· 5 years ago · Feb 23, 2020, 04:32 PM
1CREATE TABLE IF NOT EXISTS `vrp_user_vehicles` (
2 `user_id` int(11) NOT NULL DEFAULT '0',
3 `vehicle` varchar(255) NOT NULL DEFAULT '',
4 `vehicle_name` varchar(255) NOT NULL,
5 `vehicle_plate` varchar(15) NOT NULL,
6 `veh_type` varchar(255) NOT NULL DEFAULT 'default',
7 `vehicle_colorprimary` varchar(255) DEFAULT NULL,
8 `vehicle_colorsecondary` varchar(255) DEFAULT NULL,
9 `vehicle_pearlescentcolor` varchar(255) DEFAULT NULL,
10 `vehicle_wheelcolor` varchar(255) DEFAULT NULL,
11 `vehicle_plateindex` varchar(255) DEFAULT NULL,
12 `vehicle_neoncolor1` varchar(255) DEFAULT NULL,
13 `vehicle_neoncolor2` varchar(255) DEFAULT NULL,
14 `vehicle_neoncolor3` varchar(255) DEFAULT NULL,
15 `vehicle_windowtint` varchar(255) DEFAULT NULL,
16 `vehicle_wheeltype` varchar(255) DEFAULT NULL,
17 `vehicle_mods0` varchar(255) DEFAULT NULL,
18 `vehicle_mods1` varchar(255) DEFAULT NULL,
19 `vehicle_mods2` varchar(255) DEFAULT NULL,
20 `vehicle_mods3` varchar(255) DEFAULT NULL,
21 `vehicle_mods4` varchar(255) DEFAULT NULL,
22 `vehicle_mods5` varchar(255) DEFAULT NULL,
23 `vehicle_mods6` varchar(255) DEFAULT NULL,
24 `vehicle_mods7` varchar(255) DEFAULT NULL,
25 `vehicle_mods8` varchar(255) DEFAULT NULL,
26 `vehicle_mods9` varchar(255) DEFAULT NULL,
27 `vehicle_mods10` varchar(255) DEFAULT NULL,
28 `vehicle_mods11` varchar(255) DEFAULT NULL,
29 `vehicle_mods12` varchar(255) DEFAULT NULL,
30 `vehicle_mods13` varchar(255) DEFAULT NULL,
31 `vehicle_mods14` varchar(255) DEFAULT NULL,
32 `vehicle_mods15` varchar(255) DEFAULT NULL,
33 `vehicle_mods16` varchar(255) DEFAULT NULL,
34 `vehicle_turbo` varchar(255) NOT NULL DEFAULT 'off',
35 `vehicle_tiresmoke` varchar(255) NOT NULL DEFAULT 'off',
36 `vehicle_xenon` varchar(255) NOT NULL DEFAULT 'off',
37 `vehicle_mods23` varchar(255) DEFAULT NULL,
38 `vehicle_mods24` varchar(255) DEFAULT NULL,
39 `vehicle_neon0` varchar(255) DEFAULT NULL,
40 `vehicle_neon1` varchar(255) DEFAULT NULL,
41 `vehicle_neon2` varchar(255) DEFAULT NULL,
42 `vehicle_neon3` varchar(255) DEFAULT NULL,
43 `vehicle_bulletproof` varchar(255) DEFAULT NULL,
44 `vehicle_smokecolor1` varchar(255) DEFAULT NULL,
45 `vehicle_smokecolor2` varchar(255) DEFAULT NULL,
46 `vehicle_smokecolor3` varchar(255) DEFAULT NULL,
47 `vehicle_modvariation` varchar(255) NOT NULL DEFAULT 'off',
48 `vehicle_price` int(60) NOT NULL DEFAULT '0',
49 PRIMARY KEY (`user_id`,`vehicle_plate`,`vehicle`) USING BTREE
50) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;