insertdata_oracle.sql

Sun公司Dream项目

'Short Description','Martin Scorsese''s Oscar-nominated epic focuses on the rise of Irish and Italian gangs in New York in the mid-1800s',
1,1,'Starz','2002-05-02','2003-06-02','USA',1,'Showing',1,1,120,1,1,1,1,NULL,
'2004-07-04','2004-07-05',5,2,'/gangs.en.mpg','/gangs.jpg',9,9,'gangs');


insert into moviecatalog values (10,'LY00010','The Recruit','The Recruit','The Recruit',
'Short Description','Of all the CIA operatives-in-training, James Clayton (Colin Farrell) is the one agency veteran Walter Burke (Al Pacino) most wants to recruit',
1,1,'Starz','2002-05-03','2003-06-03','USA',1,'Showing',1,1,120,1,1,1,1,NULL,
'2004-07-04','2004-07-05',5,2,'/recruit.en.mpg','/recruit.jpg',10,10,'recruit');


insert into moviecatalog values (4,'LY00005','Freaky Friday','Freaky Friday','Freaky Friday', 'Short Description',
'Jamie Lee Curtis stars as Tess Coleman, mother of 15-year-old Anna',
1,4,'Starz','2002-05-02','2003-06-02','USA',1,'Showing',1,1,120,1,1,1,1,NULL,
'2004-07-04','2004-07-05',5,2,'/freaky.en.mpg','/freaky.jpg',4,4,'freaky');

insert into movie_metadata values (4,'2003-06-02','USA', 'ENU', 'USA', '','','','','SUN');
insert into movie_metadata values (5,'2003-06-02','USA', 'ENU', 'USA', '','','','','SUN');
insert into movie_metadata values (7,'2003-06-02','USA', 'ENU', 'USA', '','','','','SUN');
insert into movie_metadata values (9,'2003-06-02','USA', 'ENU', 'USA', '','','','','SUN');
insert into movie_metadata values (8,'2003-06-02','USA', 'ENU', 'USA', '','','','','SUN');
insert into movie_metadata values (10,'2003-06-02','USA', 'ENU', 'USA', '','','','','SUN');

insert into movieurls values( 1,'152.70.12.105', 11000 ,'/lotr.en.mpg');
insert into movieurls values( 2,'152.70.12.105',11000,'/batman.en.mpg');
insert into movieurls values( 3,'152.70.12.105', 11000,'/daddy.en.mpg');
insert into movieurls values( 4,'152.70.12.105', 11000,'/freaky.en.mpg');
insert into movieurls values( 5,'152.70.12.105', 11000,'/pianist.en.mpg');
insert into movieurls values( 6,'152.70.12.105', 11000,'/chicago.en.mpg');
insert into movieurls values( 7,'152.70.12.105', 11000,'/am.en.mpg');
insert into movieurls values( 8,'152.70.12.105', 11000,'/final.en.mpg');
insert into movieurls values( 9,'152.70.12.105', 11000,'/gangs.en.mpg');
insert into movieurls values(10,'152.70.12.105', 11000,'/recruit.en.mpg');

insert into moviegenres values( 1,' Action and Adventure',  2);
insert into moviegenres values( 2,' Adult Movies ', 0);
insert into moviegenres values( 3,' Classic Hollywood', 1);
insert into moviegenres values( 4 ,'Comedy', 2);
insert into moviegenres values( 5,' Comic and Animation ',0);
insert into moviegenres values( 6,'Cult Movies',  0);
insert into moviegenres values( 7,' Documentary', 0);
insert into moviegenres values( 8,' Drama',  2);
insert into moviegenres values( 9,' Family ', 0);
insert into moviegenres values(10,' Film Noir ', 0);
insert into moviegenres values(11,' Horror', 1);
insert into moviegenres values(12,' Martial Arts', 0);
insert into moviegenres values(13,' Miscellaneous', 0);
insert into moviegenres values(14,' Musicals', 0);
insert into moviegenres values(15,' Science Fiction and Fantasy',1);
insert into moviegenres values(16,' Shakespearean',0);
insert into moviegenres values(17,'Silent Movies', 0);
insert into moviegenres values(18,' Sports ', 0);
insert into moviegenres values(19,'Teen Movies', 1);
insert into moviegenres values(20, 'War Movies', 0);
insert into moviegenres values( 21,' Westerns', 0);
insert into moviegenres values(100,' Science and Technology', 0);
insert into moviegenres values(102,' Movies', 2);

insert into ratings values(1,' G',' General Audiences. All Ages Admitted '); 
insert into ratings values(2,' PG',' Parental Guidance Suggested. Some Material May Not Be Suitable For Children');
insert into ratings values(3,' PG-13',' Parents Strongly Cautioned. Some Material May Be Inappropriate For Children');
insert into ratings values(4,' R',' Restricted. Under 17 Requires Accompanying Parent Or Adult Guardian');
insert into ratings values(5,' NC-17',' No One 17 And Under Admitted');


insert into stbtypes values (1, 'Philips', 'Silverbox');
insert into stbtypes values (2, 'ADB', 'ADB');

insert into auditlog values( to_date('2003-08-03 11:42:06'), 1000,' RENTAL ','MOVIEID=1',' OK');
insert into auditlog values( to_date('2003-04-03 11:17:10'), 1000,' RENTAL',' MOVIEID=1', 'OK');
insert into auditlog values( to_date('2003-04-07 10:35:46'),1000 ,'RENTAL',' MOVIEID=1', 'OK');
insert into auditlog values( to_date('2003-04-03 01:41:41'), 2000,' RENTAL',' MOVIEID=1', 'OK');
insert into auditlog values( to_date('2003-04-10 08:19:12'), 1000,' RENTAL',' MOVIEID=1',' OK');
insert into auditlog values( to_date('2003-04-10 08:33:30'),2000 ,'RENTAL',' MOVIEID=1',' OK');
insert into auditlog values( to_date('2003-09-29 11:20:42'), 2000,' RENTAL',' MOVIEID=1', 'OK');
insert into auditlog values( to_date('2003-10-16 03:32:09'), 2000, 'RENTAL','MOVIEID=1', 'OK');
insert into auditlog values( to_date('2003-10-16 03:32:26'), 2000, 'RENTAL', 'MOVIEID=1', 'OK');
insert into auditlog values( to_date('2003-10-23 10:58:22'), 1000, 'RENTAL', 'MOVIEID=1', 'OK');
insert into auditlog values( to_date('2003-10-23 11:03:06'),  1000, 'RENTAL',  'MOVIEID=1', 'OK');
insert into auditlog values( to_date('2003-10-23 11:28:03'), 1000, 'RENTAL', 'MOVIEID=1', 'OK');
insert into auditlog values( to_date('2003-10-23 11:46:50'),  2000, 'RENTAL', 'MOVIEID=1', 'OK');
insert into auditlog values( to_date('2003-10-23 12:00:11'), 1000, 'RENTAL', 'MOVIEID=1', 'OK');
insert into auditlog values( to_date('2003-10-23 12:02:51'), 1000, 'RENTAL', 'MOVIEID=1', 'OK');
insert into auditlog values( to_date('2003-10-27 07:36:06'), 1000, 'RENTAL', 'MOVIEID=1', 'OK');
insert into auditlog values( to_date('2003-10-29 03:19:52'), 1000, 'RENTAL', 'MOVIEID=1', 'OK');
insert into auditlog values( to_date('2003-11-05 10:11:58'),  2000, 'RENTAL', 'MOVIEID=1', 'OK');


insert into qamresources values('','192.168.1.2', 49410, '1', '1', null, 1);
insert into qamresources values('','192.168.1.2', 49412, '1', '2', null, 1);
insert into qamresources values('','192.168.1.2', 49414, '1', '3', null, 1);
insert into qamresources values('','192.168.1.2', 49416, '1', '4', null, 1);
insert into qamresources values('','192.168.1.2', 49418, '1', '5', null, 1);
insert into qamresources values('','192.168.1.2', 49420, '1', '6', null, 1);
insert into qamresources values('','192.168.1.2', 49422, '1', '7', null, 1);
insert into qamresources values('','192.168.1.2', 49424, '1', '8', null, 1);


insert into ipresourcesvod values(1221, '','192.168.1.2', null, 1);
insert into ipresourcesvod values(1222, '','192.168.1.2', null, 1);
insert into ipresourcesvod values(1223, '','192.168.1.2', null, 1);
insert into ipresourcesvod values(1224, '','192.168.1.2', null, 1);
insert into ipresourcesvod values(1225, '','192.168.1.2', null, 1);
insert into ipresourcesvod values(1226, '','192.168.1.2', null, 1);
insert into ipresourcesvod values(1227, '','192.168.1.2', null, 1);
insert into ipresourcesvod values(1228, '','192.168.1.2', null, 1);

insert into maxidvalues values(1);