Yurttas/PL/DBL/mssql/F/01/Movies/I-all.sql

  1/*
  2REM
  3REM i-all.sql
  4REM
  5REM Insert into Movie database tables.
  6REM
  7*/
  8
  9
 10/*
 11REM
 12REM
 13REM MovieExec-ins.sql
 14REM
 15REM
 16*/
 17
 18INSERT INTO MovieExec
 19  VALUES('Debbie Allen', 'Hollywood, CA', 3009, 100);
 20
 21INSERT INTO MovieExec
 22  VALUES('John Hughes', 'Hollywood, CA', 276, 500);
 23
 24INSERT INTO MovieExec
 25  VALUES('Brian Grazer', 'Hollywood, CA', 817, 750);
 26
 27INSERT INTO MovieExec
 28  VALUES('Wendy Finerman', 'Hollywood, CA', 1212, 500);
 29
 30INSERT INTO MovieExec
 31  VALUES('Peter Guber', 'Hollywood, CA', 1222, 800);
 32
 33INSERT INTO MovieExec
 34  VALUES('Su Armstrong', 'Hollywood, CA', 3002, 400);
 35
 36INSERT INTO MovieExec
 37  VALUES('Letty Aronson', 'Hollywood, CA', 413,  500);
 38
 39INSERT INTO MovieExec
 40  VALUES('Patrick Cassavetti', 'Hollywood, CA', 789, 300);
 41
 42/*
 43REM
 44REM
 45REM Studio-ins.sql
 46REM
 47REM
 48*/
 49
 50INSERT INTO Studio
 51  VALUES('DreamWorks SKG', 'Hollywood, CA', 3009);
 52
 53INSERT INTO Studio
 54  VALUES('Disney', 'Hollywood, CA', 276);
 55
 56INSERT INTO Studio
 57  VALUES('MCA/Universal Pictures', 'Hollywood, CA', 817);
 58
 59INSERT INTO Studio
 60  VALUES('Paramount', 'Hollywood, CA', 1212);
 61
 62INSERT INTO Studio
 63  VALUES('Warner Bros.', 'Hollywood, CA', 1222);
 64
 65INSERT INTO Studio
 66  VALUES('Be Gentlemen Limited Partnership', 'Hollywood, CA', 3002);
 67
 68INSERT INTO Studio
 69  VALUES('Miramax', 'Hollywood, CA', 413);
 70
 71INSERT INTO Studio
 72  VALUES('Haft Entertainment', 'Hollywood, CA', 789);
 73
 74/*
 75REM
 76REM
 77REM MovieStar-ins.sql
 78REM
 79REM
 80*/
 81
 82INSERT INTO MovieStar
 83  VALUES('Djimon Hounsou', 'Paris FR', 'M', 1970);
 84
 85INSERT INTO MovieStar
 86  VALUES('Anthony Hopkins', 'Port Talbort, Wales UK', 'M', 1937);
 87
 88INSERT INTO MovieStar
 89  VALUES('Ming-Na Wen', NULL, 'F', NULL);
 90
 91INSERT INTO MovieStar
 92  VALUES('Eddie Murphy', NULL, 'M', NULL);
 93
 94INSERT INTO MovieStar
 95  VALUES('Tom Hanks', NULL, 'M', NULL);
 96
 97INSERT INTO MovieStar
 98  VALUES('Ed Harris', NULL, 'M', NULL);
 99
100INSERT INTO MovieStar
101  VALUES('Bill Paxton', NULL, 'M', NULL);
102
103INSERT INTO MovieStar
104  VALUES('Sally Field', NULL, 'F', NULL);
105
106INSERT INTO MovieStar
107  VALUES('Liam Neeson', NULL, 'M', NULL);
108
109INSERT INTO MovieStar
110  VALUES('Ben Kingsley', NULL, 'M', NULL);
111
112INSERT INTO MovieStar
113  VALUES('Danny Glover', NULL, 'M', NULL);
114
115INSERT INTO MovieStar
116  VALUES('Whoopi Goldberg', NULL, 'F', NULL);
117
118INSERT INTO MovieStar
119  VALUES('Robin Williams', NULL, 'M', NULL);
120
121INSERT INTO MovieStar
122  VALUES('Marcia Gay Harden', NULL, 'F', NULL);
123
124INSERT INTO MovieStar
125  VALUES('Mat Damon', NULL, 'M', NULL);
126
127INSERT INTO MovieStar
128  VALUES('John Cusak', NULL, 'M', NULL);
129
130INSERT INTO MovieStar
131  VALUES('Jack Warden', NULL, 'M', NULL);
132
133INSERT INTO MovieStar
134  VALUES('Gwyneth Paltrow', NULL, 'F', NULL);
135
136INSERT INTO MovieStar
137  VALUES('James Cosmo', NULL, 'M', NULL);
138
139/*
140REM
141REM
142REM Movie-ins.sql
143REM
144REM
145*/
146
147INSERT INTO Movie
148  VALUES('Amistad', 1997, 152, 'color', 'DreamWorks SKG', 3009); 
149
150INSERT INTO Movie
151  VALUES('Mulan', 1998, 120, 'color', 'Disney', 276); 
152
153INSERT INTO Movie
154  VALUES('Apollo 13', 1995, 140, 'color', 'MCA/Universal Pictures', 817);
155
156INSERT INTO Movie
157  VALUES('Forrest Gump', 1994, 142, 'color', 'Paramount', 1212);
158
159INSERT INTO Movie
160  VALUES('Schindler''s List', 1993, 197, 'BW', 'MCA/Universal Pictures', 817);
161
162INSERT INTO Movie
163  VALUES('The Color Purple', 1985, 152, 'color', 'Warner Bros.', 1212);
164
165INSERT INTO Movie
166  VALUES('Flubber', 1998, 93, 'color', 'Disney', 276);
167
168INSERT INTO Movie
169  VALUES('Good Will Hunting', 1997, 126, 'color', 'Be Gentlemen Limited Partnership', 3002);
170
171INSERT INTO Movie
172  VALUES('Bullets Over Broadway', 1994, 98, 'color', 'Miramax', 413);
173
174INSERT INTO Movie
175  VALUES('Emma', 1996, 121, 'color', 'Haft Entertainment', 789);
176
177
178/*
179REM
180REM
181REM StarsIn-ins.sql
182REM
183REM
184*/
185
186INSERT INTO StarsIn
187  VALUES('Amistad', 1997, 'Djimon Hounsou');
188
189INSERT INTO StarsIn
190  VALUES('Mulan', 1998, 'Ming-Na Wen');
191
192INSERT INTO StarsIn
193  VALUES('Mulan', 1998, 'Eddie Murphy');
194
195INSERT INTO StarsIn
196  VALUES('Apollo 13', 1995, 'Tom Hanks');
197
198INSERT INTO StarsIn
199  VALUES('Apollo 13', 1995, 'Ed Harris');
200
201INSERT INTO StarsIn
202  VALUES('Apollo 13', 1995, 'Bill Paxton');
203
204INSERT INTO StarsIn
205  VALUES('Forrest Gump', 1994, 'Tom Hanks');
206
207INSERT INTO StarsIn
208  VALUES('Forrest Gump', 1994, 'Sally Field');
209
210INSERT INTO StarsIn
211  VALUES('Schindler''s List', 1993, 'Liam Neeson');
212
213INSERT INTO StarsIn
214  VALUES('Schindler''s List', 1993, 'Ben Kingsley');
215
216INSERT INTO StarsIn
217  VALUES('The Color Purple', 1985, 'Danny Glover');
218
219INSERT INTO StarsIn
220  VALUES('The Color Purple', 1985, 'Whoopi Goldberg');
221
222INSERT INTO StarsIn
223  VALUES('Flubber', 1998, 'Robin Williams');
224
225INSERT INTO StarsIn
226  VALUES('Flubber', 1998, 'Marcia Gay Harden');
227
228INSERT INTO StarsIn
229  VALUES('Good Will Hunting', 1997, 'Robin Williams');
230
231INSERT INTO StarsIn
232  VALUES('Good Will Hunting', 1997, 'Mat Damon');
233
234INSERT INTO StarsIn
235  VALUES('Bullets Over Broadway', 1994, 'John Cusak');
236
237INSERT INTO StarsIn
238  VALUES('Bullets Over Broadway', 1994, 'Jack Warden');
239
240INSERT INTO StarsIn
241  VALUES('Emma', 1996, 'Gwyneth Paltrow');
242
243INSERT INTO StarsIn
244  VALUES('Emma', 1996, 'James Cosmo');