1kaUWmvi

1CREATE DATABASES database2;
2USE database2;
3
4DROP TABLES IF EXISTS authors
5CREATE TABLE authors (
6authorID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, 
7firstname VARCHAR(256),
8lastname VARCHAR(256), 
9);
10
11DROP TABLES IF EXISTS books
12CREATE TABLE books (
13bookID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, 
14title VARCHAR(256),
15isbn VARCHAR(256),
16editionID int not null,
17FOREIGN KEY fk_editionID(editionID)
18REFERENCES editions(editionID)
19ON UPDATE CASCADE
20ON DELETE RESTRICT
21);
22
23DROP TABLES IF EXISTS editions
24CREATE TABLE editions (
25editionID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
26publisher VARCHAR(256),
27yearofpublication DATE,
28locationofpublication VARCHAR(256),
29);
30
31
32DROP TABLES IF EXISTS authors_books
33CREATE TABLE authors_books (
34authors_booksID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
35bookID int not null,
36FOREIGN KEY fk_bookID(bookID)
37REFERENCES books(bookID)
38ON UPDATE CASCADE
39ON DELETE RESTRICT
40authorID int not null,
41FOREIGN KEY fk_authorID(authorID)
42REFERENCES authors(authorID)
43ON UPDATE CASCADE
44ON DELETE RESTRICT
45);