sql-script.txt

create database bookswap;

use bookswap;

create table users (
	id int not null auto_increment key,
	name varchar(80),
	email varchar(80) not null unique,
	password varchar(255) not null
);

create table books (
	bookid int not null auto_increment key,
	title varchar(255) not null,
	author varchar(80) not null,
	ownerid int not null,
	isbn varchar(13),
	status int not null
);

insert into users
	(name, email, password)
	values
	('Deb','stoddard@drexel.edu', PASSWORD('password')),
	('Ed', 'ecallaghan93@gmail.com', PASSWORD('password')),
	('Dhantha', 'dhanthag@gmail.com', PASSWORD('password')),
	('Yongchang', 'yc552@drexel.edu', PASSWORD('password'));

insert into books
	(title, author, ownerid, isbn, status)
	values
	('Portraits of Courage', 'George W. Bush', 1, 1138218251, 0),
	('Hidden Figures', 'Margot Lee Shetterly', 1, 9781603094054, 0),
	('A Dog\'s Purpose', 'W. Bruce Cameron', 1, 827714010046, 1),
	('A Dog\'s Purpose', 'W. Bruce Cameron', 2, 827714010046, 0),
	('The Underground Railroad', 'Colson Whitehead', 1, 9781603093682, 1),
	('Banana Cream Pie Murder', 'Joanne Fluke', 1, 9781603093255, 0),
	('Banana Cream Pie Murder', 'Joanne Fluke', 2, 9781603093255, 1),
	('Dereliction of Duty', 'H. R. McMaster', 2, 9781603093668, 0),
	('Echoes in Death', 'J.D. Robb', 2, 0681203093255, 1),
	('Lincoln in the Bardo', 'George Saunders', 3, 3800013093255, 1),
	('Hidden Figures', 'Margot Lee Shetterly', 3, 9781603094054, 0),
	('The Underground Railroad', 'Colson Whitehead', 3, 9781603093682, 1),
	('A Dog\'s Purpose', 'W. Bruce Cameron', 3, 827714010046, 0),
	('Lion', 'Saroo Brierley', 4, 3844203093255, 1),
	('Lion', 'Saroo Brierley', 3, 3844203093255, 1),
	('Lion', 'Saroo Brierley', 2, 3844203093255, 1),
	('Lion', 'Saroo Brierley', 1, 3844203093255, 0),
	('Banana Cream Pie Murder', 'Joanne Fluke', 4, 9781603093255, 1),
	('A Dog\'s Purpose', 'W. Bruce Cameron', 4, 827714010046, 1),
	('Dereliction of Duty', 'H. R. McMaster', 4, 9781603093668, 1),
	('The Zookeeper\'s Wife', 'Diane Ackerman', 4, 9799103093391, 1);