· 5 years ago · Feb 14, 2020, 11:06 AM
1-- MySQL Workbench Synchronization
2-- Generated: 2020-02-14 13:45
3-- Model: New Model
4-- Version: 1.0
5-- Project: Name of the project
6-- Author: Maks
7
8SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
9SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
10SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
11
12CREATE SCHEMA IF NOT EXISTS `car_parts` DEFAULT CHARACTER SET utf8 ;
13
14CREATE TABLE IF NOT EXISTS `car_parts`.`car_part` (
15 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
16 `car_id` INT(10) UNSIGNED NOT NULL,
17 `name` VARCHAR(64) NOT NULL,
18 `description` VARCHAR(255) NULL DEFAULT NULL,
19 PRIMARY KEY (`id`),
20 UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
21 INDEX `fk_car_part_car1_idx` (`car_id` ASC) VISIBLE,
22 UNIQUE INDEX `name_UNIQUE` (`name` ASC) VISIBLE,
23 CONSTRAINT `fk_car_part_car1`
24 FOREIGN KEY (`car_id`)
25 REFERENCES `car_parts`.`car` (`id`)
26 ON DELETE NO ACTION
27 ON UPDATE NO ACTION)
28ENGINE = InnoDB
29DEFAULT CHARACTER SET = utf8;
30
31CREATE TABLE IF NOT EXISTS `car_parts`.`car` (
32 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
33 `volume` SMALLINT(5) UNSIGNED NULL DEFAULT NULL,
34 `engines_type_id` TINYINT(3) UNSIGNED NOT NULL,
35 `body_type_id` TINYINT(3) UNSIGNED NOT NULL,
36 `car_model_id` MEDIUMINT(8) UNSIGNED NOT NULL,
37 `modification_id` INT(10) UNSIGNED NOT NULL,
38 PRIMARY KEY (`id`),
39 UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
40 INDEX `fk_car_engines_type_idx` (`engines_type_id` ASC) VISIBLE,
41 INDEX `fk_car_body_type1_idx` (`body_type_id` ASC) VISIBLE,
42 INDEX `fk_car_car_model1_idx` (`car_model_id` ASC) VISIBLE,
43 INDEX `fk_car_modification1_idx` (`modification_id` ASC) VISIBLE,
44 CONSTRAINT `fk_car_engines_type`
45 FOREIGN KEY (`engines_type_id`)
46 REFERENCES `car_parts`.`engines_type` (`id`)
47 ON DELETE NO ACTION
48 ON UPDATE NO ACTION,
49 CONSTRAINT `fk_car_body_type1`
50 FOREIGN KEY (`body_type_id`)
51 REFERENCES `car_parts`.`body_type` (`id`)
52 ON DELETE NO ACTION
53 ON UPDATE NO ACTION,
54 CONSTRAINT `fk_car_car_model1`
55 FOREIGN KEY (`car_model_id`)
56 REFERENCES `car_parts`.`model` (`id`)
57 ON DELETE NO ACTION
58 ON UPDATE NO ACTION,
59 CONSTRAINT `fk_car_modification1`
60 FOREIGN KEY (`modification_id`)
61 REFERENCES `car_parts`.`modification` (`id`)
62 ON DELETE NO ACTION
63 ON UPDATE NO ACTION)
64ENGINE = InnoDB
65DEFAULT CHARACTER SET = utf8;
66
67CREATE TABLE IF NOT EXISTS `car_parts`.`model` (
68 `id` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
69 `name` VARCHAR(64) NOT NULL,
70 `car_mark_id` MEDIUMINT(8) UNSIGNED NOT NULL,
71 PRIMARY KEY (`id`),
72 UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
73 UNIQUE INDEX `name_UNIQUE` (`name` ASC) VISIBLE,
74 INDEX `fk_car_model_car_mark1_idx` (`car_mark_id` ASC) VISIBLE,
75 CONSTRAINT `fk_car_model_car_mark1`
76 FOREIGN KEY (`car_mark_id`)
77 REFERENCES `car_parts`.`mark` (`id`)
78 ON DELETE NO ACTION
79 ON UPDATE NO ACTION)
80ENGINE = InnoDB
81DEFAULT CHARACTER SET = utf8;
82
83CREATE TABLE IF NOT EXISTS `car_parts`.`mark` (
84 `id` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
85 `name` VARCHAR(64) NOT NULL,
86 PRIMARY KEY (`id`),
87 UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
88 UNIQUE INDEX `name_UNIQUE` (`name` ASC) VISIBLE)
89ENGINE = InnoDB
90DEFAULT CHARACTER SET = utf8;
91
92CREATE TABLE IF NOT EXISTS `car_parts`.`body_type` (
93 `id` TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
94 `name` VARCHAR(45) NOT NULL,
95 PRIMARY KEY (`id`),
96 UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
97 UNIQUE INDEX `name_UNIQUE` (`name` ASC) VISIBLE)
98ENGINE = InnoDB
99DEFAULT CHARACTER SET = utf8;
100
101CREATE TABLE IF NOT EXISTS `car_parts`.`engines_type` (
102 `id` TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
103 `name` VARCHAR(45) NOT NULL,
104 PRIMARY KEY (`id`),
105 UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
106 UNIQUE INDEX `name_UNIQUE` (`name` ASC) VISIBLE)
107ENGINE = InnoDB
108DEFAULT CHARACTER SET = utf8;
109
110CREATE TABLE IF NOT EXISTS `car_parts`.`modification` (
111 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
112 `name` VARCHAR(45) NULL DEFAULT NULL,
113 PRIMARY KEY (`id`),
114 UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE)
115ENGINE = InnoDB
116DEFAULT CHARACTER SET = utf8;
117
118CREATE TABLE IF NOT EXISTS `car_parts`.`car_part_category` (
119 `id` TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
120 `name` VARCHAR(64) NOT NULL,
121 `car_part_id` INT(10) UNSIGNED NOT NULL,
122 PRIMARY KEY (`id`),
123 UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
124 UNIQUE INDEX `name_UNIQUE` (`name` ASC) VISIBLE,
125 INDEX `fk_car_part_category_car_part1_idx` (`car_part_id` ASC) VISIBLE,
126 CONSTRAINT `fk_car_part_category_car_part1`
127 FOREIGN KEY (`car_part_id`)
128 REFERENCES `car_parts`.`car_part` (`id`)
129 ON DELETE NO ACTION
130 ON UPDATE NO ACTION)
131ENGINE = InnoDB
132DEFAULT CHARACTER SET = utf8;
133
134CREATE TABLE IF NOT EXISTS `car_parts`.`provider` (
135 `id` TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
136 `provider` VARCHAR(45) NOT NULL,
137 `id_user` SMALLINT(5) UNSIGNED NULL DEFAULT NULL,
138 PRIMARY KEY (`id`),
139 UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
140 INDEX `fk_provider_user_idx` (`id_user` ASC) VISIBLE,
141 CONSTRAINT `fk_provider_user`
142 FOREIGN KEY (`id_user`)
143 REFERENCES `car_parts`.`user` (`id`)
144 ON DELETE NO ACTION
145 ON UPDATE NO ACTION)
146ENGINE = InnoDB
147DEFAULT CHARACTER SET = utf8;
148
149CREATE TABLE IF NOT EXISTS `car_parts`.`address` (
150 `id` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
151 `type_of_settlement` ENUM("город", "агрогородок", "деревня", "село", "хутор", "поселок городского типа") NOT NULL,
152 `type_of_street` ENUM("улица", "проспект", "переулок", "площадь", "тракт", "проезд", "кольцо", "бульвар") NOT NULL,
153 `house_num` INT(10) UNSIGNED NOT NULL,
154 `bulding_num` CHAR(2) NULL DEFAULT NULL,
155 `post_index` MEDIUMINT(9) NULL DEFAULT NULL,
156 `flat_num` CHAR(3) NULL DEFAULT NULL,
157 `city_id` SMALLINT(5) UNSIGNED NOT NULL,
158 `region_id` SMALLINT(5) UNSIGNED NOT NULL,
159 `district_id` SMALLINT(5) UNSIGNED NOT NULL,
160 `street_id` SMALLINT(5) UNSIGNED NOT NULL,
161 `email_id` MEDIUMINT(8) UNSIGNED NOT NULL,
162 `tel_id` MEDIUMINT(8) UNSIGNED NOT NULL,
163 `customer_id` INT(10) UNSIGNED NOT NULL,
164 PRIMARY KEY (`id`),
165 UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
166 INDEX `fk_address_city1_idx` (`city_id` ASC) VISIBLE,
167 INDEX `fk_address_region1_idx` (`region_id` ASC) VISIBLE,
168 INDEX `fk_address_district1_idx` (`district_id` ASC) VISIBLE,
169 INDEX `fk_address_street1_idx` (`street_id` ASC) VISIBLE,
170 INDEX `fk_address_email1_idx` (`email_id` ASC) VISIBLE,
171 INDEX `fk_address_tel1_idx` (`tel_id` ASC) VISIBLE,
172 INDEX `fk_address_customer1_idx` (`customer_id` ASC) VISIBLE,
173 CONSTRAINT `fk_address_city1`
174 FOREIGN KEY (`city_id`)
175 REFERENCES `car_parts`.`city` (`id`)
176 ON DELETE NO ACTION
177 ON UPDATE NO ACTION,
178 CONSTRAINT `fk_address_region1`
179 FOREIGN KEY (`region_id`)
180 REFERENCES `car_parts`.`region` (`id`)
181 ON DELETE NO ACTION
182 ON UPDATE NO ACTION,
183 CONSTRAINT `fk_address_district1`
184 FOREIGN KEY (`district_id`)
185 REFERENCES `car_parts`.`district` (`id`)
186 ON DELETE NO ACTION
187 ON UPDATE NO ACTION,
188 CONSTRAINT `fk_address_street1`
189 FOREIGN KEY (`street_id`)
190 REFERENCES `car_parts`.`street` (`id`)
191 ON DELETE NO ACTION
192 ON UPDATE NO ACTION,
193 CONSTRAINT `fk_address_email1`
194 FOREIGN KEY (`email_id`)
195 REFERENCES `car_parts`.`email` (`id`)
196 ON DELETE NO ACTION
197 ON UPDATE NO ACTION,
198 CONSTRAINT `fk_address_tel1`
199 FOREIGN KEY (`tel_id`)
200 REFERENCES `car_parts`.`tel` (`id`)
201 ON DELETE NO ACTION
202 ON UPDATE NO ACTION,
203 CONSTRAINT `fk_address_customer1`
204 FOREIGN KEY (`customer_id`)
205 REFERENCES `car_parts`.`customer` (`id`)
206 ON DELETE NO ACTION
207 ON UPDATE NO ACTION)
208ENGINE = InnoDB
209DEFAULT CHARACTER SET = utf8;
210
211CREATE TABLE IF NOT EXISTS `car_parts`.`street` (
212 `id` SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
213 `name` VARCHAR(64) NOT NULL,
214 PRIMARY KEY (`id`),
215 UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
216 UNIQUE INDEX `name_UNIQUE` (`name` ASC) VISIBLE)
217ENGINE = InnoDB
218DEFAULT CHARACTER SET = utf8;
219
220CREATE TABLE IF NOT EXISTS `car_parts`.`region` (
221 `id` SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
222 `name` VARCHAR(64) NOT NULL,
223 PRIMARY KEY (`id`),
224 UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
225 UNIQUE INDEX `name_UNIQUE` (`name` ASC) VISIBLE)
226ENGINE = InnoDB
227DEFAULT CHARACTER SET = utf8;
228
229CREATE TABLE IF NOT EXISTS `car_parts`.`city` (
230 `id` SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
231 `name` VARCHAR(64) NOT NULL,
232 PRIMARY KEY (`id`),
233 UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
234 UNIQUE INDEX `name_UNIQUE` (`name` ASC) VISIBLE)
235ENGINE = InnoDB
236DEFAULT CHARACTER SET = utf8;
237
238CREATE TABLE IF NOT EXISTS `car_parts`.`district` (
239 `id` SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
240 `name` VARCHAR(64) NOT NULL,
241 PRIMARY KEY (`id`),
242 UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
243 UNIQUE INDEX `name_UNIQUE` (`name` ASC) VISIBLE)
244ENGINE = InnoDB
245DEFAULT CHARACTER SET = utf8;
246
247CREATE TABLE IF NOT EXISTS `car_parts`.`email` (
248 `id` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
249 `name` VARCHAR(64) NOT NULL,
250 PRIMARY KEY (`id`),
251 UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
252 UNIQUE INDEX `name_UNIQUE` (`name` ASC) VISIBLE)
253ENGINE = InnoDB
254DEFAULT CHARACTER SET = utf8;
255
256CREATE TABLE IF NOT EXISTS `car_parts`.`tel` (
257 `id` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
258 `name` VARCHAR(25) NOT NULL,
259 PRIMARY KEY (`id`),
260 UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
261 UNIQUE INDEX `name_UNIQUE` (`name` ASC) VISIBLE)
262ENGINE = InnoDB
263DEFAULT CHARACTER SET = utf8;
264
265CREATE TABLE IF NOT EXISTS `car_parts`.`store` (
266 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
267 `count_part` MEDIUMINT(8) UNSIGNED NOT NULL,
268 `price` MEDIUMINT(8) UNSIGNED NOT NULL,
269 `receipt_date` DATE NOT NULL,
270 `car_part_id` INT(10) UNSIGNED NOT NULL,
271 `provider_id` TINYINT(3) UNSIGNED NOT NULL,
272 PRIMARY KEY (`id`),
273 UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
274 INDEX `fk_storage_car_part1_idx` (`car_part_id` ASC) VISIBLE,
275 INDEX `fk_store_provider1_idx` (`provider_id` ASC) VISIBLE,
276 CONSTRAINT `fk_storage_car_part1`
277 FOREIGN KEY (`car_part_id`)
278 REFERENCES `car_parts`.`car_part` (`id`)
279 ON DELETE NO ACTION
280 ON UPDATE NO ACTION,
281 CONSTRAINT `fk_store_provider1`
282 FOREIGN KEY (`provider_id`)
283 REFERENCES `car_parts`.`provider` (`id`)
284 ON DELETE NO ACTION
285 ON UPDATE NO ACTION)
286ENGINE = InnoDB
287DEFAULT CHARACTER SET = utf8;
288
289CREATE TABLE IF NOT EXISTS `car_parts`.`transaction` (
290 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
291 `time` DATE NOT NULL,
292 `paid_price` INT(10) UNSIGNED NOT NULL,
293 `bank_details_id` INT(10) UNSIGNED NOT NULL,
294 PRIMARY KEY (`id`),
295 UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
296 INDEX `fk_transaction_bank_details1_idx` (`bank_details_id` ASC) VISIBLE,
297 CONSTRAINT `fk_transaction_bank_details1`
298 FOREIGN KEY (`bank_details_id`)
299 REFERENCES `car_parts`.`bank_details` (`id`)
300 ON DELETE NO ACTION
301 ON UPDATE NO ACTION)
302ENGINE = InnoDB
303DEFAULT CHARACTER SET = utf8;
304
305CREATE TABLE IF NOT EXISTS `car_parts`.`sales` (
306 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
307 `full_price` INT(10) UNSIGNED NOT NULL,
308 `time` TIMESTAMP NOT NULL,
309 `transaction_id` INT(10) UNSIGNED NOT NULL,
310 `count_part` MEDIUMINT(8) UNSIGNED NOT NULL,
311 `store_id` INT(10) UNSIGNED NOT NULL,
312 `customer_id` INT(10) UNSIGNED NOT NULL,
313 PRIMARY KEY (`id`),
314 UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
315 INDEX `fk_sales_transaction1_idx` (`transaction_id` ASC) VISIBLE,
316 INDEX `fk_sales_store1_idx` (`store_id` ASC) VISIBLE,
317 INDEX `fk_sales_customer1_idx` (`customer_id` ASC) VISIBLE,
318 CONSTRAINT `fk_sales_transaction1`
319 FOREIGN KEY (`transaction_id`)
320 REFERENCES `car_parts`.`transaction` (`id`)
321 ON DELETE NO ACTION
322 ON UPDATE NO ACTION,
323 CONSTRAINT `fk_sales_store1`
324 FOREIGN KEY (`store_id`)
325 REFERENCES `car_parts`.`store` (`id`)
326 ON DELETE NO ACTION
327 ON UPDATE NO ACTION,
328 CONSTRAINT `fk_sales_customer1`
329 FOREIGN KEY (`customer_id`)
330 REFERENCES `car_parts`.`customer` (`id`)
331 ON DELETE NO ACTION
332 ON UPDATE NO ACTION)
333ENGINE = InnoDB
334DEFAULT CHARACTER SET = utf8;
335
336CREATE TABLE IF NOT EXISTS `car_parts`.`customer` (
337 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
338 `name1_id` SMALLINT(5) UNSIGNED NULL DEFAULT NULL,
339 `name2_id` SMALLINT(5) UNSIGNED NULL DEFAULT NULL,
340 `name3_id` SMALLINT(5) UNSIGNED NULL DEFAULT NULL,
341 `adress_id` MEDIUMINT(8) UNSIGNED NOT NULL,
342 `bank_details_id` INT(11) NULL DEFAULT NULL,
343 `id_user` SMALLINT(5) UNSIGNED NULL DEFAULT NULL,
344 PRIMARY KEY (`id`),
345 UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
346 INDEX `fk_customer_name11_idx` (`name1_id` ASC) VISIBLE,
347 INDEX `fk_customer_name21_idx` (`name2_id` ASC) VISIBLE,
348 INDEX `fk_customer_name31_idx` (`name3_id` ASC) VISIBLE,
349 INDEX `fk_customer_user_idx` (`id_user` ASC) VISIBLE,
350 CONSTRAINT `fk_customer_name11`
351 FOREIGN KEY (`name1_id`)
352 REFERENCES `car_parts`.`name1` (`id`)
353 ON DELETE NO ACTION
354 ON UPDATE NO ACTION,
355 CONSTRAINT `fk_customer_name21`
356 FOREIGN KEY (`name2_id`)
357 REFERENCES `car_parts`.`name2` (`id`)
358 ON DELETE NO ACTION
359 ON UPDATE NO ACTION,
360 CONSTRAINT `fk_customer_name31`
361 FOREIGN KEY (`name3_id`)
362 REFERENCES `car_parts`.`name3` (`id`)
363 ON DELETE NO ACTION
364 ON UPDATE NO ACTION,
365 CONSTRAINT `fk_customer_user`
366 FOREIGN KEY (`id_user`)
367 REFERENCES `car_parts`.`user` (`id`)
368 ON DELETE NO ACTION
369 ON UPDATE NO ACTION)
370ENGINE = InnoDB
371DEFAULT CHARACTER SET = utf8;
372
373CREATE TABLE IF NOT EXISTS `car_parts`.`bank_details` (
374 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
375 `bank_id` INT(10) UNSIGNED NOT NULL,
376 `pay_acc_id` INT(10) UNSIGNED NOT NULL,
377 `customer_id` INT(10) UNSIGNED NOT NULL,
378 PRIMARY KEY (`id`),
379 UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
380 INDEX `fk_bank_details_bank1_idx` (`bank_id` ASC) VISIBLE,
381 INDEX `fk_bank_details_pay_acc1_idx` (`pay_acc_id` ASC) VISIBLE,
382 INDEX `fk_bank_details_customer1_idx` (`customer_id` ASC) VISIBLE,
383 CONSTRAINT `fk_bank_details_bank1`
384 FOREIGN KEY (`bank_id`)
385 REFERENCES `car_parts`.`bank` (`id`)
386 ON DELETE NO ACTION
387 ON UPDATE NO ACTION,
388 CONSTRAINT `fk_bank_details_pay_acc1`
389 FOREIGN KEY (`pay_acc_id`)
390 REFERENCES `car_parts`.`pay_acc` (`id`)
391 ON DELETE NO ACTION
392 ON UPDATE NO ACTION,
393 CONSTRAINT `fk_bank_details_customer1`
394 FOREIGN KEY (`customer_id`)
395 REFERENCES `car_parts`.`customer` (`id`)
396 ON DELETE NO ACTION
397 ON UPDATE NO ACTION)
398ENGINE = InnoDB
399DEFAULT CHARACTER SET = utf8;
400
401CREATE TABLE IF NOT EXISTS `car_parts`.`pay_acc` (
402 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
403 `acc` CHAR(20) NOT NULL,
404 PRIMARY KEY (`id`),
405 UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
406 UNIQUE INDEX `acc_UNIQUE` (`acc` ASC) VISIBLE)
407ENGINE = InnoDB
408DEFAULT CHARACTER SET = utf8;
409
410CREATE TABLE IF NOT EXISTS `car_parts`.`bank` (
411 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
412 `name` VARCHAR(64) NOT NULL,
413 PRIMARY KEY (`id`),
414 UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
415 UNIQUE INDEX `name_UNIQUE` (`name` ASC) VISIBLE)
416ENGINE = InnoDB
417DEFAULT CHARACTER SET = utf8;
418
419CREATE TABLE IF NOT EXISTS `car_parts`.`name1` (
420 `id` SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
421 `name` VARCHAR(64) NOT NULL,
422 PRIMARY KEY (`id`),
423 UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
424 UNIQUE INDEX `name_UNIQUE` (`name` ASC) VISIBLE)
425ENGINE = InnoDB
426DEFAULT CHARACTER SET = utf8;
427
428CREATE TABLE IF NOT EXISTS `car_parts`.`name2` (
429 `id` SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
430 `name` VARCHAR(64) NOT NULL,
431 PRIMARY KEY (`id`),
432 UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
433 UNIQUE INDEX `name_UNIQUE` (`name` ASC) VISIBLE)
434ENGINE = InnoDB
435DEFAULT CHARACTER SET = utf8;
436
437CREATE TABLE IF NOT EXISTS `car_parts`.`name3` (
438 `id` SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
439 `name` VARCHAR(64) NOT NULL,
440 PRIMARY KEY (`id`),
441 UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
442 UNIQUE INDEX `name_UNIQUE` (`name` ASC) VISIBLE)
443ENGINE = InnoDB
444DEFAULT CHARACTER SET = utf8;
445
446CREATE TABLE IF NOT EXISTS `car_parts`.`user` (
447 `id` SMALLINT(5) UNSIGNED NOT NULL,
448 `username` VARCHAR(45) NULL DEFAULT NULL,
449 `password` VARCHAR(45) NULL DEFAULT NULL,
450 `id_role` TINYINT(3) UNSIGNED NULL DEFAULT NULL,
451 PRIMARY KEY (`id`),
452 INDEX `fk_user_role_idx` (`id_role` ASC) VISIBLE,
453 CONSTRAINT `fk_user_role`
454 FOREIGN KEY (`id_role`)
455 REFERENCES `car_parts`.`roles` (`id`)
456 ON DELETE NO ACTION
457 ON UPDATE NO ACTION)
458ENGINE = InnoDB
459DEFAULT CHARACTER SET = utf8;
460
461CREATE TABLE IF NOT EXISTS `car_parts`.`roles` (
462 `id` TINYINT(3) UNSIGNED NOT NULL,
463 `role` VARCHAR(45) NULL DEFAULT NULL,
464 PRIMARY KEY (`id`))
465ENGINE = InnoDB
466DEFAULT CHARACTER SET = utf8;
467
468
469SET SQL_MODE=@OLD_SQL_MODE;
470SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
471SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;