NTp3W2aF

1-- Dumping structure for tabel vrpfx.vrp_user_vehicles
2DROP TABLE IF EXISTS `vrp_user_vehicles`;
3CREATE TABLE IF NOT EXISTS `vrp_user_vehicles` (
4  `user_id` int(11) NOT NULL DEFAULT 0,
5  `vehicle` varchar(255) NOT NULL DEFAULT '',
6  `vehicle_name` varchar(255) NOT NULL,
7  `vehicle_plate` varchar(15) NOT NULL,
8  `veh_type` varchar(255) NOT NULL DEFAULT 'default',
9  `vehicle_colorprimary` varchar(255) DEFAULT NULL,
10  `vehicle_colorsecondary` varchar(255) DEFAULT NULL,
11  `vehicle_pearlescentcolor` varchar(255) DEFAULT NULL,
12  `vehicle_wheelcolor` varchar(255) DEFAULT NULL,
13  `vehicle_plateindex` varchar(255) DEFAULT NULL,
14  `vehicle_neoncolor1` varchar(255) DEFAULT NULL,
15  `vehicle_neoncolor2` varchar(255) DEFAULT NULL,
16  `vehicle_neoncolor3` varchar(255) DEFAULT NULL,
17  `vehicle_windowtint` varchar(255) DEFAULT NULL,
18  `vehicle_wheeltype` varchar(255) DEFAULT NULL,
19  `vehicle_mods0` varchar(255) DEFAULT NULL,
20  `vehicle_mods1` varchar(255) DEFAULT NULL,
21  `vehicle_mods2` varchar(255) DEFAULT NULL,
22  `vehicle_mods3` varchar(255) DEFAULT NULL,
23  `vehicle_mods4` varchar(255) DEFAULT NULL,
24  `vehicle_mods5` varchar(255) DEFAULT NULL,
25  `vehicle_mods6` varchar(255) DEFAULT NULL,
26  `vehicle_mods7` varchar(255) DEFAULT NULL,
27  `vehicle_mods8` varchar(255) DEFAULT NULL,
28  `vehicle_mods9` varchar(255) DEFAULT NULL,
29  `vehicle_mods10` varchar(255) DEFAULT NULL,
30  `vehicle_mods11` varchar(255) DEFAULT NULL,
31  `vehicle_mods12` varchar(255) DEFAULT NULL,
32  `vehicle_mods13` varchar(255) DEFAULT NULL,
33  `vehicle_mods14` varchar(255) DEFAULT NULL,
34  `vehicle_mods15` varchar(255) DEFAULT NULL,
35  `vehicle_mods16` varchar(255) DEFAULT NULL,
36  `vehicle_turbo` varchar(255) NOT NULL DEFAULT 'off',
37  `vehicle_tiresmoke` varchar(255) NOT NULL DEFAULT 'off',
38  `vehicle_xenon` varchar(255) NOT NULL DEFAULT 'off',
39  `vehicle_mods23` varchar(255) DEFAULT NULL,
40  `vehicle_mods24` varchar(255) DEFAULT NULL,
41  `vehicle_neon0` varchar(255) DEFAULT NULL,
42  `vehicle_neon1` varchar(255) DEFAULT NULL,
43  `vehicle_neon2` varchar(255) DEFAULT NULL,
44  `vehicle_neon3` varchar(255) DEFAULT NULL,
45  `vehicle_bulletproof` varchar(255) DEFAULT NULL,
46  `vehicle_smokecolor1` varchar(255) DEFAULT NULL,
47  `vehicle_smokecolor2` varchar(255) DEFAULT NULL,
48  `vehicle_smokecolor3` varchar(255) DEFAULT NULL,
49  `vehicle_modvariation` varchar(255) NOT NULL DEFAULT 'off',
50  `vehicle_price` int(60) NOT NULL DEFAULT 0,
51  `vehicle_damage` varchar(255) NOT NULL DEFAULT '',
52  `vehicle_impound` varchar(255) NOT NULL DEFAULT '',
53  `vehicle_livery` varchar(255) DEFAULT NULL,
54  PRIMARY KEY (`user_id`,`vehicle_plate`,`vehicle`),
55  CONSTRAINT `fk_user_vehicles_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
56) ENGINE=InnoDB DEFAULT CHARSET=utf8;