· 7 years ago · Dec 27, 2018, 01:52 PM
1CREATE TABLE IF NOT EXISTS `accounts` (
2 `ID` int(11) NOT NULL AUTO_INCREMENT,
3 `NickName` varchar(24) CHARACTER SET cp1251 COLLATE cp1251_general_cs NOT NULL,
4 `Password` varchar(64) NOT NULL DEFAULT 'NULL',
5 `RegIP` varchar(16) NOT NULL DEFAULT 'No IP Adress',
6 `OldIP` varchar(16) NOT NULL DEFAULT 'No IP Adress',
7 `CheckIP1` varchar(16) NOT NULL DEFAULT 'No IP Adress',
8 `CheckIP2` varchar(16) NOT NULL DEFAULT 'No IP Adress',
9 `Referal` varchar(24) NOT NULL DEFAULT 'No Referal',
10 `Mail` varchar(50) NOT NULL DEFAULT 'No Mail Adress',
11 `Telephone` varchar(20) NOT NULL DEFAULT 'No Telephone',
12 `ForumName` varchar(30) NOT NULL DEFAULT 'No Forum Name',
13 `Level` int(11) NOT NULL,
14 `Exp` int(11) NOT NULL,
15 `PlayHours` int(11) NOT NULL,
16 `Sex` int(11) NOT NULL,
17 `Age` int(11) NOT NULL,
18 `Race` int(11) NOT NULL,
19 `Admin` int(11) NOT NULL,
20 `Helper` int(11) NOT NULL,
21 `Money` int(11) NOT NULL,
22 `Bank` int(11) NOT NULL,
23 `Wanted` int(11) NOT NULL,
24 `VIP` int(11) NOT NULL,
25 `Leader` int(11) NOT NULL,
26 `Member` int(11) NOT NULL,
27 `Rank` int(11) NOT NULL,
28 `GunLic` int(11) NOT NULL,
29 `BoatLic` int(11) NOT NULL,
30 `FishLic` int(11) NOT NULL,
31 `FlyLic` int(11) NOT NULL,
32 `CarLic` int(11) NOT NULL,
33 `BikeLic` int(11) NOT NULL,
34 `D_Packets` int(11) NOT NULL,
35 `Warns` int(11) NOT NULL,
36 `PayDay` int(11) NOT NULL,
37 `HouseKey` int(11) NOT NULL,
38 `BizKey` int(11) NOT NULL,
39 `FWarns` int(11) NOT NULL,
40 `Skin` int(11) NOT NULL,
41 `TelNum` int(11) NOT NULL,
42 `Phone` int(11) NOT NULL,
43 `Mats` int(11) NOT NULL,
44 `Packets` int(11) NOT NULL,
45 `Drugs` int(11) NOT NULL,
46 `Job` int(11) NOT NULL,
47 `MuteTime` int(11) NOT NULL,
48 `FMuteTime` int(11) NOT NULL,
49 `JailTime` int(11) NOT NULL,
50 `BailPrice` int(11) NOT NULL,
51 `KungfuStyle` int(11) NOT NULL,
52 `KneeheadStyle` int(11) NOT NULL,
53 `BoxingStyle` int(11) NOT NULL,
54 `ElbowStyle` int(11) NOT NULL,
55 `Style` int(11) NOT NULL,
56 `Spawned` int(11) NOT NULL,
57 `NeSdal` int(11) NOT NULL,
58 `DropCarTime` int(11) NOT NULL,
59 `Drunk` int(11) NOT NULL,
60 `Spining` int(11) NOT NULL,
61 `Worms` int(11) NOT NULL,
62 `Lotto` int(11) NOT NULL,
63 `Mask` int(11) NOT NULL,
64 `Roliki` int(11) NOT NULL,
65 `Fuel` int(11) NOT NULL,
66 `PhoneBook` int(11) NOT NULL,
67 `Pistol_Skill` int(11) NOT NULL,
68 `SDPistol_Skill` int(11) NOT NULL,
69 `Eagle_Skill` int(11) NOT NULL,
70 `ShotGun_Skill` int(11) NOT NULL,
71 `UZI_Skill` int(11) NOT NULL,
72 `MP5_Skill` int(11) NOT NULL,
73 `AK47_Skill` int(11) NOT NULL,
74 `M4_Skill` int(11) NOT NULL,
75 `Sniper_Skill` int(11) NOT NULL,
76 `Glasses` int(11) NOT NULL,
77 `Bandans` int(11) NOT NULL,
78 `Hats` int(11) NOT NULL,
79 `IncReset` int(11) NOT NULL,
80 `Poison` int(11) NOT NULL,
81 `Syringe` int(11) NOT NULL,
82 `Smokes` int(11) NOT NULL,
83 `Lighter` int(11) NOT NULL,
84 `From` int(11) NOT NULL DEFAULT '-1',
85 `BlackList` int(11) NOT NULL,
86 `OOC` int(11) NOT NULL DEFAULT '1',
87 `ZKP` int(11) NOT NULL,
88 `CarPoundTime` int(11) NOT NULL,
89 `Heal` int(11) NOT NULL,
90 `Fullness` int(11) NOT NULL,
91 `Pack` int(11) NOT NULL,
92 `Sprunks` int(11) NOT NULL,
93 `Cheeps` int(11) NOT NULL,
94 `Radio` int(11) NOT NULL,
95 `TruckReset` int(11) NOT NULL,
96 `Snow` int(11) NOT NULL DEFAULT '1',
97 `VirMoney` int(11) NOT NULL,
98 `OldRepl` int(11) NOT NULL,
99 `AllRepl` int(11) NOT NULL,
100 `GetBonus` int(11) NOT NULL,
101 `Key` int(11) NOT NULL,
102 `KeyCheck` int(11) NOT NULL,
103 `StatsStyle` int(11) NOT NULL,
104 `Credit` int(11) NOT NULL,
105 `EnterKey` int(11) NOT NULL,
106 `NewVirMoney` int(11) NOT NULL,
107 `View` int(11) NOT NULL,
108 `FeFinder` int(11) NOT NULL,
109 `Gold` int(11) NOT NULL,
110 `RepBan` int(11) NOT NULL,
111 `AskBan` int(11) NOT NULL,
112 `Clip` int(11) NOT NULL,
113 `ContractTime` int(11) NOT NULL,
114 `GunsUP` int(11) NOT NULL,
115 `BuyGuns` int(11) NOT NULL,
116 `RPTest` int(11) NOT NULL,
117 `Energy` float NOT NULL,
118 `RepPack` int(11) NOT NULL,
119 `F_Skill` int(11) NOT NULL,
120 `P_Skill` int(11) NOT NULL,
121 `Z_Skill` int(11) NOT NULL,
122 `Za_Skill` int(11) NOT NULL,
123 `In_Skill` int(11) NOT NULL,
124 `My_Skill` int(11) NOT NULL,
125 `By_Skill` int(11) NOT NULL,
126 `Online_status` int(11) NOT NULL,
127 `VipTime` int(11) NOT NULL,
128 `Merrit` int(11) NOT NULL,
129 `Sprunkq` int(11) NOT NULL,
130 `Beerq` int(11) NOT NULL,
131 `ShowCase` int(11) NOT NULL,
132 `LastIP` text NOT NULL,
133 `LastLogin` text NOT NULL,
134 `HavePassword` int(11) NOT NULL,
135 `HP` float NOT NULL,
136 `Walentin` int(11) NOT NULL,
137 `BuyWalent` int(11) NOT NULL,
138 `TimeToLastWarn` int(11) NOT NULL,
139 `Hospital` int(11) NOT NULL,
140 `pSlotItem0` int(11) NOT NULL,
141 `pSlotItem1` int(11) NOT NULL,
142 `pSlotItem2` int(11) NOT NULL,
143 `pSlotItem3` int(111) NOT NULL,
144 `pSlotItem4` int(11) NOT NULL,
145 `pSlotItem5` int(11) NOT NULL,
146 `Redio` int(11) NOT NULL,
147 `More` int(11) NOT NULL,
148 `Cheepsq` int(11) NOT NULL,
149 `Weapons` varchar(56) NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0,0,0,0,0',
150 `pAmountSex` int(11) NOT NULL,
151 `pDisease` int(11) NOT NULL,
152 `pWhore` int(11) NOT NULL,
153 `pMesh` int(11) NOT NULL,
154 `FamilyID` int(11) NOT NULL DEFAULT '-1',
155 `FamilyMute` int(11) NOT NULL DEFAULT '0',
156 `pReputation` int(11) NOT NULL,
157 `pLoadTextures` int(11) NOT NULL DEFAULT '1',
158 `FamTalon` int(11) NOT NULL,
159 PRIMARY KEY (`ID`)
160) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=6 ;---------------------------------------------------
161
162--