· 6 years ago · Aug 06, 2019, 07:30 PM
1-- Data exporting was unselected.
2-- Dumping structure for table bsessentialmode.cardealer2_vehicles
3CREATE TABLE IF NOT EXISTS `cardealer2_vehicles` (
4 `id` int(11) NOT NULL AUTO_INCREMENT,
5 `vehicle` varchar(255) NOT NULL,
6 `price` int(11) NOT NULL,
7 PRIMARY KEY (`id`)
8) ENGINE=InnoDB AUTO_INCREMENT=3099 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT;
9
10-- Data exporting was unselected.
11-- Dumping structure for table bsessentialmode.cardealer3_vehicles
12CREATE TABLE IF NOT EXISTS `cardealer3_vehicles` (
13 `id` int(11) NOT NULL AUTO_INCREMENT,
14 `vehicle` varchar(255) NOT NULL,
15 `price` int(11) NOT NULL,
16 PRIMARY KEY (`id`)
17) ENGINE=InnoDB AUTO_INCREMENT=2157 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT;
18
19-- Data exporting was unselected.
20-- Dumping structure for table bsessentialmode.cardealer_vehicles
21CREATE TABLE IF NOT EXISTS `cardealer_vehicles` (
22 `id` int(11) NOT NULL AUTO_INCREMENT,
23 `vehicle` varchar(255) NOT NULL,
24 `price` int(11) NOT NULL,
25 PRIMARY KEY (`id`)
26) ENGINE=InnoDB AUTO_INCREMENT=3412 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
27-- Data exporting was unselected.
28-- Dumping structure for table bsessentialmode.medical_records
29CREATE TABLE IF NOT EXISTS `medical_records` (
30 `id` int(255) NOT NULL AUTO_INCREMENT,
31 `identifier` varchar(50) NOT NULL,
32 `firstname` varchar(255) NOT NULL,
33 `lastname` varchar(255) NOT NULL,
34 `dateofrecord` varchar(255) NOT NULL,
35 `record` varchar(255) NOT NULL,
36 PRIMARY KEY (`id`)
37) ENGINE=InnoDB AUTO_INCREMENT=3556 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT;
38
39
40-- Data exporting was unselected.
41-- Dumping structure for table bsessentialmode.owned_vehicles
42CREATE TABLE IF NOT EXISTS `owned_vehicles` (
43 `id` int(11) NOT NULL AUTO_INCREMENT,
44 `owner` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
45 `state` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'State of the car',
46 `plate` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
47 `vehicle` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
48 `character` int(11) NOT NULL,
49 `model` varchar(45) DEFAULT NULL,
50 `numberOfImpounds` int(1) NOT NULL DEFAULT '0',
51 `lastImpound` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
52 PRIMARY KEY (`plate`),
53 KEY `id` (`id`)
54) ENGINE=InnoDB AUTO_INCREMENT=17876 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
55-- Data exporting was unselected.
56-- Dumping structure for table bsessentialmode.vehicles3
57CREATE TABLE IF NOT EXISTS `vehicles3` (
58 `id` int(11) NOT NULL AUTO_INCREMENT,
59 `name` varchar(60) NOT NULL,
60 `model` varchar(60) NOT NULL,
61 `price` int(11) NOT NULL,
62 `category` varchar(60) DEFAULT NULL,
63 `rotation` int(11) DEFAULT NULL,
64 PRIMARY KEY (`id`)
65) ENGINE=InnoDB AUTO_INCREMENT=431 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT;
66-- Data exporting was unselected.
67-- Dumping structure for table bsessentialmode.vehicles
68CREATE TABLE IF NOT EXISTS `vehicles` (
69 `id` int(11) NOT NULL AUTO_INCREMENT,
70 `name` varchar(60) NOT NULL,
71 `model` varchar(60) NOT NULL,
72 `price` int(11) NOT NULL,
73 `category` varchar(60) DEFAULT NULL,
74 `rotation` int(11) DEFAULT NULL,
75 PRIMARY KEY (`id`)
76) ENGINE=InnoDB AUTO_INCREMENT=434 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT;
77
78-- Data exporting was unselected.
79-- Dumping structure for table bsessentialmode.vehicles2
80CREATE TABLE IF NOT EXISTS `vehicles2` (
81 `id` int(11) NOT NULL AUTO_INCREMENT,
82 `name` varchar(60) NOT NULL,
83 `model` varchar(60) NOT NULL,
84 `price` int(11) NOT NULL,
85 `category` varchar(60) DEFAULT NULL,
86 `rotation` int(11) DEFAULT NULL,
87 PRIMARY KEY (`id`)
88) ENGINE=InnoDB AUTO_INCREMENT=431 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT;
89
90-- Data exporting was unselected.
91-- Dumping structure for table bsessentialmode.vehicles3
92CREATE TABLE IF NOT EXISTS `vehicles3` (
93 `id` int(11) NOT NULL AUTO_INCREMENT,
94 `name` varchar(60) NOT NULL,
95 `model` varchar(60) NOT NULL,
96 `price` int(11) NOT NULL,
97 `category` varchar(60) DEFAULT NULL,
98 `rotation` int(11) DEFAULT NULL,
99 PRIMARY KEY (`id`)
100) ENGINE=InnoDB AUTO_INCREMENT=431 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT;
101-- Data exporting was unselected.
102-- Dumping structure for table bsessentialmode.vehicles_job
103CREATE TABLE IF NOT EXISTS `vehicles_job` (
104 `id` varchar(60) NOT NULL,
105 `name` varchar(60) NOT NULL,
106 `model` varchar(60) NOT NULL,
107 `price` int(11) NOT NULL,
108 `category` varchar(60) DEFAULT NULL,
109 PRIMARY KEY (`model`)
110) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT;
111
112-- Data exporting was unselected.
113-- Dumping structure for table bsessentialmode.vehicles_lowend
114CREATE TABLE IF NOT EXISTS `vehicles_lowend` (
115 `id` varchar(60) NOT NULL,
116 `name` varchar(60) NOT NULL,
117 `model` varchar(60) NOT NULL,
118 `price` int(11) NOT NULL,
119 `category` varchar(60) DEFAULT NULL,
120 PRIMARY KEY (`model`)
121) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT;
122
123-- Data exporting was unselected.
124-- Dumping structure for table bsessentialmode.vehicle_categories
125CREATE TABLE IF NOT EXISTS `vehicle_categories` (
126 `id` int(11) NOT NULL AUTO_INCREMENT,
127 `name` varchar(60) NOT NULL,
128 `label` varchar(60) NOT NULL,
129 PRIMARY KEY (`id`)
130) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
131-- Data exporting was unselected.
132-- Dumping structure for table bsessentialmode.vehicle_categories2
133CREATE TABLE IF NOT EXISTS `vehicle_categories2` (
134 `id` int(11) NOT NULL AUTO_INCREMENT,
135 `name` varchar(60) NOT NULL,
136 `label` varchar(60) NOT NULL,
137 PRIMARY KEY (`id`)
138) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT;
139
140-- Data exporting was unselected.
141-- Dumping structure for table bsessentialmode.vehicle_categories3
142CREATE TABLE IF NOT EXISTS `vehicle_categories3` (
143 `id` int(11) NOT NULL AUTO_INCREMENT,
144 `name` varchar(60) NOT NULL,
145 `label` varchar(60) NOT NULL,
146 PRIMARY KEY (`id`)
147) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT;
148
149-- Data exporting was unselected.
150-- Dumping structure for table bsessentialmode.vehicle_categories_job
151CREATE TABLE IF NOT EXISTS `vehicle_categories_job` (
152 `id` int(11) NOT NULL AUTO_INCREMENT,
153 `name` varchar(60) NOT NULL,
154 `label` varchar(60) NOT NULL,
155 PRIMARY KEY (`id`)
156) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT;
157
158-- Data exporting was unselected.
159-- Dumping structure for table bsessentialmode.vehicle_categories_lowend
160CREATE TABLE IF NOT EXISTS `vehicle_categories_lowend` (
161 `id` int(11) NOT NULL AUTO_INCREMENT,
162 `name` varchar(60) NOT NULL,
163 `label` varchar(60) NOT NULL,
164 PRIMARY KEY (`id`)
165) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT;