geronimo-scm mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From genspr...@apache.org
Subject svn commit: r1051888 - in /geronimo/server/trunk: ./ plugingroups/javaee6-tomcat/ plugingroups/javaee6-tomcat/src/main/history/ plugins/axis/ plugins/uddi/ plugins/uddi/uddi-db/src/main/sql/ plugins/uddi/uddi-jetty/ plugins/uddi/uddi-jetty/src/main/his...
Date Wed, 22 Dec 2010 13:27:19 GMT
Author: genspring
Date: Wed Dec 22 13:27:18 2010
New Revision: 1051888

URL: http://svn.apache.org/viewvc?rev=1051888&view=rev
Log:
GERONIMO-5005, updated juddi.sql for v3, repackage juddi war to use our own persistence.xml and libs.

Added:
    geronimo/server/trunk/plugins/uddi/uddi-war-repackage/
    geronimo/server/trunk/plugins/uddi/uddi-war-repackage/pom.xml
    geronimo/server/trunk/plugins/uddi/uddi-war-repackage/src/
    geronimo/server/trunk/plugins/uddi/uddi-war-repackage/src/main/
    geronimo/server/trunk/plugins/uddi/uddi-war-repackage/src/main/resources/
    geronimo/server/trunk/plugins/uddi/uddi-war-repackage/src/main/resources/WEB-INF/
    geronimo/server/trunk/plugins/uddi/uddi-war-repackage/src/main/resources/WEB-INF/classes/
    geronimo/server/trunk/plugins/uddi/uddi-war-repackage/src/main/resources/WEB-INF/classes/META-INF/
    geronimo/server/trunk/plugins/uddi/uddi-war-repackage/src/main/resources/WEB-INF/classes/META-INF/persistence.xml
Modified:
    geronimo/server/trunk/plugingroups/javaee6-tomcat/pom.xml
    geronimo/server/trunk/plugingroups/javaee6-tomcat/src/main/history/dependencies.xml
    geronimo/server/trunk/plugins/axis/pom.xml
    geronimo/server/trunk/plugins/uddi/pom.xml
    geronimo/server/trunk/plugins/uddi/uddi-db/src/main/sql/juddi.sql
    geronimo/server/trunk/plugins/uddi/uddi-jetty/pom.xml
    geronimo/server/trunk/plugins/uddi/uddi-jetty/src/main/history/dependencies.xml
    geronimo/server/trunk/plugins/uddi/uddi-tomcat/pom.xml
    geronimo/server/trunk/plugins/uddi/uddi-tomcat/src/main/history/dependencies.xml
    geronimo/server/trunk/plugins/uddi/uddi-tomcat/src/main/plan/plan.xml
    geronimo/server/trunk/pom.xml

Modified: geronimo/server/trunk/plugingroups/javaee6-tomcat/pom.xml
URL: http://svn.apache.org/viewvc/geronimo/server/trunk/plugingroups/javaee6-tomcat/pom.xml?rev=1051888&r1=1051887&r2=1051888&view=diff
==============================================================================
--- geronimo/server/trunk/plugingroups/javaee6-tomcat/pom.xml (original)
+++ geronimo/server/trunk/plugingroups/javaee6-tomcat/pom.xml Wed Dec 22 13:27:18 2010
@@ -88,12 +88,12 @@
             <type>car</type>
         </dependency>
 
-        <!--<dependency>-->
-            <!--<groupId>org.apache.geronimo.configs</groupId>-->
-            <!--<artifactId>uddi-tomcat</artifactId>-->
-            <!--<version>${project.version}</version>-->
-            <!--<type>car</type>-->
-        <!--</dependency>-->
+       <dependency>
+            <groupId>org.apache.geronimo.configs</groupId>
+            <artifactId>uddi-tomcat</artifactId>
+            <version>${project.version}</version>
+            <type>car</type>
+        </dependency>
 
         <!--<dependency>-->
             <!--<groupId>org.apache.geronimo.plugins.monitoring</groupId>-->

Modified: geronimo/server/trunk/plugingroups/javaee6-tomcat/src/main/history/dependencies.xml
URL: http://svn.apache.org/viewvc/geronimo/server/trunk/plugingroups/javaee6-tomcat/src/main/history/dependencies.xml?rev=1051888&r1=1051887&r2=1051888&view=diff
==============================================================================
--- geronimo/server/trunk/plugingroups/javaee6-tomcat/src/main/history/dependencies.xml (original)
+++ geronimo/server/trunk/plugingroups/javaee6-tomcat/src/main/history/dependencies.xml Wed Dec 22 13:27:18 2010
@@ -12,6 +12,11 @@
         <type>car</type>
     </dependency>
     <dependency>
+        <groupId>org.apache.geronimo.configs</groupId>
+        <artifactId>uddi-tomcat</artifactId>
+        <type>car</type>
+    </dependency>
+    <dependency>
         <groupId>org.apache.geronimo.plugingroups</groupId>
         <artifactId>client</artifactId>
         <type>car</type>

Modified: geronimo/server/trunk/plugins/axis/pom.xml
URL: http://svn.apache.org/viewvc/geronimo/server/trunk/plugins/axis/pom.xml?rev=1051888&r1=1051887&r2=1051888&view=diff
==============================================================================
--- geronimo/server/trunk/plugins/axis/pom.xml (original)
+++ geronimo/server/trunk/plugins/axis/pom.xml Wed Dec 22 13:27:18 2010
@@ -60,13 +60,21 @@
             <dependency>
                 <groupId>org.apache.juddi</groupId>
                 <artifactId>uddi-ws</artifactId>
-                <version>3.0.2</version>
+                <version>3.0.5-SNAPSHOT</version>
                 <exclusions>
                     <exclusion>
-                        <groupId>log4j</groupId>
-                        <artifactId>log4j</artifactId>
+			<groupId>javax.xml.bind</groupId>
+			<artifactId>jaxb-api</artifactId>
                     </exclusion>
-                </exclusions>
+                    <exclusion>
+			<groupId>com.sun.xml.ws</groupId>
+			<artifactId>jaxws-rt</artifactId>
+                    </exclusion>
+		     <exclusion>
+			<groupId>com.sun.xml.bind</groupId>
+			<artifactId>jaxb-impl</artifactId>
+                    </exclusion>
+		</exclusions>
             </dependency>
         </dependencies>
     </dependencyManagement>

Modified: geronimo/server/trunk/plugins/uddi/pom.xml
URL: http://svn.apache.org/viewvc/geronimo/server/trunk/plugins/uddi/pom.xml?rev=1051888&r1=1051887&r2=1051888&view=diff
==============================================================================
--- geronimo/server/trunk/plugins/uddi/pom.xml (original)
+++ geronimo/server/trunk/plugins/uddi/pom.xml Wed Dec 22 13:27:18 2010
@@ -31,13 +31,16 @@
     <description>
         UDDI plugin
     </description>
-
+        <properties>    
+        <juddiv3.version>3.0.5-SNAPSHOT</juddiv3.version>
+    </properties>    
     <modules>
         <module>uddi-db</module>
+    <module>uddi-war-repackage</module>
         <module>uddi-jetty</module>
         <module>uddi-tomcat</module>
   </modules>
-
+  
 
     <dependencyManagement>
         <dependencies>
@@ -48,10 +51,17 @@
                 <type>pom</type>
                 <scope>import</scope>
             </dependency>
+        <dependency>
+                <groupId>org.apache.geronimo.plugins</groupId>
+                <artifactId>axis</artifactId>
+                <version>${project.version}</version>
+                <type>pom</type>
+                <scope>import</scope>
+            </dependency>
             <dependency>
                 <groupId>org.apache.juddi</groupId>
                 <artifactId>juddiv3-war</artifactId>
-                <version>3.0.1</version>
+                <version>${juddiv3.version}</version>
                 <type>war</type>
                 <scope>provided</scope>
             </dependency>

Modified: geronimo/server/trunk/plugins/uddi/uddi-db/src/main/sql/juddi.sql
URL: http://svn.apache.org/viewvc/geronimo/server/trunk/plugins/uddi/uddi-db/src/main/sql/juddi.sql?rev=1051888&r1=1051887&r2=1051888&view=diff
==============================================================================
--- geronimo/server/trunk/plugins/uddi/uddi-db/src/main/sql/juddi.sql (original)
+++ geronimo/server/trunk/plugins/uddi/uddi-db/src/main/sql/juddi.sql Wed Dec 22 13:27:18 2010
@@ -1,725 +1,619 @@
---
--- Licensed to the Apache Software Foundation (ASF) under one or more
--- contributor license agreements.  See the NOTICE file distributed with
--- this work for additional information regarding copyright ownership.
--- The ASF licenses this file to You under the Apache License, Version 2.0
--- (the "License"); you may not use this file except in compliance with
--- the License.  You may obtain a copy of the License at
---
---    http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing, software
--- distributed under the License is distributed on an "AS IS" BASIS,
--- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
--- See the License for the specific language governing permissions and
--- limitations under the License.
---
--- $Rev$ $Date$
---
-
-CREATE TABLE BUSINESS_ENTITY
-(
-  BUSINESS_KEY VARCHAR(41) NOT NULL,
-  AUTHORIZED_NAME VARCHAR(255) NOT NULL,
-  PUBLISHER_ID VARCHAR(20) ,
-  OPERATOR VARCHAR(255) NOT NULL,
-  LAST_UPDATE TIMESTAMP NOT NULL,
-  PRIMARY KEY (BUSINESS_KEY)
-);
-
-CREATE TABLE BUSINESS_DESCR
-(
-  BUSINESS_KEY VARCHAR(41) NOT NULL,
-  BUSINESS_DESCR_ID INT NOT NULL,
-  LANG_CODE VARCHAR(5),
-  DESCR VARCHAR(255) NOT NULL,
-  PRIMARY KEY (BUSINESS_KEY,BUSINESS_DESCR_ID),
-  FOREIGN KEY (BUSINESS_KEY)
-    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
-);
-
-CREATE TABLE BUSINESS_CATEGORY
-(
-  BUSINESS_KEY VARCHAR(41) NOT NULL,
-  CATEGORY_ID INT NOT NULL,
-  TMODEL_KEY_REF VARCHAR(41) ,
-  KEY_NAME VARCHAR(255) ,
-  KEY_VALUE VARCHAR(255) NOT NULL,
-  PRIMARY KEY (BUSINESS_KEY,CATEGORY_ID),
-  FOREIGN KEY (BUSINESS_KEY)
-    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
-);
-
-CREATE TABLE BUSINESS_IDENTIFIER
-(
-  BUSINESS_KEY VARCHAR(41) NOT NULL,
-  IDENTIFIER_ID INT NOT NULL,
-  TMODEL_KEY_REF VARCHAR(41) ,
-  KEY_NAME VARCHAR(255) ,
-  KEY_VALUE VARCHAR(255) NOT NULL,
-  PRIMARY KEY (BUSINESS_KEY,IDENTIFIER_ID),
-  FOREIGN KEY (BUSINESS_KEY)
-    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
-);
-
-CREATE TABLE BUSINESS_NAME
-(
-  BUSINESS_KEY VARCHAR(41) NOT NULL,
-  BUSINESS_NAME_ID INT NOT NULL,
-  LANG_CODE VARCHAR(5),
-  NAME VARCHAR(255) NOT NULL,
-  PRIMARY KEY (BUSINESS_KEY,BUSINESS_NAME_ID),
-  FOREIGN KEY (BUSINESS_KEY)
-    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
-);
-
-CREATE TABLE CONTACT
-(
-  BUSINESS_KEY VARCHAR(41) NOT NULL,
-  CONTACT_ID INT NOT NULL,
-  USE_TYPE VARCHAR(255) ,
-  PERSON_NAME VARCHAR(255) NOT NULL,
-  PRIMARY KEY (BUSINESS_KEY,CONTACT_ID),
-  FOREIGN KEY (BUSINESS_KEY)
-    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
-);
-
-CREATE TABLE CONTACT_DESCR
-(
-  BUSINESS_KEY VARCHAR(41) NOT NULL,
-  CONTACT_ID INT NOT NULL,
-  CONTACT_DESCR_ID INT NOT NULL,
-  LANG_CODE VARCHAR(5),
-  DESCR VARCHAR(255) NOT NULL,
-  PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,CONTACT_DESCR_ID),
-  FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
-    REFERENCES CONTACT (BUSINESS_KEY,CONTACT_ID)
-);
-
-CREATE TABLE ADDRESS
-(
-  BUSINESS_KEY VARCHAR(41) NOT NULL,
-  CONTACT_ID INT NOT NULL,
-  ADDRESS_ID INT NOT NULL,
-  USE_TYPE VARCHAR(255) ,
-  SORT_CODE VARCHAR(10) ,
-  TMODEL_KEY VARCHAR(41) ,
-  PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,ADDRESS_ID),
-  FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
-    REFERENCES CONTACT (BUSINESS_KEY,CONTACT_ID)
-);
-
-CREATE TABLE ADDRESS_LINE
-(
-  BUSINESS_KEY VARCHAR(41) NOT NULL,
-  CONTACT_ID INT NOT NULL,
-  ADDRESS_ID INT NOT NULL,
-  ADDRESS_LINE_ID INT NOT NULL,
-  LINE VARCHAR(80) NOT NULL,
-  KEY_NAME VARCHAR(255) ,
-  KEY_VALUE VARCHAR(255) ,
-  PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,ADDRESS_ID,ADDRESS_LINE_ID),
-  FOREIGN KEY (BUSINESS_KEY,CONTACT_ID,ADDRESS_ID)
-    REFERENCES ADDRESS (BUSINESS_KEY,CONTACT_ID,ADDRESS_ID)
-);
-
-CREATE TABLE EMAIL
-(
-  BUSINESS_KEY VARCHAR(41) NOT NULL,
-  CONTACT_ID INT NOT NULL,
-  EMAIL_ID INT NOT NULL,
-  USE_TYPE VARCHAR(255) ,
-  EMAIL_ADDRESS VARCHAR(255) NOT NULL,
-  PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,EMAIL_ID),
-  FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
-    REFERENCES CONTACT (BUSINESS_KEY,CONTACT_ID)
-);
-
-CREATE TABLE PHONE
-(
-  BUSINESS_KEY VARCHAR(41) NOT NULL,
-  CONTACT_ID INT NOT NULL,
-  PHONE_ID INT NOT NULL,
-  USE_TYPE VARCHAR(255) ,
-  PHONE_NUMBER VARCHAR(50) NOT NULL,
-  PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,PHONE_ID),
-  FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
-    REFERENCES CONTACT (BUSINESS_KEY,CONTACT_ID)
-);
-
-CREATE TABLE DISCOVERY_URL
-(
-  BUSINESS_KEY VARCHAR(41) NOT NULL,
-  DISCOVERY_URL_ID INT NOT NULL,
-  USE_TYPE VARCHAR(255) NOT NULL,
-  URL VARCHAR(255) NOT NULL,
-  PRIMARY KEY (BUSINESS_KEY,DISCOVERY_URL_ID),
-  FOREIGN KEY (BUSINESS_KEY)
-    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
-);
-
-CREATE TABLE BUSINESS_SERVICE
-(
-  BUSINESS_KEY VARCHAR(41) NOT NULL,
-  SERVICE_KEY VARCHAR(41) NOT NULL,
-  LAST_UPDATE TIMESTAMP NOT NULL,
-  PRIMARY KEY (SERVICE_KEY),
-  FOREIGN KEY (BUSINESS_KEY)
-    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
-);
-
-CREATE TABLE SERVICE_DESCR
-(
-  SERVICE_KEY VARCHAR(41) NOT NULL,
-  SERVICE_DESCR_ID INT NOT NULL,
-  LANG_CODE VARCHAR(5),
-  DESCR VARCHAR(255) NOT NULL,
-  PRIMARY KEY (SERVICE_KEY,SERVICE_DESCR_ID),
-  FOREIGN KEY (SERVICE_KEY)
-    REFERENCES BUSINESS_SERVICE (SERVICE_KEY)
-);
-
-CREATE TABLE SERVICE_CATEGORY
-(
-  SERVICE_KEY VARCHAR(41) NOT NULL,
-  CATEGORY_ID INT NOT NULL,
-  TMODEL_KEY_REF VARCHAR(41) ,
-  KEY_NAME VARCHAR(255) ,
-  KEY_VALUE VARCHAR(255) NOT NULL,
-  PRIMARY KEY (SERVICE_KEY,CATEGORY_ID),
-  FOREIGN KEY (SERVICE_KEY)
-    REFERENCES BUSINESS_SERVICE (SERVICE_KEY)
-);
-
-CREATE TABLE SERVICE_NAME
-(
-  SERVICE_KEY VARCHAR(41) NOT NULL,
-  SERVICE_NAME_ID INT NOT NULL,
-  LANG_CODE VARCHAR(5) ,
-  NAME VARCHAR(255) NOT NULL,
-  PRIMARY KEY (SERVICE_KEY,SERVICE_NAME_ID),
-  FOREIGN KEY (SERVICE_KEY)
-    REFERENCES BUSINESS_SERVICE (SERVICE_KEY)
-);
-
-CREATE TABLE BINDING_TEMPLATE
-(
-  SERVICE_KEY VARCHAR(41) NOT NULL,
-  BINDING_KEY VARCHAR(41) NOT NULL,
-  ACCESS_POINT_TYPE VARCHAR(20) ,
-  ACCESS_POINT_URL VARCHAR(2000) ,
-  HOSTING_REDIRECTOR VARCHAR(255) ,
-  LAST_UPDATE TIMESTAMP NOT NULL,
-  PRIMARY KEY (BINDING_KEY),
-  FOREIGN KEY (SERVICE_KEY)
-    REFERENCES BUSINESS_SERVICE (SERVICE_KEY)
-);
-
-CREATE TABLE BINDING_CATEGORY
-(
-  BINDING_KEY VARCHAR(41) NOT NULL,
-  CATEGORY_ID INT NOT NULL,
-  TMODEL_KEY_REF VARCHAR(41),
-  KEY_NAME VARCHAR(255),
-  KEY_VALUE VARCHAR(255) NOT NULL,
-  PRIMARY KEY (BINDING_KEY,CATEGORY_ID),
-  FOREIGN KEY (BINDING_KEY)
-    REFERENCES BINDING_TEMPLATE (BINDING_KEY)
-);
-
-CREATE TABLE BINDING_DESCR
-(
-  BINDING_KEY VARCHAR(41) NOT NULL,
-  BINDING_DESCR_ID INT NOT NULL,
-  LANG_CODE VARCHAR(5),
-  DESCR VARCHAR(255) NOT NULL,
-  PRIMARY KEY (BINDING_KEY,BINDING_DESCR_ID),
-  FOREIGN KEY (BINDING_KEY)
-    REFERENCES BINDING_TEMPLATE (BINDING_KEY)
-);
-
-CREATE TABLE TMODEL_INSTANCE_INFO
-(
-  BINDING_KEY VARCHAR(41) NOT NULL,
-  TMODEL_INSTANCE_INFO_ID INT NOT NULL,
-  TMODEL_KEY VARCHAR(41) NOT NULL,
-  OVERVIEW_URL VARCHAR(255) ,
-  INSTANCE_PARMS VARCHAR(255) ,
-  PRIMARY KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID),
-  FOREIGN KEY (BINDING_KEY)
-    REFERENCES BINDING_TEMPLATE (BINDING_KEY)
-);
-
-CREATE TABLE TMODEL_INSTANCE_INFO_DESCR
-(
-  BINDING_KEY VARCHAR(41) NOT NULL,
-  TMODEL_INSTANCE_INFO_ID INT NOT NULL,
-  TMODEL_INSTANCE_INFO_DESCR_ID INT NOT NULL,
-  LANG_CODE VARCHAR(5),
-  DESCR VARCHAR(255) NOT NULL,
-  PRIMARY KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID,TMODEL_INSTANCE_INFO_DESCR_ID),
-  FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
-    REFERENCES TMODEL_INSTANCE_INFO (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
-);
-
-CREATE TABLE INSTANCE_DETAILS_DESCR
-(
-  BINDING_KEY VARCHAR(41) NOT NULL,
-  TMODEL_INSTANCE_INFO_ID INT NOT NULL,
-  INSTANCE_DETAILS_DESCR_ID INT NOT NULL,
-  LANG_CODE VARCHAR(5),
-  DESCR VARCHAR(255) NOT NULL,
-  PRIMARY KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID,INSTANCE_DETAILS_DESCR_ID),
-  FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
-    REFERENCES TMODEL_INSTANCE_INFO (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
-);
-
-CREATE TABLE INSTANCE_DETAILS_DOC_DESCR
-(
-  BINDING_KEY VARCHAR(41) NOT NULL,
-  TMODEL_INSTANCE_INFO_ID INT NOT NULL,
-  INSTANCE_DETAILS_DOC_DESCR_ID INT NOT NULL,
-  LANG_CODE VARCHAR(5),
-  DESCR VARCHAR(255) NOT NULL,
-  PRIMARY KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID,INSTANCE_DETAILS_DOC_DESCR_ID),
-  FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
-    REFERENCES TMODEL_INSTANCE_INFO (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
-);
-
-CREATE TABLE TMODEL
-(
-  TMODEL_KEY VARCHAR(41) NOT NULL,
-  AUTHORIZED_NAME VARCHAR(255) NOT NULL,
-  PUBLISHER_ID VARCHAR(20) ,
-  OPERATOR VARCHAR(255) NOT NULL,
-  NAME VARCHAR(255) NOT NULL,
-  LANG_CODE VARCHAR(5),
-  OVERVIEW_URL VARCHAR(255) ,
-  DELETED VARCHAR(5),
-  LAST_UPDATE TIMESTAMP NOT NULL,
-  PRIMARY KEY (TMODEL_KEY)
-);
-
-CREATE TABLE TMODEL_DESCR
-(
-  TMODEL_KEY VARCHAR(41) NOT NULL,
-  TMODEL_DESCR_ID INT NOT NULL,
-  LANG_CODE VARCHAR(5),
-  DESCR VARCHAR(255) NOT NULL,
-  PRIMARY KEY (TMODEL_KEY,TMODEL_DESCR_ID),
-  FOREIGN KEY (TMODEL_KEY)
-    REFERENCES TMODEL (TMODEL_KEY)
-);
-
-CREATE TABLE TMODEL_CATEGORY
-(
-  TMODEL_KEY VARCHAR(41) NOT NULL,
-  CATEGORY_ID INT NOT NULL,
-  TMODEL_KEY_REF VARCHAR(255) ,
-  KEY_NAME VARCHAR(255) ,
-  KEY_VALUE VARCHAR(255) NOT NULL,
-  PRIMARY KEY (TMODEL_KEY,CATEGORY_ID),
-  FOREIGN KEY (TMODEL_KEY)
-    REFERENCES TMODEL (TMODEL_KEY)
-);
-
-CREATE TABLE TMODEL_IDENTIFIER
-(
-  TMODEL_KEY VARCHAR(41) NOT NULL,
-  IDENTIFIER_ID INT NOT NULL,
-  TMODEL_KEY_REF VARCHAR(255) ,
-  KEY_NAME VARCHAR(255) ,
-  KEY_VALUE VARCHAR(255) NOT NULL,
-  PRIMARY KEY (TMODEL_KEY,IDENTIFIER_ID),
-  FOREIGN KEY (TMODEL_KEY)
-    REFERENCES TMODEL (TMODEL_KEY)
-);
-
-CREATE TABLE TMODEL_DOC_DESCR
-(
-  TMODEL_KEY VARCHAR(41) NOT NULL,
-  TMODEL_DOC_DESCR_ID INT NOT NULL,
-  LANG_CODE VARCHAR(5),
-  DESCR VARCHAR(255) NOT NULL,
-  PRIMARY KEY (TMODEL_KEY,TMODEL_DOC_DESCR_ID),
-  FOREIGN KEY (TMODEL_KEY)
-    REFERENCES TMODEL (TMODEL_KEY)
-);
-
-CREATE TABLE PUBLISHER_ASSERTION
-(
-  FROM_KEY VARCHAR(41) NOT NULL,
-  TO_KEY VARCHAR(41) NOT NULL,
-  TMODEL_KEY VARCHAR(41) NOT NULL,
-  KEY_NAME VARCHAR(255) NOT NULL,
-  KEY_VALUE VARCHAR(255) NOT NULL,
-  FROM_CHECK VARCHAR(5) NOT NULL,
-  TO_CHECK VARCHAR(5) NOT NULL,
-  FOREIGN KEY (FROM_KEY)
-    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY),
-  FOREIGN KEY (TO_KEY)
-    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
-);
-
-CREATE TABLE PUBLISHER
-(
-  PUBLISHER_ID VARCHAR(20) NOT NULL,
-  PUBLISHER_NAME VARCHAR(255) NOT NULL,
-  EMAIL_ADDRESS VARCHAR(255),
-  IS_ADMIN VARCHAR(5),
-  IS_ENABLED VARCHAR(5),
-  MAX_BUSINESSES INT,
-  MAX_SERVICES_PER_BUSINESS INT,
-  MAX_BINDINGS_PER_SERVICE INT,
-  MAX_TMODELS INT,
-  PRIMARY KEY (PUBLISHER_ID)
-);
-
-CREATE TABLE AUTH_TOKEN
-(
-  AUTH_TOKEN VARCHAR(51) NOT NULL,
-  PUBLISHER_ID VARCHAR(20) NOT NULL,
-  PUBLISHER_NAME VARCHAR(255) NOT NULL,
-  CREATED TIMESTAMP NOT NULL,
-  LAST_USED TIMESTAMP NOT NULL,
-  NUMBER_OF_USES INT NOT NULL,
-  TOKEN_STATE INT NOT NULL,
-  PRIMARY KEY (AUTH_TOKEN)
-);
-
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','Administrator','jUDDI.org','uddi-org:types','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#UDDItypes',CURRENT TIMESTAMP);
-
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4',0,'en','UDDI Type Taxonomy');
-
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4',0,'en','Taxonomy used to categorize Service Descriptions.');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');
-
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:DB77450D-9FA8-45D4-A7BC-04411D14E384','Administrator','jUDDI.org','unspsc-org:unspsc:3-1','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#UNSPSC31',CURRENT TIMESTAMP);
-
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:DB77450D-9FA8-45D4-A7BC-04411D14E384',0,'en','Product Taxonomy: UNSPSC (Version 3.1)');
-
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:DB77450D-9FA8-45D4-A7BC-04411D14E384',0,'en','This tModel defines the UNSPSC product taxonomy.');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:DB77450D-9FA8-45D4-A7BC-04411D14E384',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
-
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:CD153257-086A-4237-B336-6BDCBDCC6634','Administrator','jUDDI.org','unspsc-org:unspsc','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#UNSPSC',CURRENT TIMESTAMP);
-
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:CD153257-086A-4237-B336-6BDCBDCC6634',0,'en','Product Taxonomy: UNSPSC (Version 7.3)');
-
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:CD153257-086A-4237-B336-6BDCBDCC6634',0,'en','This tModel defines Version 7.3 of the UNSPSC product taxonomy.');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:CD153257-086A-4237-B336-6BDCBDCC6634',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:CD153257-086A-4237-B336-6BDCBDCC6634',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','Checked');
-
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2','Administrator','jUDDI.org','ntis-gov:naics:1997','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#NAICS',CURRENT TIMESTAMP);
-
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2',0,'en','Business Taxonomy: NAICS(1997 Release)');
-
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2',0,'en','This tModel defines the NAICS industry taxonomy.');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');
-
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88','Administrator','jUDDI.org','uddi-org:iso-ch:3166-1999','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#ISO3166',CURRENT TIMESTAMP);
-
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88',0,'en','ISO 3166-1:1997 and 3166-2:1998. Codes for names of countries and their subdivisions. Part 1: Country codes. Part 2:Country subdivision codes. Update newsletters include ISO 3166-1 V-1 (1998-02-05), V-2 (1999-10-01), ISO 3166-2 I-1 (1998)');
-
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88',0,'en','Taxonomy used to categorize entries by geographic location.');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');
-
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:A035A07C-F362-44DD-8F95-E2B134BF43B4','Administrator','jUDDI.org','uddi-org:general_keywords','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#GenKW',CURRENT TIMESTAMP);
-
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:A035A07C-F362-44DD-8F95-E2B134BF43B4',0,'en','Special taxonomy consisting of namespace identifiers and the keywords associated with the namespaces');
-
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:A035A07C-F362-44DD-8F95-E2B134BF43B4',0,'en','This tModel defines an unidentified taxonomy.');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:A035A07C-F362-44DD-8F95-E2B134BF43B4',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
-
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:4064C064-6D14-4F35-8953-9652106476A9','Administrator','jUDDI.org','uddi-org:owningBusiness','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#owningBusiness',CURRENT TIMESTAMP);
-
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:4064C064-6D14-4F35-8953-9652106476A9',0,'en','A pointer to a businessEntity that owns the tagged data.');
-
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:4064C064-6D14-4F35-8953-9652106476A9',0,'en','This tModel indicates the businessEntity that published or owns the tagged tModel. Used with tModels to establish an "owned" relationship with a registered businessEntity.');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:4064C064-6D14-4F35-8953-9652106476A9',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:4064C064-6D14-4F35-8953-9652106476A9',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');
-
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:807A2C6A-EE22-470D-ADC7-E0424A337C03','Administrator','jUDDI.org','uddi-org:relationships','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#Relationships',CURRENT TIMESTAMP);
-
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:807A2C6A-EE22-470D-ADC7-E0424A337C03',0,'en','Starter set classifications of businessEntity relationships');
-
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:807A2C6A-EE22-470D-ADC7-E0424A337C03',0,'en','This tModel is used to describe business relationships. Used in the publisher assertion messages.');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:807A2C6A-EE22-470D-ADC7-E0424A337C03',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','relationship');
-
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:327A56F0-3299-4461-BC23-5CD513E95C55','Administrator','jUDDI.org','uddi-org:operators','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#Operators',CURRENT TIMESTAMP);
-
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:327A56F0-3299-4461-BC23-5CD513E95C55',0,'en','Taxonomy for categorizing the businessEntity of an operator of a registry.');
-
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:327A56F0-3299-4461-BC23-5CD513E95C55',0,'en','This checked value set is used to identify UDDI operators.');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:327A56F0-3299-4461-BC23-5CD513E95C55',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:327A56F0-3299-4461-BC23-5CD513E95C55',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');
-
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E','Administrator','jUDDI.org','uddi-org:isReplacedBy','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#IsReplacedBy',CURRENT TIMESTAMP);
-
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E',0,'en','An identifier system used to point (using UDDI keys) to the tModel (or businessEntity) that is the logical replacement for the one in which isReplacedBy is used');
-
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E',0,'en','This is a checked value set.');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','identifier');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');
-
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:8609C81E-EE1F-4D5A-B202-3EB13AD01823','Administrator','jUDDI.org','dnb-com:D-U-N-S','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#D-U-N-S',CURRENT TIMESTAMP);
-
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:8609C81E-EE1F-4D5A-B202-3EB13AD01823',0,'en','Dun&Bradstreet D-U-N-S® Number');
-
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:8609C81E-EE1F-4D5A-B202-3EB13AD01823',0,'en','This tModel is used for the Dun&Bradstreet D-U-N-S® Number identifier.');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:8609C81E-EE1F-4D5A-B202-3EB13AD01823',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','identifier');
-
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:B1B1BAF5-2329-43E6-AE13-BA8E97195039','Administrator','jUDDI.org','thomasregister-com:supplierID','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#Thomas',CURRENT TIMESTAMP);
-
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:B1B1BAF5-2329-43E6-AE13-BA8E97195039',0,'en','Thomas Registry Suppliers');
-
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:B1B1BAF5-2329-43E6-AE13-BA8E97195039',0,'en','This tModel is used for the Thomas Register supplier identifier codes.');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:B1B1BAF5-2329-43E6-AE13-BA8E97195039',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','identifier');
-
-
-
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:6E090AFA-33E5-36EB-81B7-1CA18373F457','Administrator','admin','jUDDI.org','uddi-org:wsdl:types','http://www.oasis-open.org/committees/uddi-spec/doc/tn/uddi-spec-tc-tn-wsdl-v2.htm#wsdlTypes',CURRENT TIMESTAMP);
-
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:6E090AFA-33E5-36EB-81B7-1CA18373F457',0,'en','WSDL Type Category System');
-
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:6E090AFA-33E5-36EB-81B7-1CA18373F457',0,'en','The WSDL Entity Type tModel uses a number of UDDI entities to represent the various entities within a WSDL document.');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:6E090AFA-33E5-36EB-81B7-1CA18373F457',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','unchecked');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:6E090AFA-33E5-36EB-81B7-1CA18373F457',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','categorization');
-
-
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:D01987D1-AB2E-3013-9BE2-2A66EB99D824','Administrator','admin','jUDDI.org','uddi-org:xml:namespace','http://www.oasis-open.org/committees/uddi-spec/doc/tn/uddi-spec-tc-tn-wsdl-v2.htm#xmlNamespace',CURRENT TIMESTAMP);
-
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:D01987D1-AB2E-3013-9BE2-2A66EB99D824',0,'en','A category system used to indicate namespaces');
-
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:D01987D1-AB2E-3013-9BE2-2A66EB99D824',0,'en','A namespace provides necessary qualifying information about a technical concept or model. The XML Namespace tModel provides a mechanism to associate a namespace with a UDDI entity.');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:D01987D1-AB2E-3013-9BE2-2A66EB99D824',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','unchecked');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:D01987D1-AB2E-3013-9BE2-2A66EB99D824',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','categorization');
-
-
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:2EC65201-9109-3919-9BEC-C9DBEFCACCF6','Administrator','admin','jUDDI.org','uddi-org:xml:localName','http://www.oasis-open.org/committees/uddi-spec/doc/tn/uddi-spec-tc-tn-wsdl-v2.htm#xmlLocalName',CURRENT TIMESTAMP);
-
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:2EC65201-9109-3919-9BEC-C9DBEFCACCF6',0,'en','A category system used to indicate XML local names');
-
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:2EC65201-9109-3919-9BEC-C9DBEFCACCF6',0,'en','The XML Local Name tModel provides a mechanism to indicate the name attribute for the uddi:businessService.');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:2EC65201-9109-3919-9BEC-C9DBEFCACCF6',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','unchecked');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:2EC65201-9109-3919-9BEC-C9DBEFCACCF6',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','categorization');
-
-
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:082B0851-25D8-303C-B332-F24A6D53E38E','Administrator','admin','jUDDI.org','uddi-org:wsdl:portTypeReference','http://www.oasis-open.org/committees/uddi-spec/doc/tn/uddi-spec-tc-tn-wsdl-v2.htm#portTypeReference',CURRENT TIMESTAMP);
-
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:082B0851-25D8-303C-B332-F24A6D53E38E',0,'en','A category system used to reference a wsdl:portType tModel');
-
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:082B0851-25D8-303C-B332-F24A6D53E38E',0,'en','The WSDL portType Reference category system provides a mechanism to indicate that a UDDI entity has a relationship with a certain wsdl:portType tModel.');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:082B0851-25D8-303C-B332-F24A6D53E38E',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','checked');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:082B0851-25D8-303C-B332-F24A6D53E38E',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','categorization');
-
-
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:AA254698-93DE-3870-8DF3-A5C075D64A0E','Administrator','admin','jUDDI.org','uddi-org:protocol:soap','http://www.oasis-open.org/committees/uddi-spec/doc/tn/uddi-spec-tc-tn-wsdl-v2.htm#soap',CURRENT TIMESTAMP);
-
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:AA254698-93DE-3870-8DF3-A5C075D64A0E',0,'en','A tModel that represents the SOAP 1.1 protocol');
-
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:AA254698-93DE-3870-8DF3-A5C075D64A0E',0,'en','The SOAP Protocol tModel can be used to indicate that a Web service supports the SOAP 1.1 protocol.');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:AA254698-93DE-3870-8DF3-A5C075D64A0E',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','protocol');
-
-
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:6E10B91B-BABC-3442-B8FC-5A3C8FDE0794','Administrator','admin','jUDDI.org','uddi-org:protocol:http','http://www.oasis-open.org/committees/uddi-spec/doc/tn/uddi-spec-tc-tn-wsdl-v2.htm#http',CURRENT TIMESTAMP);
-
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:6E10B91B-BABC-3442-B8FC-5A3C8FDE0794',0,'en','A tModel that represents the HTTP protocol');
-
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:6E10B91B-BABC-3442-B8FC-5A3C8FDE0794',0,'en','The HTTP Protocol tModel can be used to indicate that a Web service supports the HTTP protocol.');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:6E10B91B-BABC-3442-B8FC-5A3C8FDE0794',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','protocol');
-
-
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:4DC74177-7806-34D9-AECD-33C57DC3A865','Administrator','admin','jUDDI.org','uddi-org:wsdl:categorization:protocol','http://www.oasis-open.org/committees/uddi-spec/doc/tn/uddi-spec-tc-tn-wsdl-v2.htm#protocol',CURRENT TIMESTAMP);
-
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:4DC74177-7806-34D9-AECD-33C57DC3A865',0,'en','Category system used to describe the protocol supported by a wsdl:binding.');
-
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:4DC74177-7806-34D9-AECD-33C57DC3A865',0,'en','The Protocol Categorization tModel provides a mechanism to capture this protocol information in the UDDI binding tModel.');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:4DC74177-7806-34D9-AECD-33C57DC3A865',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','categorization');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:4DC74177-7806-34D9-AECD-33C57DC3A865',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','checked');
-
-
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:E5C43936-86E4-37BF-8196-1D04B35C0099','Administrator','admin','jUDDI.org','uddi-org:wsdl:categorization:transport','http://www.oasis-open.org/committees/uddi-spec/doc/tn/uddi-spec-tc-tn-wsdl-v2.htm#transport',CURRENT TIMESTAMP);
-
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:E5C43936-86E4-37BF-8196-1D04B35C0099',0,'en','Category system used to describe the transport supported by a wsdl:binding.');
-
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:E5C43936-86E4-37BF-8196-1D04B35C0099',0,'en','The Transport Categorization tModel provides a mechanism to capture transport information in the UDDI binding tModel which allows a user to search for bindings that implement a specific transport protocol.');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:E5C43936-86E4-37BF-8196-1D04B35C0099',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','categorization');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:E5C43936-86E4-37BF-8196-1D04B35C0099',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','checked');
-
-
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:AD61DE98-4DB8-31B2-A299-A2373DC97212','Administrator','admin','jUDDI.org','uddi-org:wsdl:address','http://www.oasis-open.org/committees/uddi-spec/doc/tn/uddi-spec-tc-tn-wsdl-v2.htm#Address',CURRENT TIMESTAMP);
-
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:AD61DE98-4DB8-31B2-A299-A2373DC97212',0,'en','A tModel used to indicate the WSDL address option.');
-
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:AD61DE98-4DB8-31B2-A299-A2373DC97212',0,'en','The WSDL Address tModel provides A mechanism to indicate that the endpoint address should be obtained from a WSDL document.');
-
--- ** http transport **
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:68DE9E80-AD09-469D-8A37-088422BFBC36','Administrator','admin','jUDDI.org','uddi-org:http','http://www.uddi.org/taxonomies/UDDI_CoreOther_tModels.htm#overHTTP',CURRENT TIMESTAMP);
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:68DE9E80-AD09-469D-8A37-088422BFBC36',0,'en','An HTTP or web browser-based web service');
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:68DE9E80-AD09-469D-8A37-088422BFBC36',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','tModelType','transport');
-
--- ** uddi inquiry **
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:AC104DCC-D623-452F-88A7-F8ACD94D9B2B','Administrator','admin','jUDDI.org','uddi-org:inquiry_v2','http://www.uddi.org/wsdl/inquire_v2.wsdl',CURRENT TIMESTAMP);
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:AC104DCC-D623-452F-88A7-F8ACD94D9B2B',0,'en','UDDI Inquiry API Version 2 - Core Specification');
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:AC104DCC-D623-452F-88A7-F8ACD94D9B2B',0,'en','This tModel defines the inquiry API calls for interacting with a V2 UDDI node.');
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:AC104DCC-D623-452F-88A7-F8ACD94D9B2B',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','specification');
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:AC104DCC-D623-452F-88A7-F8ACD94D9B2B',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','xmlSpec');
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:AC104DCC-D623-452F-88A7-F8ACD94D9B2B',2,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','soapSpec');
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:AC104DCC-D623-452F-88A7-F8ACD94D9B2B',3,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','wsdlSpec');
-
--- ** uddi-org:taxonomy_V2
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A','Administrator','admin','jUDDI.org','uddi-org:taxonomy_v2','http://www.uddi.org/taxonomies/UDDI_Registry_tModels.htm#TaxV2',CURRENT_TIMESTAMP);
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A',0,'en','UDDI Taxonomy API Version 2 - Core Specification');
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A',0,'en','This tModel defines the taxonomy validation API calls for interacting with a V2 UDDI node.');
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','specification');
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','xmlSpec');
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A',2,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','soapSpec');
-
+--
+-- Licensed to the Apache Software Foundation (ASF) under one or more
+-- contributor license agreements.  See the NOTICE file distributed with
+-- this work for additional information regarding copyright ownership.
+-- The ASF licenses this file to You under the Apache License, Version 2.0
+-- (the "License"); you may not use this file except in compliance with
+-- the License.  You may obtain a copy of the License at
+--
+--    http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing, software
+-- distributed under the License is distributed on an "AS IS" BASIS,
+-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+-- See the License for the specific language governing permissions and
+-- limitations under the License.
+--
+-- $Rev$ $Date$
+--
+
+CREATE TABLE J3_PERSON_NAME (
+    ID BIGINT NOT NULL,
+    LANG_CODE VARCHAR(5),
+    NAME VARCHAR(255) NOT NULL,
+    CONTACT_ID BIGINT NOT NULL
+  );
+
+CREATE TABLE J3_TRANSFER_TOKEN (
+    TRANSFER_TOKEN VARCHAR(51) NOT NULL,
+    EXPIRATION_DATE TIMESTAMP NOT NULL
+  );
+
+CREATE TABLE J3_ADDRESS_LINE (
+    ID BIGINT NOT NULL,
+    KEY_NAME VARCHAR(255),
+    KEY_VALUE VARCHAR(255),
+    LINE VARCHAR(80) NOT NULL,
+    ADDRESS_ID BIGINT NOT NULL
+  );
+
+CREATE TABLE J3_INSTANCE_DETAILS_DOC_DESCR (
+    ID BIGINT NOT NULL,
+    DESCR VARCHAR(1024) NOT NULL,
+    LANG_CODE VARCHAR(5),
+    TMODEL_INSTANCE_INFO_ID BIGINT NOT NULL
+  );
+
+CREATE TABLE J3_OVERVIEW_DOC_DESCR (
+    ID BIGINT NOT NULL,
+    DESCR VARCHAR(1024) NOT NULL,
+    LANG_CODE VARCHAR(5),
+    OVERVIEW_DOC_ID BIGINT
+  );
+
+CREATE TABLE J3_PUBLISHER (
+    AUTHORIZED_NAME VARCHAR(255) NOT NULL,
+    EMAIL_ADDRESS VARCHAR(255),
+    IS_ADMIN VARCHAR(5),
+    IS_ENABLED VARCHAR(5),
+    MAX_BINDINGS_PER_SERVICE INTEGER,
+    MAX_BUSINESSES INTEGER,
+    MAX_SERVICES_PER_BUSINESS INTEGER,
+    MAX_TMODELS INTEGER,
+    PUBLISHER_NAME VARCHAR(255) NOT NULL
+  );
+
+CREATE TABLE J3_PUBLISHER_ASSERTION (
+    FROM_KEY VARCHAR(255) NOT NULL,
+    TO_KEY VARCHAR(255) NOT NULL,
+    FROM_CHECK VARCHAR(5) NOT NULL,
+    KEY_NAME VARCHAR(255) NOT NULL,
+    KEY_VALUE VARCHAR(255) NOT NULL,
+    TMODEL_KEY VARCHAR(255) NOT NULL,
+    TO_CHECK VARCHAR(5) NOT NULL
+  );
+
+CREATE TABLE J3_ADDRESS (
+    ID BIGINT NOT NULL,
+    SORT_CODE VARCHAR(10),
+    TMODEL_KEY VARCHAR(255),
+    USE_TYPE VARCHAR(255),
+    ADDRESS_ID BIGINT NOT NULL
+  );
+
+CREATE TABLE J3_UDDI_ENTITY (
+    ENTITY_KEY VARCHAR(255) NOT NULL,
+    AUTHORIZED_NAME VARCHAR(255) NOT NULL,
+    CREATED TIMESTAMP,
+    MODIFIED TIMESTAMP NOT NULL,
+    MODIFIED_INCLUDING_CHILDREN TIMESTAMP,
+    NODE_ID VARCHAR(255)
+  );
+
+CREATE TABLE J3_SUBSCRIPTION (
+    SUBSCRIPTION_KEY VARCHAR(255) NOT NULL,
+    AUTHORIZED_NAME VARCHAR(255) NOT NULL,
+    BINDING_KEY VARCHAR(255),
+    BRIEF SMALLINT,
+    CREATE_DATE TIMESTAMP NOT NULL,
+    EXPIRES_AFTER TIMESTAMP,
+    LAST_NOTIFIED TIMESTAMP,
+    MAX_ENTITIES INTEGER,
+    NOTIFICATION_INTERVAL VARCHAR(255),
+    SUBSCRIPTION_FILTER CLOB(2147483647) NOT NULL
+  );
+
+CREATE TABLE J3_BUSINESS_SERVICE (
+    ENTITY_KEY VARCHAR(255) NOT NULL,
+    BUSINESS_KEY VARCHAR(255) NOT NULL
+  );
+
+CREATE TABLE J3_BUSINESS_DESCR (
+    ID BIGINT NOT NULL,
+    DESCR VARCHAR(1024) NOT NULL,
+    LANG_CODE VARCHAR(5),
+    ENTITY_KEY VARCHAR(255) NOT NULL
+  );
+
+CREATE TABLE J3_BUSINESS_CATEGORY_BAG (
+    ID BIGINT NOT NULL,
+    ENTITY_KEY VARCHAR(255)
+  );
+
+CREATE TABLE J3_CLIENT_SUBSCRIPTIONINFO (
+    SUBSCRIPTION_KEY VARCHAR(255) NOT NULL,
+    LAST_NOTIFIED TIMESTAMP,
+    FROMCLERK_CLERK_NAME VARCHAR(255),
+    TOCLERK_CLERK_NAME VARCHAR(255)
+  );
+
+CREATE TABLE J3_KEYED_REFERENCE_GROUP (
+    ID BIGINT NOT NULL,
+    TMODEL_KEY VARCHAR(255),
+    CATEGORY_BAG_ID BIGINT NOT NULL
+  );
+
+CREATE TABLE J3_CONTACT (
+    ID BIGINT NOT NULL,
+    USE_TYPE VARCHAR(255),
+    ENTITY_KEY VARCHAR(255) NOT NULL
+  );
+
+CREATE TABLE J3_TMODEL (
+    ENTITY_KEY VARCHAR(255) NOT NULL,
+    DELETED SMALLINT,
+    LANG_CODE VARCHAR(5),
+    NAME VARCHAR(255) NOT NULL
+  );
+
+CREATE TABLE OPENJPA_SEQUENCE_TABLE (
+    ID SMALLINT NOT NULL,
+    SEQUENCE_VALUE BIGINT
+  );
+
+CREATE TABLE J3_OVERVIEW_DOC (
+    ID BIGINT NOT NULL,
+    OVERVIEW_URL VARCHAR(255),
+    OVERVIEW_URL_USE_TYPE VARCHAR(255),
+    ENTITY_KEY VARCHAR(255),
+    TOMODEL_INSTANCE_INFO_ID BIGINT
+  );
+
+CREATE TABLE J3_TMODEL_INSTANCE_INFO (
+    ID BIGINT NOT NULL,
+    INSTANCE_PARMS VARCHAR(512),
+    TMODEL_KEY VARCHAR(255) NOT NULL,
+    ENTITY_KEY VARCHAR(255) NOT NULL
+  );
+
+CREATE TABLE J3_INSTANCE_DETAILS_DESCR (
+    ID BIGINT NOT NULL,
+    DESCR VARCHAR(1024) NOT NULL,
+    LANG_CODE VARCHAR(5),
+    TMODEL_INSTANCE_INFO_ID BIGINT NOT NULL
+  );
+
+CREATE TABLE J3_TMODEL_DESCR (
+    ID BIGINT NOT NULL,
+    DESCR VARCHAR(1024) NOT NULL,
+    LANG_CODE VARCHAR(5),
+    ENTITY_KEY VARCHAR(255) NOT NULL
+  );
+
+CREATE TABLE J3_SUBSCRIPTION_MATCH (
+    ID BIGINT NOT NULL,
+    ENTITY_KEY VARCHAR(255) NOT NULL,
+    SUBSCRIPTION_KEY VARCHAR(255) NOT NULL
+  );
+
+CREATE TABLE J3_BINDING_CATEGORY_BAG (
+    ID BIGINT NOT NULL,
+    ENTITY_KEY VARCHAR(255)
+  );
+
+CREATE TABLE J3_EMAIL (
+    ID BIGINT NOT NULL,
+    EMAIL_ADDRESS VARCHAR(255) NOT NULL,
+    USE_TYPE VARCHAR(255),
+    CONTACT_ID BIGINT NOT NULL
+  );
+
+CREATE TABLE J3_SERVICE_DESCR (
+    ID BIGINT NOT NULL,
+    DESCR VARCHAR(1024) NOT NULL,
+    LANG_CODE VARCHAR(5),
+    ENTITY_KEY VARCHAR(255) NOT NULL
+  );
+
+CREATE TABLE J3_PHONE (
+    ID BIGINT NOT NULL,
+    PHONE_NUMBER VARCHAR(50) NOT NULL,
+    USE_TYPE VARCHAR(255),
+    CONTACT_ID BIGINT NOT NULL
+  );
+
+CREATE TABLE J3_TMODEL_INSTANCE_INFO_DESCR (
+    ID BIGINT NOT NULL,
+    DESCR VARCHAR(1024) NOT NULL,
+    LANG_CODE VARCHAR(5),
+    TMODEL_INSTANCE_INFO_ID BIGINT NOT NULL
+  );
+
+CREATE TABLE J3_CLERK (
+    CLERK_NAME VARCHAR(255) NOT NULL,
+    CRED VARCHAR(255),
+    PUBLISHER_ID VARCHAR(255) NOT NULL,
+    NODE_NAME VARCHAR(255)
+  );
+
+CREATE TABLE J3_TMODEL_CATEGORY_BAG (
+    ID BIGINT NOT NULL,
+    ENTITY_KEY VARCHAR(255)
+  );
+
+CREATE TABLE J3_BINDING_DESCR (
+    ID BIGINT NOT NULL,
+    DESCR VARCHAR(1024) NOT NULL,
+    LANG_CODE VARCHAR(5),
+    ENTITY_KEY VARCHAR(255) NOT NULL
+  );
+
+CREATE TABLE J3_TRANSFER_TOKEN_KEYS (
+    ID BIGINT NOT NULL,
+    ENTITY_KEY VARCHAR(255),
+    TRANSFER_TOKEN VARCHAR(255) NOT NULL
+  );
+
+CREATE TABLE J3_DISCOVERY_URL (
+    ID BIGINT NOT NULL,
+    URL VARCHAR(255) NOT NULL,
+    USE_TYPE VARCHAR(255) NOT NULL,
+    ENTITY_KEY VARCHAR(255) NOT NULL
+  );
+
+CREATE TABLE J3_TMODEL_IDENTIFIER (
+    ID BIGINT NOT NULL,
+    KEY_NAME VARCHAR(255),
+    KEY_VALUE VARCHAR(255) NOT NULL,
+    TMODEL_KEY_REF VARCHAR(255),
+    ENTITY_KEY VARCHAR(255) NOT NULL
+  );
+
+CREATE TABLE J3_CONTACT_DESCR (
+    ID BIGINT NOT NULL,
+    DESCR VARCHAR(1024) NOT NULL,
+    LANG_CODE VARCHAR(5),
+    CONTACT_ID BIGINT NOT NULL
+  );
+
+CREATE TABLE J3_CATEGORY_BAG (
+    ID BIGINT NOT NULL
+  );
+
+CREATE TABLE J3_SERVICE_PROJECTION (
+    BUSINESS_KEY VARCHAR(255) NOT NULL,
+    SERVICE_KEY VARCHAR(255) NOT NULL
+  );
+
+CREATE TABLE J3_BUSINESS_NAME (
+    ID BIGINT NOT NULL,
+    LANG_CODE VARCHAR(5),
+    NAME VARCHAR(255) NOT NULL,
+    ENTITY_KEY VARCHAR(255) NOT NULL
+  );
+
+CREATE TABLE J3_SERVICE_CATEGORY_BAG (
+    ID BIGINT NOT NULL,
+    ENTITY_KEY VARCHAR(255)
+  );
+
+CREATE TABLE J3_NODE (
+    NAME VARCHAR(255) NOT NULL,
+    CUSTODY_TRANSFER_URL VARCHAR(255) NOT NULL,
+    FACTORY_INITIAL VARCHAR(255),
+    FACTORY_NAMING_PROVIDER VARCHAR(255),
+    FACTORY_URL_PKGS VARCHAR(255),
+    INQUIRY_URL VARCHAR(255) NOT NULL,
+    JUDDI_API_URL VARCHAR(255),
+    MANAGER_NAME VARCHAR(255) NOT NULL,
+    PROXY_TRANSPORT VARCHAR(255) NOT NULL,
+    PUBLISH_URL VARCHAR(255) NOT NULL,
+    SECURITY_URL VARCHAR(255) NOT NULL,
+    SUBSCRIPTION_URL VARCHAR(255) NOT NULL
+  );
+
+CREATE TABLE J3_BINDING_TEMPLATE (
+    ENTITY_KEY VARCHAR(255) NOT NULL,
+    ACCESS_POINT_TYPE VARCHAR(255),
+    ACCESS_POINT_URL VARCHAR(4000),
+    HOSTING_REDIRECTOR VARCHAR(255),
+    SERVICE_KEY VARCHAR(255) NOT NULL
+  );
+
+CREATE TABLE J3_KEYED_REFERENCE (
+    ID BIGINT NOT NULL,
+    KEY_NAME VARCHAR(255),
+    KEY_VALUE VARCHAR(255) NOT NULL,
+    TMODEL_KEY_REF VARCHAR(255),
+    CATEGORY_BAG_ID BIGINT,
+    KEYED_REFERENCE_GROUP_ID BIGINT
+  );
+
+CREATE TABLE J3_AUTH_TOKEN (
+    AUTH_TOKEN VARCHAR(51) NOT NULL,
+    AUTHORIZED_NAME VARCHAR(255) NOT NULL,
+    CREATED TIMESTAMP NOT NULL,
+    LAST_USED TIMESTAMP NOT NULL,
+    NUMBER_OF_USES INTEGER NOT NULL,
+    TOKEN_STATE INTEGER NOT NULL
+  );
+
+CREATE TABLE J3_SUBSCRIPTION_CHUNK_TOKEN (
+    CHUNK_TOKEN VARCHAR(255) NOT NULL,
+    DATA INTEGER NOT NULL,
+    END_POINT TIMESTAMP,
+    EXPIRES_AFTER TIMESTAMP NOT NULL,
+    START_POINT TIMESTAMP,
+    SUBSCRIPTION_KEY VARCHAR(255) NOT NULL
+  );
+
+CREATE TABLE J3_SERVICE_NAME (
+    ID BIGINT NOT NULL,
+    LANG_CODE VARCHAR(5),
+    NAME VARCHAR(255) NOT NULL,
+    ENTITY_KEY VARCHAR(255) NOT NULL
+  );
+
+CREATE TABLE J3_BUSINESS_IDENTIFIER (
+    ID BIGINT NOT NULL,
+    KEY_NAME VARCHAR(255),
+    KEY_VALUE VARCHAR(255) NOT NULL,
+    TMODEL_KEY_REF VARCHAR(255),
+    ENTITY_KEY VARCHAR(255) NOT NULL
+  );
+
+CREATE TABLE J3_BUSINESS_ENTITY (
+    ENTITY_KEY VARCHAR(255) NOT NULL
+  );
+
+CREATE INDEX I_J3_TSCR_TMODEL ON J3_TMODEL_DESCR (ENTITY_KEY ASC);
+
+CREATE UNIQUE INDEX SQL101221160128000 ON J3_TMODEL (ENTITY_KEY ASC);
+
+CREATE INDEX I_J3_PHON_CONTACT ON J3_PHONE (CONTACT_ID ASC);
+
+CREATE INDEX I_J3_BRVC_BUSINESSENTITY ON J3_BUSINESS_SERVICE (BUSINESS_KEY ASC);
+
+CREATE INDEX I_J3_S_NM_BUSINESSSERVICE ON J3_SERVICE_NAME (ENTITY_KEY ASC);
+
+CREATE INDEX I_J3_CNNF_TOCLERK ON J3_CLIENT_SUBSCRIPTIONINFO (TOCLERK_CLERK_NAME ASC);
+
+CREATE UNIQUE INDEX SQL101221160121420 ON J3_CLIENT_SUBSCRIPTIONINFO (SUBSCRIPTION_KEY ASC);
+
+CREATE INDEX I_J3_BSCR_BINDINGTEMPLATE ON J3_BINDING_DESCR (ENTITY_KEY ASC);
+
+CREATE INDEX I_J3_DRSS_CONTACT ON J3_ADDRESS (ADDRESS_ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160120410 ON J3_BUSINESS_NAME (ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160126530 ON J3_SERVICE_PROJECTION (BUSINESS_KEY ASC, SERVICE_KEY ASC);
+
+CREATE INDEX I_J3_P_NM_CONTACT ON J3_PERSON_NAME (CONTACT_ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160129560 ON J3_TRANSFER_TOKEN (TRANSFER_TOKEN ASC);
+
+CREATE UNIQUE INDEX SQL101221160123590 ON J3_KEYED_REFERENCE_GROUP (ID ASC);
+
+CREATE INDEX I_J3_VSCR_OVERVIEWDOC ON J3_OVERVIEW_DOC_DESCR (OVERVIEW_DOC_ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160129830 ON J3_TRANSFER_TOKEN_KEYS (ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160126780 ON J3_SUBSCRIPTION (SUBSCRIPTION_KEY ASC);
+
+CREATE UNIQUE INDEX SQL101221160118890 ON J3_BINDING_DESCR (ID ASC);
+
+CREATE INDEX I_J3_CTCT_BUSINESSENTITY ON J3_CONTACT (ENTITY_KEY ASC);
+
+CREATE UNIQUE INDEX SQL101221160123870 ON J3_NODE (NAME ASC);
+
+CREATE UNIQUE INDEX SQL101221160128670 ON J3_TMODEL_IDENTIFIER (ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160122440 ON J3_EMAIL (ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160124160 ON J3_OVERVIEW_DOC (ID ASC);
+
+CREATE INDEX I_J3_TSCR_TMODELINSTANCEINFO ON J3_TMODEL_INSTANCE_INFO_DESCR (TMODEL_INSTANCE_INFO_ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160130130 ON J3_UDDI_ENTITY (ENTITY_KEY ASC);
+
+CREATE INDEX I_J3_NSCR_TMODELINSTANCEINFO ON J3_INSTANCE_DETAILS_DESCR (TMODEL_INSTANCE_INFO_ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160125640 ON J3_PUBLISHER_ASSERTION (FROM_KEY ASC, TO_KEY ASC);
+
+CREATE UNIQUE INDEX SQL101221160119730 ON J3_BUSINESS_DESCR (ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160119500 ON J3_BUSINESS_CATEGORY_BAG (ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160127550 ON J3_SUBSCRIPTION_CHUNK_TOKEN (CHUNK_TOKEN ASC);
+
+CREATE UNIQUE INDEX SQL101221160126090 ON J3_SERVICE_DESCR (ID ASC);
+
+CREATE INDEX I_J3_BTFR_BUSINESSENTITY ON J3_BUSINESS_IDENTIFIER (ENTITY_KEY ASC);
+
+CREATE UNIQUE INDEX SQL101221160120180 ON J3_BUSINESS_IDENTIFIER (ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160128210 ON J3_TMODEL_CATEGORY_BAG (ID ASC);
+
+CREATE INDEX I_J3_BSCR_BUSINESSENTITY ON J3_BUSINESS_DESCR (ENTITY_KEY ASC);
+
+CREATE INDEX I_J3_BPLT_BUSINESSSERVICE ON J3_BINDING_TEMPLATE (SERVICE_KEY ASC);
+
+CREATE INDEX I_J3_T_NF_BINDINGTEMPLATE ON J3_TMODEL_INSTANCE_INFO (ENTITY_KEY ASC);
+
+CREATE UNIQUE INDEX SQL101221160118450 ON J3_AUTH_TOKEN (AUTH_TOKEN ASC);
+
+CREATE INDEX I_J3_B_BG_BINDINGTEMPLATE ON J3_BINDING_CATEGORY_BAG (ENTITY_KEY ASC);
+
+CREATE UNIQUE INDEX SQL101221160120860 ON J3_CATEGORY_BAG (ID ASC);
+
+CREATE INDEX I_J3_V_DC_TMODEL ON J3_OVERVIEW_DOC (ENTITY_KEY ASC);
+
+CREATE INDEX I_J3_S_BG_BUSINESSSERVICE ON J3_SERVICE_CATEGORY_BAG (ENTITY_KEY ASC);
+
+CREATE UNIQUE INDEX SQL101221160123320 ON J3_KEYED_REFERENCE (ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160121930 ON J3_CONTACT_DESCR (ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160121170 ON J3_CLERK (CLERK_NAME ASC);
+
+CREATE UNIQUE INDEX SQL101221160127780 ON J3_SUBSCRIPTION_MATCH (ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160120640 ON J3_BUSINESS_SERVICE (ENTITY_KEY ASC);
+
+CREATE UNIQUE INDEX SQL101221160128950 ON J3_TMODEL_INSTANCE_INFO (ID ASC);
+
+CREATE INDEX I_J3_CLRK_NODE ON J3_CLERK (NODE_NAME ASC);
+
+CREATE INDEX I_J3_STCH_SUBSCRIPTION ON J3_SUBSCRIPTION_MATCH (SUBSCRIPTION_KEY ASC);
+
+CREATE UNIQUE INDEX SQL101221160119940 ON J3_BUSINESS_ENTITY (ENTITY_KEY ASC);
+
+CREATE INDEX I_J3_EMIL_CONTACT ON J3_EMAIL (CONTACT_ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160118210 ON J3_ADDRESS_LINE (ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160128420 ON J3_TMODEL_DESCR (ID ASC);
+
+CREATE INDEX I_J3_T_BG_TMODEL ON J3_TMODEL_CATEGORY_BAG (ENTITY_KEY ASC);
+
+CREATE INDEX I_J3_KRNC_CATEGORYBAG ON J3_KEYED_REFERENCE (CATEGORY_BAG_ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160126300 ON J3_SERVICE_NAME (ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160125370 ON J3_PUBLISHER (AUTHORIZED_NAME ASC);
+
+CREATE INDEX I_J3_SSCR_BUSINESSSERVICE ON J3_SERVICE_DESCR (ENTITY_KEY ASC);
+
+CREATE UNIQUE INDEX SQL101221160122740 ON J3_INSTANCE_DETAILS_DESCR (ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160129300 ON J3_TMODEL_INSTANCE_INFO_DESCR (ID ASC);
+
+CREATE INDEX I_J3_KRNC_KEYEDREFERENCEGROUP ON J3_KEYED_REFERENCE (KEYED_REFERENCE_GROUP_ID ASC);
+
+CREATE INDEX I_J3_B_NM_BUSINESSENTITY ON J3_BUSINESS_NAME (ENTITY_KEY ASC);
+
+CREATE UNIQUE INDEX SQL101221160125870 ON J3_SERVICE_CATEGORY_BAG (ID ASC);
+
+CREATE INDEX I_J3_D_LN_ADDRESS ON J3_ADDRESS_LINE (ADDRESS_ID ASC);
+
+CREATE INDEX I_J3_TTFR_TMODEL ON J3_TMODEL_IDENTIFIER (ENTITY_KEY ASC);
+
+CREATE INDEX I_J3_NSCR_TMODELINSTANCEINFO1 ON J3_INSTANCE_DETAILS_DOC_DESCR (TMODEL_INSTANCE_INFO_ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160124440 ON J3_OVERVIEW_DOC_DESCR (ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160124690 ON J3_PERSON_NAME (ID ASC);
+
+CREATE INDEX I_J3_CNNF_FROMCLERK ON J3_CLIENT_SUBSCRIPTIONINFO (FROMCLERK_CLERK_NAME ASC);
+
+CREATE UNIQUE INDEX SQL101221160119280 ON J3_BINDING_TEMPLATE (ENTITY_KEY ASC);
+
+CREATE UNIQUE INDEX SQL101221160117940 ON J3_ADDRESS (ID ASC);
+
+CREATE INDEX I_J3_KGRP_CATEGORYBAG ON J3_KEYED_REFERENCE_GROUP (CATEGORY_BAG_ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160124970 ON J3_PHONE (ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160130460 ON OPENJPA_SEQUENCE_TABLE (ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160123010 ON J3_INSTANCE_DETAILS_DOC_DESCR (ID ASC);
+
+CREATE INDEX I_J3_CSCR_CONTACT ON J3_CONTACT_DESCR (CONTACT_ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160121690 ON J3_CONTACT (ID ASC);
+
+CREATE INDEX I_J3_TKYS_TRANSFERTOKEN ON J3_TRANSFER_TOKEN_KEYS (TRANSFER_TOKEN ASC);
+
+CREATE INDEX I_J3_V_DC_TMODELINSTANCEINFO ON J3_OVERVIEW_DOC (TOMODEL_INSTANCE_INFO_ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160122200 ON J3_DISCOVERY_URL (ID ASC);
+
+CREATE INDEX I_J3_B_BG_BUSINESSENTITY ON J3_BUSINESS_CATEGORY_BAG (ENTITY_KEY ASC);
+
+CREATE UNIQUE INDEX SQL101221160118680 ON J3_BINDING_CATEGORY_BAG (ID ASC);
+
+CREATE INDEX I_J3_D_RL_BUSINESSENTITY ON J3_DISCOVERY_URL (ENTITY_KEY ASC);
+
+ALTER TABLE J3_SUBSCRIPTION_MATCH ADD CONSTRAINT SQL101221160127780 PRIMARY KEY (ID);
+
+ALTER TABLE J3_SERVICE_DESCR ADD CONSTRAINT SQL101221160126090 PRIMARY KEY (ID);
+
+ALTER TABLE J3_AUTH_TOKEN ADD CONSTRAINT SQL101221160118450 PRIMARY KEY (AUTH_TOKEN);
+
+ALTER TABLE J3_TMODEL_INSTANCE_INFO_DESCR ADD CONSTRAINT SQL101221160129300 PRIMARY KEY (ID);
+
+ALTER TABLE J3_TMODEL_DESCR ADD CONSTRAINT SQL101221160128420 PRIMARY KEY (ID);
+
+ALTER TABLE J3_BUSINESS_CATEGORY_BAG ADD CONSTRAINT SQL101221160119500 PRIMARY KEY (ID);
+
+ALTER TABLE J3_INSTANCE_DETAILS_DESCR ADD CONSTRAINT SQL101221160122740 PRIMARY KEY (ID);
+
+ALTER TABLE J3_TMODEL_IDENTIFIER ADD CONSTRAINT SQL101221160128670 PRIMARY KEY (ID);
+
+ALTER TABLE J3_TRANSFER_TOKEN ADD CONSTRAINT SQL101221160129560 PRIMARY KEY (TRANSFER_TOKEN);
+
+ALTER TABLE J3_TMODEL ADD CONSTRAINT SQL101221160128000 PRIMARY KEY (ENTITY_KEY);
+
+ALTER TABLE J3_TMODEL_INSTANCE_INFO ADD CONSTRAINT SQL101221160128950 PRIMARY KEY (ID);
+
+ALTER TABLE J3_CLERK ADD CONSTRAINT SQL101221160121170 PRIMARY KEY (CLERK_NAME);
+
+ALTER TABLE J3_OVERVIEW_DOC ADD CONSTRAINT SQL101221160124160 PRIMARY KEY (ID);
+
+ALTER TABLE J3_INSTANCE_DETAILS_DOC_DESCR ADD CONSTRAINT SQL101221160123010 PRIMARY KEY (ID);
+
+ALTER TABLE J3_ADDRESS_LINE ADD CONSTRAINT SQL101221160118210 PRIMARY KEY (ID);
+
+ALTER TABLE J3_OVERVIEW_DOC_DESCR ADD CONSTRAINT SQL101221160124440 PRIMARY KEY (ID);
+
+ALTER TABLE J3_NODE ADD CONSTRAINT SQL101221160123870 PRIMARY KEY (NAME);
+
+ALTER TABLE J3_BUSINESS_ENTITY ADD CONSTRAINT SQL101221160119940 PRIMARY KEY (ENTITY_KEY);
+
+ALTER TABLE J3_KEYED_REFERENCE_GROUP ADD CONSTRAINT SQL101221160123590 PRIMARY KEY (ID);
+
+ALTER TABLE J3_SUBSCRIPTION ADD CONSTRAINT SQL101221160126780 PRIMARY KEY (SUBSCRIPTION_KEY);
+
+ALTER TABLE OPENJPA_SEQUENCE_TABLE ADD CONSTRAINT SQL101221160130460 PRIMARY KEY (ID);
+
+ALTER TABLE J3_BUSINESS_IDENTIFIER ADD CONSTRAINT SQL101221160120180 PRIMARY KEY (ID);
+
+ALTER TABLE J3_EMAIL ADD CONSTRAINT SQL101221160122440 PRIMARY KEY (ID);
+
+ALTER TABLE J3_KEYED_REFERENCE ADD CONSTRAINT SQL101221160123320 PRIMARY KEY (ID);
+
+ALTER TABLE J3_CONTACT_DESCR ADD CONSTRAINT SQL101221160121930 PRIMARY KEY (ID);
+
+ALTER TABLE J3_PHONE ADD CONSTRAINT SQL101221160124970 PRIMARY KEY (ID);
+
+ALTER TABLE J3_CONTACT ADD CONSTRAINT SQL101221160121690 PRIMARY KEY (ID);
+
+ALTER TABLE J3_BINDING_DESCR ADD CONSTRAINT SQL101221160118890 PRIMARY KEY (ID);
+
+ALTER TABLE J3_PUBLISHER ADD CONSTRAINT SQL101221160125370 PRIMARY KEY (AUTHORIZED_NAME);
+
+ALTER TABLE J3_UDDI_ENTITY ADD CONSTRAINT SQL101221160130130 PRIMARY KEY (ENTITY_KEY);
+
+ALTER TABLE J3_CATEGORY_BAG ADD CONSTRAINT SQL101221160120860 PRIMARY KEY (ID);
+
+ALTER TABLE J3_BUSINESS_DESCR ADD CONSTRAINT SQL101221160119730 PRIMARY KEY (ID);
+
+ALTER TABLE J3_DISCOVERY_URL ADD CONSTRAINT SQL101221160122200 PRIMARY KEY (ID);
+
+ALTER TABLE J3_BUSINESS_SERVICE ADD CONSTRAINT SQL101221160120640 PRIMARY KEY (ENTITY_KEY);
+
+ALTER TABLE J3_TRANSFER_TOKEN_KEYS ADD CONSTRAINT SQL101221160129830 PRIMARY KEY (ID);
+
+ALTER TABLE J3_CLIENT_SUBSCRIPTIONINFO ADD CONSTRAINT SQL101221160121420 PRIMARY KEY (SUBSCRIPTION_KEY);
+
+ALTER TABLE J3_SUBSCRIPTION_CHUNK_TOKEN ADD CONSTRAINT SQL101221160127550 PRIMARY KEY (CHUNK_TOKEN);
+
+ALTER TABLE J3_SERVICE_CATEGORY_BAG ADD CONSTRAINT SQL101221160125870 PRIMARY KEY (ID);
+
+ALTER TABLE J3_PERSON_NAME ADD CONSTRAINT SQL101221160124690 PRIMARY KEY (ID);
+
+ALTER TABLE J3_ADDRESS ADD CONSTRAINT SQL101221160117940 PRIMARY KEY (ID);
+
+ALTER TABLE J3_PUBLISHER_ASSERTION ADD CONSTRAINT SQL101221160125640 PRIMARY KEY (FROM_KEY, TO_KEY);
+
+ALTER TABLE J3_TMODEL_CATEGORY_BAG ADD CONSTRAINT SQL101221160128210 PRIMARY KEY (ID);
+
+ALTER TABLE J3_SERVICE_PROJECTION ADD CONSTRAINT SQL101221160126530 PRIMARY KEY (BUSINESS_KEY, SERVICE_KEY);
+
+ALTER TABLE J3_SERVICE_NAME ADD CONSTRAINT SQL101221160126300 PRIMARY KEY (ID);
+
+ALTER TABLE J3_BINDING_CATEGORY_BAG ADD CONSTRAINT SQL101221160118680 PRIMARY KEY (ID);
+
+ALTER TABLE J3_BUSINESS_NAME ADD CONSTRAINT SQL101221160120410 PRIMARY KEY (ID);
+
+ALTER TABLE J3_BINDING_TEMPLATE ADD CONSTRAINT SQL101221160119280 PRIMARY KEY (ENTITY_KEY);
\ No newline at end of file

Modified: geronimo/server/trunk/plugins/uddi/uddi-jetty/pom.xml
URL: http://svn.apache.org/viewvc/geronimo/server/trunk/plugins/uddi/uddi-jetty/pom.xml?rev=1051888&r1=1051887&r2=1051888&view=diff
==============================================================================
--- geronimo/server/trunk/plugins/uddi/uddi-jetty/pom.xml (original)
+++ geronimo/server/trunk/plugins/uddi/uddi-jetty/pom.xml Wed Dec 22 13:27:18 2010
@@ -74,16 +74,11 @@
         </dependency>
         
         <dependency>
-            <groupId>org.apache.juddi</groupId>
-            <artifactId>juddiv3-war</artifactId>
-            <type>war</type>
+            <groupId>org.apache.geronimo.plugins</groupId>
+            <artifactId>uddi-war-repackage</artifactId>
+     	    <version>${project.version}</version>
             <scope>provided</scope>
         </dependency>
-        
-        <dependency>
-            <groupId>commons-collections</groupId>
-            <artifactId>commons-collections</artifactId>
-        </dependency>
 
         <dependency>
             <groupId>org.apache.geronimo.configs</groupId>
@@ -91,12 +86,55 @@
             <version>${project.version}</version>
             <type>car</type>
         </dependency>
+	
         <dependency>
             <groupId>org.apache.geronimo.configs</groupId>
             <artifactId>jasper</artifactId>
             <version>${project.version}</version>
             <type>car</type>
         </dependency>
+	
+        <dependency>
+            <groupId>org.apache.openjpa</groupId>
+            <artifactId>openjpa</artifactId>
+        </dependency>
+        
+        <dependency>
+	    <groupId>org.apache.geronimo.specs</groupId>
+	    <artifactId>geronimo-jaxr_1.0_spec</artifactId>
+        </dependency>              
+        
+        <dependency>
+            <groupId>org.apache.geronimo.bundles</groupId>
+            <artifactId>scout</artifactId>
+        </dependency>
+	
+	<dependency>	
+	    <groupId>org.apache.juddi</groupId>
+            <artifactId>uddi-ws</artifactId>
+        </dependency>
+	
+	<dependency>
+             <groupId>commons-collections</groupId>
+             <artifactId>commons-collections</artifactId>
+        </dependency>
+
+	<dependency>
+	    <groupId>commons-lang</groupId>
+	    <artifactId>commons-lang</artifactId>
+	</dependency>
+    
+	<dependency>	    
+	    <groupId>org.apache.geronimo.bundles</groupId>
+	    <artifactId>commons-digester</artifactId>
+	 </dependency>          
+	     
+	<dependency>	     
+	    <groupId>commons-beanutils</groupId>
+	    <artifactId>commons-beanutils</artifactId>
+	</dependency>   
+			
+		
     </dependencies>
     
     <build>
@@ -114,9 +152,9 @@
                     </deploymentConfigs>
                     <category>Web Services</category>
                     <module>
-                        <groupId>org.apache.juddi</groupId>
-                        <artifactId>juddiv3-war</artifactId>
-                        <type>war</type>
+                        <groupId>org.apache.geronimo.plugins</groupId>
+                        <artifactId>uddi-war-repackage</artifactId>
+                        <type>jar</type>
                     </module>
                 </configuration>
             </plugin>

Modified: geronimo/server/trunk/plugins/uddi/uddi-jetty/src/main/history/dependencies.xml
URL: http://svn.apache.org/viewvc/geronimo/server/trunk/plugins/uddi/uddi-jetty/src/main/history/dependencies.xml?rev=1051888&r1=1051887&r2=1051888&view=diff
==============================================================================
--- geronimo/server/trunk/plugins/uddi/uddi-jetty/src/main/history/dependencies.xml (original)
+++ geronimo/server/trunk/plugins/uddi/uddi-jetty/src/main/history/dependencies.xml Wed Dec 22 13:27:18 2010
@@ -7,6 +7,16 @@
         <type>car</type>
     </module-id>
     <dependency>
+        <groupId>commons-logging</groupId>
+        <artifactId>commons-logging-api</artifactId>
+        <type>jar</type>
+    </dependency>
+    <dependency>
+        <groupId>org.apache.geronimo.bundles</groupId>
+        <artifactId>scout</artifactId>
+        <type>jar</type>
+    </dependency>
+    <dependency>
         <groupId>org.apache.geronimo.configs</groupId>
         <artifactId>cxf</artifactId>
         <type>car</type>
@@ -26,4 +36,14 @@
         <artifactId>uddi-db</artifactId>
         <type>car</type>
     </dependency>
+    <dependency>
+        <groupId>org.apache.juddi</groupId>
+        <artifactId>uddi-ws</artifactId>
+        <type>jar</type>
+    </dependency>
+    <dependency>
+        <groupId>org.apache.openjpa</groupId>
+        <artifactId>openjpa</artifactId>
+        <type>jar</type>
+    </dependency>
 </plugin-artifact>

Modified: geronimo/server/trunk/plugins/uddi/uddi-tomcat/pom.xml
URL: http://svn.apache.org/viewvc/geronimo/server/trunk/plugins/uddi/uddi-tomcat/pom.xml?rev=1051888&r1=1051887&r2=1051888&view=diff
==============================================================================
--- geronimo/server/trunk/plugins/uddi/uddi-tomcat/pom.xml (original)
+++ geronimo/server/trunk/plugins/uddi/uddi-tomcat/pom.xml Wed Dec 22 13:27:18 2010
@@ -49,9 +49,10 @@
             <type>car</type>
             <scope>provided</scope>
         </dependency>
+	
         <dependency>
             <groupId>org.apache.geronimo.configs</groupId>
-            <artifactId>cxf-deployer</artifactId>
+            <artifactId>axis2-deployer</artifactId>
             <version>${project.version}</version>
             <type>car</type>
             <scope>provided</scope>
@@ -59,7 +60,7 @@
 
         <dependency>
             <groupId>org.apache.geronimo.configs</groupId>
-            <artifactId>cxf</artifactId>
+            <artifactId>axis2</artifactId>
             <version>${project.version}</version>
             <type>car</type>
         </dependency>
@@ -70,11 +71,11 @@
             <version>${project.version}</version>
             <type>car</type>
         </dependency>
-
+        
         <dependency>
-            <groupId>org.apache.juddi</groupId>
-            <artifactId>juddiv3-war</artifactId>
-            <type>war</type>
+            <groupId>org.apache.geronimo.plugins</groupId>
+            <artifactId>uddi-war-repackage</artifactId>
+     	    <version>${project.version}</version>
             <scope>provided</scope>
         </dependency>
 
@@ -84,12 +85,55 @@
             <version>${project.version}</version>
             <type>car</type>
         </dependency>
+        
         <dependency>
             <groupId>org.apache.geronimo.configs</groupId>
             <artifactId>jasper</artifactId>
             <version>${project.version}</version>
             <type>car</type>
         </dependency>
+        
+        <dependency>
+            <groupId>org.apache.openjpa</groupId>
+            <artifactId>openjpa</artifactId>
+        </dependency>
+        
+        <dependency>
+	    <groupId>org.apache.geronimo.specs</groupId>
+	    <artifactId>geronimo-jaxr_1.0_spec</artifactId>
+        </dependency>              
+        
+        <dependency>
+            <groupId>org.apache.geronimo.bundles</groupId>
+            <artifactId>scout</artifactId>
+        </dependency>
+	
+	<dependency>	
+	    <groupId>org.apache.juddi</groupId>
+            <artifactId>uddi-ws</artifactId>
+        </dependency>
+	
+	<dependency>
+             <groupId>commons-collections</groupId>
+             <artifactId>commons-collections</artifactId>
+        </dependency>
+
+	<dependency>
+	    <groupId>commons-lang</groupId>
+	    <artifactId>commons-lang</artifactId>
+	</dependency>
+    
+	<dependency>	    
+	    <groupId>org.apache.geronimo.bundles</groupId>
+	    <artifactId>commons-digester</artifactId>
+	 </dependency>          
+	     
+	<dependency>	     
+	    <groupId>commons-beanutils</groupId>
+	    <artifactId>commons-beanutils</artifactId>
+	</dependency>   
+			
+		
     </dependencies>
 
     <build>
@@ -102,14 +146,14 @@
                         <deploymentConfig>${gbeanDeployer}</deploymentConfig>
                         <deploymentConfig>${j2eeDeployer}</deploymentConfig>
                         <deploymentConfig>${tomcatDeployer}</deploymentConfig>
-                        <deploymentConfig>${cxfDeployer}</deploymentConfig>
+                        <deploymentConfig>${axis2Deployer}</deploymentConfig>
                         <deploymentConfig>${jasperDeployer}</deploymentConfig>
                     </deploymentConfigs>
                     <category>Web Services</category>
                     <module>
-                        <groupId>org.apache.juddi</groupId>
-                        <artifactId>juddiv3-war</artifactId>
-                        <type>war</type>
+                        <groupId>org.apache.geronimo.plugins</groupId>
+                        <artifactId>uddi-war-repackage</artifactId>
+                        <type>jar</type>
                     </module>
                 </configuration>
             </plugin>

Modified: geronimo/server/trunk/plugins/uddi/uddi-tomcat/src/main/history/dependencies.xml
URL: http://svn.apache.org/viewvc/geronimo/server/trunk/plugins/uddi/uddi-tomcat/src/main/history/dependencies.xml?rev=1051888&r1=1051887&r2=1051888&view=diff
==============================================================================
--- geronimo/server/trunk/plugins/uddi/uddi-tomcat/src/main/history/dependencies.xml (original)
+++ geronimo/server/trunk/plugins/uddi/uddi-tomcat/src/main/history/dependencies.xml Wed Dec 22 13:27:18 2010
@@ -7,8 +7,23 @@
         <type>car</type>
     </module-id>
     <dependency>
+        <groupId>commons-logging</groupId>
+        <artifactId>commons-logging-api</artifactId>
+        <type>jar</type>
+    </dependency>
+    <dependency>
+        <groupId>commons-pool</groupId>
+        <artifactId>commons-pool</artifactId>
+        <type>jar</type>
+    </dependency>
+    <dependency>
+        <groupId>org.apache.geronimo.bundles</groupId>
+        <artifactId>scout</artifactId>
+        <type>jar</type>
+    </dependency>
+    <dependency>
         <groupId>org.apache.geronimo.configs</groupId>
-        <artifactId>cxf</artifactId>
+        <artifactId>axis2</artifactId>
         <type>car</type>
     </dependency>
     <dependency>
@@ -26,4 +41,14 @@
         <artifactId>uddi-db</artifactId>
         <type>car</type>
     </dependency>
+    <dependency>
+        <groupId>org.apache.juddi</groupId>
+        <artifactId>uddi-ws</artifactId>
+        <type>jar</type>
+    </dependency>
+    <dependency>
+        <groupId>org.apache.openjpa</groupId>
+        <artifactId>openjpa</artifactId>
+        <type>jar</type>
+    </dependency>
 </plugin-artifact>

Modified: geronimo/server/trunk/plugins/uddi/uddi-tomcat/src/main/plan/plan.xml
URL: http://svn.apache.org/viewvc/geronimo/server/trunk/plugins/uddi/uddi-tomcat/src/main/plan/plan.xml?rev=1051888&r1=1051887&r2=1051888&view=diff
==============================================================================
--- geronimo/server/trunk/plugins/uddi/uddi-tomcat/src/main/plan/plan.xml (original)
+++ geronimo/server/trunk/plugins/uddi/uddi-tomcat/src/main/plan/plan.xml Wed Dec 22 13:27:18 2010
@@ -18,7 +18,7 @@
 
 <!-- $Rev$ $Date$ -->
 
-<web-app xmlns="http://geronimo.apache.org/xml/ns/j2ee/web/tomcat-2.0.1">
+<web-app xmlns="http://geronimo.apache.org/xml/ns/j2ee/web/tomcat-2.0.1" xmlns:naming="http://geronimo.apache.org/xml/ns/naming-1.2">
 
   <context-root>/juddi</context-root>
   <!--<gbean name="UDDIResources" class="org.apache.geronimo.system.util.DirectoryInitializationGBean">-->
@@ -29,4 +29,12 @@
       <!--<name>ServerInfo</name>-->
     <!--</reference>-->
   <!--</gbean>-->
+  <naming:resource-ref>
+        <naming:ref-name>jdbc/juddiDB</naming:ref-name>
+        <naming:resource-link>jdbc/juddiDB</naming:resource-link>
+    </naming:resource-ref>
+    <naming:resource-ref>
+        <naming:ref-name>jdbc/NoTxJuddiDB</naming:ref-name>
+        <naming:resource-link>jdbc/NoTxJuddiDB</naming:resource-link>
+    </naming:resource-ref>
 </web-app>

Added: geronimo/server/trunk/plugins/uddi/uddi-war-repackage/pom.xml
URL: http://svn.apache.org/viewvc/geronimo/server/trunk/plugins/uddi/uddi-war-repackage/pom.xml?rev=1051888&view=auto
==============================================================================
--- geronimo/server/trunk/plugins/uddi/uddi-war-repackage/pom.xml (added)
+++ geronimo/server/trunk/plugins/uddi/uddi-war-repackage/pom.xml Wed Dec 22 13:27:18 2010
@@ -0,0 +1,92 @@
+<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
+
+    <!--
+
+        Licensed to the Apache Software Foundation (ASF) under one or more
+        contributor license agreements.  See the NOTICE file distributed with
+        this work for additional information regarding copyright ownership.
+        The ASF licenses this file to You under the Apache License, Version 2.0
+        (the "License"); you may not use this file except in compliance with
+        the License.  You may obtain a copy of the License at
+
+           http://www.apache.org/licenses/LICENSE-2.0
+
+        Unless required by applicable law or agreed to in writing, software
+        distributed under the License is distributed on an "AS IS" BASIS,
+        WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+        See the License for the specific language governing permissions and
+        limitations under the License.
+    -->
+
+    <modelVersion>4.0.0</modelVersion>
+
+    <parent>
+        <groupId>org.apache.geronimo.plugins</groupId>
+        <artifactId>uddi</artifactId>
+        <version>3.0-SNAPSHOT</version>
+    </parent>
+
+    <artifactId>uddi-war-repackage</artifactId>
+    <packaging>jar</packaging>
+    <name>Geronimo Plugins, UDDI :: uddi-war-repackage</name>
+
+    <build>
+      
+	
+        <plugins>
+          <plugin>
+         <groupId>org.apache.maven.plugins</groupId>
+         <artifactId>maven-dependency-plugin</artifactId>
+         <executions>
+           <execution>
+             <id>unpack-uddi-war</id>
+             <phase>generate-resources</phase>
+             <goals>
+               <goal>unpack</goal>
+             </goals>
+             <configuration>
+               <artifactItems>
+                 <artifactItem>
+		    <groupId>org.apache.juddi</groupId>
+		    <artifactId>juddiv3-war</artifactId>
+		    <type>war</type>
+		    <version>${juddiv3.version}</version>
+                 </artifactItem>
+               </artifactItems>
+               <includes>**/*</includes>
+               <excludes>**/persistence.xml,**/uddi-ws*.jar,**/juddi-client*.jar,**/juddi-core-openjpa*.jar,**/commons-beanutils*.jar,**/commons-collections*.jar,**/commons-digester*.jar,**/commons-lang*.jar,**/commons-logging-api*.jar</excludes>
+               <outputDirectory>${project.build.directory}/classes</outputDirectory>
+               <overWriteReleases>false</overWriteReleases>
+               <overWriteSnapshots>true</overWriteSnapshots>
+             </configuration>
+           </execution>
+	    <execution>
+             <id>unpack-uddi-core-openjpa</id>
+             <phase>generate-resources</phase>
+             <goals>
+               <goal>unpack</goal>
+             </goals>
+             <configuration>
+               <artifactItems>
+                 <artifactItem>
+		    <groupId>org.apache.juddi</groupId>
+		    <artifactId>juddi-core-openjpa</artifactId>
+		    <type>jar</type>
+		    <version>${juddiv3.version}</version>
+                 </artifactItem>
+               </artifactItems>
+               <includes>**/*</includes>
+               <excludes>**/persistence.xml</excludes>
+               <outputDirectory>${project.build.directory}/classes/WEB-INF/classes</outputDirectory>
+               <overWriteReleases>false</overWriteReleases>
+               <overWriteSnapshots>true</overWriteSnapshots>
+             </configuration>
+           </execution>
+         </executions>
+       </plugin>
+     
+          
+        </plugins>
+    </build>
+
+</project>
\ No newline at end of file

Added: geronimo/server/trunk/plugins/uddi/uddi-war-repackage/src/main/resources/WEB-INF/classes/META-INF/persistence.xml
URL: http://svn.apache.org/viewvc/geronimo/server/trunk/plugins/uddi/uddi-war-repackage/src/main/resources/WEB-INF/classes/META-INF/persistence.xml?rev=1051888&view=auto
==============================================================================
--- geronimo/server/trunk/plugins/uddi/uddi-war-repackage/src/main/resources/WEB-INF/classes/META-INF/persistence.xml (added)
+++ geronimo/server/trunk/plugins/uddi/uddi-war-repackage/src/main/resources/WEB-INF/classes/META-INF/persistence.xml Wed Dec 22 13:27:18 2010
@@ -0,0 +1,89 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<persistence xmlns="http://java.sun.com/xml/ns/persistence" 
+             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+             xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd" 
+             version="1.0">
+  <persistence-unit name="juddiDatabase" transaction-type="RESOURCE_LOCAL">
+    <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
+    
+    <!-- entity classes -->
+    <class>org.apache.juddi.model.Address</class>
+    <class>org.apache.juddi.model.AddressLine</class>
+    <class>org.apache.juddi.model.AuthToken</class>
+    <class>org.apache.juddi.model.BindingCategoryBag</class>
+    <class>org.apache.juddi.model.BindingDescr</class>
+    <class>org.apache.juddi.model.BindingTemplate</class>
+    <class>org.apache.juddi.model.BusinessCategoryBag</class>
+    <class>org.apache.juddi.model.BusinessDescr</class>
+    <class>org.apache.juddi.model.BusinessEntity</class>
+    <class>org.apache.juddi.model.BusinessIdentifier</class>
+    <class>org.apache.juddi.model.BusinessName</class>
+    <class>org.apache.juddi.model.BusinessService</class>
+    <class>org.apache.juddi.model.CategoryBag</class>
+    <class>org.apache.juddi.model.Clerk</class>
+    <class>org.apache.juddi.model.ClientSubscriptionInfo</class>
+    <class>org.apache.juddi.model.Contact</class>
+    <class>org.apache.juddi.model.ContactDescr</class>
+    <class>org.apache.juddi.model.DiscoveryUrl</class>
+    <class>org.apache.juddi.model.Email</class>
+    <class>org.apache.juddi.model.InstanceDetailsDescr</class>
+    <class>org.apache.juddi.model.InstanceDetailsDocDescr</class>
+    <class>org.apache.juddi.model.KeyedReference</class>
+    <class>org.apache.juddi.model.KeyedReferenceGroup</class>
+    <class>org.apache.juddi.model.Node</class>
+    <class>org.apache.juddi.model.OverviewDoc</class>
+    <class>org.apache.juddi.model.OverviewDocDescr</class>
+    <class>org.apache.juddi.model.PersonName</class>
+    <class>org.apache.juddi.model.Phone</class>
+    <class>org.apache.juddi.model.Publisher</class>
+    <class>org.apache.juddi.model.PublisherAssertion</class>
+    <class>org.apache.juddi.model.PublisherAssertionId</class>
+    <class>org.apache.juddi.model.ServiceCategoryBag</class>
+    <class>org.apache.juddi.model.ServiceDescr</class>
+    <class>org.apache.juddi.model.ServiceName</class>
+    <class>org.apache.juddi.model.ServiceProjection</class>
+    <class>org.apache.juddi.model.ServiceProjectionId</class>
+    <class>org.apache.juddi.model.Subscription</class>
+    <class>org.apache.juddi.model.SubscriptionChunkToken</class>
+    <class>org.apache.juddi.model.SubscriptionMatch</class>
+    <class>org.apache.juddi.model.Tmodel</class>
+    <class>org.apache.juddi.model.TmodelCategoryBag</class>
+    <class>org.apache.juddi.model.TmodelDescr</class>
+    <class>org.apache.juddi.model.TmodelIdentifier</class>
+    <class>org.apache.juddi.model.TmodelInstanceInfo</class>
+    <class>org.apache.juddi.model.TmodelInstanceInfoDescr</class>
+    <class>org.apache.juddi.model.TransferToken</class>
+    <class>org.apache.juddi.model.TransferTokenKey</class>
+    <class>org.apache.juddi.model.UddiEntity</class>
+    <class>org.apache.juddi.model.UddiEntityPublisher</class>
+    
+    <properties>
+      <!--property name="openjpa.jdbc.SynchronizeMappings" value="buildSchema(SchemaAction='dropDB,add')"/-->
+      <property name="openjpa.Log" value="DefaultLevel=WARN, Tool=INFO"/>
+      <property name="openjpa.jdbc.UpdateManager" value="operation-order"/>
+      <property name="openjpa.RuntimeUnenhancedClasses" value="warn"/>
+      
+      <!-- derby connection properties -->
+      <property name="openjpa.ConnectionDriverName" value="org.apache.derby.jdbc.ClientDriver"/>
+      <property name="openjpa.ConnectionURL" value="jdbc:derby://localhost:1527/UddiDatabase;create=false;"/>
+      <property name="openjpa.ConnectionUserName" value="app"/>
+      <property name="openjpa.ConnectionPassword" value="app"/>
+      
+      
+      <!--  mysql connection properties
+      <property name="openjpa.ConnectionURL" value="jdbc:mysql://localhost:3306/juddi"/>
+      <property name="openjpa.ConnectionDriverName" value="com.mysql.jdbc.Driver"/>
+      <property name="openjpa.ConnectionUserName" value="juddiv3"/>
+      <property name="openjpa.ConnectionPassword" value=""/>
+      -->
+      
+      <!--  pgsql connection properties 
+      <property name="openjpa.ConnectionURL" value="jdbc:postgresql://localhost/juddi"/>
+      <property name="openjpa.ConnectionDriverName" value="org.postgresql.Driver"/>
+      <property name="openjpa.ConnectionUserName" value="juddi"/>
+      <property name="openjpa.ConnectionPassword" value="juddi"/>
+      -->
+      
+    </properties>
+  </persistence-unit>
+</persistence>
\ No newline at end of file

Modified: geronimo/server/trunk/pom.xml
URL: http://svn.apache.org/viewvc/geronimo/server/trunk/pom.xml?rev=1051888&r1=1051887&r2=1051888&view=diff
==============================================================================
--- geronimo/server/trunk/pom.xml (original)
+++ geronimo/server/trunk/pom.xml Wed Dec 22 13:27:18 2010
@@ -725,7 +725,7 @@
             <dependency>
                 <groupId>org.apache.geronimo.bundles</groupId>
                 <artifactId>scout</artifactId>
-                <version>1.2.2_1-SNAPSHOT</version>
+                <version>1.2.2_1</version>
                 <exclusions>
                     <exclusion>
                         <groupId>commons-logging</groupId>
@@ -2402,7 +2402,19 @@ only found in cxf
                 <module>assemblies</module>
             </modules>
 
-            <repositories>
+            <repositories>            
+		<repository>
+                    <id>geornimo bundle stage</id>
+                    <url>https://repository.apache.org/content/repositories/orgapachegeronimo-024/</url>
+                    <layout>default</layout>
+                    <snapshots>
+                        <enabled>false</enabled>
+                    </snapshots>
+                    <releases>
+                        <enabled>true</enabled>
+                    </releases>
+                </repository>
+
                 <repository>
                     <!-- org.eclipse.jetty routing -->
                     <id>jetty.oss.sonatype.org</id>



Mime
View raw message