insertdata_oracle.sql

来自「Sun公司Dream项目」· SQL 代码 · 共 216 行 · 第 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(2000,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','127.0.0.1',' 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', to_date('2005-12-08 11:41:21'),'204');
insert into rtspsessions values (1000,'pianist.mpg', to_date('2006-01-11 12:00:28'),'111');
insert into rtspsessions values (4,'lotr.mpg', to_date('2005-07-28 10:36:55'),'4401');
insert into rtspsessions values (2000,'recruit.mpg', to_date('2005-11-01 11:49:56'),'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,to_date('2004-06-21 11:31:27'),2);
insert into billingcdr values(2000,4,to_date('2004-06-22 01:31:27'),2);
insert into billingcdr values(1000,7,to_date('2004-06-21 11:31:27'),2);
insert into billingcdr values(2000,9,to_date('2003-04-07 07:31:27'),2);

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

insert into opera_license_info values (0, 'John', 'operaShop0', 'pianist', 100, 70,  to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'John', 'operaShop0', 'gangs', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'John', 'operaShop0', 'angermgmt', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'John', 'operaShop0', 'final2', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'John', 'operaShop0', 'recruit', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'John', 'operaShop0', 'freaky', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'Hans', 'operaShop0', 'pianist', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'Hans', 'operaShop0', 'gangs', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'Hans', 'operaShop0', 'angermgmt', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'Hans', 'operaShop0', 'final2', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'Hans', 'operaShop0', 'recruit', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'Hans', 'operaShop0', 'freaky', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'Q', 'operaShop0', 'pianist', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'Q', 'operaShop0', 'gangs', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'Q', 'operaShop0', 'angermgmt', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'Q', 'operaShop0', 'final2', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'Q', 'operaShop0', 'recruit', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'Q', 'operaShop0', 'freaky', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'Anakin', 'operaShop0', 'pianist', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'Anakin', 'operaShop0', 'gangs', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'Anakin', 'operaShop0', 'angermgmt', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'Anakin', 'operaShop0', 'final2', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'Anakin', 'operaShop0', 'recruit', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'Anakin', 'operaShop0', 'freaky', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'Skywalker', 'operaShop0', 'pianist', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'Skywalker', 'operaShop0', 'gangs', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'Skywalker', 'operaShop0', 'angermgmt', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'Skywalker', 'operaShop0', 'final2', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'Skywalker', 'operaShop0', 'recruit', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'Skywalker', 'operaShop0', 'freaky', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'Bond', 'operaShop0', 'pianist', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'Bond', 'operaShop0', 'gangs', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'Bond', 'operaShop0', 'angermgmt', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'Bond', 'operaShop0', 'final2', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'Bond', 'operaShop0', 'recruit', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));
insert into opera_license_info values (0, 'Bond', 'operaShop0', 'freaky', 100, 70, to_date('2003-04-24 11:33:53'),  to_date('2007-04-24 11:33:53'));


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',
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',