· 8 years ago · Feb 06, 2018, 05:22 PM
1[Err] 1146 - Table 'testserver.allowed_character_creator_models' doesn't exist
2[Err] -- Dumping data for table gta_rp.allowed_character_creator_models: ~295 rows (approximately)
3DELETE FROM `allowed_character_creator_models`;
4[Err] 1146 - Table 'testserver.allowed_character_creator_models' doesn't exist
5[Err] /*!40000 ALTER TABLE `allowed_character_creator_models` DISABLE KEYS */;
6[Err] 1146 - Table 'testserver.allowed_character_creator_models' doesn't exist
7[Err] INSERT INTO `allowed_character_creator_models` (`model_name`) VALUES
8 ('Abigail'),
9 ('AfriAmer01AMM'),
10 ('Agent14'),
11 ('AlDiNapoli'),
12 ('AmandaTownley'),
13 ('Andreas'),
14 ('AntonB'),
15 ('ArmBoss01GMM'),
16 ('ArmGoon01GMM'),
17 ('ArmGoon02GMY'),
18 ('ArmLieut01GMM'),
19 ('Ashley'),
20 ('AutoShop01SMM'),
21 ('AviSchwartzman'),
22 ('Azteca01GMY'),
23 ('BallaEast01GMY'),
24 ('BallaOrig01GMY'),
25 ('Ballas01GFY'),
26 ('BallasOG'),
27 ('BallaSout01GMY'),
28 ('Bankman'),
29 ('Bankman01'),
30 ('Barman01SMY'),
31 ('Barry'),
32 ('Bartender01SFY'),
33 ('Baygor'),
34 ('Beach01AMO'),
35 ('Beach01AMY'),
36 ('Beach02AMY'),
37 ('BeachVesp01AMY'),
38 ('Beachvesp02AMY'),
39 ('Benny'),
40 ('BestMen'),
41 ('Beverly'),
42 ('BevHills01AFM'),
43 ('Bevhills01AFY'),
44 ('BevHills01AMM'),
45 ('BevHills01AMY'),
46 ('BevHills02AFM'),
47 ('BevHills02AFY'),
48 ('BevHills02AMM'),
49 ('BevHills02AMY'),
50 ('Bevhills03AFY'),
51 ('BevHills04AFY'),
52 ('BikerChic'),
53 ('BoatStaff01F'),
54 ('BoatStaff01M'),
55 ('Brad'),
56 ('Bride'),
57 ('Busicas01AMY'),
58 ('Business01AFY'),
59 ('Business01AMM'),
60 ('Business01AMY'),
61 ('Business02AFM'),
62 ('Business02AFY'),
63 ('Business02AMY'),
64 ('Business03AFY'),
65 ('Business03AMY'),
66 ('Business04AFY'),
67 ('Busker01SMO'),
68 ('Car3Guy1'),
69 ('Car3Guy2'),
70 ('ChiBoss01GMM'),
71 ('ChiGoon01GMM'),
72 ('ChiGoon02GMM'),
73 ('Chip'),
74 ('CntryBar01SMM'),
75 ('ComJane'),
76 ('Cyclist01'),
77 ('Cyclist01amy'),
78 ('Dale'),
79 ('DaveNorton'),
80 ('Dealer01SMY'),
81 ('Denise'),
82 ('Devin'),
83 ('DevinSec01SMY'),
84 ('DHill01AMY'),
85 ('DoaMan'),
86 ('Dom'),
87 ('DownTown01AFM'),
88 ('DownTown01AMY'),
89 ('Dreyfuss'),
90 ('DrFriedlander'),
91 ('EastSA01AFM'),
92 ('EastSA01AFY'),
93 ('EastSA01AMM'),
94 ('Eastsa01AMY'),
95 ('EastSA02AFM'),
96 ('EastSA02AFY'),
97 ('EastSa02AMM'),
98 ('EastSA02AMY'),
99 ('EastSA03AFY'),
100 ('EdToh'),
101 ('Epsilon01AFY'),
102 ('Epsilon01AMY'),
103 ('Epsilon02AMY'),
104 ('Fabien'),
105 ('FamCA01GMY'),
106 ('FamDD01'),
107 ('FamDNF01GMY'),
108 ('FamFor01GMY'),
109 ('Families01GFY'),
110 ('Farmer01AMM'),
111 ('FatBla01AFM'),
112 ('FatLatin01AMM'),
113 ('FatWhite01AFM'),
114 ('FemBarberSFM'),
115 ('Fitness01AFY'),
116 ('Fitness02AFY'),
117 ('Floyd'),
118 ('G'),
119 ('Gay01AMY'),
120 ('Gay02AMY'),
121 ('GenFat01AMM'),
122 ('GenFat02AMM'),
123 ('GenHot01AFY'),
124 ('GenStreet01AMY'),
125 ('GenStreet02AMY'),
126 ('GlenStank01'),
127 ('Golfer01AFY'),
128 ('Groom'),
129 ('Guido01'),
130 ('HairDress01SMM'),
131 ('Hao'),
132 ('HasJew01AMM'),
133 ('HasJew01AMY'),
134 ('Hiker01AFY'),
135 ('Hiker01AMY'),
136 ('HillBilly01AMM'),
137 ('HillBilly02AMM'),
138 ('Hippie01'),
139 ('Hippie01AFY'),
140 ('Hippy01AMY'),
141 ('Hipster01AFY'),
142 ('Hipster01AMY'),
143 ('Hipster02AFY'),
144 ('Hipster02AMY'),
145 ('Hipster03AFY'),
146 ('Hipster03AMY'),
147 ('Hipster04AFY'),
148 ('HotPosh01'),
149 ('Indian01AFO'),
150 ('Indian01AFY'),
151 ('Indian01AMM'),
152 ('Indian01AMY'),
153 ('Janet'),
154 ('JayNorris'),
155 ('JewelAss'),
156 ('JewelAss01'),
157 ('JimmyBoston'),
158 ('JimmyDisanto'),
159 ('JoeMinuteman'),
160 ('Josef'),
161 ('Josh'),
162 ('Juggalo01AFY'),
163 ('Juggalo01AMY'),
164 ('KerryMcintosh'),
165 ('KorBoss01GMM'),
166 ('Korean01GMY'),
167 ('Korean02GMY'),
168 ('KorLieut01GMY'),
169 ('KTown01AFM'),
170 ('KTown01AFO'),
171 ('KTown01AMM'),
172 ('KTown01AMO'),
173 ('KTown01AMY'),
174 ('KTown02AFM'),
175 ('KTown02AMY'),
176 ('LamarDavis'),
177 ('Latino01AMY'),
178 ('Lazlow'),
179 ('LifeInvad01'),
180 ('LifeInvad01SMM'),
181 ('LifeInvad02'),
182 ('Lost01GFY'),
183 ('Lost01GMY'),
184 ('Lost02GMY'),
185 ('Lost03GMY'),
186 ('Magenta'),
187 ('Malibu01AMM'),
188 ('Mani'),
189 ('Manuel'),
190 ('Markfost'),
191 ('Marnie'),
192 ('Maryann'),
193 ('MethHead01AMY'),
194 ('MexBoss01GMM'),
195 ('MexBoss02GMM'),
196 ('MexCntry01AMM'),
197 ('MexGang01GMY'),
198 ('MexGoon01GMY'),
199 ('MexGoon02GMY'),
200 ('MexGoon03GMY'),
201 ('Mexthug01AMY'),
202 ('Milton'),
203 ('Miranda'),
204 ('Motox02AMY'),
205 ('MovPrem01SFY'),
206 ('MovPrem01SMM'),
207 ('MPros01'),
208 ('MrK'),
209 ('Natalia'),
210 ('NervousRon'),
211 ('Nigel'),
212 ('OGBoss01AMM'),
213 ('OldMan2'),
214 ('Oneil'),
215 ('Ortega'),
216 ('Paige'),
217 ('Paparazzi01AMM'),
218 ('Paper'),
219 ('Party01'),
220 ('PoloGoon01GMY'),
221 ('PoloGoon02GMY'),
222 ('Polynesian01AMM'),
223 ('Polynesian01AMY'),
224 ('Popov'),
225 ('RampGang'),
226 ('RampHipster'),
227 ('RivalPaparazzi'),
228 ('RoadCyc01AMY')
229[Err] 1146 - Table 'testserver.allowed_character_creator_models' doesn't exist
230[Err] /*!40000 ALTER TABLE `allowed_character_creator_models` ENABLE KEYS */;
231[Err] 1146 - Table 'testserver.buildings' doesn't exist
232[Err] -- Dumping data for table gta_rp.buildings: ~2 rows (approximately)
233DELETE FROM `buildings`;
234[Err] 1146 - Table 'testserver.buildings' doesn't exist
235[Err] /*!40000 ALTER TABLE `buildings` DISABLE KEYS */;
236[Err] 1146 - Table 'testserver.buildings' doesn't exist
237[Err] INSERT INTO `buildings` (`id`, `name`, `use_blip`, `blip_id`, `blip_x`, `blip_y`, `blip_z`) VALUES
238 (0, 'Eclipse Towers', 1, 475, -773.48, 309.5, 85.6981),
239 (1, 'Middle Road', 0, NULL, NULL, NULL, NULL);
240[Err] 1146 - Table 'testserver.buildings' doesn't exist
241[Err] /*!40000 ALTER TABLE `buildings` ENABLE KEYS */;
242[Err] 1146 - Table 'testserver.characters' doesn't exist
243[Err] -- Dumping data for table gta_rp.characters: ~3 rows (approximately)
244DELETE FROM `characters`;
245[Err] 1146 - Table 'testserver.characters' doesn't exist
246[Err] /*!40000 ALTER TABLE `characters` DISABLE KEYS */;
247[Err] 1146 - Table 'testserver.characters' doesn't exist
248[Err] INSERT INTO `characters` (`id`, `player_id`, `first_name`, `last_name`, `faction_id`, `player_model`, `money`, `job`, `phone_number`, `spawn_house_id`) VALUES
249 (0, 0, 'John', 'Thomson', 0, 'Barry', 266241, 1, '4695300', 4),
250 (1, 0, 'Jane', 'Cheng', 0, 'MovPrem01SFY', 1293274, 1, '1325993', -1),
251 (2, 0, 'Jane', 'Thomson', 1, 'Bevhills01AFY', 50, 1, '3411699', -1);
252[Err] 1146 - Table 'testserver.characters' doesn't exist
253[Err] /*!40000 ALTER TABLE `characters` ENABLE KEYS */;
254[Err] 1146 - Table 'testserver.houses' doesn't exist
255[Err] -- Dumping data for table gta_rp.houses: ~2 rows (approximately)
256DELETE FROM `houses`;
257[Err] 1146 - Table 'testserver.houses' doesn't exist
258[Err] /*!40000 ALTER TABLE `houses` DISABLE KEYS */;
259[Err] 1146 - Table 'testserver.houses' doesn't exist
260[Err] INSERT INTO `houses` (`id`, `owner_id`, `template_id`, `name`) VALUES
261 (1, 1, 1, 'Jane\'s apartment'),
262 (2, 1, 0, 'Jane\'s second house'),
263 (3, 0, 0, 'John\'s home'),
264 (4, 0, 0, 'Apartment 2'),
265 (5, 0, 0, 'test1');
266[Err] 1146 - Table 'testserver.houses' doesn't exist
267[Err] /*!40000 ALTER TABLE `houses` ENABLE KEYS */;
268[Err] 1146 - Table 'testserver.house_exits' doesn't exist
269[Err] -- Dumping data for table gta_rp.house_exits: ~3 rows (approximately)
270DELETE FROM `house_exits`;
271[Err] 1146 - Table 'testserver.house_exits' doesn't exist
272[Err] /*!40000 ALTER TABLE `house_exits` DISABLE KEYS */;
273[Err] 1146 - Table 'testserver.house_exits' doesn't exist
274[Err] INSERT INTO `house_exits` (`id`, `house_template_id`, `exitX`, `exitY`, `exitZ`) VALUES
275 (0, 0, -785.143, 323.671, 211.997),
276 (1, 1, -614.86, 40.6783, 97.6001),
277 (2, 2, 261.459, -998.82, -99.0086);
278[Err] 1146 - Table 'testserver.house_exits' doesn't exist
279[Err] /*!40000 ALTER TABLE `house_exits` ENABLE KEYS */;
280[Err] 1146 - Table 'testserver.house_teleports' doesn't exist
281[Err] -- Dumping data for table gta_rp.house_teleports: ~4 rows (approximately)
282DELETE FROM `house_teleports`;
283[Err] 1146 - Table 'testserver.house_teleports' doesn't exist
284[Err] /*!40000 ALTER TABLE `house_teleports` DISABLE KEYS */;
285[Err] 1146 - Table 'testserver.house_teleports' doesn't exist
286[Err] INSERT INTO `house_teleports` (`id`, `building_id`, `entranceX`, `entranceY`, `entranceZ`, `name`) VALUES
287 (0, 0, -772.716, 311.984, 85.6981, 'Main entrance'),
288 (1, 1, 419.016, -1735.89, 29.6077, 'Exit'),
289 (2, 1, 285.554, -1011.85, 86.7462, 'Rooftop'),
290 (3, 0, -755.102, 334.561, 230.637, 'Rooftop');
291[Err] 1146 - Table 'testserver.house_teleports' doesn't exist
292[Err] /*!40000 ALTER TABLE `house_teleports` ENABLE KEYS */;
293[Err] 1146 - Table 'testserver.house_teleport_links' doesn't exist
294[Err] -- Dumping data for table gta_rp.house_teleport_links: ~4 rows (approximately)
295DELETE FROM `house_teleport_links`;
296[Err] 1146 - Table 'testserver.house_teleport_links' doesn't exist
297[Err] /*!40000 ALTER TABLE `house_teleport_links` DISABLE KEYS */;
298[Err] 1146 - Table 'testserver.house_teleport_links' doesn't exist
299[Err] INSERT INTO `house_teleport_links` (`entrance_id`, `exit_id`) VALUES
300 (0, 0),
301 (1, 2),
302 (2, 2),
303 (3, 0);
304[Err] 1146 - Table 'testserver.house_teleport_links' doesn't exist
305[Err] /*!40000 ALTER TABLE `house_teleport_links` ENABLE KEYS */;
306[Err] 1146 - Table 'testserver.house_template' doesn't exist
307[Err] -- Dumping data for table gta_rp.house_template: ~3 rows (approximately)
308DELETE FROM `house_template`;
309[Err] 1146 - Table 'testserver.house_template' doesn't exist
310[Err] /*!40000 ALTER TABLE `house_template` DISABLE KEYS */;
311[Err] 1146 - Table 'testserver.house_template' doesn't exist
312[Err] INSERT INTO `house_template` (`id`, `building_id`, `ipl`, `house_name`, `spawn_positionX`, `spawn_positionY`, `spawn_positionZ`) VALUES
313 (0, 0, 'no_ipl', 'Eclipse Towers 32', -776.343, 335.784, 211.397),
314 (1, 0, 'no_ipl', 'Tinsel Towers 12', 0, 0, 0),
315 (2, 1, 'no_ipl', 'Apartment 520', 0, 0, 0);
316[Err] 1146 - Table 'testserver.house_template' doesn't exist
317[Err] /*!40000 ALTER TABLE `house_template` ENABLE KEYS */;
318[Err] 1146 - Table 'testserver.items' doesn't exist
319[Err] -- Dumping data for table gta_rp.items: ~4 rows (approximately)
320DELETE FROM `items`;
321[Err] 1146 - Table 'testserver.items' doesn't exist
322[Err] /*!40000 ALTER TABLE `items` DISABLE KEYS */;
323[Err] 1146 - Table 'testserver.items' doesn't exist
324[Err] INSERT INTO `items` (`owner_id`, `item_id`, `amount`) VALUES
325 (0, 0, 1),
326 (0, 1, 1),
327 (1, 0, 1),
328 (1, 1, 1),
329 (2, 1, 2);
330[Err] 1146 - Table 'testserver.items' doesn't exist
331[Err] /*!40000 ALTER TABLE `items` ENABLE KEYS */;
332[Err] 1146 - Table 'testserver.item_templates' doesn't exist
333[Err] -- Dumping data for table gta_rp.item_templates: ~2 rows (approximately)
334DELETE FROM `item_templates`;
335[Err] 1146 - Table 'testserver.item_templates' doesn't exist
336[Err] /*!40000 ALTER TABLE `item_templates` DISABLE KEYS */;
337[Err] 1146 - Table 'testserver.item_templates' doesn't exist
338[Err] INSERT INTO `item_templates` (`id`, `type`, `name`, `description`, `field1`, `field2`, `field3`, `field4`) VALUES
339 (0, 1, 'SMG', 'SMG weapon', 736523883, NULL, NULL, 'asd'),
340 (1, 2, 'Fishing rod', 'You can catch fish with this', 1338703913, 57005, NULL, 'amb@world_human_stand_fishing@base;base;0.225,-0.045,-0.1;-23,-33,-120;0.17,-0.07,-0.06;-24,-33,-130');
341[Err] 1146 - Table 'testserver.item_templates' doesn't exist
342[Err] /*!40000 ALTER TABLE `item_templates` ENABLE KEYS */;
343[Err] 1146 - Table 'testserver.model_genders' doesn't exist
344[Err] -- Dumping data for table gta_rp.model_genders: ~295 rows (approximately)
345DELETE FROM `model_genders`;
346[Err] 1146 - Table 'testserver.model_genders' doesn't exist
347[Err] /*!40000 ALTER TABLE `model_genders` DISABLE KEYS */;
348[Err] 1146 - Table 'testserver.model_genders' doesn't exist
349[Err] INSERT INTO `model_genders` (`model_name`, `gender`) VALUES
350 ('Abigail', 1),
351 ('AfriAmer01AMM', 0),
352 ('Agent14', 0),
353 ('AlDiNapoli', 0),
354 ('AmandaTownley', 1),
355 ('Andreas', 0),
356 ('AntonB', 0),
357 ('ArmBoss01GMM', 0),
358 ('ArmGoon01GMM', 0),
359 ('ArmGoon02GMY', 0),
360 ('ArmLieut01GMM', 0),
361 ('Ashley', 1),
362 ('AutoShop01SMM', 0),
363 ('AviSchwartzman', 0),
364 ('Azteca01GMY', 0),
365 ('BallaEast01GMY', 0),
366 ('BallaOrig01GMY', 0),
367 ('Ballas01GFY', 1),
368 ('BallasOG', 0),
369 ('BallaSout01GMY', 0),
370 ('Bankman', 0),
371 ('Bankman01', 0),
372 ('Barman01SMY', 0),
373 ('Barry', 0),
374 ('Bartender01SFY', 1),
375 ('Baygor', 0),
376 ('Beach01AMO', 0),
377 ('Beach01AMY', 0),
378 ('Beach02AMY', 0),
379 ('BeachVesp01AMY', 0),
380 ('Beachvesp02AMY', 0),
381 ('Benny', 0),
382 ('BestMen', 0),
383 ('Beverly', 0),
384 ('BevHills01AFM', 1),
385 ('Bevhills01AFY', 1),
386 ('BevHills01AMM', 0),
387 ('BevHills01AMY', 0),
388 ('BevHills02AFM', 1),
389 ('BevHills02AFY', 1),
390 ('BevHills02AMM', 0),
391 ('BevHills02AMY', 0),
392 ('Bevhills03AFY', 1),
393 ('BevHills04AFY', 1),
394 ('BikerChic', 1),
395 ('BoatStaff01F', 1),
396 ('BoatStaff01M', 0),
397 ('Brad', 0),
398 ('Bride', 1),
399 ('Busicas01AMY', 0),
400 ('Business01AFY', 1),
401 ('Business01AMM', 0),
402 ('Business01AMY', 0),
403 ('Business02AFM', 1),
404 ('Business02AFY', 1),
405 ('Business02AMY', 0),
406 ('Business03AFY', 1),
407 ('Business03AMY', 0),
408 ('Business04AFY', 1),
409 ('Busker01SMO', 0),
410 ('Car3Guy1', 0),
411 ('Car3Guy2', 0),
412 ('ChiBoss01GMM', 0),
413 ('ChiGoon01GMM', 0),
414 ('ChiGoon02GMM', 0),
415 ('Chip', 0),
416 ('CntryBar01SMM', 0),
417 ('ComJane', 1),
418 ('Cyclist01', 0),
419 ('Cyclist01amy', 0),
420 ('Dale', 0),
421 ('DaveNorton', 0),
422 ('Dealer01SMY', 0),
423 ('Denise', 1),
424 ('Devin', 0),
425 ('DevinSec01SMY', 0),
426 ('DHill01AMY', 0),
427 ('DoaMan', 0),
428 ('Dom', 0),
429 ('DownTown01AFM', 1),
430 ('DownTown01AMY', 0),
431 ('Dreyfuss', 0),
432 ('DrFriedlander', 0),
433 ('EastSA01AFM', 1),
434 ('EastSA01AFY', 1),
435 ('EastSA01AMM', 0),
436 ('Eastsa01AMY', 0),
437 ('EastSA02AFM', 1),
438 ('EastSA02AFY', 1),
439 ('EastSa02AMM', 0),
440 ('EastSA02AMY', 0),
441 ('EastSA03AFY', 1),
442 ('EdToh', 0),
443 ('Epsilon01AFY', 1),
444 ('Epsilon01AMY', 0),
445 ('Epsilon02AMY', 0),
446 ('Fabien', 0),
447 ('FamCA01GMY', 0),
448 ('FamDD01', 0),
449 ('FamDNF01GMY', 0),
450 ('FamFor01GMY', 0),
451 ('Families01GFY', 1),
452 ('Farmer01AMM', 0),
453 ('FatBla01AFM', 1),
454 ('FatLatin01AMM', 0),
455 ('FatWhite01AFM', 1),
456 ('FemBarberSFM', 1),
457 ('Fitness01AFY', 1),
458 ('Fitness02AFY', 1),
459 ('Floyd', 0),
460 ('G', 0),
461 ('Gay01AMY', 0),
462 ('Gay02AMY', 0),
463 ('GenFat01AMM', 0),
464 ('GenFat02AMM', 0),
465 ('GenHot01AFY', 1),
466 ('GenStreet01AMY', 0),
467 ('GenStreet02AMY', 0),
468 ('GlenStank01', 0),
469 ('Golfer01AFY', 1),
470 ('Groom', 0),
471 ('Guido01', 0),
472 ('HairDress01SMM', 0),
473 ('Hao', 0),
474 ('HasJew01AMM', 0),
475 ('HasJew01AMY', 0),
476 ('Hiker01AFY', 1),
477 ('Hiker01AMY', 0),
478 ('HillBilly01AMM', 0),
479 ('HillBilly02AMM', 0),
480 ('Hippie01', 0),
481 ('Hippie01AFY', 1),
482 ('Hippy01AMY', 0),
483 ('Hipster01AFY', 1),
484 ('Hipster01AMY', 0),
485 ('Hipster02AFY', 1),
486 ('Hipster02AMY', 0),
487 ('Hipster03AFY', 1),
488 ('Hipster03AMY', 0),
489 ('Hipster04AFY', 1),
490 ('HotPosh01', 1),
491 ('Indian01AFO', 1),
492 ('Indian01AFY', 1),
493 ('Indian01AMM', 0),
494 ('Indian01AMY', 1),
495 ('Janet', 1),
496 ('JayNorris', 0),
497 ('JewelAss', 1),
498 ('JewelAss01', 1),
499 ('JimmyBoston', 0),
500 ('JimmyDisanto', 0),
501 ('JoeMinuteman', 0),
502 ('Josef', 0),
503 ('Josh', 0),
504 ('Juggalo01AFY', 1),
505 ('Juggalo01AMY', 0),
506 ('KerryMcintosh', 1),
507 ('KorBoss01GMM', 0),
508 ('Korean01GMY', 0),
509 ('Korean02GMY', 0),
510 ('KorLieut01GMY', 0),
511 ('KTown01AFM', 1),
512 ('KTown01AFO', 1),
513 ('KTown01AMM', 0),
514 ('KTown01AMO', 0),
515 ('KTown01AMY', 0),
516 ('KTown02AFM', 1),
517 ('KTown02AMY', 0),
518 ('LamarDavis', 0),
519 ('Latino01AMY', 0),
520 ('Lazlow', 0),
521 ('LifeInvad01', 0),
522 ('LifeInvad01SMM', 0),
523 ('LifeInvad02', 0),
524 ('Lost01GFY', 1),
525 ('Lost01GMY', 0),
526 ('Lost02GMY', 0),
527 ('Lost03GMY', 0),
528 ('Magenta', 1),
529 ('Malibu01AMM', 0),
530 ('Mani', 0),
531 ('Manuel', 0),
532 ('Markfost', 0),
533 ('Marnie', 1),
534 ('Maryann', 1),
535 ('MethHead01AMY', 0),
536 ('MexBoss01GMM', 0),
537 ('MexBoss02GMM', 0),
538 ('MexCntry01AMM', 0),
539
540[Err] 1146 - Table 'testserver.model_genders' doesn't exist
541[Err] /*!40000 ALTER TABLE `model_genders` ENABLE KEYS */;
542[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<<<<<<< HEAD
543-- Dumping structure for table gta_rp.phone_contacts
544CREATE TABLE' at line 1
545[Err] <<<<<<< HEAD
546-- Dumping structure for table gta_rp.phone_contacts
547CREATE TABLE IF NOT EXISTS `phone_contacts` (
548 `owner` int(11) NOT NULL DEFAULT '0',
549 `name` varchar(11) DEFAULT NULL,
550 `number` varchar(11) NOT NULL DEFAULT '',
551 PRIMARY KEY (`owner`,`number`)
552) ENGINE=InnoDB DEFAULT CHARSET=utf8;
553[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<<<<<<< Updated upstream
554-- Dumping data for table gta_rp.phone_contacts: ~1 ro' at line 1
555[Err] <<<<<<< Updated upstream
556-- Dumping data for table gta_rp.phone_contacts: ~1 rows (approximately)
557=======
558-- Dumping data for table gta_rp.phone_contacts: ~0 rows (approximately)
559=======
560-- Dumping data for table gta_rp.phone_contacts: ~1 rows (approximately)
561DELETE FROM `phone_contacts`;
562[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '>>>>>>> parent of b1c0711... Updated sql file
563>>>>>>> Stashed changes
564/*!40000' at line 1
565[Err] >>>>>>> parent of b1c0711... Updated sql file
566>>>>>>> Stashed changes
567/*!40000 ALTER TABLE `phone_contacts` DISABLE KEYS */;
568[Err] 1146 - Table 'testserver.phone_contacts' doesn't exist
569[Err] INSERT INTO `phone_contacts` (`owner`, `name`, `number`) VALUES
570 (2, 'asd', '3411699');
571[Err] 1146 - Table 'testserver.phone_contacts' doesn't exist
572[Err] /*!40000 ALTER TABLE `phone_contacts` ENABLE KEYS */;
573[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<<<<<<< HEAD
574-- Dumping structure for table gta_rp.players
575CREATE TABLE IF NOT' at line 1
576[Err] <<<<<<< HEAD
577-- Dumping structure for table gta_rp.players
578CREATE TABLE IF NOT EXISTS `players` (
579 `id` int(11) NOT NULL DEFAULT '0',
580 `name` varchar(100) DEFAULT NULL,
581 `password` varchar(100) DEFAULT NULL,
582 `admin_level` int(11) DEFAULT NULL,
583 PRIMARY KEY (`id`)
584) ENGINE=InnoDB DEFAULT CHARSET=utf8;
585[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<<<<<<< Updated upstream
586-- Dumping data for table gta_rp.players: ~1 rows (app' at line 1
587[Err] <<<<<<< Updated upstream
588-- Dumping data for table gta_rp.players: ~1 rows (approximately)
589=======
590-- Dumping data for table gta_rp.players: ~0 rows (approximately)
591=======
592-- Dumping data for table gta_rp.players: ~1 rows (approximately)
593DELETE FROM `players`;
594[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '>>>>>>> parent of b1c0711... Updated sql file
595>>>>>>> Stashed changes
596/*!40000' at line 1
597[Err] >>>>>>> parent of b1c0711... Updated sql file
598>>>>>>> Stashed changes
599/*!40000 ALTER TABLE `players` DISABLE KEYS */;
600[Err] 1146 - Table 'testserver.players' doesn't exist
601[Err] INSERT INTO `players` (`id`, `name`, `password`, `admin_level`) VALUES
602 (0, 'Test', 'cc03e747a6afbbcbf8be7668acfebee5', 0);
603[Err] 1146 - Table 'testserver.players' doesn't exist
604[Err] /*!40000 ALTER TABLE `players` ENABLE KEYS */;
605[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<<<<<<< Updated upstream
606=======
607<<<<<<< HEAD
608-- Dumping structure for table ' at line 1
609[Err] <<<<<<< Updated upstream
610=======
611<<<<<<< HEAD
612-- Dumping structure for table gta_rp.police_ranks
613CREATE TABLE IF NOT EXISTS `police_ranks` (
614 `character_id` int(100) NOT NULL,
615 `rank_id` int(100) NOT NULL,
616 `modelHash` varchar(100) NOT NULL,
617 PRIMARY KEY (`character_id`,`rank_id`)
618) ENGINE=InnoDB DEFAULT CHARSET=utf8;
619[Err] 1146 - Table 'testserver.police_ranks' doesn't exist
620[Err] -- Dumping data for table gta_rp.police_ranks: ~0 rows (approximately)
621/*!40000 ALTER TABLE `police_ranks` DISABLE KEYS */;
622[Err] 1146 - Table 'testserver.police_ranks' doesn't exist
623[Err] INSERT INTO `police_ranks` (`character_id`, `rank_id`, `modelHash`) VALUES
624 (0, 3, 'CIASec01SMM');
625[Err] 1146 - Table 'testserver.police_ranks' doesn't exist
626[Err] /*!40000 ALTER TABLE `police_ranks` ENABLE KEYS */;
627[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '>>>>>>> Stashed changes
628-- Dumping structure for table gta_rp.random_house_sell' at line 1
629[Err] >>>>>>> Stashed changes
630-- Dumping structure for table gta_rp.random_house_sell_templates
631CREATE TABLE IF NOT EXISTS `random_house_sell_templates` (
632 `templateId` int(11) NOT NULL,
633 `minPrice` int(11) NOT NULL,
634 `maxPrice` int(11) NOT NULL,
635 PRIMARY KEY (`templateId`),
636 UNIQUE KEY `templateId` (`templateId`)
637) ENGINE=InnoDB DEFAULT CHARSET=utf8;
638[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<<<<<<< Updated upstream
639-- Dumping data for table gta_rp.random_house_sell_tem' at line 1
640[Err] <<<<<<< Updated upstream
641-- Dumping data for table gta_rp.random_house_sell_templates: ~3 rows (approximately)
642=======
643-- Dumping data for table gta_rp.random_house_sell_templates: ~2 rows (approximately)
644=======
645-- Dumping data for table gta_rp.random_house_sell_templates: ~3 rows (approximately)
646DELETE FROM `random_house_sell_templates`;
647[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '>>>>>>> parent of b1c0711... Updated sql file
648>>>>>>> Stashed changes
649/*!40000' at line 1
650[Err] >>>>>>> parent of b1c0711... Updated sql file
651>>>>>>> Stashed changes
652/*!40000 ALTER TABLE `random_house_sell_templates` DISABLE KEYS */;
653[Err] 1146 - Table 'testserver.random_house_sell_templates' doesn't exist
654[Err] INSERT INTO `random_house_sell_templates` (`templateId`, `minPrice`, `maxPrice`) VALUES
655 (0, 100000, 250000),
656 (1, 150000, 180000),
657 (2, 100000, 120000);
658[Err] 1146 - Table 'testserver.random_house_sell_templates' doesn't exist
659[Err] /*!40000 ALTER TABLE `random_house_sell_templates` ENABLE KEYS */;
660[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<<<<<<< HEAD
661-- Dumping structure for table gta_rp.text_messages
662CREATE TABLE ' at line 1
663[Err] <<<<<<< HEAD
664-- Dumping structure for table gta_rp.text_messages
665CREATE TABLE IF NOT EXISTS `text_messages` (
666 `id` int(11) NOT NULL DEFAULT '0',
667 `sender_number` varchar(11) NOT NULL DEFAULT '',
668 `receiver_number` varchar(100) NOT NULL DEFAULT '',
669 `time` varchar(11) NOT NULL DEFAULT '',
670 `message` varchar(1000) NOT NULL DEFAULT '',
671 PRIMARY KEY (`id`)
672) ENGINE=InnoDB DEFAULT CHARSET=utf8;
673[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<<<<<<< Updated upstream
674-- Dumping data for table gta_rp.text_messages: ~3 row' at line 1
675[Err] <<<<<<< Updated upstream
676-- Dumping data for table gta_rp.text_messages: ~3 rows (approximately)
677=======
678-- Dumping data for table gta_rp.text_messages: ~2 rows (approximately)
679=======
680-- Dumping data for table gta_rp.text_messages: ~3 rows (approximately)
681DELETE FROM `text_messages`;
682[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '>>>>>>> parent of b1c0711... Updated sql file
683>>>>>>> Stashed changes
684/*!40000' at line 1
685[Err] >>>>>>> parent of b1c0711... Updated sql file
686>>>>>>> Stashed changes
687/*!40000 ALTER TABLE `text_messages` DISABLE KEYS */;
688[Err] 1146 - Table 'testserver.text_messages' doesn't exist
689[Err] INSERT INTO `text_messages` (`id`, `sender_number`, `receiver_number`, `time`, `message`) VALUES
690 (0, '1325993', '1325993', '19:53:00', 'test'),
691 (1, '3411699', '3411699', '23:34:00', 'asdadasd s'),
692 (2, '3411699', '3411699', '01:18:00', 'asda213');
693[Err] 1146 - Table 'testserver.text_messages' doesn't exist
694[Err] /*!40000 ALTER TABLE `text_messages` ENABLE KEYS */;
695[Err] 1146 - Table 'testserver.vehicles' doesn't exist
696[Err] -- Dumping data for table gta_rp.vehicles: ~8 rows (approximately)
697DELETE FROM `vehicles`;
698[Err] 1146 - Table 'testserver.vehicles' doesn't exist
699[Err] /*!40000 ALTER TABLE `vehicles` DISABLE KEYS */;
700[Err] 1146 - Table 'testserver.vehicles' doesn't exist
701[Err] INSERT INTO `vehicles` (`id`, `ownedId`, `factionId`, `model`, `park_x`, `park_y`, `park_z`, `park_rot_x`, `park_rot_y`, `park_rot_z`, `license_plate_text`, `license_plate_style`, `color1`, `color2`) VALUES
702 (1, -1, 1, 2046537925, -1126, -865, 13, 0, 0, -140, '', 0, 111, 0),
703 (2, -1, 1, 2046537925, -1123, -863, 13, 0, 0, -142, '', 0, 111, 0),
704 (3, -1, 1, -1627000575, -1112, -855, 13, 1, 0, -143, '', 0, 111, 0),
705 (4, -1, 1, -2007026063, -1043, -858, 5, 0, 0, -122, '', 0, 63, 63),
706 (5, -1, 1, -2007026063, -1049, -864, 5, 0, -3, -122, '', 0, 63, 63),
707 (6, 0, 0, 719660200, -223, -1168, 23, 1, 0, -92, 'LS6X3USS', 0, 41, 55),
708 (7, 1, 0, 719660200, -679, 291, 81, -2, -3, -103, 'LSYXE325', 0, 127, 28),
709 (8, 1, 0, -956048545, -223, -1168, 23, 1, 0, -92, 'LSS2HL6K', 0, 135, 89);
710[Err] 1146 - Table 'testserver.vehicles' doesn't exist
711[Err] /*!40000 ALTER TABLE `vehicles` ENABLE KEYS */;
712[Err] 1146 - Table 'testserver.vehicle_prices' doesn't exist
713[Err] -- Dumping data for table gta_rp.vehicle_prices: ~6 rows (approximately)
714DELETE FROM `vehicle_prices`;
715[Err] 1146 - Table 'testserver.vehicle_prices' doesn't exist
716[Err] /*!40000 ALTER TABLE `vehicle_prices` DISABLE KEYS */;
717[Err] 1146 - Table 'testserver.vehicle_prices' doesn't exist
718[Err] INSERT INTO `vehicle_prices` (`model`, `price`) VALUES
719 ('Baller3', 250000),
720 ('Baller4', 230000),
721 ('BJXL', 100000),
722 ('Contender', 500000),
723 ('Ruston', 830000),
724 ('Taxi', 400000);
725[Err] 1146 - Table 'testserver.vehicle_prices' doesn't exist
726[Err] /*!40000 ALTER TABLE `vehicle_prices` ENABLE KEYS */;
727[Msg] Finished - Unsuccessfully
728--------------------------------------------------