create database myvids;

GRANT ALL ON myvids.* TO 'admin'@'localhost' IDENTIFIED BY 'admin';

use myvids;

CREATE TABLE members
( membid int(10) unsigned not null auto_increment primary key,
name char(40) not null,
address char(50) not null,
city char(20) not null,
state char(2) not null,
zip char(5) not null,
email char(30) not null,
phone char(12) not null
);

CREATE TABLE movies
( movid int(10) unsigned not null auto_increment primary key,
title char(120) not null,
rating char(5) not null,
released year(4) not null,
actors text not null,
subject char(30),
borrowed bool not null
);


CREATE TABLE lends
( lendid int(10) unsigned not null auto_increment primary key,
movid int(15) not null,
email char(40) not null,
brdate date not null,
borrowed bool not null
);