create table eofrecipe (
	rid int not null primary key auto_increment,
	rname varchar(100) not null,
	rdescription varchar(255) not null,
	rdirections mediumtext not null,
	rserved int not null,
	rtime int not null,
	rdate date not null,
	uid int not null,
	cid int not null
);

create table eofcategory (
	cid int not null primary key auto_increment,
	cname varchar(30) not null
);

insert into eofcategory(cname) values('Appetizers and Snacks');
insert into eofcategory(cname) values('Beverages');
insert into eofcategory(cname) values('Breads');
insert into eofcategory(cname) values('Desserts');
insert into eofcategory(cname) values('Meats');
insert into eofcategory(cname) values('Pastas');
insert into eofcategory(cname) values('Soups and Stews');
insert into eofcategory(cname) values('Vegtables');


create table eofimage (
	imid int not null primary key auto_increment,
	ipath varchar(100) not null,
	iname varchar(50) not null,
	rid int not null
);

create table eofuser (
	uid int not null primary key auto_increment,
	ulogin varchar(20) not null unique,
	ufname varchar(20) not null,
	ulname varchar(30) not null,
	uemail varchar(50) not null unique,
	upass varchar(30) not null
);

create table eofrating (
	uid int not null,
	rid int not null,
	rascore int not null,
	radate datetime not null,
	racomment varchar(255) not null,
	primary key(uid, rid)
);

create table eoffavorite (
	uid int not null,
	rid int not null,
	primary key(uid, rid)
);

create table eofingredient (
	iid int not null primary key auto_increment,
	iname varchar(50) not null,
	iamount varchar(15) unsigned not null,
	unid int not null,
	rid int not null
);

create table eofunit (
	unid int not null primary key auto_increment,
	uname varchar(30) not null
);

insert into eofunit(uname) values('');
insert into eofunit(uname) values('bushel');
insert into eofunit(uname) values('can');
insert into eofunit(uname) values('cup');
insert into eofunit(uname) values('dash');
insert into eofunit(uname) values('drop');
insert into eofunit(uname) values('fluid ounce');
insert into eofunit(uname) values('gallon');
insert into eofunit(uname) values('gram');
insert into eofunit(uname) values('handfull');
insert into eofunit(uname) values('head');
insert into eofunit(uname) values('kilogram');
insert into eofunit(uname) values('liter');
insert into eofunit(uname) values('milliliter');
insert into eofunit(uname) values('ounce');
insert into eofunit(uname) values('package');
insert into eofunit(uname) values('peck');
insert into eofunit(uname) values('pint');
insert into eofunit(uname) values('pound');
insert into eofunit(uname) values('quart');
insert into eofunit(uname) values('tablespoon');
insert into eofunit(uname) values('teaspoon');