wbxKBHU0

1DROP TABLE IF EXISTS `Model`;
2CREATE TABLE `Model` (
3  `model_id` INT(10) NOT NULL AUTO_INCREMENT,
4  `model_name` VARCHAR(40) NOT NULL, 
5  `first_production_year` INT NOT NULL,
6  PRIMARY KEY (`model_id`)
7) ENGINE=InnoDB;
8
9DROP TABLE IF EXISTS `Make`;
10CREATE TABLE `Make` (
11  `make_id` INT(10) NOT NULL AUTO_INCREMENT,
12  `make_name` VARCHAR(40) NOT NULL, 
13  `country` VARCHAR(40) NOT NULL,
14  PRIMARY KEY (`make_id`)
15) ENGINE=InnoDB;
16
17DROP TABLE IF EXISTS `Vehicle`;
18CREATE TABLE `Vehicle` (
19  `vehicle_id` INT(10) NOT NULL AUTO_INCREMENT,
20  `fk_make_id` INT(10) DEFAULT NULL,
21  `fk_model_id` INT(10) DEFAULT NULL,
22  `year` INT(4) NOT NULL,
23  PRIMARY KEY (`vehicle_id`),
24  KEY `fk_make_id` (`fk_make_id`)
25--   CONSTRAINT `fk_make_vehicle` FOREIGN KEY (`fk_make_id`) REFERENCES `make` (`make_id`),
26--   CONSTRAINT `fk_model_vehicle` FOREIGN KEY (`fk_model_id`) REFERENCES `model` (`model_id`)
27) ENGINE=InnoDB;
28
29INSERT INTO `Model` (`model_name`, `first_production_year`) VALUES ('Putt-putt', 1976);
30INSERT INTO `Model` (`model_name`, `first_production_year`) VALUES ('Gofast', 1976);
31INSERT INTO `Model` (`model_name`, `first_production_year`) VALUES ('Turbo', 1976);
32INSERT INTO `Model` (`model_name`, `first_production_year`) VALUES ('Zoooooom', 1982);
33
34INSERT INTO `Make` (`make_name`, `country`) VALUES ('Doge', 'USA');
35INSERT INTO `Make` (`make_name`, `country`) VALUES ('Buck', 'USA');
36
37INSERT INTO `Vehicle` (`fk_make_id`, `fk_model_id`, `year`) VALUES (1, 1, 1979);
38INSERT INTO `Vehicle` (`fk_make_id`, `fk_model_id`, `year`) VALUES (1, 1, 1978);
39INSERT INTO `Vehicle` (`fk_make_id`, `fk_model_id`, `year`) VALUES (1, 2, 1977);
40INSERT INTO `Vehicle` (`fk_make_id`, `fk_model_id`, `year`) VALUES (1, 2, 1976);
41INSERT INTO `Vehicle` (`fk_make_id`, `fk_model_id`, `year`) VALUES (1, 2, 1976);
42INSERT INTO `Vehicle` (`fk_make_id`, `fk_model_id`, `year`) VALUES (2, 3, 2003);
43INSERT INTO `Vehicle` (`fk_make_id`, `fk_model_id`, `year`) VALUES (2, 4, 2019);
44INSERT INTO `Vehicle` (`fk_make_id`, `fk_model_id`, `year`) VALUES (2, 4, 1994);