· 6 years ago · May 01, 2019, 03:02 PM
1SET FOREIGN_KEY_CHECKS=0;
2
3-- ----------------------------
4-- Table structure for `lv_articles`
5-- ----------------------------
6DROP TABLE IF EXISTS `lv_articles`;
7CREATE TABLE `lv_articles` (
8 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
9 `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
10 `body` text COLLATE utf8mb4_unicode_ci,
11 `user_id` int(11) NOT NULL DEFAULT '0',
12 `created_at` timestamp NULL DEFAULT NULL,
13 `updated_at` timestamp NULL DEFAULT NULL,
14 PRIMARY KEY (`id`)
15) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
16
17-- ----------------------------
18-- Records of lv_articles
19-- ----------------------------
20
21-- ----------------------------
22-- Table structure for `lv_faqs`
23-- ----------------------------
24DROP TABLE IF EXISTS `lv_faqs`;
25CREATE TABLE `lv_faqs` (
26 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
27 `category_id` int(11) NOT NULL DEFAULT '0',
28 `question` text COLLATE utf8mb4_unicode_ci,
29 `answer` text COLLATE utf8mb4_unicode_ci,
30 `created_at` timestamp NULL DEFAULT NULL,
31 `updated_at` timestamp NULL DEFAULT NULL,
32 PRIMARY KEY (`id`)
33) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
34
35-- ----------------------------
36-- Records of lv_faqs
37-- ----------------------------
38
39-- ----------------------------
40-- Table structure for `lv_faqs_categories`
41-- ----------------------------
42DROP TABLE IF EXISTS `lv_faqs_categories`;
43CREATE TABLE `lv_faqs_categories` (
44 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
45 `name` text COLLATE utf8mb4_unicode_ci,
46 `slug` text COLLATE utf8mb4_unicode_ci,
47 `created_at` timestamp NULL DEFAULT NULL,
48 `updated_at` timestamp NULL DEFAULT NULL,
49 PRIMARY KEY (`id`)
50) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
51
52-- ----------------------------
53-- Records of lv_faqs_categories
54-- ----------------------------
55
56-- ----------------------------
57-- Table structure for `lv_migrations`
58-- ----------------------------
59DROP TABLE IF EXISTS `lv_migrations`;
60CREATE TABLE `lv_migrations` (
61 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
62 `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
63 `batch` int(11) NOT NULL,
64 PRIMARY KEY (`id`)
65) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
66
67-- ----------------------------
68-- Records of lv_migrations
69-- ----------------------------
70INSERT INTO `lv_migrations` VALUES ('1', '2014_10_12_000000_create_users_table', '1');
71INSERT INTO `lv_migrations` VALUES ('2', '2014_10_12_100000_create_password_resets_table', '1');
72INSERT INTO `lv_migrations` VALUES ('3', '2018_11_30_231053_create_articles_table', '1');
73INSERT INTO `lv_migrations` VALUES ('4', '2018_12_01_214646_create_settings_table', '1');
74INSERT INTO `lv_migrations` VALUES ('5', '2018_12_01_222731_create_permissions_table', '1');
75INSERT INTO `lv_migrations` VALUES ('6', '2018_12_01_222819_create_users_permissions_table', '1');
76INSERT INTO `lv_migrations` VALUES ('8', '2019_04_10_172956_create_products_items_table', '2');
77INSERT INTO `lv_migrations` VALUES ('11', '2019_04_10_175914_create_users_orders_table', '3');
78INSERT INTO `lv_migrations` VALUES ('12', '2019_04_10_172323_create_products_table', '4');
79INSERT INTO `lv_migrations` VALUES ('15', '2019_04_13_213329_create_users_transactions_table', '6');
80INSERT INTO `lv_migrations` VALUES ('16', '2019_04_13_002852_create_products_categories_table', '7');
81INSERT INTO `lv_migrations` VALUES ('17', '2019_04_14_165442_create_faqs_table', '8');
82INSERT INTO `lv_migrations` VALUES ('18', '2019_04_14_172643_create_faqs_categories_table', '8');
83INSERT INTO `lv_migrations` VALUES ('19', '2019_04_19_165135_create_users_tickets_table', '9');
84INSERT INTO `lv_migrations` VALUES ('20', '2019_04_19_170520_create_users_tickets_categories_table', '9');
85INSERT INTO `lv_migrations` VALUES ('21', '2019_04_19_170812_create_users_tickets_replies_table', '9');
86INSERT INTO `lv_migrations` VALUES ('22', '2019_04_24_005024_create_notifications_table', '10');
87
88-- ----------------------------
89-- Table structure for `lv_notifications`
90-- ----------------------------
91DROP TABLE IF EXISTS `lv_notifications`;
92CREATE TABLE `lv_notifications` (
93 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
94 `custom_id` int(11) NOT NULL DEFAULT '0',
95 `extra_data` text COLLATE utf8mb4_unicode_ci,
96 `type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
97 `created_at` timestamp NULL DEFAULT NULL,
98 `updated_at` timestamp NULL DEFAULT NULL,
99 `readed` enum('true','false') COLLATE utf8mb4_unicode_ci DEFAULT 'false',
100 PRIMARY KEY (`id`)
101) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
102
103-- ----------------------------
104-- Records of lv_notifications
105-- ----------------------------
106
107-- ----------------------------
108-- Table structure for `lv_password_resets`
109-- ----------------------------
110DROP TABLE IF EXISTS `lv_password_resets`;
111CREATE TABLE `lv_password_resets` (
112 `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
113 `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
114 `created_at` timestamp NULL DEFAULT NULL,
115 KEY `lv_password_resets_email_index` (`email`)
116) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
117
118-- ----------------------------
119-- Records of lv_password_resets
120-- ----------------------------
121
122-- ----------------------------
123-- Table structure for `lv_permissions`
124-- ----------------------------
125DROP TABLE IF EXISTS `lv_permissions`;
126CREATE TABLE `lv_permissions` (
127 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
128 `permission` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
129 `created_at` timestamp NULL DEFAULT NULL,
130 `updated_at` timestamp NULL DEFAULT NULL,
131 PRIMARY KEY (`id`),
132 UNIQUE KEY `lv_permissions_permission_unique` (`permission`)
133) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
134
135-- ----------------------------
136-- Records of lv_permissions
137-- ----------------------------
138INSERT INTO `lv_permissions` VALUES ('1', 'access_backend', null, null);
139INSERT INTO `lv_permissions` VALUES ('2', 'jabber_newsletter', null, null);
140INSERT INTO `lv_permissions` VALUES ('3', 'manage_articles', null, null);
141INSERT INTO `lv_permissions` VALUES ('4', 'manage_faqs', null, null);
142INSERT INTO `lv_permissions` VALUES ('5', 'manage_faqs_categories', null, null);
143INSERT INTO `lv_permissions` VALUES ('6', 'manage_products', null, null);
144INSERT INTO `lv_permissions` VALUES ('7', 'manage_products_categories', null, null);
145INSERT INTO `lv_permissions` VALUES ('8', 'manage_tickets', null, null);
146INSERT INTO `lv_permissions` VALUES ('9', 'manage_tickets_categories', null, null);
147INSERT INTO `lv_permissions` VALUES ('10', 'system_settings', null, null);
148INSERT INTO `lv_permissions` VALUES ('11', 'manage_bitcoin_wallet', null, null);
149INSERT INTO `lv_permissions` VALUES ('12', 'manage_creditcards', null, null);
150INSERT INTO `lv_permissions` VALUES ('13', 'manage_users', null, null);
151INSERT INTO `lv_permissions` VALUES ('14', 'manage_users_permissions', null, null);
152
153-- ----------------------------
154-- Table structure for `lv_products`
155-- ----------------------------
156DROP TABLE IF EXISTS `lv_products`;
157CREATE TABLE `lv_products` (
158 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
159 `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
160 `description` text COLLATE utf8mb4_unicode_ci,
161 `short_description` text COLLATE utf8mb4_unicode_ci,
162 `content` text COLLATE utf8mb4_unicode_ci,
163 `price_in_cent` int(11) NOT NULL DEFAULT '0',
164 `category_id` int(11) NOT NULL DEFAULT '0',
165 `stock_management` int(11) NOT NULL DEFAULT '1',
166 `created_at` timestamp NULL DEFAULT NULL,
167 `updated_at` timestamp NULL DEFAULT NULL,
168 `sells` int(11) DEFAULT '0',
169 PRIMARY KEY (`id`)
170) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
171
172-- ----------------------------
173-- Records of lv_products
174-- ----------------------------
175
176-- ----------------------------
177-- Table structure for `lv_products_categories`
178-- ----------------------------
179DROP TABLE IF EXISTS `lv_products_categories`;
180CREATE TABLE `lv_products_categories` (
181 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
182 `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
183 `slug` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
184 `created_at` timestamp NULL DEFAULT NULL,
185 `updated_at` timestamp NULL DEFAULT NULL,
186 PRIMARY KEY (`id`)
187) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
188
189-- ----------------------------
190-- Records of lv_products_categories
191-- ----------------------------
192
193-- ----------------------------
194-- Table structure for `lv_products_items`
195-- ----------------------------
196DROP TABLE IF EXISTS `lv_products_items`;
197CREATE TABLE `lv_products_items` (
198 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
199 `product_id` int(11) NOT NULL DEFAULT '0',
200 `content` text COLLATE utf8mb4_unicode_ci,
201 `created_at` timestamp NULL DEFAULT NULL,
202 `updated_at` timestamp NULL DEFAULT NULL,
203 PRIMARY KEY (`id`)
204) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
205
206-- ----------------------------
207-- Records of lv_products_items
208-- ----------------------------
209
210-- ----------------------------
211-- Table structure for `lv_settings`
212-- ----------------------------
213DROP TABLE IF EXISTS `lv_settings`;
214CREATE TABLE `lv_settings` (
215 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
216 `key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
217 `value` text COLLATE utf8mb4_unicode_ci NOT NULL,
218 `type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'string',
219 `before_add` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
220 `after_add` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
221 `created_at` timestamp NULL DEFAULT NULL,
222 `updated_at` timestamp NULL DEFAULT NULL,
223 PRIMARY KEY (`id`)
224) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
225
226-- ----------------------------
227-- Records of lv_settings
228-- ----------------------------
229INSERT INTO `lv_settings` VALUES ('1', 'app.name', 'FraudCart', 'string', '', '', '0000-00-00 00:00:00', '2019-04-23 21:38:18');
230INSERT INTO `lv_settings` VALUES ('2', 'app.url', 'http://localhost', 'string', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
231INSERT INTO `lv_settings` VALUES ('3', 'app.asset_url', '/assets/', 'string', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
232INSERT INTO `lv_settings` VALUES ('4', 'app.timezone', 'Europe/Berlin', 'string', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
233INSERT INTO `lv_settings` VALUES ('5', 'app.cipher', 'AES-256-CBC', 'string', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
234INSERT INTO `lv_settings` VALUES ('6', 'app.debug', 'true', 'bool', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
235INSERT INTO `lv_settings` VALUES ('7', 'mail.from.name', 'FraudCart', 'string', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
236INSERT INTO `lv_settings` VALUES ('8', 'mail.from.address', 'info@fraudcart.lv', 'string', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
237INSERT INTO `lv_settings` VALUES ('9', 'mail.port', '587', 'string', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
238INSERT INTO `lv_settings` VALUES ('10', 'mail.host', 'us2.smtp.mailhostbox.com', 'string', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
239INSERT INTO `lv_settings` VALUES ('11', 'mail.driver', 'smtp', 'string', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
240INSERT INTO `lv_settings` VALUES ('12', 'mail.username', 'info@fraudcart.lv', 'string', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
241INSERT INTO `lv_settings` VALUES ('13', 'mail.password', '123456', 'string', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
242INSERT INTO `lv_settings` VALUES ('14', 'mail.encryption', 'tls', 'string', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
243INSERT INTO `lv_settings` VALUES ('15', 'backend.name', 'FraudCart Panel', 'string', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
244INSERT INTO `lv_settings` VALUES ('16', 'app.access_only_for_users', '1', 'bool', null, null, null, '2019-04-25 03:14:45');
245INSERT INTO `lv_settings` VALUES ('17', 'shop.replace_rules', '7', 'int', null, null, null, '2019-04-24 18:54:17');
246INSERT INTO `lv_settings` VALUES ('18', 'shop.currency', 'EUR', 'string', null, null, null, '2019-04-23 21:38:26');
247INSERT INTO `lv_settings` VALUES ('19', 'shop.btc_confirms_needed', '1', 'int', null, null, null, null);
248INSERT INTO `lv_settings` VALUES ('20', 'shop.total_sells', '10', 'int', null, null, null, '2019-04-28 23:14:17');
249INSERT INTO `lv_settings` VALUES ('21', 'jabber.address', 'tcp://jabber.ccc.de:5222', 'string', null, null, null, null);
250INSERT INTO `lv_settings` VALUES ('22', 'jabber.username', 'fraudcart', 'string', null, null, null, null);
251INSERT INTO `lv_settings` VALUES ('23', 'jabber.password', 'Fraud123', 'string', null, null, null, null);
252INSERT INTO `lv_settings` VALUES ('24', 'bitcoin.api', 'http://btc_user:btc_pass@localhost:8332/', 'string', null, null, null, null);
253INSERT INTO `lv_settings` VALUES ('25', 'register.newsletter_enabled', '1', 'bool', null, null, null, '2019-04-27 20:57:27');
254INSERT INTO `lv_settings` VALUES ('26', 'shop.creditcards.enabled', '0', 'bool', null, null, null, '2019-04-29 21:12:45');
255
256-- ----------------------------
257-- Table structure for `lv_users`
258-- ----------------------------
259DROP TABLE IF EXISTS `lv_users`;
260CREATE TABLE `lv_users` (
261 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
262 `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
263 `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
264 `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
265 `jabber_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
266 `balance_in_cent` int(11) NOT NULL DEFAULT '0',
267 `email_verified_at` timestamp NULL DEFAULT NULL,
268 `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
269 `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
270 `created_at` timestamp NULL DEFAULT NULL,
271 `updated_at` timestamp NULL DEFAULT NULL,
272 `language` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'de',
273 `newsletter_enabled` int(11) DEFAULT '0',
274 PRIMARY KEY (`id`),
275 UNIQUE KEY `lv_users_username_unique` (`username`),
276 UNIQUE KEY `lv_users_jabber_id_unique` (`jabber_id`),
277 UNIQUE KEY `lv_users_email_unique` (`email`)
278) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
279
280-- ----------------------------
281-- Records of lv_users
282-- ----------------------------
283INSERT INTO `lv_users` VALUES ('1', 'Admin', 'admin', 'admin@example.com', 'admin@exploit.im', '30000', null, '$2y$10$rMM9YOYxRlHKvwsJBWjqGutH948Sc3FssgsNOhcb2aCteN6UrMPL6', '3klasttVxWN41OGw8AoetnA4WJGo0Etc2E6xZhSC9sbbkCIgZfxwTdwITgJR', '2019-04-10 03:47:15', '2019-04-30 23:11:34', 'de', '1');
284
285-- ----------------------------
286-- Table structure for `lv_users_orders`
287-- ----------------------------
288DROP TABLE IF EXISTS `lv_users_orders`;
289CREATE TABLE `lv_users_orders` (
290 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
291 `user_id` int(11) NOT NULL DEFAULT '0',
292 `name` text COLLATE utf8mb4_unicode_ci,
293 `content` text COLLATE utf8mb4_unicode_ci,
294 `price_in_cent` int(11) NOT NULL DEFAULT '0',
295 `created_at` timestamp NULL DEFAULT NULL,
296 `updated_at` timestamp NULL DEFAULT NULL,
297 PRIMARY KEY (`id`)
298) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
299
300-- ----------------------------
301-- Records of lv_users_orders
302-- ----------------------------
303
304-- ----------------------------
305-- Table structure for `lv_users_permissions`
306-- ----------------------------
307DROP TABLE IF EXISTS `lv_users_permissions`;
308CREATE TABLE `lv_users_permissions` (
309 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
310 `user_id` int(11) NOT NULL DEFAULT '0',
311 `permission_id` int(11) NOT NULL DEFAULT '0',
312 `created_at` timestamp NULL DEFAULT NULL,
313 `updated_at` timestamp NULL DEFAULT NULL,
314 PRIMARY KEY (`id`)
315) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
316
317-- ----------------------------
318-- Records of lv_users_permissions
319-- ----------------------------
320INSERT INTO `lv_users_permissions` VALUES ('1', '1', '1', null, null);
321INSERT INTO `lv_users_permissions` VALUES ('2', '1', '2', null, null);
322INSERT INTO `lv_users_permissions` VALUES ('3', '1', '3', null, null);
323INSERT INTO `lv_users_permissions` VALUES ('4', '1', '4', null, null);
324INSERT INTO `lv_users_permissions` VALUES ('5', '1', '5', null, null);
325INSERT INTO `lv_users_permissions` VALUES ('6', '1', '6', null, null);
326INSERT INTO `lv_users_permissions` VALUES ('7', '1', '7', null, null);
327INSERT INTO `lv_users_permissions` VALUES ('8', '1', '8', null, null);
328INSERT INTO `lv_users_permissions` VALUES ('9', '1', '9', null, null);
329INSERT INTO `lv_users_permissions` VALUES ('10', '1', '10', null, null);
330INSERT INTO `lv_users_permissions` VALUES ('11', '1', '11', null, null);
331INSERT INTO `lv_users_permissions` VALUES ('12', '1', '12', null, null);
332INSERT INTO `lv_users_permissions` VALUES ('13', '1', '13', null, null);
333INSERT INTO `lv_users_permissions` VALUES ('14', '1', '14', null, null);
334
335-- ----------------------------
336-- Table structure for `lv_users_tickets`
337-- ----------------------------
338DROP TABLE IF EXISTS `lv_users_tickets`;
339CREATE TABLE `lv_users_tickets` (
340 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
341 `user_id` int(11) NOT NULL DEFAULT '0',
342 `category_id` int(11) NOT NULL DEFAULT '0',
343 `subject` text COLLATE utf8mb4_unicode_ci,
344 `content` text COLLATE utf8mb4_unicode_ci,
345 `created_at` timestamp NULL DEFAULT NULL,
346 `updated_at` timestamp NULL DEFAULT NULL,
347 `status` enum('open','closed') COLLATE utf8mb4_unicode_ci DEFAULT 'open',
348 PRIMARY KEY (`id`)
349) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
350
351-- ----------------------------
352-- Records of lv_users_tickets
353-- ----------------------------
354
355-- ----------------------------
356-- Table structure for `lv_users_tickets_categories`
357-- ----------------------------
358DROP TABLE IF EXISTS `lv_users_tickets_categories`;
359CREATE TABLE `lv_users_tickets_categories` (
360 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
361 `name` text COLLATE utf8mb4_unicode_ci,
362 `created_at` timestamp NULL DEFAULT NULL,
363 `updated_at` timestamp NULL DEFAULT NULL,
364 PRIMARY KEY (`id`)
365) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
366
367-- ----------------------------
368-- Records of lv_users_tickets_categories
369-- ----------------------------
370INSERT INTO `lv_users_tickets_categories` VALUES ('1', 'Allgemein', null, null);
371INSERT INTO `lv_users_tickets_categories` VALUES ('2', 'Account', null, null);
372INSERT INTO `lv_users_tickets_categories` VALUES ('3', 'Bestellung', null, null);
373INSERT INTO `lv_users_tickets_categories` VALUES ('4', 'Bug-Reporting', null, null);
374
375-- ----------------------------
376-- Table structure for `lv_users_tickets_replies`
377-- ----------------------------
378DROP TABLE IF EXISTS `lv_users_tickets_replies`;
379CREATE TABLE `lv_users_tickets_replies` (
380 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
381 `user_id` int(11) NOT NULL DEFAULT '0',
382 `ticket_id` int(11) NOT NULL DEFAULT '0',
383 `content` text COLLATE utf8mb4_unicode_ci,
384 `created_at` timestamp NULL DEFAULT NULL,
385 `updated_at` timestamp NULL DEFAULT NULL,
386 PRIMARY KEY (`id`)
387) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
388
389-- ----------------------------
390-- Records of lv_users_tickets_replies
391-- ----------------------------
392
393-- ----------------------------
394-- Table structure for `lv_users_transactions`
395-- ----------------------------
396DROP TABLE IF EXISTS `lv_users_transactions`;
397CREATE TABLE `lv_users_transactions` (
398 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
399 `user_id` int(11) NOT NULL DEFAULT '0',
400 `wallet` text COLLATE utf8mb4_unicode_ci,
401 `txids` text COLLATE utf8mb4_unicode_ci,
402 `status` enum('paid','pending','waiting') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'waiting',
403 `amount` bigint(20) NOT NULL DEFAULT '0',
404 `created_at` timestamp NULL DEFAULT NULL,
405 `updated_at` timestamp NULL DEFAULT NULL,
406 `amount_cent` int(11) NOT NULL DEFAULT '0',
407 `payment_method` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'btc',
408 `confirmations` int(11) DEFAULT '0',
409 PRIMARY KEY (`id`)
410) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
411
412-- ----------------------------
413-- Records of lv_users_transactions
414-- ----------------------------