1#@!#!123s

: / home / stickain / davidsteele.com / wp-content / plugins / alidswoo / core /
Filename : sql.php
back
<?php
/**
 * Author: Vitaly Kukin
 * Date: 12.10.2016
 * Time: 9:49
 */

function adsw_sql_list(){

	global $wpdb;

	$charset_collate = $wpdb->get_charset_collate();

	return [

      	"CREATE TABLE IF NOT EXISTS {$wpdb->prefix}adsw_ali_meta (
                  `id` BIGINT(20) unsigned NOT NULL AUTO_INCREMENT,
                  `post_id` BIGINT(20) unsigned NOT NULL,
                  `product_id` VARCHAR(20) DEFAULT NULL,
                  `origPrice` DECIMAL(10,2) DEFAULT '0.00',
                  `origPriceMax` DECIMAL(10,2) DEFAULT '0.00',
                  `origSalePrice` DECIMAL(10,2) DEFAULT '0.00',
                  `origSalePriceMax` DECIMAL(10,2) DEFAULT '0.00',
                  `productUrl` VARCHAR(255) DEFAULT NULL,
                  `feedbackUrl` VARCHAR(255) DEFAULT NULL,
                  `storeUrl` VARCHAR(255) DEFAULT NULL,
                  `storeName` VARCHAR(255) DEFAULT NULL,
                  `storeRate` VARCHAR(255) DEFAULT NULL,
                  `adminDescription` TEXT DEFAULT NULL,
                  `skuOriginaAttr` LONGTEXT DEFAULT NULL,
                  `skuOriginal` LONGTEXT DEFAULT NULL,
                  `currencyCode` CHAR(4) DEFAULT 'USD',
                  `needUpdate` TINYINT(1) DEFAULT 1,
                  PRIMARY KEY (`id`),
                  KEY (`post_id`),
                  KEY (`product_id`)
            ) {$charset_collate};",

        "CREATE TABLE IF NOT EXISTS {$wpdb->prefix}adsw_variations  (
	            `id` BIGINT(20) unsigned NOT NULL AUTO_INCREMENT,
	            `post_id` 		   BIGINT(20) UNSIGNED NOT NULL,
	            `product_id` 	   VARCHAR(20) DEFAULT NULL,
	            `productUrl` 	   VARCHAR(255) DEFAULT NULL,
	            `storeUrl` 		   VARCHAR(255) DEFAULT NULL,
	            `storeName` 	   VARCHAR(255) DEFAULT NULL,
	            `storeRate` 	   VARCHAR(255) DEFAULT NULL,
	            `currencyCode` 	   CHAR(4) DEFAULT 'USD',
	            `skuOriginaAttr`   LONGTEXT DEFAULT NULL,
	            `skuOriginal` 	   LONGTEXT DEFAULT NULL,

	            PRIMARY KEY (`id`),
	            KEY (`post_id`),
	            KEY (`product_id`)
		    ) {$charset_collate};",

      	"CREATE TABLE IF NOT EXISTS `{$wpdb->prefix}adsw_activities` (
                  `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
                  `post_id` BIGINT(20) unsigned NOT NULL,
                  `product_data` TEXT DEFAULT NULL,
                  `type` VARCHAR(20) DEFAULT NULL,
                  `date` DATETIME DEFAULT '0000-00-00 00:00:00',
                  `anonce` VARCHAR(255) DEFAULT NULL,
                  `trouble` VARCHAR(40) DEFAULT NULL,
                  `status` VARCHAR(20) DEFAULT NULL,
                  PRIMARY KEY (`id`)
            ) {$charset_collate};",

        "CREATE TABLE IF NOT EXISTS `{$wpdb->prefix}adsw_search_analytics` (
            `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
            `search` VARCHAR(255) NOT NULL,
            `q` INT(10) DEFAULT 0,
            `date` DATETIME DEFAULT CURRENT_TIMESTAMP,
            PRIMARY KEY (`id`),
            KEY(`search`)
        ) {$charset_collate};",

        "CREATE TABLE IF NOT EXISTS `{$wpdb->prefix}adsw_task_upload_images` (	            
	            `post_id` BIGINT(20) UNSIGNED NOT NULL,
	            `product_id` VARCHAR(20) NOT NULL,
	            `images` TEXT DEFAULT NULL,
	            `count` SMALLINT(5) UNSIGNED DEFAULT NULL,	            
	            PRIMARY KEY (`post_id`),
	            KEY (`product_id`)
		    ) {$charset_collate};",

        "CREATE TABLE IF NOT EXISTS `{$wpdb->prefix}adsw_comments_hash` (
	          `id` 	 	   BIGINT(20) NOT NULL AUTO_INCREMENT,
              `comment_ID` 	   INT(10) DEFAULT 0,
              `comment_post_ID` 	   INT(10) DEFAULT 0,
              `comment_date` 	   DATETIME DEFAULT NULL,
              `comment_author` 	   TINYTEXT NOT NULL,
              PRIMARY KEY (`id`),
              KEY (`comment_ID`)
            ) {$charset_collate};",
    ];
}