· 8 years ago · May 16, 2018, 09:18 PM
1CREATE TABLE IF NOT EXISTS `Accounts` (
2 `UserID` int(3) NOT NULL AUTO_INCREMENT,
3 `Username` text NOT NULL,
4 `Password` text NOT NULL,
5 `Admin` int(2) NOT NULL DEFAULT '0',
6 `Level` int(2) NOT NULL DEFAULT '1',
7 `Donator` int(2) NOT NULL DEFAULT '0',
8 `MaskID` int(10) NOT NULL DEFAULT '0',
9 `LoadPos` int(2) NOT NULL DEFAULT '0',
10 `Crashed` int(2) NOT NULL DEFAULT '0',
11 `LoadPosX` float NOT NULL DEFAULT '0',
12 `LoadPosY` float NOT NULL DEFAULT '0',
13 `LoadPosZ` float NOT NULL DEFAULT '0',
14 `Skin` int(3) NOT NULL DEFAULT '299',
15 `LoadPosInt` int(3) NOT NULL DEFAULT '0',
16 `LoadPosW` int(10) NOT NULL DEFAULT '0',
17 `Gun0` int(2) NOT NULL DEFAULT '0',
18 `GunAmmo0` int(3) NOT NULL DEFAULT '0',
19 `Gun1` int(2) NOT NULL DEFAULT '0',
20 `GunAmmo1` int(20) NOT NULL DEFAULT '0',
21 `Gun2` int(2) NOT NULL DEFAULT '0',
22 `GunAmmo2` int(20) NOT NULL DEFAULT '0',
23 `Gun3` int(2) NOT NULL DEFAULT '0',
24 `GunAmmo3` int(20) NOT NULL DEFAULT '0',
25 `Gun4` int(2) NOT NULL DEFAULT '0',
26 `GunAmmo4` int(20) NOT NULL DEFAULT '0',
27 `Gun5` int(2) NOT NULL DEFAULT '0',
28 `GunAmmo5` int(20) NOT NULL DEFAULT '0',
29 `Gun6` int(2) NOT NULL DEFAULT '0',
30 `GunAmmo6` int(20) NOT NULL DEFAULT '0',
31 `Gun7` int(2) NOT NULL DEFAULT '0',
32 `GunAmmo7` int(4) NOT NULL DEFAULT '0',
33 `Gun8` int(2) NOT NULL DEFAULT '0',
34 `GunAmmo8` int(4) NOT NULL DEFAULT '0',
35 `Gun9` int(2) NOT NULL DEFAULT '0',
36 `GunAmmo9` int(4) NOT NULL DEFAULT '0',
37 `Gun10` int(2) NOT NULL DEFAULT '0',
38 `GunAmmo10` int(4) NOT NULL DEFAULT '0',
39 `Gun11` int(2) NOT NULL DEFAULT '0',
40 `GunAmmo11` int(4) NOT NULL DEFAULT '0',
41 `Gun12` int(2) NOT NULL DEFAULT '0',
42 `GunAmmo12` int(4) NOT NULL DEFAULT '0',
43 `SkillP` int(3) NOT NULL DEFAULT '0',
44 `DesertSkill` int(4) NOT NULL DEFAULT '0',
45 `ShotgunSkill` int(4) NOT NULL DEFAULT '0',
46 `AK47Skill` int(4) NOT NULL DEFAULT '0',
47 `M4Skill` int(4) NOT NULL DEFAULT '0',
48 `V1` longtext NOT NULL,
49 `V2` text NOT NULL,
50 `V3` text NOT NULL,
51 `V4` text NOT NULL,
52 `V5` text NOT NULL,
53 `Sex` int(1) NOT NULL DEFAULT '0',
54 `Tutorial` int(1) NOT NULL DEFAULT '0',
55 `SpawnPoint` int(1) NOT NULL DEFAULT '0',
56 `HouseKey` int(3) NOT NULL DEFAULT '0',
57 `BizKey` int(3) NOT NULL DEFAULT '255',
58 `ApartKey` int(3) NOT NULL DEFAULT '255',
59 `Banned` int(1) NOT NULL DEFAULT '0',
60 `Bank` int(15) NOT NULL DEFAULT '500',
61 `Money` int(15) NOT NULL DEFAULT '500',
62 `Savings` int(15) NOT NULL DEFAULT '0',
63 `PayCheck` int(5) NOT NULL DEFAULT '0',
64 `Experience` int(2) NOT NULL DEFAULT '0',
65 `CarKey` int(3) NOT NULL DEFAULT '0',
66 `Tester` int(1) NOT NULL DEFAULT '0',
67 `CarDupe` int(7) NOT NULL DEFAULT '0',
68 `Demerits` int(2) NOT NULL DEFAULT '0',
69 `Crimes` int(3) NOT NULL DEFAULT '0',
70 `Deaths` int(3) NOT NULL DEFAULT '0',
71 `Arrested` int(3) NOT NULL DEFAULT '0',
72 `Radio` int(2) NOT NULL DEFAULT '0',
73 `Frequence` int(15) NOT NULL DEFAULT '0',
74 `Mask` int(2) NOT NULL DEFAULT '0',
75 `Job` int(2) NOT NULL DEFAULT '0',
76 `JobAllow` int(3) NOT NULL DEFAULT '0',
77 `Faction` int(3) NOT NULL DEFAULT '0',
78 `AllowedPayday` int(2) NOT NULL DEFAULT '0',
79 `Jailed` int(2) NOT NULL DEFAULT '0',
80 `JailTime` int(8) NOT NULL DEFAULT '0',
81 `Cigarettes` int(2) NOT NULL DEFAULT '0',
82 `BadgeNumber` int(2) NOT NULL DEFAULT '0',
83 `Lighter` varchar(3) NOT NULL DEFAULT '0',
84 `CarLic` int(1) NOT NULL DEFAULT '0',
85 `FlyLic` int(1) NOT NULL DEFAULT '0',
86 `WepLic` int(1) NOT NULL DEFAULT '0',
87 `LifeLic` int(1) NOT NULL DEFAULT '0',
88 `PhoneBook` int(1) NOT NULL DEFAULT '0',
89 `ListNumber` int(1) NOT NULL DEFAULT '1',
90 `PhoneNumber` int(10) NOT NULL DEFAULT '0',
91 `Materials` int(4) NOT NULL DEFAULT '0',
92 `Products` int(4) NOT NULL DEFAULT '0',
93 `ContractTime` int(2) NOT NULL DEFAULT '0',
94 `WorkOn` int(3) NOT NULL DEFAULT '255',
95 `HeadValue` int(5) NOT NULL DEFAULT '0',
96 `Seeds` int(3) NOT NULL DEFAULT '0',
97 `Weed` int(3) NOT NULL DEFAULT '0',
98 `Ecstasy` int(3) NOT NULL DEFAULT '0',
99 `Amphetamine` int(3) NOT NULL DEFAULT '0',
100 `Cocaine` int(3) NOT NULL DEFAULT '0',
101 `Speed` int(3) NOT NULL DEFAULT '0',
102 `Heroin` int(3) NOT NULL DEFAULT '0',
103 `note1` text NOT NULL,
104 `note2` text NOT NULL,
105 `note3` text NOT NULL,
106 `note4` text NOT NULL,
107 `note5` text NOT NULL,
108 `note1s` int(1) NOT NULL DEFAULT '0',
109 `note2s` int(1) NOT NULL DEFAULT '0',
110 `note3s` int(1) NOT NULL DEFAULT '0',
111 `note4s` int(1) NOT NULL DEFAULT '0',
112 `note5s` int(1) NOT NULL DEFAULT '0',
113 `Inv1` longtext NOT NULL,
114 `Inv2` longtext NOT NULL,
115 `Inv3` longtext NOT NULL,
116 `Inv4` longtext NOT NULL,
117 `Inv5` longtext NOT NULL,
118 `Inv6` longtext NOT NULL,
119 `Inv7` longtext NOT NULL,
120 `Inv8` longtext NOT NULL,
121 `Inv9` longtext NOT NULL,
122 `Inv10` longtext NOT NULL,
123 `Inv11` longtext NOT NULL,
124 `Inv12` longtext NOT NULL,
125 `Inv1a` int(2) NOT NULL DEFAULT '0',
126 `Inv2a` int(2) NOT NULL DEFAULT '0',
127 `Inv3a` int(2) NOT NULL DEFAULT '0',
128 `Inv4a` int(2) NOT NULL DEFAULT '0',
129 `Inv5a` int(2) NOT NULL DEFAULT '0',
130 `Inv6a` int(2) NOT NULL DEFAULT '0',
131 `Inv7a` int(2) NOT NULL DEFAULT '0',
132 `Inv8a` int(2) NOT NULL DEFAULT '0',
133 `Inv9a` int(2) NOT NULL DEFAULT '0',
134 `Inv10a` int(2) NOT NULL DEFAULT '0',
135 `Inv11a` int(2) NOT NULL DEFAULT '0',
136 `Social` int(9) NOT NULL DEFAULT '0',
137 `Rank` int(2) NOT NULL DEFAULT '0',
138 `Fight` int(2) NOT NULL DEFAULT '0',
139 `Walk` int(2) NOT NULL DEFAULT '0',
140 `Talk` int(2) NOT NULL DEFAULT '0',
141 `PlayingHours` int(4) NOT NULL DEFAULT '0',
142 `Age` int(3) NOT NULL DEFAULT '0',
143 `Hunger` int(3) NOT NULL DEFAULT '100',
144 `Race` text NOT NULL,
145 `MoneyConvert` int(2) NOT NULL DEFAULT '0',
146 `Credit` int(8) NOT NULL DEFAULT '0',
147 `Armour` float NOT NULL DEFAULT '0',
148 `BMX` int(2) NOT NULL DEFAULT '0',
149 `Wanted` text NOT NULL,
150 `Cell` int(3) NOT NULL DEFAULT '999',
151 `Location` text NOT NULL,
152 `PaydayTime` varchar(3) NOT NULL DEFAULT '0',
153 `ConName1` text NOT NULL,
154 `ConNum1` int(13) NOT NULL DEFAULT '0',
155 `ConName2` text NOT NULL,
156 `ConNum2` int(13) NOT NULL DEFAULT '0',
157 `WeedX` float NOT NULL DEFAULT '0',
158 `WeedY` float NOT NULL DEFAULT '0',
159 `WeedZ` float NOT NULL DEFAULT '0',
160 `WeedTimer` int(6) NOT NULL DEFAULT '0',
161 `WeedPlant` int(6) NOT NULL DEFAULT '0',
162 `Online` int(2) NOT NULL DEFAULT '0',
163 `CountryUCP` int(2) NOT NULL DEFAULT '0',
164 `NameUCP` text NOT NULL,
165 `AgeUCP` int(2) NOT NULL DEFAULT '0',
166 `MailUCP` text NOT NULL,
167 `FirstHouse` int(2) NOT NULL DEFAULT '0',
168 `FirstCar` int(2) NOT NULL DEFAULT '0',
169 `FirstSmoke` int(2) NOT NULL DEFAULT '0',
170 `JoinOfficialFaction` int(2) NOT NULL DEFAULT '0',
171 `DriveFast` int(2) NOT NULL DEFAULT '0',
172 `GreetJohn` int(2) NOT NULL DEFAULT '0',
173 `DieOneTime` int(2) NOT NULL DEFAULT '0',
174 `DieTwentyTimes` int(2) NOT NULL DEFAULT '0',
175 `FirstDecember` int(2) NOT NULL DEFAULT '0',
176 `CarBill` int(4) NOT NULL DEFAULT '0',
177 `HouseBill` int(4) NOT NULL DEFAULT '0',
178 `BusinessBill` int(4) NOT NULL DEFAULT '0',
179 `NormalMail` int(4) NOT NULL DEFAULT '1',
180 `Developer` int(1) NOT NULL DEFAULT '0',
181 `Garage` int(2) NOT NULL DEFAULT '0',
182 PRIMARY KEY (`UserID`)
183) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=21984 ;