· 8 years ago · Aug 13, 2018, 10:58 AM
1CREATE TABLE if not exists authors(
2-> author_id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
3-> name VARCHAR(30)
4);
5
6CREATE TABLE if not exists books(
7-> book_id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
8-> title VARCHAR(255),
9-> genre VARCHAR(30),
10-> FOREIGN KEY(author_id) REFERENCES authors(author_id)
11);