· 6 years ago · Feb 22, 2019, 08:42 PM
1-- phpMyAdmin SQL Dump
2-- version 4.8.2
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1
6-- Generation Time: 14-Nov-2018 Ã s 14:57
7-- Versão do servidor: 10.1.34-MariaDB
8-- PHP Version: 7.2.8
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Database: `twidley`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Estrutura da tabela `so_comments`
29--
30
31CREATE TABLE `so_comments` (
32 `comment_id` int(20) NOT NULL,
33 `post_id` int(20) NOT NULL,
34 `user_id` int(20) NOT NULL,
35 `postText` text,
36 `postFile` varchar(180) DEFAULT NULL,
37 `postImage` varchar(180) DEFAULT NULL,
38 `postVideo` varchar(180) DEFAULT NULL,
39 `postGif` varchar(180) DEFAULT NULL,
40 `postSticker` varchar(180) DEFAULT NULL,
41 `postYoutube` varchar(150) DEFAULT NULL,
42 `time` int(11) NOT NULL,
43 `day` int(2) NOT NULL,
44 `month` int(2) NOT NULL,
45 `year` int(4) NOT NULL,
46 `hour` varchar(10) NOT NULL
47) ENGINE=InnoDB DEFAULT CHARSET=utf8;
48
49-- --------------------------------------------------------
50
51--
52-- Estrutura da tabela `so_comments_like`
53--
54
55CREATE TABLE `so_comments_like` (
56 `id` int(20) NOT NULL,
57 `post_id` int(20) NOT NULL,
58 `user_id` int(20) NOT NULL,
59 `comment_id` int(20) NOT NULL,
60 `time` int(11) NOT NULL
61) ENGINE=InnoDB DEFAULT CHARSET=utf8;
62
63-- --------------------------------------------------------
64
65--
66-- Estrutura da tabela `so_config`
67--
68
69CREATE TABLE `so_config` (
70 `id` int(11) NOT NULL,
71 `name` varchar(100) NOT NULL,
72 `value` text
73) ENGINE=InnoDB DEFAULT CHARSET=utf8;
74
75--
76-- Extraindo dados da tabela `so_config`
77--
78
79INSERT INTO `so_config` (`id`, `name`, `value`) VALUES
80(1, 'site_name', 'Twidley'),
81(2, 'theme', 'olympus'),
82(3, 'maintenance_mode', '0'),
83(4, 'language', 'en-US'),
84(5, 'smtp_host', ''),
85(6, 'smtp_email', ''),
86(7, 'smtp_password', ''),
87(8, 'google_map_api', 'AIzaSyBOfpaMO_tMMsuvS2T4zx4llbtsFqMuT9Y'),
88(9, 'giphy_api', '4fwnD2DNjILnxLWvgkqPamI7ceP8VOUB'),
89(10, 'yandex_api', 'trnsl.1.1.20180713T194926Z.f1af20bec26c804d.57873b89711db04b2ae53054b5d05adbaeec18db'),
90(12, 'version', '2.0.1'),
91(14, 'app_token', ''),
92(15, 'amazon_s3', '0'),
93(16, 'amazon_s3_key', '0'),
94(17, 'amazon_s3_s_key', '0'),
95(18, 'bucket_amazon_name', '0'),
96(19, 'region', 'us-east-1'),
97(20, 'message_alert', ''),
98(21, 'live_stream', '0'),
99(22, 'live_stream_all_users', '0'),
100(23, 'adsense', '0'),
101(24, 'client_id', ''),
102(25, 'secret', ''),
103(26, 'color_box', '1'),
104(27, 'type_button', 'reactions'),
105(28, 'floopz_music', '1'),
106(29, 'moments', '1'),
107(30, 'search_background', '#00b3a2'),
108(31, 'border_search_background', '#00a797'),
109(32, 'header_background', '#00a796'),
110(33, 'header_background_two', '#009688'),
111(34, 'cover_background', '#02d0bb'),
112(35, 'border_button', '#009688'),
113(36, 'color_text_button', '#009688'),
114(37, 'color_link', '#009688'),
115(38, 'color_total_notifications', '#009688'),
116(39, 'color_border', '#009688'),
117(40, 'websocket', '0'),
118(39, 'site_port', '3000');
119
120-- --------------------------------------------------------
121
122--
123-- Estrutura da tabela `so_emoticons`
124--
125
126CREATE TABLE `so_emoticons` (
127 `id` int(11) NOT NULL,
128 `key` varchar(30) NOT NULL
129) ENGINE=InnoDB DEFAULT CHARSET=utf8;
130
131--
132-- Extraindo dados da tabela `so_emoticons`
133--
134
135INSERT INTO `so_emoticons` (`id`, `key`) VALUES
136(1, '1f600'),
137(2, '263a'),
138(3, '1f970'),
139(4, '1f601');
140
141-- --------------------------------------------------------
142
143--
144-- Estrutura da tabela `so_followers`
145--
146
147CREATE TABLE `so_followers` (
148 `id` int(20) NOT NULL,
149 `from_id` int(20) NOT NULL,
150 `to_id` int(20) NOT NULL,
151 `active` int(1) NOT NULL DEFAULT '1',
152 `privacy` int(1) NOT NULL DEFAULT '1'
153) ENGINE=InnoDB DEFAULT CHARSET=utf8;
154
155-- --------------------------------------------------------
156
157--
158-- Estrutura da tabela `so_hashtags`
159--
160
161CREATE TABLE `so_hashtags` (
162 `id` int(11) NOT NULL,
163 `hash` varchar(255) NOT NULL DEFAULT '',
164 `tag` varchar(255) NOT NULL DEFAULT '',
165 `last_trend_time` int(11) NOT NULL DEFAULT '0',
166 `trend_use_num` int(11) NOT NULL DEFAULT '0',
167 `expire` date DEFAULT NULL
168) ENGINE=InnoDB DEFAULT CHARSET=utf8;
169
170-- --------------------------------------------------------
171
172--
173-- Estrutura da tabela `so_like`
174--
175
176CREATE TABLE `so_like` (
177 `id` int(11) NOT NULL,
178 `user_id` int(11) NOT NULL,
179 `post_id` int(11) NOT NULL,
180 `time` int(11) NOT NULL
181) ENGINE=InnoDB DEFAULT CHARSET=utf8;
182
183-- --------------------------------------------------------
184
185--
186-- Estrutura da tabela `so_messages`
187--
188
189CREATE TABLE `so_messages` (
190 `id` int(20) NOT NULL,
191 `from_id` int(20) NOT NULL,
192 `to_id` int(20) NOT NULL,
193 `postText` text,
194 `postFile` varchar(180) DEFAULT NULL,
195 `postImage` varchar(180) DEFAULT NULL,
196 `postVideo` varchar(180) DEFAULT NULL,
197 `postGif` varchar(180) DEFAULT NULL,
198 `postSticker` varchar(180) DEFAULT NULL,
199 `postYoutube` varchar(150) DEFAULT NULL,
200 `time` int(11) NOT NULL,
201 `day` int(2) NOT NULL,
202 `month` int(2) NOT NULL,
203 `year` int(4) NOT NULL,
204 `hour` varchar(10) NOT NULL,
205 `seen` int(1) NOT NULL DEFAULT '0',
206 `deleted_one` int(1) NOT NULL,
207 `deleted_two` int(1) NOT NULL
208) ENGINE=InnoDB DEFAULT CHARSET=utf8;
209
210-- --------------------------------------------------------
211
212--
213-- Estrutura da tabela `so_notifications`
214--
215
216CREATE TABLE `so_notifications` (
217 `id` int(20) NOT NULL,
218 `comment_id` int(20) NOT NULL,
219 `post_id` int(20) NOT NULL,
220 `user_id` int(20) NOT NULL,
221 `to_id` int(20) DEFAULT NULL,
222 `type` varchar(120) NOT NULL,
223 `time` int(11) NOT NULL,
224 `day` int(2) NOT NULL,
225 `month` int(2) NOT NULL,
226 `year` int(4) NOT NULL,
227 `seen` int(1) NOT NULL DEFAULT '0'
228) ENGINE=InnoDB DEFAULT CHARSET=utf8;
229
230-- --------------------------------------------------------
231
232--
233-- Estrutura da tabela `so_open_chats`
234--
235
236CREATE TABLE `so_open_chats` (
237 `id` int(11) NOT NULL,
238 `from_id` int(11) NOT NULL,
239 `to_id` int(11) NOT NULL,
240 `time` int(11) NOT NULL
241) ENGINE=InnoDB DEFAULT CHARSET=utf8;
242
243-- --------------------------------------------------------
244
245--
246-- Estrutura da tabela `so_posts`
247--
248
249CREATE TABLE `so_posts` (
250 `post_id` int(20) NOT NULL,
251 `user_id` int(20) NOT NULL,
252 `postText` text,
253 `postFile` varchar(180) DEFAULT NULL,
254 `postImage` varchar(180) DEFAULT NULL,
255 `postVideo` varchar(180) DEFAULT NULL,
256 `postGif` varchar(180) DEFAULT NULL,
257 `postSticker` varchar(180) DEFAULT NULL,
258 `postType` varchar(35) DEFAULT NULL,
259 `postYoutube` varchar(150) DEFAULT NULL,
260 `time` int(11) NOT NULL,
261 `day` int(2) NOT NULL,
262 `month` int(2) NOT NULL,
263 `year` int(4) NOT NULL,
264 `hour` varchar(10) NOT NULL,
265 `share_id` int(30) NOT NULL,
266 `amazon` int(1) NOT NULL,
267 `html_title` varchar(180) DEFAULT NULL,
268 `html_image` varchar(180) DEFAULT NULL,
269 `html_body` text,
270 `html_url` varchar(180) DEFAULT NULL,
271 `background` varchar(180) DEFAULT NULL,
272 `titleMoment` varchar(180) DEFAULT NULL,
273 `categoryMoment` int(1) DEFAULT NULL
274) ENGINE=InnoDB DEFAULT CHARSET=utf8;
275
276-- --------------------------------------------------------
277
278--
279-- Estrutura da tabela `so_reactions`
280--
281
282CREATE TABLE `so_reactions` (
283 `id` int(20) NOT NULL,
284 `from_id` int(20) NOT NULL,
285 `to_id` int(20) NOT NULL,
286 `post_id` int(20) NOT NULL,
287 `comment_id` int(20) NOT NULL,
288 `type` varchar(25) NOT NULL DEFAULT 'reaction_like'
289) ENGINE=InnoDB DEFAULT CHARSET=utf8;
290
291-- --------------------------------------------------------
292
293--
294-- Estrutura da tabela `so_stickers`
295--
296
297CREATE TABLE `so_stickers` (
298 `id` int(20) NOT NULL,
299 `sticker_id` int(20) NOT NULL,
300 `image` varchar(180) NOT NULL
301) ENGINE=InnoDB DEFAULT CHARSET=utf8;
302
303--
304-- Extraindo dados da tabela `so_stickers`
305--
306
307INSERT INTO `so_stickers` (`id`, `sticker_id`, `image`) VALUES
308(2, 2, 'upload/stickers/Meep/1322665222_13_b29824d15b945e7d8287108108271933.png'),
309(3, 2, 'upload/stickers/Meep/586484157_13_318dea1d08766dffed30af8f1221967b.png'),
310(4, 2, 'upload/stickers/Meep/1868840101_13_4d88bf9fdc530a09ff231ae8e6bc8183.png'),
311(5, 2, 'upload/stickers/Meep/952055133_13_60d2d8f4c7860a4604c027ab8259f326.png'),
312(6, 2, 'upload/stickers/Meep/196758538_13_dcffbe7eb57abc0036a10ec1ebc8e063.png'),
313(7, 2, 'upload/stickers/Meep/1569651652_13_48f6a086683f1942459193e41464ec2e.png'),
314(8, 2, 'upload/stickers/Meep/39902901_13_3f041ad4e19c74007609f7c2277efdfd.png'),
315(9, 2, 'upload/stickers/Meep/1077261031_13_d05ef2283fa3d5daeb208c5a4522036f.png'),
316(10, 2, 'upload/stickers/Meep/1559817737_13_36d247b54c8cf773304644a276fdad40.png'),
317(11, 2, 'upload/stickers/Meep/149957007_13_b2db84c87330fe8ffd1015b9258eca8a.png'),
318(12, 2, 'upload/stickers/Meep/1752734396_13_801e1d8de4f23b641e3c216c50dc031a.png'),
319(13, 2, 'upload/stickers/Meep/1361805912_13_d1ee711a8492281739fda1ba3973285c.png'),
320(14, 2, 'upload/stickers/Meep/740023459_13_dfd6d5df2da3e4fb7ec0b8239b0cd206.png'),
321(15, 2, 'upload/stickers/Meep/26601173_13_3767ce721ef453269e8cb971c1554999.png'),
322(16, 2, 'upload/stickers/Meep/470575373_13_22d58c028c74cc22e7d0d1cbf77a4c49.png'),
323(17, 2, 'upload/stickers/Meep/1554185141_13_dde27f2c3b478a109c4d7194700fd9f0.png'),
324(18, 2, 'upload/stickers/Meep/30394001_13_8e20ab44bd46c76139bdb44094ee235a.png'),
325(19, 2, 'upload/stickers/Meep/430771469_13_c6ca1908287574796f5a6cad015d2050.png'),
326(20, 2, 'upload/stickers/Meep/40784468_13_c1588f80d568fdb33f5e2fecb8f167e1.png'),
327(21, 2, 'upload/stickers/Meep/2086329646_13_a4a69fe7346cd658c0b2e798f4ec74e9.png'),
328(22, 2, 'upload/stickers/Meep/1714519003_13_862768f5a51388c2e938d6d061fbbe38.png'),
329(23, 2, 'upload/stickers/Meep/1921662295_13_6e7b952e1969e4b14a7d413a464b98ee.png'),
330(24, 2, 'upload/stickers/Meep/405940528_13_805232e2b438d8bc3b3ada7001f5786d.png'),
331(25, 2, 'upload/stickers/Meep/1997258228_13_c27f1902c011c1336a8eb1aebaa76972.png'),
332(26, 2, 'upload/stickers/Meep/831209899_13_7d98eafca6fa25a446e368c37534ad47.png'),
333(27, 2, 'upload/stickers/Meep/161287325_13_5be257e83037a184b2b63d5e9c7cf055.png'),
334(28, 2, 'upload/stickers/Meep/298075945_13_48745a6c9de35d2604f28a784efa9c37.png'),
335(29, 2, 'upload/stickers/Meep/51333695_13_d5500a65fe21549a9a859cde069a71d2.png'),
336(30, 2, 'upload/stickers/Meep/956900276_13_e7d63279276a9dfdd419da5101f607e9.png'),
337(31, 2, 'upload/stickers/Meep/1863233275_13_8a4f46d30bb20de5e3d103aa098f55f4.png'),
338(32, 2, 'upload/stickers/Meep/1172758260_13_14eb2e3349165de85f464450e591f0b3.png'),
339(33, 2, 'upload/stickers/Meep/833684770_13_1342fb652eb94a73ddf3049f031a6f0c.png'),
340(34, 3, 'upload/stickers/TontonFriendsToo/466357797_14_9365b5c800de2f726533e72ee2e4d2bf.png'),
341(35, 3, 'upload/stickers/TontonFriendsToo/1560616177_14_a13deafcd83cfb221db5c247becf2f24.png'),
342(36, 3, 'upload/stickers/TontonFriendsToo/1337551180_14_6d43197e76f3c42d762d7d73763b34d8.png'),
343(37, 3, 'upload/stickers/TontonFriendsToo/484501143_14_57c8ff0370ec3c6de3e7910e95e109eb.png'),
344(38, 3, 'upload/stickers/TontonFriendsToo/406664866_14_e795fc965f0548e59e4aa4308a4422a1.png'),
345(39, 3, 'upload/stickers/TontonFriendsToo/1466917631_14_42f0b99d2a030a1bb3731eb8402a7bc4.png'),
346(40, 3, 'upload/stickers/TontonFriendsToo/1770869003_14_7fc06502649a14463b424e1a904db0bc.png'),
347(41, 3, 'upload/stickers/TontonFriendsToo/879527121_14_6cbcf87cfde7d7e8d4132fcc54e28280.png'),
348(42, 3, 'upload/stickers/TontonFriendsToo/1258869158_14_65a9304908b4c711bc19f418d82d67e3.png'),
349(43, 3, 'upload/stickers/TontonFriendsToo/152793202_14_d599a2fffc4f930f8ec0a669d60ba634.png'),
350(44, 3, 'upload/stickers/TontonFriendsToo/1969879844_14_88bbf4b11705cd151fba977badffccd9.png'),
351(45, 3, 'upload/stickers/TontonFriendsToo/2030762461_14_10b4d4f44e1c185331fc55f58e5b1810.png'),
352(46, 3, 'upload/stickers/TontonFriendsToo/1617150548_14_cf33de86247bebbafd4a24d32b080ea5.png'),
353(47, 3, 'upload/stickers/TontonFriendsToo/1086581306_14_6c65041926ea1c1ffead2615d89c35b0.png'),
354(48, 3, 'upload/stickers/TontonFriendsToo/264615720_14_7ba3152cb60308928080df95f81e77a5.png'),
355(49, 3, 'upload/stickers/TontonFriendsToo/850145785_14_1f0d3b6f3d280a1994e32f5c9e0ade1d.png'),
356(50, 3, 'upload/stickers/TontonFriendsToo/1200260758_14_771f00ff35a560605ed1c92bf77cf9ad.png'),
357(51, 3, 'upload/stickers/TontonFriendsToo/480222251_14_be42deacde052985d45049890ceafd30.png'),
358(52, 3, 'upload/stickers/TontonFriendsToo/1214193499_14_4a4a03484a27eaaf24a017399d676436.png'),
359(53, 3, 'upload/stickers/TontonFriendsToo/12171087_14_c7da0667c0dfbc20a2b939463a67cb11.png'),
360(54, 3, 'upload/stickers/TontonFriendsToo/503156655_14_b52d1e10b6ea0aa3c4e070e2fd4e6acb.png'),
361(55, 3, 'upload/stickers/TontonFriendsToo/1451451430_14_929315fd6d385e5af3341b929fbcb561.png'),
362(56, 3, 'upload/stickers/TontonFriendsToo/487825433_14_24390d58aadb36796513d3298f0b5913.png'),
363(57, 3, 'upload/stickers/TontonFriendsToo/1665180135_14_f9e809b8f5b12cb7be7edf1374a210dc.png');
364
365-- --------------------------------------------------------
366
367--
368-- Estrutura da tabela `so_stickers_store`
369--
370
371CREATE TABLE `so_stickers_store` (
372 `id` int(20) NOT NULL,
373 `name` varchar(150) NOT NULL,
374 `image` varchar(180) NOT NULL
375) ENGINE=InnoDB DEFAULT CHARSET=utf8;
376
377--
378-- Extraindo dados da tabela `so_stickers_store`
379--
380
381INSERT INTO `so_stickers_store` (`id`, `name`, `image`) VALUES
382(2, 'Meep', 'upload/stickers/697284939_13_559e8cfd7b90727e92b775746f6b5e6c.png'),
383(3, 'Tonton Friends Too', 'upload/stickers/1364604229_14_f7f6adcac0711a87b7a861147812eea8_sticker.png');
384
385-- --------------------------------------------------------
386
387--
388-- Estrutura da tabela `so_users`
389--
390
391CREATE TABLE `so_users` (
392 `user_id` int(20) NOT NULL,
393 `username` varchar(60) NOT NULL,
394 `email` varchar(150) NOT NULL,
395 `phone_number` varchar(20) DEFAULT NULL,
396 `password` varchar(160) NOT NULL,
397 `first_name` varchar(100) NOT NULL,
398 `last_name` varchar(100) NOT NULL,
399 `avatar` varchar(180) NOT NULL DEFAULT 'upload/images/d-avatar.png',
400 `cover` varchar(180) NOT NULL,
401 `about` text,
402 `language` varchar(10) NOT NULL DEFAULT 'en-US',
403 `gender` varchar(11) NOT NULL DEFAULT 'male',
404 `day` int(2) NOT NULL,
405 `month` int(2) NOT NULL,
406 `year` int(4) NOT NULL,
407 `location` varchar(150) DEFAULT NULL,
408 `registered_day` int(2) NOT NULL,
409 `registered_month` int(2) NOT NULL,
410 `registered_year` int(4) NOT NULL,
411 `lastseen` int(11) NOT NULL,
412 `auto_message` text,
413 `ip_address` varchar(30) NOT NULL,
414 `active` int(1) NOT NULL DEFAULT '0',
415 `token_active` varchar(160) DEFAULT NULL,
416 `privacy` int(1) NOT NULL DEFAULT '1',
417 `country` varchar(20) NOT NULL DEFAULT 'Brazil',
418 `admin` int(1) NOT NULL DEFAULT '0',
419 `verified` int(1) NOT NULL DEFAULT '0',
420 `amazon_avatar` int(1) NOT NULL,
421 `amazon_cover` int(1) NOT NULL,
422 `connected_via` varchar(32) NOT NULL DEFAULT 'pc',
423 `secret_key` varchar(80) DEFAULT NULL,
424 `all_posts` int(1) NOT NULL DEFAULT '0'
425) ENGINE=InnoDB DEFAULT CHARSET=utf8;
426
427-- --------------------------------------------------------
428
429--
430-- Estrutura da tabela `so_user_stickers`
431--
432
433CREATE TABLE `so_user_stickers` (
434 `id` int(20) NOT NULL,
435 `sticker_id` int(20) NOT NULL,
436 `user_id` int(20) NOT NULL
437) ENGINE=InnoDB DEFAULT CHARSET=utf8;
438
439--
440-- Indexes for dumped tables
441--
442
443--
444-- Indexes for table `so_comments`
445--
446ALTER TABLE `so_comments`
447 ADD PRIMARY KEY (`comment_id`);
448
449--
450-- Indexes for table `so_comments_like`
451--
452ALTER TABLE `so_comments_like`
453 ADD PRIMARY KEY (`id`);
454
455--
456-- Indexes for table `so_config`
457--
458-- ALTER TABLE `so_config`
459-- ADD PRIMARY KEY (`id`);
460
461--
462-- Indexes for table `so_emoticons`
463--
464ALTER TABLE `so_emoticons`
465 ADD PRIMARY KEY (`id`);
466
467--
468-- Indexes for table `so_followers`
469--
470ALTER TABLE `so_followers`
471 ADD PRIMARY KEY (`id`);
472
473--
474-- Indexes for table `so_hashtags`
475--
476ALTER TABLE `so_hashtags`
477 ADD PRIMARY KEY (`id`),
478 ADD KEY `last_trend_time` (`last_trend_time`),
479 ADD KEY `trend_use_num` (`trend_use_num`),
480 ADD KEY `tag` (`tag`),
481 ADD KEY `expire` (`expire`);
482
483--
484-- Indexes for table `so_like`
485--
486ALTER TABLE `so_like`
487 ADD PRIMARY KEY (`id`);
488
489--
490-- Indexes for table `so_messages`
491--
492ALTER TABLE `so_messages`
493 ADD PRIMARY KEY (`id`);
494
495--
496-- Indexes for table `so_notifications`
497--
498ALTER TABLE `so_notifications`
499 ADD PRIMARY KEY (`id`);
500
501--
502-- Indexes for table `so_open_chats`
503--
504ALTER TABLE `so_open_chats`
505 ADD PRIMARY KEY (`id`);
506
507--
508-- Indexes for table `so_posts`
509--
510ALTER TABLE `so_posts`
511 ADD PRIMARY KEY (`post_id`);
512
513--
514-- Indexes for table `so_reactions`
515--
516ALTER TABLE `so_reactions`
517 ADD PRIMARY KEY (`id`);
518
519--
520-- Indexes for table `so_stickers`
521--
522ALTER TABLE `so_stickers`
523 ADD PRIMARY KEY (`id`);
524
525--
526-- Indexes for table `so_stickers_store`
527--
528ALTER TABLE `so_stickers_store`
529 ADD PRIMARY KEY (`id`);
530
531--
532-- Indexes for table `so_users`
533--
534ALTER TABLE `so_users`
535 ADD PRIMARY KEY (`user_id`);
536
537--
538-- Indexes for table `so_user_stickers`
539--
540ALTER TABLE `so_user_stickers`
541 ADD PRIMARY KEY (`id`);
542
543--
544-- AUTO_INCREMENT for dumped tables
545--
546
547--
548-- AUTO_INCREMENT for table `so_comments`
549--
550ALTER TABLE `so_comments`
551 MODIFY `comment_id` int(20) NOT NULL AUTO_INCREMENT;
552
553--
554-- AUTO_INCREMENT for table `so_comments_like`
555--
556ALTER TABLE `so_comments_like`
557 MODIFY `id` int(20) NOT NULL AUTO_INCREMENT;
558
559--
560-- AUTO_INCREMENT for table `so_config`
561--
562ALTER TABLE `so_config`
563 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;
564
565--
566-- AUTO_INCREMENT for table `so_emoticons`
567--
568ALTER TABLE `so_emoticons`
569 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
570
571--
572-- AUTO_INCREMENT for table `so_followers`
573--
574ALTER TABLE `so_followers`
575 MODIFY `id` int(20) NOT NULL AUTO_INCREMENT;
576
577--
578-- AUTO_INCREMENT for table `so_hashtags`
579--
580ALTER TABLE `so_hashtags`
581 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
582
583--
584-- AUTO_INCREMENT for table `so_like`
585--
586ALTER TABLE `so_like`
587 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
588
589--
590-- AUTO_INCREMENT for table `so_messages`
591--
592ALTER TABLE `so_messages`
593 MODIFY `id` int(20) NOT NULL AUTO_INCREMENT;
594
595--
596-- AUTO_INCREMENT for table `so_notifications`
597--
598ALTER TABLE `so_notifications`
599 MODIFY `id` int(20) NOT NULL AUTO_INCREMENT;
600
601--
602-- AUTO_INCREMENT for table `so_open_chats`
603--
604ALTER TABLE `so_open_chats`
605 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
606
607--
608-- AUTO_INCREMENT for table `so_posts`
609--
610ALTER TABLE `so_posts`
611 MODIFY `post_id` int(20) NOT NULL AUTO_INCREMENT;
612
613--
614-- AUTO_INCREMENT for table `so_reactions`
615--
616ALTER TABLE `so_reactions`
617 MODIFY `id` int(20) NOT NULL AUTO_INCREMENT;
618
619--
620-- AUTO_INCREMENT for table `so_stickers`
621--
622ALTER TABLE `so_stickers`
623 MODIFY `id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=58;
624
625--
626-- AUTO_INCREMENT for table `so_stickers_store`
627--
628ALTER TABLE `so_stickers_store`
629 MODIFY `id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
630
631--
632-- AUTO_INCREMENT for table `so_users`
633--
634ALTER TABLE `so_users`
635 MODIFY `user_id` int(20) NOT NULL AUTO_INCREMENT;
636
637--
638-- AUTO_INCREMENT for table `so_user_stickers`
639--
640ALTER TABLE `so_user_stickers`
641 MODIFY `id` int(20) NOT NULL AUTO_INCREMENT;
642COMMIT;
643
644/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
645/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
646/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;