· 5 years ago · Jul 10, 2020, 02:16 PM
1/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
2/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
3/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
4/*!50503 SET NAMES utf8mb4 */;
5/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
6/*!40103 SET TIME_ZONE='+00:00' */;
7/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
8/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
9/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
10/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
11/*!50717 SELECT COUNT(*) INTO @rocksdb_has_p_s_session_variables FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'performance_schema' AND TABLE_NAME = 'session_variables' */;
12/*!50717 SET @rocksdb_get_is_supported = IF (@rocksdb_has_p_s_session_variables, 'SELECT COUNT(*) INTO @rocksdb_is_supported FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'rocksdb_bulk_load\'', 'SELECT 0') */;
13/*!50717 PREPARE s FROM @rocksdb_get_is_supported */;
14/*!50717 EXECUTE s */;
15/*!50717 DEALLOCATE PREPARE s */;
16/*!50717 SET @rocksdb_enable_bulk_load = IF (@rocksdb_is_supported, 'SET SESSION rocksdb_bulk_load = 1', 'SET @rocksdb_dummy_bulk_load = 0') */;
17/*!50717 PREPARE s FROM @rocksdb_enable_bulk_load */;
18/*!50717 EXECUTE s */;
19/*!50717 DEALLOCATE PREPARE s */;
20
21--
22-- Table structure for table `ChandlerACLGroupsPermissions`
23--
24
25DROP TABLE IF EXISTS `ChandlerACLGroupsPermissions`;
26/*!40101 SET @saved_cs_client = @@character_set_client */;
27/*!50503 SET character_set_client = utf8mb4 */;
28CREATE TABLE `ChandlerACLGroupsPermissions` (
29 `group` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
30 `model` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
31 `context` int unsigned DEFAULT NULL,
32 `permission` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
33 `status` tinyint(1) NOT NULL DEFAULT '1',
34 KEY `group` (`group`)
35) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
36/*!40101 SET character_set_client = @saved_cs_client */;
37
38--
39-- Table structure for table `ChandlerACLPermissionAliases`
40--
41
42DROP TABLE IF EXISTS `ChandlerACLPermissionAliases`;
43/*!40101 SET @saved_cs_client = @@character_set_client */;
44/*!50503 SET character_set_client = utf8mb4 */;
45CREATE TABLE `ChandlerACLPermissionAliases` (
46 `alias` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
47 `model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
48 `context` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
49 `permission` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
50 PRIMARY KEY (`alias`)
51) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
52/*!40101 SET character_set_client = @saved_cs_client */;
53
54--
55-- Table structure for table `ChandlerACLRelations`
56--
57
58DROP TABLE IF EXISTS `ChandlerACLRelations`;
59/*!40101 SET @saved_cs_client = @@character_set_client */;
60/*!50503 SET character_set_client = utf8mb4 */;
61CREATE TABLE `ChandlerACLRelations` (
62 `user` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
63 `group` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
64 `priority` bigint unsigned NOT NULL DEFAULT '0',
65 KEY `user` (`user`),
66 KEY `group` (`group`)
67) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
68/*!40101 SET character_set_client = @saved_cs_client */;
69
70--
71-- Table structure for table `ChandlerACLUsersPermissions`
72--
73
74DROP TABLE IF EXISTS `ChandlerACLUsersPermissions`;
75/*!40101 SET @saved_cs_client = @@character_set_client */;
76/*!50503 SET character_set_client = utf8mb4 */;
77CREATE TABLE `ChandlerACLUsersPermissions` (
78 `user` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
79 `model` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
80 `context` int unsigned NOT NULL,
81 `permission` int unsigned NOT NULL,
82 `status` tinyint(1) NOT NULL DEFAULT '1',
83 KEY `user` (`user`)
84) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
85/*!40101 SET character_set_client = @saved_cs_client */;
86
87--
88-- Table structure for table `ChandlerGroups`
89--
90
91DROP TABLE IF EXISTS `ChandlerGroups`;
92/*!40101 SET @saved_cs_client = @@character_set_client */;
93/*!50503 SET character_set_client = utf8mb4 */;
94CREATE TABLE `ChandlerGroups` (
95 `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
96 `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
97 `color` mediumint unsigned DEFAULT NULL
98) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
99/*!40101 SET character_set_client = @saved_cs_client */;
100/*!50003 SET @saved_cs_client = @@character_set_client */ ;
101/*!50003 SET @saved_cs_results = @@character_set_results */ ;
102/*!50003 SET @saved_col_connection = @@collation_connection */ ;
103/*!50003 SET character_set_client = utf8mb4 */ ;
104/*!50003 SET character_set_results = utf8mb4 */ ;
105/*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ;
106/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
107/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ;
108DELIMITER ;;
109/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `bfiu_groups` BEFORE INSERT ON `ChandlerGroups` FOR EACH ROW SET new.id = uuid() */;;
110DELIMITER ;
111/*!50003 SET sql_mode = @saved_sql_mode */ ;
112/*!50003 SET character_set_client = @saved_cs_client */ ;
113/*!50003 SET character_set_results = @saved_cs_results */ ;
114/*!50003 SET collation_connection = @saved_col_connection */ ;
115
116--
117-- Table structure for table `ChandlerTokens`
118--
119
120DROP TABLE IF EXISTS `ChandlerTokens`;
121/*!40101 SET @saved_cs_client = @@character_set_client */;
122/*!50503 SET character_set_client = utf8mb4 */;
123CREATE TABLE `ChandlerTokens` (
124 `token` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
125 `user` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
126 `ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
127 `ua` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
128 PRIMARY KEY (`token`),
129 KEY `user` (`user`)
130) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
131/*!40101 SET character_set_client = @saved_cs_client */;
132/*!50003 SET @saved_cs_client = @@character_set_client */ ;
133/*!50003 SET @saved_cs_results = @@character_set_results */ ;
134/*!50003 SET @saved_col_connection = @@collation_connection */ ;
135/*!50003 SET character_set_client = utf8mb4 */ ;
136/*!50003 SET character_set_results = utf8mb4 */ ;
137/*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ;
138/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
139/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ;
140DELIMITER ;;
141/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `bfiu_tokens` BEFORE INSERT ON `ChandlerTokens` FOR EACH ROW SET new.token = uuid() */;;
142DELIMITER ;
143/*!50003 SET sql_mode = @saved_sql_mode */ ;
144/*!50003 SET character_set_client = @saved_cs_client */ ;
145/*!50003 SET character_set_results = @saved_cs_results */ ;
146/*!50003 SET collation_connection = @saved_col_connection */ ;
147
148--
149-- Table structure for table `ChandlerUsers`
150--
151
152DROP TABLE IF EXISTS `ChandlerUsers`;
153/*!40101 SET @saved_cs_client = @@character_set_client */;
154/*!50503 SET character_set_client = utf8mb4 */;
155CREATE TABLE `ChandlerUsers` (
156 `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
157 `login` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
158 `passwordHash` varchar(136) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
159 `deleted` tinyint(1) NOT NULL DEFAULT '0',
160 PRIMARY KEY (`id`),
161 UNIQUE KEY `login` (`login`)
162) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
163/*!40101 SET character_set_client = @saved_cs_client */;
164/*!50003 SET @saved_cs_client = @@character_set_client */ ;
165/*!50003 SET @saved_cs_results = @@character_set_results */ ;
166/*!50003 SET @saved_col_connection = @@collation_connection */ ;
167/*!50003 SET character_set_client = utf8mb4 */ ;
168/*!50003 SET character_set_results = utf8mb4 */ ;
169/*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ;
170/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
171/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ;
172DELIMITER ;;
173/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `bfiu_users` BEFORE INSERT ON `ChandlerUsers` FOR EACH ROW SET new.id = uuid() */;;
174DELIMITER ;
175/*!50003 SET sql_mode = @saved_sql_mode */ ;
176/*!50003 SET character_set_client = @saved_cs_client */ ;
177/*!50003 SET character_set_results = @saved_cs_results */ ;
178/*!50003 SET collation_connection = @saved_col_connection */ ;
179
180--
181-- Table structure for table `album_relations`
182--
183
184DROP TABLE IF EXISTS `album_relations`;
185/*!40101 SET @saved_cs_client = @@character_set_client */;
186/*!50503 SET character_set_client = utf8mb4 */;
187CREATE TABLE `album_relations` (
188 `album` bigint unsigned NOT NULL,
189 `photo` bigint unsigned NOT NULL,
190 `index` bigint unsigned NOT NULL AUTO_INCREMENT,
191 PRIMARY KEY (`index`)
192) ENGINE=Aria AUTO_INCREMENT=664 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
193/*!40101 SET character_set_client = @saved_cs_client */;
194
195--
196-- Table structure for table `albums`
197--
198
199DROP TABLE IF EXISTS `albums`;
200/*!40101 SET @saved_cs_client = @@character_set_client */;
201/*!50503 SET character_set_client = utf8mb4 */;
202CREATE TABLE `albums` (
203 `id` bigint unsigned NOT NULL AUTO_INCREMENT,
204 `owner` bigint NOT NULL,
205 `name` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
206 `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
207 `access_pragma` tinyint unsigned NOT NULL DEFAULT '255',
208 `cover_photo` bigint unsigned DEFAULT NULL,
209 `special_type` tinyint unsigned NOT NULL DEFAULT '0',
210 `created` bigint unsigned NOT NULL,
211 `edited` bigint unsigned DEFAULT NULL,
212 `deleted` tinyint(1) NOT NULL DEFAULT '0',
213 PRIMARY KEY (`id`)
214) ENGINE=Aria AUTO_INCREMENT=481 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
215/*!40101 SET character_set_client = @saved_cs_client */;
216
217--
218-- Table structure for table `attachments`
219--
220
221DROP TABLE IF EXISTS `attachments`;
222/*!40101 SET @saved_cs_client = @@character_set_client */;
223/*!50503 SET character_set_client = utf8mb4 */;
224CREATE TABLE `attachments` (
225 `attachable_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
226 `attachable_id` bigint unsigned DEFAULT NULL,
227 `target_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
228 `target_id` bigint unsigned DEFAULT NULL,
229 `index` bigint unsigned NOT NULL AUTO_INCREMENT,
230 PRIMARY KEY (`index`)
231) ENGINE=Aria AUTO_INCREMENT=888 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
232/*!40101 SET character_set_client = @saved_cs_client */;
233
234--
235-- Table structure for table `audio_relations`
236--
237
238DROP TABLE IF EXISTS `audio_relations`;
239/*!40101 SET @saved_cs_client = @@character_set_client */;
240/*!50503 SET character_set_client = utf8mb4 */;
241CREATE TABLE `audio_relations` (
242 `user` bigint unsigned NOT NULL,
243 `audio` bigint unsigned NOT NULL,
244 `index` bigint unsigned NOT NULL AUTO_INCREMENT,
245 UNIQUE KEY `index` (`index`)
246) ENGINE=Aria AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
247/*!40101 SET character_set_client = @saved_cs_client */;
248
249--
250-- Table structure for table `audios`
251--
252
253DROP TABLE IF EXISTS `audios`;
254/*!40101 SET @saved_cs_client = @@character_set_client */;
255/*!50503 SET character_set_client = utf8mb4 */;
256CREATE TABLE `audios` (
257 `id` bigint unsigned NOT NULL AUTO_INCREMENT,
258 `owner` bigint unsigned NOT NULL,
259 `virtual_id` bigint unsigned NOT NULL,
260 `created` bigint unsigned NOT NULL,
261 `edited` bigint unsigned DEFAULT NULL,
262 `hash` char(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
263 `deleted` tinyint DEFAULT '0',
264 `name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '(no name)',
265 `performer` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Unknown',
266 `genre` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'K-POP',
267 `lyrics` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
268 `explicit` tinyint NOT NULL DEFAULT '0',
269 PRIMARY KEY (`id`)
270) ENGINE=Aria AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
271/*!40101 SET character_set_client = @saved_cs_client */;
272
273--
274-- Table structure for table `comments`
275--
276
277DROP TABLE IF EXISTS `comments`;
278/*!40101 SET @saved_cs_client = @@character_set_client */;
279/*!50503 SET character_set_client = utf8mb4 */;
280CREATE TABLE `comments` (
281 `id` bigint unsigned NOT NULL AUTO_INCREMENT,
282 `owner` bigint NOT NULL,
283 `model` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
284 `target` bigint unsigned NOT NULL,
285 `created` bigint unsigned NOT NULL,
286 `edited` bigint unsigned DEFAULT NULL,
287 `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
288 `flags` tinyint unsigned DEFAULT NULL,
289 `ad` tinyint(1) NOT NULL DEFAULT '0',
290 `deleted` tinyint(1) DEFAULT '0',
291 `virtual_id` bigint DEFAULT '0',
292 PRIMARY KEY (`id`)
293) ENGINE=Aria AUTO_INCREMENT=699 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
294/*!40101 SET character_set_client = @saved_cs_client */;
295
296--
297-- Table structure for table `conv_sockets`
298--
299
300DROP TABLE IF EXISTS `conv_sockets`;
301/*!40101 SET @saved_cs_client = @@character_set_client */;
302/*!50503 SET character_set_client = utf8mb4 */;
303CREATE TABLE `conv_sockets` (
304 `id` bigint unsigned NOT NULL AUTO_INCREMENT,
305 `origin` bigint unsigned NOT NULL,
306 `modelId` tinyint unsigned NOT NULL,
307 `destination` bigint unsigned NOT NULL,
308 `open` bit(1) NOT NULL DEFAULT b'1',
309 `visible` bit(1) NOT NULL DEFAULT b'1',
310 UNIQUE KEY `id` (`id`)
311) ENGINE=Aria DEFAULT CHARSET=utf8;
312/*!40101 SET character_set_client = @saved_cs_client */;
313
314--
315-- Table structure for table `event_turnouts`
316--
317
318DROP TABLE IF EXISTS `event_turnouts`;
319/*!40101 SET @saved_cs_client = @@character_set_client */;
320/*!50503 SET character_set_client = utf8mb4 */;
321CREATE TABLE `event_turnouts` (
322 `user` bigint unsigned NOT NULL,
323 `event` bigint unsigned NOT NULL
324) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
325/*!40101 SET character_set_client = @saved_cs_client */;
326
327--
328-- Table structure for table `group_coadmins`
329--
330
331DROP TABLE IF EXISTS `group_coadmins`;
332/*!40101 SET @saved_cs_client = @@character_set_client */;
333/*!50503 SET character_set_client = utf8mb4 */;
334CREATE TABLE `group_coadmins` (
335 `user` bigint unsigned NOT NULL,
336 `club` bigint unsigned NOT NULL,
337 `comment` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
338 `id` bigint NOT NULL AUTO_INCREMENT,
339 PRIMARY KEY (`id`)
340) ENGINE=Aria AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
341/*!40101 SET character_set_client = @saved_cs_client */;
342
343--
344-- Table structure for table `groups`
345--
346
347DROP TABLE IF EXISTS `groups`;
348/*!40101 SET @saved_cs_client = @@character_set_client */;
349/*!50503 SET character_set_client = utf8mb4 */;
350CREATE TABLE `groups` (
351 `id` bigint unsigned NOT NULL AUTO_INCREMENT,
352 `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
353 `about` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
354 `owner` bigint unsigned DEFAULT NULL,
355 `shortcode` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
356 `verified` tinyint(1) NOT NULL DEFAULT '0',
357 `type` int unsigned DEFAULT '1',
358 `closed` tinyint unsigned NOT NULL DEFAULT '0',
359 `wall` int NOT NULL DEFAULT '1',
360 PRIMARY KEY (`id`),
361 UNIQUE KEY `shortcode` (`shortcode`)
362) ENGINE=Aria AUTO_INCREMENT=128 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
363/*!40101 SET character_set_client = @saved_cs_client */;
364
365--
366-- Table structure for table `likes`
367--
368
369DROP TABLE IF EXISTS `likes`;
370/*!40101 SET @saved_cs_client = @@character_set_client */;
371/*!50503 SET character_set_client = utf8mb4 */;
372CREATE TABLE `likes` (
373 `origin` bigint unsigned NOT NULL,
374 `model` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
375 `target` bigint NOT NULL,
376 `index` bigint unsigned NOT NULL AUTO_INCREMENT,
377 PRIMARY KEY (`index`)
378) ENGINE=Aria AUTO_INCREMENT=1468 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
379/*!40101 SET character_set_client = @saved_cs_client */;
380
381--
382-- Table structure for table `messages`
383--
384
385DROP TABLE IF EXISTS `messages`;
386/*!40101 SET @saved_cs_client = @@character_set_client */;
387/*!50503 SET character_set_client = utf8mb4 */;
388CREATE TABLE `messages` (
389 `id` bigint NOT NULL AUTO_INCREMENT,
390 `sender_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
391 `sender_id` bigint unsigned NOT NULL,
392 `recipient_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
393 `recipient_id` bigint unsigned NOT NULL,
394 `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
395 `created` bigint NOT NULL,
396 `edited` bigint DEFAULT NULL,
397 `ad` tinyint(1) NOT NULL DEFAULT '0',
398 `deleted` tinyint(1) NOT NULL DEFAULT '0',
399 PRIMARY KEY (`id`)
400) ENGINE=Aria AUTO_INCREMENT=750 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
401/*!40101 SET character_set_client = @saved_cs_client */;
402
403--
404-- Table structure for table `msg_descriptors`
405--
406
407DROP TABLE IF EXISTS `msg_descriptors`;
408/*!40101 SET @saved_cs_client = @@character_set_client */;
409/*!50503 SET character_set_client = utf8mb4 */;
410CREATE TABLE `msg_descriptors` (
411 `message` bigint unsigned NOT NULL,
412 `socket` bigint unsigned NOT NULL,
413 `ack` tinyint unsigned NOT NULL DEFAULT '0',
414 `ack_time` bigint unsigned DEFAULT NULL,
415 `visible` tinyint unsigned NOT NULL DEFAULT '1',
416 `index` bigint unsigned NOT NULL AUTO_INCREMENT,
417 UNIQUE KEY `index` (`index`)
418) ENGINE=Aria DEFAULT CHARSET=utf8;
419/*!40101 SET character_set_client = @saved_cs_client */;
420
421--
422-- Table structure for table `notes`
423--
424
425DROP TABLE IF EXISTS `notes`;
426/*!40101 SET @saved_cs_client = @@character_set_client */;
427/*!50503 SET character_set_client = utf8mb4 */;
428CREATE TABLE `notes` (
429 `id` bigint unsigned NOT NULL AUTO_INCREMENT,
430 `owner` bigint NOT NULL,
431 `virtual_id` bigint NOT NULL,
432 `created` bigint NOT NULL,
433 `edited` bigint DEFAULT NULL,
434 `name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
435 `source` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
436 `cached_content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
437 `deleted` tinyint NOT NULL DEFAULT '0',
438 PRIMARY KEY (`id`)
439) ENGINE=Aria AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
440/*!40101 SET character_set_client = @saved_cs_client */;
441
442--
443-- Table structure for table `number_verification`
444--
445
446DROP TABLE IF EXISTS `number_verification`;
447/*!40101 SET @saved_cs_client = @@character_set_client */;
448/*!50503 SET character_set_client = utf8mb4 */;
449CREATE TABLE `number_verification` (
450 `user` bigint unsigned NOT NULL,
451 `number` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
452 `code` mediumint NOT NULL,
453 PRIMARY KEY (`user`)
454) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
455/*!40101 SET character_set_client = @saved_cs_client */;
456
457--
458-- Table structure for table `password_resets`
459--
460
461DROP TABLE IF EXISTS `password_resets`;
462/*!40101 SET @saved_cs_client = @@character_set_client */;
463/*!50503 SET character_set_client = utf8mb4 */;
464CREATE TABLE `password_resets` (
465 `id` bigint unsigned NOT NULL AUTO_INCREMENT,
466 `profile` bigint unsigned NOT NULL,
467 `key` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
468 `timestamp` bigint unsigned NOT NULL,
469 PRIMARY KEY (`id`)
470) ENGINE=Aria AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
471/*!40101 SET character_set_client = @saved_cs_client */;
472
473--
474-- Table structure for table `photos`
475--
476
477DROP TABLE IF EXISTS `photos`;
478/*!40101 SET @saved_cs_client = @@character_set_client */;
479/*!50503 SET character_set_client = utf8mb4 */;
480CREATE TABLE `photos` (
481 `id` bigint unsigned NOT NULL AUTO_INCREMENT,
482 `owner` bigint NOT NULL,
483 `virtual_id` bigint NOT NULL,
484 `created` bigint unsigned NOT NULL,
485 `edited` bigint unsigned DEFAULT NULL,
486 `hash` char(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
487 `deleted` tinyint(1) NOT NULL DEFAULT '0',
488 `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
489 PRIMARY KEY (`id`)
490) ENGINE=Aria AUTO_INCREMENT=1044 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
491/*!40101 SET character_set_client = @saved_cs_client */;
492
493--
494-- Table structure for table `posts`
495--
496
497DROP TABLE IF EXISTS `posts`;
498/*!40101 SET @saved_cs_client = @@character_set_client */;
499/*!50503 SET character_set_client = utf8mb4 */;
500CREATE TABLE `posts` (
501 `id` bigint unsigned NOT NULL AUTO_INCREMENT,
502 `owner` bigint NOT NULL,
503 `wall` bigint NOT NULL,
504 `virtual_id` bigint unsigned NOT NULL,
505 `created` bigint unsigned NOT NULL,
506 `edited` bigint unsigned DEFAULT NULL,
507 `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
508 `flags` tinyint unsigned DEFAULT NULL,
509 `ad` tinyint(1) NOT NULL DEFAULT '0',
510 `deleted` tinyint(1) DEFAULT '0',
511 PRIMARY KEY (`id`)
512) ENGINE=Aria AUTO_INCREMENT=1993 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
513/*!40101 SET character_set_client = @saved_cs_client */;
514
515--
516-- Table structure for table `profiles`
517--
518
519DROP TABLE IF EXISTS `profiles`;
520/*!40101 SET @saved_cs_client = @@character_set_client */;
521/*!50503 SET character_set_client = utf8mb4 */;
522CREATE TABLE `profiles` (
523 `id` bigint unsigned NOT NULL AUTO_INCREMENT,
524 `user` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
525 `first_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Jane',
526 `last_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Doe',
527 `pseudo` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
528 `info` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
529 `about` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
530 `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
531 `privacy` bigint unsigned NOT NULL DEFAULT '1099511627775',
532 `left_menu` bigint unsigned NOT NULL DEFAULT '1099511627775',
533 `sex` tinyint(1) NOT NULL DEFAULT '1',
534 `type` tinyint NOT NULL DEFAULT '0',
535 `phone` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
536 `email` varchar(90) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
537 `coins` bigint unsigned NOT NULL DEFAULT '0',
538 `since` datetime NOT NULL,
539 `block_reason` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
540 `verified` tinyint(1) NOT NULL DEFAULT '0',
541 `reputation` bigint NOT NULL DEFAULT '1000',
542 `shortcode` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
543 `registering_ip` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '127.0.0.1',
544 `online` bigint unsigned NOT NULL DEFAULT '0',
545 `birthday` bigint DEFAULT '0',
546 `hometown` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
547 `polit_views` int DEFAULT '0',
548 `marital_status` int DEFAULT '0',
549 `email_contact` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
550 `telegram` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
551 `interests` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
552 `fav_music` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
553 `fav_films` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
554 `fav_shows` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
555 `fav_books` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
556 `fav_quote` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
557 `city` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
558 `address` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
559 `style` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ovk',
560 `style_avatar` int DEFAULT '0',
561 `show_rating` tinyint(1) DEFAULT '1',
562 `milkshake` tinyint(1) NOT NULL DEFAULT '0',
563 `notification_offset` bigint unsigned DEFAULT '0',
564 `deleted` tinyint unsigned NOT NULL DEFAULT '0',
565 PRIMARY KEY (`id`),
566 UNIQUE KEY `phone` (`phone`),
567 UNIQUE KEY `email` (`email`),
568 UNIQUE KEY `shortcode` (`shortcode`),
569 KEY `user` (`user`)
570) ENGINE=Aria AUTO_INCREMENT=218 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
571/*!40101 SET character_set_client = @saved_cs_client */;
572
573--
574-- Table structure for table `sticker_relations`
575--
576
577DROP TABLE IF EXISTS `sticker_relations`;
578/*!40101 SET @saved_cs_client = @@character_set_client */;
579/*!50503 SET character_set_client = utf8mb4 */;
580CREATE TABLE `sticker_relations` (
581 `sticker` bigint unsigned NOT NULL,
582 `pack` bigint unsigned NOT NULL,
583 `index` bigint unsigned NOT NULL AUTO_INCREMENT,
584 PRIMARY KEY (`index`)
585) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
586/*!40101 SET character_set_client = @saved_cs_client */;
587
588--
589-- Table structure for table `stickerpacks`
590--
591
592DROP TABLE IF EXISTS `stickerpacks`;
593/*!40101 SET @saved_cs_client = @@character_set_client */;
594/*!50503 SET character_set_client = utf8mb4 */;
595CREATE TABLE `stickerpacks` (
596 `id` bigint unsigned NOT NULL AUTO_INCREMENT,
597 `slug` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
598 `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
599 `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
600 `sold` tinyint NOT NULL DEFAULT '0',
601 `price` bigint unsigned DEFAULT NULL,
602 PRIMARY KEY (`id`),
603 UNIQUE KEY `slug` (`slug`)
604) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
605/*!40101 SET character_set_client = @saved_cs_client */;
606
607--
608-- Table structure for table `stickers`
609--
610
611DROP TABLE IF EXISTS `stickers`;
612/*!40101 SET @saved_cs_client = @@character_set_client */;
613/*!50503 SET character_set_client = utf8mb4 */;
614CREATE TABLE `stickers` (
615 `id` bigint unsigned NOT NULL AUTO_INCREMENT,
616 `hash` char(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
617 `emojis` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
618 PRIMARY KEY (`id`),
619 UNIQUE KEY `hash` (`hash`)
620) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
621/*!40101 SET character_set_client = @saved_cs_client */;
622
623--
624-- Table structure for table `subscriptions`
625--
626
627DROP TABLE IF EXISTS `subscriptions`;
628/*!40101 SET @saved_cs_client = @@character_set_client */;
629/*!50503 SET character_set_client = utf8mb4 */;
630CREATE TABLE `subscriptions` (
631 `follower` bigint unsigned NOT NULL,
632 `model` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
633 `target` bigint unsigned NOT NULL
634) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
635/*!40101 SET character_set_client = @saved_cs_client */;
636
637--
638-- Table structure for table `tickets`
639--
640
641DROP TABLE IF EXISTS `tickets`;
642/*!40101 SET @saved_cs_client = @@character_set_client */;
643/*!50503 SET character_set_client = utf8mb4 */;
644CREATE TABLE `tickets` (
645 `id` bigint unsigned NOT NULL AUTO_INCREMENT,
646 `type` bigint unsigned NOT NULL,
647 `deleted` tinyint NOT NULL DEFAULT '0',
648 `user_id` bigint unsigned NOT NULL,
649 `name` tinytext NOT NULL,
650 `text` longtext NOT NULL,
651 `created` bigint unsigned NOT NULL,
652 PRIMARY KEY (`id`)
653) ENGINE=Aria AUTO_INCREMENT=65 DEFAULT CHARSET=utf8;
654/*!40101 SET character_set_client = @saved_cs_client */;
655
656--
657-- Table structure for table `tickets_comments`
658--
659
660DROP TABLE IF EXISTS `tickets_comments`;
661/*!40101 SET @saved_cs_client = @@character_set_client */;
662/*!50503 SET character_set_client = utf8mb4 */;
663CREATE TABLE `tickets_comments` (
664 `id` int NOT NULL AUTO_INCREMENT,
665 `user_id` bigint unsigned NOT NULL,
666 `user_type` int NOT NULL DEFAULT '0',
667 `text` longtext NOT NULL,
668 `created` int NOT NULL,
669 `deleted` tinyint NOT NULL DEFAULT '0',
670 `ticket_id` bigint DEFAULT NULL,
671 PRIMARY KEY (`id`)
672) ENGINE=Aria AUTO_INCREMENT=139 DEFAULT CHARSET=utf8;
673/*!40101 SET character_set_client = @saved_cs_client */;
674
675--
676-- Table structure for table `videos`
677--
678
679DROP TABLE IF EXISTS `videos`;
680/*!40101 SET @saved_cs_client = @@character_set_client */;
681/*!50503 SET character_set_client = utf8mb4 */;
682CREATE TABLE `videos` (
683 `id` bigint unsigned NOT NULL AUTO_INCREMENT,
684 `owner` bigint NOT NULL,
685 `virtual_id` bigint NOT NULL,
686 `created` bigint unsigned NOT NULL,
687 `edited` bigint unsigned DEFAULT NULL,
688 `hash` char(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
689 `link` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
690 `deleted` tinyint(1) NOT NULL DEFAULT '0',
691 `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
692 `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
693 PRIMARY KEY (`id`)
694) ENGINE=Aria AUTO_INCREMENT=79 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
695/*!40101 SET character_set_client = @saved_cs_client */;
696/*!50112 SET @disable_bulk_load = IF (@is_rocksdb_supported, 'SET SESSION rocksdb_bulk_load = @old_rocksdb_bulk_load', 'SET @dummy_rocksdb_bulk_load = 0') */;
697/*!50112 PREPARE s FROM @disable_bulk_load */;
698/*!50112 EXECUTE s */;
699/*!50112 DEALLOCATE PREPARE s */;
700/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
701
702/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
703/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
704/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
705/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
706/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
707/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
708/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
709
710-- Dump completed on 2020-07-10 14:09:02
711
712INSERT INTO `ChandlerGroups` VALUES ("a8ced6a3-49d8-11ea-bf2f-424d781d39ac", "OVK\Subteno", NULL);
713
714INSERT INTO `ChandlerACLRelations` VALUES ("ffffffff-ffff-ffff-ffff-ffffffffffff", "a8ced6a3-49d8-11ea-bf2f-424d781d39ac", 16);
715
716INSERT INTO `profiles` (`id`, `user`, `first_name`, `last_name`, `pseudo`, `info`, `about`, `status`, `privacy`, `left_menu`, `sex`, `type`, `phone`, `email`, `coins`, `since`, `block_reason`, `verified`, `reputation`, `shortcode`, `registering_ip`, `online`, `birthday`, `hometown`, `polit_views`, `marital_status`, `email_contact`, `telegram`, `interests`, `fav_music`, `fav_films`, `fav_shows`, `fav_books`, `fav_quote`, `city`, `address`, `style`, `style_avatar`, `show_rating`, `milkshake`, `notification_offset`, `deleted`) VALUES ('1', 'ffffffff-ffff-ffff-ffff-ffffffffffff', 'System', 'Administrator', 'sysop', NULL, NULL, NULL, '1099511627775', '1099511627775', '1', '0', NULL, 'admin@localhost.localdomain6', '0', '2018-10-31 15:15:15', NULL, '1', '1000', 'sysop', '::1', '0', '0', NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'ovk', '0', '0', '1', '0', '0');