--
-- Create tables
--

CREATE TABLE ACTORS (
  ACTORID INT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 21) CONSTRAINT ACTORS_PK PRIMARY KEY,
  NAMEFIRST CHAR(50) NOT NULL,
  NAMELAST CHAR(50) NOT NULL,
  AGE SMALLINT NOT NULL,
  NAMEFIRSTREAL CHAR(50) NOT NULL,
  NAMELASTREAL CHAR(50) NOT NULL,
  AGEREAL SMALLINT NOT NULL,
  ISEGOMANIAC SMALLINT NOT NULL,
  ISTOTALBABE SMALLINT NOT NULL,
  GENDER CHAR(1) NOT NULL
);


CREATE TABLE CONTACTS (
  CONTACTID INT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 6) CONSTRAINT CONTACTS_PK PRIMARY KEY,
  FIRSTNAME CHAR(50) NOT NULL,
  LASTNAME CHAR(50) NOT NULL,
  ADDRESS CHAR(100),
  CITY CHAR(50),
  STATE CHAR(5),
  ZIP CHAR(10),
  COUNTRY CHAR(50),
  EMAIL CHAR(100),
  PHONE CHAR(50),
  USERLOGIN CHAR(50),
  USERPASSWORD CHAR(50),
  MAILINGLIST SMALLINT,
  USERROLEID INT
);


CREATE TABLE DIRECTORS (
  DIRECTORID INT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 14) CONSTRAINT DIRECTORS_PK PRIMARY KEY,
  FIRSTNAME CHAR(50) NOT NULL,
  LASTNAME CHAR(50) NOT NULL
);

CREATE TABLE EXPENSES (
  EXPENSEID INT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 53) CONSTRAINT EXPENSES_PK PRIMARY KEY,
  FILMID INT NOT NULL,
  EXPENSEAMOUNT REAL NOT NULL,
  DESCRIPTION CHAR(100) NOT NULL,
  EXPENSEDATE DATE NOT NULL
);

CREATE TABLE FILMS (
  FILMID INT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 24) CONSTRAINT FILMS_PK PRIMARY KEY,
  MOVIETITLE CHAR(254) NOT NULL,
  PITCHTEXT CHAR(100) NOT NULL,
  AMOUNTBUDGETED REAL,
  RATINGID INT,
  SUMMARY VARCHAR(32672),
  IMAGENAME CHAR(50),
  DATEINTHEATERS DATE
);

CREATE TABLE FILMSACTORS (
  FARECID INT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 54) CONSTRAINT FILMSACTORS_PK PRIMARY KEY,
  FILMID INT NOT NULL,
  ACTORID INT NOT NULL,
  ISSTARRINGROLE SMALLINT NOT NULL,
  SALARY REAL NOT NULL
);

CREATE TABLE FILMSDIRECTORS (
  FDRECID INT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 32) CONSTRAINT FILMSDIRECTORS_PK PRIMARY KEY,
  FILMID INT NOT NULL,
  DIRECTORID INT NOT NULL,
  SALARY REAL NOT NULL
);

CREATE TABLE FILMSRATINGS (
  RATINGID INT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 7) CONSTRAINT FILMSRATINGS_PK PRIMARY KEY,
  RATING CHAR(50) NOT NULL
);

CREATE TABLE MERCHANDISE (
  MERCHID INT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 14) CONSTRAINT MERCHANDISE_PK PRIMARY KEY,
  FILMID INT NOT NULL,
  MERCHNAME CHAR(50) NOT NULL,
  MERCHDESCRIPTION CHAR(100),
  MERCHPRICE REAL NOT NULL,
  IMAGENAMESMALL CHAR(50),
  IMAGENAMELARGE CHAR(50)
);

CREATE TABLE MERCHANDISEORDERS (
  ORDERID INT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 4) CONSTRAINT MERCHANDISEORDERS_PK PRIMARY KEY,
  CONTACTID INT NOT NULL,
  ORDERDATE DATE NOT NULL,
  SHIPADDRESS CHAR(100),
  SHIPCITY CHAR(50),
  SHIPSTATE CHAR(5),
  SHIPZIP CHAR(10),
  SHIPCOUNTRY CHAR(50),
  SHIPDATE DATE
);

CREATE TABLE MERCHANDISEORDERSITEMS (
  ORDERITEMID INT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 7) CONSTRAINT MERCHANDISEORDERSITEMS_PK PRIMARY KEY,
  ORDERID INT NOT NULL,
  ITEMID INT NOT NULL,
  ORDERQTY INT NOT NULL,
  ITEMPRICE REAL NOT NULL
);

CREATE TABLE USERROLES (
  USERROLEID INT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 6) CONSTRAINT USERROLES_PK PRIMARY KEY,
  USERROLENAME CHAR(20) NOT NULL,
  USERROLEFUNCTION CHAR(75) NOT NULL
);



--
-- Define foreign keys
--

ALTER TABLE CONTACTS ADD CONSTRAINT CONTACTS_FK FOREIGN KEY (USERROLEID) REFERENCES USERROLES (USERROLEID);
ALTER TABLE EXPENSES ADD CONSTRAINT EXPENSES_FK FOREIGN KEY (FILMID) REFERENCES FILMS (FILMID);
ALTER TABLE FILMS ADD CONSTRAINT FILMS_FK FOREIGN KEY (RATINGID) REFERENCES FILMSRATINGS (RATINGID);
ALTER TABLE FILMSACTORS ADD CONSTRAINT FILMSACTORS_FK1 FOREIGN KEY (FILMID) REFERENCES FILMS (FILMID);
ALTER TABLE FILMSACTORS ADD CONSTRAINT FILMSACTORS_FK2 FOREIGN KEY (ACTORID) REFERENCES ACTORS (ACTORID);
ALTER TABLE FILMSDIRECTORS ADD CONSTRAINT FILMSDIRECTORS_FK1 FOREIGN KEY (FILMID) REFERENCES FILMS (FILMID);
ALTER TABLE FILMSDIRECTORS ADD CONSTRAINT FILMSDIRECTORS_FK2 FOREIGN KEY (DIRECTORID) REFERENCES DIRECTORS (DIRECTORID);
ALTER TABLE MERCHANDISE ADD CONSTRAINT MERCHANDISE_FK FOREIGN KEY (FILMID) REFERENCES FILMS (FILMID);
ALTER TABLE MERCHANDISEORDERS ADD CONSTRAINT MERCHANDISEORDERS_FK FOREIGN KEY (CONTACTID) REFERENCES CONTACTS (CONTACTID);
ALTER TABLE MERCHANDISEORDERSITEMS ADD CONSTRAINT MERCHANDISEORDERSITEMS_FK1 FOREIGN KEY (ORDERID) REFERENCES MERCHANDISEORDERS (ORDERID);
ALTER TABLE MERCHANDISEORDERSITEMS ADD CONSTRAINT MERCHANDISEORDERSITEMS_FK2 FOREIGN KEY (ITEMID) REFERENCES MERCHANDISE (MERCHID);



--
-- Insert data
--

INSERT INTO Actors(ActorID, NameFirst, NameLast, Age, NameFirstReal, NameLastReal, AgeReal, IsEgomaniac, IsTotalBabe, Gender)
  VALUES(1, 'Sean', 'Conway', 56, 'Sean', 'Sean Conway', 66, 1, 0, 'M'),
        (2, 'Harry', 'Fjord', 52, 'Harrison', 'Fjord', 52, 0, 0, 'M'),
        (3, 'Pam', 'Andrewson', 21, 'Mary Margaret Catherine Angela', 'Andrewson', 38, 1, 1, 'F'),
        (4, 'Kevin', 'Space', 30, 'Kevin', 'Spacedout', 35, 0, 0, 'M'),
        (5, 'Uno', 'Thorman', 26, 'Unaslava', 'Toradorsky', 26, 0, 0, 'F'),
        (6, 'Sam', 'Gold', 44, 'Samuel', 'Goldenberg', 44, 0, 0, 'M'),
        (7, 'Patrik', 'Sway', 40, 'Patik', 'Swap', 40, 1, 1, 'M'),
        (8, 'Fabio', '', 35, 'N.', 'Butter', 25, 1, 1, 'M'),
        (9, 'Albert', 'Books', 45, 'Albert', 'Einstein', 45, 0, 0, 'M'),
        (10, 'Sharon', 'Stoned', 22, 'Sharin', 'Bones', 19, 1, 1, 'F'),
        (11, 'Robbie', 'Berry', 29, 'Robbie', 'Berry', 28, 0, 1, 'F'),
        (12, 'L.L.', 'P.J.', 35, 'R.U.', 'Tired', 47, 1, 0, 'M'),
        (13, 'Ferris', 'Beuller', 18, 'Matthew', 'Brocovich', 30, 0, 0, 'M'),
        (14, 'Nick', 'Nutty', 48, 'Nicolas', 'Nicolby', 43, 1, 1, 'M'),
        (15, 'Dolly', 'Pardon', 41, 'Denise', 'Grande', 61, 0, 0, 'F'),
        (16, 'Halle', 'Beary', 23, 'Halle', 'Barrely', 33, 0, 1, 'F'),
        (17, 'Nicole', 'Kidmen', 22, 'Nicolas', 'Kidmen', 29, 1, 1, 'M'),
        (18, 'Belinda', 'Foxile', 21, 'Stephanie', 'Hawkins', 31, 0, 1, 'F'),
        (19, 'William', 'Shitener', 50, 'William', 'Klingon', 65, 1, 0, 'M'),
        (20, 'Carlease', 'Theron', 25, 'T.R.', 'Ouble', 26, 0, 1, 'F');

INSERT INTO Directors(DirectorID, FirstName, LastName)
  VALUES(1, 'Alfred', 'Hitchhike'),
        (2, 'Stanley', 'Rubric'),
        (3, 'George', 'Locust'),
        (4, 'Cecile', 'Deville'),
        (5, 'Rob', 'Refiner'),
        (6, 'Steven', 'Iceberg'),
        (7, 'Kathleen', 'Kidney'),
        (8, 'Ivan', 'Rightman'),
        (9, 'Francis', 'Copulate'),
        (10, 'Riddle E.', 'Scott'),
        (11, 'Woody', 'Talon'),
        (12, 'John', 'Who'),
        (13, 'Jeanmarie', 'Williams');

INSERT INTO UserRoles(UserRoleID, UserRoleName, UserRoleFunction)
  VALUES(1, 'Admin', 'Provides user access to all system functions'),
        (2, 'Marketing', 'Provides user access to marketing functions'),
        (3, 'Operations', 'Provides user access to operational functions'),
        (4, 'Acting', 'Enables user to get job waiting tables in W. Hollywood'),
        (5, 'User', 'Provides access to basic system functions');

INSERT INTO Contacts(ContactID, FirstName, LastName, Address, City, State, Zip, Country, Email, Phone, UserLogin, UserPassword, MailingList, UserRoleID)
  VALUES(1, 'Robert', 'Bobson', '1000 Avenue B', 'Palo Alto', 'CA', '94303', 'USA', 'bob@bob.x', '408-555-1111', 'bob', 'bobbyboy', 1, 5),
        (2, 'Jean', 'Jones', '1 Rue Street', 'Brussels', '', '1234', 'Belgium', 'jean@be', '322-700-0000', 'jean', 'jeanyves', 1, 5),
        (3, 'Rick', 'Richards', '22 The Way', 'London', '', 'E10', 'England', 'rr@abcdefg.london.co.uk', '207-123-4567', '', '', 0, 5),
        (4, 'Ben', 'Forta', '2000 Town Center, Suite 1900', 'Southfield', 'MI', '48075', 'USA', 'ben@forta.com', '', 'ben', 'forta', 1, 5),
        (5, 'Alex', 'Schweiz', 'Strasse 10', 'Zurich', '', 'CH-0000', 'Switzerland', 'alex@abcdefghijklmnopqrstuvwxyz.co.ch', '41-111-2222', 'alex', 'xela', 1, 5);

INSERT INTO FilmsRatings(RatingID, Rating)
  VALUES(1, 'General'),
        (2, 'Kids'),
        (3, 'Accompanied Minors'),
        (4, 'Teens'),
        (5, 'Adults'),
        (6, 'Mature Audiences');

INSERT INTO Films(FilmID, MovieTitle, PitchText, AmountBudgeted, RatingID, Summary, ImageName, DateInTheaters)
  VALUES(1, 'Being Unbearably Light', 'Love, betrayal, and battling eating disorders', 300000, 5, 'Love, ambition, lust, cheating, war, politics, and refusing to eat.', '', '2000-08-01'),
        (2, 'Charlie''s Devils', 'Making bad look so good', 750000, 1, 'It''s a quiet peaceful day, no bad news, no bad guys, and no worries. But all that''s about to change. Three beautiful women hear a voice (which conveniently leaves the door open for an insanity plea in the sequel) which directs them on a mission of destruction, mayhem, and temptation.', 'f2.gif', '2000-12-25'),
        (3, 'Closet Encounters of the Odd Kind', 'Some things should remain in the closet', 350000, 5, 'One man find out more than he ever wanted to know about the skeletons in his closet - and not just figuratively either.', 'f3.gif', '2000-11-07'),
        (4, 'Four Bar-Mitzvah''s and a Circumcision', 'Oy, I carried you for nine months, would it hurt to call me once in a while?', 175000, 1, 'One mother''s journey of self-discovery ? yeah, right ? make that discovery of everything going on in every house in the neighborhood.', '', '2001-05-16'),
        (5, 'Harry''s Pottery', 'One day an ordinary boy, the next day the talk of elite', 600000, 1, 'For Harry, an eleven year old orphan, life is about to change when he discovers that he''s inherited magical powers that let him create pottery and bone china beyond compare.', '', '2001-12-01'),
        (6, 'Geriatric Park', 'Just when you thought it was safe to visit Florida', 575000, 6, 'Think it''ll be a sun filled vacation? Think again. Big slow cars, turning signals that blink forever, election recounts ? you''ll be begging for the comparable peace and tranquility of a nice seasonal hurricane.', '', '2001-08-17'),
        (7, 'Ground Hog Day', 'Would you like fries with that? Would you like fries with that? Would you like fries with that?', 225000, 4, 'The tale of one man''s struggle to come to grips with his irrational fear of fast food. Until he learns to enjoy hamburgers he''ll have to eat them over and over and over and ?', 'f7.gif', '2001-02-15'),
        (8, 'It''s a Wonderful Wife', 'Boy meets girl, boy marries girl, boy learns to never forget a birthday', 315000, 1, 'The classic family favorite revisited. Family, holidays, celebrations, and the trials and tribulations of dealing with trick questions like "Does this make me look fat"?', '', '1998-06-15'),
        (9, 'Kramer vs. George', 'There''s a fine line between friend and feud', 195000, 6, 'Two friends, and one custody battle about to get really ugly. Just what is the domain, and who is it''s master?', '', '2001-07-18'),
        (10, 'Mission Improbable', 'This mission, which we recommend you decline, ?', 900000, 2, 'High tech action thriller, and the agent who''d rather hit the snooze button than risk his life with a glamorous sidekick at his side.', '', '2001-10-01'),
        (11, 'Nightmare on Overwhelmed Street', 'Suburbia, two cars, dual income, the neighborhood, noooooooooo', 475000, 6, 'The picture perfect family - beautiful home, 2.3 kids, a pet, two cars, two jobs, and a balanced portfolio. Fantasy? Not for long. When the neighborhood association shows up at the door, be frightened, be very frightened.', '', '2002-01-01'),
        (12, 'Silence of the Clams', 'Hannibal meets Moby-Dick', 700000, 3, 'Peaceful, serene, soothing, calming - marine life can look so innocent. But the ugly truth is quite different. Once you get beyond the cover-up, once you learn of the terrifying fish-eating fish, you''ll never be able to eat seafood again.', 'f12.gif', '2001-03-01'),
        (13, 'Starlet Wars', 'Intergalactic beauty pageants were never this much fun', 800000, 3, 'The gowns, the music, the celebrities, the glamour, the redundant body parts, talent contests involving monosyllabic growls and funny sounding weapons that shoot in bright neon hues - welcome to the first intergalactic beauty pageant.', 'f13.gif', '2001-06-01'),
        (14, 'The Funeral Planner', 'She''s to die for', 375000, 5, 'True love can blossom just about anywhere. But when a man falls for his fianc''s funeral planner someone is bound to get upset - especially the fianc (who was expecting neither the funeral nor the planner).', '', '2001-11-01'),
        (15, 'The Sixth Nonsense', 'I see stupid people!', 650000, 4, 'Psychological thriller about a young boy haunted by visions of stupidity, and the doctor who helps him deal with this gift (or affliction) helping himself in the process.', '', '2001-06-21'),
        (16, 'West End Story', 'Love and heartbreak in the theatre district', 215000, 1, 'The heartwarming story of triumph over adversity set in London''s theatre district. A group of badly reviewed actors sing and dance their way to the top.', '', '2001-09-18'),
        (17, 'Raiders of the Lost Aardvark', 'Indiana Jones meets Crocodile Dundee', 70000, 4, 'It''s the year 3034, and darkness and disease have fallen over the earth. Humanity is doomed, unless our hero can track down the last known Aardvark and bring it back alive. Confused? Just wait until the surprise ending.', '', '2001-02-14'),
        (18, 'Folded Laundry, Concealed Ticket', 'Couch Potatoes meet the English Patient', 7000000, 2, 'Metaphysical romp follow-up to last year''s smash hit, Crouching Tiger, Hidden Dragon. This time the mystery surrounds some long-lost clothing. How did it get to the desert? Who will make it out alive? Will they use starch? Find out all this and more when it hits the screens.', '', '2002-09-15'),
        (19, 'Use Your ColdFusion II', 'Axel Rose heads to the heartland', 1700, 1, 'In search of two legendary brothers who made it big during the Internet years of the late 20th Century, time-traveling gumshoe Axel Rose leaves his west-coast digs in search of answers. Who really discovered ColdFusion? Did Al Gore really invent the Internet? Will Slash save the day?', '', '2001-05-15'),
        (20, 'Hannah and Her Blisters', 'Annie Hall meets Chariots of Fire', 13000000, 1, 'In Woody Allen''s latest, we meet a shoe saleswoman who has a dream to run the New York Marathon. Thing is, she can''t afford the foot operation she needs to be able to run, so she attempts to seduce her handsome, older, somewhat neurotic boss.', '', '2001-05-15'),
        (21, 'Forrest Trump', 'Gump gets rich', 135000000, 3, 'It''s 10 years later, and everyone''s favorite half-wit has made himself a small fortune building high-rise towers in New York City. But will he remember his roots?', '', '2004-07-12'),
        (22, 'Strangers on a Stain', 'Honey, I Shrunk the Kids meets The Odd Couple', 7000000, 2, 'They used to be college roommates, but now they are arch rivals in the micro engineering industry. Sabotage leads to one disaster after another, and now they are each just one inch high and can''t escape from a backstage party at a Motley Crue concert.', '', '2003-11-22'),
        (23, 'Gladly Ate Her', 'Dr. Lecter meets the Roman Empire', 800000000, 3, 'There''s something for everyone in this comedy/thriller/horror/love story. When in Rome, do as the Romans do.', '', '2004-02-15');

INSERT INTO Expenses(ExpenseID, FilmID, ExpenseAmount, Description, ExpenseDate)
  VALUES(1, 1, 25000, 'Costume rental', '2000-01-01'),
        (2, 1, 800, 'Food', '2000-01-02'),
        (3, 2, 100000, 'Vehicles', '2000-03-01'),
        (4, 2, 85000, 'Pyrotechnics', '2000-04-12'),
        (5, 2, 32500, 'Costume design', '2001-03-18'),
        (6, 2, 3500, 'Travel', '2001-03-20'),
        (7, 3, 50, 'Closet', '2000-05-04'),
        (8, 3, 30, 'Skeletons', '2000-05-05'),
        (9, 4, 200, 'Mohel', '2001-07-02'),
        (10, 4, 10000, 'Local phone calls', '2001-07-03'),
        (11, 4, 50, 'Costumes', '2001-08-05'),
        (12, 5, 20000, 'Bone china', '2000-12-10'),
        (13, 5, 500, 'Pots and pans', '2000-12-12'),
        (14, 6, 200, 'Big old car', '2001-08-12'),
        (15, 6, 1, 'Election ballot counting machine', '2000-11-25'),
        (16, 6, 250, 'Costumes', '1999-01-01'),
        (17, 6, 10000, 'Alligator', '1999-12-25'),
        (18, 7, 2000, 'Hamburgers', '2000-07-01'),
        (19, 8, 500, 'Birthday gift', '2000-03-18'),
        (20, 8, 5000, 'Second birthday gift', '2000-03-20'),
        (21, 8, 50000, 'Third birthday gift', '2000-12-30'),
        (22, 9, 75000, 'Week''s rent for New York apartment', '1999-02-28'),
        (23, 10, 9, 'Alarm clock', '2001-01-12'),
        (24, 10, 100, 'Ammunition', '1999-04-15'),
        (25, 10, 500, 'Costumes', '2000-10-19'),
        (26, 11, 250000, 'Suburban home', '1998-04-05'),
        (27, 11, 5000, 'Pet supplies', '1998-04-12'),
        (28, 12, 25000, 'Marine life', '1998-09-18'),
        (29, 12, 5000, 'Bait', '1998-09-30'),
        (30, 13, 30000, 'Costumes', '2000-07-08'),
        (31, 13, 50000, 'Space age ammunition', '1999-04-05'),
        (32, 13, 150000, 'Alien plastic surgery', '2001-07-05'),
        (33, 14, 450, 'Casket', '1999-09-10'),
        (34, 15, 1, 'Extras', '2001-04-05'),
        (35, 16, 1000, 'Costumes', '2001-08-09'),
        (36, 17, 45000, 'Coffee', '2001-07-12'),
        (37, 17, 8.5, 'Makeup', '2001-07-28'),
        (38, 18, 18500, 'Leather Jackets', '2000-06-15'),
        (39, 18, 10000, 'Rubber Fish', '2000-06-07'),
        (40, 19, 5, 'Towel', '2001-08-12'),
        (41, 19, 12, 'Hitchhiker''s Guide', '2001-09-17'),
        (42, 20, 17000, 'Neon lights', '1999-04-15'),
        (43, 20, 8700, 'Dry ice', '1999-04-26'),
        (44, 20, 13000, 'Ice cube trays', '1999-04-16'),
        (45, 20, 1200, 'Gloves', '1999-04-19'),
        (46, 21, 100000.5, 'Egg Salad', '2001-02-01'),
        (47, 21, 1245, 'Sandals', '2001-02-02'),
        (48, 22, 130000, 'Gore', '2001-12-01'),
        (49, 22, 13000, 'Other Politicians', '2001-12-15'),
        (50, 23, 50000, 'Extras', '1998-05-17'),
        (51, 23, 150000, 'False noses', '1998-05-18'),
        (52, 23, 400000, 'Internet consultants', '1998-05-20');

INSERT INTO FilmsActors(FARecID, FilmID, ActorID, IsStarringRole, Salary)
  VALUES(1, 1, 1, 1, 50000),
        (2, 1, 2, 1, 50000),
        (3, 2, 12, 0, 990000),
        (4, 2, 14, 1, 60000),
        (5, 3, 17, 0, 77700),
        (6, 3, 1, 0, 35000),
        (7, 3, 7, 0, 120000),
        (8, 3, 4, 1, 7800),
        (9, 4, 12, 1, 2342),
        (10, 4, 13, 1, 77000),
        (11, 5, 3, 1, 570000),
        (12, 5, 13, 1, 1800000),
        (13, 6, 16, 0, 1),
        (14, 6, 12, 1, 80000),
        (16, 7, 1, 1, 50000),
        (17, 7, 2, 0, 40000),
        (18, 7, 7, 1, 50000),
        (19, 8, 6, 1, 100000),
        (20, 8, 16, 1, 120000),
        (21, 9, 5, 0, 35000),
        (22, 10, 7, 1, 20000),
        (23, 10, 14, 1, 170000),
        (24, 11, 17, 1, 909000),
        (25, 11, 16, 0, 72100),
        (26, 11, 7, 0, 90900),
        (27, 12, 8, 1, 84200),
        (28, 12, 4, 1, 10000),
        (29, 13, 5, 1, 20000),
        (30, 13, 17, 0, 30000),
        (31, 14, 16, 1, 40000),
        (32, 14, 20, 0, 50000),
        (33, 14, 6, 1, 55000),
        (34, 15, 5, 0, 1250),
        (35, 16, 1, 1, 50000),
        (36, 16, 11, 1, 1750),
        (37, 16, 19, 0, 12000),
        (38, 17, 17, 1, 88000),
        (39, 17, 1, 0, 90899),
        (40, 18, 2, 1, 17001),
        (41, 18, 8, 1, 80000),
        (42, 19, 18, 1, 99999),
        (43, 19, 12, 0, 45000),
        (44, 20, 11, 1, 17000),
        (45, 21, 10, 1, 95000),
        (46, 21, 6, 0, 38000),
        (47, 21, 14, 1, 1700),
        (48, 23, 10, 0, 9900),
        (49, 23, 7, 1, 10000),
        (50, 20, 8, 1, 15000),
        (51, 17, 3, 0, 40000),
        (52, 22, 15, 0, 0),
        (53, 23, 15, 0, 0);

INSERT INTO FilmsDirectors(FDRecID, FilmID, DirectorID, Salary)
  VALUES(1, 1, 4, 100000),
        (2, 2, 3, 110000),
        (3, 3, 5, 75500),
        (4, 4, 2, 75000),
        (5, 4, 8, 80000),
        (6, 5, 7, 65000),
        (7, 6, 6, 85000),
        (8, 7, 2, 75000),
        (9, 7, 9, 99000),
        (10, 8, 4, 85000),
        (11, 9, 6, 45000),
        (13, 10, 12, 15000),
        (14, 11, 9, 88000),
        (15, 11, 12, 98000),
        (16, 11, 1, 108000),
        (17, 12, 3, 118000),
        (18, 13, 11, 45000),
        (19, 14, 7, 55000),
        (20, 15, 1, 10000),
        (21, 15, 10, 100000),
        (22, 16, 12, 1000000),
        (23, 17, 11, 150000),
        (24, 18, 11, 950000),
        (25, 19, 10, 800000),
        (26, 20, 1, 70000),
        (27, 21, 1, 40000),
        (28, 23, 13, 35000),
        (30, 22, 11, 35000),
        (31, 1, 1, 18000);

INSERT INTO Merchandise(MerchID, FilmID, MerchName, MerchDescription, MerchPrice, ImageNameSmall, ImageNameLarge)
  VALUES(1, 1, 'Poster', 'Wonderful poster showing all the stars, winking.', 17.5, '', ''),
        (2, 2, 'Small Poster', 'Campy, dressed-up, dressed-down Angels!', 40, '', ''),
        (3, 12, 'Autographed Knife', 'Was actually used (by caterers) during production', 88, 'p3_sml.jpg', 'p3_lrg.jpg'),
        (4, 23, 'Pair of Sandals', 'Special promotional item. Actually worn by Patrik.', 130, '', ''),
        (5, 13, 'Jabba the Hut Action Figure', 'Uto-buto, Solo?', 950, 'p5_sml.jpg', 'p5_lrg.jpg'),
        (6, 5, 'Poster', 'Shows our favorite kid wizard in front of kiln.', 30, '', ''),
        (7, 16, 'T-Shirt', 'Be the talk of the town with a West End Story Tee.', 19.5, '', ''),
        (8, 19, 'ColdFusion Construction Kit', 'Free Guns and Roses album with purchase.', 59.95, 'p8_sml.jpg', 'p8_lrg.jpg'),
        (9, 9, 'Poster', 'Signed by the whole cast', 100, '', ''),
        (10, 18, 'Laundry', 'Original laundry used in movie, mostly unused (and unwashed)', 250, 'p10_sml.jpg', 'p10_lrg.jpg'),
        (11, 15, 'Fake IQ Test Certificate', 'Convince your friends they are as stupid as you think they are.', 7.5, '', ''),
        (12, 19, 'ColdFusion 1.x diskettes', 'Yes, it really shipped on 3.5 inch floppies, and you can have the proof.', 24.99, 'p12_sml.jpg', 'p12_lrg.jpg'),
        (13, 13, 'Size epsilon shoe', 'Worn by the runner up (suitable for single legged life form only).', 59, '', '');

INSERT INTO MerchandiseOrders(OrderID, ContactID, OrderDate, ShipAddress, ShipCity, ShipState, ShipZip, ShipCountry, ShipDate)
  VALUES(1, 2, '2001-03-01', '1 Rue Street', 'Brussels', '', '1234', 'Belgium', '2001-03-03'),
        (2, 4, '2001-03-01', '2000 Town Center, Suite 1900', 'Southfield', 'MI', '48075', 'USA', '2001-03-03'),
        (3, 4, '2001-03-05', '2000 Town Center, Suite 1900', 'Southfield', 'MI', '48075', 'USA', '2001-03-05');

INSERT INTO MerchandiseOrdersItems(OrderItemID, OrderID, ItemID, OrderQty, ItemPrice)
  VALUES(1, 1, 6, 2, 30),
        (2, 1, 1, 1, 17.5),
        (3, 1, 9, 1, 100),
        (4, 2, 11, 10, 7.5),
        (5, 3, 13, 1, 59),
        (6, 3, 12, 2, 24.99);

