· 6 years ago · Sep 15, 2019, 12:10 PM
1-- --------------------------------------------------------
2-- Vært: 127.0.0.1
3-- Server-version: 10.3.16-MariaDB - mariadb.org binary distribution
4-- ServerOS: Win64
5-- HeidiSQL Version: 10.2.0.5599
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14
15-- Dumping database structure for server1
16CREATE DATABASE IF NOT EXISTS `server1` /*!40100 DEFAULT CHARACTER SET latin1 */;
17USE `server1`;
18
19-- Dumping structure for tabel server1.jsfour_cardetails
20CREATE TABLE IF NOT EXISTS `jsfour_cardetails` (
21 `pk` int(11) NOT NULL AUTO_INCREMENT,
22 `plate` varchar(255) DEFAULT NULL,
23 `owner` varchar(255) DEFAULT NULL,
24 `incident` varchar(255) NOT NULL DEFAULT '{}',
25 `inspected` varchar(255) DEFAULT NULL,
26 `identifier` varchar(255) DEFAULT NULL,
27 PRIMARY KEY (`pk`)
28) ENGINE=InnoDB DEFAULT CHARSET=latin1;
29
30-- Data exporting was unselected.
31
32-- Dumping structure for tabel server1.jsfour_efterlysningar
33CREATE TABLE IF NOT EXISTS `jsfour_efterlysningar` (
34 `pk` int(11) NOT NULL AUTO_INCREMENT,
35 `wanted` varchar(255) DEFAULT NULL,
36 `dob` varchar(255) DEFAULT NULL,
37 `crime` varchar(255) DEFAULT NULL,
38 `uploader` varchar(255) DEFAULT NULL,
39 `date` varchar(255) DEFAULT NULL,
40 `incident` varchar(255) DEFAULT NULL,
41 PRIMARY KEY (`pk`)
42) ENGINE=InnoDB DEFAULT CHARSET=latin1;
43
44-- Data exporting was unselected.
45
46-- Dumping structure for tabel server1.jsfour_incidents
47CREATE TABLE IF NOT EXISTS `jsfour_incidents` (
48 `pk` int(11) NOT NULL AUTO_INCREMENT,
49 `number` varchar(255) DEFAULT NULL,
50 `text` varchar(255) DEFAULT NULL,
51 `uploader` varchar(255) DEFAULT NULL,
52 `date` varchar(255) DEFAULT NULL,
53 PRIMARY KEY (`pk`)
54) ENGINE=InnoDB DEFAULT CHARSET=latin1;
55
56-- Data exporting was unselected.
57
58-- Dumping structure for tabel server1.jsfour_logs
59CREATE TABLE IF NOT EXISTS `jsfour_logs` (
60 `pk` int(11) NOT NULL AUTO_INCREMENT,
61 `type` varchar(255) DEFAULT NULL,
62 `remover` varchar(255) DEFAULT NULL,
63 `wanted` varchar(255) DEFAULT NULL,
64 PRIMARY KEY (`pk`)
65) ENGINE=InnoDB DEFAULT CHARSET=latin1;
66
67-- Data exporting was unselected.
68
69-- Dumping structure for tabel server1.phone_app_chat
70CREATE TABLE IF NOT EXISTS `phone_app_chat` (
71 `id` int(11) NOT NULL AUTO_INCREMENT,
72 `userid` int(11) NOT NULL,
73 `channel` varchar(20) NOT NULL,
74 `message` varchar(255) NOT NULL,
75 `time` timestamp NOT NULL DEFAULT current_timestamp(),
76 PRIMARY KEY (`id`)
77) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
78
79-- Data exporting was unselected.
80
81-- Dumping structure for tabel server1.phone_calls
82CREATE TABLE IF NOT EXISTS `phone_calls` (
83 `id` int(11) NOT NULL AUTO_INCREMENT,
84 `owner` varchar(20) NOT NULL COMMENT 'Num tel proprio',
85 `num` varchar(20) NOT NULL COMMENT 'Num reférence du contact',
86 `incoming` int(11) NOT NULL COMMENT 'Défini si on est à l''origine de l''appels',
87 `time` timestamp NOT NULL DEFAULT current_timestamp(),
88 `accepts` int(11) NOT NULL COMMENT 'Appels accepter ou pas',
89 PRIMARY KEY (`id`)
90) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;
91
92-- Data exporting was unselected.
93
94-- Dumping structure for tabel server1.phone_messages
95CREATE TABLE IF NOT EXISTS `phone_messages` (
96 `id` int(11) NOT NULL AUTO_INCREMENT,
97 `transmitter` varchar(20) NOT NULL,
98 `receiver` varchar(20) NOT NULL,
99 `message` varchar(255) NOT NULL DEFAULT '0',
100 `time` timestamp NOT NULL DEFAULT current_timestamp(),
101 `isRead` int(11) NOT NULL DEFAULT 0,
102 `owner` int(11) NOT NULL DEFAULT 0,
103 PRIMARY KEY (`id`)
104) ENGINE=MyISAM AUTO_INCREMENT=380 DEFAULT CHARSET=utf8;
105
106-- Data exporting was unselected.
107
108-- Dumping structure for tabel server1.phone_twitter
109CREATE TABLE IF NOT EXISTS `phone_twitter` (
110 `id` int(11) NOT NULL AUTO_INCREMENT,
111 `userid` int(11) NOT NULL,
112 `name` varchar(300) NOT NULL,
113 `message` varchar(300) NOT NULL,
114 `time` varchar(30) NOT NULL,
115 PRIMARY KEY (`id`)
116) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=latin1;
117
118-- Data exporting was unselected.
119
120-- Dumping structure for tabel server1.phone_users_contacts
121CREATE TABLE IF NOT EXISTS `phone_users_contacts` (
122 `id` int(11) NOT NULL AUTO_INCREMENT,
123 `number` varchar(10) CHARACTER SET utf8mb4 DEFAULT NULL,
124 `display` varchar(64) CHARACTER SET utf8mb4 NOT NULL DEFAULT '-1',
125 `identifier` varchar(60) CHARACTER SET utf8mb4 DEFAULT NULL,
126 PRIMARY KEY (`id`)
127) ENGINE=MyISAM DEFAULT CHARSET=utf8;
128
129-- Data exporting was unselected.
130
131-- Dumping structure for tabel server1.users
132CREATE TABLE IF NOT EXISTS `users` (
133 `identifier` int(11) DEFAULT NULL,
134 `group` varchar(50) DEFAULT NULL,
135 `oldphone` varchar(50) DEFAULT NULL,
136 `phone_number` varchar(50) DEFAULT NULL
137) ENGINE=InnoDB DEFAULT CHARSET=latin1;
138
139-- Data exporting was unselected.
140
141-- Dumping structure for tabel server1.vehicles
142CREATE TABLE IF NOT EXISTS `vehicles` (
143 `id` int(12) NOT NULL AUTO_INCREMENT,
144 `side` varchar(16) NOT NULL,
145 `classname` varchar(64) NOT NULL,
146 `type` varchar(16) NOT NULL,
147 `pid` varchar(32) NOT NULL,
148 `alive` tinyint(1) NOT NULL DEFAULT 1,
149 `blacklist` tinyint(1) NOT NULL DEFAULT 0,
150 `active` tinyint(1) NOT NULL DEFAULT 0,
151 `plate` int(20) NOT NULL,
152 `color` int(20) NOT NULL,
153 `inventory` text NOT NULL,
154 `gear` text NOT NULL,
155 `fuel` double NOT NULL DEFAULT 1,
156 `damage` varchar(256) NOT NULL,
157 `insert_time` timestamp NOT NULL DEFAULT current_timestamp(),
158 PRIMARY KEY (`id`) USING BTREE,
159 KEY `side` (`side`) USING BTREE,
160 KEY `pid` (`pid`) USING BTREE,
161 KEY `type` (`type`) USING BTREE
162) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
163
164-- Data exporting was unselected.
165
166-- Dumping structure for tabel server1.vrp_cardealer
167CREATE TABLE IF NOT EXISTS `vrp_cardealer` (
168 `cardealer_id` int(11) NOT NULL AUTO_INCREMENT,
169 `cardealer_seller` int(11) NOT NULL,
170 `cardealer_sellername` varchar(200) NOT NULL,
171 `cardealer_vehicle` varchar(200) NOT NULL,
172 `cardealer_vehiclename` varchar(200) NOT NULL,
173 `cardealer_vehicledesc` varchar(200) NOT NULL,
174 `cardealer_price` int(11) NOT NULL,
175 `cardealer_img` varchar(600) NOT NULL,
176 `cardealer_soldtoid` int(11) DEFAULT 0,
177 `cardealer_solddate` timestamp NULL DEFAULT NULL,
178 `cardealer_accepted` tinyint(1) NOT NULL DEFAULT 1,
179 `cardealer_deleted` tinyint(1) NOT NULL DEFAULT 0,
180 `cardealer_created` timestamp NOT NULL DEFAULT current_timestamp(),
181 PRIMARY KEY (`cardealer_id`) USING BTREE,
182 KEY `cardealer_seller` (`cardealer_seller`) USING BTREE
183) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
184
185-- Data exporting was unselected.
186
187-- Dumping structure for tabel server1.vrp_srv_data
188CREATE TABLE IF NOT EXISTS `vrp_srv_data` (
189 `dkey` varchar(100) NOT NULL,
190 `dvalue` text DEFAULT NULL,
191 PRIMARY KEY (`dkey`)
192) ENGINE=InnoDB DEFAULT CHARSET=latin1;
193
194-- Data exporting was unselected.
195
196-- Dumping structure for tabel server1.vrp_users
197CREATE TABLE IF NOT EXISTS `vrp_users` (
198 `id` int(11) NOT NULL AUTO_INCREMENT,
199 `last_login` varchar(100) DEFAULT NULL,
200 `last_date` text CHARACTER SET utf8 COLLATE utf8_danish_ci DEFAULT NULL,
201 `whitelisted` tinyint(1) DEFAULT NULL,
202 `banned` tinyint(1) DEFAULT NULL,
203 `reason` text CHARACTER SET utf8 DEFAULT NULL,
204 `DmvTest` int(11) NOT NULL DEFAULT 1,
205 `warnings` int(11) DEFAULT 0,
206 `bankPin` int(11) DEFAULT 0,
207 `diedleft` int(11) DEFAULT 0,
208 `brugernavn` varchar(50) CHARACTER SET utf8 COLLATE utf8_danish_ci DEFAULT NULL,
209 `kode` varchar(50) CHARACTER SET utf8 COLLATE utf8_danish_ci DEFAULT NULL,
210 `_updated` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
211 PRIMARY KEY (`id`)
212) ENGINE=InnoDB DEFAULT CHARSET=latin1;
213
214-- Data exporting was unselected.
215
216-- Dumping structure for tabel server1.vrp_user_business
217CREATE TABLE IF NOT EXISTS `vrp_user_business` (
218 `user_id` int(11) NOT NULL,
219 `name` varchar(30) DEFAULT NULL,
220 `description` text DEFAULT NULL,
221 `capital` int(11) DEFAULT NULL,
222 `laundered` int(11) DEFAULT NULL,
223 `reset_timestamp` int(11) DEFAULT NULL,
224 PRIMARY KEY (`user_id`),
225 CONSTRAINT `fk_user_business_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
226) ENGINE=InnoDB DEFAULT CHARSET=latin1;
227
228-- Data exporting was unselected.
229
230-- Dumping structure for tabel server1.vrp_user_data
231CREATE TABLE IF NOT EXISTS `vrp_user_data` (
232 `user_id` int(11) NOT NULL,
233 `dkey` varchar(100) NOT NULL,
234 `dvalue` text DEFAULT NULL,
235 PRIMARY KEY (`user_id`,`dkey`),
236 CONSTRAINT `fk_user_data_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
237) ENGINE=InnoDB DEFAULT CHARSET=latin1;
238
239-- Data exporting was unselected.
240
241-- Dumping structure for tabel server1.vrp_user_homes
242CREATE TABLE IF NOT EXISTS `vrp_user_homes` (
243 `user_id` int(11) NOT NULL,
244 `home` varchar(100) DEFAULT NULL,
245 `number` int(11) DEFAULT NULL,
246 PRIMARY KEY (`user_id`),
247 UNIQUE KEY `home` (`home`,`number`),
248 CONSTRAINT `fk_user_homes_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
249) ENGINE=InnoDB DEFAULT CHARSET=latin1;
250
251-- Data exporting was unselected.
252
253-- Dumping structure for tabel server1.vrp_user_identities
254CREATE TABLE IF NOT EXISTS `vrp_user_identities` (
255 `user_id` int(11) NOT NULL,
256 `registration` varchar(20) DEFAULT NULL,
257 `phone` varchar(20) DEFAULT NULL,
258 `firstname` varchar(50) DEFAULT NULL,
259 `name` varchar(50) DEFAULT NULL,
260 `age` int(11) DEFAULT NULL,
261 PRIMARY KEY (`user_id`),
262 KEY `registration` (`registration`),
263 KEY `phone` (`phone`),
264 CONSTRAINT `fk_user_identities_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
265) ENGINE=InnoDB DEFAULT CHARSET=latin1;
266
267-- Data exporting was unselected.
268
269-- Dumping structure for tabel server1.vrp_user_ids
270CREATE TABLE IF NOT EXISTS `vrp_user_ids` (
271 `identifier` varchar(100) NOT NULL,
272 `user_id` int(11) DEFAULT NULL,
273 PRIMARY KEY (`identifier`),
274 KEY `fk_user_ids_users` (`user_id`),
275 CONSTRAINT `fk_user_ids_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
276) ENGINE=InnoDB DEFAULT CHARSET=latin1;
277
278-- Data exporting was unselected.
279
280-- Dumping structure for tabel server1.vrp_user_moneys
281CREATE TABLE IF NOT EXISTS `vrp_user_moneys` (
282 `user_id` int(11) NOT NULL,
283 `wallet` int(11) DEFAULT NULL,
284 `bank` int(11) DEFAULT NULL,
285 PRIMARY KEY (`user_id`),
286 CONSTRAINT `fk_user_moneys_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
287) ENGINE=InnoDB DEFAULT CHARSET=latin1;
288
289-- Data exporting was unselected.
290
291-- Dumping structure for tabel server1.vrp_user_vehicles
292CREATE TABLE IF NOT EXISTS `vrp_user_vehicles` (
293 `user_id` int(11) NOT NULL,
294 `vehicle_name` varchar(255) NOT NULL,
295 `vehicle_plate` varchar(15) NOT NULL,
296 `veh_type` varchar(255) NOT NULL DEFAULT 'default',
297 `vehicle_colorprimary` varchar(255) DEFAULT NULL,
298 `vehicle_colorsecondary` varchar(255) DEFAULT NULL,
299 `vehicle_pearlescentcolor` varchar(255) DEFAULT NULL,
300 `vehicle_wheelcolor` varchar(255) DEFAULT NULL,
301 `vehicle_plateindex` varchar(255) DEFAULT NULL,
302 `vehicle_neoncolor1` varchar(255) DEFAULT NULL,
303 `vehicle_neoncolor2` varchar(255) DEFAULT NULL,
304 `vehicle_neoncolor3` varchar(255) NOT NULL,
305 `vehicle_windowtint` varchar(255) DEFAULT NULL,
306 `vehicle_wheeltype` varchar(255) DEFAULT NULL,
307 `vehicle_mods0` varchar(255) DEFAULT NULL,
308 `vehicle_mods1` varchar(255) DEFAULT NULL,
309 `vehicle_mods2` varchar(255) DEFAULT NULL,
310 `vehicle_mods3` varchar(255) DEFAULT NULL,
311 `vehicle_mods4` varchar(255) DEFAULT NULL,
312 `vehicle_mods5` varchar(255) DEFAULT NULL,
313 `vehicle_mods6` varchar(255) DEFAULT NULL,
314 `vehicle_mods7` varchar(255) DEFAULT NULL,
315 `vehicle_mods8` varchar(255) DEFAULT NULL,
316 `vehicle_mods9` varchar(255) DEFAULT NULL,
317 `vehicle_mods10` varchar(255) DEFAULT NULL,
318 `vehicle_mods11` varchar(255) DEFAULT NULL,
319 `vehicle_mods12` varchar(255) DEFAULT NULL,
320 `vehicle_mods13` varchar(255) DEFAULT NULL,
321 `vehicle_mods14` varchar(255) DEFAULT NULL,
322 `vehicle_mods15` varchar(255) DEFAULT NULL,
323 `vehicle_mods16` varchar(255) DEFAULT NULL,
324 `vehicle_turbo` varchar(255) NOT NULL DEFAULT 'off',
325 `vehicle_tiresmoke` varchar(255) NOT NULL DEFAULT 'off',
326 `vehicle_xenon` varchar(255) NOT NULL DEFAULT 'off',
327 `vehicle_mods23` varchar(255) DEFAULT NULL,
328 `vehicle_mods24` varchar(255) DEFAULT NULL,
329 `vehicle_neon0` varchar(255) DEFAULT NULL,
330 `vehicle_neon1` varchar(255) DEFAULT NULL,
331 `vehicle_neon2` varchar(255) DEFAULT NULL,
332 `vehicle_neon3` varchar(255) DEFAULT NULL,
333 `vehicle_bulletproof` varchar(255) DEFAULT NULL,
334 `vehicle_smokecolor1` varchar(255) DEFAULT NULL,
335 `vehicle_smokecolor2` varchar(255) DEFAULT NULL,
336 `vehicle_smokecolor3` varchar(255) DEFAULT NULL,
337 `vehicle_modvariation` varchar(255) NOT NULL DEFAULT 'off',
338 `vehicle_price` int(60) NOT NULL DEFAULT 0,
339 `vehicle` varchar(255) NOT NULL,
340 PRIMARY KEY (`user_id`,`vehicle`),
341 CONSTRAINT `fk_user_vehicles_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
342) ENGINE=InnoDB DEFAULT CHARSET=latin1;
343
344-- Data exporting was unselected.
345
346-- Dumping structure for tabel server1.vrp_wanted
347CREATE TABLE IF NOT EXISTS `vrp_wanted` (
348 `user_id` int(11) DEFAULT NULL,
349 `wantedreason` varchar(100) DEFAULT NULL,
350 `wantedby` int(11) DEFAULT NULL,
351 `timestamp` int(11) DEFAULT NULL,
352 `count` int(11) DEFAULT NULL
353) ENGINE=InnoDB DEFAULT CHARSET=latin1;
354
355-- Data exporting was unselected.
356
357-- Dumping structure for tabel server1.wanted
358CREATE TABLE IF NOT EXISTS `wanted` (
359 `wantedID` varchar(64) NOT NULL,
360 `wantedName` varchar(32) NOT NULL,
361 `wantedCrimes` text NOT NULL,
362 `wantedBounty` int(100) NOT NULL,
363 `active` tinyint(1) NOT NULL DEFAULT 0,
364 `insert_time` timestamp NOT NULL DEFAULT current_timestamp(),
365 PRIMARY KEY (`wantedID`) USING BTREE
366) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
367
368-- Data exporting was unselected.
369
370/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
371/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
372/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;