MW1Wx8bM

1 1 create database if not exists aaa_book;
2  2 
3  3 use aaa_book;
4  4 
5  5 create table if not exists user (
6  6     id int auto_increment primary key not null,
7  7     email varchar(128) not null,
8  8     username varchar(64) not null,
9  9     password varchar(32) not null,
10 10     address varchar(255) not null,
11 11     city varchar(255) not null,
12 12     state varchar(2) not null,
13 13     zip varchar(5) not null
14 14 ) engine=innodb default CHARSET=utf8;
15 15 
16 16 create table if not exists book (
17 17     id int auto_increment primary key not null,
18 18     user_id int not null,
19 19     title varchar(128) not null,
20 20     index uid (user_id),
21 21     foreign key (user_id) references user(id) on delete cascade
22 22 ) engine=inndb default charset=utf8;
23 23 
24 24 create table if not exists page (
25 25     id int auto_increment primary key not null,
26 26     book_id int not null,
27 27     index bid (book_id),
28 28     foreign key (book_id) references book(id) on delete cascade
29 29 ) engine=innodb default charset=utf8;