· 6 years ago · Sep 03, 2019, 03:54 PM
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
48
49
50CREATE TABLE IF NOT EXISTS `stocks` (
51 `stockname` varchar(100) NOT NULL,
52 `pris` int(11) DEFAULT NULL,
53 `timestamp` int(11) DEFAULT NULL,
54 PRIMARY KEY (`stockname`)
55) ENGINE=InnoDB DEFAULT CHARSET=latin1;
56
57CREATE TABLE IF NOT EXISTS `users` (
58 `identifier` int(11) DEFAULT NULL,
59 `group` varchar(50) DEFAULT NULL,
60 `oldphone` varchar(50) DEFAULT NULL,
61 `phone_number` varchar(50) DEFAULT NULL
62) ENGINE=InnoDB DEFAULT CHARSET=latin1;
63
64CREATE TABLE IF NOT EXISTS `vehicles` (
65 `id` int(12) NOT NULL AUTO_INCREMENT,
66 `side` varchar(16) NOT NULL,
67 `classname` varchar(64) NOT NULL,
68 `type` varchar(16) NOT NULL,
69 `pid` varchar(32) NOT NULL,
70 `alive` tinyint(1) NOT NULL DEFAULT '1',
71 `blacklist` tinyint(1) NOT NULL DEFAULT '0',
72 `active` tinyint(1) NOT NULL DEFAULT '0',
73 `plate` int(20) NOT NULL,
74 `color` int(20) NOT NULL,
75 `inventory` text NOT NULL,
76 `gear` text NOT NULL,
77 `fuel` double NOT NULL DEFAULT '1',
78 `damage` varchar(256) NOT NULL,
79 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
80 PRIMARY KEY (`id`) USING BTREE,
81 KEY `side` (`side`) USING BTREE,
82 KEY `pid` (`pid`) USING BTREE,
83 KEY `type` (`type`) USING BTREE
84) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
85
86CREATE TABLE IF NOT EXISTS `vrp_cardealer` (
87 `cardealer_id` int(11) NOT NULL AUTO_INCREMENT,
88 `cardealer_seller` int(11) NOT NULL,
89 `cardealer_sellername` varchar(200) NOT NULL,
90 `cardealer_vehicle` varchar(200) NOT NULL,
91 `cardealer_vehiclename` varchar(200) NOT NULL,
92 `cardealer_vehicledesc` varchar(200) NOT NULL,
93 `cardealer_price` int(11) NOT NULL,
94 `cardealer_img` varchar(600) NOT NULL,
95 `cardealer_soldtoid` int(11) DEFAULT '0',
96 `cardealer_solddate` timestamp NULL DEFAULT NULL,
97 `cardealer_accepted` tinyint(1) NOT NULL DEFAULT '1',
98 `cardealer_deleted` tinyint(1) NOT NULL DEFAULT '0',
99 `cardealer_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
100 PRIMARY KEY (`cardealer_id`) USING BTREE,
101 KEY `cardealer_seller` (`cardealer_seller`) USING BTREE
102) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
103
104CREATE TABLE IF NOT EXISTS `vrp_eboks` (
105 `user_id` int(11) DEFAULT NULL,
106 `type` varchar(100) DEFAULT NULL,
107 `pris` int(11) DEFAULT NULL,
108 `timestamp` int(11) DEFAULT NULL
109) ENGINE=InnoDB DEFAULT CHARSET=latin1;
110
111CREATE TABLE IF NOT EXISTS `vrp_srv_data` (
112 `dkey` varchar(255) NOT NULL DEFAULT '',
113 `dvalue` text,
114 PRIMARY KEY (`dkey`) USING BTREE
115) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
116
117CREATE TABLE IF NOT EXISTS `vrp_stocks` (
118 `user_id` int(11) NOT NULL,
119 `stockname` varchar(100) DEFAULT NULL,
120 `antal` int(11) DEFAULT NULL,
121 `kobttil` int(11) DEFAULT NULL,
122 PRIMARY KEY (`user_id`)
123) ENGINE=InnoDB DEFAULT CHARSET=latin1;
124
125CREATE TABLE IF NOT EXISTS `vrp_users` (
126 `id` int(11) NOT NULL AUTO_INCREMENT,
127 `last_login` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
128 `last_date` text COLLATE utf8_danish_ci,
129 `whitelisted` tinyint(1) DEFAULT '0',
130 `banned` tinyint(1) DEFAULT '0',
131 `reason` text CHARACTER SET utf8,
132 `DmvTest` int(11) NOT NULL DEFAULT '1',
133 `_updated` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
134 `warnings` int(11) DEFAULT '0',
135 `bankPin` int(11) DEFAULT '0',
136 `diedleft` int(11) DEFAULT '0',
137 `brugernavn` varchar(50) COLLATE utf8_danish_ci DEFAULT NULL,
138 `kode` varchar(50) COLLATE utf8_danish_ci DEFAULT NULL,
139 PRIMARY KEY (`id`) USING BTREE
140) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 COLLATE=utf8_danish_ci ROW_FORMAT=DYNAMIC;
141
142CREATE TABLE IF NOT EXISTS `vrp_user_business` (
143 `user_id` int(11) NOT NULL DEFAULT '0',
144 `name` varchar(30) DEFAULT NULL,
145 `description` text,
146 `capital` int(11) DEFAULT '0',
147 `laundered` int(11) DEFAULT '0',
148 `reset_timestamp` int(11) DEFAULT '0',
149 PRIMARY KEY (`user_id`) USING BTREE
150) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
151
152CREATE TABLE IF NOT EXISTS `vrp_user_data` (
153 `user_id` int(11) NOT NULL DEFAULT '0',
154 `dkey` varchar(255) NOT NULL DEFAULT '',
155 `dvalue` text,
156 PRIMARY KEY (`user_id`,`dkey`) USING BTREE
157) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
158
159CREATE TABLE IF NOT EXISTS `vrp_user_homes` (
160 `id` int(11) NOT NULL AUTO_INCREMENT,
161 `user_id` int(11) NOT NULL DEFAULT '0',
162 `home` varchar(255) DEFAULT NULL,
163 `number` int(11) DEFAULT '0',
164 PRIMARY KEY (`id`) USING BTREE,
165 KEY `home` (`home`,`number`) USING BTREE
166) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
167
168CREATE TABLE IF NOT EXISTS `vrp_user_identities` (
169 `user_id` int(11) NOT NULL DEFAULT '0',
170 `registration` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
171 `phone` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
172 `firstname` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
173 `name` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
174 `age` int(11) DEFAULT '0',
175 PRIMARY KEY (`user_id`) USING BTREE,
176 UNIQUE KEY `registration_UNIQUE` (`registration`) USING BTREE,
177 UNIQUE KEY `phone_UNIQUE` (`phone`) USING BTREE,
178 KEY `registration` (`registration`) USING BTREE,
179 KEY `phone` (`phone`) USING BTREE
180) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_danish_ci ROW_FORMAT=DYNAMIC;
181
182CREATE TABLE IF NOT EXISTS `vrp_user_ids` (
183 `identifier` varchar(255) NOT NULL DEFAULT '',
184 `user_id` int(11) DEFAULT '0',
185 PRIMARY KEY (`identifier`) USING BTREE,
186 KEY `fk_user_ids_users` (`user_id`) USING BTREE
187) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
188
189CREATE TABLE IF NOT EXISTS `vrp_user_moneys` (
190 `user_id` int(11) NOT NULL DEFAULT '0',
191 `wallet` bigint(20) DEFAULT '0',
192 `bank` bigint(20) DEFAULT '0',
193 PRIMARY KEY (`user_id`) USING BTREE
194) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
195
196CREATE TABLE IF NOT EXISTS `vrp_user_vehicles` (
197 `user_id` int(11) NOT NULL DEFAULT '0',
198 `vehicle` varchar(255) NOT NULL DEFAULT '',
199 `vehicle_name` varchar(255) NOT NULL,
200 `vehicle_plate` varchar(15) NOT NULL,
201 `veh_type` varchar(255) NOT NULL DEFAULT 'default',
202 `vehicle_colorprimary` varchar(255) DEFAULT NULL,
203 `vehicle_colorsecondary` varchar(255) DEFAULT NULL,
204 `vehicle_pearlescentcolor` varchar(255) DEFAULT NULL,
205 `vehicle_wheelcolor` varchar(255) DEFAULT NULL,
206 `vehicle_plateindex` varchar(255) DEFAULT NULL,
207 `vehicle_neoncolor1` varchar(255) DEFAULT NULL,
208 `vehicle_neoncolor2` varchar(255) DEFAULT NULL,
209 `vehicle_neoncolor3` varchar(255) DEFAULT NULL,
210 `vehicle_windowtint` varchar(255) DEFAULT NULL,
211 `vehicle_wheeltype` varchar(255) DEFAULT NULL,
212 `vehicle_mods0` varchar(255) DEFAULT NULL,
213 `vehicle_mods1` varchar(255) DEFAULT NULL,
214 `vehicle_mods2` varchar(255) DEFAULT NULL,
215 `vehicle_mods3` varchar(255) DEFAULT NULL,
216 `vehicle_mods4` varchar(255) DEFAULT NULL,
217 `vehicle_mods5` varchar(255) DEFAULT NULL,
218 `vehicle_mods6` varchar(255) DEFAULT NULL,
219 `vehicle_mods7` varchar(255) DEFAULT NULL,
220 `vehicle_mods8` varchar(255) DEFAULT NULL,
221 `vehicle_mods9` varchar(255) DEFAULT NULL,
222 `vehicle_mods10` varchar(255) DEFAULT NULL,
223 `vehicle_mods11` varchar(255) DEFAULT NULL,
224 `vehicle_mods12` varchar(255) DEFAULT NULL,
225 `vehicle_mods13` varchar(255) DEFAULT NULL,
226 `vehicle_mods14` varchar(255) DEFAULT NULL,
227 `vehicle_mods15` varchar(255) DEFAULT NULL,
228 `vehicle_mods16` varchar(255) DEFAULT NULL,
229 `vehicle_turbo` varchar(255) NOT NULL DEFAULT 'off',
230 `vehicle_tiresmoke` varchar(255) NOT NULL DEFAULT 'off',
231 `vehicle_xenon` varchar(255) NOT NULL DEFAULT 'off',
232 `vehicle_mods23` varchar(255) DEFAULT NULL,
233 `vehicle_mods24` varchar(255) DEFAULT NULL,
234 `vehicle_neon0` varchar(255) DEFAULT NULL,
235 `vehicle_neon1` varchar(255) DEFAULT NULL,
236 `vehicle_neon2` varchar(255) DEFAULT NULL,
237 `vehicle_neon3` varchar(255) DEFAULT NULL,
238 `vehicle_bulletproof` varchar(255) DEFAULT NULL,
239 `vehicle_smokecolor1` varchar(255) DEFAULT NULL,
240 `vehicle_smokecolor2` varchar(255) DEFAULT NULL,
241 `vehicle_smokecolor3` varchar(255) DEFAULT NULL,
242 `vehicle_modvariation` varchar(255) NOT NULL DEFAULT 'off',
243 `vehicle_price` int(60) NOT NULL DEFAULT '0',
244 PRIMARY KEY (`user_id`,`vehicle_plate`,`vehicle`) USING BTREE
245) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
246
247CREATE TABLE IF NOT EXISTS `vrp_wanted` (
248 `user_id` int(11) DEFAULT NULL,
249 `wantedreason` varchar(100) DEFAULT NULL,
250 `wantedby` int(11) DEFAULT NULL,
251 `timestamp` int(11) DEFAULT NULL,
252 `count` int(11) DEFAULT NULL
253) ENGINE=InnoDB DEFAULT CHARSET=latin1;
254
255CREATE TABLE IF NOT EXISTS `wanted` (
256 `wantedID` varchar(64) NOT NULL,
257 `wantedName` varchar(32) NOT NULL,
258 `wantedCrimes` text NOT NULL,
259 `wantedBounty` int(100) NOT NULL,
260 `active` tinyint(1) NOT NULL DEFAULT '0',
261 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
262 PRIMARY KEY (`wantedID`) USING BTREE
263) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
264
265
266ALTER TABLE `vrp_user_business`
267 ADD CONSTRAINT `fk_user_business_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE;
268
269ALTER TABLE `vrp_user_data`
270 ADD CONSTRAINT `fk_user_data_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE;
271
272ALTER TABLE `vrp_user_identities`
273 ADD CONSTRAINT `fk_user_identities_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE;
274
275ALTER TABLE `vrp_user_ids`
276 ADD CONSTRAINT `fk_user_ids_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE;
277
278ALTER TABLE `vrp_user_moneys`
279 ADD CONSTRAINT `fk_user_moneys_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE;
280
281ALTER TABLE `vrp_user_vehicles`
282 ADD CONSTRAINT `fk_user_vehicles_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE;
283
284/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
285/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
286/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;