DB Schema

mysql>describe books;

Field	Type	Null	Key	Default	Extra
id	int(11)		PRI	NULL	auto_increment
title	varchar(200)	YES		NULL
author	varchar(100)	YES		NULL
price	int(11)	YES		NULL

mysql>describe cc_transactions;

Field	Type	Null	Key	Default	Extra
id	int(11)		PRI	NULL	auto_increment
result	int(11)	YES		NULL
user_id	int(11)	YES		NULL
order_id	int(11)	YES		NULL

mysql>describe cc_types;

Field	Type	Null	Key	Default	Extra
id	int(11)		PRI	NULL	auto_increment
type	varchar(20)	YES		NULL

mysql>describe orders;

Field	Type	Null	Key	Default	Extra
id	int(11)		PRI	NULL	auto_increment
user_id	int(11)	YES		NULL
book_id	int(11)	YES		NULL
quantity	int(11)	YES		NULL
total	int(11)	YES		NULL
time_created	datetime	YES		NULL

mysql>describe release_info;

Field	Type	Null	Key	Default	Extra
build_id	varchar(50)	YES		NULL
db_version	varchar(10)	YES		NULL

mysql>describe users;

Field	Type	Null	Key	Default	Extra
id	int(11)		PRI	NULL	auto_increment
first_name	varchar(50)	YES		NULL
last_name	varchar(50)	YES		NULL
email	varchar(50)	YES		NULL
password	varchar(10)	YES		NULL
zip_code	varchar(10)	YES		NULL
street	varchar(50)	YES		NULL
city	varchar(50)	YES		NULL
state	char(3)	YES		NULL
country	varchar(50)	YES		NULL
time_created	datetime	YES		NULL