· 8 years ago · Apr 22, 2018, 01:10 AM
1--
2-- Table structure for table `PlayerInfo`
3--
4
5DROP TABLE IF EXISTS `PlayerInfo`;
6/*!40101 SET @saved_cs_client = @@character_set_client */;
7/*!40101 SET character_set_client = utf8 */;
8CREATE TABLE `PlayerInfo` (
9 `SQLID` int(11) NOT NULL AUTO_INCREMENT,
10 `Online` tinyint(1) NOT NULL DEFAULT '0',
11 `PlayerName` varchar(44) DEFAULT NULL,
12 `Password` varchar(129) NOT NULL,
13 `IP` varchar(16) DEFAULT '0.0.0.0',
14 `Money` int(10) NOT NULL DEFAULT '10000',
15 `Bank` int(10) NOT NULL DEFAULT '0',
16 `level` tinyint(3) unsigned NOT NULL DEFAULT '1',
17 `RPoints` smallint(4) NOT NULL DEFAULT '0',
18 `PlayerTime` mediumint(6) NOT NULL DEFAULT '0',
19 `Jail` tinyint(1) NOT NULL DEFAULT '0',
20 `JailTime` mediumint(5) NOT NULL DEFAULT '0',
21 `Banned` tinyint(1) NOT NULL DEFAULT '0',
22 `BanReason` varchar(64) NOT NULL DEFAULT 'None',
23 `WhoBannedMe` varchar(24) NOT NULL DEFAULT 'NoBodY',
24 `WhenIGotBanned` varchar(15) NOT NULL DEFAULT 'None',
25 `Skin` smallint(3) NOT NULL DEFAULT '1',
26 `RentPrice` smallint(5) NOT NULL DEFAULT '0',
27 `DriverLicense` tinyint(1) NOT NULL DEFAULT '0',
28 `PilotLicense` tinyint(1) NOT NULL DEFAULT '0',
29 `WeaponLicense` tinyint(1) NOT NULL DEFAULT '0',
30 `SailingLicense` tinyint(1) NOT NULL DEFAULT '0',
31 `JobSkill` smallint(5) NOT NULL DEFAULT '0',
32 `TotalPlayTime` mediumint(5) NOT NULL DEFAULT '0',
33 `Kills` int(8) NOT NULL DEFAULT '0',
34 `Deaths` int(8) NOT NULL DEFAULT '0',
35 `RentHouse` smallint(4) NOT NULL DEFAULT '-1',
36 `Loan` smallint(5) NOT NULL DEFAULT '0',
37 `Guns` smallint(5) NOT NULL DEFAULT '0',
38 `SGuns` int(10) NOT NULL DEFAULT '0',
39 `SDrugs` int(10) NOT NULL DEFAULT '0',
40 `AdminLevel` smallint(5) NOT NULL DEFAULT '0',
41 `HeadActive` tinyint(1) NOT NULL DEFAULT '0',
42 `HeadBy` varchar(24) NOT NULL DEFAULT 'NoBodY',
43 `Bail` mediumint(7) NOT NULL DEFAULT '0',
44 `PremiumLevel` tinyint(1) NOT NULL DEFAULT '0',
45 `GotPhone` tinyint(1) NOT NULL DEFAULT '0',
46 `PhoneNumber` mediumint(7) NOT NULL DEFAULT '-1',
47 `PhoneBook` tinyint(1) NOT NULL DEFAULT '0',
48 `Laptop` tinyint(1) NOT NULL DEFAULT '0',
49 `Age` tinyint(2) NOT NULL DEFAULT '25',
50 `PremiumExpire` int(10) NOT NULL DEFAULT '0',
51 `FactionID` tinyint(3) unsigned NOT NULL DEFAULT '255',
52 `Radio` tinyint(1) NOT NULL DEFAULT '0',
53 `Freq1` mediumint(7) NOT NULL DEFAULT '666',
54 `Freq2` mediumint(7) NOT NULL DEFAULT '666',
55 `Freq3` mediumint(7) NOT NULL DEFAULT '666',
56 `CurrentFrequency` mediumint(7) NOT NULL DEFAULT '666',
57 `TBanned` int(10) NOT NULL DEFAULT '0',
58 `Married` varchar(24) NOT NULL DEFAULT 'NoBodY',
59 `Job` varchar(12) NOT NULL DEFAULT 'None',
60 `TotalRuns` smallint(5) unsigned NOT NULL DEFAULT '0',
61 `FactionPay` mediumint(7) NOT NULL DEFAULT '0',
62 `DrugInfo` varchar(30) NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0',
63 `Warns` tinyint(3) unsigned NOT NULL DEFAULT '0',
64 `Helper` tinyint(1) unsigned NOT NULL DEFAULT '0',
65 `RankName` varchar(64) NOT NULL DEFAULT 'CIV',
66 `PhoneChanges` tinyint(3) unsigned NOT NULL DEFAULT '0',
67 `PhoneOFF` tinyint(1) NOT NULL DEFAULT '0',
68 `OOCOff` tinyint(1) NOT NULL DEFAULT '0',
69 `WhisperLock` tinyint(1) NOT NULL DEFAULT '0',
70 `jqmessage` tinyint(1) NOT NULL DEFAULT '0',
71 `NameOFF` tinyint(1) NOT NULL DEFAULT '0',
72 `Seeds` smallint(5) unsigned NOT NULL DEFAULT '0',
73 `FishAmount` smallint(4) unsigned NOT NULL DEFAULT '0',
74 `TotalFish` mediumint(8) unsigned NOT NULL DEFAULT '0',
75 `TotalRob` int(10) NOT NULL DEFAULT '0',
76 `totalguns` mediumint(8) unsigned NOT NULL DEFAULT '0',
77 `TotalLogin` smallint(5) unsigned NOT NULL DEFAULT '0',
78 `Key_Enter` varchar(1) NOT NULL DEFAULT '2',
79 `imprisoned` int(1) NOT NULL DEFAULT '0',
80 `OOCMode` tinyint(1) NOT NULL DEFAULT '0',
81 `Fightstyleleft` smallint(5) NOT NULL DEFAULT '0',
82 `Tier` tinyint(2) NOT NULL DEFAULT '-1',
83 `SellableDrugs` int(10) NOT NULL DEFAULT '0',
84 `JailReason` varchar(64) NOT NULL DEFAULT 'None',
85 `housemax` tinyint(2) NOT NULL DEFAULT '2',
86 `bizmax` tinyint(2) NOT NULL DEFAULT '2',
87 `vMax` smallint(4) NOT NULL DEFAULT '12',
88 `vSMax` tinyint(2) NOT NULL DEFAULT '2',
89 `pbkills` smallint(5) NOT NULL DEFAULT '0',
90 `pbDeaths` smallint(5) NOT NULL DEFAULT '0',
91 `LastOnline` varchar(45) NOT NULL DEFAULT '0',
92 `Gender` tinyint(1) NOT NULL DEFAULT '-1',
93 `Ethnicity` tinyint(1) NOT NULL DEFAULT '-1',
94 `Boombox` tinyint(1) NOT NULL DEFAULT '0',
95 `NameChanges` smallint(3) NOT NULL DEFAULT '0',
96 `AllowCBug` tinyint(1) NOT NULL DEFAULT '0',
97 `BoomBoxBan` tinyint(1) NOT NULL DEFAULT '0',
98 `ChatAnim` tinyint(1) NOT NULL DEFAULT '1',
99 `Wanted` tinyint(1) NOT NULL DEFAULT '0',
100 `WantedReason` varchar(128) NOT NULL DEFAULT 'None',
101 PRIMARY KEY (`SQLID`),
102 UNIQUE KEY `PlayerName` (`PlayerName`)
103) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
104/*!40101 SET character_set_client = @saved_cs_client */;
105
106--
107-- Dumping data for table `PlayerInfo`
108--
109
110LOCK TABLES `PlayerInfo` WRITE;
111/*!40000 ALTER TABLE `PlayerInfo` DISABLE KEYS */;
112/*!40000 ALTER TABLE `PlayerInfo` ENABLE KEYS */;
113UNLOCK TABLES;