· 6 years ago · Aug 31, 2019, 03:24 PM
1CREATE TABLE IF NOT EXISTS `zaidejai` (
2 `ID` int(11) NOT NULL AUTO_INCREMENT,
3 `Slapyvardis` varchar(21) NOT NULL,
4 `Slaptazodis` varchar(30) NOT NULL,
5 `Vardas` varchar(30) NOT NULL,
6 `Email` varchar(64) NOT NULL,
7 `RegistracijosData` varchar(22) NOT NULL,
8 `REGIP` varchar(21) NOT NULL,
9 `IP` varchar(21) NOT NULL,
10 `Lygis` tinyint(3) NOT NULL,
11 `LygioLikutis` int(5) NOT NULL,
12 `XP` int(8) DEFAULT 1,
13 `Pareigos` int(3) DEFAULT -1,
14 `PareiguIspejimai` tinyint(2) NOT NULL,
15 `Darbas` tinyint(3) NOT NULL,
16 `DarboIspejimai` tinyint(2) NOT NULL,
17 `DarboKontraktas` tinyint(2) NOT NULL,
18 `PinigaiRankose` int(11) DEFAULT 10000,
19 `PinigaiBanke` int(11) NOT NULL,
20 `BankoSlaptazodis` int(11) NOT NULL,
21 `Kreditai` int(11) NOT NULL,
22 `KasyklosDalys` int(3) NOT NULL,
23 `PrisijungimoSekunde` tinyint(2) NOT NULL,
24 `PrisijungimoMinute` tinyint(2) NOT NULL,
25 `PrisijungimoValanda` tinyint(2) NOT NULL,
26 `PrisijungimoDiena` tinyint(2) NOT NULL,
27 `PrisijungimoMenesis` tinyint(2) NOT NULL,
28 `PrisijungimoMetai` int(4) NOT NULL,
29 `GyvybesDraudimas` int(11) NOT NULL,
30 `Pazyma` tinyint(2) NOT NULL,
31 `Lytis` tinyint(1) NOT NULL,
32 `DarboAlga` int(11) NOT NULL,
33 `PradirbtasLaikas` int(11) NOT NULL,
34 `Darbo1Xp` int(11) NOT NULL,
35 `Darbo2Xp` int(11) NOT NULL,
36 `Darbo3Xp` int(11) NOT NULL,
37 `Darbo4Xp` int(11) NOT NULL,
38 `Darbo5Xp` int(11) NOT NULL,
39 `Darbo6Xp` int(11) NOT NULL,
40 `Darbo7Xp` int(11) NOT NULL,
41 `Darbo8Xp` int(11) NOT NULL,
42 `Darbo9Xp` int(11) NOT NULL,
43 `Darbo10Xp` int(11) NOT NULL,
44 `Darbo11Xp` int(11) NOT NULL,
45 `Darbo12Xp` int(11) NOT NULL,
46 `Darbo13Xp` int(11) NOT NULL,
47 `Darbo1Lygis` int(11) NOT NULL,
48 `Darbo2Lygis` int(11) NOT NULL,
49 `Darbo3Lygis` int(11) NOT NULL,
50 `Darbo4Lygis` int(11) NOT NULL,
51 `Darbo5Lygis` int(11) NOT NULL,
52 `Darbo6Lygis` int(11) NOT NULL,
53 `Darbo7Lygis` int(11) NOT NULL,
54 `Darbo8Lygis` int(11) NOT NULL,
55 `Darbo9Lygis` int(11) NOT NULL,
56 `Darbo10Lygis` int(11) NOT NULL,
57 `Darbo11Lygis` int(11) NOT NULL,
58 `Darbo12Lygis` int(11) NOT NULL,
59 `Darbo13Lygis` int(11) NOT NULL,
60 `DarboMokestis` int(11) NOT NULL,
61 `DraudimoMokestis` int(11) NOT NULL,
62 `KuroMokestis` int(11) NOT NULL,
63 `MokesciuDienos` int(11) NOT NULL,
64 `NusikaltimoLygis` tinyint(4) NOT NULL,
65 `Nuzudymai` int(11) NOT NULL,
66 `Mirtys` int(11) NOT NULL,
67 `DarboApranga` tinyint(3) NOT NULL,
68 `Apranga` tinyint(3) NOT NULL,
69 `DabartineApranga` tinyint(3) NOT NULL,
70 `Telefonas` tinyint(2) NOT NULL,
71 `TelefonoSaskaita` int(11) NOT NULL,
72 `Tinklas` tinyint(2) NOT NULL,
73 `TelefonoBaterija` int(3) NOT NULL,
74 `KovosStilius` int(3) NOT NULL,
75 `VisasPralostasLaikas` int(11) NOT NULL,
76 `SiandienosPralostasLaikas` tinyint(3) NOT NULL,
77 `Maistas` int(4) NOT NULL,
78 `MedPakas` int(1) NOT NULL,
79 `Priziuretojas` int(4) NOT NULL,
80 `Leidimaskurtigauja` int(1) NOT NULL,
81 `Gaujosskin` int(3) NOT NULL,
82 `Gauja` int(4) NOT NULL,
83 `Gaujiniolygis` int(7) DEFAULT 1,
84 `Gaujiniorep` int(9) NOT NULL,
85 `Serga` tinyint(2) NOT NULL,
86 `TeisesA` tinyint(2) NOT NULL,
87 `TeisesB` tinyint(2) NOT NULL,
88 `TeisesC` tinyint(2) NOT NULL,
89 `TeisesD` tinyint(2) NOT NULL,
90 `TeisiuIspejimai` tinyint(2) NOT NULL,
91 `Heroinas` int(11) NOT NULL,
92 `Kokainas` int(11) NOT NULL,
93 `Marihuana` int(11) NOT NULL,
94 `Ginklas0` int(11) NOT NULL,
95 `Ginklas1` int(11) NOT NULL,
96 `Ginklas2` int(11) NOT NULL,
97 `Ginklas3` int(11) NOT NULL,
98 `Ginklas4` int(11) NOT NULL,
99 `Ginklas5` int(11) NOT NULL,
100 `Ginklas6` int(11) NOT NULL,
101 `Ginklas8` int(11) NOT NULL,
102 `Ginklas9` int(11) NOT NULL,
103 `Ginklas10` int(11) NOT NULL,
104 `Ginklas12` int(11) NOT NULL,
105 `Kulkos0` int(11) NOT NULL,
106 `Kulkos1` int(11) NOT NULL,
107 `Kulkos2` int(11) NOT NULL,
108 `Kulkos3` int(11) NOT NULL,
109 `Kulkos4` int(11) NOT NULL,
110 `Kulkos5` int(11) NOT NULL,
111 `Kulkos6` int(11) NOT NULL,
112 `Kulkos8` int(11) NOT NULL,
113 `Kulkos9` int(11) NOT NULL,
114 `Kulkos10` int(11) NOT NULL,
115 `Kulkos12` int(11) NOT NULL,
116 `XPPasiekimas` tinyint(2) NOT NULL,
117 `DarboSkillPasiekimas` tinyint(2) NOT NULL,
118 `PiniguPasiekimas` tinyint(2) NOT NULL,
119 `NuzudymuPasiekimas` tinyint(2) NOT NULL,
120 `DrkPasiekimas` tinyint(2) NOT NULL,
121 `PareiguPasiekimas` tinyint(2) NOT NULL,
122 `Misijos` int(8) NOT NULL,
123 `GinkluLicencija` tinyint(2) NOT NULL,
124 `KalejimoLaikas` int(11) NOT NULL,
125 `UztildymoLaikas` int(11) NOT NULL,
126 `ReputacijosTaskai` int(11) NOT NULL,
127 `Salmas` int(5) NOT NULL,
128 `Arrest` int(2) NOT NULL,
129 `Taser` int(2) NOT NULL,
130 `Gyvybes` FLOAT DEFAULT 100,
131 `Armour` FLOAT NOT NULL,
132 `X` FLOAT DEFAULT -2425.6555,
133 `Y` FLOAT DEFAULT 337.6967,
134 `Z` FLOAT DEFAULT 37.1012,
135 `F` FLOAT NOT NULL,
136 `Liemene` FLOAT NOT NULL,
137 `SalmasPD` FLOAT NOT NULL,
138 `Skydas` FLOAT NOT NULL,
139 `Interjeras` int(4) NOT NULL,
140 `VirtualWorld` int(10) NOT NULL,
141 `BuvoServeryje` tinyint(3) NOT NULL,
142 PRIMARY KEY (`ID`)
143 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;