· 8 years ago · Jul 02, 2018, 12:48 PM
1CREATE TABLE IF NOT EXISTS `wp_woocommerce_downloadable_product_permissions` (
2`permission_id` bigint(20) unsigned NOT NULL,
3 `download_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL,
4 `product_id` bigint(20) unsigned NOT NULL,
5 `order_id` bigint(20) unsigned NOT NULL DEFAULT '0',
6 `order_key` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
7 `user_email` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
8 `user_id` bigint(20) unsigned DEFAULT NULL,
9 `downloads_remaining` varchar(9) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
10 `access_granted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
11 `access_expires` datetime DEFAULT NULL,
12 `download_count` bigint(20) unsigned NOT NULL DEFAULT '0'
13) ENGINE=InnoDB AUTO_INCREMENT=860 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
14
15--
16-- Contenu de la table `wp_woocommerce_downloadable_product_permissions`
17--
18
19INSERT INTO `wp_woocommerce_downloadable_product_permissions` (`permission_id`, `download_id`, `product_id`, `order_id`, `order_key`, `user_email`, `user_id`, `downloads_remaining`, `access_granted`, `access_expires`, `download_count`) VALUES
20(1, '561fd9eea1ba0ec666120a1496ae4944', 70, 128, 'wc_order_5a625b77c5b0a', 'dddd@gmail.com', 5, '', '2018-01-19 00:00:00', NULL, 4),
21(2, '2c7b89bac8ce3e76af31888b7ff6844e', 67, 128, 'wc_order_5a625b77c5b0a', 'dddd@gmail.com', 5, '', '2018-01-19 00:00:00', NULL, 3),
22(3, 'f6364d5c32a1c00f5e2003cd392e33ce', 68, 128, 'wc_order_5a625b77c5b0a', 'dddd@gmail.com', 5, '', '2018-01-19 00:00:00', NULL, 3),
23(4, 'cf8f58927b855efc7dbc3b75d890b527', 74, 128, 'wc_order_5a625b77c5b0a', 'dddd@gmail.com', 5, '', '2018-01-19 00:00:00', NULL, 3),
24(5, 'db6a38503b698aebdc222de47b3303f6', 69, 128, 'wc_order_5a625b77c5b0a', 'dddd@gmail.com', 5, '', '2018-01-19 00:00:00', NULL, 5)