cQaW4ZZZ

1DROP TABLE IF EXISTS Books, Authors;
2
3CREATE TABLE IF NOT EXISTS Authors(Id INT PRIMARY KEY AUTO_INCREMENT, 
4    Name VARCHAR(25)) ENGINE=INNODB;
5
6INSERT INTO Authors(Id, Name) VALUES(1, 'Jack London');
7INSERT INTO Authors(Id, Name) VALUES(2, 'Honore de Balzac');
8INSERT INTO Authors(Id, Name) VALUES(3, 'Lion Feuchtwanger');
9INSERT INTO Authors(Id, Name) VALUES(4, 'Emile Zola');
10INSERT INTO Authors(Id, Name) VALUES(5, 'Truman Capote');
11
12CREATE TABLE IF NOT EXISTS Books(Id INT PRIMARY KEY AUTO_INCREMENT, 
13    AuthorId INT, Title VARCHAR(100), 
14    FOREIGN KEY(AuthorId) REFERENCES Authors(Id) ON DELETE CASCADE)
15    ENGINE=INNODB;
16
17INSERT INTO Books(Id, AuthorId, Title) VALUES(1, 1, 'Call of the Wild');
18INSERT INTO Books(Id, AuthorId, Title) VALUES(2, 1, 'Martin Eden');
19INSERT INTO Books(Id, AuthorId, Title) VALUES(3, 2, 'Old Goriot');
20INSERT INTO Books(Id, AuthorId, Title) VALUES(4, 2, 'Cousin Bette');
21INSERT INTO Books(Id, AuthorId, Title) VALUES(5, 3, 'Jew Suess');
22INSERT INTO Books(Id, AuthorId, Title) VALUES(6, 4, 'Nana');
23INSERT INTO Books(Id, AuthorId, Title) VALUES(7, 4, 'The Belly of Paris');
24INSERT INTO Books(Id, AuthorId, Title) VALUES(8, 5, 'In Cold blood');
25INSERT INTO Books(Id, AuthorId, Title) VALUES(9, 5, 'Breakfast at Tiffany');