/*
REM
REM
REM Movie-ins.sql
REM
REM
*/

SELECT current_schema();
SET search_path to "movies";

INSERT INTO Movie
  VALUES('Mulan', 1998, 120, 'color', 'Disney', 276); 

INSERT INTO Movie
  VALUES('Apollo 13', 1995, 140, 'color', 'MCA/Universal Pictures', 817);

INSERT INTO Movie
  VALUES('Forrest Gump', 1994, 142, 'color', 'Paramount', 1212);

INSERT INTO Movie
  VALUES('Schindler''s List', 1993, 197, 'BW', 'MCA/Universal Pictures', 817);

INSERT INTO Movie
  VALUES('The Color Purple', 1985, 152, 'color', 'Warner Bros.', 1212);

INSERT INTO Movie
  VALUES('Flubber', 1998, 93, 'color', 'Disney', 276);

INSERT INTO Movie
  VALUES('Good Will Hunting', 1997, 126, 'color', 'Be Gentlemen Limited Partnership', 3002);

INSERT INTO Movie
  VALUES('Bullets Over Broadway', 1994, 98, 'color', 'Miramax', 413);

INSERT INTO Movie
  VALUES('Emma', 1996, 121, 'color', 'Haft Entertainment', 789);

INSERT INTO Movie
  VALUES('Chicago', 2002, 113, 'color', 'Miramax', 413);
      
INSERT INTO Movie
  VALUES('Gladiator', 2000, 155, 'color', 'Dreamworks', 3009);
   
INSERT INTO Movie
  VALUES('Pieces of April', 2003, 80, 'color', 'United Artists', 123);
  
INSERT INTO Movie
  VALUES('Dark Blue', 2002, 118, 'color', 'United Artists', 123);
  
INSERT INTO Movie
  VALUES('Ben Hur', 1959, 212, 'color', 'United Artists', 123);
  
INSERT INTO Movie
  VALUES('Toy Story', 1995, 81, 'color', 'Pixar', 975);
  
INSERT INTO Movie
  VALUES('Titanic', 2000, 194, 'color', 'Paramount', 1212);
  
INSERT INTO Movie
  VALUES('Bad Boys II', 2003, 147, 'color', 'Columbia Pictures', 432);
  
INSERT INTO Movie
  VALUES('Finding Nemo', 2003, 100, 'color', 'Disney', 276);
  
INSERT INTO Movie
  VALUES('The Terminal', 2004, 128, 'color', 'Dreamworks', 3009);
  
INSERT INTO Movie
  VALUES('I, Robot', 2004, 115, 'color', '20th Century Fox', 2020);

INSERT INTO Movie
  VALUES('Little Mermaid The Sequel', 2004, 121, 'color', 'Disney', 789);

INSERT INTO Movie
  VALUES('Shrek', 2002, 121, 'color', 'Disney', 789);

INSERT INTO Movie
  VALUES('Bambi', 1993, 140, 'color', 'Disney', 789);