Advertisement
Guest User

Untitled

a guest
Jul 2nd, 2018
265
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.77 KB | None | 0 0
  1. CREATE 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.  
  19. 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
  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)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement