· 6 years ago · Oct 16, 2019, 09:14 AM
1-- Adminer 4.7.3 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP DATABASE IF EXISTS `flits`;
9CREATE DATABASE `flits` /*!40100 DEFAULT CHARACTER SET latin1 */;
10USE `flits`;
11
12DROP TABLE IF EXISTS `affiliate_links`;
13CREATE TABLE `affiliate_links` (
14 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
15 `app_admins_id` bigint(20) NOT NULL,
16 `link_slug` varchar(191) COLLATE utf8_bin NOT NULL,
17 `total_installation` bigint(20) NOT NULL,
18 `total_uninstallation` bigint(20) NOT NULL,
19 `total_payment` double NOT NULL,
20 `created_at` timestamp NULL DEFAULT NULL,
21 `updated_at` timestamp NULL DEFAULT NULL,
22 `deleted_at` timestamp NULL DEFAULT NULL,
23 PRIMARY KEY (`id`)
24) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
25
26
27DROP TABLE IF EXISTS `affiliate_stores`;
28CREATE TABLE `affiliate_stores` (
29 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
30 `app_admins_id` bigint(20) NOT NULL,
31 `affiliate_links_id` bigint(20) NOT NULL,
32 `shop_id` bigint(20) NOT NULL,
33 `plan_name` varchar(191) COLLATE utf8_bin NOT NULL,
34 `store_name` varchar(191) COLLATE utf8_bin NOT NULL,
35 `total_payment` double NOT NULL,
36 `payment` double NOT NULL,
37 `trial_ends_on` date NOT NULL,
38 `is_uninstallation` tinyint(4) NOT NULL,
39 `created_at` timestamp NULL DEFAULT NULL,
40 `updated_at` timestamp NULL DEFAULT NULL,
41 `deleted_at` timestamp NULL DEFAULT NULL,
42 PRIMARY KEY (`id`)
43) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
44
45
46DROP TABLE IF EXISTS `apps`;
47CREATE TABLE `apps` (
48 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
49 `name` varchar(191) COLLATE utf8_bin NOT NULL,
50 `mode` varchar(191) COLLATE utf8_bin NOT NULL,
51 `is_payment_test` tinyint(1) NOT NULL DEFAULT '1',
52 `shopify_key` varchar(255) COLLATE utf8_bin DEFAULT NULL,
53 `shopify_secret` varchar(255) COLLATE utf8_bin DEFAULT NULL,
54 `env_suffix` varchar(255) COLLATE utf8_bin DEFAULT NULL,
55 `app_url` varchar(255) COLLATE utf8_bin DEFAULT NULL,
56 `shopify_callback_url` varchar(255) COLLATE utf8_bin DEFAULT NULL,
57 `payment_return_url` varchar(255) COLLATE utf8_bin DEFAULT NULL,
58 `created_at` timestamp NULL DEFAULT NULL,
59 `updated_at` timestamp NULL DEFAULT NULL,
60 PRIMARY KEY (`id`)
61) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
62
63
64DROP TABLE IF EXISTS `app_admins`;
65CREATE TABLE `app_admins` (
66 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
67 `name` varchar(191) COLLATE utf8_bin NOT NULL,
68 `email` varchar(191) COLLATE utf8_bin NOT NULL,
69 `password` varchar(191) COLLATE utf8_bin NOT NULL,
70 `app_admin_token` varchar(191) COLLATE utf8_bin NOT NULL,
71 `role_id` bigint(20) NOT NULL DEFAULT '-1',
72 `percentage` double NOT NULL DEFAULT '0',
73 `total_payment` double DEFAULT '0',
74 `payments` double NOT NULL DEFAULT '0',
75 `remember_token` varchar(100) COLLATE utf8_bin DEFAULT NULL,
76 `created_at` timestamp NULL DEFAULT NULL,
77 `updated_at` timestamp NULL DEFAULT NULL,
78 `deleted_at` timestamp NULL DEFAULT NULL,
79 PRIMARY KEY (`id`)
80) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
81
82
83DROP TABLE IF EXISTS `columns`;
84CREATE TABLE `columns` (
85 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
86 `name` varchar(191) COLLATE utf8_bin NOT NULL,
87 `display_name` varchar(191) COLLATE utf8_bin NOT NULL,
88 `value_type` varchar(191) COLLATE utf8_bin DEFAULT NULL,
89 `created_at` timestamp NULL DEFAULT NULL,
90 `updated_at` timestamp NULL DEFAULT NULL,
91 PRIMARY KEY (`id`)
92) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
93
94
95DROP TABLE IF EXISTS `credit_types`;
96CREATE TABLE `credit_types` (
97 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
98 `name` varchar(191) COLLATE utf8_bin NOT NULL,
99 `display_name` varchar(191) COLLATE utf8_bin NOT NULL,
100 `created_at` timestamp NULL DEFAULT NULL,
101 `updated_at` timestamp NULL DEFAULT NULL,
102 PRIMARY KEY (`id`)
103) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
104
105
106DROP TABLE IF EXISTS `desktop_notifications`;
107CREATE TABLE `desktop_notifications` (
108 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
109 `title` varchar(255) COLLATE utf8_bin NOT NULL,
110 `message` varchar(255) COLLATE utf8_bin NOT NULL,
111 `primary_link` varchar(255) COLLATE utf8_bin NOT NULL,
112 `btn_0_text` varchar(255) COLLATE utf8_bin NOT NULL,
113 `btn_0_link` varchar(255) COLLATE utf8_bin NOT NULL,
114 `btn_1_text` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT 'null',
115 `btn_1_link` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT 'null',
116 `created_at` timestamp NULL DEFAULT NULL,
117 `updated_at` timestamp NULL DEFAULT NULL,
118 PRIMARY KEY (`id`)
119) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
120
121
122DROP TABLE IF EXISTS `discounts`;
123CREATE TABLE `discounts` (
124 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
125 `discount_label` varchar(191) COLLATE utf8_bin NOT NULL,
126 `discount_percentage` double NOT NULL,
127 `max_usage` int(11) NOT NULL,
128 `total_usage` int(11) NOT NULL,
129 `is_expired` tinyint(1) NOT NULL,
130 `used_in` text COLLATE utf8_bin,
131 `display_msg` varchar(191) COLLATE utf8_bin DEFAULT NULL,
132 `created_at` timestamp NULL DEFAULT NULL,
133 `updated_at` timestamp NULL DEFAULT NULL,
134 `deleted_at` timestamp NULL DEFAULT NULL,
135 PRIMARY KEY (`id`)
136) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
137
138
139DROP TABLE IF EXISTS `failed_jobs`;
140CREATE TABLE `failed_jobs` (
141 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
142 `connection` text COLLATE utf8_bin NOT NULL,
143 `queue` text COLLATE utf8_bin NOT NULL,
144 `payload` longtext COLLATE utf8_bin NOT NULL,
145 `exception` longtext COLLATE utf8_bin NOT NULL,
146 `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
147 PRIMARY KEY (`id`)
148) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
149
150
151DROP TABLE IF EXISTS `features`;
152CREATE TABLE `features` (
153 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
154 `app_id` bigint(20) unsigned NOT NULL,
155 `key` varchar(191) COLLATE utf8_bin NOT NULL,
156 `is_addon` tinyint(1) NOT NULL DEFAULT '0',
157 `is_enable_key` varchar(191) COLLATE utf8_bin DEFAULT NULL,
158 `is_paid_key` varchar(191) COLLATE utf8_bin DEFAULT NULL,
159 `short` varchar(191) COLLATE utf8_bin DEFAULT NULL,
160 `route_str` varchar(191) COLLATE utf8_bin DEFAULT NULL,
161 `created_at` timestamp NULL DEFAULT NULL,
162 `updated_at` timestamp NULL DEFAULT NULL,
163 PRIMARY KEY (`id`)
164) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
165
166
167DROP TABLE IF EXISTS `feature_plan`;
168CREATE TABLE `feature_plan` (
169 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
170 `plan_id` bigint(20) NOT NULL,
171 `feature_id` bigint(20) NOT NULL,
172 `value` varchar(191) COLLATE utf8_bin NOT NULL,
173 `is_available` tinyint(1) NOT NULL,
174 `price` float NOT NULL,
175 `created_at` timestamp NULL DEFAULT NULL,
176 `updated_at` timestamp NULL DEFAULT NULL,
177 PRIMARY KEY (`id`)
178) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
179
180
181DROP TABLE IF EXISTS `jobs`;
182CREATE TABLE `jobs` (
183 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
184 `queue` varchar(191) COLLATE utf8_bin NOT NULL,
185 `payload` longtext COLLATE utf8_bin NOT NULL,
186 `attempts` tinyint(3) unsigned NOT NULL,
187 `reserved_at` int(10) unsigned DEFAULT NULL,
188 `available_at` int(10) unsigned NOT NULL,
189 `created_at` int(10) unsigned NOT NULL,
190 PRIMARY KEY (`id`),
191 KEY `jobs_queue_index` (`queue`)
192) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
193
194
195DROP TABLE IF EXISTS `mail_trackings`;
196CREATE TABLE `mail_trackings` (
197 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
198 `user_id` bigint(20) NOT NULL,
199 `mail_key` varchar(191) COLLATE utf8_bin NOT NULL,
200 `is_open` int(11) NOT NULL DEFAULT '0',
201 `is_primary_button_clicked` int(11) NOT NULL DEFAULT '0',
202 `is_secondary_button_clicked` int(11) NOT NULL DEFAULT '0',
203 `is_user_converted` int(11) NOT NULL DEFAULT '0',
204 `created_at` timestamp NULL DEFAULT NULL,
205 `updated_at` timestamp NULL DEFAULT NULL,
206 PRIMARY KEY (`id`)
207) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
208
209
210DROP TABLE IF EXISTS `main_taggables`;
211CREATE TABLE `main_taggables` (
212 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
213 `main_tag_id` bigint(20) NOT NULL,
214 `main_taggable_id` bigint(20) NOT NULL,
215 `main_taggable_type` varchar(255) COLLATE utf8_bin NOT NULL,
216 `created_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
217 `updated_at` timestamp NULL DEFAULT NULL,
218 PRIMARY KEY (`id`)
219) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
220
221
222DROP TABLE IF EXISTS `main_tags`;
223CREATE TABLE `main_tags` (
224 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
225 `tag` varchar(255) COLLATE utf8_bin NOT NULL,
226 `created_at` timestamp NULL DEFAULT NULL,
227 `updated_at` timestamp NULL DEFAULT NULL,
228 PRIMARY KEY (`id`)
229) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
230
231
232DROP TABLE IF EXISTS `meta_datas`;
233CREATE TABLE `meta_datas` (
234 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
235 `app_id` int(11) NOT NULL DEFAULT '1',
236 `user_id` int(11) NOT NULL DEFAULT '-1',
237 `key` varchar(191) COLLATE utf8_bin DEFAULT NULL,
238 `value` varchar(191) COLLATE utf8_bin DEFAULT NULL,
239 `created_at` timestamp NULL DEFAULT NULL,
240 `updated_at` timestamp NULL DEFAULT NULL,
241 PRIMARY KEY (`id`)
242) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
243
244
245DROP TABLE IF EXISTS `migrations`;
246CREATE TABLE `migrations` (
247 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
248 `migration` varchar(191) COLLATE utf8_bin NOT NULL,
249 `batch` int(11) NOT NULL,
250 PRIMARY KEY (`id`)
251) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
252
253
254DROP TABLE IF EXISTS `notes`;
255CREATE TABLE `notes` (
256 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
257 `note` blob,
258 `notable_id` bigint(20) NOT NULL,
259 `notable_type` varchar(255) COLLATE utf8_bin NOT NULL,
260 `created_at` timestamp NULL DEFAULT NULL,
261 `updated_at` timestamp NULL DEFAULT NULL,
262 PRIMARY KEY (`id`)
263) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
264
265
266DROP TABLE IF EXISTS `password_resets`;
267CREATE TABLE `password_resets` (
268 `email` varchar(191) COLLATE utf8_bin NOT NULL,
269 `token` varchar(191) COLLATE utf8_bin NOT NULL,
270 `created_at` timestamp NULL DEFAULT NULL,
271 KEY `password_resets_email_index` (`email`)
272) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
273
274
275DROP TABLE IF EXISTS `permissions`;
276CREATE TABLE `permissions` (
277 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
278 `role_id` bigint(20) NOT NULL DEFAULT '-1',
279 `permission_name` varchar(191) COLLATE utf8_bin NOT NULL,
280 `created_at` timestamp NULL DEFAULT NULL,
281 `updated_at` timestamp NULL DEFAULT NULL,
282 PRIMARY KEY (`id`)
283) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
284
285
286DROP TABLE IF EXISTS `plans`;
287CREATE TABLE `plans` (
288 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
289 `app_id` int(11) NOT NULL,
290 `name` varchar(191) COLLATE utf8_bin NOT NULL,
291 `price` double(8,2) NOT NULL,
292 `trial_days` int(11) NOT NULL DEFAULT '0',
293 `is_old` tinyint(4) NOT NULL,
294 `price_compare_at` double NOT NULL,
295 `custom_name` varchar(191) COLLATE utf8_bin NOT NULL,
296 `parent_id` double NOT NULL,
297 `created_at` timestamp NULL DEFAULT NULL,
298 `updated_at` timestamp NULL DEFAULT NULL,
299 PRIMARY KEY (`id`)
300) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
301
302
303DROP TABLE IF EXISTS `relations`;
304CREATE TABLE `relations` (
305 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
306 `name` varchar(191) COLLATE utf8_bin NOT NULL,
307 `display_name` varchar(191) COLLATE utf8_bin NOT NULL,
308 `symbol` varchar(191) COLLATE utf8_bin NOT NULL,
309 `created_at` timestamp NULL DEFAULT NULL,
310 `updated_at` timestamp NULL DEFAULT NULL,
311 PRIMARY KEY (`id`)
312) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
313
314
315DROP TABLE IF EXISTS `roles`;
316CREATE TABLE `roles` (
317 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
318 `role_id` bigint(20) NOT NULL DEFAULT '-1',
319 `role_name` varchar(191) COLLATE utf8_bin NOT NULL,
320 `created_at` timestamp NULL DEFAULT NULL,
321 `updated_at` timestamp NULL DEFAULT NULL,
322 PRIMARY KEY (`id`)
323) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
324
325
326DROP TABLE IF EXISTS `rules`;
327CREATE TABLE `rules` (
328 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
329 `column_id` int(11) NOT NULL,
330 `relation_id` int(11) NOT NULL,
331 `rule_type` varchar(191) COLLATE utf8_bin DEFAULT NULL,
332 `created_at` timestamp NULL DEFAULT NULL,
333 `updated_at` timestamp NULL DEFAULT NULL,
334 PRIMARY KEY (`id`)
335) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
336
337
338DROP TABLE IF EXISTS `sessions`;
339CREATE TABLE `sessions` (
340 `id` varchar(191) COLLATE utf8_bin NOT NULL,
341 `user_id` int(10) unsigned DEFAULT NULL,
342 `ip_address` varchar(45) COLLATE utf8_bin DEFAULT NULL,
343 `user_agent` text COLLATE utf8_bin,
344 `payload` text COLLATE utf8_bin NOT NULL,
345 `last_activity` int(11) NOT NULL,
346 UNIQUE KEY `sessions_id_unique` (`id`)
347) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
348
349
350DROP TABLE IF EXISTS `shopify_calls`;
351CREATE TABLE `shopify_calls` (
352 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
353 `method` varchar(191) COLLATE utf8_bin DEFAULT NULL,
354 `url` varchar(191) COLLATE utf8_bin DEFAULT NULL,
355 `size` varchar(191) COLLATE utf8_bin DEFAULT NULL,
356 `created_at` timestamp NULL DEFAULT NULL,
357 `updated_at` timestamp NULL DEFAULT NULL,
358 PRIMARY KEY (`id`)
359) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
360
361
362DROP TABLE IF EXISTS `users`;
363CREATE TABLE `users` (
364 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
365 `shopify_id` bigint(20) NOT NULL,
366 `version` int(11) NOT NULL DEFAULT '1',
367 `guid` varchar(191) COLLATE utf8_bin NOT NULL,
368 `name` varchar(191) COLLATE utf8_bin NOT NULL,
369 `email` varchar(191) COLLATE utf8_bin NOT NULL,
370 `password` varchar(191) COLLATE utf8_bin NOT NULL,
371 `shop_name` varchar(191) COLLATE utf8_bin NOT NULL,
372 `shopify_domain` text COLLATE utf8_bin,
373 `shopify_country_name` varchar(191) COLLATE utf8_bin DEFAULT NULL,
374 `shopify_address1` text COLLATE utf8_bin,
375 `shopify_phone` varchar(191) COLLATE utf8_bin DEFAULT NULL,
376 `shopify_has_storefront` tinyint(1) NOT NULL,
377 `shopify_password_enabled` tinyint(1) NOT NULL DEFAULT '0',
378 `shopify_plan` varchar(191) COLLATE utf8_bin DEFAULT NULL,
379 `store_name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
380 `money_format` varchar(255) COLLATE utf8_bin DEFAULT NULL,
381 `token` varchar(191) COLLATE utf8_bin DEFAULT NULL COMMENT 'this token is used for api access',
382 `is_uninstall` tinyint(1) NOT NULL DEFAULT '0',
383 `selected_plan` int(11) NOT NULL DEFAULT '-1',
384 `customers_limit` bigint(20) NOT NULL DEFAULT '0',
385 `selected_plan_price` double NOT NULL DEFAULT '0',
386 `applied_discount_id` bigint(20) NOT NULL DEFAULT '0',
387 `is_sc_paid` tinyint(1) NOT NULL DEFAULT '0',
388 `sc_version` int(11) NOT NULL DEFAULT '1',
389 `is_sl_paid` tinyint(1) NOT NULL DEFAULT '0',
390 `is_wl_paid` tinyint(1) NOT NULL DEFAULT '0',
391 `is_ad_paid` tinyint(1) NOT NULL DEFAULT '0',
392 `is_ot_paid` tinyint(1) NOT NULL DEFAULT '0',
393 `applied_discount_price` double NOT NULL DEFAULT '0',
394 `remember_token` varchar(100) COLLATE utf8_bin DEFAULT NULL,
395 `shopify_timezone` varchar(191) COLLATE utf8_bin NOT NULL DEFAULT 'Asia/Kolkata',
396 `created_at` timestamp NULL DEFAULT NULL,
397 `updated_at` timestamp NULL DEFAULT NULL,
398 `billing_updated_on` datetime DEFAULT NULL,
399 `total_customer_jobs` bigint(20) NOT NULL DEFAULT '0',
400 `trial_days` int(11) NOT NULL DEFAULT '0',
401 `trial_ends_on` date DEFAULT NULL,
402 `is_google_new_url` tinyint(1) NOT NULL DEFAULT '0',
403 PRIMARY KEY (`id`)
404) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
405
406
407DROP TABLE IF EXISTS `user_accesses`;
408CREATE TABLE `user_accesses` (
409 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
410 `ip_address` varchar(191) COLLATE utf8_bin DEFAULT NULL,
411 `shop_id` int(11) DEFAULT NULL,
412 `request_url` text COLLATE utf8_bin,
413 `shop_name` varchar(191) COLLATE utf8_bin DEFAULT NULL,
414 `selected_plan` varchar(191) COLLATE utf8_bin DEFAULT NULL,
415 `price` int(11) DEFAULT NULL,
416 `total_calls` bigint(20) DEFAULT NULL,
417 `created_at` timestamp NULL DEFAULT NULL,
418 `updated_at` timestamp NULL DEFAULT NULL,
419 PRIMARY KEY (`id`)
420) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
421
422
423DROP TABLE IF EXISTS `webhook_logs`;
424CREATE TABLE `webhook_logs` (
425 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
426 `ip_add` varchar(191) COLLATE utf8_bin DEFAULT NULL,
427 `add` varchar(191) COLLATE utf8_bin DEFAULT NULL,
428 `data` longtext COLLATE utf8_bin,
429 `size` double DEFAULT NULL,
430 `created_at` timestamp NULL DEFAULT NULL,
431 `updated_at` timestamp NULL DEFAULT NULL,
432 PRIMARY KEY (`id`)
433) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
434
435
436-- 2019-10-16 09:06:36