· 9 years ago · Jan 23, 2017, 04:14 PM
1--
2-- Structure de la table `containers`
3--
4
5CREATE TABLE IF NOT EXISTS `containers` (
6 `id` int(11) NOT NULL AUTO_INCREMENT,
7 `pid` varchar(32) NOT NULL,
8 `classname` varchar(32) NOT NULL,
9 `pos` varchar(64) DEFAULT NULL,
10 `inventory` varchar(500) NOT NULL,
11 `gear` text NOT NULL,
12 `dir` varchar(64) DEFAULT NULL,
13 `active` tinyint(1) NOT NULL DEFAULT '0',
14 `owned` tinyint(4) DEFAULT '0',
15 PRIMARY KEY (`id`,`pid`)
16) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
17
18-- --------------------------------------------------------
19
20--
21-- Structure de la table `gangs`
22--
23
24CREATE TABLE IF NOT EXISTS `gangs` (
25 `id` int(11) NOT NULL AUTO_INCREMENT,
26 `owner` varchar(32) DEFAULT NULL,
27 `name` varchar(32) DEFAULT NULL,
28 `members` text,
29 `maxmembers` int(2) DEFAULT '8',
30 `bank` int(100) DEFAULT '0',
31 `active` tinyint(4) DEFAULT '1',
32 PRIMARY KEY (`id`),
33 UNIQUE KEY `name_UNIQUE` (`name`)
34) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
35
36-- --------------------------------------------------------
37
38--
39-- Structure de la table `houses`
40--
41
42CREATE TABLE IF NOT EXISTS `houses` (
43 `id` int(11) NOT NULL AUTO_INCREMENT,
44 `pid` varchar(32) NOT NULL,
45 `pos` varchar(64) DEFAULT NULL,
46 `owned` tinyint(4) DEFAULT '0',
47 PRIMARY KEY (`id`,`pid`)
48) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
49
50-- --------------------------------------------------------
51
52--
53-- Structure de la table `players`
54--
55
56CREATE TABLE IF NOT EXISTS `players` (
57 `uid` int(12) NOT NULL AUTO_INCREMENT,
58 `name` varchar(32) NOT NULL,
59 `aliases` text NOT NULL,
60 `playerid` varchar(50) NOT NULL,
61 `cash` int(100) NOT NULL DEFAULT '0',
62 `bankacc` int(100) NOT NULL DEFAULT '0',
63 `coplevel` enum('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',
64 `mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
65 `civ_licenses` text NOT NULL,
66 `cop_licenses` text NOT NULL,
67 `med_licenses` text NOT NULL,
68 `civ_gear` text NOT NULL,
69 `cop_gear` text NOT NULL,
70 `med_gear` text NOT NULL,
71 `civ_stats` varchar(11) NOT NULL DEFAULT '"[100,100]"',
72 `cop_stats` varchar(11) NOT NULL DEFAULT '"[100,100]"',
73 `med_stats` varchar(11) NOT NULL DEFAULT '"[100,100]"',
74 `arrested` tinyint(1) NOT NULL DEFAULT '0',
75 `adminlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
76 `donatorlvl` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
77 `blacklist` tinyint(1) NOT NULL DEFAULT '0',
78 PRIMARY KEY (`uid`),
79 UNIQUE KEY `playerid` (`playerid`),
80 KEY `name` (`name`),
81 KEY `blacklist` (`blacklist`)
82) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
83
84-- --------------------------------------------------------
85
86--
87-- Structure de la table `vehicles`
88--
89
90CREATE TABLE IF NOT EXISTS `vehicles` (
91 `id` int(12) NOT NULL AUTO_INCREMENT,
92 `side` varchar(15) NOT NULL,
93 `classname` varchar(32) NOT NULL,
94 `type` varchar(12) NOT NULL,
95 `pid` varchar(32) NOT NULL,
96 `alive` tinyint(1) NOT NULL DEFAULT '1',
97 `active` tinyint(1) NOT NULL DEFAULT '0',
98 `plate` int(20) NOT NULL,
99 `color` int(20) NOT NULL,
100 `inventory` varchar(500) NOT NULL,
101 `gear` text NOT NULL,
102 `fuel` double NOT NULL DEFAULT '1',
103 PRIMARY KEY (`id`),
104 KEY `side` (`side`),
105 KEY `pid` (`pid`),
106 KEY `type` (`type`)
107) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
108
109-- --------------------------------------------------------
110
111--
112-- Structure de la table `wanted`
113--
114
115CREATE TABLE IF NOT EXISTS `wanted` (
116 `wantedID` varchar(50) NOT NULL,
117 `wantedName` varchar(52) NOT NULL,
118 `wantedCrimes` text NOT NULL,
119 `wantedBounty` int(100) NOT NULL,
120 `active` tinyint(1) NOT NULL DEFAULT '0',
121 PRIMARY KEY (`wantedID`)
122) ENGINE=InnoDB DEFAULT CHARSET=latin1;