insertdata.sql

来自「Sun公司Dream项目」· SQL 代码 · 共 267 行 · 第 1/2 页

insert into mastersubscribers values (1000, 'Skywalker', '1234', 'Luke', 'Skywalker', '16 Zatura', 'Acropolis', '325567', '[e-mail]', '[phone]','123456789');
insert into mastersubscribers values (2000, 'Bond', '1234', 'James', 'Bond', '15 Nottingham', 'London', '19678', '[e-mail]', '[phone]','123456789');

insert into subsubscribers values(1000,1,'Anakin','1234','Anakin','Skywalker','123456789');
insert into subsubscribers values(1000,2,'Hans','1234','Hans','Solo','343456789');
insert into subsubscribers values(1000,3,'John','1234','Johnny','English','563456789');
insert into subsubscribers values(2000,4,'Q','1234','Doc','Q','783456789');

insert into  subscrstb values ('0000-0000-0000-0002', 1000,  2,'00-50-DA-56-48-8D', '192.70.40.73', ' STB');
insert into  subscrstb values ('0000-0000-0000-0007', 1000, 2 ,'00-50-DA-56-48-8D',' 198.60.40.75',' MTV');
insert into  subscrstb values ('0000-0000-0000-0001', 1000, 2, '00-50-DA-56-48-8D', '127.0.0.1', ' SWZ');
insert into  subscrstb values ('0000-0000-0000-0002', 2000, 2,'00-50-DA-56-48-8D','128.60.40.240',' SWZ');
insert into  subscrstb values ('0000-0000-0000-0003',1000,2, '00-50-DA-56-48-8D',' 128.60.40.239',' MTV');
insert into  subscrstb values ('0000-0000-0000-0004', 1000, 2,'00-50-DA-56-48-8D',' 132.70.35.82',' EMV');
insert into  subscrstb values ('0000-0000-0000-0005', 1000, 2,'00-50-DA-56-48-8D',' 151.71.50.273',' MTV');
insert into  subscrstb values ('0000-0000-0000-0006', 1000, 2,'00-50-DA-56-48-8D','163.66.240.29',' MTV');
insert into  subscrstb values ('0000-0000-0000-0002', 1000, 2 ,'00-50-DA-56-48-8D','182.254.24.21',' MTV');

insert into rtspsessions values (2,'2f2f.mpg','2005-12-08 11:41:21:467000','204');
insert into rtspsessions values (1000,'pianist.mpg','2006-01-11 12:00:28:947000','111');
insert into rtspsessions values (4,'lotr.mpg','2005-07-28 10:36:55:062000','4401');
insert into rtspsessions values (2000,'recruit.mpg','2005-11-01 11:49:56:377000','5598');

insert into subscrgenres values(2, 1000);
insert into subscrgenres values(3,1);
insert into subscrgenres values(4, 1);
insert into subscrgenres values(5, 1000);
insert into subscrgenres values(5,2);
insert into subscrgenres values(6, 2);
insert into subscrgenres values(100, 4);
insert into subscrgenres values(16,4);
insert into subscrgenres values(18,3);
insert into subscrgenres values(102,3);
insert into subscrgenres values(1, 2000);

insert into subscracct values (1000, 1200);
insert into subscracct values (2000, 900);

insert into billingcdr values(1000,5,'2004-06-21 11:31:27:491000',2);
insert into billingcdr values(2000,4,'2004-06-22 01:31:27:491000',2);
insert into billingcdr values(1000,7,'2004-06-21 11:31:27:491000',2);
insert into billingcdr values(2000,9,'2003-04-07 07:31:27:491000',2);

insert into subscrentals values (4, 1,'2003-04-24 11:33:53:977000', 0,'8.24');
insert into subscrentals values (7, 1000, '2003-04-24 11:29:48:645000',  0,'159.89');
insert into subscrentals values (9, 2,'2003-04-24 11:45:56:003000', 0,'5.86');
insert into subscrentals values (10, 2000, '2003-04-24 11:38:17:154000', 0,'110.73');
insert into subscrentals values (5, 1000, '2003-04-24 11:51:46:218000', 0, '6.87');
insert into subscrentals values (8, 4, '2003-08-23 11:42:06:251000',   0, '0.00');
insert into subscrentals values (4, 3, '2003-08-29 06:06:28:953000',  0, '291.86');

insert into opera_license_info values ('JPIANIST',0, 'John', 'operaShop0', 'pianist', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('JGANGS',0, 'John', 'operaShop0', 'gangs', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('JANGER', 0, 'John', 'operaShop0', 'angermgmt', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('JFINAL', 0, 'John', 'operaShop0', 'final2', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('JRECRUIT', 0, 'John', 'operaShop0', 'recruit', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('JFREAKY', 0, 'John', 'operaShop0', 'freaky', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('HPIANIST', 0, 'Hans', 'operaShop0', 'pianist', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('HGANGS', 0, 'Hans', 'operaShop0', 'gangs', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('HANGER', 0, 'Hans', 'operaShop0', 'angermgmt', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('HFINAL', 0, 'Hans', 'operaShop0', 'final2', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('HRECRUIT', 0, 'Hans', 'operaShop0', 'recruit', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('HFREAKY', 0, 'Hans', 'operaShop0', 'freaky', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('QPIANIST', 0, 'Q', 'operaShop0', 'pianist', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('QGANGS', 0, 'Q', 'operaShop0', 'gangs', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('QANGER', 0, 'Q', 'operaShop0', 'angermgmt', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('QFINAL', 0, 'Q', 'operaShop0', 'final2', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('QRECRUIT', 0, 'Q', 'operaShop0', 'recruit', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('QFREAKY', 0, 'Q', 'operaShop0', 'freaky', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('APIANIST', 0, 'Anakin', 'operaShop0', 'pianist', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('AGANGS', 0, 'Anakin', 'operaShop0', 'gangs', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('AANGER', 0, 'Anakin', 'operaShop0', 'angermgmt', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('AFINAL', 0, 'Anakin', 'operaShop0', 'final2', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('ARECRUIT', 0, 'Anakin', 'operaShop0', 'recruit', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('AFREAKY', 0, 'Anakin', 'operaShop0', 'freaky', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('SPIANIST', 0, 'Skywalker', 'operaShop0', 'pianist', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('SGANGS', 0, 'Skywalker', 'operaShop0', 'gangs', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('SANGER', 0, 'Skywalker', 'operaShop0', 'angermgmt', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('SFINAL', 0, 'Skywalker', 'operaShop0', 'final2', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('SRECRUIT', 0, 'Skywalker', 'operaShop0', 'recruit', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('SFREAKY', 0, 'Skywalker', 'operaShop0', 'freaky', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('BPIANIST', 0, 'Bond', 'operaShop0', 'pianist', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('BGANGS', 0, 'Bond', 'operaShop0', 'gangs', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('BANGER', 0, 'Bond', 'operaShop0', 'angermgmt', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('BFINAL', 0, 'Bond', 'operaShop0', 'final2', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('BRECRUIT', 0, 'Bond', 'operaShop0', 'recruit', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');
insert into opera_license_info values ('BFREAKY', 0, 'Bond', 'operaShop0', 'freaky', 100, 70, '2003-04-24 11:33:53:977000', '2007-04-24 11:33:53:977000');

insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','JPIANIST');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','JGANGS');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','JANGER');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','JFINAL');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','JRECRUIT');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','JFREAKY');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','HPIANIST');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','HGANGS');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','HANGER');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','HFINAL');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','HRECRUIT');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','HFREAKY');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','APIANIST');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','AGANGS');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','AANGER');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','AFINAL');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','ARECRUIT');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','AFREAKY');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','QPIANIST');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','QGANGS');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','QANGER');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','QFINAL');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','QRECRUIT');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','QFREAKY');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','SPIANIST');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','SGANGS');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','SANGER');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','SFINAL');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','SRECRUIT');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','SFREAKY');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','BPIANIST');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','BGANGS');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','BANGER');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','BFINAL');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','BRECRUIT');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','BFREAKY');

insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','O5M003');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','O5M004');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','O1M003');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','O1M001');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','O2M003');
insert into rights_info values ('UNRESTRICTED_PLAY','COUNT','3','O2M001');

insert into moviecatalog values (5,'LY00005','The Pianist','The Pianist','The Pianist', 'Short Description',
'Famed Polish concert pianist Wladyslaw Szpilman (Adrien Brody, who won an Oscar for the role) struggles to survive the onslaught of Nazi tyranny during World War II in this autobiographical film',