schema.sql

java实现浏览器等本地桌面的功能

;
INSERT INTO activity VALUES ('ACTY-4', 'en_US', 'The Islands of the Bahamas', 'Snorkeling','Snorkel in crystal clear waters and learn  about life under the sea',300.00,'http://azonic.sfbay.sun.com/adventure/images/Activity_Boat_Ride_Icon.gif')
;
INSERT INTO activity VALUES ('ACTY-5', 'en_US', 'The Islands of the Bahamas','Spa Masssge' , 'Be pampered and relax ',325.00,'http://azonic.sfbay.sun.com/adventure/images/Activity_Spa_Massage_Icon.gif')
;
INSERT INTO activity VALUES ('ACTY-6', 'en_US', 'The Islands of the Bahamas', 'Fishing','Different species of fishes - the fish lover will never get disappointed',285.00,'http://azonic.sfbay.sun.com/adventure/images/Activity_Fishing_Icon.gif')
;
INSERT INTO activity VALUES ('ACTY-7', 'en_US', 'The Islands of Tahiti', 'Snorkeling','Snorkel in crystal clear waters and learn about life under the sea ',300.00,'http://azonic.sfbay.sun.com/adventure/images/Activity_Snorkeling_Icon.gif')
;
INSERT INTO activity VALUES ('ACTY-8', 'en_US', 'The Islands of Tahiti','Para Sailing' , 'Enjoy a great ride with a view',325.00,'http://azonic.sfbay.sun.com/adventure/images/Activity_ParaSail_Icon.gif')
;
INSERT INTO activity VALUES ('ACTY-9', 'en_US', 'The Islands of Tahiti', 'Fishing','Different species of fishes - the fish lover will never get disappointed',455.00,'http://azonic.sfbay.sun.com/adventure/images/Activity_Boat_Ride_Icon.gif')
;
INSERT INTO activity VALUES ('ACTY-10', 'en_US', 'Amazon Jungle', 'Boat Ride', 'Get a spectacular view of exotic flora and fauna',200.00,'http://azonic.sfbay.sun.com/adventure/images/Activity_Boat_Ride_Icon.gif')
;
INSERT INTO activity VALUES ('ACTY-11', 'en_US', 'Amazon Jungle', 'Hiking', 'Explore the jungle',350.00,'http://azonic.sfbay.sun.com/adventure/images/Activity_Hiking_Icon.gif')
;
INSERT INTO activity VALUES ('ACTY-12', 'en_US', 'Amazon Jungle', 'Bird Watching', 'For the bird lover . View hundreds of different species of birds',199.00,'http://azonic.sfbay.sun.com/adventure/images/Activity_Bird_Watching_Icon.gif')
;
INSERT INTO activity VALUES ('ACTY-13', 'en_US', 'Amazon Jungle', 'Rafting', 'Enjoy rafting in the amazon',145.00,'http://azonic.sfbay.sun.com/adventure/images/Activity_Rafting_Icon.gif')
;
INSERT INTO activity VALUES ('ACTY-14', 'en_US', 'Amazon Jungle', 'Crocodile Wrestling', 'Make new reptile friends while practicing your half nelson',189.00,'http://azonic.sfbay.sun.com/adventure/images/Activity_Crocodile_Wrestling_Icon.gif')
;
INSERT INTO activity VALUES ('ACTY-15', 'en_US', 'Mt.Kilimanjaro', 'Mountain Climbing', 'Enjoy the view from the summit',129.00,'http://azonic.sfbay.sun.com/adventure/images/Activity_Mountain_Climb_Icon.gif')
;
INSERT INTO activity VALUES ('ACTY-16', 'en_US', 'Mt.Kilimanjaro', 'Mountain Biking', 'Bike to a hidden waterfall',189.00,'http://azonic.sfbay.sun.com/adventure/images/Activity_Mountain_Bike_Icon.gif')
;
INSERT INTO activity VALUES ('ACTY-17', 'en_US', 'Mt.Kilimanjaro', 'Hiking', 'Explore the mountain',146.00,'http://azonic.sfbay.sun.com/adventure/images/Activity_Hiking_Icon.gif')
;
INSERT INTO activity VALUES ('ACTY-18', 'en_US', 'Mt.Kilimanjaro', 'Bird Watching', 'For the bird lover . View hundreds of different species of birds',172.00,'http://azonic.sfbay.sun.com/adventure/images/Activity_Bird_Watching_Icon.gif')
;
INSERT INTO activity VALUES ('ACTY-19', 'en_US', 'Mt.Kilimanjaro', 'Spa Masssge' , 'Be pampered and relax',172.00,'http://azonic.sfbay.sun.com/adventure/images/Activity_Spa_Massage_Icon.gif')
;
INSERT INTO activity VALUES ('ACTY-20', 'en_US', 'Space', 'Space Walk', 'Get the best view of the earth possible',1899867.00,'http://azonic.sfbay.sun.com/adventure/images/Activity_Space_Walk_Icon.gif')
;
INSERT INTO activity VALUES ('ACTY-21', 'en_US', 'Space', 'Space Experiments', 'Find answers to all your questions about space',1893477.00,'http://azonic.sfbay.sun.com/adventure/images/Activity_Space_Experiment_Icon.gif')
;
INSERT INTO activity VALUES ('ACTY-22', 'en_US', 'Antarctica', 'Boat Ride', 'Get a spectacular view from at sea on a luxurious yacht',367.00,'http://azonic.sfbay.sun.com/adventure/images/Activity_Boat_Ride_Icon.gif')
;
INSERT INTO activity VALUES ('ACTY-23', 'en_US', 'Antarctica', 'Helicopter Ride', 'A memorable experience in the sky',389.00,'http://azonic.sfbay.sun.com/adventure/images/Activity_Helicopter_Icon.gif')
;
INSERT INTO activity VALUES ('ACTY-24', 'en_US', 'Antarctica', 'Hiking', 'Explore the South Pole',307.00,'http://azonic.sfbay.sun.com/adventure/images/Activity_Hiking_Icon.gif')
;
INSERT INTO activity VALUES ('ACTY-25', 'en_US', 'Antarctica', 'Barbeque', 'For the food lover',320.00,'http://azonic.sfbay.sun.com/adventure/images/Activity_BBQ_Icon.gif')
;
INSERT INTO activity VALUES ('ACTY-26', 'en_US', 'Antarctica', 'Fishing', 'Different species of fishes - the fish lover will never get disappointed',530.00,'http://azonic.sfbay.sun.com/adventure/images/Activity_Boat_Ride_Icon.gif')
;
INSERT INTO activity VALUES ('ACTY-27', 'en_US', 'Texas', 'Barbeque', 'Enjoy the finest cuisine the wild wild west has to offer',350.00,'http://azonic.sfbay.sun.com/adventure/images/Activity_BBQ_Icon.gif')
;
INSERT INTO activity VALUES ('ACTY-28', 'en_US', 'Texas' , 'Bull Ride', 'Great way to reduce stress',320.00,'http://azonic.sfbay.sun.com/adventure/images/Activity_Bull_Ride_Icon.gif')
;

INSERT INTO activitylist VALUES ('PACK-1', 'ACTY-1', 'en_US')
;
INSERT INTO activitylist VALUES ('PACK-1', 'ACTY-2', 'en_US')
;
INSERT INTO activitylist VALUES ('PACK-1', 'ACTY-3', 'en_US')
;
INSERT INTO activitylist VALUES ('PACK-2', 'ACTY-4', 'en_US')
;
INSERT INTO activitylist VALUES ('PACK-2', 'ACTY-5', 'en_US')
;
INSERT INTO activitylist VALUES ('PACK-2', 'ACTY-6', 'en_US')
;
INSERT INTO activitylist VALUES ('PACK-3', 'ACTY-7', 'en_US')
;
INSERT INTO activitylist VALUES ('PACK-3', 'ACTY-8', 'en_US')
;
INSERT INTO activitylist VALUES ('PACK-3', 'ACTY-9', 'en_US')
;
INSERT INTO activitylist VALUES ('PACK-4', 'ACTY-10', 'en_US')
;
INSERT INTO activitylist VALUES ('PACK-4', 'ACTY-11', 'en_US')
;
INSERT INTO activitylist VALUES ('PACK-4', 'ACTY-12', 'en_US')
;
INSERT INTO activitylist VALUES ('PACK-5', 'ACTY-13', 'en_US')
;
INSERT INTO activitylist VALUES ('PACK-5', 'ACTY-11', 'en_US')
;
INSERT INTO activitylist VALUES ('PACK-5', 'ACTY-14', 'en_US')
;
INSERT INTO activitylist VALUES ('PACK-6', 'ACTY-15', 'en_US')
;
INSERT INTO activitylist VALUES ('PACK-6', 'ACTY-16', 'en_US')
;
INSERT INTO activitylist VALUES ('PACK-6', 'ACTY-17', 'en_US')
;
INSERT INTO activitylist VALUES ('PACK-7', 'ACTY-17', 'en_US')
;
INSERT INTO activitylist VALUES ('PACK-7', 'ACTY-18', 'en_US')
;
INSERT INTO activitylist VALUES ('PACK-7', 'ACTY-19', 'en_US')
;
INSERT INTO activitylist VALUES ('PACK-8', 'ACTY-20', 'en_US')
;
INSERT INTO activitylist VALUES ('PACK-8', 'ACTY-21', 'en_US')
;
INSERT INTO activitylist VALUES ('PACK-9', 'ACTY-22', 'en_US')
;
INSERT INTO activitylist VALUES ('PACK-9', 'ACTY-23', 'en_US')
;
INSERT INTO activitylist VALUES ('PACK-9', 'ACTY-24', 'en_US')
;
INSERT INTO activitylist VALUES ('PACK-10', 'ACTY-25', 'en_US')
;
INSERT INTO activitylist VALUES ('PACK-10', 'ACTY-26', 'en_US')
;
INSERT INTO activitylist VALUES ('PACK-11', 'ACTY-27', 'en_US')
;
INSERT INTO activitylist VALUES ('PACK-12', 'ACTY-28', 'en_US')
;

INSERT INTO transportation VALUES ('TRPN-1','en_US', 'Los Angeles' ,'The Island of Maui', 'Island Airlines', 'IA1234','10:30 AM','4:30 PM' , 'Airbus A319','economy class',600.00,'http://azonic.sfbay.sun.com/adventure/images/Airplane_Icon.gif')
;
INSERT INTO transportation VALUES ('TRPN-2','en_US', 'The Island of Maui', 'Los Angeles' , 'Island Airlines', 'IA1694','6:00 PM','1:00 AM' , 'Airbus A320','business class',1000.00,'http://azonic.sfbay.sun.com/adventure/images/Airplane_Icon.gif')
;
INSERT INTO transportation VALUES ('TRPN-3','en_US', 'Orlando' ,'The Islands of the Bahamas' , 'Dragon Airlines', 'DA1468','6:00 PM','11:55 PM' , 'Airbus A319','economy class',1750.00,'http://azonic.sfbay.sun.com/adventure/images/Airplane_Icon.gif')
;
INSERT INTO transportation VALUES ('TRPN-4', 'en_US', 'The Islands of the Bahamas' , 'Orlando', 'Dragon Airlines', 'DA4567','11:00 AM','4:55 PM', 'Airbus A319','business class',2100.00,'http://azonic.sfbay.sun.com/adventure/images/Airplane_Icon.gif')
;
INSERT INTO transportation VALUES ('TRPN-5', 'en_US', 'Austin', 'The Islands of Tahiti' , 'Island Airlines', 'IA4389','11:00 AM','6:00 PM', 'Airbus A320','economy class',2500.00,'http://azonic.sfbay.sun.com/adventure/images/Airplane_Icon.gif')
;
INSERT INTO transportation VALUES ('TRPN-6', 'en_US', 'The Islands of Tahiti' , 'Austin' , 'Island Airlines', 'IA8319','10:30 PM','5:30 AM', 'Airbus A320','economy class',2500.00,'http://azonic.sfbay.sun.com/adventure/images/Airplane_Icon.gif')
;
INSERT INTO transportation VALUES ('TRPN-7', 'en_US', 'Columbus' , 'Amazon Jungle' , 'Jungle King Airlines', 'JK4832','11:00 AM','8:00 PM', 'Airbus A319','business class',2100.00,'http://azonic.sfbay.sun.com/adventure/images/Airplane_Icon.gif')
;
INSERT INTO transportation VALUES ('TRPN-8', 'en_US', 'Amazon Jungle' , 'Columbus' , 'Jungle King Airlines', 'JK9231','9:00 PM','6:00 AM', 'Airbus A319','economy class',2900.00,'http://azonic.sfbay.sun.com/adventure/images/Airplane_Icon.gif')
;
INSERT INTO transportation VALUES ('TRPN-9', 'en_US', 'Detroit' , 'Mt.Kilimanjaro' , 'Mountain Airlines', 'MA5012','11:00 AM','10:00 PM', 'Airbus A320','economy class',2100.00,'http://azonic.sfbay.sun.com/adventure/images/Airplane_Icon.gif')
;
INSERT INTO transportation VALUES ('TRPN-10', 'en_US', 'Mt.Kilimanjaro' , 'Detroit' , 'Mountain Airlines', 'MA6821','10:30 PM','9:30 AM', 'Airbus A319','business class',2225.00,'http://azonic.sfbay.sun.com/adventure/images/Airplane_Icon.gif')
;
INSERT INTO transportation VALUES ('TRPN-11', 'en_US', 'Los Angeles' , 'Texas', 'Wild West Airlines', 'WA6932','11:00 AM','2:00 PM', 'Airbus A319','business class',1485.00,'http://azonic.sfbay.sun.com/adventure/images/Airplane_Icon.gif')
;
INSERT INTO transportation VALUES ('TRPN-12', 'en_US', 'Texas', 'Los Angeles' , 'Wild West Airlines', 'WA4483','5:30 PM','8:30 PM', 'Airbus A320','economy class',500.00,'http://azonic.sfbay.sun.com/adventure/images/Airplane_Icon.gif')
;
INSERT INTO transportation VALUES ('TRPN-13','en_US', 'Austin' ,'The Island of Maui', 'Island Airlines', 'IA1689','11:30 AM','5:30 PM' , 'Airbus A319','economy class',600.00,'http://azonic.sfbay.sun.com/adventure/images/Airplane_Icon.gif')
;
INSERT INTO transportation VALUES ('TRPN-14','en_US', 'The Island of Maui', 'Austin' , 'Island Airlines', 'IA1527','7:00 PM','2:00 AM' , 'Airbus A320','business class',1000.00,'http://azonic.sfbay.sun.com/adventure/images/Airplane_Icon.gif')
;
INSERT INTO transportation VALUES ('TRPN-15','en_US', 'Los Angeles' ,'The Islands of the Bahamas' , 'Dragon Airlines', 'DA1398','5:00 PM','10:55 PM' , '  Boeing A319','economy class',1750.00,'http://azonic.sfbay.sun.com/adventure/images/Airplane_Icon.gif')
;
INSERT INTO transportation VALUES ('TRPN-16', 'en_US', 'The Islands of the Bahamas' , 'Los Angeles', 'Dragon Airlines', 'DA9376','10:00 AM','3:55 PM', 'Boeing A319','business class',2100.00,'http://azonic.sfbay.sun.com/adventure/images/Airplane_Icon.gif')
;
INSERT INTO transportation VALUES ('TRPN-17', 'en_US', 'Columbus' , 'The Islands of Tahiti' , 'Island Airlines', 'IA5678','10:00 AM','5:00 PM', 'Boeing A320','economy class',2500.00,'http://azonic.sfbay.sun.com/adventure/images/Airplane_Icon.gif')
;
INSERT INTO transportation VALUES ('TRPN-18', 'en_US', 'The Islands of Tahiti' , 'Columbus' , 'Island Airlines', 'IA8754','9:30 PM','4:30 AM', 'Airbus A320','economy class',2500.00,'http://azonic.sfbay.sun.com/adventure/images/Airplane_Icon.gif')
;
INSERT INTO transportation VALUES ('TRPN-19', 'en_US', 'Orlando' , 'Amazon Jungle' , 'Jungle King Airlines', 'JK5678','10:00 AM','7:00 PM', 'Airbus A319','business class',2100.00,'http://azonic.sfbay.sun.com/adventure/images/Airplane_Icon.gif')
;
INSERT INTO transportation VALUES ('TRPN-20', 'en_US', 'Amazon Jungle' , 'Orlando' , 'Jungle King Airlines', 'JK7991','8:00 PM','5:00 AM', 'Boeing A319','economy class',2900.00,'http://azonic.sfbay.sun.com/adventure/images/Airplane_Icon.gif')
;
INSERT INTO transportation VALUES ('TRPN-21', 'en_US', 'Los Angeles' , 'Mt.Kilimanjaro' , 'Mountain Airlines', 'MA9542','10:00 AM','9:00 PM', 'Airbus A320','economy class',2100.00,'http://azonic.sfbay.sun.com/adventure/images/Airplane_Icon.gif')
;
INSERT INTO transportation VALUES ('TRPN-22', 'en_US', 'Mt.Kilimanjaro' , 'Los Angeles' , 'Mountain Airlines', 'MA9024','9:30 PM','8:30 AM', 'Airbus A319','business class',2225.00,'http://azonic.sfbay.sun.com/adventure/images/Airplane_Icon.gif')
;
INSERT INTO transportation VALUES ('TRPN-23', 'en_US', 'Detroit' , 'Texas', 'Wild West Airlines', 'WA7893','10:00 AM','3:00 PM', 'Airbus A319','business class',1485.00,'http://azonic.sfbay.sun.com/adventure/images/Airplane_Icon.gif')
;
INSERT INTO transportation VALUES ('TRPN-24', 'en_US', 'Texas', 'Detroit' , 'Wild West Airlines', 'WA9432','5:30 PM','10:30 PM', 'Airbus A320','economy class',500.00,'http://azonic.sfbay.sun.com/adventure/images/Airplane_Icon.gif')
;
INSERT INTO transportation VALUES ('TRPN-25', 'en_US', 'Space' , 'Florida', 'Space Airlines', 'WA7401','11:00 AM','3:00 PM', 'Space Shuttle','business class',21000550.00,'http://azonic.sfbay.sun.com/adventure/images/Shuttle_Icon.gif')
;
INSERT INTO transportation VALUES ('TRPN-26', 'en_US', 'Florida', 'Space' , 'Space Airlines', 'WA4701','7:30 PM','10:30 PM', 'Space Shuttle','business class',21000550.00,'http://azonic.sfbay.sun.com/adventure/images/Shuttle_Icon.gif')
;
INSERT INTO transportation VALUES ('TRPN-27', 'en_US', 'Detroit' , 'Antarctica ', 'South Pole Airlines', 'WA7801','10:00 AM','3:00 PM', 'Boeing A319','business class',4500.00,'http://azonic.sfbay.sun.com/adventure/images/Airplane_Icon.gif')
;
INSERT INTO transportation VALUES ('TRPN-28', 'en_US', 'Antarctica ', 'Detroit' , 'South Pole Airlines', 'WA4901','5:30 PM','10:30 PM', 'Boeing A320','economy class',4500.00,'http://azonic.sfbay.sun.com/adventure/images/Airplane_Icon.gif')
;

INSERT INTO signon VALUES('j2ee','j2ee')
;
INSERT INTO account VALUES('j2ee', '[e-mail]','ABC', 'XYZ', '123 Some Road','Apartment 206', 'Santa Clara', 'CA', '94303', 'USA', '555-555-5555')
;