You are viewing a plain text version of this content. The canonical link for it is here.
Posted to scm@geronimo.apache.org by jl...@apache.org on 2005/11/21 17:22:19 UTC
svn commit: r345928 - in /geronimo/trunk/sandbox/adventurebuilder: maven.xml
src/plan/adventure1.0.1-db-ra-plan.xml
src/plan/consumerwebsite1.0.1.ear-plan.xml src/sql/ab1.0.1.sql
Author: jlaskowski
Date: Mon Nov 21 08:22:05 2005
New Revision: 345928
URL: http://svn.apache.org/viewcvs?rev=345928&view=rev
Log:
Database is now properly populated for the Adventure Builder application
Added:
geronimo/trunk/sandbox/adventurebuilder/src/sql/ab1.0.1.sql (with props)
Modified:
geronimo/trunk/sandbox/adventurebuilder/maven.xml
geronimo/trunk/sandbox/adventurebuilder/src/plan/adventure1.0.1-db-ra-plan.xml
geronimo/trunk/sandbox/adventurebuilder/src/plan/consumerwebsite1.0.1.ear-plan.xml
Modified: geronimo/trunk/sandbox/adventurebuilder/maven.xml
URL: http://svn.apache.org/viewcvs/geronimo/trunk/sandbox/adventurebuilder/maven.xml?rev=345928&r1=345927&r2=345928&view=diff
==============================================================================
--- geronimo/trunk/sandbox/adventurebuilder/maven.xml (original)
+++ geronimo/trunk/sandbox/adventurebuilder/maven.xml Mon Nov 21 08:22:05 2005
@@ -71,16 +71,29 @@
<ant:arg value="--offline"/>
<ant:arg value="distribute"/>
<ant:arg value="${maven.build.dir}/plan/consumerwebsite1.0.1.ear-plan.xml"/>
- <!--ant:arg value="${ab.home}/project/apps/consumerwebsite/build/consumerwebsite.ear"/-->
- <ant:arg value="${ab.home}/consumerwebsite.ear"/>
+ <ant:arg value="${ab.home}/project/apps/consumerwebsite/build/consumerwebsite.ear"/>
+ <!-- ant:arg value="${ab.home}/consumerwebsite.ear"/-->
</ant:java>
+
+ <ant:echo>Creating Adventure Builder Database Schema</ant:echo>
+ <j:invokeStatic className="java.lang.System" method="setProperty">
+ <j:arg type="java.lang.String" value="derby.system.home"/>
+ <j:arg type="java.lang.String" value="${instDir}/var/derby"/>
+ </j:invokeStatic>
+ <ant:sql driver="org.apache.derby.jdbc.EmbeddedDriver"
+ url="jdbc:derby:AdventureDB;create=true" userid="" password="">
+ <ant:fileset dir="src/sql"/>
+ <ant:classpath>
+ <ant:pathelement location="${maven.repo.local}/org.apache.derby/jars/derby-${derby_version}.jar"/>
+ </ant:classpath>
+ </ant:sql>
</goal>
<goal name="ab:start" description="Start Adventure Builder">
<deploy:startRemoteServer
geronimoTarget="${instDir}"
debugPort="8000"
- configs="org/apache/geronimo/Adventure1.0.1 org/apache/geronimo/RuntimeDeployer"/>
+ configs="org/apache/geronimo/AdventureBuilder1.0.1"/>
<ant:echo message="Waiting for server at: ${instDir}"/>
<deploy:waitForStarted
uri="deployer:geronimo:jmx:rmi://localhost/jndi/rmi:/JMXConnector"
Modified: geronimo/trunk/sandbox/adventurebuilder/src/plan/adventure1.0.1-db-ra-plan.xml
URL: http://svn.apache.org/viewcvs/geronimo/trunk/sandbox/adventurebuilder/src/plan/adventure1.0.1-db-ra-plan.xml?rev=345928&r1=345927&r2=345928&view=diff
==============================================================================
--- geronimo/trunk/sandbox/adventurebuilder/src/plan/adventure1.0.1-db-ra-plan.xml (original)
+++ geronimo/trunk/sandbox/adventurebuilder/src/plan/adventure1.0.1-db-ra-plan.xml Mon Nov 21 08:22:05 2005
@@ -17,7 +17,7 @@
-->
<!-- $Rev$ $Date$ -->
<connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector"
- parentId="org/apache/geronimo/SystemDatabase"
+ parentId="org/apache/geronimo/SystemDatabase"
configId="org/apache/geronimo/AdventureDataSource1.0.1">
<resourceadapter>
Modified: geronimo/trunk/sandbox/adventurebuilder/src/plan/consumerwebsite1.0.1.ear-plan.xml
URL: http://svn.apache.org/viewcvs/geronimo/trunk/sandbox/adventurebuilder/src/plan/consumerwebsite1.0.1.ear-plan.xml?rev=345928&r1=345927&r2=345928&view=diff
==============================================================================
--- geronimo/trunk/sandbox/adventurebuilder/src/plan/consumerwebsite1.0.1.ear-plan.xml (original)
+++ geronimo/trunk/sandbox/adventurebuilder/src/plan/consumerwebsite1.0.1.ear-plan.xml Mon Nov 21 08:22:05 2005
@@ -18,7 +18,7 @@
<!-- $Rev$ $Date$ -->
<application xmlns="http://geronimo.apache.org/xml/ns/j2ee/application"
parentId="org/apache/geronimo/AdventureDataSource1.0.1"
- configId="org/apache/geronimo/Adventure1.0.1">
+ configId="org/apache/geronimo/AdventureBuilder1.0.1">
<module>
<web>adventure.war</web>
Added: geronimo/trunk/sandbox/adventurebuilder/src/sql/ab1.0.1.sql
URL: http://svn.apache.org/viewcvs/geronimo/trunk/sandbox/adventurebuilder/src/sql/ab1.0.1.sql?rev=345928&view=auto
==============================================================================
--- geronimo/trunk/sandbox/adventurebuilder/src/sql/ab1.0.1.sql (added)
+++ geronimo/trunk/sandbox/adventurebuilder/src/sql/ab1.0.1.sql Mon Nov 21 08:22:05 2005
@@ -0,0 +1,341 @@
+create table category (
+ catid varchar(20) NOT NULL,
+ locale varchar(10) NOT NULL,
+ name varchar(80),
+ description varchar(255),
+ imageuri varchar(80),
+ PRIMARY KEY (catid, locale)
+);
+
+create table lodging (
+ lodgingid varchar(20) not null,
+ locale varchar(10) not null,
+ location varchar(30) not null,
+ name varchar(80) not null,
+ description varchar(255) not null,
+ price decimal(10,2),
+ imageuri varchar(80) not null,
+ primary key (lodgingid , locale )
+);
+
+create table package (
+ packageid varchar(20) not null,
+ catid VARCHAR(20) not null,
+ locale varchar(10) not null,
+ location varchar(30) not null,
+ price decimal(10,2) not null,
+ name varchar(80),
+ description varchar(255),
+ imageuri varchar(80) not null,
+ lodgingid VARCHAR(20) not null,
+ primary key (packageid, locale) ,
+ foreign key (catid, locale) references category (catid, locale),
+ foreign key (lodgingid, locale) references lodging (lodgingid, locale)
+)
+;
+
+create table activity (
+ activityid VARCHAR(20) not null,
+ locale varchar(10) not null,
+ location varchar(30) not null,
+ name varchar(80) not null,
+ description varchar(255) not null,
+ price decimal(10,2),
+ imageuri varchar(80) not null,
+ primary key (activityid , locale )
+)
+;
+
+create table activitylist (
+ packageid VARCHAR(20) not null,
+ activityid VARCHAR(20) not null,
+ locale varchar(10) not null,
+ primary key (packageid , activityid ,locale),
+ foreign key (packageid , locale) references package (packageid, locale),
+ foreign key (activityid , locale) references activity(activityid , locale)
+)
+;
+
+create table transportation (
+ transportationid VARCHAR(20) not null,
+ locale varchar(10) not null,
+ origin varchar(30) not null,
+ destination varchar(30) not null,
+ carrier varchar(80) not null,
+ name varchar(80) not null,
+ departuretime varchar(80) not null,
+ arrivaltime varchar(80) not null,
+ description varchar(255) not null,
+ class varchar(20) not null,
+ price decimal(10,2),
+ imageuri varchar(80) not null,
+ primary key (transportationid , locale )
+)
+;
+
+create table signon (
+ username varchar(25) not null,
+ password varchar(25) not null,
+ primary key (username)
+)
+;
+
+create table account (
+ userid varchar(80) not null,
+ email varchar(80) not null,
+ firstname varchar(80) not null,
+ lastname varchar(80) not null,
+ addr1 varchar(80) not null,
+ addr2 varchar(40),
+ city varchar(80) not null,
+ state varchar(80) not null,
+ zip varchar(20) not null,
+ country varchar(20) not null,
+ phone varchar(80) not null,
+ primary key (userid)
+)
+;
+
+INSERT INTO category VALUES ('ISLAND', 'en_US', 'Island Adventures', 'Experience an island paradise in a way fit for your needs.','Island_Adventures.gif')
+;
+INSERT INTO category VALUES ('JUNGLE', 'en_US', 'Jungle Adventures', 'Experience a jungle paradise in a way fit for your needs.','Jungle_Adventures.gif')
+;
+INSERT INTO category VALUES ('MOUNTAIN', 'en_US', 'Mountain Adventures', 'Experience an elevated paradise with a view.','Mountain_Adventures.gif')
+;
+INSERT INTO category VALUES ('ORBITAL', 'en_US', 'Orbital Adventures', 'Experience a vacuum paradise with a beautiful view and where no one can hear you scream.','Space_Adventures.gif')
+;
+INSERT INTO category VALUES ('WESTERN', 'en_US', 'Western Adventures', 'Enjoy the Wild West.','Western_Adventures.gif')
+;
+INSERT INTO category VALUES ('SOUTH_POLE', 'en_US', 'South Pole Adventures', 'Experience a frozen paradise in a way fit for your needs.','SouthPole_Adventures.gif')
+;
+
+
+INSERT INTO lodging VALUES ('LODG-1', 'en_US', 'The Island of Maui', 'Budget Hotel','per night single ocuppancy' ,265.00,'Budget_Hotel_Icon.gif')
+;
+INSERT INTO lodging VALUES ('LODG-2', 'en_US', 'The Islands of the Bahamas', 'Downtown Luxury Hotel', 'per night single ocuppancy' ,260.00,'Luxury_Hotel_Icon.gif')
+;
+INSERT INTO lodging VALUES ('LODG-3', 'en_US', 'The Islands of Tahiti', 'Budget Hotel','per night single ocuppancy' ,187.00,'Budget_Hotel_Icon.gif')
+;
+INSERT INTO lodging VALUES ('LODG-4', 'en_US', 'Amazon Jungle', 'Jungle Cave Hotel','per night single ocuppancy' ,255.00,'Cave_Hotel_Icon.gif')
+;
+INSERT INTO lodging VALUES ('LODG-5', 'en_US', 'Amazon Jungle', 'Jungle Tent Hotel','per night single ocuppancy' ,156.00,'Tent_Hotel_Icon.gif')
+;
+INSERT INTO lodging VALUES ('LODG-6', 'en_US', 'Mt.Kilimanjaro', 'Mountain Cabin Hotel','per night single ocuppancy' ,195.00,'Log_Cabin_Hotel_Icon.gif')
+;
+INSERT INTO lodging VALUES ('LODG-7', 'en_US', 'Mt.Kilimanjaro', 'Mountain Cave Hotel','per night single ocuppancy' ,187.00,'Cave_Hotel_Icon.gif')
+;
+INSERT INTO lodging VALUES ('LODG-8', 'en_US', 'Space', 'Space Hotel','per night single ocuppancy' ,49887.00,'Space_Hotel_Icon.gif')
+;
+INSERT INTO lodging VALUES ('LODG-9', 'en_US', 'Antarctica', 'Snow Cave Hotel','per night single ocuppancy' ,289.00,'Snow_Cave_Hotel_Icon.gif')
+;
+INSERT INTO lodging VALUES ('LODG-10', 'en_US', 'Antarctica', 'Icy Igloo' ,'per night single ocuppancy' ,267.00,'Igloo_Hotel_Icon.gif')
+;
+INSERT INTO lodging VALUES ('LODG-11', 'en_US', 'Texas', 'Old Western Hotel' ,'per night single ocuppancy' ,227.00,'Budget_Hotel_Icon.gif')
+;
+INSERT INTO lodging VALUES ('LODG-12', 'en_US', 'Texas', 'Budget Hotel' ,'per night single ocuppancy' ,189.00,'Budget_Hotel_Icon.gif')
+;
+
+INSERT INTO package VALUES ('PACK-1','ISLAND', 'en_US', 'The Island of Maui', 1115.00,'Maui Survival Adventure', 'Practice your survival skills in an island paradise.', 'Island_Survival.gif','LODG-1')
+;
+INSERT INTO package VALUES ('PACK-2','ISLAND', 'en_US', 'The Islands of the Bahamas', 1135.00,'Bahamas Relaxation trip', 'Relax, unwind and enjoy in an island paradise.', 'Island_Relax.gif','LODG-2')
+;
+INSERT INTO package VALUES ('PACK-3','ISLAND', 'en_US', 'The Islands of Tahiti', 1269.00,'Tahiti Snorkeling Adventure', 'Practice your snorkeling skills in an island paradise.', 'Island_Snorkeling.gif','LODG-3')
+;
+INSERT INTO package VALUES ('PACK-4','JUNGLE','en_US', 'Amazon Jungle', 1756.00,'Amazon Appreciation Adventure','Practice your appreciation skills in a jungle paradise.','Jungle_Appreciation.gif','LODG-4')
+;
+INSERT INTO package VALUES ('PACK-5','JUNGLE','en_US', 'Amazon Jungle', 1213.00,'Amazon Survival Adventure','Explore the amazon rainforest.','Jungle_Survival.gif','LODG-5')
+;
+INSERT INTO package VALUES ('PACK-6','MOUNTAIN','en_US', 'Mt.Kilimanjaro', 1495.00,'Mountain Climbing Adventure','Practice your climing skills in an elevated paradise.','Mountain_Climbing.gif','LODG-6')
+;
+INSERT INTO package VALUES ('PACK-7','MOUNTAIN','en_US', 'Mt.Kilimanjaro', 1676.00,'Mountain Relaxation Adventure','Practice your relaxation skills in a elevated paradise.','Mountain_Relax.gif','LODG-7')
+;
+INSERT INTO package VALUES ('PACK-8','ORBITAL','en_US', 'Space', 1999999.00,'Orbital Appreciation Adventure', 'See the earth from a new perspective.', 'Space_Appreciation.gif','LODG-8')
+;
+INSERT INTO package VALUES ('PACK-9','SOUTH_POLE','en_US', 'Antarctica', 19957.00,'South Pole Survival Adventure', 'Practice your survival skills in a frozen paradise.', 'SouthPole_Survival.gif','LODG-9')
+;
+INSERT INTO package VALUES ('PACK-10','SOUTH_POLE','en_US', 'Antarctica', 18764.00,'South Pole Relaxation Adventure', 'Practice your relaxation skills in a frozen paradise.', 'SouthPole_Relax.gif','LODG-10')
+;
+INSERT INTO package VALUES ('PACK-11','WESTERN' ,'en_US', 'Texas', 764.00,'Urban Cowboy Adventure', 'Practice your cowboy skills in the wild wild west.', 'Western_Urban_Cowboy.gif','LODG-11')
+;
+INSERT INTO package VALUES ('PACK-12','WESTERN', 'en_US', 'Texas', 1862.00,'Dude Ranch Adventure', 'Practice your cowboy skills in a western paradise.', 'Western_Dude_Ranch.gif','LODG-12')
+;
+
+INSERT INTO activity VALUES ('ACTY-1', 'en_US', 'The Island of Maui', 'Snorkeling','Learn about life under the sea',100.00,'Activity_Boat_Ride_Icon.gif')
+;
+INSERT INTO activity VALUES ('ACTY-2', 'en_US', 'The Island of Maui','Helicopter Ride' , 'Get a spectacular view of the island',125.00,'Activity_Helicopter_Icon.gif')
+;
+INSERT INTO activity VALUES ('ACTY-3', 'en_US', 'The Island of Maui','Surfing', 'Experience the thrill - ride the waves',139.00,'Activity_Surfing_Icon.gif')
+;
+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,'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,'Activity_Spa_Massage_Icon.gif')
+;
+INSERT INTO activity VALUES ('ACTY-6', 'en_US', 'The Islands of the Bahamas', 'Fishing','Diferent species of fishes - the fish lover will never get disappointed',285.00,'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,'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,'Activity_ParaSail_Icon.gif')
+;
+INSERT INTO activity VALUES ('ACTY-9', 'en_US', 'The Islands of Tahiti', 'Fishing','Diferent species of fishes - the fish lover will never get disappointed',455.00,'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,'Activity_Boat_Ride_Icon.gif')
+;
+INSERT INTO activity VALUES ('ACTY-11', 'en_US', 'Amazon Jungle', 'Hiking', 'Explore the jungle',350.00,'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,'Activity_Bird_Watching_Icon.gif')
+;
+INSERT INTO activity VALUES ('ACTY-13', 'en_US', 'Amazon Jungle', 'Rafting', 'Enjoy rafting in the amazon',145.00,'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,'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,'Activity_Mountain_Climb_Icon.gif')
+;
+INSERT INTO activity VALUES ('ACTY-16', 'en_US', 'Mt.Kilimanjaro', 'Mountain Biking', 'Bike to a hidden waterfall',189.00,'Activity_Mountain_Bike_Icon.gif')
+;
+INSERT INTO activity VALUES ('ACTY-17', 'en_US', 'Mt.Kilimanjaro', 'Hiking', 'Explore the mountain',146.00,'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,'Activity_Bird_Watching_Icon.gif')
+;
+INSERT INTO activity VALUES ('ACTY-19', 'en_US', 'Mt.Kilimanjaro', 'Spa Masssge' , 'Be pampered and relax',172.00,'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,'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,'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,'Activity_Boat_Ride_Icon.gif')
+;
+INSERT INTO activity VALUES ('ACTY-23', 'en_US', 'Antarctica', 'Helicopter Ride', 'A memorable experience in the sky',389.00,'Activity_Helicopter_Icon.gif')
+;
+INSERT INTO activity VALUES ('ACTY-24', 'en_US', 'Antarctica', 'Hiking', 'Explore the South Pole',307.00,'Activity_Hiking_Icon.gif')
+;
+INSERT INTO activity VALUES ('ACTY-25', 'en_US', 'Antarctica', 'Barbeque', 'For the food lover',320.00,'Activity_BBQ_Icon.gif')
+;
+INSERT INTO activity VALUES ('ACTY-26', 'en_US', 'Antarctica', 'Fishing', 'Diferent species of fishes - the fish lover will never get disappointed',530.00,'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,'Activity_BBQ_Icon.gif')
+;
+INSERT INTO activity VALUES ('ACTY-28', 'en_US', 'Texas' , 'Bull Ride', 'Great way to reduce stress',320.00,'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,'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,'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,'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,'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,'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,'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,'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,'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,'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,'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,'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,'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,'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,'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,'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,'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,'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,'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,'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,'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,'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,'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,'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,'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,'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,'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,'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,'Airplane_Icon.gif')
+;
+
+INSERT INTO signon VALUES('j2ee','j2ee')
+;
+INSERT INTO account VALUES('j2ee', 'yourname@yourdomain.com','ABC', 'XYZ', '123 Some Road','Apartment 206', 'Santa Clara', 'CA', '94303', 'USA', '555-555-5555')
+;
Propchange: geronimo/trunk/sandbox/adventurebuilder/src/sql/ab1.0.1.sql
------------------------------------------------------------------------------
svn:executable = *