FDQHZpBF

1SET FOREIGN_KEY_CHECKS=0;
2SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
3SET AUTOCOMMIT = 0;
4START TRANSACTION;
5SET time_zone = "+00:00";
6
7DROP TABLE IF EXISTS `albums`;
8CREATE TABLE IF NOT EXISTS `albums` (
9  `id` bigint(255) UNSIGNED NOT NULL AUTO_INCREMENT,
10  `owner` bigint(255) NOT NULL,
11  `title` varchar(255) COLLATE utf32_unicode_ci NOT NULL,
12  `desc` longtext COLLATE utf32_unicode_ci NOT NULL,
13  `photos` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
14  UNIQUE KEY `unique_id` (`id`)
15) ENGINE=MyISAM DEFAULT CHARSET=utf32 COLLATE=utf32_unicode_ci;
16
17DROP TABLE IF EXISTS `avatars`;
18CREATE TABLE IF NOT EXISTS `avatars` (
19  `owner` bigint(20) NOT NULL,
20  `filename` mediumtext COLLATE utf32_unicode_ci NOT NULL,
21  `filename_optimized` mediumtext COLLATE utf32_unicode_ci NOT NULL,
22  `filename_min` mediumtext COLLATE utf32_unicode_ci NOT NULL
23) ENGINE=MyISAM DEFAULT CHARSET=utf32 COLLATE=utf32_unicode_ci;
24
25DROP TABLE IF EXISTS `comments`;
26CREATE TABLE IF NOT EXISTS `comments` (
27  `id` bigint(255) UNSIGNED NOT NULL AUTO_INCREMENT,
28  `owner` bigint(255) NOT NULL,
29  `commentable_id` bigint(255) NOT NULL,
30  `commentable_type` mediumtext COLLATE utf32_unicode_ci NOT NULL,
31  `liked_by` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
32  `content` longtext COLLATE utf32_unicode_ci NOT NULL,
33  `date` timestamp NOT NULL DEFAULT current_timestamp(),
34  `edited` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
35  UNIQUE KEY `unique_id` (`id`)
36) ENGINE=MyISAM AVG_ROW_LENGTH=249 DEFAULT CHARSET=utf32 COLLATE=utf32_unicode_ci ROW_FORMAT=DYNAMIC;
37
38DROP TABLE IF EXISTS `conversations`;
39CREATE TABLE IF NOT EXISTS `conversations` (
40  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
41  `type` enum('chat','channel') COLLATE utf32_unicode_ci NOT NULL DEFAULT 'chat',
42  `talk_type` enum('textonly','voip','video') COLLATE utf32_unicode_ci NOT NULL DEFAULT 'textonly',
43  `admins` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
44  `participiants` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
45  `privacy_pragma` varchar(5) COLLATE utf32_unicode_ci NOT NULL DEFAULT 'aaaaa',
46  PRIMARY KEY (`id`)
47) ENGINE=MyISAM DEFAULT CHARSET=utf32 COLLATE=utf32_unicode_ci;
48
49DROP TABLE IF EXISTS `docs`;
50CREATE TABLE IF NOT EXISTS `docs` (
51  `id` bigint(255) UNSIGNED NOT NULL AUTO_INCREMENT,
52  `owner` bigint(255) NOT NULL,
53  `title` varchar(255) COLLATE utf32_unicode_ci NOT NULL,
54  `file` varchar(255) COLLATE utf32_unicode_ci NOT NULL,
55  UNIQUE KEY `unique_id` (`id`)
56) ENGINE=MyISAM DEFAULT CHARSET=utf32 COLLATE=utf32_unicode_ci;
57
58DROP TABLE IF EXISTS `files`;
59CREATE TABLE IF NOT EXISTS `files` (
60  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
61  `type` enum('document','photo','video','music','executable') COLLATE utf32_unicode_ci NOT NULL DEFAULT 'document',
62  `name` varchar(255) COLLATE utf32_unicode_ci NOT NULL DEFAULT 'Unnamed',
63  `owner` bigint(20) NOT NULL,
64  `description` longtext COLLATE utf32_unicode_ci NOT NULL,
65  `privacy_pragma` varchar(3) COLLATE utf32_unicode_ci NOT NULL DEFAULT 'aaa',
66  `extension` varchar(1024) COLLATE utf32_unicode_ci NOT NULL DEFAULT ' ',
67  PRIMARY KEY (`id`)
68) ENGINE=MyISAM DEFAULT CHARSET=utf32 COLLATE=utf32_unicode_ci;
69
70DROP TABLE IF EXISTS `followers`;
71CREATE TABLE IF NOT EXISTS `followers` (
72  `follower` bigint(20) UNSIGNED NOT NULL,
73  `target` bigint(20) NOT NULL
74) ENGINE=MyISAM AVG_ROW_LENGTH=17 DEFAULT CHARSET=utf32 COLLATE=utf32_unicode_ci;
75
76DROP TABLE IF EXISTS `gifts`;
77CREATE TABLE IF NOT EXISTS `gifts` (
78  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
79  `from` bigint(20) UNSIGNED NOT NULL,
80  `to` bigint(20) UNSIGNED NOT NULL,
81  `privacy_pragma` varchar(3) COLLATE utf32_unicode_ci NOT NULL DEFAULT 'aaa',
82  `type` enum('gift','stickerpack','money') COLLATE utf32_unicode_ci NOT NULL DEFAULT 'gift',
83  `coins` bigint(20) UNSIGNED DEFAULT NULL,
84  `gift_id` bigint(20) UNSIGNED DEFAULT NULL,
85  PRIMARY KEY (`id`)
86) ENGINE=MyISAM DEFAULT CHARSET=utf32 COLLATE=utf32_unicode_ci;
87
88DROP TABLE IF EXISTS `gift_list`;
89CREATE TABLE IF NOT EXISTS `gift_list` (
90  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
91  `suggested` longtext COLLATE utf32_unicode_ci DEFAULT NULL,
92  PRIMARY KEY (`id`)
93) ENGINE=MyISAM DEFAULT CHARSET=utf32 COLLATE=utf32_unicode_ci ROW_FORMAT=DYNAMIC;
94
95DROP TABLE IF EXISTS `groups`;
96CREATE TABLE IF NOT EXISTS `groups` (
97  `id` bigint(20) NOT NULL AUTO_INCREMENT,
98  `name` varchar(50) COLLATE utf32_unicode_ci NOT NULL,
99  `info` longtext COLLATE utf32_unicode_ci NOT NULL,
100  `about` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
101  `created` datetime NOT NULL DEFAULT current_timestamp(),
102  `status` varchar(255) COLLATE utf32_unicode_ci NOT NULL,
103  `privacy_pragma` varchar(27) COLLATE utf32_unicode_ci NOT NULL DEFAULT 'aaaaaaaaaaaaaaaaaaaaaaaaaaa',
104  `verified` enum('verified','no') COLLATE utf32_unicode_ci NOT NULL DEFAULT 'verified',
105  `owner` bigint(20) UNSIGNED DEFAULT NULL,
106  `type` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
107  `coadmins` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
108  PRIMARY KEY (`id`)
109) ENGINE=MyISAM AVG_ROW_LENGTH=266 DEFAULT CHARSET=utf32 COLLATE=utf32_unicode_ci;
110
111DROP TABLE IF EXISTS `messages`;
112CREATE TABLE IF NOT EXISTS `messages` (
113  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
114  `owner` bigint(20) NOT NULL,
115  `to` bigint(20) NOT NULL,
116  `edited` datetime NOT NULL,
117  `liked_by` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
118  `attachments` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
119  `type` enum('text','invite','sticker','audio') COLLATE utf32_unicode_ci NOT NULL,
120  `conversation_id` bigint(20) UNSIGNED DEFAULT NULL,
121  `content` longtext COLLATE utf32_unicode_ci NOT NULL,
122  PRIMARY KEY (`id`)
123) ENGINE=MyISAM DEFAULT CHARSET=utf32 COLLATE=utf32_unicode_ci ROW_FORMAT=DYNAMIC;
124
125DROP TABLE IF EXISTS `music`;
126CREATE TABLE IF NOT EXISTS `music` (
127  `id` bigint(255) UNSIGNED NOT NULL AUTO_INCREMENT,
128  `owner` bigint(255) NOT NULL,
129  `title` varchar(255) COLLATE utf32_unicode_ci NOT NULL,
130  `lyrics` longtext COLLATE utf32_unicode_ci NOT NULL,
131  `nsfw` bit(1) NOT NULL,
132  `file` varchar(255) COLLATE utf32_unicode_ci NOT NULL,
133  UNIQUE KEY `unique_id` (`id`)
134) ENGINE=MyISAM DEFAULT CHARSET=utf32 COLLATE=utf32_unicode_ci;
135
136DROP TABLE IF EXISTS `photos`;
137CREATE TABLE IF NOT EXISTS `photos` (
138  `id` bigint(255) UNSIGNED NOT NULL AUTO_INCREMENT,
139  `owner` bigint(255) NOT NULL,
140  `desc` longtext COLLATE utf32_unicode_ci NOT NULL,
141  `nsfw` bit(1) NOT NULL,
142  `file` varchar(255) COLLATE utf32_unicode_ci NOT NULL,
143  UNIQUE KEY `unique_id` (`id`)
144) ENGINE=MyISAM DEFAULT CHARSET=utf32 COLLATE=utf32_unicode_ci;
145
146DROP TABLE IF EXISTS `posts`;
147CREATE TABLE IF NOT EXISTS `posts` (
148  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
149  `owner` bigint(20) NOT NULL,
150  `liked_by` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
151  `edited` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
152  `attachments` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
153  `content` longtext COLLATE utf32_unicode_ci NOT NULL,
154  `target` bigint(255) NOT NULL,
155  `date` timestamp NOT NULL DEFAULT current_timestamp(),
156  PRIMARY KEY (`id`)
157) ENGINE=MyISAM AVG_ROW_LENGTH=150 DEFAULT CHARSET=utf32 COLLATE=utf32_unicode_ci ROW_FORMAT=DYNAMIC;
158
159DROP TABLE IF EXISTS `stickerpacks`;
160CREATE TABLE IF NOT EXISTS `stickerpacks` (
161  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
162  `name` varchar(255) COLLATE utf32_unicode_ci NOT NULL,
163  `description` longtext COLLATE utf32_unicode_ci NOT NULL,
164  `price` bigint(20) UNSIGNED DEFAULT NULL,
165  `owner` bigint(20) DEFAULT NULL,
166  PRIMARY KEY (`id`)
167) ENGINE=MyISAM DEFAULT CHARSET=utf32 COLLATE=utf32_unicode_ci;
168
169DROP TABLE IF EXISTS `stickers`;
170CREATE TABLE IF NOT EXISTS `stickers` (
171  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
172  `stickerpack` bigint(255) UNSIGNED NOT NULL,
173  `replaces` longtext COLLATE utf32_unicode_ci DEFAULT NULL,
174  `type` enum('image','video') COLLATE utf32_unicode_ci NOT NULL DEFAULT 'image',
175  PRIMARY KEY (`id`)
176) ENGINE=MyISAM DEFAULT CHARSET=utf32 COLLATE=utf32_unicode_ci ROW_FORMAT=DYNAMIC;
177
178DROP TABLE IF EXISTS `tokens`;
179CREATE TABLE IF NOT EXISTS `tokens` (
180  `user` bigint(255) NOT NULL,
181  `ip` varchar(255) COLLATE utf32_unicode_ci NOT NULL,
182  `token` longtext COLLATE utf32_unicode_ci NOT NULL
183) ENGINE=InnoDB AVG_ROW_LENGTH=963 DEFAULT CHARSET=utf32 COLLATE=utf32_unicode_ci;
184
185DROP TABLE IF EXISTS `users`;
186CREATE TABLE IF NOT EXISTS `users` (
187  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
188  `first_name` varchar(50) COLLATE utf32_unicode_ci NOT NULL DEFAULT 'Jane',
189  `last_name` varchar(50) COLLATE utf32_unicode_ci NOT NULL DEFAULT 'Doe',
190  `pseudo` varchar(50) COLLATE utf32_unicode_ci NOT NULL DEFAULT ' ',
191  `info` longtext COLLATE utf32_unicode_ci DEFAULT NULL,
192  `about` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
193  `status` varchar(255) COLLATE utf32_unicode_ci NOT NULL DEFAULT ' ',
194  `now_listening` bigint(20) UNSIGNED NOT NULL,
195  `is_talking` enum('talking','no') COLLATE utf32_unicode_ci NOT NULL DEFAULT 'no',
196  `role` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
197  `privacy_pragma` varchar(28) COLLATE utf32_unicode_ci NOT NULL DEFAULT 'aaaaaaaaaaaaaaaaaaaaaaaaaaaa',
198  `sex` set('female','male') COLLATE utf32_unicode_ci NOT NULL DEFAULT 'female',
199  `type` enum('bot','sysent','default') COLLATE utf32_unicode_ci NOT NULL DEFAULT 'default',
200  `phone` int(11) NOT NULL,
201  `email` varchar(50) COLLATE utf32_unicode_ci NOT NULL,
202  `coins` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
203  `last_action` datetime NOT NULL DEFAULT current_timestamp(),
204  `last_device` enum('pc','tablet','mobile','nojs','embedded','car','gameconsole','term','tv','player') COLLATE utf32_unicode_ci NOT NULL DEFAULT 'pc',
205  `since` datetime NOT NULL DEFAULT current_timestamp(),
206  `blacklist` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
207  `blocked` enum('totally','partial','no') COLLATE utf32_unicode_ci NOT NULL DEFAULT 'no',
208  `block_reason` tinytext COLLATE utf32_unicode_ci DEFAULT NULL,
209  `dead` enum('dead','no') COLLATE utf32_unicode_ci NOT NULL DEFAULT 'no',
210  `verified` enum('verified','no') COLLATE utf32_unicode_ci NOT NULL DEFAULT 'no',
211  `css` text COLLATE utf32_unicode_ci DEFAULT NULL,
212  `achievments` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
213  `reputation` bigint(20) NOT NULL DEFAULT 1000,
214  `people_reach` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
215  `login` varchar(11) COLLATE utf32_unicode_ci NOT NULL,
216  `password_hash` varchar(255) COLLATE utf32_unicode_ci NOT NULL,
217  PRIMARY KEY (`id`)
218) ENGINE=MyISAM AVG_ROW_LENGTH=866 DEFAULT CHARSET=utf32 COLLATE=utf32_unicode_ci;
219
220DROP TABLE IF EXISTS `videos`;
221CREATE TABLE IF NOT EXISTS `videos` (
222  `id` bigint(255) UNSIGNED NOT NULL AUTO_INCREMENT,
223  `owner` bigint(255) NOT NULL,
224  `title` varchar(255) COLLATE utf32_unicode_ci NOT NULL,
225  `desc` longtext COLLATE utf32_unicode_ci NOT NULL,
226  `nsfw` bit(1) NOT NULL,
227  `file` varchar(255) COLLATE utf32_unicode_ci NOT NULL,
228  UNIQUE KEY `unique_id` (`id`)
229) ENGINE=MyISAM DEFAULT CHARSET=utf32 COLLATE=utf32_unicode_ci;
230
231DROP TABLE IF EXISTS `__ov4config`;
232CREATE TABLE IF NOT EXISTS `__ov4config` (
233  `key` varchar(125) COLLATE utf32_unicode_ci NOT NULL,
234  `value` varchar(1024) COLLATE utf32_unicode_ci NOT NULL,
235  `desc` text COLLATE utf32_unicode_ci NOT NULL
236) ENGINE=MyISAM DEFAULT CHARSET=utf32 COLLATE=utf32_unicode_ci;
237SET FOREIGN_KEY_CHECKS=1;
238COMMIT;