· 10 years ago · Sep 08, 2016, 06:38 AM
1DROP TABLE IF EXISTS `tasks`;
2
3CREATE TABLE `tasks` (
4`id` int(11) NOT NULL AUTO_INCREMENT,
5`seller_id` int(11) DEFAULT NULL,
6PRIMARY KEY (`id`),
7KEY `index_tasks_on_seller_id` (`seller_id`)
8) ENGINE=InnoDB DEFAULT CHARSET=utf8;
9
10INSERT INTO `tasks` (`id`, `seller_id`)
11VALUES
12 (15788, 95157),
13 (15789, 95158),
14 (15790, 86270),
15 (15791, 86270),
16 (15792, 94260),
17 (15793, 14354),
18 (15794, 95160),
19 (15795, 95161),
20 (15796, 10786),
21 (15797, 95162),
22 (15798, 72740),
23 (15799, 95163),
24 (15800, 93159),
25 (15801, 95165),
26 (15802, 95168),
27 (15803, 95170),
28 (15804, 95173),
29 (15805, 6983),
30 (15806, 95175),
31 (15807, 95177),
32 (15808, 80037),
33 (15809, 45066),
34 (15810, 95180),
35 (15811, 95181),
36 (15812, 95182),
37 (15813, 84020),
38 (15814, 95156),
39 (15815, 93418),
40 (15816, 74020),
41 (15817, 74020),
42 (15818, 73604),
43 (15819, 95190),
44 (15820, 95188),
45 (15821, 39132),
46 (15822, 95191),
47 (15823, 95192),
48 (15824, 95196),
49 (15825, 32979),
50 (15826, 30104),
51 (15827, 95198),
52 (15828, 95200),
53 (15829, 93974),
54 (15830, 95201),
55 (15831, 95202),
56 (15832, 33487),
57 (15833, 60076),
58 (15834, 33487),
59 (15835, 88081),
60 (15836, 95204),
61 (15837, 95205),
62 (15838, 27527),
63 (15839, 93055),
64 (15840, 95209),
65 (15841, 2297),
66 (15842, 95211),
67 (15843, 76806),
68 (15844, 69400),
69 (15845, 34273),
70 (15846, 95214),
71 (15847, 82877);
72
73DROP TABLE IF EXISTS `chats`;
74
75CREATE TABLE `chats` (
76`id` int(11) NOT NULL AUTO_INCREMENT,
77`creator_id` int(11) DEFAULT NULL,
78`task_id` int(11) DEFAULT NULL,
79PRIMARY KEY (`id`)
80) ENGINE=InnoDB DEFAULT CHARSET=utf8;
81INSERT INTO `chats` (`id`, `creator_id`, `task_id`)
82VALUES
83 (10754, 53058, 15788),
84 (10767, 36414, 15788),
85 (10778, 61359, 15788),
86 (10759, 61359, 15789),
87 (10770, 36414, 15789),
88 (10961, 10541, 15790),
89 (10777, 61359, 15792),
90 (10819, 11835, 15793),
91 (10766, 4631, 15795),
92 (10791, 18461, 15795),
93 (10823, 31111, 15795),
94 (10874, 11649, 15795),
95 (10994, 85902, 15795),
96 (10769, 36414, 15797),
97 (10776, 61359, 15797),
98 (10919, 53058, 15797),
99 (10771, 12815, 15798),
100 (10775, 83339, 15798),
101 (10811, 12745, 15799),
102 (11211, 35416, 15799),
103 (10793, 4631, 15800),
104 (10833, 85902, 15800),
105 (10816, 36414, 15802),
106 (10806, 36414, 15803),
107 (10801, 80049, 15804),
108 (10818, 36414, 15804),
109 (10824, 11835, 15805),
110 (10802, 7240, 15806),
111 (10822, 39871, 15806),
112 (10838, 79168, 15806),
113 (10817, 36414, 15807),
114 (10918, 53058, 15807),
115 (10809, 33051, 15808),
116 (10843, 20435, 15808),
117 (10803, 45069, 15809),
118 (10804, 5093, 15809),
119 (10814, 84699, 15810),
120 (10844, 58098, 15810),
121 (10847, 95206, 15810),
122 (10849, 95105, 15810),
123 (10853, 94009, 15810),
124 (10854, 94009, 15810),
125 (10855, 94009, 15810),
126 (10856, 94009, 15810),
127 (10857, 94009, 15810),
128 (10858, 94009, 15810),
129 (10859, 94009, 15810),
130 (10860, 94009, 15810),
131 (10894, 65435, 15814),
132 (11057, 91171, 15815),
133 (10975, 85902, 15816),
134 (10812, 4631, 15817),
135 (10841, 85115, 15818),
136 (10903, 87971, 15818),
137 (10980, 36414, 15819),
138 (10886, 39393, 15821),
139 (10825, 11835, 15824),
140 (10871, 2919, 15824),
141 (11194, 21322, 15824),
142 (11137, 94553, 15825),
143 (10831, 84932, 15826),
144 (10836, 83339, 15826),
145 (10839, 8532, 15826),
146 (10840, 11967, 15826),
147 (10913, 35573, 15827),
148 (10983, 36414, 15827),
149 (10878, 29425, 15829),
150 (10952, 36414, 15831),
151 (10845, 10511, 15832),
152 (10941, 7240, 15832),
153 (10872, 3154, 15834),
154 (10897, 36414, 15835),
155 (10917, 53058, 15835),
156 (11045, 36902, 15835),
157 (10879, 29425, 15836),
158 (11114, 94682, 15836),
159 (10900, 36414, 15837),
160 (10846, 4631, 15838),
161 (10850, 4631, 15839),
162 (10848, 4631, 15841),
163 (10852, 4631, 15842),
164 (10851, 4631, 15844),
165 (10864, 62822, 15845),
166 (10889, 85115, 15847);
167
168DROP TABLE IF EXISTS `messages`;
169
170CREATE TABLE `messages` (
171`id` int(11) NOT NULL AUTO_INCREMENT,
172`chat_id` int(11) DEFAULT NULL,
173`author_id` int(11) DEFAULT NULL,
174PRIMARY KEY (`id`)
175) ENGINE=InnoDB DEFAULT CHARSET=utf8;
176INSERT INTO `messages` (`chat_id`, `author_id`)
177values
178 (10754, 53058),
179 (10767, 36414),
180 (10778, 61359),
181 (10759, 61359),
182 (10759, 95158),
183 (10770, 36414),
184 (10770, 95158),
185 (10961, 10541),
186 (10961, 86270),
187 (10777, 61359),
188 (10819, 11835),
189 (10819, 14354),
190 (10766, 4631),
191 (10766, 95161),
192 (10791, 95161),
193 (10791, 18461),
194 (10823, 31111),
195 (10874, 11649),
196 (10994, 85902),
197 (10769, 36414),
198 (10776, 61359),
199 (10919, 53058),
200 (10775, 83339),
201 (10775, 72740),
202 (10811, 12745),
203 (10811, 95163),
204 (11211, 35416),
205 (11211, 95163),
206 (10793, 4631),
207 (10793, 93159),
208 (10833, 85902),
209 (10833, 93159),
210 (10816, 36414),
211 (10806, 36414),
212 (10801, 80049),
213 (10818, 36414),
214 (10824, 11835),
215 (10824, 6983),
216 (10802, 7240),
217 (10802, 95175),
218 (10822, 39871),
219 (10838, 79168),
220 (10838, 95175),
221 (10817, 36414),
222 (10817, 95177),
223 (10918, 53058),
224 (10809, 33051),
225 (10809, 80037),
226 (10843, 20435),
227 (10843, 80037),
228 (10803, 45069),
229 (10804, 5093),
230 (10814, 84699),
231 (10814, 95180),
232 (10844, 58098),
233 (10844, 95180),
234 (10847, 95206),
235 (10847, 95180),
236 (10849, 95105),
237 (10849, 95180),
238 (10853, 94009),
239 (10853, 95180),
240 (10894, 65435),
241 (10894, 95156),
242 (11057, 91171),
243 (10975, 85902),
244 (10975, 74020),
245 (10812, 4631),
246 (10812, 74020),
247 (10841, 85115),
248 (10841, 73604),
249 (10903, 87971),
250 (10903, 73604),
251 (10980, 36414),
252 (10980, 95190),
253 (10886, 39393),
254 (10886, 39132),
255 (10825, 11835),
256 (10825, 95196),
257 (10871, 2919),
258 (10871, 95196),
259 (11194, 21322),
260 (11194, 95196),
261 (11137, 94553),
262 (10831, 84932),
263 (10836, 83339),
264 (10839, 8532),
265 (10839, 30104),
266 (10840, 11967),
267 (10913, 35573),
268 (10913, 95198),
269 (10983, 36414),
270 (10878, 29425),
271 (10878, 93974),
272 (10952, 36414),
273 (10845, 33487),
274 (10845, 10511),
275 (10941, 7240),
276 (10872, 3154),
277 (10872, 33487),
278 (10897, 36414),
279 (10897, 88081),
280 (10917, 53058),
281 (11045, 36902),
282 (11045, 88081),
283 (10879, 29425),
284 (10879, 95204),
285 (11114, 94682),
286 (10900, 36414),
287 (10900, 95205),
288 (10846, 4631),
289 (10846, 27527),
290 (10850, 4631),
291 (10850, 93055),
292 (10848, 4631),
293 (10852, 4631),
294 (10852, 95211),
295 (10851, 4631),
296 (10851, 69400),
297 (10864, 62822),
298 (10889, 85115);