Cq7MNUaT

1CREATE TABLE IF NOT EXISTS `cars`.`cars_info` (
2  `id` INT(11) NOT NULL AUTO_INCREMENT,
3  `label` VARCHAR(45) NOT NULL,
4  `model` VARCHAR(45) NULL DEFAULT NULL,
5  `engine` VARCHAR(45) NOT NULL,
6  `horse_power` INT(11) NULL DEFAULT NULL,
7  `gearbox` VARCHAR(45) NOT NULL,
8  `price` INT(11) NOT NULL,
9  `month` VARCHAR(45) NOT NULL,
10  `year` INT(11) NOT NULL,
11  `km` INT(11) NOT NULL,
12  `city` VARCHAR(20) NULL DEFAULT NULL,
13  `user_id` INT(11) NULL DEFAULT NULL,
14  `two_three_doors` INT(11) NULL DEFAULT '0',
15  `four_five_doors` TINYINT(1) NULL DEFAULT '0',
16  `LED_lights` TINYINT(1) NULL DEFAULT '0',
17  `ksenon_lights` TINYINT(1) NULL DEFAULT '0',
18  `halogen_lights` TINYINT(1) NULL DEFAULT '0',
19  `leti_djanti` TINYINT(1) NULL DEFAULT '0',
20  `teglich` TINYINT(1) NULL DEFAULT '0',
21  `shibedah` TINYINT(1) NULL DEFAULT '0',
22  `alarm` TINYINT(1) NULL DEFAULT '0',
23  `imobilizer` TINYINT(1) NULL DEFAULT '0',
24  `casco` TINYINT(1) NULL DEFAULT NULL,
25  `central_locking` TINYINT(1) NULL DEFAULT '0',
26  `fourXfour` TINYINT(1) NULL DEFAULT '0',
27  `barter` TINYINT(1) NULL DEFAULT '0',
28  `gasSystem` TINYINT(1) NULL DEFAULT '0',
29  `lizing` TINYINT(1) NULL DEFAULT '0',
30  `new_entry` TINYINT(1) NULL DEFAULT '0',
31  `on_parts` TINYINT(1) NULL DEFAULT '0',
32  `with_registration` TINYINT(1) NULL DEFAULT '0',
33  `serviceBook` TINYINT(1) NULL DEFAULT '0',
34  PRIMARY KEY (`id`))
35ENGINE = InnoDB
36AUTO_INCREMENT = 36
37DEFAULT CHARACTER SET = utf8;