create table items
(
	id int auto_increment
		primary key,
	title varchar(150) not null,
	photoLocation varchar(30) not null,
	description varchar(2000) not null,
	reportedBy varchar(16) not null,
	dateReported varchar(30) not null,
	location varchar(16) not null,
	constraint items_id_uindex
		unique (id),
	constraint items_photoLocation_uindex
		unique (photoLocation)
)
;

create table requests
(
	id int auto_increment
		primary key,
	dateRequested varchar(30) not null,
	requestedBy varchar(16) not null,
	itemID int not null,
	reason varchar(2000) not null,
	constraint requests_id_uindex
		unique (id)
)
;

create table users
(
	username varchar(16) not null
		primary key,
	hashedPassword varchar(200) not null,
	email varchar(255) not null,
	constraint users_username_uindex
		unique (username)
)
;