Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS `wp_woocommerce_downloadable_product_permissions` (
- `permission_id` bigint(20) unsigned NOT NULL,
- `download_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL,
- `product_id` bigint(20) unsigned NOT NULL,
- `order_id` bigint(20) unsigned NOT NULL DEFAULT '0',
- `order_key` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
- `user_email` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
- `user_id` bigint(20) unsigned DEFAULT NULL,
- `downloads_remaining` varchar(9) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
- `access_granted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `access_expires` datetime DEFAULT NULL,
- `download_count` bigint(20) unsigned NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB AUTO_INCREMENT=860 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
- --
- -- Contenu de la table `wp_woocommerce_downloadable_product_permissions`
- --
- INSERT 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
- (1, '561fd9eea1ba0ec666120a1496ae4944', 70, 128, 'wc_order_5a625b77c5b0a', 'dddd@gmail.com', 5, '', '2018-01-19 00:00:00', NULL, 4),
- (2, '2c7b89bac8ce3e76af31888b7ff6844e', 67, 128, 'wc_order_5a625b77c5b0a', 'dddd@gmail.com', 5, '', '2018-01-19 00:00:00', NULL, 3),
- (3, 'f6364d5c32a1c00f5e2003cd392e33ce', 68, 128, 'wc_order_5a625b77c5b0a', 'dddd@gmail.com', 5, '', '2018-01-19 00:00:00', NULL, 3),
- (4, 'cf8f58927b855efc7dbc3b75d890b527', 74, 128, 'wc_order_5a625b77c5b0a', 'dddd@gmail.com', 5, '', '2018-01-19 00:00:00', NULL, 3),
- (5, 'db6a38503b698aebdc222de47b3303f6', 69, 128, 'wc_order_5a625b77c5b0a', 'dddd@gmail.com', 5, '', '2018-01-19 00:00:00', NULL, 5)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement