REM Define the products available on the system
REM $Id: PRODUCTS_BASE.sql 1638 2007-05-31 19:29:23Z drmills $

Insert into products_base values (1,112, 4, 'Plasma HD Television','AVAILABLE', 1499.99, 1999.99, 1599.99, 6, 'CLASS3', 'images/1.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (2,119, 7, 'PlayStation 2 Video Game','AVAILABLE', 85.00, 199.95, 101.99, 2, 'CLASS2', 'images/2.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (3,102, 6, 'Treo 650 Phone/PDA','AVAILABLE', 200.00, 299.99, 259.99, 6, 'CLASS2', 'images/3.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (4,106, 6, 'Treo 700w Phone/PDA','AVAILABLE', 300.00,399.99, 359.99, 6,  'CLASS2', 'images/4.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (5,106, 4, 'Tungsten E PDA','AVAILABLE', 100.00, 195.99, 175.99, 3, 'CLASS1', 'images/5.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (6,105, 7, 'XBox Video Game System','AVAILABLE',75.00, 159.99, 135.99, 3, 'CLASS2', 'images/6.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (7,105, 7, 'XBox 360 Video Game System','AVAILABLE', 150.00, 299.99, 229.99, 3, 'CLASS2', 'images/7.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (8,119, 7, 'Playstation Portable','AVAILABLE', 100.00, 199.99, 129.99, 3, 'CLASS2', 'images/8.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (9,105, 7, 'Nintendo DS','AVAILABLE', 55.00, 129.99, 76.99, 3, 'CLASS2', 'images/9.jpg' ,null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (10,123, 4, 'Zune 30Gb','AVAILABLE', 100.00, 225.99, 169.99, 3, 'CLASS2', 'images/10.jpg' ,null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (11,112, 6,'RAZR Cellular Phone','AVAILABLE', 140.00, 259.99, 209.99, 3, 'CLASS1', 'images/11.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (12,123, 4,'Muvo Personal MP3 Player','AVAILABLE', 64.00, 99.99, 78.99, 3, 'CLASS1', 'images/12.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (13,101, 6,'Bluetooth Adaptor','AVAILABLE', 5.00, 19.99, 6.99, 0, 'CLASS1', 'images/13.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (14,112, 6,'Bluetooth Phone Headset','AVAILABLE', 20.00, 49.99, 24.99, 0, 'CLASS1', 'images/14.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (15,106, 4,'Ipod Speakers','AVAILABLE', 35.00, 89.99, 55.99, 6, 'CLASS2', 'images/15.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (16,106, 4,'Creative Zen Vision W 60 GB','AVAILABLE', 290.00, 389.99, 329.99, 6, 'CLASS2', 'images/16.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (17,126, 4,'Ipod Video 80Gb','AVAILABLE', 200.00, 339.99, 299.95, 6, 'CLASS2', 'images/17.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (18,123, 4,'Ipod Shuffle 1Gb','AVAILABLE', 45.00, 99.99, 69.95, 6, 'CLASS2', 'images/18.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (19,114, 4,'Ipod Video 30Gb','AVAILABLE', 125.00, 249.99, 227.95, 6, 'CLASS2', 'images/19.gif', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (20,112, 4,'Ipod Video 60Gb','AVAILABLE', 175.00, 399.99, 279.99, 6, 'CLASS2', 'images/20.gif' ,null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (21,123, 4,'Ipod Nano 1Gb','AVAILABLE', 90.00, 149.95, 119.99, 6, 'CLASS2', 'images/21.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (22,126, 4,'Ipod Nano 2Gb','AVAILABLE', 100.00, 199.95, 129.99, 6, 'CLASS2', 'images/22.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (23,106, 4,'Ipod Nano 4Gb','AVAILABLE', 150.00, 249.95, 199.95, 6, 'CLASS2', 'images/23.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (24,103, 12,'17-Inch iMac','AVAILABLE', 400.00, 899.99, 699.99, 6, 'CLASS3', 'images/24.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (25,101, 12,'20-Inch iMac','AVAILABLE', 1000.00, 2499.99, 1499.99, 12, 'CLASS3', 'images/25.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (26,103, 12,'Mini Mac Computer','AVAILABLE', 400.00, 799.99, 599.99, 12, 'CLASS3', 'images/26.jpg' ,null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (27,107, 12,'17-Inch Powerbook','AVAILABLE', 2500.00, 3499.99, 3099.99, 12, 'CLASS3', 'images/27.jpg' ,null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (28,102, 12,'15-Inch MacBook Pro','AVAILABLE', 1000.00, 1999.99, 1499.99, 12, 'CLASS3', 'images/28.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);

Insert into products_base values (29,106, 4,'LCD HD Television','AVAILABLE', 600.00, 899.99, 699.99, 12, 'CLASS3', 'images/29.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (30,123, 5,'MPEG4 Camcorder','AVAILABLE', 200.00, 499.99, 239.99, 3, 'CLASS2', 'images/30.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (31,106, 5,'7 Megapixel Digital Camera','AVAILABLE', 300.00, 629.99, 399.99, 3, 'CLASS2', 'images/31.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (32,114, 5,'Internet Camera','AVAILABLE', 200.00, 439.99, 239.99, 3, 'CLASS2', 'images/32.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (33,106, 6,'Chocolate Phone','AVAILABLE', 300.00, 499.99, 399.99, 6, 'CLASS1', 'images/33.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (34,114, 5,'6 Megapixel Digital Camera','AVAILABLE', 200.00, 299.99, 249.99, 6, 'CLASS2', 'images/34.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (35,123, 6,'Blackberry 8100c','AVAILABLE', 300.00, 499.99, 399.99, 6, 'CLASS1', 'images/35.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (36,105, 7,'Nintendo Wii','AVAILABLE', 470.00, 659.99, 559.99, 12, 'CLASS2', 'images/36.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (37,119, 7,'Wii Remote','AVAILABLE', 60.00, 71.99, 69.99, 3, 'CLASS1', 'images/37.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);

Insert into products_base values (38,104, 8,'Beginning EJB Application Development','AVAILABLE', 15.00, 29.99, 25.99, 0, 'CLASS2', 'images/38.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (39,113, 8,'Pro EJB 3: Java Persistence API','AVAILABLE', 15.00, 35.99, 25.99, 0, 'CLASS2', 'images/39.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (40,104, 8,'The Oracle of Oracle','AVAILABLE', 5.00, 24.99, 10.99, 0, 'CLASS2', 'images/40.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (41,113, 8,'EJB3 In Action','AVAILABLE', 9.00, 29.99, 15.99, 0, 'CLASS2', 'images/41.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);

Insert into products_base values (42,103, 11,'Essential Bach','AVAILABLE', 4.00, 15.99, 6.99, 0, 'CLASS1', 'images/42.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (43,121, 11,'Beethoven Symphonies Collection','AVAILABLE', 6.00, 18.99, 12.99, 0, 'CLASS1', 'images/43.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (44,109, 11,'Essential Mozart','AVAILABLE', 6.00, 15.99, 6.99, 0, 'CLASS1', 'images/44.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (45,107, 11,'Chopin: Favorite Piano Works','AVAILABLE', 7.00, 17.99, 10.99, 0, 'CLASS1', 'images/45.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (46,117, 11,'Tchaikovsky''s Ballet','AVAILABLE', 9.00, 16.99, 11.99, 0, 'CLASS1', 'images/46.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (47,110, 11,'Dvorak''s Great Symphonies','AVAILABLE', 7.00, 16.99, 10.99, 0, 'CLASS1', 'images/47.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);

Insert into products_base values (48,100, 14,'Oracle Collaboration Suite (User Perpetual)','AVAILABLE', 60.00, 60.00, 60.00, 12, 'CLASS1', 'images/48.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (49,102, 14,'Oracle Application Server (Processor Perpetual)','AVAILABLE', 5000.00, 5000.00, 5000.00, 12, 'CLASS1', 'images/49.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (50,108, 14,'Oracle Database SE (Processor Perpetual)','AVAILABLE', 4995.00, 4995.00, 4995.00, 12, 'CLASS1', 'images/50.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (51,101, 14,'Oracle Database EE (Processor Perpetual)','AVAILABLE', 40000.00, 40000.00, 40000.00, 12, 'CLASS1', 'images/51.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (52,103, 14,'Oracle JDeveloper','AVAILABLE', 0.00, 0.00, 0.00, 12, 'CLASS1', 'images/52.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (53,104, 14,'Oracle Linux Premier Support','AVAILABLE', 1999.00, 1999.00, 1999.00, 12, 'CLASS1', 'images/53.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);

Insert into products_base values (54,107, 13,'Stapler','AVAILABLE', 4.00, 7.99, 6.99, 0, 'CLASS2', 'images/54.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (55,103, 13,'Red Swingline Stapler','AVAILABLE', 15.00, 32.99, 26.99, 12, 'CLASS2', 'images/55.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (56,108, 13,'7 port USB Hub','AVAILABLE', 20.00, 28.99, 24.99, 6, 'CLASS2', 'images/56.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (57,101, 13,'Multi-purpose Scissors','AVAILABLE', 10.00, 19.99, 14.99, 0, 'CLASS1', 'images/57.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (58,109, 13,'Roller Carrying Case','AVAILABLE', 50.00, 99.99, 64.99, 6, 'CLASS3', 'images/58.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (59,103, 13,'Contour Carrying Case','AVAILABLE', 40.00, 59.99, 44.99, 6, 'CLASS2', 'images/59.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);

Insert into products_base values (60,104, 8, 'JavaServer Faces: The Complete Reference','AVAILABLE', 18.00, 35.99, 24.99, 0, 'CLASS2', 'images/60.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (61,113, 8, 'Oracle JDeveloper for Forms and PL/SQL Developers','AVAILABLE', 20.00, 35.99, 24.99, 0, 'CLASS2', 'images/61.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);

Insert into products_base values (62,103, 9,'Rin Tin Tin Double Feature, Vol. 1 (1947)','AVAILABLE',3.00, 12.99, 8.99, 3, 'CLASS1', 'images/62.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (63,107, 9,'Rin Tin Tin Double Feature, Vol. 2 (1947)','AVAILABLE',3.00, 12.99, 8.99, 3, 'CLASS1', 'images/63.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (64,101, 9,'Sky King:Vol 1 TV Series (1958)','AVAILABLE',3.00, 12.99, 8.99, 3, 'CLASS1', 'images/64.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (65,104, 9,'Cheyenne - The Complete First Season (1955)','AVAILABLE',3.00, 12.99, 8.99, 3, 'CLASS1', 'images/65.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (66,110, 9,'Rawhide - The Complete First Season (1959)','AVAILABLE',3.00, 12.99, 8.99, 3, 'CLASS1', 'images/66.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);
Insert into products_base values (67,102, 9,'Colt .45 / Tall Man Riding / Fort Worth (1950)','AVAILABLE',3.00, 12.99, 8.99, 3, 'CLASS1', 'images/67.jpg', null, null, null, null, null, null, null, null, null, null, null, null, null, null,  null, null, 'SEED_DATA', SYSDATE, 'SEED_DATA', SYSDATE, 1);


