VgJFRd7g

1CREATE SCHEMA IF NOT EXISTS `otm`;
2
3CREATE TABLE IF NOT EXISTS `otm`.`manufactures`
4(
5`manufacturer_id` INT AUTO_INCREMENT PRIMARY KEY,
6`name` VARCHAR(50),
7`established_on` DATETIME 
8);
9
10INSERT INTO  `otm`.`manufactures` (`manufacturer_id`,`name`,`established_on`) VALUES ('1','BMW', STR_TO_DATE('01/03/1916', '%d/%m/%Y'));
11INSERT INTO  `otm`.`manufactures` (`name`,`established_on`) VALUES ('Tesla',STR_TO_DATE('01/01/2003', '%d/%m/%Y'));
12INSERT INTO  `otm`.`manufactures` (`name`,`established_on`) VALUES ('Lada',STR_TO_DATE('01/05/1966','%d/%m/%Y'));
13CREATE TABLE IF NOT EXISTS `otm`.`models`
14(
15`model_id` INT AUTO_INCREMENT PRIMARY KEY,
16`name` VARCHAR(50),
17`manufacturer_id` INT ,
18CONSTRAINT `fk_manunfacturer_id` FOREIGN KEY(`manufacturer_id`) REFERENCES `otm`.`manufactures` (`manufacturer_id`)
19);
20INSERT INTO  `otm`.`models` (`model_id`,`name`,`manufacturer_id`) VALUES ('101','X1', '1');
21INSERT INTO  `otm`.`models` (`name`,`manufacturer_id`) VALUES ('i6', '1');
22INSERT INTO  `otm`.`models` (`name`,`manufacturer_id`) VALUES ('Model S', '2');
23INSERT INTO  `otm`.`models` (`name`,`manufacturer_id`) VALUES ('Model X', '2');
24INSERT INTO  `otm`.`models` (`name`,`manufacturer_id`) VALUES ('Model 3', '2');
25INSERT INTO  `otm`.`models` (`name`,`manufacturer_id`) VALUES ('Nova', '3');