· 6 years ago · Dec 01, 2019, 02:22 PM
1-- phpMyAdmin SQL Dump
2-- version 4.2.12deb2+deb8u2
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Aug 12, 2018 at 02:43 PM
7-- Server version: 10.1.29-MariaDB-1~jessie
8-- PHP Version: 5.6.30-0+deb8u1
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20--Database:`vrpfx`
21--
22
23--------------------------------------------------------
24
25--
26--Table structure for table `vrp_user_vehicles`
27--
28
29CREATE TABLE IF NOT EXISTS `vrp_user_vehicles` (
30`id` int(255) NOT NULL,
31 `user_id` int(11) NOT NULL,
32 `vehicle` varchar(100) NOT NULL,
33 `veh_type` varchar(255) NOT NULL DEFAULT 'default',
34 `vehicle_plate` varchar(255) NOT NULL,
35 `vehicle_colorprimary` varchar(255) DEFAULT NULL,
36 `vehicle_colorsecondary` varchar(255) DEFAULT NULL,
37 `vehicle_pearlescentcolor` varchar(255) DEFAULT NULL,
38 `vehicle_wheelcolor` varchar(255) DEFAULT NULL,
39 `vehicle_plateindex` varchar(255) DEFAULT NULL,
40 `vehicle_neoncolor1` varchar(255) DEFAULT NULL,
41 `vehicle_neoncolor2` varchar(255) DEFAULT NULL,
42 `vehicle_neoncolor3` varchar(255) DEFAULT NULL,
43 `vehicle_windowtint` varchar(255) DEFAULT NULL,
44 `vehicle_wheeltype` varchar(255) DEFAULT NULL,
45 `vehicle_mods0` varchar(255) DEFAULT NULL,
46 `vehicle_mods1` varchar(255) DEFAULT NULL,
47 `vehicle_mods2` varchar(255) DEFAULT NULL,
48 `vehicle_mods3` varchar(255) DEFAULT NULL,
49 `vehicle_mods4` varchar(255) DEFAULT NULL,
50 `vehicle_mods5` varchar(255) DEFAULT NULL,
51 `vehicle_mods6` varchar(255) DEFAULT NULL,
52 `vehicle_mods7` varchar(255) DEFAULT NULL,
53 `vehicle_mods8` varchar(255) DEFAULT NULL,
54 `vehicle_mods9` varchar(255) DEFAULT NULL,
55 `vehicle_mods10` varchar(255) DEFAULT NULL,
56 `vehicle_mods11` varchar(255) DEFAULT NULL,
57 `vehicle_mods12` varchar(255) DEFAULT NULL,
58 `vehicle_mods13` varchar(255) DEFAULT NULL,
59 `vehicle_mods14` varchar(255) DEFAULT NULL,
60 `vehicle_mods15` varchar(255) DEFAULT NULL,
61 `vehicle_mods16` varchar(255) DEFAULT NULL,
62 `vehicle_turbo` varchar(255) NOT NULL DEFAULT 'off',
63 `vehicle_tiresmoke` varchar(255) NOT NULL DEFAULT 'off',
64 `vehicle_xenon` varchar(255) NOT NULL DEFAULT 'off',
65 `vehicle_mods23` varchar(255) DEFAULT NULL,
66 `vehicle_mods24` varchar(255) DEFAULT NULL,
67 `vehicle_neon0` varchar(255) DEFAULT NULL,
68 `vehicle_neon1` varchar(255) DEFAULT NULL,
69 `vehicle_neon2` varchar(255) DEFAULT NULL,
70 `vehicle_neon3` varchar(255) DEFAULT NULL,
71 `vehicle_bulletproof` varchar(255) DEFAULT NULL,
72 `vehicle_smokecolor1` varchar(255) DEFAULT NULL,
73 `vehicle_smokecolor2` varchar(255) DEFAULT NULL,
74 `vehicle_smokecolor3` varchar(255) DEFAULT NULL,
75 `vehicle_modvariation` varchar(255) NOT NULL DEFAULT 'off'
76) ENGINE=InnoDB DEFAULT CHARSET=latin1;
77
78--
79-- Indexes for dumped tables
80--
81
82--
83-- Indexes for table `vrp_user_vehicles`
84--
85ALTER TABLE `vrp_user_vehicles`
86 ADD PRIMARY KEY (`id`);
87
88--
89-- AUTO_INCREMENT for dumped tables
90--
91
92--
93-- AUTO_INCREMENT for table `vrp_user_vehicles`
94--
95ALTER TABLE `vrp_user_vehicles`
96MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;
97/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
98/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
99/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;