iffgaVaL

1
2
3CREATE TABLE IF NOT EXISTS `data_players` (
4`uid` int(11) NOT NULL AUTO_INCREMENT,
5`playerid` int(11) NOT NULL,
6`nick` VARCHAR( 24 ) CHARACTER SET ASCII NOT NULL,
7`password` VARCHAR( 50 ) NOT NULL,
8`ip` VARCHAR( 24 ) NOT NULL,
9`gpci` VARCHAR( 40 ) NOT NULL,
10`hp` float NOT NULL DEFAULT 10.77,
11`cash` INT(11)  NOT NULL,
12`cashbank` INT(11)  NOT NULL,
13`score` INT(11)  NOT NULL,
14`x` float NOT NULL DEFAULT 0.0,
15`y` float NOT NULL DEFAULT 0.0,
16`z` float NOT NULL DEFAULT 0.0,
17`a` float NOT NULL DEFAULT 0.0,
18`vw` INT(11)  NOT NULL,
19`int` INT(11)  NOT NULL,
20`lider` INT(11)  NOT NULL,
21`firma` INT(11)  NOT NULL,
22`frakcja` INT(11)  NOT NULL,
23`ranga` INT(11)  NOT NULL,
24`skin` INT(11)  NOT NULL,
25`muted` INT(11)  NOT NULL,
26`jail` INT(11)  NOT NULL,
27`czas_godziny` INT(11)  NOT NULL,
28`czas_minuty` INT(11)  NOT NULL,
29`vip` INT(11)  NOT NULL,
30`skuty` INT(11)  NOT NULL,
31`level` INT(11)  NOT NULL,
32`sila` INT(11)  NOT NULL,
33`dowod_osobisty` INT(11)  NOT NULL,
34`dowod_rejestracyjny` INT(11)  NOT NULL,
35`dowod_ubezpieczenie` INT(11)  NOT NULL,
36`dowod_paszport` INT(11)  NOT NULL,
37`warns` INT(11)  NOT NULL,
38`wantedlevel` INT(11)  NOT NULL,
39`lotto` INT(11)  NOT NULL,
40`klucze` INT(11)  NOT NULL,
41`sen` INT(11)  NOT NULL,
42`glod` INT(11)  NOT NULL,
43`adr` INT(11) NOT NULL,
44`firma_ranga` INT(11) NOT NULL,
45`firma_exp` INT(11) NOT NULL,
46`firma_towary` INT(11) NOT NULL,
47`firma_kasa` INT(11) NOT NULL,
48`czas_godziny_sluzba` INT(11) NOT NULL,
49`czas_minuty_sluzba` INT(11) NOT NULL,
50`privcars` INT(11) NOT NULL,
51`privhouses` INT(11) NOT NULL,
52`pkt_karne` INT(11) NOT NULL,
53`drive_h` INT(11) NOT NULL,
54`drive_m` INT(11) NOT NULL,
55`viatoll` INT(11)  NOT NULL,
56`prawojazdy_t_a` INT(11)  NOT NULL,
57`prawojazdy_t_b` INT(11)  NOT NULL,
58`prawojazdy_t_c` INT(11)  NOT NULL,
59`prawojazdy_t_d` INT(11)  NOT NULL,
60`prawojazdy_t_l` INT(11)  NOT NULL,
61`prawojazdy_p_a` INT(11)  NOT NULL,
62`prawojazdy_p_b` INT(11)  NOT NULL,
63`prawojazdy_p_c` INT(11)  NOT NULL,
64`prawojazdy_p_d` INT(11)  NOT NULL,
65`prawojazdy_p_l` INT(11)  NOT NULL,
66PRIMARY KEY (`uid`)
67) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
68
69
70
71
72
73
74
75
76
77
78CREATE TABLE IF NOT EXISTS `data_budynki` (
79`uid` int(11) NOT NULL AUTO_INCREMENT,
80`owneruid` INT(11)  NOT NULL,
81`owner` VARCHAR( 24 ) NOT NULL,
82`pickup` float NOT NULL DEFAULT 10.77,
83`mapicon` INT(11)  NOT NULL,
84`type` INT(11)  NOT NULL,
85`vw` INT(11)  NOT NULL,
86`int` INT(11)  NOT NULL,
87`x_pos_in` float NOT NULL DEFAULT 0.0,
88`y_pos_in` float NOT NULL DEFAULT 0.0,
89`z_pos_in` float NOT NULL DEFAULT 0.0,
90`x_pos_out` float NOT NULL DEFAULT 0.0,
91`y_pos_out` float NOT NULL DEFAULT 0.0,
92`z_pos_out` float NOT NULL DEFAULT 0.0,
93`price` INT(11)  NOT NULL,
94`locked` INT(11)  NOT NULL,
95`level` INT(11)  NOT NULL,
96`opis` VARCHAR( 30 ) NOT NULL,
97`interior_house` INT(11)  NOT NULL,
98`aktywny` INT(11)  NOT NULL,
99`name` VARCHAR( 31 ) NOT NULL,
100PRIMARY KEY (`uid`)
101) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
102
103
104
105
106
107CREATE TABLE IF NOT EXISTS `data_frakcje` (
108`uid` int(11) NOT NULL AUTO_INCREMENT,
109`pieniadze` INT(11)  NOT NULL,
110PRIMARY KEY (`uid`)
111) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
112
113
114
115
116		
117CREATE TABLE IF NOT EXISTS `data_narkotyki` (
118`uid` int(11) NOT NULL AUTO_INCREMENT,
119`aktywny` INT(11)  NOT NULL,
120`tworca` VARCHAR( 24 ) NOT NULL,
121`frakcja` INT( 24 ) NOT NULL,
122`type` float NOT NULL DEFAULT 10.77,
123`vw` INT(11)  NOT NULL,
124`int` INT(11)  NOT NULL,
125`time` INT(11)  NOT NULL,
126`x` float NOT NULL DEFAULT 0.0,
127`y` float NOT NULL DEFAULT 0.0,
128`z` float NOT NULL DEFAULT 0.0,
129PRIMARY KEY (`uid`)
130) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
131
132
133
134
135CREATE TABLE IF NOT EXISTS `data_prawojazdy` (
136`uid` int(11) NOT NULL AUTO_INCREMENT,
137`type` INT(11)  NOT NULL,
138`x` float NOT NULL DEFAULT 0.0,
139`y` float NOT NULL DEFAULT 0.0,
140`z` float NOT NULL DEFAULT 0.0,
141PRIMARY KEY (`uid`)
142) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
143
144
145CREATE TABLE IF NOT EXISTS `data_pickups` (
146`uid` int(11) NOT NULL AUTO_INCREMENT,
147`aktywny` INT(11)  NOT NULL,
148`pickup` INT( 24 ) NOT NULL,
149`mapicon` INT( 24 ) NOT NULL,
150`type` float NOT NULL DEFAULT 10.77,
151`vw` INT(11)  NOT NULL,
152`int` INT(11)  NOT NULL,
153`cena` INT(11)  NOT NULL,
154`x` float NOT NULL DEFAULT 0.0,
155`y` float NOT NULL DEFAULT 0.0,
156`z` float NOT NULL DEFAULT 0.0,
157PRIMARY KEY (`uid`)
158) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
159
160
161CREATE TABLE IF NOT EXISTS `data_opinie` (
162`uid` int(11) NOT NULL AUTO_INCREMENT,
163`autor` VARCHAR( 30 ) NOT NULL,
164`tresc` VARCHAR( 128 ) NOT NULL,
165`ip` VARCHAR( 128 ) NOT NULL,
166`gpci` VARCHAR( 128 ) NOT NULL,
167`time` INT(11)  NOT NULL,
168PRIMARY KEY (`uid`)
169) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
170
171
172
173CREATE TABLE IF NOT EXISTS `data_towary` (
174`uid` int(11) NOT NULL AUTO_INCREMENT,
175`name` VARCHAR( 30 ) NOT NULL,
176`stan` INT( 11 ) NOT NULL,
177`dla` INT( 11 ) NOT NULL,
178`score_player` INT( 11) NOT NULL,
179`score_vip` INT( 11 ) NOT NULL,
180`kasa_player` INT( 11 ) NOT NULL,
181`kasa_vip` INT( 11 ) NOT NULL,
182`z_x` float NOT NULL DEFAULT 0.0,
183`z_y` float NOT NULL DEFAULT 0.0,
184`z_z` float NOT NULL DEFAULT 0.0,
185`r_x` float NOT NULL DEFAULT 0.0,
186`r_y` float NOT NULL DEFAULT 0.0,
187`r_z` float NOT NULL DEFAULT 0.0,
188`z_w` VARCHAR( 30 ) NOT NULL,
189`z_r` VARCHAR( 30 ) NOT NULL,
190`adr` INT( 11 ) NOT NULL,
191`exp` INT( 11 ) NOT NULL,
192`kasa_firma` INT( 11 ) NOT NULL,
193`legal` INT( 11 ) NOT NULL,
194`odgodz` INT( 11 ) NOT NULL,
195`dogodz` INT( 11 ) NOT NULL,
196PRIMARY KEY (`uid`)
197) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
198
199
200CREATE TABLE IF NOT EXISTS `data_vehicles` (
201`uid` int(11) NOT NULL AUTO_INCREMENT,
202`sampid` INT( 24 ) NOT NULL DEFAULT -1,
203`private` INT( 24 ) NOT NULL,
204`owneruid` INT( 24 ) NOT NULL,
205`owner` VARCHAR( 30 ) NOT NULL,
206`model` INT( 24 ) NOT NULL,
207`hp` float NOT NULL DEFAULT 0.0,
208`register` varchar(31) NOT NULL,
209`paliwo` float NOT NULL DEFAULT 100,
210`paliwotyp` INT( 24 ) NOT NULL,
211`przebieg` float NOT NULL DEFAULT 0.0,
212`kolor1` INT( 24 ) NOT NULL,
213`kolor2` INT( 24 ) NOT NULL,
214`panel` int(11) NOT NULL,
215`lights` int(11) NOT NULL,
216`tires` int(11) NOT NULL,
217`doors` int(11) NOT NULL,
218`locked` INT( 24 ) NOT NULL,
219`wheelsblocked` int(11) NOT NULL,
220`x` float NOT NULL DEFAULT 0.0,
221`y` float NOT NULL DEFAULT 0.0,
222`z` float NOT NULL DEFAULT 0.0,
223`a` float NOT NULL DEFAULT 0.0,
224`naprawy` float NOT NULL DEFAULT 0.0,
225`cb` INT( 24 ) NOT NULL,
226`firmy` INT( 24 ) NOT NULL,
227`frakcji` INT( 24 ) NOT NULL,
228`zlom` INT( 24 ) NOT NULL,
229`type` INT( 24 ) NOT NULL,
230PRIMARY KEY (`uid`)
231) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
232
233
234
235
236CREATE TABLE IF NOT EXISTS `data_bans` (
237`uid` int(11) NOT NULL AUTO_INCREMENT,
238`nick` VARCHAR( 24 ) NOT NULL,
239`admin` VARCHAR( 24 ) NOT NULL,
240`powod` VARCHAR( 30 ) NOT NULL,
241`data` VARCHAR( 50 ) NOT NULL,
242`ip` VARCHAR( 24 ) NOT NULL,
243`gpci` VARCHAR( 50 ) NOT NULL,
244`time` INT( 24 ) NOT NULL,
245PRIMARY KEY (`uid`)
246) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
247
248
249
250
251
252CREATE TABLE IF NOT EXISTS `data_przedmioty` (
253`uid` int(11) NOT NULL AUTO_INCREMENT,
254`owneruid` int(11) NOT NULL,
255`przedmiot` VARCHAR( 30 ) NOT NULL,
256`use` int(11) NOT NULL,
257`var1` int(11) NOT NULL,
258`var2` int(11) NOT NULL,
259`var3` int(11) NOT NULL,
260`var4` int(11) NOT NULL,
261`var5` int(11) NOT NULL,
262`var6` int(11) NOT NULL,
263PRIMARY KEY (`uid`)
264) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
265
266
267
268CREATE TABLE IF NOT EXISTS `data_viatoll` (
269`uid` int(11) NOT NULL AUTO_INCREMENT,
270`aktywny` int(11) NOT NULL,
271`pkt` int(11) NOT NULL,
272`kwota` int(11) NOT NULL,
273`x` float NOT NULL DEFAULT 0.0,
274`y` float NOT NULL DEFAULT 0.0,
275`z` float NOT NULL DEFAULT 0.0,
276`rx` float NOT NULL DEFAULT 0.0,
277`ry` float NOT NULL DEFAULT 0.0,
278`rz` float NOT NULL DEFAULT 0.0,
279`vw` int(11) NOT NULL,
280`int` int(11) NOT NULL,
281PRIMARY KEY (`uid`)
282) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
283
284
285CREATE TABLE IF NOT EXISTS `data_pozary` (
286`uid` int(11) NOT NULL AUTO_INCREMENT,
287`aktywny` int(11) NOT NULL,
288`type` int(11) NOT NULL,
289`x` float NOT NULL DEFAULT 0.0,
290`y` float NOT NULL DEFAULT 0.0,
291`z` float NOT NULL DEFAULT 0.0,
292`rx` float NOT NULL DEFAULT 0.0,
293`ry` float NOT NULL DEFAULT 0.0,
294`rz` float NOT NULL DEFAULT 0.0,
295`vw` int(11) NOT NULL,
296`int` int(11) NOT NULL,
297PRIMARY KEY (`uid`)
298) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
299
300
301CREATE TABLE IF NOT EXISTS `data_klody` (
302`uid` int(11) NOT NULL AUTO_INCREMENT,
303`aktywny` int(11) NOT NULL,
304`modelid` int(11) NOT NULL,
305`x` float NOT NULL DEFAULT 0.0,
306`y` float NOT NULL DEFAULT 0.0,
307`z` float NOT NULL DEFAULT 0.0,
308`rx` float NOT NULL DEFAULT 0.0,
309`ry` float NOT NULL DEFAULT 0.0,
310`rz` float NOT NULL DEFAULT 0.0,
311`vw` int(11) NOT NULL,
312`int` int(11) NOT NULL,
313PRIMARY KEY (`uid`)
314) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
315
316
317
318CREATE TABLE IF NOT EXISTS `data_fotoradary` (
319`uid` int(11) NOT NULL AUTO_INCREMENT,
320`aktywny` int(11) NOT NULL,
321`max` int(11) NOT NULL,
322`kara` int(11) NOT NULL,
323`x` float NOT NULL DEFAULT 0.0,
324`y` float NOT NULL DEFAULT 0.0,
325`z` float NOT NULL DEFAULT 0.0,
326`rx` float NOT NULL DEFAULT 0.0,
327`ry` float NOT NULL DEFAULT 0.0,
328`rz` float NOT NULL DEFAULT 0.0,
329`vw` int(11) NOT NULL,
330`int` int(11) NOT NULL,
331PRIMARY KEY (`uid`)
332) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
333
334
335
336
337
338CREATE TABLE IF NOT EXISTS `data_obiekty` (
339`uid` int(11) NOT NULL AUTO_INCREMENT,
340`aktywny` int(11) NOT NULL,
341`vw` int(11) NOT NULL,
342`int` int(11) NOT NULL,
343`modelid` int(11) NOT NULL,
344`type` int(11) NOT NULL,
345`x` float NOT NULL DEFAULT 0.0,
346`y` float NOT NULL DEFAULT 0.0,
347`z` float NOT NULL DEFAULT 0.0,
348`rx` float NOT NULL DEFAULT 0.0,
349`ry` float NOT NULL DEFAULT 0.0,
350`rz` float NOT NULL DEFAULT 0.0,
351`rfirma` int(11) NOT NULL,
352`rfrakcja` int(11) NOT NULL,
353`move` int(11) NOT NULL,
354`mx` float NOT NULL DEFAULT 0.0,
355`my` float NOT NULL DEFAULT 0.0,
356`mz` float NOT NULL DEFAULT 0.0,
357`mrx` float NOT NULL DEFAULT 0.0,
358`mry` float NOT NULL DEFAULT 0.0,
359`mrz` float NOT NULL DEFAULT 0.0,
360PRIMARY KEY (`uid`)
361) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
362
363
364
365
366
367CREATE TABLE IF NOT EXISTS `data_firmy` (
368`uid` int(11) NOT NULL AUTO_INCREMENT,
369`nazwa` VARCHAR( 30 ) NOT NULL,
370`aktywny` int(11) NOT NULL,
371`owneruid` int(11) NOT NULL,
372`owner` VARCHAR( 30 ) NOT NULL,
373`saldo` int(11) NOT NULL,
374`level` int(11) NOT NULL,
375`exp` int(11) NOT NULL,
376`towary` int(11) NOT NULL,
377`pracownikow` int(11) NOT NULL,
378PRIMARY KEY (`uid`)
379) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;