· 6 years ago · Jan 09, 2020, 06:24 AM
1CREATE TABLE IF NOT EXISTS `accounts` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `name` varchar(24) NOT NULL,
4 `password` varchar(32) NOT NULL,
5 `ip` varchar(16) NOT NULL DEFAULT '0.0.0.0',
6 `veh_number` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
7 `veh_reg` int(1) NOT NULL DEFAULT '0',
8 `admin` int(11) NOT NULL DEFAULT '0',
9 `securitycode` int(11) NOT NULL DEFAULT '0',
10 `checkcode` int(11) NOT NULL DEFAULT '0',
11 `mail` varchar(64) NOT NULL DEFAULT 'None',
12 `level` int(11) NOT NULL DEFAULT '10',
13 `cash` int(11) NOT NULL DEFAULT '50000000',
14 `bank` int(11) NOT NULL DEFAULT '250',
15 `exp` int(11) NOT NULL DEFAULT '0',
16 `regip` varchar(16) NOT NULL DEFAULT '0.0.0.0',
17 `datareg` varchar(15) NOT NULL DEFAULT '0.0.0',
18 `leader` int(3) NOT NULL DEFAULT '0',
19 `templeader` int(3) NOT NULL DEFAULT '0',
20 `member` int(3) NOT NULL DEFAULT '0',
21 `rank` int(3) NOT NULL DEFAULT '0',
22 `warn` int(11) NOT NULL DEFAULT '0',
23 `sex` int(11) NOT NULL DEFAULT '0',
24 `age` int(11) NOT NULL DEFAULT '0',
25 `model` int(11) NOT NULL DEFAULT '0',
26 `memberskin` int(11) NOT NULL DEFAULT '0',
27 `lic` varchar(16) NOT NULL DEFAULT '1, 1, 1, 1, 1',
28 `guns` varchar(56) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0,0,0,0,0',
29 `ammos` varchar(56) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0,0,0,0,0',
30 `mute` int(11) NOT NULL DEFAULT '0',
31 `mutereason` varchar(64) NOT NULL DEFAULT 'None',
32 `pick` int(11) NOT NULL DEFAULT '0',
33 `checktime` int(6) NOT NULL DEFAULT '0',
34 `news` int(11) NOT NULL DEFAULT '0',
35 `phone` varchar(16) NOT NULL DEFAULT '0, 0',
36 `phonenumber` int(11) NOT NULL DEFAULT '0',
37 `text` varchar(20) NOT NULL DEFAULT '0, 0, 0, 0',
38 `jail` int(11) NOT NULL DEFAULT '0',
39 `jailtime` int(11) NOT NULL DEFAULT '0',
40 `jailreason` varchar(64) NOT NULL DEFAULT 'None',
41 `wanted` int(11) NOT NULL DEFAULT '0',
42 `wantedtime` int(11) NOT NULL DEFAULT '0',
43 `wantedwho` varchar(24) NOT NULL DEFAULT 'None',
44 `wantedreason` varchar(32) NOT NULL DEFAULT 'None',
45 `heal` varchar(11) NOT NULL DEFAULT '100.0',
46 `drugs` int(11) NOT NULL DEFAULT '0',
47 `patron` int(11) NOT NULL DEFAULT '0',
48 `gunamount` int(11) NOT NULL DEFAULT '0',
49 `crimes` int(11) NOT NULL DEFAULT '0',
50 `job` int(11) NOT NULL DEFAULT '0',
51 `married` int(11) NOT NULL DEFAULT '0',
52 `whomarried` varchar(24) NOT NULL DEFAULT 'None',
53 `referal` varchar(24) NOT NULL DEFAULT 'None',
54 `refmoney` int(11) NOT NULL DEFAULT '0',
55 `paycheck` int(11) NOT NULL DEFAULT '0',
56 `charity` int(11) NOT NULL DEFAULT '0',
57 `vip` int(11) NOT NULL DEFAULT '0',
58 `viptime` int(11) NOT NULL DEFAULT '0',
59 `time` int(11) NOT NULL DEFAULT '0',
60 `fstyle` int(11) NOT NULL DEFAULT '0',
61 `credits` int(11) NOT NULL DEFAULT '0',
62 `skin1` int(11) NOT NULL DEFAULT '0',
63 `skin2` int(11) NOT NULL DEFAULT '0',
64 `skin3` int(11) NOT NULL DEFAULT '0',
65 `spawnchange` int(11) NOT NULL DEFAULT '0',
66 `sdpistol` int(11) NOT NULL DEFAULT '100',
67 `deserteagle` int(11) NOT NULL DEFAULT '100',
68 `shotgun` int(11) NOT NULL DEFAULT '100',
69 `mp5` int(11) NOT NULL DEFAULT '100',
70 `ak47` int(11) NOT NULL DEFAULT '100',
71 `m4` int(11) NOT NULL DEFAULT '100',
72 `pistol` int(11) NOT NULL DEFAULT '100',
73 `microuzi` int(11) NOT NULL DEFAULT '100',
74 `hunger` int(11) NOT NULL DEFAULT '100',
75 `healths` float NOT NULL DEFAULT '100',
76 `sportexp` int(11) NOT NULL DEFAULT '0',
77 `online` int(11) NOT NULL DEFAULT '0',
78 `zakon` int(11) NOT NULL DEFAULT '0',
79 `city` int(11) NOT NULL DEFAULT '0',
80 `repcar` varchar(16) NOT NULL DEFAULT '0, 0',
81 `bed` int(11) NOT NULL,
82 `watch` int(11) NOT NULL DEFAULT '0',
83 `ciggare` int(11) NOT NULL DEFAULT '0',
84 `sprunk` int(11) NOT NULL DEFAULT '7000',
85 `mask` int(11) NOT NULL DEFAULT '0',
86 `phonebalance` int(11) NOT NULL DEFAULT '100',
87 `truckskill` int(11) NOT NULL DEFAULT '0',
88 `aptechka` int(11) NOT NULL DEFAULT '0',
89 `Voennik` int(11) NOT NULL DEFAULT '0',
90 `music` int(11) NOT NULL DEFAULT '0',
91 `improves` varchar(32) NOT NULL DEFAULT '0, 0, 0, 0',
92 `datavhod` varchar(15) NOT NULL DEFAULT '0.0.0',
93 `settings` varchar(32) NOT NULL DEFAULT '0,0,0,0,0',
94 `phnumber1` int(11) NOT NULL DEFAULT '0',
95 `phnumber2` int(11) NOT NULL DEFAULT '0',
96 `phnumber3` int(11) NOT NULL DEFAULT '0',
97 `phnumber4` int(11) NOT NULL DEFAULT '0',
98 `phnumber5` int(11) NOT NULL DEFAULT '0',
99 `phnumber6` int(11) NOT NULL DEFAULT '0',
100 `phnumber7` int(11) NOT NULL DEFAULT '0',
101 `phnumber8` int(11) NOT NULL DEFAULT '0',
102 `mailconf` int(11) NOT NULL DEFAULT '0',
103 `fishki` int(11) NOT NULL DEFAULT '0',
104 `family` int(11) NOT NULL,
105 `familysozd` int(11) NOT NULL,
106 `familyzam` int(11) NOT NULL,
107 `black0` int(1) NOT NULL,
108 `black1` int(1) NOT NULL,
109 `black2` int(1) NOT NULL,
110 `black3` int(1) NOT NULL,
111 `black4` int(1) NOT NULL,
112 `black5` int(1) NOT NULL,
113 `black6` int(1) NOT NULL,
114 `black7` int(1) NOT NULL,
115 `black8` int(1) NOT NULL,
116 `black9` int(1) NOT NULL,
117 `black10` int(1) NOT NULL,
118 `black11` int(11) NOT NULL,
119 `black12` int(11) NOT NULL,
120 `set1` int(1) NOT NULL,
121 `set2` int(1) NOT NULL,
122 `set3` int(1) NOT NULL,
123 `set4` int(1) NOT NULL,
124 `set5` int(1) NOT NULL DEFAULT '1',
125 `set6` int(1) NOT NULL,
126 `set7` int(1) NOT NULL,
127 `donatepay` int(11) NOT NULL,
128 `garage` int(20) NOT NULL DEFAULT '-1',
129 `familyrank` int(11) NOT NULL,
130 `lwarn` int(11) NOT NULL,
131 `countcars` int(11) NOT NULL DEFAULT '2',
132 `leaderstats` varchar(32) NOT NULL DEFAULT '0,0,0,0,0,0',
133 `mats` int(11) NOT NULL,
134 `google` int(11) NOT NULL,
135 `googlecode` varchar(17) NOT NULL,
136 `LockPick` int(11) NOT NULL,
137 `bonusday` int(11) NOT NULL,
138 `bonusdaytime` int(11) NOT NULL,
139 PRIMARY KEY (`id`),
140 KEY `name` (`name`),
141 KEY `id` (`id`),
142 KEY `password` (`password`),
143 KEY `settings` (`settings`)
144) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=45206 ;
145
146
147CREATE TABLE IF NOT EXISTS `admin` (
148 `name` varchar(24) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
149 `level` int(2) NOT NULL,
150 `password` varchar(32) NOT NULL DEFAULT 'qwerty',
151 `last_connect` varchar(15) NOT NULL,
152 `put_admin` varchar(24) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
153 `data` varchar(15) NOT NULL,
154 `a_goto` int(1) NOT NULL,
155 `a_gethere` int(1) NOT NULL,
156 `a_spec` int(1) NOT NULL,
157 `timemin` int(11) NOT NULL,
158 `awarn` int(11) NOT NULL,
159 `Bans` int(11) NOT NULL DEFAULT '0',
160 `Warns` int(11) NOT NULL DEFAULT '0',
161 `Prison` int(11) NOT NULL DEFAULT '0',
162 `Kicks` int(11) NOT NULL DEFAULT '0',
163 `Pm` int(11) NOT NULL DEFAULT '0',
164 `Mutes` int(11) NOT NULL DEFAULT '0',
165 `act_time` int(11) NOT NULL DEFAULT '0',
166 `security` int(11) NOT NULL,
167 `securitycode` varchar(17) NOT NULL,
168 `warnreason` varchar(64) NOT NULL DEFAULT 'None',
169 `timeday` int(11) NOT NULL,
170 `sunday` varchar(64) NOT NULL DEFAULT '0,0,0,0,0,0,0',
171 `monday` varchar(64) NOT NULL DEFAULT '0,0,0,0,0,0,0',
172 `tuesday` varchar(64) NOT NULL DEFAULT '0,0,0,0,0,0,0',
173 `wednesday` varchar(64) NOT NULL DEFAULT '0,0,0,0,0,0,0',
174 `thursday` varchar(64) NOT NULL DEFAULT '0,0,0,0,0,0,0',
175 `friday` varchar(64) NOT NULL DEFAULT '0,0,0,0,0,0,0',
176 `saturday` varchar(64) NOT NULL DEFAULT '0,0,0,0,0,0,0',
177 PRIMARY KEY (`name`)
178) ENGINE=InnoDB DEFAULT CHARSET=utf8;
179
180
181CREATE TABLE IF NOT EXISTS `atm` (
182 `ID` int(11) NOT NULL,
183 `aX` varchar(15) NOT NULL,
184 `aY` varchar(15) NOT NULL,
185 `aZ` varchar(15) NOT NULL,
186 `arX` varchar(15) NOT NULL,
187 `arY` varchar(15) NOT NULL,
188 `arZ` varchar(15) NOT NULL
189) ENGINE=MyISAM DEFAULT CHARSET=utf8;
190
191CREATE TABLE IF NOT EXISTS `bans` (
192 `name` varchar(24) NOT NULL,
193 `whobanned` varchar(24) NOT NULL,
194 `ip` varchar(16) NOT NULL,
195 `bandate` varchar(32) NOT NULL,
196 `time` int(11) NOT NULL,
197 `unbandate` varchar(15) NOT NULL,
198 `reason` varchar(32) NOT NULL,
199 PRIMARY KEY (`name`)
200) ENGINE=MyISAM DEFAULT CHARSET=utf8;
201
202CREATE TABLE IF NOT EXISTS `bizz` (
203 `id` int(11) NOT NULL AUTO_INCREMENT,
204 `owner` varchar(24) NOT NULL DEFAULT 'None',
205 `type` int(11) NOT NULL DEFAULT '1',
206 `price` int(11) NOT NULL DEFAULT '100000',
207 `buyprice` int(11) NOT NULL DEFAULT '0',
208 `money` int(11) NOT NULL DEFAULT '500000',
209 `lic` int(11) NOT NULL DEFAULT '0',
210 `x` varchar(11) NOT NULL DEFAULT '0.0',
211 `y` varchar(11) NOT NULL DEFAULT '0.0',
212 `z` varchar(11) NOT NULL DEFAULT '0.0',
213 `xt` varchar(11) NOT NULL DEFAULT '0.0',
214 `yt` varchar(11) NOT NULL DEFAULT '0.0',
215 `zt` varchar(11) NOT NULL DEFAULT '0.0',
216 `menux` varchar(11) NOT NULL DEFAULT '0.0',
217 `menuy` varchar(11) NOT NULL DEFAULT '0.0',
218 `menuz` varchar(11) NOT NULL DEFAULT '0.0',
219 `vint` int(11) NOT NULL DEFAULT '0',
220 `virt` int(11) NOT NULL DEFAULT '0',
221 `icon` int(11) NOT NULL DEFAULT '4',
222 `name` varchar(32) NOT NULL DEFAULT 'None',
223 `penter` int(11) NOT NULL DEFAULT '100',
224 `block` int(11) NOT NULL DEFAULT '0',
225 `product` int(11) NOT NULL DEFAULT '0',
226 `till` int(11) NOT NULL DEFAULT '50',
227 `locktime` int(11) NOT NULL DEFAULT '0',
228 `mafia` int(11) NOT NULL DEFAULT '0',
229 `oplata` int(11) NOT NULL,
230 PRIMARY KEY (`id`)
231) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=115 ;
232
233
234CREATE TABLE IF NOT EXISTS `bug` (
235 `id` int(11) NOT NULL AUTO_INCREMENT,
236 `name` varchar(24) NOT NULL,
237 `svias` varchar(100) NOT NULL,
238 `text` text NOT NULL,
239 `time` date NOT NULL,
240 PRIMARY KEY (`id`)
241) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
242
243CREATE TABLE IF NOT EXISTS `family_system` (
244 `fam_id` int(11) NOT NULL AUTO_INCREMENT,
245 `fam_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
246 `fam_creator` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
247 `fam_data` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
248 `fam_chat_color` int(11) NOT NULL,
249 `fam_members_amount` int(11) NOT NULL,
250 `fam_zamcreator` varchar(24) CHARACTER SET latin1 NOT NULL,
251 `fam_sklad_dostup` int(11) NOT NULL,
252 `fam_spawn` int(11) NOT NULL,
253 `fam_spawn_x` float NOT NULL,
254 `fam_spawn_y` float NOT NULL,
255 `fam_spawn_z` float NOT NULL,
256 `fam_money` int(11) NOT NULL,
257 `fam_narko` int(11) NOT NULL,
258 `fam_patr` int(11) NOT NULL,
259 `fam_ranks` varchar(100) NOT NULL DEFAULT 'none, none, none, none, none, none, none',
260 `fam_int` int(11) NOT NULL,
261 `fam_world` int(11) NOT NULL,
262 PRIMARY KEY (`fam_id`)
263) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=117 ;
264
265
266CREATE TABLE IF NOT EXISTS `fullaccess` (
267 `id` int(11) NOT NULL AUTO_INCREMENT,
268 `name` varchar(24) NOT NULL,
269 `rank` varchar(64) NOT NULL DEFAULT 'Пидор',
270 PRIMARY KEY (`id`)
271) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=9 ;
272
273CREATE TABLE IF NOT EXISTS `gang` (
274 `grovebank` int(11) NOT NULL DEFAULT '0',
275 `ballasbank` int(11) NOT NULL DEFAULT '0',
276 `rifabank` int(11) NOT NULL DEFAULT '0',
277 `aztecbank` int(11) NOT NULL DEFAULT '0',
278 `vagosbank` int(11) NOT NULL DEFAULT '0',
279 `grovedrugs` int(11) NOT NULL DEFAULT '0',
280 `ballasdrugs` int(11) NOT NULL DEFAULT '0',
281 `rifadrugs` int(11) NOT NULL DEFAULT '0',
282 `aztecdrugs` int(11) NOT NULL DEFAULT '0',
283 `vagosdrugs` int(11) NOT NULL DEFAULT '0',
284 `grovepat` int(11) NOT NULL DEFAULT '0',
285 `ballaspat` int(11) NOT NULL DEFAULT '0',
286 `rifapat` int(11) NOT NULL DEFAULT '0',
287 `aztecpat` int(11) NOT NULL DEFAULT '0',
288 `vagospat` int(11) NOT NULL DEFAULT '0',
289 `groveed` int(11) NOT NULL DEFAULT '0',
290 `ballased` int(11) NOT NULL DEFAULT '0',
291 `rifaed` int(11) NOT NULL DEFAULT '0',
292 `azteced` int(11) NOT NULL DEFAULT '0',
293 `vagosed` int(11) NOT NULL DEFAULT '0',
294 `bcapt_g` int(1) NOT NULL DEFAULT '0',
295 `bcapt_b` int(1) NOT NULL DEFAULT '0',
296 `bcapt_r` int(1) NOT NULL DEFAULT '0',
297 `bcapt_a` int(1) NOT NULL DEFAULT '0',
298 `bcapt_v` int(1) NOT NULL DEFAULT '0',
299 `bskl_g` int(1) NOT NULL DEFAULT '0',
300 `bskl_b` int(1) NOT NULL DEFAULT '0',
301 `bskl_r` int(1) NOT NULL DEFAULT '0',
302 `bskl_a` int(1) NOT NULL DEFAULT '0',
303 `bskl_v` int(1) NOT NULL DEFAULT '0',
304 `spartak_mats` int(11) NOT NULL,
305 `cska_mats` int(11) NOT NULL,
306 `itmaf_mats` int(11) NOT NULL,
307 `rusmaf_mats` int(11) NOT NULL,
308 `army_mats` int(11) NOT NULL
309) ENGINE=MyISAM DEFAULT CHARSET=utf8;
310
311CREATE TABLE IF NOT EXISTS `gangzone` (
312 `id` int(4) NOT NULL AUTO_INCREMENT,
313 `ginfo1` float NOT NULL DEFAULT '0',
314 `ginfo2` float NOT NULL DEFAULT '0',
315 `ginfo3` float NOT NULL DEFAULT '0',
316 `ginfo4` float NOT NULL DEFAULT '0',
317 `fraction` int(3) NOT NULL DEFAULT '0',
318 PRIMARY KEY (`id`)
319) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=234 ;
320
321CREATE TABLE IF NOT EXISTS `garages` (
322 `id` int(11) NOT NULL AUTO_INCREMENT,
323 `enter_x` float NOT NULL,
324 `enter_y` float NOT NULL,
325 `enter_z` float NOT NULL,
326 `enter_x_car` float NOT NULL,
327 `enter_y_car` float NOT NULL,
328 `enter_z_car` float NOT NULL,
329 `enter_a_car` float NOT NULL,
330 `exit_x` float NOT NULL,
331 `exit_y` float NOT NULL,
332 `exit_z` float NOT NULL,
333 `lock` int(11) NOT NULL,
334 `type` int(11) NOT NULL,
335 `owner` varchar(24) NOT NULL,
336 `owned` int(11) NOT NULL,
337 `price` int(11) NOT NULL,
338 `update` int(11) NOT NULL,
339 `int` int(11) NOT NULL,
340 `world` int(11) NOT NULL,
341 `day` int(11) NOT NULL,
342 PRIMARY KEY (`id`)
343) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=247 ;
344
345CREATE TABLE IF NOT EXISTS `gdonate_payments` (
346 `id` int(10) NOT NULL AUTO_INCREMENT,
347 `gdonateId` varchar(255) NOT NULL,
348 `account` varchar(255) NOT NULL,
349 `sum` float NOT NULL,
350 `itemsCount` int(11) NOT NULL DEFAULT '1',
351 `dateCreate` datetime NOT NULL,
352 `dateComplete` datetime DEFAULT NULL,
353 `status` tinyint(4) NOT NULL DEFAULT '0',
354 PRIMARY KEY (`id`)
355) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
356
357
358CREATE TABLE IF NOT EXISTS `helicopters` (
359 `id` int(11) NOT NULL AUTO_INCREMENT,
360 `h_model` int(11) NOT NULL,
361 `h_owner` varchar(24) NOT NULL DEFAULT 'none',
362 `h_color` int(11) NOT NULL,
363 `h_lock` int(11) NOT NULL,
364 `h_price` int(11) NOT NULL,
365 `h_timer` int(11) NOT NULL,
366 PRIMARY KEY (`id`),
367 UNIQUE KEY `id` (`id`)
368) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2909 ;
369
370CREATE TABLE IF NOT EXISTS `historyname` (
371 `id` int(5) NOT NULL AUTO_INCREMENT,
372 `idacca` varchar(30) COLLATE cp1251_bin DEFAULT NULL,
373 `name` varchar(30) COLLATE cp1251_bin DEFAULT NULL,
374 PRIMARY KEY (`id`),
375 UNIQUE KEY `id` (`id`)
376) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_bin ROW_FORMAT=FIXED AUTO_INCREMENT=565 ;
377
378CREATE TABLE IF NOT EXISTS `house` (
379 `id` int(11) NOT NULL AUTO_INCREMENT,
380 `hEntrx` varchar(10) NOT NULL DEFAULT '0.0',
381 `hEntry` varchar(10) NOT NULL DEFAULT '0.0',
382 `hEntrz` varchar(10) NOT NULL DEFAULT '0.0',
383 `hExitx` varchar(10) NOT NULL DEFAULT '0.0',
384 `hExity` varchar(10) NOT NULL DEFAULT '0.0',
385 `hExitz` varchar(10) NOT NULL DEFAULT '0.0',
386 `carx` varchar(10) NOT NULL DEFAULT '0.0',
387 `cary` varchar(10) NOT NULL DEFAULT '0.0',
388 `carz` varchar(10) NOT NULL DEFAULT '0.0',
389 `carfa` varchar(10) NOT NULL DEFAULT '0.0',
390 `hOwner` varchar(24) NOT NULL DEFAULT 'None',
391 `hDiscript` varchar(16) NOT NULL DEFAULT 'Дом',
392 `hPrice` int(11) NOT NULL DEFAULT '10000',
393 `buyprice` int(11) NOT NULL DEFAULT '0',
394 `hInt` int(11) NOT NULL DEFAULT '0',
395 `hVirtual` int(11) NOT NULL DEFAULT '0',
396 `hLock` int(11) NOT NULL DEFAULT '0',
397 `hOplata` int(11) NOT NULL DEFAULT '0',
398 `hHeal` int(11) NOT NULL DEFAULT '0',
399 `hGarage` int(11) NOT NULL DEFAULT '0',
400 `hAutoDoors` int(1) NOT NULL DEFAULT '0',
401 `hCS` int(1) NOT NULL DEFAULT '0',
402 `hMoney` int(30) NOT NULL DEFAULT '0',
403 `hPatrons` int(30) NOT NULL DEFAULT '0',
404 `hDrugs` int(30) NOT NULL DEFAULT '0',
405 `hArendName` varchar(80) NOT NULL DEFAULT 'none,none,none',
406 `hRublevka` int(11) NOT NULL DEFAULT '0',
407 `hVertX` float NOT NULL DEFAULT '0',
408 `hVertY` float NOT NULL DEFAULT '0',
409 `hVertZ` float NOT NULL DEFAULT '0',
410 `hVertA` float NOT NULL DEFAULT '0',
411 PRIMARY KEY (`id`)
412) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=276 ;
413
414CREATE TABLE IF NOT EXISTS `inventory` (
415 `Name` varchar(32) NOT NULL,
416 `Slot0` int(11) NOT NULL,
417 `Amt0` int(11) NOT NULL,
418 `Value0` varchar(32) NOT NULL,
419 `Slot1` int(11) NOT NULL,
420 `Amt1` int(11) NOT NULL,
421 `Value1` varchar(32) NOT NULL,
422 `Slot2` int(11) NOT NULL,
423 `Amt2` int(11) NOT NULL,
424 `Value2` varchar(32) NOT NULL,
425 `Slot3` int(11) NOT NULL,
426 `Amt3` int(11) NOT NULL,
427 `Value3` varchar(32) NOT NULL,
428 `Slot4` int(11) NOT NULL,
429 `Amt4` int(11) NOT NULL,
430 `Value4` varchar(32) NOT NULL,
431 `Slot5` int(11) NOT NULL,
432 `Amt5` int(11) NOT NULL,
433 `Value5` varchar(32) NOT NULL,
434 `Slot6` int(11) NOT NULL,
435 `Amt6` int(11) NOT NULL,
436 `Value6` varchar(32) NOT NULL,
437 `Slot7` int(11) NOT NULL,
438 `Amt7` int(11) NOT NULL,
439 `Value7` varchar(32) NOT NULL,
440 `Slot8` int(11) NOT NULL,
441 `Amt8` int(11) NOT NULL,
442 `Value8` varchar(32) NOT NULL,
443 `Slot9` int(11) NOT NULL,
444 `Amt9` int(11) NOT NULL,
445 `Value9` varchar(32) NOT NULL,
446 `Slot10` int(11) NOT NULL,
447 `Amt10` int(11) NOT NULL,
448 `Value10` varchar(32) NOT NULL,
449 `Slot11` int(11) NOT NULL,
450 `Amt11` int(11) NOT NULL,
451 `Value11` varchar(32) NOT NULL,
452 `Slot12` int(11) NOT NULL,
453 `Amt12` int(11) NOT NULL,
454 `Value12` varchar(32) NOT NULL,
455 `Slot13` int(11) NOT NULL,
456 `Amt13` int(11) NOT NULL,
457 `Value13` varchar(32) NOT NULL,
458 `Slot14` int(11) NOT NULL,
459 `Amt14` int(11) NOT NULL,
460 `Value14` varchar(32) NOT NULL,
461 `Slot15` int(11) NOT NULL,
462 `Amt15` int(11) NOT NULL,
463 `Value15` varchar(32) NOT NULL,
464 `Slot16` int(11) NOT NULL,
465 `Amt16` int(11) NOT NULL,
466 `Value16` varchar(32) NOT NULL,
467 KEY `Name` (`Name`)
468) ENGINE=MyISAM DEFAULT CHARSET=utf8;
469
470CREATE TABLE IF NOT EXISTS `mafia` (
471 `yakuzabank` int(11) NOT NULL DEFAULT '0',
472 `lcnbank` int(11) NOT NULL DEFAULT '0',
473 `rmbank` int(11) NOT NULL DEFAULT '0',
474 `yakuzadrugs` int(11) NOT NULL DEFAULT '0',
475 `lcndrugs` int(11) NOT NULL DEFAULT '0',
476 `rmdrugs` int(11) NOT NULL DEFAULT '0',
477 `lcnpat` int(11) NOT NULL DEFAULT '0',
478 `yakpat` int(11) NOT NULL DEFAULT '0',
479 `rmpat` int(11) NOT NULL DEFAULT '0',
480 `lcned` int(11) NOT NULL DEFAULT '0',
481 `yaked` int(11) NOT NULL DEFAULT '0',
482 `rmed` int(11) NOT NULL DEFAULT '0',
483 `bskl_l` int(11) NOT NULL DEFAULT '0',
484 `bskl_y` int(11) NOT NULL DEFAULT '0',
485 `bskl_r` int(11) NOT NULL DEFAULT '0'
486) ENGINE=MyISAM DEFAULT CHARSET=utf8;
487
488CREATE TABLE IF NOT EXISTS `news_ucp` (
489 `id` int(11) NOT NULL,
490 `title` varchar(128) NOT NULL,
491 `title2` varchar(128) NOT NULL,
492 `text` text NOT NULL,
493 `time` date NOT NULL
494) ENGINE=InnoDB DEFAULT CHARSET=utf8;
495
496CREATE TABLE IF NOT EXISTS `online_cases` (
497 `id` int(11) NOT NULL AUTO_INCREMENT,
498 `number` int(11) NOT NULL DEFAULT '0',
499 `number_case` int(11) NOT NULL DEFAULT '0',
500 `name` varchar(24) NOT NULL,
501 `status` int(11) NOT NULL DEFAULT '0',
502 PRIMARY KEY (`id`)
503) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=14 ;
504
505CREATE TABLE IF NOT EXISTS `other` (
506 `lsnbank` int(11) NOT NULL DEFAULT '0',
507 `sfnbank` int(11) NOT NULL DEFAULT '0',
508 `lvnbank` int(11) NOT NULL DEFAULT '0',
509 `newsprice` varchar(40) NOT NULL DEFAULT '15, 15, 2, 2, 8, 8',
510 `jobprice` varchar(40) NOT NULL DEFAULT '0, 0, 0, 0, 0, 0',
511 `merpanel` varchar(40) NOT NULL DEFAULT '0, 0, 0, 0, 0, 0',
512 `mdpanel` varchar(40) NOT NULL DEFAULT '1, 1, 1, 1, 1, 1',
513 `mineral` int(11) NOT NULL DEFAULT '0',
514 `guncoal` int(11) NOT NULL DEFAULT '0',
515 `gunwood` int(11) NOT NULL DEFAULT '0',
516 `gun` int(11) NOT NULL DEFAULT '0',
517 `drova` int(11) NOT NULL DEFAULT '0',
518 `armygun` int(11) NOT NULL DEFAULT '0',
519 `armyammo` int(11) NOT NULL DEFAULT '0',
520 `d_exp` int(1) NOT NULL DEFAULT '0',
521 `d_donate` int(1) NOT NULL DEFAULT '1',
522 `d_jobik` int(1) NOT NULL DEFAULT '0',
523 `lp0` varchar(40) NOT NULL DEFAULT '0, 0, 0, 0, 0, 0',
524 `lp1` varchar(40) NOT NULL DEFAULT '0, 0, 0, 0, 0, 0',
525 `lp2` varchar(40) NOT NULL DEFAULT '0, 0, 0, 0, 0, 0',
526 `lp3` varchar(40) NOT NULL DEFAULT '0, 0, 0, 0, 0, 0',
527 `lp4` varchar(40) NOT NULL DEFAULT '0, 0, 0, 0, 0, 0',
528 `lp5` varchar(40) NOT NULL DEFAULT '0, 0, 0, 0, 0, 0',
529 `materials` int(11) NOT NULL,
530 `happy_hours` int(11) NOT NULL
531) ENGINE=MyISAM DEFAULT CHARSET=utf8;
532
533CREATE TABLE IF NOT EXISTS `ownable_cars` (
534 `id` int(11) NOT NULL AUTO_INCREMENT,
535 `c_model` int(11) NOT NULL,
536 `c_x` float NOT NULL,
537 `c_y` float NOT NULL,
538 `c_z` float NOT NULL,
539 `c_a` float NOT NULL,
540 `c_class` int(11) NOT NULL,
541 `c_owner` varchar(24) NOT NULL DEFAULT 'none',
542 `c_fuel` int(11) NOT NULL,
543 `c_color1` int(11) NOT NULL,
544 `c_color2` int(11) NOT NULL,
545 `c_lock` int(11) NOT NULL,
546 `c_price` int(11) NOT NULL,
547 `c_vehcom` varchar(64) NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0,0,0,0,0,0',
548 `c_number` varchar(64) NOT NULL DEFAULT 'None',
549 `c_paintjob` int(11) NOT NULL,
550 `c_status` int(11) NOT NULL DEFAULT '0',
551 `c_world` int(11) NOT NULL,
552 `c_trunk` varchar(64) NOT NULL DEFAULT '0,0,0,0,0,0,0',
553 `c_update` int(11) NOT NULL DEFAULT '0',
554 `c_mileage` float NOT NULL DEFAULT '0',
555 `c_health` float NOT NULL,
556 PRIMARY KEY (`id`),
557 KEY `id` (`id`),
558 KEY `c_owner` (`c_owner`),
559 KEY `c_number` (`c_number`),
560 KEY `c_status` (`c_status`)
561) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=76535 ;
562
563CREATE TABLE IF NOT EXISTS `ownable_numbers` (
564 `id` int(11) NOT NULL AUTO_INCREMENT,
565 `number` varchar(64) NOT NULL,
566 `is_used` int(11) NOT NULL,
567 PRIMARY KEY (`id`),
568 UNIQUE KEY `number` (`number`),
569 KEY `is_used` (`is_used`)
570) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1331001 ;
571
572
573CREATE TABLE IF NOT EXISTS `passports` (
574 `Name` varchar(24) NOT NULL,
575 `Seria` int(11) NOT NULL,
576 `Number` int(11) NOT NULL,
577 `Sex` int(11) NOT NULL,
578 `D_Day` int(11) NOT NULL,
579 `D_Month` int(11) NOT NULL,
580 `D_Year` int(11) NOT NULL,
581 `DB_Day` int(11) NOT NULL,
582 `DB_Month` int(11) NOT NULL,
583 `DB_Year` int(11) NOT NULL,
584 `City` int(11) NOT NULL,
585 `McState` int(11) NOT NULL
586) ENGINE=MyISAM DEFAULT CHARSET=utf8;
587
588
589CREATE TABLE IF NOT EXISTS `pickup_data` (
590 `id` int(11) NOT NULL AUTO_INCREMENT,
591 `e_x` float NOT NULL,
592 `e_y` float NOT NULL,
593 `e_z` float NOT NULL,
594 `e_r` float NOT NULL,
595 `v_x` float NOT NULL,
596 `v_y` float NOT NULL,
597 `v_z` float NOT NULL,
598 `v_r` float NOT NULL,
599 `name` varchar(32) NOT NULL,
600 `e_int` int(11) NOT NULL,
601 `e_world` int(11) NOT NULL,
602 `type` int(11) NOT NULL,
603 `dostup` int(11) NOT NULL,
604 `fraction` int(11) NOT NULL,
605 PRIMARY KEY (`id`)
606) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=32 ;
607
608CREATE TABLE IF NOT EXISTS `podezd` (
609 `idpodezd` int(11) NOT NULL AUTO_INCREMENT,
610 `poX` float NOT NULL DEFAULT '0',
611 `poY` float NOT NULL DEFAULT '0',
612 `poZ` float NOT NULL DEFAULT '0',
613 `poExitX` float NOT NULL DEFAULT '0',
614 `poExitY` float NOT NULL DEFAULT '0',
615 `poExitZ` float NOT NULL DEFAULT '0',
616 `poI` varchar(32) NOT NULL DEFAULT '0',
617 `poV` varchar(16) NOT NULL DEFAULT '0',
618 `poType` int(11) NOT NULL DEFAULT '0',
619 `poSphereEnter` int(11) NOT NULL DEFAULT '0',
620 `poSphereExit` int(11) NOT NULL DEFAULT '0',
621 `poPickup` int(11) NOT NULL DEFAULT '0',
622 `poPickupExit` int(11) NOT NULL DEFAULT '0',
623 PRIMARY KEY (`idpodezd`)
624) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=611 ;
625
626CREATE TABLE IF NOT EXISTS `promo` (
627 `name` varchar(24) NOT NULL,
628 `activate` int(11) NOT NULL,
629 `block` int(11) NOT NULL,
630 `nactivations` int(11) NOT NULL,
631 `date` varchar(32) NOT NULL,
632 `typepriz` int(11) NOT NULL,
633 `amountpriz` int(11) NOT NULL,
634 PRIMARY KEY (`name`)
635) ENGINE=InnoDB DEFAULT CHARSET=utf8;
636
637CREATE TABLE IF NOT EXISTS `promo_activations` (
638 `id` int(11) NOT NULL AUTO_INCREMENT,
639 `account_id` int(11) NOT NULL,
640 `name_promo` varchar(30) NOT NULL,
641 PRIMARY KEY (`id`)
642) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1300 ;
643
644
645
646CREATE TABLE IF NOT EXISTS `radar` (
647 `r_id` int(11) NOT NULL AUTO_INCREMENT,
648 `r_name` varchar(24) NOT NULL,
649 `r_type` int(11) NOT NULL,
650 `r_speed` int(11) NOT NULL,
651 `r_x` float NOT NULL,
652 `r_y` float NOT NULL,
653 `r_z` float NOT NULL,
654 `r_a` float NOT NULL,
655 PRIMARY KEY (`r_id`)
656) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
657
658CREATE TABLE IF NOT EXISTS `rooms` (
659 `id` int(11) NOT NULL AUTO_INCREMENT,
660 `rX` float NOT NULL DEFAULT '0',
661 `rY` float NOT NULL DEFAULT '0',
662 `rZ` float NOT NULL DEFAULT '0',
663 `rV` float NOT NULL DEFAULT '0',
664 `rI` float NOT NULL DEFAULT '0',
665 `rExitX` float NOT NULL DEFAULT '0',
666 `rExitY` float NOT NULL DEFAULT '0',
667 `rExitZ` float NOT NULL DEFAULT '0',
668 `rExitV` float NOT NULL DEFAULT '0',
669 `rExitI` float NOT NULL DEFAULT '0',
670 `rType` int(11) NOT NULL DEFAULT '0',
671 `rCost` int(11) NOT NULL DEFAULT '0',
672 `rOwner` varchar(32) NOT NULL DEFAULT 'None',
673 `rOplata` int(11) NOT NULL DEFAULT '0',
674 `rLock` int(11) NOT NULL DEFAULT '0',
675 `rPickupEnter` int(11) NOT NULL DEFAULT '0',
676 `rPickupExit` int(11) NOT NULL DEFAULT '0',
677 `rSphereEnter` int(11) NOT NULL DEFAULT '0',
678 `rSphereExit` int(11) NOT NULL DEFAULT '0',
679 PRIMARY KEY (`id`),
680 KEY `id` (`id`),
681 KEY `rOwner` (`rOwner`)
682) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11525 ;
683
684CREATE TABLE IF NOT EXISTS `site_settings` (
685 `group_vk` varchar(64) NOT NULL DEFAULT 'unknown',
686 `name_server` varchar(64) NOT NULL DEFAULT 'unknown',
687 `ip_server` varchar(64) NOT NULL DEFAULT 'unknown',
688 `id_toplay` int(11) NOT NULL DEFAULT '0',
689 `table_acc` varchar(32) NOT NULL DEFAULT 'unknown',
690 `table_admin` varchar(32) NOT NULL DEFAULT 'unknown',
691 `field_name` varchar(32) NOT NULL DEFAULT 'unknown',
692 `field_password` varchar(32) NOT NULL DEFAULT 'unknown',
693 `field_admpass` varchar(32) NOT NULL DEFAULT 'unknown',
694 `field_exp` varchar(32) NOT NULL DEFAULT 'unknown',
695 `field_level` varchar(32) NOT NULL DEFAULT 'unknown',
696 `field_id` varchar(32) NOT NULL DEFAULT 'unknown',
697 `field_model` varchar(32) NOT NULL DEFAULT 'unknown',
698 `field_phone` varchar(32) NOT NULL DEFAULT 'unknown',
699 `field_phonecash` varchar(32) NOT NULL DEFAULT 'unknown',
700 `field_cash` varchar(32) NOT NULL DEFAULT 'unknown',
701 `field_bank` varchar(32) NOT NULL DEFAULT 'unknown',
702 `field_donate` varchar(32) NOT NULL DEFAULT 'unknown',
703 `field_fraction` varchar(32) NOT NULL DEFAULT 'unknown',
704 `field_rank` varchar(32) NOT NULL DEFAULT 'unknown',
705 `field_job` varchar(32) NOT NULL DEFAULT 'unknown',
706 `field_lic` varchar(32) NOT NULL DEFAULT 'unknown',
707 `field_sdpistol` varchar(32) NOT NULL DEFAULT 'unknown',
708 `field_deserteagle` varchar(32) NOT NULL DEFAULT 'unknown',
709 `field_shotgun` varchar(32) NOT NULL DEFAULT 'unknown',
710 `field_mp5` varchar(32) NOT NULL DEFAULT 'unknown',
711 `field_ak47` varchar(32) NOT NULL DEFAULT 'unknown',
712 `field_m4` varchar(32) NOT NULL DEFAULT 'unknown',
713 `field_mask` varchar(32) NOT NULL DEFAULT 'unknown',
714 `field_metall` varchar(32) NOT NULL DEFAULT 'unknown',
715 `field_patron` varchar(32) NOT NULL DEFAULT 'unknown',
716 `field_health` varchar(32) NOT NULL DEFAULT 'unknown'
717) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
718
719CREATE TABLE IF NOT EXISTS `unitpay_payments` (
720 `id` int(10) NOT NULL AUTO_INCREMENT,
721 `unitpayId` varchar(255) NOT NULL,
722 `account` varchar(255) NOT NULL,
723 `sum` float NOT NULL,
724 `itemsCount` int(11) NOT NULL DEFAULT '1',
725 `dateCreate` datetime NOT NULL,
726 `dateComplete` datetime DEFAULT NULL,
727 `status` tinyint(4) NOT NULL DEFAULT '0',
728 PRIMARY KEY (`id`)
729) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1333 ;
730
731CREATE TABLE IF NOT EXISTS `vehicle` (
732 `id` int(11) NOT NULL AUTO_INCREMENT,
733 `model` int(11) NOT NULL DEFAULT '0',
734 `x` varchar(10) NOT NULL DEFAULT '0',
735 `y` varchar(10) NOT NULL DEFAULT '0',
736 `z` varchar(10) NOT NULL DEFAULT '0',
737 `fa` varchar(10) NOT NULL DEFAULT '0',
738 `vint` int(11) NOT NULL DEFAULT '0',
739 `world` int(11) NOT NULL,
740 `colors` varchar(10) NOT NULL DEFAULT '0, 0',
741 `fraction` int(11) NOT NULL DEFAULT '0',
742 `status` int(11) NOT NULL DEFAULT '0',
743 `cost` int(11) NOT NULL DEFAULT '0',
744 `mileage` float NOT NULL DEFAULT '0',
745 `dostup` int(11) NOT NULL DEFAULT '1',
746 PRIMARY KEY (`id`)
747) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=153 ;
748
749CREATE TABLE IF NOT EXISTS `visits` (
750 `ip` varchar(32) NOT NULL DEFAULT '0.0.0.0',
751 `date` date NOT NULL
752) ENGINE=InnoDB DEFAULT CHARSET=utf8;
753
754CREATE TABLE IF NOT EXISTS `yacht` (
755 `id` int(11) NOT NULL AUTO_INCREMENT,
756 `y_model` int(11) NOT NULL,
757 `y_owner` varchar(24) NOT NULL,
758 `y_color` int(11) NOT NULL,
759 `y_lock` int(11) NOT NULL,
760 `y_price` int(11) NOT NULL,
761 `y_x` float NOT NULL,
762 `y_y` float NOT NULL,
763 `y_z` float NOT NULL,
764 `y_r` float NOT NULL,
765 PRIMARY KEY (`id`)
766) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2011 ;