dbdata.sql

Sun公司Dream项目

// family one
insert into mastersubscribers values (1000, 'Bernard', '1234', 'Bernard', 'Van Haecke', '15 Lozenberg', 'Zaventem', '1932', '[e-mail]', '[phone]');
insert into subsubscribers values (1000, 1, 'David', '1234', 'David', 'Delabassee');
insert into subsubscribers values (1000, 2, 'Rudy', '1234', 'Rudy', 'Van Hoe');
insert into subsubscribers values (1000, 3, 'Saskia', '1234', 'Saskia', 'Cremelie');
insert into subsubscribers values (1000, 4, 'Paul', '1234', 'Paul', 'De Decker');
insert into subsubscribers values (1000, 5, 'Geert', '1234', 'Geert', 'Vaillemans');
insert into subsubscribers values (1000, 6, 'Kelly', '1234', 'Kelly', 'Kishore');

// family two
insert into mastersubscribers values (2000, 'James', '1234', 'James', 'Goslings', '15 Lozenberg', 'Zaventem', '1932', '[e-mail]', '[phone]');
insert into subsubscribers values (2000, 10, 'Gerard', '1234', 'Gerard', 'Fernando');

// http://www.filmratings.com/guide.htm
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');

// http://dir.yahoo.com/Entertainment/Movies_and_Film/Genres/
insert into moviegenres values (1, 'Action and Adventure', 0);
insert into moviegenres values (2, 'Adult Movies', 0);
insert into moviegenres values (3, 'Classic Hollywood', 0);
insert into moviegenres values (4, 'Comedy', 0);
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', 0);
insert into moviegenres values (9, 'Family', 0);
insert into moviegenres values (10, 'Film Noir', 0);
insert into moviegenres values (11, 'Horror', 0);
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', 0);
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', 0);
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 (101, 'Sun Microsystems', 0);
insert into moviegenres values (102, 'Learning series', 0);


// registered set-top-boxes, identified by assigned IP address
// 129.159.233.250 is the one that we use in the POC
insert into subscrstb values ('0000-0000-0000-0001', 1000, 2, '00-50-DA-56-48-8D', '127.0.0.1', 'Lozenberg');
insert into subscrstb values ('0000-0000-0000-0002', 1000, 2, '00-50-DA-56-48-8D', '192.168.0.2', 'Lozenberg');
insert into subscrstb values ('0000-0000-0000-0002', 1000, 2, '00-50-DA-56-48-8D', '129.159.234.141', 'Lozenberg');
insert into subscrstb values ('0000-0000-0000-0002', 1000, 2, '00-50-DA-56-48-8D', '129.159.233.250', 'Lozenberg');

// types of set-top-boxes
insert into stbtypes values (1, 'Philips', 'Silverbox');
insert into stbtypes values (2, 'ADB', 'ADB');

// prepaid account for mastersubscribers
insert into subscracct values (1000, 1000);

// user subscriptions for movie categories
insert into subscrgenres values (1000, 1);
insert into subscrgenres values (1000, 2);
insert into subscrgenres values (1000, 3);
insert into subscrgenres values (1000, 4);
insert into subscrgenres values (1000, 5);
insert into subscrgenres values (1000, 6);
insert into subscrgenres values (1000, 7);
insert into subscrgenres values (1000, 18);
insert into subscrgenres values (1000, 21);
insert into subscrgenres values (1, 1);
insert into subscrgenres values (1, 2);
insert into subscrgenres values (2, 3);
insert into subscrgenres values (3, 1);
insert into subscrgenres values (2000, 1);
insert into subscrgenres values (10, 7);

//1 -2 3 -6 10


insert into subscrgenres values (1, 100);
insert into subscrgenres values (1, 101);
insert into subscrgenres values (1, 102);

insert into subscrgenres values (3, 100);
insert into subscrgenres values (3, 101);
insert into subscrgenres values (3, 102);

insert into subscrgenres values (10, 100);
insert into subscrgenres values (10, 101);
insert into subscrgenres values (10, 102);




// currently rented movies
insert into subscrentals values (1000, 1, null, 0, '');

// film data
insert into moviecatalog values (
1, 'LY1', 'Spiderman', 'Spiderman', 'Spiderman', 'With great power comes great responsibility', 'When bitten by a genetically modified spider, a nerdy high school student gains spider-like abilities which he must eventually use to fight evil as a superhero.', 1, 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/spidermanposter.jpg');

insert into moviedetail values (1, 5, '/movies/spiderman0.jpg');
insert into moviedetail values (1, 5, '/movies/spiderman1.jpg');
insert into moviedetail values (1, 5, '/movies/spiderman3.jpg');
insert into moviedetail values (1, 5, '/movies/spiderman7.jpg');
insert into moviedetail values (1, 5, '/movies/spiderman8.jpg');
insert into moviedetail values (1, 5, '/movies/spiderman9.jpg');
insert into moviedetail values (1, 5, '/movies/spiderman10.jpg');
insert into moviedetail values (1, 3, 'Sam Raimi');
insert into moviedetail values (1, 1, 'Tobey Maguire ... Peter Parker/Spider-Man');
insert into moviedetail values (1, 1, 'Willem Dafoe ... Norman Osborn/The Green Goblin');
insert into moviedetail values (1, 1, 'Kirsten Dunst ... Mary Jane Watson');
insert into moviedetail values (1, 1, 'James Franco ... Harry Osborn');



insert into moviecatalog values (
2, 'LY1', 
'Beyond Enemy Lines', 
'Beyond Enemy Lines', 
'Beyond Enemy Lines', 
'Beyond Enemy Lines', 
'A Navy navigator is shot down over enemy territory and is ruthlessly pursued by a secret police enforcer and the opposing troops. Meanwhile his commanding officer goes against orders in an attempt to rescue him',
 1, 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/enemylinesposter.jpg');
insert into moviedetail values (2, 3, 'John Moore (V)');
insert into moviedetail values (2, 1, 'Gene Hackman ....  Adm. Leslie Reigart ');
insert into moviedetail values (2, 1, 'Owen Wilson ....  Lt. Chris Burnett ');
insert into moviedetail values (2, 1, 'Gabriel Macht ....  Stackhouse ');
insert into moviedetail values (2, 5, '/movies/enemylines1.jpg');
insert into moviedetail values (2, 5, '/movies/enemylines2.jpg');
insert into moviedetail values (2, 5, '/movies/enemylines3.jpg');
insert into moviedetail values (2, 5, '/movies/enemylines4.jpg');
insert into moviedetail values (2, 5, '/movies/enemylines5.jpg');
insert into moviedetail values (2, 5, '/movies/enemylines6.jpg');




insert into moviecatalog values (
3, 'LY1', 
'xXx', 
'xXx', 
'xXx', 
'Triple X', 
'Former extreme sports athlete Xander XXX Cage, notorious for his death defying public stunts. Betting he can succeed where other conventional spies have failed, Xander is recruited by NSA Agent Gibbons (Samuel L. Jackson) to become a different kind ...',
 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/xxxposter.jpg');
insert into moviedetail values (3, 3, 'Rob Cohen');
insert into moviedetail values (3, 1, 'Vin Diesel');
insert into moviedetail values (3, 1, 'Samuel L. Jackson');
insert into moviedetail values (3, 1, 'Marton Csokas');
insert into moviedetail values (3, 5, '/movies/xxx1.jpg');
insert into moviedetail values (3, 5, '/movies/xxx2.jpg');
insert into moviedetail values (3, 5, '/movies/xxx3.jpg');
insert into moviedetail values (3, 5, '/movies/xxx4.jpg');
insert into moviedetail values (3, 5, '/movies/xxx5.jpg');
insert into moviedetail values (3, 5, '/movies/xxx6.jpg');
insert into moviedetail values (3, 5, '/movies/xxx7.jpg');
insert into moviedetail values (3, 5, '/movies/xxx8.jpg');
insert into moviedetail values (3, 5, '/movies/xxx9.jpg');
insert into moviedetail values (3, 5, '/movies/xxx10.jpg');
insert into moviedetail values (3, 5, '/movies/xxx11.jpg');
insert into moviedetail values (3, 5, '/movies/xxx12.jpg');
insert into moviedetail values (3, 5, '/movies/xxx13.jpg');
insert into moviedetail values (3, 5, '/movies/xxx14.jpg');
insert into moviedetail values (3, 5, '/movies/xxx15.jpg');


insert into moviecatalog values (
4, 'LY1', 
'Halloween Ressurection', 
'Halloween Ressurection', 
'Halloween Ressurection', 
'Halloween Ressurection', 
'Six students won a contest and can stay for one night at the house of the world s best known serial killer, Michael Myers...',
 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/halloweenresurrectionposter.jpg');
insert into moviedetail values (4, 3, 'Rick Rosenthal');
insert into moviedetail values (4, 1, 'Jamie Lee Curtis');
insert into moviedetail values (4, 1, 'Busta Rhymes');
insert into moviedetail values (4, 1, 'Tyra Banks');
insert into moviedetail values (4, 5, '/movies/halloweenresurrection1.jpg');
insert into moviedetail values (4, 5, '/movies/halloweenresurrection2.jpg');
insert into moviedetail values (4, 5, '/movies/halloweenresurrection3.jpg');




insert into moviecatalog values (
5, 'LY1', 
'Jet Lag', 
'Jet Lag', 
'Jet Lag', 
'Jet Lag', 
'She is called Rose and works as a beauty specialist. He is Felix, a businessman. Felix is single and has only time for his job. Due to a strike at the airport, they are stuck in the same hotel...',
 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/jetlagposter.jpg');
insert into moviedetail values (5, 3, 'Dani阬e Thompson');
insert into moviedetail values (5, 1, 'Jean R雗o');
insert into moviedetail values (5, 1, 'Juliette Binoche');
insert into moviedetail values (5, 5, '/movies/jetlag1.jpg');
insert into moviedetail values (5, 5, '/movies/jetlag2.jpg');



insert into moviecatalog values (
6, 'LY1', 
'The Ring', 
'The Ring',
'The Ring', 
'Before you die, you see the ring', 
'When her niece spontaneously dies of fright one week to the day she watched a disturbing video, a cynical journalist...',
 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/theringposter.jpg');