· 7 years ago · Dec 08, 2018, 02:04 AM
1CREATE TABLE IF NOT EXISTS `users` (
2 `Name` varchar(24) NOT NULL,
3 `Password` varchar(42) NOT NULL,
4 `Admin` int(1) NOT NULL,
5 `Money` int(8) NOT NULL default '15000',
6 `Score` int(5) NOT NULL,
7 `PoliceRank` int(2) NOT NULL,
8 `ID` int(11) NOT NULL auto_increment,
9 `SavedLife` int(1) NOT NULL,
10 `DonatingPlayer` varchar(50) NOT NULL default '0',
11 `DrugSeeds` int(11) NOT NULL,
12 `Skin` int(11) NOT NULL,
13 `Team` int(11) NOT NULL,
14 `WantedLevel` int(11) NOT NULL default '0',
15 `ChasityBelt` int(11) NOT NULL,
16 `Condoms` int(11) NOT NULL,
17 `BankCash` int(100) NOT NULL,
18 `DrugAmount` int(11) NOT NULL,
19 `ConnectedHours` int(11) NOT NULL,
20 `ConnectedMins` int(11) NOT NULL,
21 `Donuts` int(11) NOT NULL,
22 `LifeInsurance` int(11) NOT NULL,
23 `HealthInsurance` int(11) NOT NULL,
24 `HousesAmount` int(11) NOT NULL,
25 `IP` varchar(16) NOT NULL,
26 `AccountDisabled` int(11) NOT NULL,
27 `InHouseID` int(11) NOT NULL default '-1',
28 `Jailed` int(11) NOT NULL,
29 `JailedMins` int(11) NOT NULL,
30 `JailedSecs` int(11) NOT NULL,
31 `JailedBail` int(11) NOT NULL,
32 `DonatingExpiry` int(50) NOT NULL,
33 `CopWorkArrest` int(11) NOT NULL,
34 `CopWorkTick` int(11) NOT NULL,
35 `GunPermit` int(11) NOT NULL,
36 `SILENCEDPISTOL` int(11) NOT NULL,
37 `AK47` int(11) NOT NULL,
38 `MP4` int(11) NOT NULL,
39 `MP5` int(11) NOT NULL,
40 `TEC9` int(11) NOT NULL,
41 `SNIPER` int(11) NOT NULL,
42 `SAWNOFF` int(11) NOT NULL,
43 `ARMOUR` int(11) NOT NULL,
44 `STOCK` int(11) NOT NULL,
45 `FIVEGRAMS` int(11) NOT NULL,
46 `TENGRAMS` int(11) NOT NULL,
47 `FIFTYGRAMS` int(11) NOT NULL,
48 `HUNDREDGRAMS` int(11) NOT NULL,
49 `TWOHUNDREDGRAMS` int(11) NOT NULL,
50 `FIVEHUNDREDGRAMS` int(11) NOT NULL,
51 `JailedEscape` int(11) NOT NULL,
52 `HEAL` int(11) NOT NULL default '1500',
53 `CURE` int(11) NOT NULL default '2500',
54 `BOTHHEALCURE` int(11) NOT NULL default '4000',
55 `MEDICSTOCK` int(11) NOT NULL,
56 `HasSTDSwineFlu` int(11) NOT NULL,
57 `HasSTDGonorrhea` int(11) NOT NULL,
58 `HasSTDSyphilis` int(11) NOT NULL,
59 `OnDrugs` int(11) NOT NULL default '-1',
60 `LastTimePaidTax` int(11) NOT NULL,
61 `LastCrimes1` varchar(60) NOT NULL default 'None',
62 `LastCrimes2` varchar(60) NOT NULL default 'None',
63 `LastCrimes3` varchar(60) NOT NULL default 'None',
64 `LastCrimes4` varchar(60) NOT NULL default 'None',
65 `LastCrimes5` varchar(60) NOT NULL default 'None',
66 `WeaponsForSpawn` varchar(128) NOT NULL default '0|0,0|0,0|0,0|0,0|0,0|0,0|0,0|0,0|0,0|0,0|0,0|0,',
67 `DaysAlive` int(11) NOT NULL default '0',
68 `Age` int(5) NOT NULL default '0',
69 `CrimesCommited` int(20) NOT NULL default '0',
70 `WantedLevelGained` int(20) NOT NULL default '0',
71 `TicketsReceived` int(20) NOT NULL default '0',
72 `TicketsPaid` int(20) NOT NULL default '0',
73 `Arrests` int(20) NOT NULL default '0',
74 `DrugsTaken` int(20) NOT NULL default '0',
75 `Diseases` int(20) NOT NULL default '0',
76 `HitsPlaced` int(20) NOT NULL default '0',
77 `HitsCompleted` int(20) NOT NULL default '0',
78 `TimesRaped` int(20) NOT NULL default '0',
79 `TimesRobbed` int(20) NOT NULL default '0',
80 `Kills` int(20) NOT NULL default '0',
81 `Deaths` int(20) NOT NULL default '0',
82 `TimesExposed` int(20) NOT NULL default '0',
83 `FishCaught` int(20) NOT NULL default '0',
84 `SeedsPlanted` int(20) NOT NULL default '0',
85 `PlantsHarvested` int(20) NOT NULL default '0',
86 `Holdups` int(20) NOT NULL default '0',
87 `CasinoRobberies` int(20) NOT NULL default '0',
88 `BankRobberies` int(20) NOT NULL default '0',
89 `SavedLife2` int(2) NOT NULL,
90 `LastOnline` int(10) NOT NULL default '0',
91 `DrunkPlayer` int(11) NOT NULL default '0',
92 `Password2` varchar(32) NOT NULL,
93 `Debt` int(9) NOT NULL default '0',
94 `TrainTicket` int(4) NOT NULL default '0',
95 `TakeDowns` int(9) NOT NULL default '0',
96 `TicketsIssued` int(9) NOT NULL default '0',
97 `TicketsCollected` int(9) NOT NULL default '0',
98 `PetName` varchar(24) NOT NULL default 'No Pet',
99 `PetDays` int(9) NOT NULL default '0',
100 `PetSize` int(9) NOT NULL default '0',
101 `PetHungar` int(9) NOT NULL,
102 `PetClass` int(9) NOT NULL default '0',
103 UNIQUE KEY `ID` (`ID`)
104) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=260 ;