create database markvids;

use markvids;

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

CREATE TABLE movies
( movid int(10) unsigned not null auto_increment primary key,
title char(50) not null,
rating char(5) not null,
released year(4) not null,
actors text not null,
subject char(12),
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
);



insert into members values
(null, 'Smith, Tim', '12 Elm St', 'Tampa', 'FL', '34567', 'tsmith@aol.com', '555-555-1212'),
(null, 'Jones, Tom', '435 Oak Dr', 'Dunedin', 'FL', '33245', 'tjones@comcast.com', '555-555-1212'),
(null, 'Avery, BIll', '623 Ash Ave', 'Clearwater', 'FL', '33655', 'bavery@msn.com', '555-555-1212'),
(null, 'Kerr, Debra', '1573 Yew Crt', 'Clearwater', 'FL', '33442', 'dkerr@aol.com', '555-555-1212');

insert into movies values
(null,'Deepstar 6', 'PG', 1989, 'Taurean Blacque, Nancy Everhard, Greg Evigan, Miguel Ferrer, Nia Peeples', 'Sci-Fi', false ),
(null,'The First Power', 'R', 1990, 'Lou Diamond Phillips, Tracy Griffith, Jeff Kober, Mykelti Williamson, Elizabeth Arlen', 'Horror', false ),
(null,'Boomerang', 'R', 1992, 'Eddie Murphy, Robin Givens, Halle Berry, David Alan Grier, Martin Lawrence, Grace Jones, Geoffrey Holder, Chris Rock', 'Comedy', false ),
(null,'Monty Python and the Holy Grail', 'PG', 1975, 'Graham Chapman, John Cleese, Eric Idle, Terry Gilliam, Terry Jones, Michael Palin', 'Comedy', false ),
(null,'Caddy Shack', 'R', 1980, 'Chevy Chase, Rodney Dangerfield, Ted Knight, Michael O''Keefe, Bill Murray, Bryan Doyle Murray', 'Comedy', false ),
(null,'Prince of Darkness', 'R', 1987, 'Donald Pleasence, Jameson Parker, Victor Wong, Lisa Blount, Dennis Dun, Susan Blanchard, Anne Marie Howard, Ann Yen, Ken Wright, Dirk Blocker, Jessie Lawrence Ferguson, Peter Jason, Robert Grasmere, Thom Bray, Joanna Merlin, Alice Cooper, Betty Ramey, Jessie Ferguson', 'Horror', false ),
(null,'Stand By Me', 'R', 1986, 'Wil Wheaton, River Phoenix, Corey Feldman, Jerry O''Connell, Kiefer Sutherland, Casey Siemaszko, Gary Riley, Bradley Gregg, Jason Oliver, Marshall Bell, Frances Lee McCain, Bruce Kirby, William Bronder, Scott Beach, Richard Dreyfuss, John Cusack, Madeleine Swift, Popeye, Geanette Bobst, Art Burke, Matt Williams, Andy Lindberg, Dick Durock, O.B. Babbs, Charlie Owens, Kenneth Hodges, John Hodges, Susan Thorpe, Korey Scott Pollard, Rick Elliott, Kent Lutrell, Chance Quinn, Jason Naylor', 'Drama', false );