· 8 years ago · Apr 18, 2018, 07:10 PM
1DROP TABLE IF EXISTS `characters`;
2CREATE TABLE `characters` (
3 `master_dbid` int(11) NOT NULL,
4 `char_dbid` int(11) NOT NULL AUTO_INCREMENT,
5 `char_name` varchar(32) NOT NULL,
6 `create_date` varchar(60) NOT NULL,
7 `create_ip` varchar(60) NOT NULL,
8 `pLastSkin` int(11) NOT NULL DEFAULT '264',
9 `pLastPosX` float NOT NULL DEFAULT '1642.02',
10 `pLastPosY` float NOT NULL DEFAULT '-2334.05',
11 `pLastPosZ` float NOT NULL DEFAULT '13.5469',
12 `pLastInterior` int(11) NOT NULL DEFAULT '0',
13 `pLastWorld` int(11) NOT NULL DEFAULT '0',
14 `pLevel` int(11) NOT NULL DEFAULT '1',
15 `pEXP` int(11) NOT NULL DEFAULT '0',
16 `pAge` varchar(20) NOT NULL DEFAULT 'Invalid',
17 `pOrigin` varchar(60) NOT NULL DEFAULT 'Invalid',
18 `pStory` varchar(90) NOT NULL DEFAULT 'Nothing',
19 `pStoryTwo` varchar(90) NOT NULL DEFAULT 'Nothing',
20 `pMoney` int(11) NOT NULL DEFAULT '5000',
21 `pBank` int(11) NOT NULL DEFAULT '15000',
22 `pPaycheck` int(11) NOT NULL DEFAULT '5000',
23 `pPhone` int(11) NOT NULL,
24 `pLastOnline` varchar(90) NOT NULL,
25 `pLastOnlineTime` int(11) NOT NULL,
26 `pAdminjailed` tinyint(1) NOT NULL,
27 `pAdminjailTime` int(11) NOT NULL,
28 `pOfflinejailed` tinyint(1) NOT NULL DEFAULT '0',
29 `pOfflinejailedReason` varchar(128) NOT NULL,
30 `pFaction` int(11) NOT NULL DEFAULT '0',
31 `pFactionRank` int(11) NOT NULL DEFAULT '0',
32 `pOwnedVehicles1` int(11) NOT NULL DEFAULT '0',
33 `pOwnedVehicles2` int(11) NOT NULL DEFAULT '0',
34 `pOwnedVehicles3` int(11) NOT NULL DEFAULT '0',
35 `pOwnedVehicles4` int(11) NOT NULL DEFAULT '0',
36 `pOwnedVehicles5` int(11) NOT NULL DEFAULT '0',
37 `pVehicleSpawned` tinyint(1) NOT NULL DEFAULT '0',
38 `pVehicleSpawnedID` int(11) NOT NULL DEFAULT '0',
39 `pWeapons0` tinyint(4) NOT NULL DEFAULT '0',
40 `pWeapons1` tinyint(4) NOT NULL DEFAULT '0',
41 `pWeapons2` tinyint(4) NOT NULL DEFAULT '0',
42 `pWeapons3` tinyint(4) NOT NULL DEFAULT '0',
43 `pWeaponsAmmo0` smallint(6) NOT NULL DEFAULT '0',
44 `pWeaponsAmmo1` smallint(6) NOT NULL DEFAULT '0',
45 `pWeaponsAmmo2` smallint(6) NOT NULL DEFAULT '0',
46 `pWeaponsAmmo3` smallint(6) NOT NULL DEFAULT '0',
47 `pTimeplayed` int(11) NOT NULL DEFAULT '0',
48 `pMaskID` int(11) NOT NULL,
49 `pMaskIDEx` int(11) NOT NULL,
50 `pInProperty` int(11) NOT NULL DEFAULT '0',
51 `pInBusiness` int(11) NOT NULL DEFAULT '0',
52 `pHasRadio` tinyint(1) NOT NULL DEFAULT '0',
53 `pRadio1` int(11) NOT NULL DEFAULT '0',
54 `pRadio2` int(11) NOT NULL DEFAULT '0',
55 `pMainSlot` int(11) NOT NULL DEFAULT '1',
56 `pGascan` int(11) NOT NULL DEFAULT '0',
57 `pSpawnPoint` int(11) NOT NULL DEFAULT '0',
58 `pSpawnPointHouse` int(11) NOT NULL DEFAULT '0',
59 `pWeaponsLicense` int(11) NOT NULL DEFAULT '0',
60 `pDriversLicense` int(11) NOT NULL DEFAULT '0',
61 `pActiveListings` int(11) NOT NULL DEFAULT '0',
62 `pPrisonTimes` int(11) NOT NULL DEFAULT '0',
63 `pJailTimes` int(11) NOT NULL DEFAULT '0',
64 PRIMARY KEY (`char_dbid`)
65) ENGINE=InnoDB DEFAULT CHARSET=latin1;