· 10 years ago · Aug 24, 2016, 10:46 PM
1CREATE TABLE IF NOT EXISTS `accounts` (
2 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
3 `username` varchar(255) NOT NULL,
4 `password` varchar(255) NOT NULL,
5 `admin_level` tinyint(1) unsigned NOT NULL,
6 `admin_state` tinyint(1) unsigned NOT NULL,
7 `admin_hidden` tinyint(1) unsigned NOT NULL DEFAULT '0',
8 `option_1` tinyint(1) unsigned NOT NULL DEFAULT '0',
9 `option_2` varchar(4) NOT NULL DEFAULT 'both',
10 `option_3` tinyint(1) unsigned NOT NULL DEFAULT '0',
11 `option_4` tinyint(1) unsigned NOT NULL DEFAULT '1',
12 `option_5` tinyint(1) unsigned NOT NULL DEFAULT '1',
13 `option_6` tinyint(1) unsigned NOT NULL DEFAULT '0',
14 `option_7` tinyint(1) unsigned NOT NULL DEFAULT '1',
15 `option_8` tinyint(1) unsigned NOT NULL DEFAULT '1',
16 `settings` varchar(255) 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 ] ]',
17 `jailed` int(11) NOT NULL DEFAULT '-1',
18 `jailedReason` text NOT NULL,
19 `jailedBy` int(10) unsigned NOT NULL DEFAULT '0',
20 `points` int(10) unsigned NOT NULL DEFAULT '0',
21 `perks` varchar(255) NOT NULL DEFAULT '[ ]',
22 `loginDate` varchar(255) NOT NULL DEFAULT '0',
23 `registerDate` varchar(255) NOT NULL DEFAULT '0',
24 `lastOnline` varchar(1000) NOT NULL DEFAULT '0',
25 `lastIP` varchar(255) NOT NULL DEFAULT '0.0.0.0',
26 `lastSerial` varchar(255) NOT NULL DEFAULT '0',
27 PRIMARY KEY (`id`)
28) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
29
30CREATE TABLE IF NOT EXISTS `atms` (
31 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
32 `posX` float NOT NULL,
33 `posY` float NOT NULL,
34 `posZ` float NOT NULL,
35 `rotation` float NOT NULL,
36 `interior` tinyint(3) unsigned NOT NULL DEFAULT '0',
37 `dimension` smallint(5) unsigned NOT NULL DEFAULT '0',
38 `deposit` tinyint(1) unsigned NOT NULL DEFAULT '0',
39 `withdraw` tinyint(1) unsigned NOT NULL DEFAULT '1',
40 `limit` int(10) unsigned NOT NULL DEFAULT '5000',
41 `created` varchar(255) NOT NULL DEFAULT '0',
42 PRIMARY KEY (`id`)
43) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
44
45CREATE TABLE IF NOT EXISTS `characters` (
46 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
47 `characterName` varchar(255) NOT NULL,
48 `posX` float NOT NULL DEFAULT '1732.4',
49 `posY` float NOT NULL DEFAULT '-1912.06',
50 `posZ` float NOT NULL DEFAULT '13.56',
51 `rotX` float NOT NULL DEFAULT '0',
52 `rotY` float NOT NULL DEFAULT '0',
53 `rotZ` float NOT NULL DEFAULT '90.78',
54 `interior` tinyint(3) unsigned NOT NULL DEFAULT '0',
55 `dimension` smallint(5) unsigned NOT NULL DEFAULT '0',
56 `lastArea` varchar(255) NOT NULL DEFAULT 'Unknown',
57 `loginDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
58 `registerDate` varchar(255) NOT NULL DEFAULT '0',
59 `lastOnline` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
60 `hoursOnline` int(10) unsigned NOT NULL DEFAULT '0',
61 `gender` tinyint(1) unsigned NOT NULL DEFAULT '0',
62 `race` tinyint(1) unsigned NOT NULL DEFAULT '0',
63 `model` smallint(3) unsigned NOT NULL DEFAULT '1',
64 `description` text NOT NULL,
65 `age` tinyint(3) unsigned NOT NULL DEFAULT '16',
66 `height` tinyint(3) unsigned NOT NULL DEFAULT '145',
67 `weight` tinyint(3) unsigned NOT NULL DEFAULT '40',
68 `health` smallint(3) unsigned NOT NULL DEFAULT '100',
69 `armor` tinyint(3) unsigned NOT NULL DEFAULT '0',
70 `cash` int(10) unsigned NOT NULL DEFAULT '250',
71 `bank` bigint(20) NOT NULL DEFAULT '12500',
72 `cked` tinyint(1) unsigned NOT NULL DEFAULT '0',
73 `CoD` text NOT NULL,
74 `factionID` smallint(5) unsigned NOT NULL DEFAULT '0',
75 `factionRank` tinyint(2) unsigned NOT NULL DEFAULT '1',
76 `factionPrivileges` tinyint(1) unsigned NOT NULL DEFAULT '0',
77 `jobID` int(10) unsigned NOT NULL DEFAULT '0',
78 `playedTime` bigint(20) unsigned NOT NULL DEFAULT '0',
79 `driversLicense` tinyint(1) unsigned NOT NULL DEFAULT '0',
80 `transmissionLicense` tinyint(1) NOT NULL DEFAULT '-1',
81 `userID` int(10) unsigned NOT NULL,
82 PRIMARY KEY (`id`)
83) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
84
85CREATE TABLE IF NOT EXISTS `config` (
86 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
87 `key` varchar(255) NOT NULL,
88 `value` text NOT NULL,
89 PRIMARY KEY (`id`)
90) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
91
92INSERT INTO `config` (`id`, `key`, `value`) VALUES
93(1, 'motd', 'Welcome to FairPlay Gaming MTA: Roleplay! This is an open-source roleplay gamemode developed by Socialz (GitHub repository: Socialz/lua-mta-roleplay).'),
94(2, 'gov_property_tax', '90'),
95(3, 'gov_vehicle_tax', '60'),
96(4, 'gov_state_benefit', '220');
97
98CREATE TABLE IF NOT EXISTS `contacts` (
99 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
100 `name` varchar(100) NOT NULL,
101 `number` varchar(10) NOT NULL,
102 `ownerNumber` varchar(10) NOT NULL,
103 PRIMARY KEY (`id`)
104) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
105
106CREATE TABLE IF NOT EXISTS `elevators` (
107 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
108 `posX` float NOT NULL DEFAULT '0',
109 `posY` float NOT NULL DEFAULT '0',
110 `posZ` float NOT NULL DEFAULT '0',
111 `interior` tinyint(3) unsigned NOT NULL DEFAULT '0',
112 `dimension` smallint(5) unsigned NOT NULL DEFAULT '0',
113 `posX2` float NOT NULL DEFAULT '0',
114 `posY2` float NOT NULL DEFAULT '0',
115 `posZ2` float NOT NULL DEFAULT '0',
116 `interior2` tinyint(3) unsigned NOT NULL DEFAULT '0',
117 `dimension2` smallint(5) unsigned NOT NULL DEFAULT '0',
118 `openType` tinyint(1) unsigned NOT NULL DEFAULT '1',
119 PRIMARY KEY (`id`)
120) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
121
122CREATE TABLE IF NOT EXISTS `factions` (
123 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
124 `name` varchar(255) NOT NULL DEFAULT 'Untitled Faction',
125 `description` text NOT NULL,
126 `ranks` varchar(1000) NOT NULL DEFAULT '[ [ "Rank 1", "Rank 2", "Rank 3", "Rank 4", "Rank 5", "Rank 6", "Rank 7", "Rank 8", "Rank 9", "Rank 10", "Rank 11", "Rank 12", "Rank 13", "Rank 14", "Rank 15", "Rank 16", "Rank 17", "Rank 18", "Rank 19", "Rank 20" ] ]',
127 `wages` varchar(1000) NOT NULL DEFAULT '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]',
128 `created` int(10) unsigned NOT NULL DEFAULT '0',
129 `motd` text NOT NULL,
130 `type` tinyint(2) unsigned NOT NULL DEFAULT '1',
131 `inviteCount` tinyint(1) unsigned NOT NULL DEFAULT '0',
132 `bankValue` bigint(20) NOT NULL DEFAULT '0',
133 PRIMARY KEY (`id`)
134) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
135
136CREATE TABLE IF NOT EXISTS `fuelstations` (
137 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
138 `posX` float NOT NULL,
139 `posY` float NOT NULL,
140 `posZ` float NOT NULL,
141 `rotZ` float NOT NULL,
142 `dimension` int(10) unsigned NOT NULL DEFAULT '0',
143 `interior` int(10) unsigned NOT NULL DEFAULT '0',
144 `modelID` smallint(3) unsigned NOT NULL DEFAULT '50',
145 `name` varchar(255) NOT NULL DEFAULT 'John_Doe',
146 PRIMARY KEY (`id`)
147) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
148
149CREATE TABLE IF NOT EXISTS `gates` (
150 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
151 `modelID` smallint(5) unsigned NOT NULL DEFAULT '1337',
152 `posX` float NOT NULL DEFAULT '0',
153 `posY` float NOT NULL DEFAULT '0',
154 `posZ` float NOT NULL DEFAULT '0',
155 `rotX` float NOT NULL DEFAULT '0',
156 `rotY` float NOT NULL DEFAULT '0',
157 `rotZ` float NOT NULL DEFAULT '0',
158 `interior` tinyint(3) unsigned NOT NULL DEFAULT '0',
159 `dimension` smallint(5) unsigned NOT NULL DEFAULT '0',
160 `endPosX` float NOT NULL DEFAULT '0',
161 `endPosY` float NOT NULL DEFAULT '0',
162 `endPosZ` float NOT NULL DEFAULT '0',
163 `endRotX` float NOT NULL DEFAULT '0',
164 `endRotY` float NOT NULL DEFAULT '0',
165 `endRotZ` float NOT NULL DEFAULT '0',
166 `endInterior` tinyint(3) unsigned NOT NULL DEFAULT '0',
167 `endDimension` smallint(5) unsigned NOT NULL DEFAULT '0',
168 `lockMethod` tinyint(1) unsigned NOT NULL DEFAULT '1',
169 `openCondition` varchar(100) NOT NULL,
170 `moveSpeed` mediumint(8) unsigned NOT NULL DEFAULT '1100',
171 `openTime` int(10) unsigned NOT NULL DEFAULT '5000',
172 `easingMethod` varchar(100) NOT NULL DEFAULT 'Linear',
173 `easingPeriod` float unsigned NOT NULL DEFAULT '0',
174 `easingAmplitude` float unsigned NOT NULL DEFAULT '0',
175 `easingOvershoot` float unsigned NOT NULL DEFAULT '0',
176 `radius` float unsigned NOT NULL DEFAULT '6.5',
177 `gateName` varchar(255) NOT NULL DEFAULT 'undefined',
178 `createdBy` int(10) unsigned NOT NULL,
179 `createdOn` int(10) unsigned NOT NULL,
180 PRIMARY KEY (`id`)
181) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
182
183CREATE TABLE IF NOT EXISTS `interiors` (
184 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
185 `name` varchar(255) NOT NULL DEFAULT 'Unknown',
186 `posX` float NOT NULL,
187 `posY` float NOT NULL,
188 `posZ` float NOT NULL,
189 `interior` tinyint(3) unsigned NOT NULL DEFAULT '0',
190 `dimension` smallint(5) unsigned NOT NULL DEFAULT '0',
191 `interiorID` smallint(5) unsigned NOT NULL,
192 `interiorType` tinyint(3) unsigned NOT NULL DEFAULT '0',
193 `interiorCost` int(10) unsigned NOT NULL DEFAULT '0',
194 `disabled` tinyint(1) unsigned NOT NULL DEFAULT '0',
195 `locked` tinyint(1) unsigned NOT NULL DEFAULT '1',
196 `lastused` varchar(255) NOT NULL DEFAULT '0',
197 `created` varchar(255) NOT NULL DEFAULT '0',
198 `userID` int(10) unsigned NOT NULL,
199 PRIMARY KEY (`id`)
200) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
201
202CREATE TABLE IF NOT EXISTS `inventory` (
203 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
204 `charID` int(10) unsigned NOT NULL,
205 `itemID` int(10) unsigned NOT NULL,
206 `value` varchar(255) NOT NULL,
207 `ringtoneID` tinyint(2) unsigned NOT NULL DEFAULT '1',
208 `messagetoneID` tinyint(2) unsigned NOT NULL DEFAULT '1',
209 `timestamp` varchar(255) NOT NULL,
210 PRIMARY KEY (`id`)
211) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
212
213CREATE TABLE IF NOT EXISTS `languages` (
214 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
215 `charID` int(10) unsigned NOT NULL,
216 `lang1` tinyint(2) unsigned NOT NULL DEFAULT '1',
217 `lang2` tinyint(2) unsigned NOT NULL DEFAULT '0',
218 `lang3` tinyint(2) unsigned NOT NULL DEFAULT '0',
219 `skill1` tinyint(3) unsigned NOT NULL DEFAULT '100',
220 `skill2` tinyint(3) unsigned NOT NULL DEFAULT '0',
221 `skill3` tinyint(3) unsigned NOT NULL DEFAULT '0',
222 PRIMARY KEY (`id`)
223) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
224
225CREATE TABLE IF NOT EXISTS `logs` (
226 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
227 `logSource` text CHARACTER SET latin1 NOT NULL,
228 `logActionID` tinyint(3) unsigned NOT NULL DEFAULT '0',
229 `logAffected` text CHARACTER SET latin1 NOT NULL,
230 `logData` longtext CHARACTER SET latin1 NOT NULL,
231 `logTime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
232 PRIMARY KEY (`id`)
233) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
234
235CREATE TABLE IF NOT EXISTS `perks` (
236 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
237 `userID` int(10) unsigned NOT NULL,
238 `perkID` int(11) NOT NULL,
239 `value` varchar(255) NOT NULL,
240 `expire` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
241 `set` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
242 PRIMARY KEY (`id`)
243) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
244
245CREATE TABLE IF NOT EXISTS `shops` (
246 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
247 `posX` float NOT NULL DEFAULT '0',
248 `posY` float NOT NULL DEFAULT '0',
249 `posZ` float NOT NULL DEFAULT '3',
250 `rotation` float NOT NULL DEFAULT '0',
251 `interior` tinyint(3) unsigned NOT NULL DEFAULT '0',
252 `dimension` smallint(5) unsigned NOT NULL DEFAULT '0',
253 `shopID` tinyint(3) unsigned NOT NULL DEFAULT '1',
254 `skinID` smallint(3) unsigned NOT NULL DEFAULT '186',
255 `created` varchar(255) NOT NULL DEFAULT '0',
256 PRIMARY KEY (`id`)
257) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
258
259CREATE TABLE IF NOT EXISTS `vehicles` (
260 `id` int(11) NOT NULL AUTO_INCREMENT,
261 `modelid` smallint(3) unsigned NOT NULL,
262 `userID` int(10) NOT NULL,
263 `posX` float NOT NULL DEFAULT '0',
264 `posY` float NOT NULL DEFAULT '0',
265 `posZ` float NOT NULL DEFAULT '3',
266 `rotX` float NOT NULL DEFAULT '0',
267 `rotY` float NOT NULL DEFAULT '0',
268 `rotZ` float NOT NULL DEFAULT '0',
269 `rPosX` float NOT NULL DEFAULT '0',
270 `rPosY` float NOT NULL DEFAULT '0',
271 `rPosZ` float NOT NULL DEFAULT '3',
272 `rRotX` float NOT NULL DEFAULT '0',
273 `rRotY` float NOT NULL DEFAULT '0',
274 `rRotZ` float NOT NULL DEFAULT '0',
275 `respawnInterior` tinyint(3) unsigned NOT NULL DEFAULT '0',
276 `respawnDimension` smallint(5) unsigned NOT NULL DEFAULT '0',
277 `color1` varchar(255) NOT NULL DEFAULT '[ [ 0, 0, 0 ] ]',
278 `color2` varchar(255) NOT NULL DEFAULT '[ [ 0, 0, 0 ] ]',
279 `interior` tinyint(3) unsigned NOT NULL DEFAULT '0',
280 `dimension` smallint(5) unsigned NOT NULL DEFAULT '0',
281 `health` smallint(4) unsigned NOT NULL DEFAULT '1000',
282 `engineState` tinyint(1) unsigned NOT NULL DEFAULT '0',
283 `lightState` tinyint(1) unsigned NOT NULL DEFAULT '0',
284 `handbraked` tinyint(1) unsigned NOT NULL DEFAULT '0',
285 `damageproof` tinyint(1) unsigned NOT NULL DEFAULT '0',
286 `description` varchar(255) NOT NULL DEFAULT '',
287 `tinted` tinyint(1) unsigned NOT NULL DEFAULT '0',
288 `locked` tinyint(1) unsigned NOT NULL DEFAULT '0',
289 `fuel` float unsigned NOT NULL DEFAULT '100',
290 `plateText` varchar(255) NOT NULL DEFAULT 'WTF1337',
291 `jobID` int(10) unsigned NOT NULL,
292 `doorState` varchar(255) NOT NULL DEFAULT '[ [ 0, 0, 0, 0, 0, 0 ] ]',
293 `panelState` varchar(255) NOT NULL DEFAULT '[ [ 0, 0, 0, 0, 0, 0, 0 ] ]',
294 `wheelState` varchar(255) NOT NULL DEFAULT '[ [ 0, 0, 0, 0 ] ]',
295 `windowsDown` tinyint(1) unsigned NOT NULL DEFAULT '0',
296 `manualGearbox` tinyint(1) unsigned NOT NULL DEFAULT '1',
297 `suspension` float NOT NULL DEFAULT '0.05',
298 `disabled` tinyint(1) unsigned NOT NULL DEFAULT '0',
299 `lastused` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
300 `created` varchar(255) NOT NULL DEFAULT '0',
301 PRIMARY KEY (`id`)
302) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
303
304CREATE TABLE IF NOT EXISTS `worlditems` (
305 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
306 `itemID` int(10) unsigned NOT NULL,
307 `value` varchar(1000) NOT NULL,
308 `posX` float NOT NULL DEFAULT '0',
309 `posY` float NOT NULL DEFAULT '0',
310 `posZ` float NOT NULL DEFAULT '0',
311 `rotX` int(11) NOT NULL DEFAULT '0',
312 `rotY` int(11) NOT NULL DEFAULT '0',
313 `rotZ` int(11) NOT NULL DEFAULT '0',
314 `interior` tinyint(3) unsigned NOT NULL DEFAULT '0',
315 `dimension` smallint(5) unsigned NOT NULL DEFAULT '0',
316 `created` varchar(1000) NOT NULL DEFAULT '0',
317 `ringtoneID` tinyint(2) unsigned NOT NULL DEFAULT '1',
318 `messagetoneID` tinyint(2) unsigned NOT NULL DEFAULT '1',
319 `userID` int(11) unsigned NOT NULL DEFAULT '0',
320 `protection` int(10) NOT NULL DEFAULT '0',
321 PRIMARY KEY (`id`)
322) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;