dS4v2KdY

1-- MySQL Workbench Forward Engineering
2
3SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
4SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
5SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
6
7-- -----------------------------------------------------
8-- Schema mydb
9-- -----------------------------------------------------
10DROP SCHEMA IF EXISTS `mydb` ;
11
12-- -----------------------------------------------------
13-- Schema mydb
14-- -----------------------------------------------------
15CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
16USE `mydb` ;
17
18-- -----------------------------------------------------
19-- Table `mydb`.`Owner_Info`
20-- -----------------------------------------------------
21CREATE TABLE IF NOT EXISTS `mydb`.`Owner_Info` (
22  `Owner_ID` INT UNSIGNED NOT NULL AUTO_INCREMENT,
23  `First_Name` VARCHAR(45) NOT NULL DEFAULT '',
24  `Last_Name` VARCHAR(45) NOT NULL DEFAULT '',
25  `Address` VARCHAR(45) NOT NULL DEFAULT '',
26  `Phone_Number` VARCHAR(45) NOT NULL DEFAULT '',
27  `Number_Of_Movies` INT NOT NULL DEFAULT 0,
28  PRIMARY KEY (`Owner_ID`),
29  UNIQUE INDEX `Owner_ID_UNIQUE` (`Owner_ID` ASC))
30ENGINE = InnoDB;
31
32
33-- -----------------------------------------------------
34-- Table `mydb`.`Age_Rating`
35-- -----------------------------------------------------
36CREATE TABLE IF NOT EXISTS `mydb`.`Age_Rating` (
37  `Age_Rating_ID` INT UNSIGNED NOT NULL AUTO_INCREMENT,
38  `Description` VARCHAR(200) NOT NULL DEFAULT '',
39  `Violence` TINYINT NOT NULL DEFAULT 0,
40  `Language` TINYINT NOT NULL DEFAULT 0,
41  `Substance_Abuse` TINYINT NOT NULL DEFAULT 0,
42  `Nudity` TINYINT NOT NULL DEFAULT 0,
43  PRIMARY KEY (`Age_Rating_ID`),
44  UNIQUE INDEX `Age_Rating_ID_UNIQUE` (`Age_Rating_ID` ASC))
45ENGINE = InnoDB;
46
47
48-- -----------------------------------------------------
49-- Table `mydb`.`Directors`
50-- -----------------------------------------------------
51CREATE TABLE IF NOT EXISTS `mydb`.`Directors` (
52  `Director_ID` INT UNSIGNED NOT NULL AUTO_INCREMENT,
53  `First_Name` VARCHAR(45) NOT NULL DEFAULT '',
54  `Last_Name` VARCHAR(45) NOT NULL DEFAULT '',
55  `Date_Of_Birth` DATE NULL,
56  `Movies_Made` INT NOT NULL DEFAULT 0,
57  `Awards_Recieved` INT NOT NULL DEFAULT 0,
58  PRIMARY KEY (`Director_ID`),
59  UNIQUE INDEX `Director_ID_UNIQUE` (`Director_ID` ASC))
60ENGINE = InnoDB;
61
62
63-- -----------------------------------------------------
64-- Table `mydb`.`Movies`
65-- -----------------------------------------------------
66CREATE TABLE IF NOT EXISTS `mydb`.`Movies` (
67  `Movie_ID` INT UNSIGNED NOT NULL AUTO_INCREMENT,
68  `Movie_Title` VARCHAR(45) NOT NULL DEFAULT '',
69  `Release_Date` DATE NULL,
70  `Age_Rating_ID` INT UNSIGNED NOT NULL,
71  `Director_ID` INT UNSIGNED NOT NULL,
72  `Medium` VARCHAR(45) NOT NULL DEFAULT '',
73  `Format` VARCHAR(45) NOT NULL DEFAULT '',
74  `Owner_ID` INT UNSIGNED NOT NULL,
75  `Length` INT NOT NULL DEFAULT 0,
76  `Series_ID` INT NULL,
77  PRIMARY KEY (`Movie_ID`),
78  INDEX `fk_Movies_Owner_Info1_idx` (`Owner_ID` ASC),
79  INDEX `fk_Movies_Age_Rating1_idx` (`Age_Rating_ID` ASC),
80  INDEX `fk_Movies_Directors1_idx` (`Director_ID` ASC),
81  UNIQUE INDEX `Movie_ID_UNIQUE` (`Movie_ID` ASC),
82  CONSTRAINT `fk_Movies_Owner_Info1`
83    FOREIGN KEY (`Owner_ID`)
84    REFERENCES `mydb`.`Owner_Info` (`Owner_ID`)
85    ON DELETE NO ACTION
86    ON UPDATE NO ACTION,
87  CONSTRAINT `fk_Movies_Age_Rating1`
88    FOREIGN KEY (`Age_Rating_ID`)
89    REFERENCES `mydb`.`Age_Rating` (`Age_Rating_ID`)
90    ON DELETE NO ACTION
91    ON UPDATE NO ACTION,
92  CONSTRAINT `fk_Movies_Directors1`
93    FOREIGN KEY (`Director_ID`)
94    REFERENCES `mydb`.`Directors` (`Director_ID`)
95    ON DELETE NO ACTION
96    ON UPDATE NO ACTION)
97ENGINE = InnoDB;
98
99
100-- -----------------------------------------------------
101-- Table `mydb`.`Lendee_Info`
102-- -----------------------------------------------------
103CREATE TABLE IF NOT EXISTS `mydb`.`Lendee_Info` (
104  `Lendee_ID` INT UNSIGNED NOT NULL AUTO_INCREMENT,
105  `First_Name` VARCHAR(45) NOT NULL DEFAULT '',
106  `Last_Name` VARCHAR(45) NOT NULL DEFAULT '',
107  `Address` VARCHAR(45) NOT NULL DEFAULT '',
108  `Phone_Number` VARCHAR(45) NOT NULL DEFAULT '',
109  `Movie_Condition` VARCHAR(45) NOT NULL DEFAULT '',
110  `Date_Lended` DATE NULL,
111  `Return_By` DATE NULL,
112  PRIMARY KEY (`Lendee_ID`),
113  UNIQUE INDEX `Lendee_ID_UNIQUE` (`Lendee_ID` ASC))
114ENGINE = InnoDB;
115
116
117-- -----------------------------------------------------
118-- Table `mydb`.`Box_Office`
119-- -----------------------------------------------------
120CREATE TABLE IF NOT EXISTS `mydb`.`Box_Office` (
121  `Movie_ID` INT UNSIGNED NOT NULL AUTO_INCREMENT,
122  `Production_Cost` INT NOT NULL DEFAULT 0,
123  `Opening_Week` INT NOT NULL DEFAULT 0,
124  `Gross_Revenue` INT NOT NULL DEFAULT 0,
125  `Net_Revenue` INT NOT NULL DEFAULT 0,
126  `Production_Company` VARCHAR(45) NOT NULL DEFAULT '',
127  INDEX `fk_Box_Office_Movies1_idx` (`Movie_ID` ASC),
128  PRIMARY KEY (`Movie_ID`),
129  UNIQUE INDEX `Movie_ID_UNIQUE` (`Movie_ID` ASC),
130  CONSTRAINT `fk_Box_Office_Movies1`
131    FOREIGN KEY (`Movie_ID`)
132    REFERENCES `mydb`.`Movies` (`Movie_ID`)
133    ON DELETE NO ACTION
134    ON UPDATE NO ACTION)
135ENGINE = InnoDB;
136
137
138-- -----------------------------------------------------
139-- Table `mydb`.`Actors`
140-- -----------------------------------------------------
141CREATE TABLE IF NOT EXISTS `mydb`.`Actors` (
142  `Actor_ID` INT UNSIGNED NOT NULL AUTO_INCREMENT,
143  `First_Name` VARCHAR(45) NOT NULL DEFAULT '',
144  `Last_Name` VARCHAR(45) NOT NULL DEFAULT '',
145  `Gender` VARCHAR(45) NOT NULL DEFAULT 'n/a',
146  `Nationality` VARCHAR(45) NOT NULL DEFAULT 'n/a',
147  `Date_Of_Birth` DATE NULL,
148  `Number_Of_Awards` INT NOT NULL DEFAULT 0,
149  `Number_Of_Movies` INT NOT NULL DEFAULT 0,
150  PRIMARY KEY (`Actor_ID`),
151  UNIQUE INDEX `Actor_ID_UNIQUE` (`Actor_ID` ASC))
152ENGINE = InnoDB;
153
154
155-- -----------------------------------------------------
156-- Table `mydb`.`Movies_Borrowed`
157-- -----------------------------------------------------
158CREATE TABLE IF NOT EXISTS `mydb`.`Movies_Borrowed` (
159  `Lendee_ID` INT UNSIGNED NOT NULL,
160  `Movie_ID` INT UNSIGNED NOT NULL,
161  PRIMARY KEY (`Lendee_ID`, `Movie_ID`),
162  INDEX `fk_Lended_Movies_Movies1_idx` (`Movie_ID` ASC),
163  CONSTRAINT `fk_Lended_Movies_Lendee_Info1`
164    FOREIGN KEY (`Lendee_ID`)
165    REFERENCES `mydb`.`Lendee_Info` (`Lendee_ID`)
166    ON DELETE NO ACTION
167    ON UPDATE NO ACTION,
168  CONSTRAINT `fk_Lended_Movies_Movies1`
169    FOREIGN KEY (`Movie_ID`)
170    REFERENCES `mydb`.`Movies` (`Movie_ID`)
171    ON DELETE NO ACTION
172    ON UPDATE NO ACTION)
173ENGINE = InnoDB;
174
175
176-- -----------------------------------------------------
177-- Table `mydb`.`Movies_Cast`
178-- -----------------------------------------------------
179CREATE TABLE IF NOT EXISTS `mydb`.`Movies_Cast` (
180  `Movie_ID` INT UNSIGNED NOT NULL,
181  `Actor_ID` INT UNSIGNED NOT NULL,
182  PRIMARY KEY (`Movie_ID`, `Actor_ID`),
183  INDEX `fk_Movies_has_Actors_Actors1_idx` (`Actor_ID` ASC),
184  INDEX `fk_Movies_has_Actors_Movies1_idx` (`Movie_ID` ASC),
185  CONSTRAINT `fk_Movies_has_Actors_Movies1`
186    FOREIGN KEY (`Movie_ID`)
187    REFERENCES `mydb`.`Movies` (`Movie_ID`)
188    ON DELETE NO ACTION
189    ON UPDATE NO ACTION,
190  CONSTRAINT `fk_Movies_has_Actors_Actors1`
191    FOREIGN KEY (`Actor_ID`)
192    REFERENCES `mydb`.`Actors` (`Actor_ID`)
193    ON DELETE NO ACTION
194    ON UPDATE NO ACTION)
195ENGINE = InnoDB;
196
197
198SET SQL_MODE=@OLD_SQL_MODE;
199SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
200SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
201
202-- -----------------------------------------------------
203-- Data for table `mydb`.`Owner_Info`
204-- -----------------------------------------------------
205START TRANSACTION;
206USE `mydb`;
207INSERT INTO `mydb`.`Owner_Info` (`Owner_ID`, `First_Name`, `Last_Name`, `Address`, `Phone_Number`, `Number_Of_Movies`) VALUES (1, 'Alex', 'Boellner', '4906 Carroll Court', '4104911110', 15);
208INSERT INTO `mydb`.`Owner_Info` (`Owner_ID`, `First_Name`, `Last_Name`, `Address`, `Phone_Number`, `Number_Of_Movies`) VALUES (2, 'Riss', 'Hardcastle', '', '', 0);
209
210COMMIT;
211
212
213-- -----------------------------------------------------
214-- Data for table `mydb`.`Age_Rating`
215-- -----------------------------------------------------
216START TRANSACTION;
217USE `mydb`;
218INSERT INTO `mydb`.`Age_Rating` (`Age_Rating_ID`, `Description`, `Violence`, `Language`, `Substance_Abuse`, `Nudity`) VALUES (1, 'G', 0, 0, 0, 0);
219INSERT INTO `mydb`.`Age_Rating` (`Age_Rating_ID`, `Description`, `Violence`, `Language`, `Substance_Abuse`, `Nudity`) VALUES (2, 'PG', 1, 0, 0, 0);
220INSERT INTO `mydb`.`Age_Rating` (`Age_Rating_ID`, `Description`, `Violence`, `Language`, `Substance_Abuse`, `Nudity`) VALUES (3, 'PG-13', 1, 1, 0, 0);
221INSERT INTO `mydb`.`Age_Rating` (`Age_Rating_ID`, `Description`, `Violence`, `Language`, `Substance_Abuse`, `Nudity`) VALUES (4, 'R', 1, 1, 0, 1);
222
223COMMIT;
224
225
226-- -----------------------------------------------------
227-- Data for table `mydb`.`Directors`
228-- -----------------------------------------------------
229START TRANSACTION;
230USE `mydb`;
231INSERT INTO `mydb`.`Directors` (`Director_ID`, `First_Name`, `Last_Name`, `Date_Of_Birth`, `Movies_Made`, `Awards_Recieved`) VALUES (1, 'Irvin', ' Kershner', '4/29/1923', 27, 6);
232INSERT INTO `mydb`.`Directors` (`Director_ID`, `First_Name`, `Last_Name`, `Date_Of_Birth`, `Movies_Made`, `Awards_Recieved`) VALUES (2, 'Richard ', ' Marquand', '9/22/1937', 27, 2);
233INSERT INTO `mydb`.`Directors` (`Director_ID`, `First_Name`, `Last_Name`, `Date_Of_Birth`, `Movies_Made`, `Awards_Recieved`) VALUES (3, 'George', 'Lucas', '5/14/1944', 18, 58);
234INSERT INTO `mydb`.`Directors` (`Director_ID`, `First_Name`, `Last_Name`, `Date_Of_Birth`, `Movies_Made`, `Awards_Recieved`) VALUES (4, 'J. J. ', 'Abhrams', '6/27/1966', 56, 22);
235INSERT INTO `mydb`.`Directors` (`Director_ID`, `First_Name`, `Last_Name`, `Date_Of_Birth`, `Movies_Made`, `Awards_Recieved`) VALUES (5, 'Gareth', 'Edwards', '6/1/1975', 7, 14);
236INSERT INTO `mydb`.`Directors` (`Director_ID`, `First_Name`, `Last_Name`, `Date_Of_Birth`, `Movies_Made`, `Awards_Recieved`) VALUES (6, 'Peter', 'Jackson', '10/31/1961', 24, 167);
237INSERT INTO `mydb`.`Directors` (`Director_ID`, `First_Name`, `Last_Name`, `Date_Of_Birth`, `Movies_Made`, `Awards_Recieved`) VALUES (7, 'Terry', 'Gilliam', '9/22/1940', 28, 23);
238INSERT INTO `mydb`.`Directors` (`Director_ID`, `First_Name`, `Last_Name`, `Date_Of_Birth`, `Movies_Made`, `Awards_Recieved`) VALUES (8, 'Dean', 'DeBlois', '6/7/1970', 6, 10);
239INSERT INTO `mydb`.`Directors` (`Director_ID`, `First_Name`, `Last_Name`, `Date_Of_Birth`, `Movies_Made`, `Awards_Recieved`) VALUES (9, 'Andrew ', 'Adamson', '12/1/1966', 8, 8);
240INSERT INTO `mydb`.`Directors` (`Director_ID`, `First_Name`, `Last_Name`, `Date_Of_Birth`, `Movies_Made`, `Awards_Recieved`) VALUES (10, 'Mel', 'Brooks', '6/28/1926', 12, 23);
241INSERT INTO `mydb`.`Directors` (`Director_ID`, `First_Name`, `Last_Name`, `Date_Of_Birth`, `Movies_Made`, `Awards_Recieved`) VALUES (11, 'Andrew ', 'Stanton', '12/3/1965', 8, 34);
242
243COMMIT;
244
245
246-- -----------------------------------------------------
247-- Data for table `mydb`.`Movies`
248-- -----------------------------------------------------
249START TRANSACTION;
250USE `mydb`;
251INSERT INTO `mydb`.`Movies` (`Movie_ID`, `Movie_Title`, `Release_Date`, `Age_Rating_ID`, `Director_ID`, `Medium`, `Format`, `Owner_ID`, `Length`, `Series_ID`) VALUES (1, 'Star Wars: The Empire Strikes Back', '1980', 3, 1, 'Movie', 'DVD', 1, 124, 1);
252INSERT INTO `mydb`.`Movies` (`Movie_ID`, `Movie_Title`, `Release_Date`, `Age_Rating_ID`, `Director_ID`, `Medium`, `Format`, `Owner_ID`, `Length`, `Series_ID`) VALUES (2, 'Star Wars: Return of the Jedi', '1983', 3, 2, 'Movie', 'DVD', 1, 132, 1);
253INSERT INTO `mydb`.`Movies` (`Movie_ID`, `Movie_Title`, `Release_Date`, `Age_Rating_ID`, `Director_ID`, `Medium`, `Format`, `Owner_ID`, `Length`, `Series_ID`) VALUES (3, 'Star Wars: The Phantom Menace', '1999', 3, 3, 'Movie', 'DVD', 1, 133, 1);
254INSERT INTO `mydb`.`Movies` (`Movie_ID`, `Movie_Title`, `Release_Date`, `Age_Rating_ID`, `Director_ID`, `Medium`, `Format`, `Owner_ID`, `Length`, `Series_ID`) VALUES (4, 'Star Wars: Attack of the Clones', '2002', 3, 3, 'Movie', 'DVD', 1, 142, 1);
255INSERT INTO `mydb`.`Movies` (`Movie_ID`, `Movie_Title`, `Release_Date`, `Age_Rating_ID`, `Director_ID`, `Medium`, `Format`, `Owner_ID`, `Length`, `Series_ID`) VALUES (5, 'Star Wars: Revenge of the Sith', '2005', 3, 3, 'Movie', 'DVD', 1, 140, 1);
256INSERT INTO `mydb`.`Movies` (`Movie_ID`, `Movie_Title`, `Release_Date`, `Age_Rating_ID`, `Director_ID`, `Medium`, `Format`, `Owner_ID`, `Length`, `Series_ID`) VALUES (6, 'Star Wars: The Force Awakens', '2015', 3, 4, 'Movie', 'Blue-Ray', 1, 135, 1);
257INSERT INTO `mydb`.`Movies` (`Movie_ID`, `Movie_Title`, `Release_Date`, `Age_Rating_ID`, `Director_ID`, `Medium`, `Format`, `Owner_ID`, `Length`, `Series_ID`) VALUES (7, 'Rogue One: A Star Wars Story', '2016', 3, 5, 'Movie', 'Blue-Ray', 1, 133, 1);
258INSERT INTO `mydb`.`Movies` (`Movie_ID`, `Movie_Title`, `Release_Date`, `Age_Rating_ID`, `Director_ID`, `Medium`, `Format`, `Owner_ID`, `Length`, `Series_ID`) VALUES (8, 'Lord of the Rings: Fellowship of the Ring', '2001', 3, 6, 'Movie', 'Blue-Ray', 1, 178, 2);
259INSERT INTO `mydb`.`Movies` (`Movie_ID`, `Movie_Title`, `Release_Date`, `Age_Rating_ID`, `Director_ID`, `Medium`, `Format`, `Owner_ID`, `Length`, `Series_ID`) VALUES (9, 'Lord of the Rings: The Two Towers', '2002', 3, 6, 'Movie', 'Blue-Ray', 1, 179, 2);
260INSERT INTO `mydb`.`Movies` (`Movie_ID`, `Movie_Title`, `Release_Date`, `Age_Rating_ID`, `Director_ID`, `Medium`, `Format`, `Owner_ID`, `Length`, `Series_ID`) VALUES (10, 'Lord of the Rings: Return of the King', '2003', 3, 6, 'Movie', 'Blue-Ray', 1, 201, 2);
261INSERT INTO `mydb`.`Movies` (`Movie_ID`, `Movie_Title`, `Release_Date`, `Age_Rating_ID`, `Director_ID`, `Medium`, `Format`, `Owner_ID`, `Length`, `Series_ID`) VALUES (11, 'Monty Python and the Holy Grail', '1975', 2, 7, 'Movie', 'DVD', 1, 91, Null);
262INSERT INTO `mydb`.`Movies` (`Movie_ID`, `Movie_Title`, `Release_Date`, `Age_Rating_ID`, `Director_ID`, `Medium`, `Format`, `Owner_ID`, `Length`, `Series_ID`) VALUES (12, 'How to Train Your Dragon', '2010', 2, 8, 'Movie', 'Blue-Ray', 1, 98, 3);
263INSERT INTO `mydb`.`Movies` (`Movie_ID`, `Movie_Title`, `Release_Date`, `Age_Rating_ID`, `Director_ID`, `Medium`, `Format`, `Owner_ID`, `Length`, `Series_ID`) VALUES (13, 'Shrek', '2001', 2, 9, 'Mvoe', 'DVD', 1, 90, 4);
264INSERT INTO `mydb`.`Movies` (`Movie_ID`, `Movie_Title`, `Release_Date`, `Age_Rating_ID`, `Director_ID`, `Medium`, `Format`, `Owner_ID`, `Length`, `Series_ID`) VALUES (14, 'Space Balls', '1987', 2, 10, 'Movie', 'DVD', 1, 96, Null);
265INSERT INTO `mydb`.`Movies` (`Movie_ID`, `Movie_Title`, `Release_Date`, `Age_Rating_ID`, `Director_ID`, `Medium`, `Format`, `Owner_ID`, `Length`, `Series_ID`) VALUES (15, 'WALL-E', '2008', 1, 11, 'Movie', 'DVD', 1, 98, Null);
266
267COMMIT;
268
269
270-- -----------------------------------------------------
271-- Data for table `mydb`.`Lendee_Info`
272-- -----------------------------------------------------
273START TRANSACTION;
274USE `mydb`;
275INSERT INTO `mydb`.`Lendee_Info` (`Lendee_ID`, `First_Name`, `Last_Name`, `Address`, `Phone_Number`, `Movie_Condition`, `Date_Lended`, `Return_By`) VALUES (1, 'John', 'Smith', '123 Way', '1234567878', 'Good', '12/7/2017', '12/17/2017');
276INSERT INTO `mydb`.`Lendee_Info` (`Lendee_ID`, `First_Name`, `Last_Name`, `Address`, `Phone_Number`, `Movie_Condition`, `Date_Lended`, `Return_By`) VALUES (2, 'Larry', 'Smith', '124 Way', '1234567878', 'Good', '12/8/2017', '12/18/2017');
277INSERT INTO `mydb`.`Lendee_Info` (`Lendee_ID`, `First_Name`, `Last_Name`, `Address`, `Phone_Number`, `Movie_Condition`, `Date_Lended`, `Return_By`) VALUES (3, 'Manny', 'Smith', '125 Way', '1234567878', 'Good', '12/9/2017', '12/19/2017');
278
279COMMIT;
280
281
282-- -----------------------------------------------------
283-- Data for table `mydb`.`Box_Office`
284-- -----------------------------------------------------
285START TRANSACTION;
286USE `mydb`;
287INSERT INTO `mydb`.`Box_Office` (`Movie_ID`, `Production_Cost`, `Opening_Week`, `Gross_Revenue`, `Net_Revenue`, `Production_Company`) VALUES (1, 18000000, 6415804, 290475067, 272475067, 'Lucas Films');
288INSERT INTO `mydb`.`Box_Office` (`Movie_ID`, `Production_Cost`, `Opening_Week`, `Gross_Revenue`, `Net_Revenue`, `Production_Company`) VALUES (2, 32500000, 30490619, 309125409, 276625409, 'Lucas Films');
289INSERT INTO `mydb`.`Box_Office` (`Movie_ID`, `Production_Cost`, `Opening_Week`, `Gross_Revenue`, `Net_Revenue`, `Production_Company`) VALUES (3, 115000000, 64820970, 474544677, 359544677, 'Lucas Films');
290INSERT INTO `mydb`.`Box_Office` (`Movie_ID`, `Production_Cost`, `Opening_Week`, `Gross_Revenue`, `Net_Revenue`, `Production_Company`) VALUES (4, 115000000, 80027814, 310675583, 195675583, 'Lucas Films');
291INSERT INTO `mydb`.`Box_Office` (`Movie_ID`, `Production_Cost`, `Opening_Week`, `Gross_Revenue`, `Net_Revenue`, `Production_Company`) VALUES (5, 113000000, 108435841, 380262555, 267262555, 'Lucas Films');
292INSERT INTO `mydb`.`Box_Office` (`Movie_ID`, `Production_Cost`, `Opening_Week`, `Gross_Revenue`, `Net_Revenue`, `Production_Company`) VALUES (6, 245000000, 247966675, 936662225, 691662225, 'Lucas Films');
293INSERT INTO `mydb`.`Box_Office` (`Movie_ID`, `Production_Cost`, `Opening_Week`, `Gross_Revenue`, `Net_Revenue`, `Production_Company`) VALUES (7, 200000000, 155081681, 532177324, 332177324, 'Lucas Films');
294INSERT INTO `mydb`.`Box_Office` (`Movie_ID`, `Production_Cost`, `Opening_Week`, `Gross_Revenue`, `Net_Revenue`, `Production_Company`) VALUES (8, 93000000, 47211490, 315544750, 222544750, 'New Line Cinema');
295INSERT INTO `mydb`.`Box_Office` (`Movie_ID`, `Production_Cost`, `Opening_Week`, `Gross_Revenue`, `Net_Revenue`, `Production_Company`) VALUES (9, 94000000, 62007528, 342551365, 248551365, 'New Line Cinema');
296INSERT INTO `mydb`.`Box_Office` (`Movie_ID`, `Production_Cost`, `Opening_Week`, `Gross_Revenue`, `Net_Revenue`, `Production_Company`) VALUES (10, 94000000, 72629713, 377845905, 283845905, 'New Line Cinema');
297INSERT INTO `mydb`.`Box_Office` (`Movie_ID`, `Production_Cost`, `Opening_Week`, `Gross_Revenue`, `Net_Revenue`, `Production_Company`) VALUES (11, 229575, 45487, 1229197, 999622, 'Michael White Productions');
298INSERT INTO `mydb`.`Box_Office` (`Movie_ID`, `Production_Cost`, `Opening_Week`, `Gross_Revenue`, `Net_Revenue`, `Production_Company`) VALUES (12, 165000000, 43732319, 217581231, 52581231, 'Dreamworks');
299INSERT INTO `mydb`.`Box_Office` (`Movie_ID`, `Production_Cost`, `Opening_Week`, `Gross_Revenue`, `Net_Revenue`, `Production_Company`) VALUES (13, 60000000, 42347760, 267665011, 207665011, 'Pixar');
300INSERT INTO `mydb`.`Box_Office` (`Movie_ID`, `Production_Cost`, `Opening_Week`, `Gross_Revenue`, `Net_Revenue`, `Production_Company`) VALUES (14, 22700000, 6600000, 38119483, 15419483, 'Brooksfilms');
301INSERT INTO `mydb`.`Box_Office` (`Movie_ID`, `Production_Cost`, `Opening_Week`, `Gross_Revenue`, `Net_Revenue`, `Production_Company`) VALUES (15, 180000000, 63087526, 223808164, 43808164, 'Pixar');
302
303COMMIT;
304
305
306-- -----------------------------------------------------
307-- Data for table `mydb`.`Actors`
308-- -----------------------------------------------------
309START TRANSACTION;
310USE `mydb`;
311INSERT INTO `mydb`.`Actors` (`Actor_ID`, `First_Name`, `Last_Name`, `Gender`, `Nationality`, `Date_Of_Birth`, `Number_Of_Awards`, `Number_Of_Movies`) VALUES (1, 'Mark', 'Hamil', 'M', 'White', '9/25/1951', 16, 305);
312INSERT INTO `mydb`.`Actors` (`Actor_ID`, `First_Name`, `Last_Name`, `Gender`, `Nationality`, `Date_Of_Birth`, `Number_Of_Awards`, `Number_Of_Movies`) VALUES (2, 'Orlando', 'Bloom', 'M', 'White', '1/13/1977', 27, 41);
313INSERT INTO `mydb`.`Actors` (`Actor_ID`, `First_Name`, `Last_Name`, `Gender`, `Nationality`, `Date_Of_Birth`, `Number_Of_Awards`, `Number_Of_Movies`) VALUES (3, 'Viggo', 'Mortensen', 'M', 'White', '10/20/1958', 34, 58);
314INSERT INTO `mydb`.`Actors` (`Actor_ID`, `First_Name`, `Last_Name`, `Gender`, `Nationality`, `Date_Of_Birth`, `Number_Of_Awards`, `Number_Of_Movies`) VALUES (4, 'Mike', 'Myers', 'M', 'White', '5/25/1963', 29, 51);
315INSERT INTO `mydb`.`Actors` (`Actor_ID`, `First_Name`, `Last_Name`, `Gender`, `Nationality`, `Date_Of_Birth`, `Number_Of_Awards`, `Number_Of_Movies`) VALUES (5, 'Ben', 'Burtt', 'M', 'White', '7/12/1948', 17, 90);
316
317COMMIT;
318
319
320-- -----------------------------------------------------
321-- Data for table `mydb`.`Movies_Borrowed`
322-- -----------------------------------------------------
323START TRANSACTION;
324USE `mydb`;
325INSERT INTO `mydb`.`Movies_Borrowed` (`Lendee_ID`, `Movie_ID`) VALUES (1, 1);
326INSERT INTO `mydb`.`Movies_Borrowed` (`Lendee_ID`, `Movie_ID`) VALUES (2, 2);
327INSERT INTO `mydb`.`Movies_Borrowed` (`Lendee_ID`, `Movie_ID`) VALUES (3, 3);
328
329COMMIT;