p1wUn0wN

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