GNKCrA9a

1# --------------------------------------------------------
2# Table: `gctkkcyx_wc_download_log`
3# --------------------------------------------------------
4
5
6#
7# Delete any existing table `gctkkcyx_wc_download_log`
8#
9
10    DROP TABLE IF EXISTS `gctkkcyx_wc_download_log`;
11
12
13#
14# Table structure of table `gctkkcyx_wc_download_log`
15#
16
17    CREATE TABLE `gctkkcyx_wc_download_log` (
18      `download_log_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
19      `timestamp` datetime NOT NULL,
20      `permission_id` bigint(20) unsigned NOT NULL,
21      `user_id` bigint(20) unsigned DEFAULT NULL,
22      `user_ip_address` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT '',
23      PRIMARY KEY (`download_log_id`),
24      KEY `permission_id` (`permission_id`),
25      KEY `timestamp` (`timestamp`),
26      CONSTRAINT `fk_gctkkcyx_wc_download_log_permission_id` FOREIGN KEY (`permission_id`) REFERENCES `gctkkcyx_woocommerce_downloadable_product_permissions` (`permission_id`) ON DELETE CASCADE
27    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci ;
28
29#
30# Data contents of table `gctkkcyx_wc_download_log`
31#
32
33#
34# End of data contents of table `gctkkcyx_wc_download_log`
35# --------------------------------------------------------
36
37
38
39y este es el otro:
40
41
42# --------------------------------------------------------
43# Table: `gctkkcyx_woocommerce_downloadable_product_permissions`
44# --------------------------------------------------------
45
46
47#
48# Delete any existing table `gctkkcyx_woocommerce_downloadable_product_permissions`
49#
50
51    DROP TABLE IF EXISTS `gctkkcyx_woocommerce_downloadable_product_permissions`;
52
53
54#
55# Table structure of table `gctkkcyx_woocommerce_downloadable_product_permissions`
56#
57
58    CREATE TABLE `gctkkcyx_woocommerce_downloadable_product_permissions` (
59      `permission_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
60      `download_id` varchar(36) COLLATE utf8mb4_unicode_520_ci NOT NULL,
61      `product_id` bigint(20) unsigned NOT NULL,
62      `order_id` bigint(20) unsigned NOT NULL DEFAULT '0',
63      `order_key` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
64      `user_email` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
65      `user_id` bigint(20) unsigned DEFAULT NULL,
66      `downloads_remaining` varchar(9) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
67      `access_granted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
68      `access_expires` datetime DEFAULT NULL,
69      `download_count` bigint(20) unsigned NOT NULL DEFAULT '0',
70      PRIMARY KEY (`permission_id`),
71      KEY `download_order_key_product` (`product_id`,`order_id`,`order_key`(16),`download_id`),
72      KEY `download_order_product` (`download_id`,`order_id`,`product_id`),
73      KEY `order_id` (`order_id`),
74      KEY `user_order_remaining_expires` (`user_id`,`order_id`,`downloads_remaining`,`access_expires`)
75    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci ;
76
77#
78# Data contents of table `gctkkcyx_woocommerce_downloadable_product_permissions`
79#
80
81#
82# End of data contents of table `gctkkcyx_woocommerce_downloadable_product_permissions`
83# --------------------------------------------------------