# DATA FOR DREAMWEAVER CLASS

CREATE TABLE actors (
  actor_id int(10) unsigned NOT NULL auto_increment,
  firstname varchar(50) default NULL,
  lastname varchar(50) default NULL,
  status varchar(50) default NULL,
  PRIMARY KEY  (actor_id)
) TYPE=InnoDB;

INSERT INTO actors VALUES("1", "Chevy", "Chase", "active");
INSERT INTO actors VALUES("2", "Randy", "Quaid", "active");
INSERT INTO actors VALUES("3", "Julie", "Haggerty", "active");
INSERT INTO actors VALUES("4", "Bill", "Murray", "active");
INSERT INTO actors VALUES("5", "Tom", "Hanks", "active");
INSERT INTO actors VALUES("6", "Kevin", "Costner", "active");
INSERT INTO actors VALUES("7", "Dustin", "Hoffman", "active");
INSERT INTO actors VALUES("8", "Matt", "Damon", "active");
INSERT INTO actors VALUES("9", "Mel", "Brooks", "active");
INSERT INTO actors VALUES("10", "Barbara", "Streisand", "active");
INSERT INTO actors VALUES("11", "Julia", "Roberts", "active");
INSERT INTO actors VALUES("12", "Ben", "Stiller", "active");
INSERT INTO actors VALUES("13", "Jason", "Biggs", "active");
INSERT INTO actors VALUES("14", "Russell", "Crowe", "active");
INSERT INTO actors VALUES("15", "Will", "Smith", "active");
INSERT INTO actors VALUES("16", "Cuba", "Gooding", "active");
INSERT INTO actors VALUES("17", "Nicholas", "Cage", "active");
INSERT INTO actors VALUES("19", "John", "Candy", "active");
INSERT INTO actors VALUES("20", "Tim", "Roth", "active");
INSERT INTO actors VALUES("21", "Jimmy", "Stewart", "active");
INSERT INTO actors VALUES("22", "Natalie", "Wood", "active");
INSERT INTO actors VALUES("23", "Cary", "Grant III", "active");
INSERT INTO actors VALUES("24", "Meryl", "Streep", "active");
INSERT INTO actors VALUES("25", "Brad", "Pitt", "active");


CREATE TABLE movies (
  movie_id int(10) unsigned NOT NULL auto_increment,
  name varchar(50) default NULL,
  genre varchar(50) default NULL,
  actor_id int(11) default NULL,
  status varchar(50) default NULL,
  review varchar(50) default NULL,
  PRIMARY KEY  (movie_id)
) TYPE=InnoDB;



INSERT INTO movies VALUES("2", "Airplane!", "comedy", "3", "active", "This is the review for Airplane!");
INSERT INTO movies VALUES("4", "All the Presidents Men", "true story", "7", "active", "This is the review for All the Presidents Men");
INSERT INTO movies VALUES("16", "Beautiful Mind, A", "drama", "14", "active", "This is the review for Beautiful Mind, A");
INSERT INTO movies VALUES("36", "Airplane!", "drama", "6", "active", "This is the review for Airplane!11111");
INSERT INTO movies VALUES("44", "Erin Brokovich", "true story", "11", "active", "This is the review for Erin Brokovich");
INSERT INTO movies VALUES("48", "Forrest Gump", "comedy", "5", "active", "This is the review for Forrest Gump");
INSERT INTO movies VALUES("50", "Funny Girl", "musical", "10", "active", "This is the review for Funny Girl");
INSERT INTO movies VALUES("59", "Good Will Hunting", "drama", "8", "active", "This is the review for Good Will Hunting!!");
INSERT INTO movies VALUES("65", "Groundhog Day", "comedy", "4", "active", "This is the review for Groundhog Day");
INSERT INTO movies VALUES("72", "History of the World", "comedy", "9", "active", "This is the review for History of the World");
INSERT INTO movies VALUES("81", "It\'s a Wonderful Life", "drama", "21", "active", "This is the review for It\'s a Wonderful Life");
INSERT INTO movies VALUES("102", "Meet the Parents", "comedy", "12", "active", "This is the review for Meet the Parents");
INSERT INTO movies VALUES("103", "Men in Black", "comedy", "15", "active", "This is the review for Men in Black");
INSERT INTO movies VALUES("104", "Men in Black II", "comedy", "15", "active", "This is the review for Men in Black II");
INSERT INTO movies VALUES("105", "Men of Honor", "drama", "16", "active", "This is the review for Men of Honor");
INSERT INTO movies VALUES("115", "Mystic Pizza!!", "comedy", "11", "active", "This is the review for Mystic Pizza!!!");
INSERT INTO movies VALUES("116", "North By Northwest", "drama", "23", "active", "This is the review for North By Northwest");
INSERT INTO movies VALUES("122", "Out of Africa", "drama", "24", "active", "This is the review for Out of Africa");
INSERT INTO movies VALUES("137", "Raising Arizona", "comedy", "17", "active", "This is the review for Raising Arizona");
INSERT INTO movies VALUES("139", "Rear Window", "mystery", "21", "active", "This is the review for Rear Window");
INSERT INTO movies VALUES("140", "Resevoir Dogs", "comedy", "20", "active", "This is the review for Resevoir Dogs");
INSERT INTO movies VALUES("158", "Sound of Music, The", "musical", "18", "active", "This is the review for Sound of Music, The");
INSERT INTO movies VALUES("177", "Uncle Buck", "comedy", "19", "active", "This is the review for Uncle Buck");
INSERT INTO movies VALUES("178", "Vacation", "comedy", "1", "active", "This is the review for Vacation");
INSERT INTO movies VALUES("179", "Vertigo", "mystery", "21", "active", "This is the review for Vertigo");
INSERT INTO movies VALUES("180", "Wag the Dog", "comedy", "7", "active", "This is the review for Wag the Dog");
INSERT INTO movies VALUES("184", "West Side Story", "musical", "22", "active", "This is the review for West Side Story");
INSERT INTO movies VALUES("189", "Young Frankenstein", "comedy", "9", "active", "This is the review for Young Frankenstein");
