API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 26th, 2020
164
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 29.58 KB | None | 0 0
raw download clone embed print report
  1. -- Adminer 4.3.1 MySQL dump
  2.  
  3. SET NAMES utf8;
  4. SET time_zone = '+00:00';
  5. SET foreign_key_checks = 0;
  6. SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
  7.  
  8. SET NAMES utf8mb4;
  9.  
  10. DROP TABLE IF EXISTS `analytics`;
  11. CREATE TABLE `analytics` (
  12. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  13. `user_id` int(10) unsigned NOT NULL,
  14. `action_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  15. `identifier` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  16. `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  17. `created_at` timestamp NULL DEFAULT NULL,
  18. `updated_at` timestamp NULL DEFAULT NULL,
  19. PRIMARY KEY (`id`),
  20. KEY `analytics_user_id_foreign` (`user_id`),
  21. CONSTRAINT `analytics_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
  22. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  23.  
  24.  
  25. DROP TABLE IF EXISTS `avatars`;
  26. CREATE TABLE `avatars` (
  27. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  28. `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  29. `description` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  30. `role` int(11) DEFAULT NULL,
  31. `required_published_reports` int(11) NOT NULL,
  32. `icon_male` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  33. `icon_female` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  34. `active` tinyint(1) NOT NULL,
  35. `created_at` timestamp NULL DEFAULT NULL,
  36. `updated_at` timestamp NULL DEFAULT NULL,
  37. `deleted_at` timestamp NULL DEFAULT NULL,
  38. PRIMARY KEY (`id`)
  39. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  40.  
  41.  
  42. INSERT INTO `easy2b_payments` (`id`, `identifier`, `transaction_id`, `type`, `status`, `entity`, `reference`, `url`, `IBAN`, `descriptive`, `customer_id`, `campaign_id`, `value`, `additional_info`, `evaluated_by`, `date`, `created_at`, `updated_at`, `deleted_at`) VALUES
  43. (1, 'E2B-T14V-BJXV6', '8a5f46a7-7a7f-4fc7-a4a7-063b035d9873', 'mb', 'pending', '11683', '831002618', NULL, NULL, NULL, '2ec63f0a-b5c2-43b6-8189-bcee61b75079', 209, 42, NULL, NULL, '2019-10-01 16:59:34', '2019-10-01 17:59:34', '2019-10-01 17:59:34', NULL),
  44. (2, 'E2B-KU0J-N09M2', 'bb20b8df-4d80-472d-9609-fbe3dcf2f525', 'cc', 'pending', NULL, NULL, 'https://cc.test.easypay.pt/start/bb20b8df-4d80-472d-9609-fbe3dcf2f525', NULL, NULL, '89be7a2f-a359-4d41-8345-9c4c66774428', 210, 70, NULL, NULL, '2019-10-01 17:00:13', '2019-10-01 18:00:13', '2019-10-01 18:00:13', NULL),
  45. (3, 'E2B-QN54-GNTL3', NULL, 'wt', 'paid', 'ENTIDADE', NULL, NULL, NULL, 'MFTTJC', NULL, 211, 70, NULL, NULL, '2019-10-01 17:00:26', '2019-10-01 18:00:26', '2019-10-02 16:08:50', NULL),
  46. (4, 'E2B-GJJL-DOVX9', NULL, 'wt', 'paid', 'ENTIDADE', NULL, NULL, NULL, 'NPQCUX', NULL, 212, 70, NULL, NULL, '2019-10-02 09:13:56', '2019-10-02 10:13:56', '2019-10-02 16:06:30', NULL),
  47. (5, 'E2B-VXDC-LJUK8', NULL, 'wt', 'paid', NULL, NULL, NULL, 'PT500000000000000000', 'TFM4DG', NULL, 213, 70, NULL, NULL, '2019-10-02 09:22:19', '2019-10-02 10:22:19', '2019-10-02 15:03:59', NULL),
  48. (6, 'E2B-QRTT-ITK55', NULL, 'wt', 'paid', NULL, NULL, NULL, 'PT500000000000000000', 'BAXMSA', NULL, 214, 70, NULL, NULL, '2019-10-02 09:23:32', '2019-10-02 10:23:32', '2019-10-02 15:04:25', NULL),
  49. (7, 'E2B-4MEA-MMAE7', '11010220-45ca-4bb9-b6cb-58a17c8bb1d6', 'mb', 'pending', '11683', '831002657', NULL, NULL, NULL, '8d3b429a-146a-4bef-bca3-0e7189da6f4b', 215, 70, NULL, NULL, '2019-10-02 09:23:58', '2019-10-02 10:23:58', '2019-10-02 10:23:58', NULL),
  50. (8, 'E2B-SSNK-POFN6', '262ea950-9cc1-4528-81c0-2200d572ce93', 'mb', 'pending', '11683', '831002705', NULL, NULL, NULL, 'a9f1db0a-ea45-45e4-8c09-517924ef3e9a', 216, 70, NULL, NULL, '2019-10-02 09:24:41', '2019-10-02 10:24:41', '2019-10-02 10:24:41', NULL),
  51. (9, 'E2B-4KCB-CLB79', 'd03c4a68-67b3-4cbf-9225-cb98bd97fb46', 'cc', 'pending', NULL, NULL, 'https://cc.test.easypay.pt/start/d03c4a68-67b3-4cbf-9225-cb98bd97fb46', NULL, NULL, 'dcaa74f7-c1fd-40cd-8633-4506cffe5252', 217, 70, NULL, NULL, '2019-10-02 10:09:14', '2019-10-02 11:09:14', '2019-10-02 11:09:14', NULL),
  52. (10, 'E2B-XCXA-JI4O7', NULL, 'wt', 'paid', NULL, NULL, NULL, 'PT500000000000000000', 'Y4JZC9', NULL, 219, 70, NULL, NULL, '2019-10-02 14:51:50', '2019-10-02 15:51:50', '2019-10-02 16:06:33', NULL),
  53. (11, 'E2B-RRAK-IYJI8', NULL, 'wt', 'paid', NULL, NULL, NULL, 'PT500000000000000000', 'FGIHNV', NULL, 220, 70, NULL, NULL, '2019-10-02 15:00:13', '2019-10-02 16:00:13', '2019-10-02 16:06:34', NULL),
  54. (12, 'E2B-XKJU-9XRN0', NULL, 'wt', 'paid', NULL, NULL, NULL, 'PT500000000000000000', 'JXBRPX', NULL, 221, 70, NULL, NULL, '2019-10-02 16:22:39', '2019-10-02 17:22:39', '2019-10-04 16:19:40', NULL),
  55. (13, 'E2B-CBLI-S4ZW3', 'db053632-8de6-4b4c-899d-42e5256d6176', 'cc', 'paid', NULL, NULL, 'https://cc.test.easypay.pt/start/db053632-8de6-4b4c-899d-42e5256d6176', NULL, NULL, 'b8b265ed-9cbb-4296-843b-939f48e12c60', 222, 900, NULL, NULL, '2019-10-02 16:26:12', '2019-10-02 17:26:12', '2019-10-07 11:07:33', NULL),
  56. (14, 'E2B-VSKT-FDRP5', NULL, 'wt', 'pending', NULL, NULL, NULL, 'PT500000000000000000', 'YIIAKH', NULL, 224, 700, NULL, NULL, '2019-10-03 09:23:42', '2019-10-03 10:23:42', '2019-10-03 10:23:42', NULL),
  57. (15, 'E2B-KDSY-R1RK4', NULL, 'wt', 'pending', NULL, NULL, NULL, 'PT500000000000000000', 'BT7H70', NULL, 232, 70, NULL, NULL, '2019-10-04 10:52:02', '2019-10-04 11:52:02', '2019-10-04 11:52:02', NULL),
  58. (16, 'E2B-GFTZ-4KHH0', NULL, 'wt', 'pending', NULL, NULL, NULL, 'PT500000000000000000', 'NDFCGQ', NULL, 233, 70, NULL, NULL, '2019-10-04 10:54:54', '2019-10-04 11:54:54', '2019-10-04 11:54:54', NULL),
  59. (17, 'E2B-XQVO-5JJV5', NULL, 'wt', 'pending', NULL, NULL, NULL, 'PT500000000000000000', 'FWBTAQ', NULL, 234, 9000, NULL, NULL, '2019-10-04 11:10:42', '2019-10-04 12:10:42', '2019-10-04 12:10:42', NULL),
  60. (18, 'E2B-TPHW-ROS64', NULL, 'wt', 'paid', NULL, NULL, NULL, 'PT500000000000000000', '9M6TNE', NULL, 235, 7, NULL, NULL, '2019-10-04 15:58:33', '2019-10-04 16:58:33', '2019-10-07 10:34:16', NULL),
  61. (19, 'E2B-FINQ-DZPP6', NULL, 'wt', 'pending', NULL, NULL, NULL, 'PT500000000000000000', 'S0STUY', NULL, 236, 70, NULL, NULL, '2019-10-07 11:25:16', '2019-10-07 12:25:16', '2019-10-07 12:25:16', NULL),
  62. (20, 'E2B-ZXWS-T5MY3', '85cd71e5-8432-4a6a-b153-c6b5747d591a', 'mb', 'pending', '11683', '831003453', NULL, NULL, NULL, 'd3765585-d148-482d-9842-7bdb9eb91c88', 237, 70, NULL, NULL, '2019-10-07 13:56:34', '2019-10-07 14:56:34', '2019-10-07 14:56:34', NULL),
  63. (21, 'E2B-AJ8K-1QAR4', '08fbb6d0-b1ef-4cbb-a92f-f88c4f621999', 'mb', 'pending', '11683', '831003501', NULL, NULL, NULL, '0a82bee9-ad0c-48a1-bbf9-64a2ebf56d77', 238, 70, NULL, NULL, '2019-10-07 13:57:51', '2019-10-07 14:57:51', '2019-10-07 14:57:51', NULL),
  64. (22, 'E2B-BT8D-WYR20', NULL, 'wt', 'pending', NULL, NULL, NULL, 'PT500000000000000000', 'HY4TO8', NULL, 239, 9000, NULL, NULL, '2019-10-08 08:50:21', '2019-10-08 09:50:21', '2019-10-08 09:50:21', NULL),
  65. (23, 'E2B-B5G8-3V5Y5', NULL, 'wt', 'pending', NULL, NULL, NULL, 'PT500000000000000000', 'LRPNUF', NULL, 240, 7, NULL, NULL, '2019-10-08 09:18:03', '2019-10-08 10:18:03', '2019-10-08 10:18:03', NULL),
  66. (24, 'E2B-SOZD-RHTB3', NULL, 'wt', 'pending', NULL, NULL, NULL, 'PT500000000000000000', 'PEAA7Q', NULL, 241, 70, NULL, NULL, '2019-10-08 10:20:11', '2019-10-08 11:20:11', '2019-10-08 11:20:11', NULL),
  67. (25, 'E2B-YAAF-D4TK0', '4568c8dc-23cb-479b-aae9-acf4ef71210e', 'mb', 'pending', '11683', '831002392', NULL, NULL, NULL, 'a2f04837-49f1-4470-8e03-b5f9bb897b0f', 242, 7, NULL, NULL, '2019-10-08 10:26:22', '2019-10-08 11:26:22', '2019-10-08 11:26:22', NULL),
  68. (26, 'E2B-9ZJZ-KDDF9', '8af86850-312a-4b77-8a78-5eb92b3c8836', 'mb', 'pending', '11683', '831003652', NULL, NULL, NULL, '809200a1-27ca-4afc-9f31-2f0f0be86566', 243, 70, NULL, NULL, '2019-10-08 10:27:12', '2019-10-08 11:27:12', '2019-10-08 11:27:12', NULL),
  69. (27, 'E2B-NA0Q-HVDC6', NULL, 'wt', 'pending', NULL, NULL, NULL, 'PT500000000000000000', '9WMOFO', NULL, 244, 70, NULL, NULL, '2019-10-08 10:29:40', '2019-10-08 11:29:40', '2019-10-08 11:29:40', NULL),
  70. (28, 'E2B-VQF6-YNFI2', '3b2ded2c-cf13-47c9-bef1-b34ea3c83e71', 'mb', 'pending', '11683', '831003700', NULL, NULL, NULL, '12367cae-d855-417a-8924-497f339ae912', 245, 70, NULL, NULL, '2019-10-08 10:49:56', '2019-10-08 11:49:56', '2019-10-08 11:49:56', NULL),
  71. (29, 'E2B-98U1-PPZM0', 'fc5a7b71-d43c-4023-a6b9-ba8b4a948208', 'mb', 'pending', '11683', '831003851', NULL, NULL, NULL, '79ed2a2e-d063-46ec-a797-a9139bbfa9ed', 246, 70, NULL, NULL, '2019-10-08 11:18:11', '2019-10-08 12:18:11', '2019-10-08 12:18:11', NULL),
  72. (30, 'E2B-0MLK-UX2F8', '3780426f-676a-4110-b07a-eccbcec5babf', 'mb', 'pending', '11683', '831002273', NULL, NULL, NULL, '06e76455-4322-4770-b84a-4100b834ab50', 247, 3000, NULL, NULL, '2019-10-08 13:54:34', '2019-10-08 14:54:34', '2019-10-08 14:54:34', NULL),
  73. (31, 'E2B-WRKC-BEN67', NULL, 'wt', 'pending', NULL, NULL, NULL, 'PT500000000000000000', 'ZZCC26', NULL, 248, 70, NULL, NULL, '2019-10-08 14:23:35', '2019-10-08 15:23:35', '2019-10-08 15:23:35', NULL),
  74. (32, 'E2B-HBXJ-4BQP8', NULL, 'wt', 'pending', NULL, NULL, NULL, 'PT500000000000000000', 'EFTBTN', NULL, 250, 70, NULL, NULL, '2019-10-08 16:00:42', '2019-10-08 17:00:42', '2019-10-08 17:00:42', NULL),
  75. (33, 'E2B-DLPS-EWBI0', NULL, 'wt', 'pending', NULL, NULL, NULL, 'PT500000000000000000', 'FPF2XZ', NULL, 251, 70, NULL, NULL, '2019-10-08 16:49:36', '2019-10-08 17:49:36', '2019-10-08 17:49:36', NULL),
  76. (34, 'E2B-PW3M-NVVJ4', NULL, 'wt', 'pending', NULL, NULL, NULL, 'PT500000000000000000', 'BMQVYO', NULL, 252, 230, NULL, NULL, '2019-10-08 17:00:46', '2019-10-08 18:00:46', '2019-10-08 18:00:46', NULL),
  77. (35, 'E2B-EBAR-YT892', NULL, 'wt', 'pending', NULL, NULL, NULL, 'PT500000000000000000', 'IBCOFA', NULL, 255, 70, NULL, NULL, '2019-10-10 09:37:08', '2019-10-10 10:37:08', '2019-10-10 10:37:08', NULL),
  78. (36, 'E2B-RIXY-MGOG8', NULL, 'wt', 'pending', NULL, NULL, NULL, 'PT500000000000000000', 'MAA1FT', NULL, 256, 70, NULL, NULL, '2019-10-10 09:39:33', '2019-10-10 10:39:33', '2019-10-10 10:39:33', NULL),
  79. (37, 'E2B-QSLT-MA4J0', NULL, 'wt', 'pending', NULL, NULL, NULL, 'PT500000000000000000', '6KIHJ1', NULL, 258, 70, NULL, NULL, '2019-10-10 09:59:43', '2019-10-10 10:59:43', '2019-10-10 10:59:43', NULL),
  80. (38, 'E2B-ZJGP-NCOZ8', NULL, 'wt', 'pending', NULL, NULL, NULL, 'PT500000000000000000', 'Z8JIMC', NULL, 259, 70, NULL, NULL, '2019-10-10 10:01:38', '2019-10-10 11:01:38', '2019-10-10 11:01:38', NULL),
  81. (39, 'E2B-F9WS-HOAJ9', NULL, 'wt', 'pending', NULL, NULL, NULL, 'PT500000000000000000', 'QEVZID', NULL, 260, 70, NULL, NULL, '2019-10-10 10:02:20', '2019-10-10 11:02:20', '2019-10-10 11:02:20', NULL),
  82. (40, 'E2B-CMGL-RPZO2', NULL, 'wt', 'pending', NULL, NULL, NULL, 'PT500000000000000000', 'VIHW4R', NULL, 261, 70, NULL, NULL, '2019-10-10 10:11:53', '2019-10-10 11:11:53', '2019-10-10 11:11:53', NULL),
  83. (41, 'E2B-HOFM-DCL11', NULL, 'wt', 'paid', NULL, NULL, NULL, 'PT500000000000000000', 'S50R8V', NULL, 262, 150, NULL, NULL, '2019-10-10 13:24:45', '2019-10-10 14:24:45', '2019-10-15 17:25:11', NULL),
  84. (42, 'E2B-X7YU-HVCV1', NULL, 'wt', 'paid', NULL, NULL, NULL, 'PT500000000000000000', 'GT8PAC', NULL, 263, 100, NULL, NULL, '2019-10-11 08:47:57', '2019-10-11 09:47:57', '2019-10-15 17:21:19', NULL),
  85. (43, 'E2B-F6GI-MGHG7', '6421f968-39ad-4fd9-9eac-ff99580e6c61', 'mb', 'pending', '11683', '831006438', NULL, NULL, NULL, '7340d0a0-c319-4599-a1cf-56701ea1ed7a', 266, 70, NULL, NULL, '2019-10-15 11:32:39', '2019-10-15 12:32:39', '2019-10-15 12:32:39', NULL),
  86. (44, 'E2B-RZXQ-VFGC5', 'db5a1cc2-af56-4e5e-bc38-8da149e5923c', 'mb', 'pending', '11683', '831006586', NULL, NULL, NULL, '6559104f-a769-4302-b21b-4a1657ac211a', 271, 70, NULL, NULL, '2019-10-15 13:28:48', '2019-10-15 14:28:48', '2019-10-15 14:28:48', NULL),
  87. (45, 'E2B-ZKWK-GZAT1', 'c3feb653-0849-4571-9e9b-1b413333da06', 'mb', 'pending', '11683', '831006637', NULL, NULL, NULL, '673bda5a-f79b-48ee-b118-00161bb99935', 272, 70, NULL, NULL, '2019-10-15 13:48:35', '2019-10-15 14:48:35', '2019-10-15 14:48:35', NULL),
  88. (46, 'E2B-5P3K-TYTI2', '9bae8554-7a4f-4870-98d7-15f9b308b290', 'mb', 'pending', '11683', '831006785', NULL, NULL, NULL, '7a3b2ba8-6f84-4a6e-adbb-310eb35ad52c', 273, 70, NULL, NULL, '2019-10-15 14:10:36', '2019-10-15 15:10:36', '2019-10-15 15:10:36', NULL),
  89. (47, 'E2B-1EAM-BJEK9', 'df5256ee-3977-43d6-ab74-75867626d7eb', 'mb', 'pending', '11683', '831006836', NULL, NULL, NULL, '021f2fa0-814a-44bb-b599-fe0e6a569e95', 274, 70, NULL, NULL, '2019-10-15 14:19:27', '2019-10-15 15:19:27', '2019-10-15 15:19:27', NULL),
  90. (48, 'E2B-EKIL-AIGB1', 'dfd50fbd-2358-4d15-8664-fac849fd14f9', 'mb', 'pending', '11683', '831006984', NULL, NULL, NULL, '8fefd606-8000-4b6f-8912-7d9fd3069187', 277, 70, NULL, NULL, '2019-10-15 14:27:03', '2019-10-15 15:27:03', '2019-10-15 15:27:03', NULL),
  91. (49, 'E2B-HOSI-MHKU6', '01e4c03e-3a9b-4ec2-a067-082bff3df7e4', 'mb', 'pending', '11683', '831007035', NULL, NULL, NULL, 'a004e450-8527-45de-96cd-4e5ab209f91c', 284, 70, NULL, NULL, '2019-10-15 14:45:58', '2019-10-15 15:45:58', '2019-10-15 15:45:58', NULL),
  92. (50, 'E2B-GD8G-N6620', 'c0341fe5-aff5-4eee-98a9-504a91df6363', 'mb', 'pending', '11683', '831007183', NULL, NULL, NULL, 'f7a9982e-c352-40a5-a9fb-f5be077ad6cb', 286, 70, NULL, NULL, '2019-10-15 16:34:22', '2019-10-15 17:34:22', '2019-10-15 17:34:22', NULL),
  93. (51, 'E2B-A4FL-5LEH1', NULL, 'wt', 'pending', NULL, NULL, NULL, 'PT500000000000000000', 'ITBALH', NULL, 287, 70, NULL, NULL, '2019-10-16 09:56:33', '2019-10-16 10:56:33', '2019-10-16 10:56:33', NULL),
  94. (52, 'E2B-8HAY-MMOM5', 'c4236fbb-463b-4300-b650-4c068fab9e87', 'mb', 'pending', '11683', '831007234', NULL, NULL, NULL, '4726ac09-6a9d-4a68-957f-441c365a1dcb', 288, 70, NULL, NULL, '2019-10-16 10:06:34', '2019-10-16 11:06:34', '2019-10-16 11:06:34', NULL),
  95. (53, 'E2B-SHRU-DXNJ5', 'f4470d41-6124-4b80-8596-337de1677ef7', 'mb', 'pending', '11683', '831007382', NULL, NULL, NULL, '50711800-a707-4565-a65d-12679e8898c5', 289, 70, NULL, NULL, '2019-10-16 10:15:41', '2019-10-16 11:15:41', '2019-10-16 11:15:41', NULL),
  96. (54, 'E2B-6LDM-PLNN7', '46d6d4c0-f317-45d9-be7d-f9456f3a26d9', 'mb', 'pending', '11683', '831007433', NULL, NULL, NULL, 'f32ed30e-4156-4f5f-bbf3-38e86ea2f9b3', 290, 70, NULL, NULL, '2019-10-16 10:19:44', '2019-10-16 11:19:44', '2019-10-16 11:19:44', NULL),
  97. (55, 'E2B-WHVH-DKAS8', '58a7b01d-7876-431b-b0e2-03e371ff5f2b', 'mb', 'pending', '11683', '831007581', NULL, NULL, NULL, '32297bd0-5c79-40c1-887a-7dba93453f18', 291, 70, NULL, NULL, '2019-10-16 10:25:35', '2019-10-16 11:25:35', '2019-10-16 11:25:35', NULL),
  98. (56, 'E2B-MLF5-EDMR3', '56cb35cb-df8f-41e2-8a1c-8de39c8b0c4b', 'cc', 'pending', NULL, NULL, 'https://cc.test.easypay.pt/start/56cb35cb-df8f-41e2-8a1c-8de39c8b0c4b', NULL, NULL, '41bf6eb8-3a02-4dcf-95fd-3000423a0919', 292, 70, NULL, NULL, '2019-10-16 10:26:43', '2019-10-16 11:26:43', '2019-10-16 11:26:43', NULL),
  99. (57, 'E2B-6V7G-FDKK3', 'ef5b9566-188b-4e0e-8bdf-26544fd45f59', 'mb', 'pending', '11683', '831007632', NULL, NULL, NULL, '6631adf0-6973-4d30-9367-dfa37dc3bec8', 296, 70, NULL, NULL, '2019-10-16 10:45:04', '2019-10-16 11:45:04', '2019-10-16 11:45:04', NULL),
  100. (58, 'E2B-VFMK-XMVU8', '534fb354-7565-44da-9872-6a2eba674e9e', 'mb', 'pending', '11683', '831007780', NULL, NULL, NULL, '23dc42fa-7a33-402d-ad59-8dd4401a0391', 297, 70, NULL, NULL, '2019-10-16 10:56:01', '2019-10-16 11:56:01', '2019-10-16 11:56:01', NULL),
  101. (59, 'E2B-LZF6-BHTL0', '434215a7-6157-437c-9fa0-f6ee414cba81', 'mb', 'pending', '11683', '831007831', NULL, NULL, NULL, 'fac2ee33-068d-4e2d-9ca7-e5d5e82d5261', 284, 70, NULL, NULL, '2019-10-16 11:26:07', '2019-10-16 12:26:07', '2019-10-16 12:26:07', NULL),
  102. (60, 'E2B-6YQG-VCAQ3', '7f2ec4aa-5c43-4ad9-8ea1-183bdc3e24ba', 'mb', 'pending', '11683', '831007979', NULL, NULL, NULL, 'c7228331-7026-42b6-9559-cca82e7e6ae1', 298, 70, NULL, NULL, '2019-10-16 11:30:20', '2019-10-16 12:30:20', '2019-10-16 12:30:20', NULL),
  103. (61, 'E2B-ZRTM-OA5B4', '5412bee9-4a64-425b-bd7f-7697c3373c2a', 'mb', 'pending', '11683', '831008974', NULL, NULL, NULL, 'a35ac8d5-47f1-4611-b894-e01040ac736f', 302, 70, NULL, NULL, '2019-10-17 09:06:52', '2019-10-17 10:06:52', '2019-10-17 10:06:52', NULL),
  104. (62, 'E2B-TYZC-UAFX1', 'af6a823c-0c56-4709-a869-ecb5a0bb455d', 'mb', 'pending', '11683', '831009025', NULL, NULL, NULL, '913e3853-431a-4def-9803-680abc6056c4', 303, 70, NULL, NULL, '2019-10-17 09:20:22', '2019-10-17 10:20:22', '2019-10-17 10:20:22', NULL),
  105. (63, 'E2B-CAGV-GUXU4', 'af82f449-4163-4c90-a1d2-51ba438549dd', 'mb', 'pending', '11683', '831009173', NULL, NULL, NULL, '119dd565-3c94-4eb3-9991-bbbe8be7ade7', 307, 70, NULL, NULL, '2019-10-17 09:38:51', '2019-10-17 10:38:51', '2019-10-17 10:38:51', NULL),
  106. (64, 'E2B-QBBS-BMKE6', '8e44bdd8-2962-4009-8fd0-37c22064cd95', 'mb', 'pending', '11683', '831009224', NULL, NULL, NULL, '56cfb2ed-9cb9-460e-93e2-bacadcf8eab7', 308, 70, NULL, NULL, '2019-10-17 09:42:39', '2019-10-17 10:42:39', '2019-10-17 10:42:39', NULL),
  107. (65, 'E2B-6GTF-JVJP9', '87af1b90-9e85-46d6-8bd9-f8360c0698c7', 'mb', 'pending', '11683', '831009372', NULL, NULL, NULL, 'e53dfacd-bc99-41b1-978f-0593f1bb0f22', 309, 70, NULL, NULL, '2019-10-17 09:44:02', '2019-10-17 10:44:02', '2019-10-17 10:44:02', NULL);
  108.  
  109. DROP TABLE IF EXISTS `easy2b_settings`;
  110. CREATE TABLE `easy2b_settings` (
  111. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  112. `key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  113. `value` text COLLATE utf8mb4_unicode_ci NOT NULL,
  114. `created_at` timestamp NULL DEFAULT NULL,
  115. `updated_at` timestamp NULL DEFAULT NULL,
  116. `deleted_at` timestamp NULL DEFAULT NULL,
  117. PRIMARY KEY (`id`)
  118. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  119.  
  120.  
  121. DROP TABLE IF EXISTS `settings`;
  122. CREATE TABLE `settings` (
  123. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  124. `key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  125. `value` text COLLATE utf8mb4_unicode_ci NOT NULL,
  126. `created_at` timestamp NULL DEFAULT NULL,
  127. `updated_at` timestamp NULL DEFAULT NULL,
  128. `deleted_at` timestamp NULL DEFAULT NULL,
  129. PRIMARY KEY (`id`)
  130. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  131.  
  132.  
  133. DROP TABLE IF EXISTS `users`;
  134. CREATE TABLE `users` (
  135. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  136. `login_type` int(11) NOT NULL DEFAULT '0',
  137. `social_id` text COLLATE utf8mb4_unicode_ci,
  138. `role` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  139. `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  140. `password` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  141. `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  142. `display_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  143. `profile_photo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  144. `location` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  145. `origin` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  146. `gender` int(11) NOT NULL DEFAULT '0',
  147. `birthday` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  148. `job` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  149. `scholarship` int(11) NOT NULL DEFAULT '0',
  150. `bio` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  151. `avatar` int(10) unsigned DEFAULT NULL,
  152. `push_token` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  153. `latitude` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  154. `longitude` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  155. `unsubscribe_email` tinyint(4) NOT NULL DEFAULT '0',
  156. `unsubscribe_email_token` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  157. `safe_str` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT '',
  158. `balance` float DEFAULT '0',
  159. `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  160. `invited_by` int(10) unsigned DEFAULT NULL,
  161. `email_confirmed` tinyint(4) DEFAULT '1',
  162. `confirm_email_code` text COLLATE utf8mb4_unicode_ci,
  163. `created_at` timestamp NULL DEFAULT NULL,
  164. `updated_at` timestamp NULL DEFAULT NULL,
  165. `deleted_at` timestamp NULL DEFAULT NULL,
  166. PRIMARY KEY (`id`),
  167. UNIQUE KEY `users_username_unique` (`username`),
  168. UNIQUE KEY `users_email_unique` (`email`),
  169. KEY `users_avatar_foreign` (`avatar`),
  170. KEY `invited_by` (`invited_by`),
  171. CONSTRAINT `users_avatar_foreign` FOREIGN KEY (`avatar`) REFERENCES `avatars` (`id`),
  172. CONSTRAINT `users_ibfk_1` FOREIGN KEY (`invited_by`) REFERENCES `users` (`id`)
  173. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  174.  
  175.  
  176. DROP TABLE IF EXISTS `users_badges`;
  177. CREATE TABLE `users_badges` (
  178. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  179. `user_id` int(10) unsigned NOT NULL,
  180. `challenge_id` int(10) unsigned NOT NULL,
  181. `reward_id` int(10) unsigned NOT NULL,
  182. `created_at` timestamp NULL DEFAULT NULL,
  183. `updated_at` timestamp NULL DEFAULT NULL,
  184. `deleted_at` timestamp NULL DEFAULT NULL,
  185. PRIMARY KEY (`id`),
  186. KEY `users_badges_user_id_foreign` (`user_id`),
  187. KEY `users_badges_challenge_id_foreign` (`challenge_id`),
  188. KEY `users_badges_reward_id_foreign` (`reward_id`),
  189. CONSTRAINT `users_badges_challenge_id_foreign` FOREIGN KEY (`challenge_id`) REFERENCES `challenges` (`id`) ON DELETE CASCADE,
  190. CONSTRAINT `users_badges_reward_id_foreign` FOREIGN KEY (`reward_id`) REFERENCES `challenges_rewards` (`id`) ON DELETE CASCADE,
  191. CONSTRAINT `users_badges_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
  192. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  193.  
  194.  
  195. DROP TABLE IF EXISTS `users_blocks`;
  196. CREATE TABLE `users_blocks` (
  197. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  198. `user_id` int(10) unsigned NOT NULL,
  199. `blocked_id` int(10) unsigned NOT NULL,
  200. `created_at` timestamp NULL DEFAULT NULL,
  201. `updated_at` timestamp NULL DEFAULT NULL,
  202. PRIMARY KEY (`id`),
  203. KEY `users_blocks_user_id_foreign` (`user_id`),
  204. KEY `users_blocks_blocked_id_foreign` (`blocked_id`),
  205. CONSTRAINT `users_blocks_blocked_id_foreign` FOREIGN KEY (`blocked_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  206. CONSTRAINT `users_blocks_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
  207. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  208.  
  209.  
  210. DROP TABLE IF EXISTS `users_challenges`;
  211. CREATE TABLE `users_challenges` (
  212. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  213. `user_id` int(10) unsigned NOT NULL,
  214. `challenge_id` int(10) unsigned NOT NULL,
  215. `created_at` timestamp NULL DEFAULT NULL,
  216. `updated_at` timestamp NULL DEFAULT NULL,
  217. `deleted_at` timestamp NULL DEFAULT NULL,
  218. PRIMARY KEY (`id`),
  219. KEY `users_challenges_user_id_foreign` (`user_id`),
  220. KEY `users_challenges_challenge_id_foreign` (`challenge_id`),
  221. CONSTRAINT `users_challenges_challenge_id_foreign` FOREIGN KEY (`challenge_id`) REFERENCES `challenges` (`id`) ON DELETE CASCADE,
  222. CONSTRAINT `users_challenges_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
  223. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  224.  
  225.  
  226. DROP TABLE IF EXISTS `users_conversations`;
  227. CREATE TABLE `users_conversations` (
  228. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  229. `user_1` int(10) unsigned NOT NULL,
  230. `user_2` int(10) unsigned NOT NULL,
  231. `created_at` timestamp NULL DEFAULT NULL,
  232. `updated_at` timestamp NULL DEFAULT NULL,
  233. `deleted_at` timestamp NULL DEFAULT NULL,
  234. PRIMARY KEY (`id`),
  235. KEY `users_conversations_user_1_foreign` (`user_1`),
  236. KEY `users_conversations_user_2_foreign` (`user_2`),
  237. CONSTRAINT `users_conversations_user_1_foreign` FOREIGN KEY (`user_1`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  238. CONSTRAINT `users_conversations_user_2_foreign` FOREIGN KEY (`user_2`) REFERENCES `users` (`id`) ON DELETE CASCADE
  239. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  240.  
  241.  
  242. DROP TABLE IF EXISTS `users_friends`;
  243. CREATE TABLE `users_friends` (
  244. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  245. `user_1` int(10) unsigned NOT NULL,
  246. `user_2` int(10) unsigned NOT NULL,
  247. `created_at` timestamp NULL DEFAULT NULL,
  248. `updated_at` timestamp NULL DEFAULT NULL,
  249. `deleted_at` timestamp NULL DEFAULT NULL,
  250. PRIMARY KEY (`id`),
  251. KEY `users_friends_user_1_foreign` (`user_1`),
  252. KEY `users_friends_user_2_foreign` (`user_2`),
  253. CONSTRAINT `users_friends_user_1_foreign` FOREIGN KEY (`user_1`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  254. CONSTRAINT `users_friends_user_2_foreign` FOREIGN KEY (`user_2`) REFERENCES `users` (`id`) ON DELETE CASCADE
  255. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  256.  
  257.  
  258. DROP TABLE IF EXISTS `users_friends_requests`;
  259. CREATE TABLE `users_friends_requests` (
  260. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  261. `from` int(10) unsigned NOT NULL,
  262. `to` int(10) unsigned NOT NULL,
  263. `created_at` timestamp NULL DEFAULT NULL,
  264. `updated_at` timestamp NULL DEFAULT NULL,
  265. `deleted_at` timestamp NULL DEFAULT NULL,
  266. PRIMARY KEY (`id`),
  267. KEY `users_friends_requests_from_foreign` (`from`),
  268. KEY `users_friends_requests_to_foreign` (`to`),
  269. CONSTRAINT `users_friends_requests_from_foreign` FOREIGN KEY (`from`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  270. CONSTRAINT `users_friends_requests_to_foreign` FOREIGN KEY (`to`) REFERENCES `users` (`id`) ON DELETE CASCADE
  271. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  272.  
  273.  
  274. DROP TABLE IF EXISTS `users_invites`;
  275. CREATE TABLE `users_invites` (
  276. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  277. `from` int(10) unsigned NOT NULL,
  278. `to` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  279. `recipient_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  280. `created_at` timestamp NULL DEFAULT NULL,
  281. `updated_at` timestamp NULL DEFAULT NULL,
  282. `deleted_at` timestamp NULL DEFAULT NULL,
  283. PRIMARY KEY (`id`),
  284. UNIQUE KEY `users_invites_to_unique` (`to`),
  285. KEY `users_invites_from_foreign` (`from`),
  286. CONSTRAINT `users_invites_from_foreign` FOREIGN KEY (`from`) REFERENCES `users` (`id`) ON DELETE CASCADE
  287. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  288.  
  289.  
  290. DROP TABLE IF EXISTS `users_invites_sent`;
  291. CREATE TABLE `users_invites_sent` (
  292. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  293. `user_id` int(10) unsigned NOT NULL,
  294. `created_at` timestamp NULL DEFAULT NULL,
  295. `updated_at` timestamp NULL DEFAULT NULL,
  296. `deleted_at` timestamp NULL DEFAULT NULL,
  297. PRIMARY KEY (`id`),
  298. KEY `users_invites_sent_user_id_foreign` (`user_id`),
  299. CONSTRAINT `users_invites_sent_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
  300. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  301.  
  302.  
  303. DROP TABLE IF EXISTS `users_password_resets`;
  304. CREATE TABLE `users_password_resets` (
  305. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  306. `user_id` int(10) unsigned NOT NULL,
  307. `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  308. `created_at` timestamp NULL DEFAULT NULL,
  309. `updated_at` timestamp NULL DEFAULT NULL,
  310. `expired_at` datetime NOT NULL,
  311. `deleted_at` timestamp NULL DEFAULT NULL,
  312. PRIMARY KEY (`id`),
  313. KEY `users_password_resets_user_id_foreign` (`user_id`),
  314. CONSTRAINT `users_password_resets_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
  315. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  316.  
  317.  
  318. DROP TABLE IF EXISTS `users_permissions`;
  319. CREATE TABLE `users_permissions` (
  320. `id` int(11) NOT NULL,
  321. `description` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  322. `reader` tinyint(1) NOT NULL,
  323. `world_reporter` tinyint(1) NOT NULL,
  324. `subscriber` tinyint(1) NOT NULL,
  325. `ambassador` tinyint(1) NOT NULL,
  326. `created_at` timestamp NULL DEFAULT NULL,
  327. `updated_at` timestamp NULL DEFAULT NULL,
  328. UNIQUE KEY `users_permissions_id_unique` (`id`)
  329. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  330.  
  331.  
  332. DROP TABLE IF EXISTS `users_points`;
  333. CREATE TABLE `users_points` (
  334. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  335. `user_id` int(10) unsigned NOT NULL,
  336. `value` int(11) NOT NULL,
  337. `report_id` int(10) unsigned DEFAULT NULL,
  338. `like_id` int(10) unsigned DEFAULT NULL,
  339. `report_award_id` int(10) unsigned DEFAULT NULL,
  340. `invited_user_id` int(10) unsigned DEFAULT NULL,
  341. `created_at` timestamp NULL DEFAULT NULL,
  342. `updated_at` timestamp NULL DEFAULT NULL,
  343. `deleted_at` timestamp NULL DEFAULT NULL,
  344. PRIMARY KEY (`id`),
  345. KEY `users_points_user_id_foreign` (`user_id`),
  346. KEY `users_points_report_id_foreign` (`report_id`),
  347. KEY `users_points_like_id_foreign` (`like_id`),
  348. KEY `users_points_report_award_id_foreign` (`report_award_id`),
  349. KEY `users_points_invited_user_id_foreign` (`invited_user_id`),
  350. CONSTRAINT `users_points_invited_user_id_foreign` FOREIGN KEY (`invited_user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  351. CONSTRAINT `users_points_like_id_foreign` FOREIGN KEY (`like_id`) REFERENCES `news_reports_likes` (`id`) ON DELETE CASCADE,
  352. CONSTRAINT `users_points_report_award_id_foreign` FOREIGN KEY (`report_award_id`) REFERENCES `news_reports` (`id`) ON DELETE CASCADE,
  353. CONSTRAINT `users_points_report_id_foreign` FOREIGN KEY (`report_id`) REFERENCES `news_reports` (`id`) ON DELETE CASCADE,
  354. CONSTRAINT `users_points_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
  355. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  356.  
  357.  
  358. DROP TABLE IF EXISTS `users_private_messages`;
  359. CREATE TABLE `users_private_messages` (
  360. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  361. `conversation_id` int(10) unsigned NOT NULL,
  362. `author` int(10) unsigned NOT NULL,
  363. `text` varchar(2048) COLLATE utf8mb4_unicode_ci NOT NULL,
  364. `state` int(11) NOT NULL,
  365. `created_at` timestamp NULL DEFAULT NULL,
  366. `updated_at` timestamp NULL DEFAULT NULL,
  367. `deleted_at` timestamp NULL DEFAULT NULL,
  368. PRIMARY KEY (`id`),
  369. KEY `users_private_messages_conversation_id_foreign` (`conversation_id`),
  370. KEY `users_private_messages_author_foreign` (`author`),
  371. CONSTRAINT `users_private_messages_author_foreign` FOREIGN KEY (`author`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  372. CONSTRAINT `users_private_messages_conversation_id_foreign` FOREIGN KEY (`conversation_id`) REFERENCES `users_conversations` (`id`) ON DELETE CASCADE
  373. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  374.  
  375.  
  376. -- 2020-02-26 17:32:14
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!