BAc6vkLw

1CREATE TABLE parking2.2Polygon IF NOT EXISTS(
2	polygon_id INT NOT NULL AUTO_INCREMENT,
3	population, INT NOT NULL,
4	available_parkings INT NOT NULL,
5	PRIMARY KEY(polygon_id)
6) engine = InnoDB;
7
8
9CREATE TABLE parking2.Coordinate IF NOT EXISTS(
10	coordinate_id INT NOT NULL AUTO_INCREMENT,
11	polygon INT NOT NULL,
12
13	PRIMARY KEY(coordinate_id)
14	FOREIGN KEY(polygon) REFERENCES polygon(polygon_id)
15) engine = InnoDB;