ND53txvW

1CREATE TABLE IF NOT EXISTS `{$wpdb->prefix}dokan_delivery_time` (
2                  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
3                  `order_id` int(11) NOT NULL,
4                  `vendor_id` int(11) NOT NULL,
5                  `date` varchar(25) NOT NULL DEFAULT '',
6                  `slot` varchar(25) NOT NULL DEFAULT '',
7                  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
8                  PRIMARY KEY (`id`),
9                  KEY `key_vendor_id_date` (`vendor_id`,`date`),
10                  KEY `key_slot` (`slot`)
11                ) ENGINE=InnoDB {$collate}
12
13CREATE TABLE IF NOT EXISTS `{$wpdb->prefix}dokan_delivery_time` (
14                  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
15                  `order_id` int(11) NOT NULL,
16                  `vendor_id` int(11) NOT NULL,
17                  `date` varchar(25) NOT NULL DEFAULT '',
18                  `slot` varchar(25) DEFAULT '',
19                  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
20                  `type` varchar(25) DEFAULT 'delivery',
21                  PRIMARY KEY (`id`),
22                  KEY `key_vendor_id_date` (`vendor_id`,`date`),
23                  KEY `key_slot` (`slot`)
24                ) ENGINE=InnoDB {$collate}