SRDCAk7P

1CREATE TABLE IF NOT EXISTS `cars`.`users` (
2  `user_id` INT(11) NOT NULL AUTO_INCREMENT,
3  `first_name` VARCHAR(45) NOT NULL,
4  `last_name` VARCHAR(45) NOT NULL,
5  `email` VARCHAR(50) NOT NULL,
6  `mobile_number` VARCHAR(10) NULL DEFAULT NULL,
7  `password` VARCHAR(45) NOT NULL,
8  PRIMARY KEY (`user_id`),
9  UNIQUE INDEX `user_id_UNIQUE` (`user_id` ASC),
10  UNIQUE INDEX `email_UNIQUE` (`email` ASC),
11  UNIQUE INDEX `password_UNIQUE` (`password` ASC))
12ENGINE = InnoDB
13DEFAULT CHARACTER SET = utf8;
14
15
16-- -----------------------------------------------------
17-- Table `cars`.`cars_info`
18-- -----------------------------------------------------
19CREATE TABLE IF NOT EXISTS `cars`.`cars_info` (
20  `id` INT(11) NOT NULL AUTO_INCREMENT,
21  `label` VARCHAR(45) NOT NULL,
22  `model` VARCHAR(45) NULL DEFAULT NULL,
23  `engine` VARCHAR(45) NOT NULL,
24  `horse_power` INT(11) NULL DEFAULT NULL,
25  `gearbox` VARCHAR(45) NOT NULL,
26  `price` INT(11) NOT NULL,
27  `month` VARCHAR(45) NOT NULL,
28  `year` INT(11) NOT NULL,
29  `km` INT(11) NOT NULL,
30  `city` VARCHAR(20) NULL DEFAULT NULL,
31  `user_id` VARCHAR(60) NULL DEFAULT NULL,
32  `two_three_doors` INT(11) NULL DEFAULT '0',
33  `four_five_doors` TINYINT(1) NULL DEFAULT '0',
34  `LED_lights` TINYINT(1) NULL DEFAULT '0',
35  `ksenon_lights` TINYINT(1) NULL DEFAULT '0',
36  `halogen_lights` TINYINT(1) NULL DEFAULT '0',
37  `leti_djanti` TINYINT(1) NULL DEFAULT '0',
38  `teglich` TINYINT(1) NULL DEFAULT '0',
39  `shibedah` TINYINT(1) NULL DEFAULT '0',
40  `alarm` TINYINT(1) NULL DEFAULT '0',
41  `imobilizer` TINYINT(1) NULL DEFAULT '0',
42  `casco` TINYINT(1) NULL DEFAULT NULL,
43  `central_locking` TINYINT(1) NULL DEFAULT '0',
44  `fourXfour` TINYINT(1) NULL DEFAULT '0',
45  `barter` TINYINT(1) NULL DEFAULT '0',
46  `gasSystem` TINYINT(1) NULL DEFAULT '0',
47  `lizing` TINYINT(1) NULL DEFAULT '0',
48  `new_entry` TINYINT(1) NULL DEFAULT '0',
49  `on_parts` TINYINT(1) NULL DEFAULT '0',
50  `with_registration` TINYINT(1) NULL DEFAULT '0',
51  `serviceBook` TINYINT(1) NULL DEFAULT '0',
52  PRIMARY KEY (`id`),
53  INDEX `fk_cars_users_idx` (`user_id` ASC),
54  CONSTRAINT `fk_cars_users`
55    FOREIGN KEY (`user_id`)
56    REFERENCES `cars`.`users` (`email`)
57    ON DELETE NO ACTION
58    ON UPDATE NO ACTION)
59ENGINE = InnoDB
60AUTO_INCREMENT = 36
61DEFAULT CHARACTER SET = utf8;