dbdata.sql

Sun公司Dream项目

insert into moviedetail values (6, 3, 'Gore Verbinski');
insert into moviedetail values (6, 1, 'Naomi Watts ....  Rachel Keller');
insert into moviedetail values (6, 1, 'Martin Henderson (I) ....  Noah');
insert into moviedetail values (6, 5, '/movies/thering1.jpg');
insert into moviedetail values (6, 5, '/movies/thering2.jpg');
insert into moviedetail values (6, 5, '/movies/thering3.jpg');
insert into moviedetail values (6, 5, '/movies/thering4.jpg');
insert into moviedetail values (6, 5, '/movies/thering5.jpg');
insert into moviedetail values (6, 5, '/movies/thering6.jpg');
insert into moviedetail values (6, 5, '/movies/thering7.jpg');
insert into moviedetail values (6, 5, '/movies/thering8.jpg');




insert into moviecatalog values (
7, 'LY1', 
'Ghost Ship ', 
'Ghost Ship ', 
'Ghost Ship ', 
'Sea Evil', 
'A salvage crew that discovers a long-lost 1953 passenger ship floating lifeless in a remote region of the Bering Sea soon notices, as they try to tow it back to land, that "strange things" happen...',
 3, 1, 'Sony Pictures', DATE '2002-05-03', '03 May 2002', 'USA', 1, '', 3, 3, 120, 1, 1, 1, 1, 'dvb://233a.a.7', DATE '2002-09-01', DATE '2010-01-01', 2, 2, 
'/Outbreak', '/movies/ghostposter.jpg');
insert into moviedetail values (7, 3, 'Steve Beck');
insert into moviedetail values (7, 1, 'Gabriel Byrne ....  Murphy');
insert into moviedetail values (7, 1, 'Julianna Margulies ....  Epps');
insert into moviedetail values (7, 5, '/movies/ghost1.jpg');
insert into moviedetail values (7, 5, '/movies/ghost2.jpg');
insert into moviedetail values (7, 5, '/movies/ghost3.jpg');
insert into moviedetail values (7, 5, '/movies/ghost4.jpg');
insert into moviedetail values (7, 5, '/movies/ghost5.jpg');
insert into moviedetail values (7, 5, '/movies/ghost6.jpg');
insert into moviedetail values (7, 5, '/movies/ghost7.jpg');



insert into moviecatalog values (
8, 'LY1', 
'Resident Evil ', 
'Resident Evil ', 
'Resident Evil ', 
'Resident Evil', 
'A special military unit fights a powerful, out-of-control supercomputer and hundreds of scientists who have mutated into flesh-eating creatures after a laboratory accident',
 3, 1, 'Sony Pictures', DATE '2002-05-03', '03 May 2002', 'USA', 1, '', 3, 3, 120, 1, 1, 1, 1, 'dvb://233a.a.7', DATE '2002-09-01', DATE '2010-01-01', 2, 2, 
'/Outbreak', '/movies/residentevilposter.jpg');
insert into moviedetail values (8, 3, 'Paul W.S. Anderson');
insert into moviedetail values (8, 1, 'Milla Jovovich ....  Alice');
insert into moviedetail values (8, 1, 'Michelle Rodriguez ....  Rain Ocampo');
insert into moviedetail values (8, 1, 'Eric Mabius ....  Matt Addison');
insert into moviedetail values (8, 1, 'James Purefoy ....  Spencer Parks ');
insert into moviedetail values (8, 5, '/movies/residentevil0.jpg');
insert into moviedetail values (8, 5, '/movies/residentevil1.jpg');
insert into moviedetail values (8, 5, '/movies/residentevil2.jpg');
insert into moviedetail values (8, 5, '/movies/residentevil3.jpg');
insert into moviedetail values (8, 5, '/movies/residentevil4.jpg');
insert into moviedetail values (8, 5, '/movies/residentevil5.jpg');
insert into moviedetail values (8, 5, '/movies/residentevil6.jpg');
insert into moviedetail values (8, 5, '/movies/residentevil7.jpg');


insert into moviecatalog values (
9, 'LY1', 
'The Matrix ', 
'The Matrix ', 
'The Matrix ', 
'The Fight for the Future Begins ', 
'A computer hacker learns from mysterious rebels about the 1 nature of his reality and his role in the war against the controllers of it.',
 3, 1, 'Sony Pictures', DATE '2002-05-03', '03 May 2002', 'USA', 1, '', 3, 3, 120, 1, 1, 1, 1, 'dvb://233a.a.7', DATE '2002-09-01', DATE '2010-01-01', 2, 2, 
'/Outbreak', '/movies/matrixposter.jpg');
insert into moviedetail values (9, 3, 'Andy Wachowski');
insert into moviedetail values (9, 1, 'Keanu Reeves ....  Thomas A. Anderson/Neo ');
insert into moviedetail values (9, 1, 'Laurence Fishburne ....  Morpheus ');
insert into moviedetail values (9, 1, 'Carrie-Anne Moss ....  Trinity ');
insert into moviedetail values (9, 1, 'Hugo Weaving ....  Agent Smith ');
insert into moviedetail values (9, 5, '/movies/matrix0.jpg');
insert into moviedetail values (9, 5, '/movies/matrix1.jpg');
insert into moviedetail values (9, 5, '/movies/matrix2.jpg');
insert into moviedetail values (9, 5, '/movies/matrix3.jpg');
insert into moviedetail values (9, 5, '/movies/matrix4.jpg');
insert into moviedetail values (9, 5, '/movies/matrix5.jpg');
insert into moviedetail values (9, 5, '/movies/matrix6.jpg');
insert into moviedetail values (9, 5, '/movies/matrix7.jpg');
insert into moviedetail values (9, 5, '/movies/matrix8.jpg');
insert into moviedetail values (9, 5, '/movies/matrix9.jpg');


// Topology Manager resource allocation table (last field: 1=free, 0=busy)
insert into qamresources values (NULL, '10.0.0.2', 49154, '1', '1', NULL, 1);
insert into qamresources values (NULL, '10.0.0.2', 49156, '1', '2', NULL, 1);
insert into qamresources values (NULL, '10.0.0.2', 49158, '1', '3', NULL, 1);
insert into qamresources values (NULL, '10.0.0.2', 49160, '1', '4', NULL, 1);
insert into qamresources values (NULL, '10.0.0.2', 49162, '1', '5', NULL, 1);
insert into qamresources values (NULL, '10.0.0.2', 49164, '1', '6', NULL, 1);
insert into qamresources values (NULL, '10.0.0.2', 49166, '1', '7', NULL, 1);
insert into qamresources values (NULL, '10.0.0.2', 49168, '1', '8', NULL, 1);
insert into qamresources values (NULL, '10.0.0.2', 49170, '1', '9', NULL, 1);




insert into moviecatalog values (
100, 'LY1', 
'Critical Decision ', 
'Critical Decision ', 
'Critical Decision ', 
'Critical Decision ', 
'This is a documentary about Sun vision and technology...',
 3, 101, 'Sun Pictures', DATE '2002-05-03', '03 May 2002', 'USA', 1, '', 3, 3, 120, 1, 1, 1, 1, 'dvb://233a.a.7', DATE '2002-09-01', DATE '2010-01-01', 2, 2, 
'/Critical_Decision_PAL', '/movies/sunposter.jpg');
insert into moviedetail values (100, 3, 'John Gage');
insert into moviedetail values (100, 1, 'Scott Mc Nealy');
insert into moviedetail values (100, 1, 'James Goslings');


insert into moviecatalog values (
101, 'LY1', 
'Digital Journey Part 1 ', 
'Digital Journey Part 1 ', 
'Digital Journey Part 1 ', 
'Digital Journey Part 1 ', 
'This is a documentary about Sun vision and technology...',
 3, 101, 'Sun Pictures', DATE '2002-05-03', '03 May 2002', 'USA', 1, '', 3, 3, 120, 1, 1, 1, 1, 'dvb://233a.a.7', DATE '2002-09-01', DATE '2010-01-01', 2, 2, 
'/DigitalJourney_Part1_PAL', '/movies/sunposter.jpg');
insert into moviedetail values (101, 3, 'John Gage');
insert into moviedetail values (101, 1, 'Scott Mc Nealy');
insert into moviedetail values (101, 1, 'James Goslings');

insert into moviecatalog values (
102, 'LY1', 
'Digital Journey Part 2 ', 
'Digital Journey Part 2 ', 
'Digital Journey Part 2 ', 
'Digital Journey Part 2 ', 
'This is a documentary about Sun vision and technology...',
 3, 101, 'Sun Pictures', DATE '2002-05-03', '03 May 2002', 'USA', 1, '', 3, 3, 120, 1, 1, 1, 1, 'dvb://233a.a.7', DATE '2002-09-01', DATE '2010-01-01', 2, 2, 
'/DigitalJourney_Part2_PAL', '/movies/sunposter.jpg');
insert into moviedetail values (102, 3, 'John Gage');
insert into moviedetail values (102, 1, 'Scott Mc Nealy');
insert into moviedetail values (102, 1, 'James Goslings');


insert into moviecatalog values (
103, 'LY1', 
'Digital Journey TMBST ', 
'Digital Journey TMBST ', 
'Digital Journey TMBST ', 
'Digital Journey TMBST ', 
'This is a documentary about Sun vision and technology...',
 3, 101, 'Sun Pictures', DATE '2002-05-03', '03 May 2002', 'USA', 1, '', 3, 3, 120, 1, 1, 1, 1, 'dvb://233a.a.7', DATE '2002-09-01', DATE '2010-01-01', 2, 2, 
'/DigitalJourney_TMBST_PAL', '/movies/sunposter.jpg');
insert into moviedetail values (103, 3, 'John Gage');
insert into moviedetail values (103, 1, 'Scott Mc Nealy');
insert into moviedetail values (103, 1, 'James Goslings');


insert into moviecatalog values (
104, 'LY1', 
'Sun WGBH DAM ', 
'Sun WGBH DAM ', 
'Sun WGBH DAM ', 
'Sun WGBH DAM ', 
'This is a documentary about Sun vision and technology...',
 3, 101, 'Sun Pictures', DATE '2002-05-03', '03 May 2002', 'USA', 1, '', 3, 3, 120, 1, 1, 1, 1, 'dvb://233a.a.7', DATE '2002-09-01', DATE '2010-01-01', 2, 2, 
'/Sun_WGBH_DAM_PAL', '/movies/sunposter.jpg');
insert into moviedetail values (104, 3, 'John Gage');
insert into moviedetail values (104, 1, 'Scott Mc Nealy');
insert into moviedetail values (104, 1, 'James Goslings');




insert into moviecatalog values (
105, 'LY1', 
'Tahiti ', 
'Tahiti ', 
'Tahiti ', 
'Tahiti ', 
'This is a documentary about Sun vision and technology...',
 3, 101, 'Sun Pictures', DATE '2002-05-03', '03 May 2002', 'USA', 1, '', 3, 3, 120, 1, 1, 1, 1, 'dvb://233a.a.7', DATE '2002-09-01', DATE '2010-01-01', 2, 2, 
'/Tahiti', '/movies/sunposter.jpg');
insert into moviedetail values (105, 3, 'John Gage');
insert into moviedetail values (105, 1, 'Scott Mc Nealy');
insert into moviedetail values (105, 1, 'James Goslings');




insert into moviecatalog values (
106, 'LY1', 
'Java Car ', 
'Java Car ', 
'Java Car ', 
'Java Car ', 
'This is a documentary about Sun vision and technology...',
 3, 101, 'Sun Pictures', DATE '2002-05-03', '03 May 2002', 'USA', 1, '', 3, 3, 120, 1, 1, 1, 1, 'dvb://233a.a.7', DATE '2002-09-01', DATE '2010-01-01', 2, 2, 
'/javacar_pal', '/movies/sunposter.jpg');
insert into moviedetail values (106, 3, 'John Gage');
insert into moviedetail values (106, 1, 'Scott Mc Nealy');
insert into moviedetail values (106, 1, 'James Goslings');



insert into moviecatalog values (
107, 'LY1', 
'Networked Planet ', 
'Networked Planet ', 
'Networked Planet ', 
'Networked Planet ', 
'This is a documentary about Sun vision and technology...',
 3, 101, 'Sun Pictures', DATE '2002-05-03', '03 May 2002', 'USA', 1, '', 3, 3, 120, 1, 1, 1, 1, 'dvb://233a.a.7', DATE '2002-09-01', DATE '2010-01-01', 2, 2, 
'/networked_planet', '/movies/sunposter.jpg');
insert into moviedetail values (107, 3, 'John Gage');
insert into moviedetail values (107, 1, 'Scott Mc Nealy');
insert into moviedetail values (107, 1, 'James Goslings');