insertdata.sql

Sun公司Dream项目

1,8,'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,'/pianist.en.mpg','/pianist.jpg',5,5,'pianist');


insert into moviecatalog values (7,'LY00007','Anger Management','Anger Management','Anger Management',
'Short Description','The unlikely pairing of Adam Sandler and Jack Nicholson drives this wacky comedy about gentle businessman Dave Buznik (Sandler), who finds himself in anger management counseling after a dispute on an airplane',
1,4,'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,'/am.en.mpg','/angermgmt.jpg',7,7,'angermgmt');


insert into moviecatalog values (8,'LY00008','Final Destination 2','Final Destination 2','Final Destination 2',
'Short Description','On a road trip with friends to Daytona Beach, Kimberly has a premonition that saves everyone from a freak car accident. But that''s just the beginning.',
1,11,'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,'/final.en.mpg','/final2.jpg',8,8,'final2');


insert into moviecatalog values (9,'LY00009','Gangs of New York','Gangs of New York','Gangs of New York',
'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('2003-08-03 11:42:06:490000', 1000,' RENTAL ','MOVIEID=1',' OK');
insert into auditlog values('2003-04-03 11:17:10:273000', 1000,' RENTAL',' MOVIEID=1', 'OK');
insert into auditlog values('2003-04-07 10:35:46:172000',1000 ,'RENTAL',' MOVIEID=1', 'OK');
insert into auditlog values('2003-04-03 01:41:41:724000', 2000,' RENTAL',' MOVIEID=1', 'OK');
insert into auditlog values('2003-04-10 08:19:12:574000', 1000,' RENTAL',' MOVIEID=1',' OK');
insert into auditlog values('2003-04-10 08:33:30:442000',2000 ,'RENTAL',' MOVIEID=1',' OK');
insert into auditlog values('2003-09-29 11:20:42:304000', 2000,' RENTAL',' MOVIEID=1', 'OK');
insert into auditlog values('2003-10-16 03:32:09:196000', 2000, 'RENTAL','MOVIEID=1', 'OK');
insert into auditlog values('2003-10-16 03:32:26:104000', 2000, 'RENTAL', 'MOVIEID=1', 'OK');
insert into auditlog values('2003-10-23 10:58:22:827000', 1000, 'RENTAL', 'MOVIEID=1', 'OK');
insert into auditlog values('2003-10-23 11:03:06:045000',  1000, 'RENTAL',  'MOVIEID=1', 'OK');
insert into auditlog values('2003-10-23 11:28:03:516000', 1000, 'RENTAL', 'MOVIEID=1', 'OK');
insert into auditlog values('2003-10-23 11:46:50:046000',  2000, 'RENTAL', 'MOVIEID=1', 'OK');
insert into auditlog values('2003-10-23 12:00:11:108000', 1000, 'RENTAL', 'MOVIEID=1', 'OK');
insert into auditlog values('2003-10-23 12:02:51:145000', 1000, 'RENTAL', 'MOVIEID=1', 'OK');
insert into auditlog values('2003-10-27 07:36:06:531000', 1000, 'RENTAL', 'MOVIEID=1', 'OK');
insert into auditlog values('2003-10-29 03:19:52:420000', 1000, 'RENTAL', 'MOVIEID=1', 'OK');
insert into auditlog values('2003-11-05 10:11:58:483000',  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);

insert into fairuse_urls values('birds','rtsp://192.168.2.111:11000/birds.mpg&content_id=birds');
insert into fairuse_urls values('batman','rtsp://192.168.2.111:11000/batman.mpg&content_id=batman');
insert into fairuse_urls values('lotr','rtsp://192.168.2.111:11000/lotr.mpg&content_id=lotr');
insert into fairuse_urls values('final','rtsp://192.168.2.111:11000/final.mpg&content_id=final');
insert into fairuse_urls values('javacar','rtsp://192.168.2.111:11000/javacar.mpg&content_id=javacar');
insert into fairuse_urls values('recruit','rtsp://192.168.2.111:11000/recruit.mpg&content_id=recruit');