mHASRB51

1
2/*
3-------------------------MYSQL TABLE GRACZE OSIAGNIECIA--------------------------------
4
5
6CREATE TABLE IF NOT EXISTS `GraczeOsiagniecia` (
7`uid` int(11) NOT NULL AUTO_INCREMENT,
8`nick` VARCHAR( 24 ) CHARACTER SET ASCII NOT NULL,
9`Os1` INT(11)  NOT NULL,
10`Os2` INT(11)  NOT NULL,
11`Os3` INT(11)  NOT NULL,
12`Os4` INT(11)  NOT NULL,
13`Os5` INT(11)  NOT NULL,
14`Os6` INT(11)  NOT NULL,
15`Os7` INT(11)  NOT NULL,
16`Os8` INT(11)  NOT NULL,
17`Os9` INT(11)  NOT NULL,
18`Os10` INT(11)  NOT NULL,
19`Os11` INT(11)  NOT NULL,
20`Os12` INT(11)  NOT NULL,
21`Os13` INT(11)  NOT NULL,
22`Os14` INT(11)  NOT NULL,
23`Os15` INT(11)  NOT NULL,
24`Os16` INT(11)  NOT NULL,
25`Os17` INT(11)  NOT NULL,
26`Os18` INT(11)  NOT NULL,
27`Os19` INT(11)  NOT NULL,
28`Os20` INT(11)  NOT NULL,
29`Os21` INT(11)  NOT NULL,
30`Os22` INT(11)  NOT NULL,
31`Os23` INT(11)  NOT NULL,
32`Os24` INT(11)  NOT NULL,
33`Os25` INT(11)  NOT NULL,
34`Os26` INT(11)  NOT NULL,
35`Os27` INT(11)  NOT NULL,
36`Os28` INT(11)  NOT NULL,
37`Os29` INT(11)  NOT NULL,
38`Os30` INT(11)  NOT NULL,
39`Os31` INT(11)  NOT NULL,
40`Os32` INT(11)  NOT NULL,
41`Os33` INT(11)  NOT NULL,
42`Os34` INT(11)  NOT NULL,
43`Os35` INT(11)  NOT NULL,
44`Os36` INT(11)  NOT NULL,
45`Os37` INT(11)  NOT NULL,
46`Os38` INT(11)  NOT NULL,
47`Os39` INT(11)  NOT NULL,
48`Os40` INT(11)  NOT NULL,
49PRIMARY KEY (`uid`)
50) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
51
52--------------------------------------------TABLE MYSQL SERWER-----------------
53CREATE TABLE IF NOT EXISTS `Statystyki` (
54`uid` int(11) NOT NULL AUTO_INCREMENT,
55`konta` INT(11) NOT NULL,
56`oZareje` VARCHAR(24) NOT NULL,
57`oZalogo` VARCHAR(24) NOT NULL,
58`wizyty` INT(11) NOT NULL,
59`rekordgraczy` INT(11) NOT NULL,
60`bany` INT(11) NOT NULL,
61`useKomendy` INT(11) NOT NULL,
62`chatIC` INT(11) NOT NULL,
63`chatOOC` INT(11) NOT NULL,
64`chatSMS` INT(11) NOT NULL,
65`gmxSerwer` INT(11) NOT NULL,
66`Kicki` INT(11) NOT NULL,
67`Mute` INT(11) NOT NULL,
68`Warny` INT(11) NOT NULL,
69`BlockAccounts` INT(11) NOT NULL,
70`towarki` INT(11) NOT NULL,
71PRIMARY KEY (`uid`)
72) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
73
74------------------------------------------TABELA MYSQL GRACZE--------------------------
75CREATE TABLE IF NOT EXISTS `Gracze` (
76`uid` int(11) NOT NULL AUTO_INCREMENT,
77`nick` VARCHAR( 24 ) CHARACTER SET ASCII NOT NULL,
78`haslo` VARCHAR( 255 ) NOT NULL,
79`ip` VARCHAR( 255 ) NOT NULL,
80`gpci` VARCHAR( 255 ) NOT NULL,
81`lastlogin` VARCHAR( 255 ) NOT NULL,
82`dataregister` VARCHAR( 255 ) NOT NULL,
83`status` int(11)  NOT NULL,
84`zycie` float NOT NULL DEFAULT 99.9,
85`skin` INT(11)  NOT NULL,
86`kasa` INT(11)  NOT NULL,
87`bankkasa` INT(11)  NOT NULL,
88`ranga` INT(11)  NOT NULL,
89`rangau` VARCHAR( 255 ) NOT NULL,
90`frakcja` INT(11)  NOT NULL,
91`firma` INT(11)  NOT NULL,
92`mafia` INT(11)  NOT NULL,
93`lider` INT(11)  NOT NULL,
94`szeffirma` INT(11)  NOT NULL,
95`score` INT(11)  NOT NULL,
96`poziom` INT(11)  NOT NULL,
97`wyplata` INT(11)  NOT NULL,
98`wyplata2` INT(11)  NOT NULL,
99`zysk` INT(11)  NOT NULL,
100`zysk2` INT(11)  NOT NULL,
101`czaspracy` INT(11)  NOT NULL,
102`wizyty` INT(11)  NOT NULL,
103`lina` INT(11)  NOT NULL,
104`mele` INT(11)  NOT NULL,
105`maska` INT(11)  NOT NULL,
106`bandana` INT(11)  NOT NULL,
107`blokada` INT(11)  NOT NULL,
108`stankonta` INT(11)  NOT NULL,
109`boombox` INT(11)  NOT NULL,
110`mp3` INT(11)  NOT NULL,
111`narzedzia1` INT(11)  NOT NULL,
112`narzedzia2` INT(11)  NOT NULL,
113`narzedzia3` INT(11)  NOT NULL,
114`mute` INT(11)  NOT NULL,
115`jail` INT(11)  NOT NULL,
116`warn` INT(11)  NOT NULL,
117`glod` INT(11)  NOT NULL,
118`sen` INT(11)  NOT NULL,
119`wantedlevel` INT(11)  NOT NULL,
120`telefon` INT(11)  NOT NULL,
121`stylwalki` INT(11)  NOT NULL,
122`knebel` INT(11)  NOT NULL,
123`skuty` INT(11)  NOT NULL,
124`prwp` INT(11)  NOT NULL,
125`punktykarne` INT(11)  NOT NULL,
126`mandat` INT(11)  NOT NULL,
127`cbradio` INT(11)  NOT NULL,
128`kask` INT(11)  NOT NULL,
129`rybacka` INT(11)  NOT NULL,
130`praktyka` INT(11)  NOT NULL,
131`teoria` INT(11)  NOT NULL,
132`strzelecka` INT(11)  NOT NULL,
133`rejestracyjny` INT(11)  NOT NULL,
134`osobisty` INT(11)  NOT NULL,
135`paszport` INT(11)  NOT NULL,
136`ubezpieczenie` INT(11)  NOT NULL,
137`wafelki` INT(11)  NOT NULL,
138`krakersy` INT(11)  NOT NULL,
139`kokaina` INT(11)  NOT NULL,
140`marihuana` INT(11)  NOT NULL,
141`amfetamina` INT(11)  NOT NULL,
142`blant` INT(11)  NOT NULL,
143`papieros` INT(11)  NOT NULL,
144`sprunk` INT(11)  NOT NULL,
145`wino` INT(11)  NOT NULL,
146`piwo` INT(11)  NOT NULL,
147`BlockGun` INT(11) NOT NULL,
148`kanister` INT(11)  NOT NULL,
149`pautorsppriv` INT(11)  NOT NULL,
150`x` float NOT NULL DEFAULT 2781.79,
151`y` float NOT NULL DEFAULT 1253.08,
152`z` float NOT NULL DEFAULT 10.77,
153`a` float NOT NULL DEFAULT 0,
154`uiddom` INT(11)  NOT NULL,
155`uidbank` INT(11)  NOT NULL,
156`uidurbanax` INT(11)  NOT NULL,
157`uidburger` INT(11)  NOT NULL,
158`uidstacja` INT(11)  NOT NULL,
159`uidmotel` INT(11)  NOT NULL,
160`uidodziezowy` INT(11)  NOT NULL,
161`uidprzystanek` INT(11)  NOT NULL,
162`uidsklepsp` INT(11)  NOT NULL,
163`uidszpital` INT(11)  NOT NULL,
164`pvw` INT(11)  NOT NULL,
165`pint` INT(11)  NOT NULL,
166`pczasgrygodz` INT(11)  NOT NULL,
167`pczasgrymin` INT(11)  NOT NULL,
168`exitintx` float NOT NULL DEFAULT 2781.79,
169`exitinty` float NOT NULL DEFAULT 1253.08,
170`exitintz` float NOT NULL DEFAULT 10.77,
171`bron0` int(11) NOT NULL,
172`bron1` int(11) NOT NULL,
173`bron2` int(11) NOT NULL,
174`bron3` int(11) NOT NULL,
175`bron4` int(11) NOT NULL,
176`bron5` int(11) NOT NULL,
177`bron6` int(11) NOT NULL,
178`bron7` int(11) NOT NULL,
179`bron8` int(11) NOT NULL,
180`bron9` int(11) NOT NULL,
181`bron10` int(11) NOT NULL,
182`bron11` int(11) NOT NULL,
183`bron12` int(11) NOT NULL,
184`abron0` int(11) NOT NULL,
185`abron1` int(11) NOT NULL,
186`abron2` int(11) NOT NULL,
187`abron3` int(11) NOT NULL,
188`abron4` int(11) NOT NULL,
189`abron5` int(11) NOT NULL,
190`abron6` int(11) NOT NULL,
191`abron7` int(11) NOT NULL,
192`abron8` int(11) NOT NULL,
193`abron9` int(11) NOT NULL,
194`abron10` int(11) NOT NULL,
195`abron11` int(11) NOT NULL,
196`abron12` int(11) NOT NULL,
197PRIMARY KEY (`uid`)
198) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
199
200
201-------------------------------------------TABLE MYSQL BRONIE GRACZA----------------------------
202CREATE TABLE IF NOT EXISTS `GraczeBronie` (
203`uid` int(11) NOT NULL AUTO_INCREMENT,
204`nick` varchar(32) NOT NULL,
205`Weap0` int(11) NOT NULL,
206`AWeap0` int(11) NOT NULL,
207`Weap1` int(11) NOT NULL,
208`AWeap1` int(11) NOT NULL,
209`Weap2` int(11) NOT NULL,
210`AWeap2` int(11) NOT NULL,
211`Weap3` int(11) NOT NULL,
212`AWeap3` int(11) NOT NULL,
213`Weap4` int(11) NOT NULL,
214`AWeap4` int(11) NOT NULL,
215`Weap5` int(11) NOT NULL,
216`AWeap5` int(11) NOT NULL,
217`Weap6` int(11) NOT NULL,
218`AWeap6` int(11) NOT NULL,
219`Weap7` int(11) NOT NULL,
220`AWeap7` int(11) NOT NULL,
221`Weap8` int(11) NOT NULL,
222`AWeap8` int(11) NOT NULL,
223`Weap9` int(11) NOT NULL,
224`AWeap9` int(11) NOT NULL,
225`Weap10` int(11) NOT NULL,
226`AWeap10` int(11) NOT NULL,
227`Weap11` int(11) NOT NULL,
228`AWeap11` int(11) NOT NULL,
229`Weap12` int(11) NOT NULL,
230`AWeap12` int(11) NOT NULL,
231PRIMARY KEY (`uid`)
232) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
233
234
235
236
237//-------------------------------MYSQL TABLE LOKAL------------------------------
238
239CREATE TABLE IF NOT EXISTS `Lokale` (
240`uid` int(11) NOT NULL AUTO_INCREMENT,
241`Owner` varchar(32) NOT NULL,
242`OwnerNick` varchar(32) NOT NULL,
243`Koszt` int(11) NOT NULL,
244`Czas` int(11) NOT NULL,
245`Zamek` int(11) NOT NULL,
246`pX` float NOT NULL DEFAULT 0,
247`pY` float NOT NULL DEFAULT 0,
248`pZ` float NOT NULL DEFAULT 0,
249`sX` float NOT NULL DEFAULT 0,
250`sY` float NOT NULL DEFAULT 0,
251`sZ` float NOT NULL DEFAULT 0,
252PRIMARY KEY (`uid`)
253) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
254
255
256---------------------------------MYSQL TABLE DOMY-------------------------------
257
258CREATE TABLE IF NOT EXISTS `Domy` (
259`uid` int(11) NOT NULL AUTO_INCREMENT,
260`Owner` varchar(32) NOT NULL,
261`OwnerNick` varchar(32) NOT NULL,
262`Opis` varchar(32) NOT NULL,
263`sejfkasa` int(11) NOT NULL,
264`Poziom` int(11) NOT NULL,
265`Interior` int(11) NOT NULL,
266`InHouseInterior` int(11) NOT NULL,
267`Koszt` int(11) NOT NULL,
268`VirtualWorld` int(11) NOT NULL,
269`Zamek` int(11) NOT NULL,
270`sejf` int(11) NOT NULL,
271`haslo` int(11) NOT NULL,
272`alarm` int(11) NOT NULL,
273`mele` int(11) NOT NULL,
274`use` int(11) NOT NULL,
275`pX` float NOT NULL DEFAULT 0,
276`pY` float NOT NULL DEFAULT 0,
277`pZ` float NOT NULL DEFAULT 0,
278`sX` float NOT NULL DEFAULT 0,
279`sY` float NOT NULL DEFAULT 0,
280`sZ` float NOT NULL DEFAULT 0,
281`bron1` int(11) NOT NULL,
282`bron2` int(11) NOT NULL,
283`bron3` int(11) NOT NULL,
284`bron4` int(11) NOT NULL,
285`bron5` int(11) NOT NULL,
286`bron6` int(11) NOT NULL,
287`bron7` int(11) NOT NULL,
288`bron8` int(11) NOT NULL,
289`bron9` int(11) NOT NULL,
290`bron10` int(11) NOT NULL,
291`bron11` int(11) NOT NULL,
292`bron12` int(11) NOT NULL,
293`bron13` int(11) NOT NULL,
294`bron14` int(11) NOT NULL,
295`bron15` int(11) NOT NULL,
296`bron16` int(11) NOT NULL,
297`bron17` int(11) NOT NULL,
298`bron18` int(11) NOT NULL,
299`bron19` int(11) NOT NULL,
300`bron20` int(11) NOT NULL,
301`bron21` int(11) NOT NULL,
302`bron22` int(11) NOT NULL,
303`bron23` int(11) NOT NULL,
304`bron24` int(11) NOT NULL,
305`bron25` int(11) NOT NULL,
306`bron26` int(11) NOT NULL,
307`bron27` int(11) NOT NULL,
308`bron28` int(11) NOT NULL,
309`bron29` int(11) NOT NULL,
310`bron30` int(11) NOT NULL,
311`bron31` int(11) NOT NULL,
312`bron32` int(11) NOT NULL,
313`bron33` int(11) NOT NULL,
314`bron34` int(11) NOT NULL,
315`bron35` int(11) NOT NULL,
316`bron36` int(11) NOT NULL,
317`bron37` int(11) NOT NULL,
318`bron38` int(11) NOT NULL,
319`bron39` int(11) NOT NULL,
320`bron40` int(11) NOT NULL,
321`bron41` int(11) NOT NULL,
322`bron42` int(11) NOT NULL,
323`bron43` int(11) NOT NULL,
324`bron44` int(11) NOT NULL,
325`bron45` int(11) NOT NULL,
326`bron46` int(11) NOT NULL,
327`bron47` int(11) NOT NULL,
328`bron48` int(11) NOT NULL,
329`bron49` int(11) NOT NULL,
330`bron50` int(11) NOT NULL,
331`amunicja1` int(11) NOT NULL,
332`amunicja2` int(11) NOT NULL,
333`amunicja3` int(11) NOT NULL,
334`amunicja4` int(11) NOT NULL,
335`amunicja5` int(11) NOT NULL,
336`amunicja6` int(11) NOT NULL,
337`amunicja7` int(11) NOT NULL,
338`amunicja8` int(11) NOT NULL,
339`amunicja9` int(11) NOT NULL,
340`amunicja10` int(11) NOT NULL,
341`amunicja11` int(11) NOT NULL,
342`amunicja12` int(11) NOT NULL,
343`amunicja13` int(11) NOT NULL,
344`amunicja14` int(11) NOT NULL,
345`amunicja15` int(11) NOT NULL,
346`amunicja16` int(11) NOT NULL,
347`amunicja17` int(11) NOT NULL,
348`amunicja18` int(11) NOT NULL,
349`amunicja19` int(11) NOT NULL,
350`amunicja20` int(11) NOT NULL,
351`amunicja21` int(11) NOT NULL,
352`amunicja22` int(11) NOT NULL,
353`amunicja23` int(11) NOT NULL,
354`amunicja24` int(11) NOT NULL,
355`amunicja25` int(11) NOT NULL,
356`amunicja26` int(11) NOT NULL,
357`amunicja27` int(11) NOT NULL,
358`amunicja28` int(11) NOT NULL,
359`amunicja29` int(11) NOT NULL,
360`amunicja30` int(11) NOT NULL,
361`amunicja31` int(11) NOT NULL,
362`amunicja32` int(11) NOT NULL,
363`amunicja33` int(11) NOT NULL,
364`amunicja34` int(11) NOT NULL,
365`amunicja35` int(11) NOT NULL,
366`amunicja36` int(11) NOT NULL,
367`amunicja37` int(11) NOT NULL,
368`amunicja38` int(11) NOT NULL,
369`amunicja39` int(11) NOT NULL,
370`amunicja40` int(11) NOT NULL,
371`amunicja41` int(11) NOT NULL,
372`amunicja42` int(11) NOT NULL,
373`amunicja43` int(11) NOT NULL,
374`amunicja44` int(11) NOT NULL,
375`amunicja45` int(11) NOT NULL,
376`amunicja46` int(11) NOT NULL,
377`amunicja47` int(11) NOT NULL,
378`amunicja48` int(11) NOT NULL,
379`amunicja49` int(11) NOT NULL,
380`amunicja50` int(11) NOT NULL,
381
382
383
384
385PRIMARY KEY (`uid`)
386) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
387
388
389
390
391
392
393
394
395
396
397
398
399CREATE TABLE IF NOT EXISTS `Domy` (
400`uid` int(11) NOT NULL,
401  `Owner` varchar(32) NOT NULL,
402  `OwnerNick` varchar(32) NOT NULL,
403  `Opis` varchar(32) NOT NULL,
404  `Poziom` int(11) NOT NULL,
405  `Interior` int(11) NOT NULL,
406  `InHouseInterior` int(11) NOT NULL,
407  `Koszt` int(11) NOT NULL,
408  `VirtualWorld` int(11) NOT NULL,
409  `Zamek` int(11) NOT NULL,
410  `pX` float NOT NULL DEFAULT '0',
411  `pY` float NOT NULL DEFAULT '0',
412  `pZ` float NOT NULL DEFAULT '0',
413  `sX` float NOT NULL DEFAULT '0',
414  `sY` float NOT NULL DEFAULT '0',
415  `sZ` float NOT NULL DEFAULT '0',
416PRIMARY KEY (`uid`)
417) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;
418
419
420--
421-- Zrzut danych tabeli `Domy`
422--
423
424INSERT INTO `Domy` (`uid`, `Owner`, `OwnerNick`, `Opis`, `Poziom`, `Interior`, `InHouseInterior`, `Koszt`, `VirtualWorld`, `Zamek`, `pX`, `pY`, `pZ`, `sX`, `sY`, `sZ`) VALUES
425(1, '6', 'CenZurA', '', 15, 1, 3, 137299, 0, 1, -691.812, 939.24, 13.6328, 235.509, 1189.17, 1080.34),
426(2, '-1', '-1', '', 4, 3, 1, 25000, 0, 1, 1034.85, -813.172, 101.852, 223.044, 1289.26, 1082.2),
427(3, '-1', '-1', '', 4, 3, 1, 25000, 0, 1, 989.755, -828.681, 95.4686, 223.044, 1289.26, 1082.2),
428(4, '-1', '-1', '', 4, 3, 1, 25000, 0, 1, 937.606, -848.524, 93.6177, 223.044, 1289.26, 1082.2),
429(5, '-1', '-1', '', 4, 3, 1, 25000, 0, 1, 910.509, -817.414, 103.126, 223.044, 1289.26, 1082.2),
430(6, '-1', '-1', '', 4, 3, 1, 25000, 0, 1, 874.839, -877.209, 77.8119, 223.044, 1289.26, 1082.2),
431(7, '-1', '-1', '', 4, 3, 1, 25000, 0, 1, 827.844, -858.006, 70.3308, 223.044, 1289.26, 1082.2),
432(8, '-1', '-1', '', 4, 3, 1, 25000, 0, 1, 835.828, -894.768, 68.7689, 223.044, 1289.26, 1082.2),
433(9, '-1', '-1', '', 4, 3, 1, 25000, 0, 1, 785.832, -828.599, 70.2896, 223.044, 1289.26, 1082.2),
434(12, '-1', '-1', '', 5, 6, 15, 40000, 0, 1, 700.173, -1060.07, 49.4217, 328.494, 1480.59, 1084.45),
435(13, '-1', '-1', '', 4, 4, 7, 40000, 0, 1, 648.222, -1058.75, 52.5799, 225.631, 1022.48, 1084.07),
436(15, '-1', '-1', '', 4, 4, 7, 25000, 0, 1, 352.115, -1197.55, 76.5156, 225.631, 1022.48, 1084.07),
437(17, '-1', '-1', '', 6, 8, 5, 200000, 0, 1, 300.185, -1154.39, 81.3901, 1299.14, -794.77, 1084),
438(18, '-1', '-1', '', 6, 8, 5, 200000, 0, 1, 251.516, -1220.25, 76.1024, 1299.14, -794.77, 1084),
439(19, '-1', '-1', '', 6, 5, 15, 200000, 0, 1, 253.191, -1270.01, 74.4286, 295.139, 1474.47, 1080.52),
440(20, '-1', '-1', '', 6, 5, 15, 50000, 0, 1, 254.49, -1367.28, 53.1094, 295.139, 1474.47, 1080.52),
441(21, '-1', '-1', '', 6, 5, 15, 50000, 0, 1, 227.944, -1405.43, 51.6094, 295.139, 1474.47, 1080.52);
442
443-- --------------------------------------------------------
444
445
446
447
448
449
450
451
452
453
454
455
456
457----------------------------MYSQL TABLE DORYWCZ DRWAL---------------------------------
458CREATE TABLE IF NOT EXISTS `DorywczeDrwal` (
459`uid` int(11) NOT NULL AUTO_INCREMENT,
460`obj` int(11) NOT NULL,
461`x1`  float NOT NULL DEFAULT 0,
462`y1`  float NOT NULL DEFAULT 0,
463`z1`  float NOT NULL DEFAULT 0,
464`rx1` float NOT NULL DEFAULT 0,
465`ry1` float NOT NULL DEFAULT 0,
466`rz1` float NOT NULL DEFAULT 0,
467`x2`  float NOT NULL DEFAULT 0,
468`y2`  float NOT NULL DEFAULT 0,
469`z2`  float NOT NULL DEFAULT 0,
470`rx2` float NOT NULL DEFAULT 0,
471`ry2` float NOT NULL DEFAULT 0,
472`rz2` float NOT NULL DEFAULT 0,
473PRIMARY KEY (`uid`)
474) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
475
476
477
478
479----------------------------MYSQL TABLE PRZYSTANKI---------------------------------
480CREATE TABLE IF NOT EXISTS `Przystanki` (
481`uid` int(11) NOT NULL AUTO_INCREMENT,
482`Stworzyl` varchar(32) NOT NULL,
483`pX` float NOT NULL DEFAULT 0,
484`pY` float NOT NULL DEFAULT 0,
485`pZ` float NOT NULL DEFAULT 0,
486PRIMARY KEY (`uid`)
487) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
488
489
490----------------------------MYSQL TABLE BURGERY---------------------------------
491CREATE TABLE IF NOT EXISTS `Burgery` (
492`uid` int(11) NOT NULL AUTO_INCREMENT,
493`Stworzyl` varchar(32) NOT NULL,
494`pX` float NOT NULL DEFAULT 0,
495`pY` float NOT NULL DEFAULT 0,
496`pZ` float NOT NULL DEFAULT 0,
497PRIMARY KEY (`uid`)
498) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
499
500----------------------------MYSQL TABLE BANKOMATY---------------------------------
501CREATE TABLE IF NOT EXISTS `Bankomaty` (
502`uid` int(11) NOT NULL AUTO_INCREMENT,
503`typ` int(11) NOT NULL,
504`Stworzyl` varchar(32) NOT NULL,
505`przelew` int(11) NOT NULL,
506`prowizja` int(11) NOT NULL,
507`pX` float NOT NULL DEFAULT 0,
508`pY` float NOT NULL DEFAULT 0,
509`pZ` float NOT NULL DEFAULT 0,
510`pA` float NOT NULL DEFAULT 0,
511`rx` float NOT NULL DEFAULT 0,
512`ry` float NOT NULL DEFAULT 0,
513`rz` float NOT NULL DEFAULT 0,
514PRIMARY KEY (`uid`)
515) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
516
517
518
519----------------------------MYSQL TABLE BINCO---------------------------------
520CREATE TABLE IF NOT EXISTS `Odziezowe` (
521`uid` int(11) NOT NULL AUTO_INCREMENT,
522`Stworzyl` varchar(32) NOT NULL,
523`pX` float NOT NULL DEFAULT 0,
524`pY` float NOT NULL DEFAULT 0,
525`pZ` float NOT NULL DEFAULT 0,
526PRIMARY KEY (`uid`)
527) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
528
529
530
531----------------------------MYSQL TABLE URBANSHOPY---------------------------------
532CREATE TABLE IF NOT EXISTS `Urbanshopy` (
533`uid` int(11) NOT NULL AUTO_INCREMENT,
534`Stworzyl` varchar(32) NOT NULL,
535`pX` float NOT NULL DEFAULT 0,
536`pY` float NOT NULL DEFAULT 0,
537`pZ` float NOT NULL DEFAULT 0,
538PRIMARY KEY (`uid`)
539) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
540
541
542
543
544----------------------------MYSQL TABLE SKLEY SPOZYWCZE---------------------------------
545CREATE TABLE IF NOT EXISTS `SklepySpozywcze` (
546`uid` int(11) NOT NULL AUTO_INCREMENT,
547`Stworzyl` varchar(32) NOT NULL,
548`pX` float NOT NULL DEFAULT 0,
549`pY` float NOT NULL DEFAULT 0,
550`pZ` float NOT NULL DEFAULT 0,
551PRIMARY KEY (`uid`)
552) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
553
554
555
556CREATE TABLE IF NOT EXISTS `Burgery` (
557  `UID` int(11) NOT NULL,
558  `Stworzyl` varchar(32) NOT NULL,
559  `VirtualWorld` int(11) NOT NULL,
560  `pX` float NOT NULL DEFAULT '0',
561  `pY` float NOT NULL DEFAULT '0',
562  `pZ` float NOT NULL DEFAULT '0',
563    PRIMARY KEY (`uid`)
564) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;
565
566
567--
568-- Zrzut danych tabeli `Burgery`
569--
570
571INSERT INTO `Burgery` (`UID`, `Stworzyl`, `VirtualWorld`, `pX`, `pY`, `pZ`) VALUES
572(1, 'Tampa', 0, 1158.1, 2072.04, 11.0625),
573(2, 'Tampa', 1, 1199.29, -918.525, 43.1201),
574(3, 'Tampa', 2, 810.66, -1616.18, 13.5469),
575(4, 'Tampa', 3, -144.116, 1224.52, 19.8992),
576(5, 'Tampa', 4, -2356.54, 1008.16, 50.8984),
577(6, 'Tampa', 5, -2336.6, -166.997, 35.5547),
578(7, 'Tampa', 6, 1367.26, 248.564, 19.5669),
579(8, 'Tampa', 7, -2155.09, -2460.24, 30.8516),
580(9, 'ChwilowyNick', 8, 1872.97, 2071.93, 11.0625),
581(10, 'Test', 9, 2083.27, 2224.08, 11.0234),
582(11, 'Test', 10, 2472.38, 2034.33, 11.0625),
583(12, 'Test', 11, -1213.56, 1830.86, 41.9297),
584(13, '[ST]Constans', 12, -1816.71, 618.068, 35.1719);
585
586
587
588----------------------------MYSQL TABLE MOTELE---------------------------------
589CREATE TABLE IF NOT EXISTS `Motele` (
590`uid` int(11) NOT NULL AUTO_INCREMENT,
591`Stworzyl` varchar(32) NOT NULL,
592`pX` float NOT NULL DEFAULT 0,
593`pY` float NOT NULL DEFAULT 0,
594`pZ` float NOT NULL DEFAULT 0,
595PRIMARY KEY (`uid`)
596) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
597
598
599
600
601
602--
603-- Struktura tabeli dla tabeli `Motele`
604--
605
606CREATE TABLE IF NOT EXISTS `Motele` (
607  `UID` int(11) NOT NULL,
608  `Stworzyl` varchar(32) NOT NULL,
609  `VirtualWorld` int(11) NOT NULL,
610  `pX` float NOT NULL DEFAULT '0',
611  `pY` float NOT NULL DEFAULT '0',
612  `pZ` float NOT NULL DEFAULT '0',
613PRIMARY KEY (`uid`)
614) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
615
616--
617-- Zrzut danych tabeli `Motele`
618--
619
620INSERT INTO `Motele` (`UID`, `Stworzyl`, `VirtualWorld`, `pX`, `pY`, `pZ`) VALUES
621(0, 'Tampa', 0, 2233.05, -1159.78, 25.8906),
622(1, 'Tampa', 1, -89.9564, 1229.44, 19.7422),
623(2, 'Tampa', 2, -2425.68, 337.728, 37.001),
624(3, 'Tampa', 3, 1965.37, 1623.11, 12.8628);
625
626-- --------------------------------------------------------
627
628
629
630
631
632
633
634
635
636
637
638
639
640-------------------------Mysql TABLE STACJE BENZYNOWE-------------------------
641
642CREATE TABLE IF NOT EXISTS `StacjeBenzynowe` (
643`uid` int(11) NOT NULL AUTO_INCREMENT,
644`Stworzyl` varchar(32) NOT NULL,
645`Koszt` int(11) NOT NULL,
646`pX` float NOT NULL DEFAULT 0,
647`pY` float NOT NULL DEFAULT 0,
648`pZ` float NOT NULL DEFAULT 0,
649PRIMARY KEY (`uid`)
650) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
651
652
653CREATE TABLE IF NOT EXISTS `GraczePrywatne` (
654`uid` int(11) NOT NULL AUTO_INCREMENT,
655`owner` varchar(255) NOT NULL,
656`ownerid` int(200) NOT NULL,
657`model` int(11) NOT NULL,
658`mafia` int(11) NOT NULL,
659`c1` float NOT NULL DEFAULT 0,
660`c2` float NOT NULL DEFAULT 0,
661`przebieg` float NOT NULL DEFAULT 0,
662`health` float NOT NULL DEFAULT 0,
663`x` float NOT NULL DEFAULT 0,
664`y` float NOT NULL DEFAULT 0,
665`z` float NOT NULL DEFAULT 0,
666`a` float NOT NULL DEFAULT 0,
667`felgi` int(11) NOT NULL,
668`szyby` int(11) NOT NULL,
669`hydraulika` int(11) NOT NULL,
670`spoiler` int(11) NOT NULL,
671`paintjob` int(11) NOT NULL,
672`locked` int(11) NOT NULL,
673`nitro` int(11) NOT NULL,
674`neon1` int(11) NOT NULL,
675`neon2` int(11) NOT NULL,
676`rejestracja` varchar(255) NOT NULL,
677`panel` int(11) NOT NULL,
678`lights` int(11) NOT NULL,
679`tires` int(11) NOT NULL,
680`doors` int(11) NOT NULL,
681`paliwo` float NOT NULL DEFAULT 1,
682`maxpaliwo` int(11) NOT NULL,
683`gtauid` int(11) NOT NULL,
684`blokada` int(11) NOT NULL,
685PRIMARY KEY (`uid`)
686) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
687
688
689
690CREATE TABLE IF NOT EXISTS `BanyTemp` (
691`uid` int(11) NOT NULL AUTO_INCREMENT,
692`Nick` varchar(255)NOT NULL,
693`IP` varchar(255)NOT NULL,
694`Host` varchar(255) NOT NULL,
695`GPCI` varchar(255) NOT NULL,
696`Admin` varchar(255) NOT NULL,
697`Powod` varchar(255) NOT NULL,
698`Czas` int(255) NOT NULL,
699`xHost` int(255) NOT NULL,
700`xGpci` int(255) NOT NULL,
701`Data` varchar(255) NOT NULL,
702PRIMARY KEY (`uid`)
703) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
704
705
706
707CREATE TABLE IF NOT EXISTS `GraczeVipy` (
708`uid` int(11) NOT NULL AUTO_INCREMENT,
709`useruid` int(11) NOT NULL,
710`Nick` varchar(255)NOT NULL,
711`Admin` varchar(255) NOT NULL,
712`Czas` int(255) NOT NULL,
713`Data` varchar(255) NOT NULL,
714PRIMARY KEY (`uid`)
715) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
716
717
718
719
720
721CREATE TABLE IF NOT EXISTS `Towary` (
722`uid` int(11) NOT NULL AUTO_INCREMENT,
723`Towar` varchar(255)NOT NULL,
724`Zaladunek` varchar(255)NOT NULL,
725`Rozladunek` varchar(255) NOT NULL,
726`Nagroda` int(255) NOT NULL,
727`ZalPosX` float NOT NULL DEFAULT 0,
728`ZalPosY` float NOT NULL DEFAULT 0,
729`ZalPosZ` float NOT NULL DEFAULT 0,
730`RozPosX` float NOT NULL DEFAULT 0,
731`RozPosY` float NOT NULL DEFAULT 0,
732`RozPosZ` float NOT NULL DEFAULT 0,
733PRIMARY KEY (`uid`)
734) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
735
736
737
738CREATE TABLE IF NOT EXISTS `LogiDostarczen` (
739`uid` int(11) NOT NULL AUTO_INCREMENT,
740`nick` varchar(255)NOT NULL,
741`useruid` int(11) NOT NULL,
742`data` varchar(255) NOT NULL,
743`towar` varchar(255) NOT NULL,
744`zaladunek` varchar(255) NOT NULL,
745`rozladunek` varchar(255) NOT NULL,
746`nagroda` int(11) NOT NULL,
747PRIMARY KEY (`uid`)
748) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
749
750
751CREATE TABLE IF NOT EXISTS `Obiekty` (
752`uid` int(11) NOT NULL AUTO_INCREMENT,
753`obiektid` int(11) NOT NULL,
754`useruid` int(11) NOT NULL,
755`typ` int(11) NOT NULL,
756`x` float NOT NULL DEFAULT 0,
757`y` float NOT NULL DEFAULT 0,
758`z` float NOT NULL DEFAULT 0,
759`rx` float NOT NULL DEFAULT 0,
760`ry` float NOT NULL DEFAULT 0,
761`rz` float NOT NULL DEFAULT 0,
762`vw` int(11) NOT NULL,
763`intek` int(11) NOT NULL,
764`dystans` float NOT NULL DEFAULT 0,
765PRIMARY KEY (`uid`)
766) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
767
768
769CREATE TABLE IF NOT EXISTS `TelefonKontakty` (
770`uid` int(11) NOT NULL AUTO_INCREMENT,
771`nick` varchar(255)NOT NULL,
772`numer` int(11)NOT NULL,
773`telefon` int(11) NOT NULL,
774PRIMARY KEY (`uid`)
775) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
776
777
778
779
780//-------------------------------MYSQL TABLE FIRMY------------------------------
781CREATE TABLE IF NOT EXISTS `Firmy` (
782`uid` int(11) NOT NULL AUTO_INCREMENT,
783`Nazwa` varchar(255)NOT NULL,
784`LiderN` varchar(255)NOT NULL,
785`Exp` int(11) NOT NULL,
786`Kasa` int(11) NOT NULL,
787`Poziom` int(11) NOT NULL,
788`Rekrutacja` int(11) NOT NULL,
789`Use` int(11) NOT NULL,
790`LiderU` int(11) NOT NULL,
791`DataP` varchar(255)NOT NULL,
792`DataW` int(11) NOT NULL,
793`fRoadTrain` int(11) NOT NULL,
794`fTanker` int(11) NOT NULL,
795`fLineruner` int(11) NOT NULL,
796`fBuritto` int(11) NOT NULL,
797`fRumpo` int(11) NOT NULL,
798`fYankee` int(11) NOT NULL,
799`fTopfunVan` int(11) NOT NULL,
800`fMule` int(11) NOT NULL,
801`fPony` int(11) NOT NULL,
802`fFlatbed` int(11) NOT NULL,
803`fBoxvile` int(11) NOT NULL,
804`fBenson` int(11) NOT NULL,
805PRIMARY KEY (`uid`)
806) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
807
808//-------------------------------MYSQL TABLE FIRMYCV------------------------------
809
810
811CREATE TABLE IF NOT EXISTS `FirmyCV` (
812`uid` int(11) NOT NULL AUTO_INCREMENT,
813`nick` varchar(255)NOT NULL,
814`tresc` varchar(255)NOT NULL,
815`useruid` int(11) NOT NULL,
816`firmaid` int(11) NOT NULL,
817PRIMARY KEY (`uid`)
818) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
819
820
821//-------------------------------MYSQL TABLE LOGI------------------------------
822
823CREATE TABLE IF NOT EXISTS `Logi` (
824  `uid` int(11) NOT NULL AUTO_INCREMENT,
825  `tresc` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
826  `data` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
827  `typlog` int(11) NOT NULL,
828  PRIMARY KEY (`uid`)
829) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;
830
831
832
833//-----------------------------MYSQL TABLE SALDO FRAKCJA-----------------------
834CREATE TABLE IF NOT EXISTS `FrakcjeSaldo` (
835`uid` int(11) NOT NULL AUTO_INCREMENT,
836`konto` int(11)NOT NULL,
837`datawyplaty` int(11)NOT NULL,
838PRIMARY KEY (`uid`)
839) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
840
841*/