You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@juddi.apache.org by al...@apache.org on 2014/03/14 23:51:14 UTC

[1/4] JUDDI-876 resolved

Repository: juddi
Updated Branches:
  refs/heads/master 737f293de -> 432345b08


http://git-wip-us.apache.org/repos/asf/juddi/blob/432345b0/juddi-ddl-generator/src/main/java/org/apache/juddi/ddl/generator/App.java
----------------------------------------------------------------------
diff --git a/juddi-ddl-generator/src/main/java/org/apache/juddi/ddl/generator/App.java b/juddi-ddl-generator/src/main/java/org/apache/juddi/ddl/generator/App.java
new file mode 100644
index 0000000..47ba801
--- /dev/null
+++ b/juddi-ddl-generator/src/main/java/org/apache/juddi/ddl/generator/App.java
@@ -0,0 +1,247 @@
+package org.apache.juddi.ddl.generator;
+
+/**
+ * Hello world!
+ *
+ */
+import java.io.File;
+import java.io.IOException;
+import java.net.URISyntaxException;
+import java.net.URL;
+import java.util.ArrayList;
+import java.util.Enumeration;
+import java.util.List;
+import java.util.jar.JarEntry;
+import java.util.jar.JarFile;
+import org.hibernate.cfg.AnnotationConfiguration;
+import org.hibernate.tool.hbm2ddl.SchemaExport;
+
+/**
+ * @author john.thompson
+ *
+ */
+public class App {
+
+        private AnnotationConfiguration cfg;
+
+        public App(String packageName) throws Exception {
+                cfg = new AnnotationConfiguration();
+                cfg.setProperty("hibernate.hbm2ddl.auto", "create");
+                List<Class> classesForPackage = getClassesForPackage(org.apache.juddi.model.Address.class.getPackage());
+                for (Class<Object> clazz : classesForPackage) {
+                        cfg.addAnnotatedClass(clazz);
+                }
+        }
+        
+         public App(String dir,String packageName) throws Exception {
+                cfg = new AnnotationConfiguration();
+                cfg.setProperty("hibernate.hbm2ddl.auto", "create");
+                List<Class> c = new ArrayList<Class>();
+                processDirectory(new File("../" + dir), packageName,c);
+                
+                processDirectory(new File(dir), packageName,c);
+                for (Class<Object> clazz : c) {
+                        cfg.addAnnotatedClass(clazz);
+                }
+                
+                
+        }
+
+        /**
+         * Method that actually creates the file.
+         *
+         * @param dbDialect to use
+         */
+        private void generate(Dialect dialect) {
+                cfg.setProperty("hibernate.dialect", dialect.getDialectClass());
+
+                SchemaExport export = new SchemaExport(cfg);
+                export.setDelimiter(";");
+                export.setOutputFile(dialect.name().toLowerCase() + ".ddl");
+                export.execute(true, false, false, true);
+        }
+
+        /**
+         * @param args
+         */
+        public static void main(String[] args) throws Exception {
+                App gen = null;
+                if (args != null && args.length == 1) {
+                        gen = new App(args[0],"org.apache.juddi.model");
+                } else {
+                        gen = new App("org.apache.juddi.model");
+                }
+                for (int i = 0; i < Dialect.values().length; i++) {
+                        gen.generate(Dialect.values()[i]);
+                }
+        }
+
+        private static void log(String msg) {
+                System.out.println("ClassDiscovery: " + msg);
+        }
+
+        private static Class<?> loadClass(String className) {
+                try {
+                        return Class.forName(className);
+                } catch (ClassNotFoundException e) {
+                        throw new RuntimeException("Unexpected ClassNotFoundException loading class '" + className + "'");
+                }
+        }
+
+        private static void processDirectory(File directory, String pkgname,List<Class> classes) {
+                log("Reading Directory '" + directory + "'");
+                // Get the list of the files contained in the package
+                if (!directory.exists())
+                        return;
+                String[] files = directory.list();
+                for (int i = 0; i < files.length; i++) {
+                        String fileName = files[i];
+                        String className = null;
+                        // we are only interested in .class files
+                        if (fileName.endsWith(".class")) {
+                                // removes the .class extension
+                                className = pkgname + '.' + fileName.substring(0, fileName.length() - 6);
+                        }
+                        log("FileName '" + fileName + "'  =>  class '" + className + "'");
+                        if (className != null) {
+                                classes.add(loadClass(className));
+                        }
+                        File subdir = new File(directory, fileName);
+                        if (subdir.isDirectory()) {
+                                processDirectory(subdir, pkgname + '.' + fileName, classes);
+                        }
+                }
+        }
+
+        private static void processJarfile(URL resource, String pkgname, List<Class> classes) {
+                String relPath = pkgname.replace('.', '/');
+                String resPath = resource.getPath();
+                String jarPath = resPath.replaceFirst("[.]jar[!].*", ".jar").replaceFirst("file:", "");
+                log("Reading JAR file: '" + jarPath + "'");
+                JarFile jarFile;
+                try {
+                        jarFile = new JarFile(jarPath);
+                } catch (IOException e) {
+                        throw new RuntimeException("Unexpected IOException reading JAR File '" + jarPath + "'", e);
+                }
+                Enumeration<JarEntry> entries = jarFile.entries();
+                while (entries.hasMoreElements()) {
+                        JarEntry entry = entries.nextElement();
+                        String entryName = entry.getName();
+                        String className = null;
+                        if (entryName.endsWith(".class") && entryName.startsWith(relPath) && entryName.length() > (relPath.length() + "/".length())) {
+                                className = entryName.replace('/', '.').replace('\\', '.').replace(".class", "");
+                        }
+                        log("JarEntry '" + entryName + "'  =>  class '" + className + "'");
+                        if (className != null) {
+                                classes.add(loadClass(className));
+                        }
+                }
+        }
+
+        public static List<Class> getClassesForPackage(Package pkg) {
+                List<Class> classes = new ArrayList<Class>();
+
+                String pkgname = pkg.getName();
+                log(pkgname);
+                log(pkg.getName());
+                String relPath = pkgname.replace('.', '/');
+
+                // Get a File object for the package
+                URL resource = ClassLoader.getSystemClassLoader().getResource(relPath);
+                if (resource == null) {
+                        processDirectory(new File(pkgname), pkgname, classes);
+                        throw new RuntimeException("Unexpected problem: No resource for " + relPath);
+                }
+                log("Package: '" + pkgname + "' becomes Resource: '" + resource.toString() + "'");
+
+                resource.getPath();
+                if (resource.toString().startsWith("jar:")) {
+                        processJarfile(resource, pkgname, classes);
+                } else {
+                        processDirectory(new File(resource.getPath()), pkgname, classes);
+                }
+
+                return classes;
+        }
+
+        /**
+         * Utility method used to fetch Class list based on a package name.
+         *
+         * @param packageName (should be the package containing your annotated
+         * beans.
+         */
+        private List<Class> getClasses(String packageName) throws Exception {
+                List classes = new ArrayList();
+                File directory = null;
+
+                ClassLoader cld = Thread.currentThread().getContextClassLoader();
+                cld = org.apache.juddi.model.Address.class.getClassLoader();
+
+                if (cld == null) {
+                        throw new ClassNotFoundException("Can't get class loader.");
+                }
+
+                String path = packageName.replace('.', '/');
+
+                //file:/C:/juddi/trunk/juddi-core/target/classes/org/apache/juddi/model
+                System.out.println(path);
+                Enumeration resources = cld.getResources(path);
+
+                while (resources.hasMoreElements()) {
+                        URL resource = (URL) resources.nextElement();
+                        System.out.println(resource.toExternalForm());
+                        try {
+                                directory = new File(resource.toURI().getPath());
+                        } catch (NullPointerException x) {
+                                throw new ClassNotFoundException(packageName + " (" + directory
+                                     + ") does not appear to be a valid package");
+                        }
+                        if (directory.exists()) {
+                                String[] files = directory.list();
+                                for (int i = 0; i < files.length; i++) {
+                                        if (files[i].endsWith(".class")) {
+// removes the .class extension
+                                                classes.add(Class.forName(packageName + '.'
+                                                     + files[i].substring(0, files[i].length() - 6)));
+                                        }
+                                }
+                        }
+                }
+                if (classes.isEmpty()) {
+                        System.err.println("No classes could be loaded.");
+                        System.exit(1);
+
+                }
+                return classes;
+        }
+
+        /**
+         * Holds the classnames of hibernate dialects for easy reference.
+         */
+        private static enum Dialect {
+
+                ORACLE("org.hibernate.dialect.Oracle10gDialect"),
+                MYSQL("org.hibernate.dialect.MySQLDialect"),
+                HSQL("org.hibernate.dialect.HSQLDialect"),
+                POSTGRES("org.hibernate.dialect.PostgreSQLDialect"),
+                MYSQL5("org.hibernate.dialect.MySQL5Dialect"),
+                DB2("org.hibernate.dialect.DB2Dialect"),
+                Derby("org.hibernate.dialect.DerbyDialect"),
+                MySQLInnoDB("org.hibernate.dialect.MySQLInnoDBDialect"),
+                Oracle9i("org.hibernate.dialect.Oracle9iDialect"),
+                Sybase("org.hibernate.dialect.SybaseDialect"),
+                MSSQL2000("org.hibernate.dialect.SQLServerDialect");
+                //   MSSQL2008("org.hibernate.dialect.SQLServer2008Dialect");
+
+                private String dialectClass;
+
+                private Dialect(String dialectClass) {
+                        this.dialectClass = dialectClass;
+                }
+
+                public String getDialectClass() {
+                        return dialectClass;
+                }
+        }
+}

http://git-wip-us.apache.org/repos/asf/juddi/blob/432345b0/juddi-ddl-generator/src/test/java/org/apache/juddi/ddl/generator/AppTest.java
----------------------------------------------------------------------
diff --git a/juddi-ddl-generator/src/test/java/org/apache/juddi/ddl/generator/AppTest.java b/juddi-ddl-generator/src/test/java/org/apache/juddi/ddl/generator/AppTest.java
new file mode 100644
index 0000000..c1a135f
--- /dev/null
+++ b/juddi-ddl-generator/src/test/java/org/apache/juddi/ddl/generator/AppTest.java
@@ -0,0 +1,13 @@
+package org.apache.juddi.ddl.generator;
+
+import org.apache.juddi.ddl.generator.App;
+import org.junit.Test;
+
+/**
+ * Unit test for simple App.
+ */
+public class AppTest {
+
+      @Test
+      public void dummytest(){}
+}

http://git-wip-us.apache.org/repos/asf/juddi/blob/432345b0/pom.xml
----------------------------------------------------------------------
diff --git a/pom.xml b/pom.xml
index 3f120b9..09768e2 100644
--- a/pom.xml
+++ b/pom.xml
@@ -334,6 +334,7 @@
 				<!-- adding these modules for release only -->
 				<module>uddi-tck</module>
 				<module>uddi-tck-runner</module>
+				<module>juddi-ddl-generator</module>
 				<module>docs</module>
 				<module>juddi-dist</module>
 				<module>uddi-client-dist</module>
@@ -347,6 +348,7 @@
 				<!-- adding these module for dist only -->
 				<module>uddi-tck</module>
 				<module>uddi-tck-runner</module>
+				<module>juddi-ddl-generator</module>
 				<module>docs</module>
 				<module>juddi-dist</module>
 				<module>uddi-client-dist</module>


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@juddi.apache.org
For additional commands, e-mail: commits-help@juddi.apache.org


[2/4] JUDDI-876 resolved

Posted by al...@apache.org.
http://git-wip-us.apache.org/repos/asf/juddi/blob/432345b0/docs/db/ddl/postgres.ddl
----------------------------------------------------------------------
diff --git a/docs/db/ddl/postgres.ddl b/docs/db/ddl/postgres.ddl
deleted file mode 100644
index b2a88a2..0000000
--- a/docs/db/ddl/postgres.ddl
+++ /dev/null
@@ -1,825 +0,0 @@
-
-    create table j3_address (
-        id int8 not null,
-        sort_code varchar(10),
-        tmodel_key varchar(255),
-        use_type varchar(255),
-        address_id int8 not null,
-        primary key (id)
-    );
-
-    create table j3_address_line (
-        id int8 not null,
-        key_name varchar(255),
-        key_value varchar(255),
-        line varchar(80) not null,
-        address_id int8 not null,
-        primary key (id)
-    );
-
-    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 int4 not null,
-        token_state int4 not null,
-		ipaddress varchar(51),
-        primary key (auth_token)
-    );
-
-    create table j3_binding_category_bag (
-        id int8 not null,
-        entity_key varchar(255) not null,
-        primary key (id),
-        unique (entity_key)
-    );
-
-    create table j3_binding_descr (
-        id int8 not null,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_binding_template (
-        access_point_type varchar(255),
-        access_point_url varchar(4096),
-        hosting_redirector varchar(255),
-        entity_key varchar(255) not null,
-        service_key varchar(255) not null,
-        primary key (entity_key)
-    );
-
-    create table j3_business_category_bag (
-        id int8 not null,
-        entity_key varchar(255) not null,
-        primary key (id),
-        unique (entity_key)
-    );
-
-    create table j3_business_descr (
-        id int8 not null,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_business_entity (
-        entity_key varchar(255) not null,
-        primary key (entity_key)
-    );
-
-    create table j3_business_identifier (
-        id int8 not null,
-        key_name varchar(255),
-        key_value varchar(255) not null,
-        tmodel_key_ref varchar(255),
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_business_name (
-        id int8 not null,
-        lang_code varchar(26),
-        name varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_business_service (
-        entity_key varchar(255) not null,
-        business_key varchar(255) not null,
-        primary key (entity_key)
-    );
-
-    create table j3_canonicalization_method (
-        id int8 not null,
-        algorithm varchar(255),
-        primary key (id)
-    );
-
-    create table j3_category_bag (
-        id int8 not null,
-        primary key (id)
-    );
-
-    create table j3_clerk (
-        clerk_name varchar(255) not null,
-        cred varchar(255),
-        publisher_id varchar(255) not null,
-        node_name varchar(255),
-        primary key (clerk_name)
-    );
-
-    create table j3_client_subscriptioninfo (
-        subscription_key varchar(255) not null,
-        last_notified timestamp,
-        fromClerk_clerk_name varchar(255),
-        toClerk_clerk_name varchar(255),
-        primary key (subscription_key)
-    );
-
-    create table j3_contact (
-        id int8 not null,
-        use_type varchar(255),
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_contact_descr (
-        id int8 not null,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        contact_id int8 not null,
-        primary key (id)
-    );
-
-    create table j3_discovery_url (
-        id int8 not null,
-        url varchar(4096) not null,
-        use_type varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_email (
-        id int8 not null,
-        email_address varchar(4096) not null,
-        use_type varchar(255),
-        contact_id int8 not null,
-        primary key (id)
-    );
-
-    create table j3_instance_details_descr (
-        id int8 not null,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        tmodel_instance_info_id int8 not null,
-        primary key (id)
-    );
-
-    create table j3_instance_details_doc_descr (
-        id int8 not null,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        tmodel_instance_info_id int8 not null,
-        primary key (id)
-    );
-
-    create table j3_key_data_value (
-        id int8 not null,
-        key_data_name varchar(255),
-        key_data_type varchar(255),
-        key_data_value oid,
-        key_data_value_string text,
-        key_data_value_key int8,
-        key_info_key int8,
-        primary key (id)
-    );
-
-    create table j3_key_info (
-        id int8 not null,
-        xml_id varchar(255),
-        primary key (id)
-    );
-
-    create table j3_keyed_reference (
-        id int8 not null,
-        key_name varchar(255),
-        key_value varchar(255) not null,
-        tmodel_key_ref varchar(255),
-        category_bag_id int8,
-        keyed_reference_group_id int8,
-        primary key (id)
-    );
-
-    create table j3_keyed_reference_group (
-        id int8 not null,
-        tmodel_key varchar(255),
-        category_bag_id int8 not null,
-        primary key (id)
-    );
-
-    create table j3_node (
-        name varchar(255) not null,
-        client_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),
-        proxy_transport varchar(255) not null,
-        publish_url varchar(255) not null,
-        security_url varchar(255) not null,
-        subscription_url varchar(255) not null,
-        primary key (name)
-    );
-
-    create table j3_object_type (
-        id int8 not null,
-        encoding varchar(255),
-        mime_type varchar(255),
-        xml_id varchar(255),
-        signature_key int8 not null,
-        primary key (id)
-    );
-
-    create table j3_object_type_content (
-        id int8 not null,
-        content oid,
-        object_type_key int8 not null,
-        primary key (id)
-    );
-
-    create table j3_overview_doc (
-        id int8 not null,
-        overview_url varchar(255),
-        overview_url_use_type varchar(255),
-        entity_key varchar(255),
-        tomodel_instance_info_id int8,
-        primary key (id)
-    );
-
-    create table j3_overview_doc_descr (
-        id int8 not null,
-        descr varchar(1024) not null,
-        lang_code varchar(26),
-        overview_doc_id int8,
-        primary key (id)
-    );
-
-    create table j3_person_name (
-        id int8 not null,
-        lang_code varchar(26),
-        name varchar(255) not null,
-        contact_id int8 not null,
-        primary key (id)
-    );
-
-    create table j3_phone (
-        id int8 not null,
-        phone_number varchar(50) not null,
-        use_type varchar(255),
-        contact_id int8 not null,
-        primary key (id)
-    );
-
-    create table j3_publisher (
-        authorized_name varchar(255) not null,
-        email_address varchar(255),
-        is_admin bool,
-        is_enabled bool,
-        max_bindings_per_service int4,
-        max_businesses int4,
-        max_services_per_business int4,
-        max_tmodels int4,
-        publisher_name varchar(255) not null,
-        primary key (authorized_name)
-    );
-
-    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,
-        primary key (from_key, to_key)
-    );
-
-    create table j3_reference (
-        id int8 not null,
-        digest_method varchar(255),
-        digest_value oid,
-        type varchar(255),
-        uri varchar(255),
-        xml_id varchar(255),
-        signed_info_key int8 not null,
-        primary key (id)
-    );
-
-    create table j3_service_category_bag (
-        id int8 not null,
-        entity_key varchar(255) not null,
-        primary key (id),
-        unique (entity_key)
-    );
-
-    create table j3_service_descr (
-        id int8 not null,
-        descr varchar(1024) not null,
-        lang_code varchar(26),
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_service_name (
-        id int8 not null,
-        lang_code varchar(26),
-        name varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_service_projection (
-        business_key varchar(255) not null,
-        service_key varchar(255) not null,
-        primary key (business_key, service_key)
-    );
-
-    create table j3_signature (
-        id int8 not null,
-        xml_id varchar(255),
-        binding_template_key varchar(255),
-        business_key varchar(255),
-        business_service_key varchar(255),
-        key_info int8 not null,
-        publisher_key varchar(255),
-        signature_value int8 not null,
-        signed_info int8 not null,
-        tmodel_key varchar(255),
-        primary key (id)
-    );
-
-    create table j3_signature_method (
-        id int8 not null,
-        algorithm varchar(255),
-        primary key (id)
-    );
-
-    create table j3_signature_transform (
-        id int8 not null,
-        transform varchar(255),
-        reference_key int8 not null,
-        primary key (id)
-    );
-
-    create table j3_signature_transform_data_v (
-        id int8 not null,
-        content_bytes oid,
-        content_type varchar(255),
-        signature_transform_key int8 not null,
-        primary key (id)
-    );
-
-    create table j3_signature_value (
-        id int8 not null,
-        value_bytes oid,
-        xml_id varchar(255),
-        primary key (id)
-    );
-
-    create table j3_signed_info (
-        id int8 not null,
-        xml_id varchar(255),
-        canonicalization_method int8 not null,
-        signature_method int8 not null,
-        primary key (id)
-    );
-
-    create table j3_subscription (
-        subscription_key varchar(255) not null,
-        authorized_name varchar(255) not null,
-        binding_key varchar(255),
-        brief bool,
-        create_date timestamp not null,
-        expires_after timestamp,
-        last_notified timestamp,
-        max_entities int4,
-        notification_interval varchar(255),
-        subscription_filter text not null,
-        primary key (subscription_key)
-    );
-
-    create table j3_subscription_chunk_token (
-        chunk_token varchar(255) not null,
-        data int4 not null,
-        end_point timestamp,
-        expires_after timestamp not null,
-        start_point timestamp,
-        subscription_key varchar(255) not null,
-        primary key (chunk_token)
-    );
-
-    create table j3_subscription_match (
-        id int8 not null,
-        entity_key varchar(255) not null,
-        subscription_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_temp_key (
-        entity_key varchar(255) not null,
-        tx_id varchar(255) not null,
-        primary key (entity_key, tx_id)
-    );
-
-    create table j3_tmodel (
-        deleted bool,
-        lang_code varchar(26),
-        name varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (entity_key)
-    );
-
-    create table j3_tmodel_category_bag (
-        id int8 not null,
-        entity_key varchar(255) not null,
-        primary key (id),
-        unique (entity_key)
-    );
-
-    create table j3_tmodel_descr (
-        id int8 not null,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_tmodel_identifier (
-        id int8 not null,
-        key_name varchar(255),
-        key_value varchar(255) not null,
-        tmodel_key_ref varchar(255),
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_tmodel_instance_info (
-        id int8 not null,
-        instance_parms varchar(8192),
-        tmodel_key varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_tmodel_instance_info_descr (
-        id int8 not null,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        tmodel_instance_info_id int8 not null,
-        primary key (id)
-    );
-
-    create table j3_transfer_token (
-        transfer_token varchar(51) not null,
-        expiration_date timestamp not null,
-        primary key (transfer_token)
-    );
-
-    create table j3_transfer_token_keys (
-        id int8 not null,
-        entity_key varchar(255),
-        transfer_token varchar(51) not null,
-        primary key (id)
-    );
-
-    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),
-        primary key (entity_key)
-    );
-
-    alter table j3_address 
-        add constraint FKF83236BE75D860FB 
-        foreign key (address_id) 
-        references j3_contact;
-
-    alter table j3_address_line 
-        add constraint FKC665B8D5F8B8D8CF 
-        foreign key (address_id) 
-        references j3_address;
-
-    alter table j3_binding_category_bag 
-        add constraint FKCF34B2376A68D45A 
-        foreign key (id) 
-        references j3_category_bag;
-
-    alter table j3_binding_category_bag 
-        add constraint FKCF34B237CFBD88B7 
-        foreign key (entity_key) 
-        references j3_binding_template;
-
-    alter table j3_binding_descr 
-        add constraint FK5EA60911CFBD88B7 
-        foreign key (entity_key) 
-        references j3_binding_template;
-
-    alter table j3_binding_template 
-        add constraint FKD044BD6A2E448F3F 
-        foreign key (service_key) 
-        references j3_business_service;
-
-    alter table j3_binding_template 
-        add constraint FKD044BD6AD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity;
-
-    alter table j3_business_category_bag 
-        add constraint FKD6D3ECB06A68D45A 
-        foreign key (id) 
-        references j3_category_bag;
-
-    alter table j3_business_category_bag 
-        add constraint FKD6D3ECB0BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_business_descr 
-        add constraint FK3A24B4B8BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_business_entity 
-        add constraint FKCA61A0CD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity;
-
-    alter table j3_business_identifier 
-        add constraint FKB0C7A652BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_business_name 
-        add constraint FK43F526F4BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_business_service 
-        add constraint FK5D4255ACD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity;
-
-    alter table j3_business_service 
-        add constraint FK5D4255ACEF04CFEE 
-        foreign key (business_key) 
-        references j3_business_entity;
-
-    alter table j3_clerk 
-        add constraint FK34DC7D9F6BB0F935 
-        foreign key (node_name) 
-        references j3_node;
-
-    alter table j3_client_subscriptioninfo 
-        add constraint FKDF04CC095BFC6733 
-        foreign key (fromClerk_clerk_name) 
-        references j3_clerk;
-
-    alter table j3_client_subscriptioninfo 
-        add constraint FKDF04CC09F3CE9C04 
-        foreign key (toClerk_clerk_name) 
-        references j3_clerk;
-
-    alter table j3_contact 
-        add constraint FK7551BEEABEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_contact_descr 
-        add constraint FK56CA9E6C2E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact;
-
-    alter table j3_discovery_url 
-        add constraint FKA042FDAABEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_email 
-        add constraint FK34F910E62E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact;
-
-    alter table j3_instance_details_descr 
-        add constraint FK3CC165902B115C6F 
-        foreign key (tmodel_instance_info_id) 
-        references j3_tmodel_instance_info;
-
-    alter table j3_instance_details_doc_descr 
-        add constraint FK447324492B115C6F 
-        foreign key (tmodel_instance_info_id) 
-        references j3_tmodel_instance_info;
-
-    alter table j3_key_data_value 
-        add constraint FK74B7E072843143EF 
-        foreign key (key_data_value_key) 
-        references j3_key_data_value;
-
-    alter table j3_key_data_value 
-        add constraint FK74B7E07238C90470 
-        foreign key (key_info_key) 
-        references j3_key_info;
-
-    alter table j3_keyed_reference 
-        add constraint FK350C8454E075C8D7 
-        foreign key (keyed_reference_group_id) 
-        references j3_keyed_reference_group;
-
-    alter table j3_keyed_reference 
-        add constraint FK350C84541DB72652 
-        foreign key (category_bag_id) 
-        references j3_category_bag;
-
-    alter table j3_keyed_reference_group 
-        add constraint FKF6224ED41DB72652 
-        foreign key (category_bag_id) 
-        references j3_category_bag;
-
-    alter table j3_object_type 
-        add constraint FK98BBFA04BC6AD65 
-        foreign key (signature_key) 
-        references j3_signature;
-
-    alter table j3_object_type_content 
-        add constraint FK987A913E71FA643E 
-        foreign key (object_type_key) 
-        references j3_object_type;
-
-    alter table j3_overview_doc 
-        add constraint FK5CD8D0E8C5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel;
-
-    alter table j3_overview_doc 
-        add constraint FK5CD8D0E8E8CE1B36 
-        foreign key (tomodel_instance_info_id) 
-        references j3_tmodel_instance_info;
-
-    alter table j3_overview_doc_descr 
-        add constraint FK36FB9EA9BDC711C 
-        foreign key (overview_doc_id) 
-        references j3_overview_doc;
-
-    alter table j3_person_name 
-        add constraint FKCB7B8AFF2E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact;
-
-    alter table j3_phone 
-        add constraint FK359202B82E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact;
-
-    alter table j3_publisher_assertion 
-        add constraint FK8A102449E3544929 
-        foreign key (to_key) 
-        references j3_business_entity;
-
-    alter table j3_publisher_assertion 
-        add constraint FK8A102449CCEE22D8 
-        foreign key (from_key) 
-        references j3_business_entity;
-
-    alter table j3_reference 
-        add constraint FK493A4F951E480746 
-        foreign key (signed_info_key) 
-        references j3_signed_info;
-
-    alter table j3_service_category_bag 
-        add constraint FK185A68076A68D45A 
-        foreign key (id) 
-        references j3_category_bag;
-
-    alter table j3_service_category_bag 
-        add constraint FK185A680748D0656D 
-        foreign key (entity_key) 
-        references j3_business_service;
-
-    alter table j3_service_descr 
-        add constraint FKB6D63D4148D0656D 
-        foreign key (entity_key) 
-        references j3_business_service;
-
-    alter table j3_service_name 
-        add constraint FKCC1BE94B48D0656D 
-        foreign key (entity_key) 
-        references j3_business_service;
-
-    alter table j3_service_projection 
-        add constraint FK629F290F2E448F3F 
-        foreign key (service_key) 
-        references j3_business_service;
-
-    alter table j3_service_projection 
-        add constraint FK629F290FEF04CFEE 
-        foreign key (business_key) 
-        references j3_business_entity;
-
-    alter table j3_signature 
-        add constraint FKC05CA90256E87DED 
-        foreign key (publisher_key) 
-        references j3_publisher;
-
-    alter table j3_signature 
-        add constraint FKC05CA90271CD8948 
-        foreign key (binding_template_key) 
-        references j3_binding_template;
-
-    alter table j3_signature 
-        add constraint FKC05CA90212F40D40 
-        foreign key (business_service_key) 
-        references j3_business_service;
-
-    alter table j3_signature 
-        add constraint FKC05CA9028ACE9A26 
-        foreign key (signed_info) 
-        references j3_signed_info;
-
-    alter table j3_signature 
-        add constraint FKC05CA9027CE6418E 
-        foreign key (signature_value) 
-        references j3_signature_value;
-
-    alter table j3_signature 
-        add constraint FKC05CA9025793CF55 
-        foreign key (tmodel_key) 
-        references j3_tmodel;
-
-    alter table j3_signature 
-        add constraint FKC05CA902DA6C2DD0 
-        foreign key (key_info) 
-        references j3_key_info;
-
-    alter table j3_signature 
-        add constraint FKC05CA902EF04CFEE 
-        foreign key (business_key) 
-        references j3_business_entity;
-
-    alter table j3_signature_transform 
-        add constraint FK726346F9256790B 
-        foreign key (reference_key) 
-        references j3_reference;
-
-    alter table j3_signature_transform_data_v 
-        add constraint FK3242526C7B88B2A4 
-        foreign key (signature_transform_key) 
-        references j3_signature_transform;
-
-    alter table j3_signed_info 
-        add constraint FKD2E7E5BB877110CC 
-        foreign key (canonicalization_method) 
-        references j3_canonicalization_method;
-
-    alter table j3_signed_info 
-        add constraint FKD2E7E5BB1A25896 
-        foreign key (signature_method) 
-        references j3_signature_method;
-
-    alter table j3_subscription_match 
-        add constraint FK5B9C2F19BEEE42E5 
-        foreign key (subscription_key) 
-        references j3_subscription;
-
-    alter table j3_tmodel 
-        add constraint FK83C8072BD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity;
-
-    alter table j3_tmodel_category_bag 
-        add constraint FK7E0859DB6A68D45A 
-        foreign key (id) 
-        references j3_category_bag;
-
-    alter table j3_tmodel_category_bag 
-        add constraint FK7E0859DBC5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel;
-
-    alter table j3_tmodel_descr 
-        add constraint FK63DFF1EDC5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel;
-
-    alter table j3_tmodel_identifier 
-        add constraint FKD5FB623DC5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel;
-
-    alter table j3_tmodel_instance_info 
-        add constraint FKDC6C9004CFBD88B7 
-        foreign key (entity_key) 
-        references j3_binding_template;
-
-    alter table j3_tmodel_instance_info_descr 
-        add constraint FKD826B4062B115C6F 
-        foreign key (tmodel_instance_info_id) 
-        references j3_tmodel_instance_info;
-
-    alter table j3_transfer_token_keys 
-        add constraint FK8BBF49185ED9DD48 
-        foreign key (transfer_token) 
-        references j3_transfer_token;
-
-    create sequence hibernate_sequence;
-
-    create sequence juddi_sequence;

http://git-wip-us.apache.org/repos/asf/juddi/blob/432345b0/docs/db/ddl/sqlserver.ddl
----------------------------------------------------------------------
diff --git a/docs/db/ddl/sqlserver.ddl b/docs/db/ddl/sqlserver.ddl
deleted file mode 100644
index ef40690..0000000
--- a/docs/db/ddl/sqlserver.ddl
+++ /dev/null
@@ -1,821 +0,0 @@
-
-    create table j3_address (
-        id numeric(19,0) identity not null,
-        sort_code varchar(10) null,
-        tmodel_key varchar(255) null,
-        use_type varchar(255) null,
-        address_id numeric(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_address_line (
-        id numeric(19,0) identity not null,
-        key_name varchar(255) null,
-        key_value varchar(255) null,
-        line varchar(80) not null,
-        address_id numeric(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_auth_token (
-        auth_token varchar(51) not null,
-        authorized_name varchar(255) not null,
-        created datetime not null,
-        last_used datetime not null,
-        number_of_uses int not null,
-        token_state int not null,
-		ipaddress varchar(51),
-        primary key (auth_token)
-    );
-
-    create table j3_binding_category_bag (
-        id numeric(19,0) not null,
-        entity_key varchar(255) not null,
-        primary key (id),
-        unique (entity_key)
-    );
-
-    create table j3_binding_descr (
-        id numeric(19,0) identity not null,
-        descr varchar(255) not null,
-        lang_code varchar(26) null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_binding_template (
-        access_point_type varchar(255) null,
-        access_point_url varchar(4096) null,
-        hosting_redirector varchar(255) null,
-        entity_key varchar(255) not null,
-        service_key varchar(255) not null,
-        primary key (entity_key)
-    );
-
-    create table j3_business_category_bag (
-        id numeric(19,0) not null,
-        entity_key varchar(255) not null,
-        primary key (id),
-        unique (entity_key)
-    );
-
-    create table j3_business_descr (
-        id numeric(19,0) identity not null,
-        descr varchar(255) not null,
-        lang_code varchar(26) null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_business_entity (
-        entity_key varchar(255) not null,
-        primary key (entity_key)
-    );
-
-    create table j3_business_identifier (
-        id numeric(19,0) identity not null,
-        key_name varchar(255) null,
-        key_value varchar(255) not null,
-        tmodel_key_ref varchar(255) null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_business_name (
-        id numeric(19,0) identity not null,
-        lang_code varchar(26) null,
-        name varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_business_service (
-        entity_key varchar(255) not null,
-        business_key varchar(255) not null,
-        primary key (entity_key)
-    );
-
-    create table j3_canonicalization_method (
-        id numeric(19,0) identity not null,
-        algorithm varchar(255) null,
-        primary key (id)
-    );
-
-    create table j3_category_bag (
-        id numeric(19,0) identity not null,
-        primary key (id)
-    );
-
-    create table j3_clerk (
-        clerk_name varchar(255) not null,
-        cred varchar(255) null,
-        publisher_id varchar(255) not null,
-        node_name varchar(255) null,
-        primary key (clerk_name)
-    );
-
-    create table j3_client_subscriptioninfo (
-        subscription_key varchar(255) not null,
-        last_notified datetime null,
-        fromClerk_clerk_name varchar(255) null,
-        toClerk_clerk_name varchar(255) null,
-        primary key (subscription_key)
-    );
-
-    create table j3_contact (
-        id numeric(19,0) identity not null,
-        use_type varchar(255) null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_contact_descr (
-        id numeric(19,0) identity not null,
-        descr varchar(255) not null,
-        lang_code varchar(26) null,
-        contact_id numeric(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_discovery_url (
-        id numeric(19,0) identity not null,
-        url varchar(4096) not null,
-        use_type varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_email (
-        id numeric(19,0) identity not null,
-        email_address varchar(4096) not null,
-        use_type varchar(255) null,
-        contact_id numeric(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_instance_details_descr (
-        id numeric(19,0) identity not null,
-        descr varchar(255) not null,
-        lang_code varchar(26) null,
-        tmodel_instance_info_id numeric(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_instance_details_doc_descr (
-        id numeric(19,0) identity not null,
-        descr varchar(255) not null,
-        lang_code varchar(26) null,
-        tmodel_instance_info_id numeric(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_key_data_value (
-        id numeric(19,0) identity not null,
-        key_data_name varchar(255) null,
-        key_data_type varchar(255) null,
-        key_data_value image null,
-        key_data_value_string text null,
-        key_data_value_key numeric(19,0) null,
-        key_info_key numeric(19,0) null,
-        primary key (id)
-    );
-
-    create table j3_key_info (
-        id numeric(19,0) identity not null,
-        xml_id varchar(255) null,
-        primary key (id)
-    );
-
-    create table j3_keyed_reference (
-        id numeric(19,0) identity not null,
-        key_name varchar(255) null,
-        key_value varchar(255) not null,
-        tmodel_key_ref varchar(255) null,
-        category_bag_id numeric(19,0) null,
-        keyed_reference_group_id numeric(19,0) null,
-        primary key (id)
-    );
-
-    create table j3_keyed_reference_group (
-        id numeric(19,0) identity not null,
-        tmodel_key varchar(255) null,
-        category_bag_id numeric(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_node (
-        name varchar(255) not null,
-        client_name varchar(255) not null,
-        custody_transfer_url varchar(255) not null,
-        factory_initial varchar(255) null,
-        factory_naming_provider varchar(255) null,
-        factory_url_pkgs varchar(255) null,
-        inquiry_url varchar(255) not null,
-        juddi_api_url varchar(255) 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,
-        primary key (name)
-    );
-
-    create table j3_object_type (
-        id numeric(19,0) identity not null,
-        encoding varchar(255) null,
-        mime_type varchar(255) null,
-        xml_id varchar(255) null,
-        signature_key numeric(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_object_type_content (
-        id numeric(19,0) identity not null,
-        content image null,
-        object_type_key numeric(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_overview_doc (
-        id numeric(19,0) identity not null,
-        overview_url varchar(255) null,
-        overview_url_use_type varchar(255) null,
-        entity_key varchar(255) null,
-        tomodel_instance_info_id numeric(19,0) null,
-        primary key (id)
-    );
-
-    create table j3_overview_doc_descr (
-        id numeric(19,0) identity not null,
-        descr varchar(1024) not null,
-        lang_code varchar(26) null,
-        overview_doc_id numeric(19,0) null,
-        primary key (id)
-    );
-
-    create table j3_person_name (
-        id numeric(19,0) identity not null,
-        lang_code varchar(26) null,
-        name varchar(255) not null,
-        contact_id numeric(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_phone (
-        id numeric(19,0) identity not null,
-        phone_number varchar(50) not null,
-        use_type varchar(255) null,
-        contact_id numeric(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_publisher (
-        authorized_name varchar(255) not null,
-        email_address varchar(255) null,
-        is_admin bool null,
-        is_enabled bool null,
-        max_bindings_per_service int null,
-        max_businesses int null,
-        max_services_per_business int null,
-        max_tmodels int null,
-        publisher_name varchar(255) not null,
-        primary key (authorized_name)
-    );
-
-    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,
-        primary key (from_key, to_key)
-    );
-
-    create table j3_reference (
-        id numeric(19,0) identity not null,
-        digest_method varchar(255) null,
-        digest_value image null,
-        type varchar(255) null,
-        uri varchar(255) null,
-        xml_id varchar(255) null,
-        signed_info_key numeric(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_service_category_bag (
-        id numeric(19,0) not null,
-        entity_key varchar(255) not null,
-        primary key (id),
-        unique (entity_key)
-    );
-
-    create table j3_service_descr (
-        id numeric(19,0) identity not null,
-        descr varchar(1024) not null,
-        lang_code varchar(26) null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_service_name (
-        id numeric(19,0) identity not null,
-        lang_code varchar(26) null,
-        name varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_service_projection (
-        business_key varchar(255) not null,
-        service_key varchar(255) not null,
-        primary key (business_key, service_key)
-    );
-
-    create table j3_signature (
-        id numeric(19,0) identity not null,
-        xml_id varchar(255) null,
-        binding_template_key varchar(255) null,
-        business_key varchar(255) null,
-        business_service_key varchar(255) null,
-        key_info numeric(19,0) not null,
-        publisher_key varchar(255) null,
-        signature_value numeric(19,0) not null,
-        signed_info numeric(19,0) not null,
-        tmodel_key varchar(255) null,
-        primary key (id)
-    );
-
-    create table j3_signature_method (
-        id numeric(19,0) identity not null,
-        algorithm varchar(255) null,
-        primary key (id)
-    );
-
-    create table j3_signature_transform (
-        id numeric(19,0) identity not null,
-        transform varchar(255) null,
-        reference_key numeric(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_signature_transform_data_v (
-        id numeric(19,0) identity not null,
-        content_bytes image null,
-        content_type varchar(255) null,
-        signature_transform_key numeric(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_signature_value (
-        id numeric(19,0) identity not null,
-        value_bytes image null,
-        xml_id varchar(255) null,
-        primary key (id)
-    );
-
-    create table j3_signed_info (
-        id numeric(19,0) identity not null,
-        xml_id varchar(255) null,
-        canonicalization_method numeric(19,0) not null,
-        signature_method numeric(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_subscription (
-        subscription_key varchar(255) not null,
-        authorized_name varchar(255) not null,
-        binding_key varchar(255) null,
-        brief tinyint null,
-        create_date datetime not null,
-        expires_after datetime null,
-        last_notified datetime null,
-        max_entities int null,
-        notification_interval varchar(255) null,
-        subscription_filter text not null,
-        primary key (subscription_key)
-    );
-
-    create table j3_subscription_chunk_token (
-        chunk_token varchar(255) not null,
-        data int not null,
-        end_point datetime null,
-        expires_after datetime not null,
-        start_point datetime null,
-        subscription_key varchar(255) not null,
-        primary key (chunk_token)
-    );
-
-    create table j3_subscription_match (
-        id numeric(19,0) identity not null,
-        entity_key varchar(255) not null,
-        subscription_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_temp_key (
-        entity_key varchar(255) not null,
-        tx_id varchar(255) not null,
-        primary key (entity_key, tx_id)
-    );
-
-    create table j3_tmodel (
-        deleted tinyint null,
-        lang_code varchar(26) null,
-        name varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (entity_key)
-    );
-
-    create table j3_tmodel_category_bag (
-        id numeric(19,0) not null,
-        entity_key varchar(255) not null,
-        primary key (id),
-        unique (entity_key)
-    );
-
-    create table j3_tmodel_descr (
-        id numeric(19,0) identity not null,
-        descr varchar(255) not null,
-        lang_code varchar(26) null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_tmodel_identifier (
-        id numeric(19,0) identity not null,
-        key_name varchar(255) null,
-        key_value varchar(255) not null,
-        tmodel_key_ref varchar(255) null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_tmodel_instance_info (
-        id numeric(19,0) identity not null,
-        instance_parms varchar(8192) null,
-        tmodel_key varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_tmodel_instance_info_descr (
-        id numeric(19,0) identity not null,
-        descr varchar(255) not null,
-        lang_code varchar(26) null,
-        tmodel_instance_info_id numeric(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_transfer_token (
-        transfer_token varchar(51) not null,
-        expiration_date datetime not null,
-        primary key (transfer_token)
-    );
-
-    create table j3_transfer_token_keys (
-        id numeric(19,0) identity not null,
-        entity_key varchar(255) null,
-        transfer_token varchar(51) not null,
-        primary key (id)
-    );
-
-    create table j3_uddi_entity (
-        entity_key varchar(255) not null,
-        authorized_name varchar(255) not null,
-        created datetime null,
-        modified datetime not null,
-        modified_including_children datetime null,
-        node_id varchar(255) null,
-        primary key (entity_key)
-    );
-
-    alter table j3_address 
-        add constraint FKF83236BE75D860FB 
-        foreign key (address_id) 
-        references j3_contact;
-
-    alter table j3_address_line 
-        add constraint FKC665B8D5F8B8D8CF 
-        foreign key (address_id) 
-        references j3_address;
-
-    alter table j3_binding_category_bag 
-        add constraint FKCF34B2376A68D45A 
-        foreign key (id) 
-        references j3_category_bag;
-
-    alter table j3_binding_category_bag 
-        add constraint FKCF34B237CFBD88B7 
-        foreign key (entity_key) 
-        references j3_binding_template;
-
-    alter table j3_binding_descr 
-        add constraint FK5EA60911CFBD88B7 
-        foreign key (entity_key) 
-        references j3_binding_template;
-
-    alter table j3_binding_template 
-        add constraint FKD044BD6A2E448F3F 
-        foreign key (service_key) 
-        references j3_business_service;
-
-    alter table j3_binding_template 
-        add constraint FKD044BD6AD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity;
-
-    alter table j3_business_category_bag 
-        add constraint FKD6D3ECB06A68D45A 
-        foreign key (id) 
-        references j3_category_bag;
-
-    alter table j3_business_category_bag 
-        add constraint FKD6D3ECB0BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_business_descr 
-        add constraint FK3A24B4B8BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_business_entity 
-        add constraint FKCA61A0CD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity;
-
-    alter table j3_business_identifier 
-        add constraint FKB0C7A652BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_business_name 
-        add constraint FK43F526F4BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_business_service 
-        add constraint FK5D4255ACD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity;
-
-    alter table j3_business_service 
-        add constraint FK5D4255ACEF04CFEE 
-        foreign key (business_key) 
-        references j3_business_entity;
-
-    alter table j3_clerk 
-        add constraint FK34DC7D9F6BB0F935 
-        foreign key (node_name) 
-        references j3_node;
-
-    alter table j3_client_subscriptioninfo 
-        add constraint FKDF04CC095BFC6733 
-        foreign key (fromClerk_clerk_name) 
-        references j3_clerk;
-
-    alter table j3_client_subscriptioninfo 
-        add constraint FKDF04CC09F3CE9C04 
-        foreign key (toClerk_clerk_name) 
-        references j3_clerk;
-
-    alter table j3_contact 
-        add constraint FK7551BEEABEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_contact_descr 
-        add constraint FK56CA9E6C2E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact;
-
-    alter table j3_discovery_url 
-        add constraint FKA042FDAABEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_email 
-        add constraint FK34F910E62E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact;
-
-    alter table j3_instance_details_descr 
-        add constraint FK3CC165902B115C6F 
-        foreign key (tmodel_instance_info_id) 
-        references j3_tmodel_instance_info;
-
-    alter table j3_instance_details_doc_descr 
-        add constraint FK447324492B115C6F 
-        foreign key (tmodel_instance_info_id) 
-        references j3_tmodel_instance_info;
-
-    alter table j3_key_data_value 
-        add constraint FK74B7E072843143EF 
-        foreign key (key_data_value_key) 
-        references j3_key_data_value;
-
-    alter table j3_key_data_value 
-        add constraint FK74B7E07238C90470 
-        foreign key (key_info_key) 
-        references j3_key_info;
-
-    alter table j3_keyed_reference 
-        add constraint FK350C8454E075C8D7 
-        foreign key (keyed_reference_group_id) 
-        references j3_keyed_reference_group;
-
-    alter table j3_keyed_reference 
-        add constraint FK350C84541DB72652 
-        foreign key (category_bag_id) 
-        references j3_category_bag;
-
-    alter table j3_keyed_reference_group 
-        add constraint FKF6224ED41DB72652 
-        foreign key (category_bag_id) 
-        references j3_category_bag;
-
-    alter table j3_object_type 
-        add constraint FK98BBFA04BC6AD65 
-        foreign key (signature_key) 
-        references j3_signature;
-
-    alter table j3_object_type_content 
-        add constraint FK987A913E71FA643E 
-        foreign key (object_type_key) 
-        references j3_object_type;
-
-    alter table j3_overview_doc 
-        add constraint FK5CD8D0E8C5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel;
-
-    alter table j3_overview_doc 
-        add constraint FK5CD8D0E8E8CE1B36 
-        foreign key (tomodel_instance_info_id) 
-        references j3_tmodel_instance_info;
-
-    alter table j3_overview_doc_descr 
-        add constraint FK36FB9EA9BDC711C 
-        foreign key (overview_doc_id) 
-        references j3_overview_doc;
-
-    alter table j3_person_name 
-        add constraint FKCB7B8AFF2E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact;
-
-    alter table j3_phone 
-        add constraint FK359202B82E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact;
-
-    alter table j3_publisher_assertion 
-        add constraint FK8A102449E3544929 
-        foreign key (to_key) 
-        references j3_business_entity;
-
-    alter table j3_publisher_assertion 
-        add constraint FK8A102449CCEE22D8 
-        foreign key (from_key) 
-        references j3_business_entity;
-
-    alter table j3_reference 
-        add constraint FK493A4F951E480746 
-        foreign key (signed_info_key) 
-        references j3_signed_info;
-
-    alter table j3_service_category_bag 
-        add constraint FK185A68076A68D45A 
-        foreign key (id) 
-        references j3_category_bag;
-
-    alter table j3_service_category_bag 
-        add constraint FK185A680748D0656D 
-        foreign key (entity_key) 
-        references j3_business_service;
-
-    alter table j3_service_descr 
-        add constraint FKB6D63D4148D0656D 
-        foreign key (entity_key) 
-        references j3_business_service;
-
-    alter table j3_service_name 
-        add constraint FKCC1BE94B48D0656D 
-        foreign key (entity_key) 
-        references j3_business_service;
-
-    alter table j3_service_projection 
-        add constraint FK629F290F2E448F3F 
-        foreign key (service_key) 
-        references j3_business_service;
-
-    alter table j3_service_projection 
-        add constraint FK629F290FEF04CFEE 
-        foreign key (business_key) 
-        references j3_business_entity;
-
-    alter table j3_signature 
-        add constraint FKC05CA90256E87DED 
-        foreign key (publisher_key) 
-        references j3_publisher;
-
-    alter table j3_signature 
-        add constraint FKC05CA90271CD8948 
-        foreign key (binding_template_key) 
-        references j3_binding_template;
-
-    alter table j3_signature 
-        add constraint FKC05CA90212F40D40 
-        foreign key (business_service_key) 
-        references j3_business_service;
-
-    alter table j3_signature 
-        add constraint FKC05CA9028ACE9A26 
-        foreign key (signed_info) 
-        references j3_signed_info;
-
-    alter table j3_signature 
-        add constraint FKC05CA9027CE6418E 
-        foreign key (signature_value) 
-        references j3_signature_value;
-
-    alter table j3_signature 
-        add constraint FKC05CA9025793CF55 
-        foreign key (tmodel_key) 
-        references j3_tmodel;
-
-    alter table j3_signature 
-        add constraint FKC05CA902DA6C2DD0 
-        foreign key (key_info) 
-        references j3_key_info;
-
-    alter table j3_signature 
-        add constraint FKC05CA902EF04CFEE 
-        foreign key (business_key) 
-        references j3_business_entity;
-
-    alter table j3_signature_transform 
-        add constraint FK726346F9256790B 
-        foreign key (reference_key) 
-        references j3_reference;
-
-    alter table j3_signature_transform_data_v 
-        add constraint FK3242526C7B88B2A4 
-        foreign key (signature_transform_key) 
-        references j3_signature_transform;
-
-    alter table j3_signed_info 
-        add constraint FKD2E7E5BB877110CC 
-        foreign key (canonicalization_method) 
-        references j3_canonicalization_method;
-
-    alter table j3_signed_info 
-        add constraint FKD2E7E5BB1A25896 
-        foreign key (signature_method) 
-        references j3_signature_method;
-
-    alter table j3_subscription_match 
-        add constraint FK5B9C2F19BEEE42E5 
-        foreign key (subscription_key) 
-        references j3_subscription;
-
-    alter table j3_tmodel 
-        add constraint FK83C8072BD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity;
-
-    alter table j3_tmodel_category_bag 
-        add constraint FK7E0859DB6A68D45A 
-        foreign key (id) 
-        references j3_category_bag;
-
-    alter table j3_tmodel_category_bag 
-        add constraint FK7E0859DBC5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel;
-
-    alter table j3_tmodel_descr 
-        add constraint FK63DFF1EDC5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel;
-
-    alter table j3_tmodel_identifier 
-        add constraint FKD5FB623DC5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel;
-
-    alter table j3_tmodel_instance_info 
-        add constraint FKDC6C9004CFBD88B7 
-        foreign key (entity_key) 
-        references j3_binding_template;
-
-    alter table j3_tmodel_instance_info_descr 
-        add constraint FKD826B4062B115C6F 
-        foreign key (tmodel_instance_info_id) 
-        references j3_tmodel_instance_info;
-
-    alter table j3_transfer_token_keys 
-        add constraint FK8BBF49185ED9DD48 
-        foreign key (transfer_token) 
-        references j3_transfer_token;

http://git-wip-us.apache.org/repos/asf/juddi/blob/432345b0/docs/db/ddl/sybase.ddl
----------------------------------------------------------------------
diff --git a/docs/db/ddl/sybase.ddl b/docs/db/ddl/sybase.ddl
deleted file mode 100644
index ef40690..0000000
--- a/docs/db/ddl/sybase.ddl
+++ /dev/null
@@ -1,821 +0,0 @@
-
-    create table j3_address (
-        id numeric(19,0) identity not null,
-        sort_code varchar(10) null,
-        tmodel_key varchar(255) null,
-        use_type varchar(255) null,
-        address_id numeric(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_address_line (
-        id numeric(19,0) identity not null,
-        key_name varchar(255) null,
-        key_value varchar(255) null,
-        line varchar(80) not null,
-        address_id numeric(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_auth_token (
-        auth_token varchar(51) not null,
-        authorized_name varchar(255) not null,
-        created datetime not null,
-        last_used datetime not null,
-        number_of_uses int not null,
-        token_state int not null,
-		ipaddress varchar(51),
-        primary key (auth_token)
-    );
-
-    create table j3_binding_category_bag (
-        id numeric(19,0) not null,
-        entity_key varchar(255) not null,
-        primary key (id),
-        unique (entity_key)
-    );
-
-    create table j3_binding_descr (
-        id numeric(19,0) identity not null,
-        descr varchar(255) not null,
-        lang_code varchar(26) null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_binding_template (
-        access_point_type varchar(255) null,
-        access_point_url varchar(4096) null,
-        hosting_redirector varchar(255) null,
-        entity_key varchar(255) not null,
-        service_key varchar(255) not null,
-        primary key (entity_key)
-    );
-
-    create table j3_business_category_bag (
-        id numeric(19,0) not null,
-        entity_key varchar(255) not null,
-        primary key (id),
-        unique (entity_key)
-    );
-
-    create table j3_business_descr (
-        id numeric(19,0) identity not null,
-        descr varchar(255) not null,
-        lang_code varchar(26) null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_business_entity (
-        entity_key varchar(255) not null,
-        primary key (entity_key)
-    );
-
-    create table j3_business_identifier (
-        id numeric(19,0) identity not null,
-        key_name varchar(255) null,
-        key_value varchar(255) not null,
-        tmodel_key_ref varchar(255) null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_business_name (
-        id numeric(19,0) identity not null,
-        lang_code varchar(26) null,
-        name varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_business_service (
-        entity_key varchar(255) not null,
-        business_key varchar(255) not null,
-        primary key (entity_key)
-    );
-
-    create table j3_canonicalization_method (
-        id numeric(19,0) identity not null,
-        algorithm varchar(255) null,
-        primary key (id)
-    );
-
-    create table j3_category_bag (
-        id numeric(19,0) identity not null,
-        primary key (id)
-    );
-
-    create table j3_clerk (
-        clerk_name varchar(255) not null,
-        cred varchar(255) null,
-        publisher_id varchar(255) not null,
-        node_name varchar(255) null,
-        primary key (clerk_name)
-    );
-
-    create table j3_client_subscriptioninfo (
-        subscription_key varchar(255) not null,
-        last_notified datetime null,
-        fromClerk_clerk_name varchar(255) null,
-        toClerk_clerk_name varchar(255) null,
-        primary key (subscription_key)
-    );
-
-    create table j3_contact (
-        id numeric(19,0) identity not null,
-        use_type varchar(255) null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_contact_descr (
-        id numeric(19,0) identity not null,
-        descr varchar(255) not null,
-        lang_code varchar(26) null,
-        contact_id numeric(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_discovery_url (
-        id numeric(19,0) identity not null,
-        url varchar(4096) not null,
-        use_type varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_email (
-        id numeric(19,0) identity not null,
-        email_address varchar(4096) not null,
-        use_type varchar(255) null,
-        contact_id numeric(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_instance_details_descr (
-        id numeric(19,0) identity not null,
-        descr varchar(255) not null,
-        lang_code varchar(26) null,
-        tmodel_instance_info_id numeric(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_instance_details_doc_descr (
-        id numeric(19,0) identity not null,
-        descr varchar(255) not null,
-        lang_code varchar(26) null,
-        tmodel_instance_info_id numeric(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_key_data_value (
-        id numeric(19,0) identity not null,
-        key_data_name varchar(255) null,
-        key_data_type varchar(255) null,
-        key_data_value image null,
-        key_data_value_string text null,
-        key_data_value_key numeric(19,0) null,
-        key_info_key numeric(19,0) null,
-        primary key (id)
-    );
-
-    create table j3_key_info (
-        id numeric(19,0) identity not null,
-        xml_id varchar(255) null,
-        primary key (id)
-    );
-
-    create table j3_keyed_reference (
-        id numeric(19,0) identity not null,
-        key_name varchar(255) null,
-        key_value varchar(255) not null,
-        tmodel_key_ref varchar(255) null,
-        category_bag_id numeric(19,0) null,
-        keyed_reference_group_id numeric(19,0) null,
-        primary key (id)
-    );
-
-    create table j3_keyed_reference_group (
-        id numeric(19,0) identity not null,
-        tmodel_key varchar(255) null,
-        category_bag_id numeric(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_node (
-        name varchar(255) not null,
-        client_name varchar(255) not null,
-        custody_transfer_url varchar(255) not null,
-        factory_initial varchar(255) null,
-        factory_naming_provider varchar(255) null,
-        factory_url_pkgs varchar(255) null,
-        inquiry_url varchar(255) not null,
-        juddi_api_url varchar(255) 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,
-        primary key (name)
-    );
-
-    create table j3_object_type (
-        id numeric(19,0) identity not null,
-        encoding varchar(255) null,
-        mime_type varchar(255) null,
-        xml_id varchar(255) null,
-        signature_key numeric(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_object_type_content (
-        id numeric(19,0) identity not null,
-        content image null,
-        object_type_key numeric(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_overview_doc (
-        id numeric(19,0) identity not null,
-        overview_url varchar(255) null,
-        overview_url_use_type varchar(255) null,
-        entity_key varchar(255) null,
-        tomodel_instance_info_id numeric(19,0) null,
-        primary key (id)
-    );
-
-    create table j3_overview_doc_descr (
-        id numeric(19,0) identity not null,
-        descr varchar(1024) not null,
-        lang_code varchar(26) null,
-        overview_doc_id numeric(19,0) null,
-        primary key (id)
-    );
-
-    create table j3_person_name (
-        id numeric(19,0) identity not null,
-        lang_code varchar(26) null,
-        name varchar(255) not null,
-        contact_id numeric(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_phone (
-        id numeric(19,0) identity not null,
-        phone_number varchar(50) not null,
-        use_type varchar(255) null,
-        contact_id numeric(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_publisher (
-        authorized_name varchar(255) not null,
-        email_address varchar(255) null,
-        is_admin bool null,
-        is_enabled bool null,
-        max_bindings_per_service int null,
-        max_businesses int null,
-        max_services_per_business int null,
-        max_tmodels int null,
-        publisher_name varchar(255) not null,
-        primary key (authorized_name)
-    );
-
-    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,
-        primary key (from_key, to_key)
-    );
-
-    create table j3_reference (
-        id numeric(19,0) identity not null,
-        digest_method varchar(255) null,
-        digest_value image null,
-        type varchar(255) null,
-        uri varchar(255) null,
-        xml_id varchar(255) null,
-        signed_info_key numeric(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_service_category_bag (
-        id numeric(19,0) not null,
-        entity_key varchar(255) not null,
-        primary key (id),
-        unique (entity_key)
-    );
-
-    create table j3_service_descr (
-        id numeric(19,0) identity not null,
-        descr varchar(1024) not null,
-        lang_code varchar(26) null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_service_name (
-        id numeric(19,0) identity not null,
-        lang_code varchar(26) null,
-        name varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_service_projection (
-        business_key varchar(255) not null,
-        service_key varchar(255) not null,
-        primary key (business_key, service_key)
-    );
-
-    create table j3_signature (
-        id numeric(19,0) identity not null,
-        xml_id varchar(255) null,
-        binding_template_key varchar(255) null,
-        business_key varchar(255) null,
-        business_service_key varchar(255) null,
-        key_info numeric(19,0) not null,
-        publisher_key varchar(255) null,
-        signature_value numeric(19,0) not null,
-        signed_info numeric(19,0) not null,
-        tmodel_key varchar(255) null,
-        primary key (id)
-    );
-
-    create table j3_signature_method (
-        id numeric(19,0) identity not null,
-        algorithm varchar(255) null,
-        primary key (id)
-    );
-
-    create table j3_signature_transform (
-        id numeric(19,0) identity not null,
-        transform varchar(255) null,
-        reference_key numeric(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_signature_transform_data_v (
-        id numeric(19,0) identity not null,
-        content_bytes image null,
-        content_type varchar(255) null,
-        signature_transform_key numeric(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_signature_value (
-        id numeric(19,0) identity not null,
-        value_bytes image null,
-        xml_id varchar(255) null,
-        primary key (id)
-    );
-
-    create table j3_signed_info (
-        id numeric(19,0) identity not null,
-        xml_id varchar(255) null,
-        canonicalization_method numeric(19,0) not null,
-        signature_method numeric(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_subscription (
-        subscription_key varchar(255) not null,
-        authorized_name varchar(255) not null,
-        binding_key varchar(255) null,
-        brief tinyint null,
-        create_date datetime not null,
-        expires_after datetime null,
-        last_notified datetime null,
-        max_entities int null,
-        notification_interval varchar(255) null,
-        subscription_filter text not null,
-        primary key (subscription_key)
-    );
-
-    create table j3_subscription_chunk_token (
-        chunk_token varchar(255) not null,
-        data int not null,
-        end_point datetime null,
-        expires_after datetime not null,
-        start_point datetime null,
-        subscription_key varchar(255) not null,
-        primary key (chunk_token)
-    );
-
-    create table j3_subscription_match (
-        id numeric(19,0) identity not null,
-        entity_key varchar(255) not null,
-        subscription_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_temp_key (
-        entity_key varchar(255) not null,
-        tx_id varchar(255) not null,
-        primary key (entity_key, tx_id)
-    );
-
-    create table j3_tmodel (
-        deleted tinyint null,
-        lang_code varchar(26) null,
-        name varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (entity_key)
-    );
-
-    create table j3_tmodel_category_bag (
-        id numeric(19,0) not null,
-        entity_key varchar(255) not null,
-        primary key (id),
-        unique (entity_key)
-    );
-
-    create table j3_tmodel_descr (
-        id numeric(19,0) identity not null,
-        descr varchar(255) not null,
-        lang_code varchar(26) null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_tmodel_identifier (
-        id numeric(19,0) identity not null,
-        key_name varchar(255) null,
-        key_value varchar(255) not null,
-        tmodel_key_ref varchar(255) null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_tmodel_instance_info (
-        id numeric(19,0) identity not null,
-        instance_parms varchar(8192) null,
-        tmodel_key varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_tmodel_instance_info_descr (
-        id numeric(19,0) identity not null,
-        descr varchar(255) not null,
-        lang_code varchar(26) null,
-        tmodel_instance_info_id numeric(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_transfer_token (
-        transfer_token varchar(51) not null,
-        expiration_date datetime not null,
-        primary key (transfer_token)
-    );
-
-    create table j3_transfer_token_keys (
-        id numeric(19,0) identity not null,
-        entity_key varchar(255) null,
-        transfer_token varchar(51) not null,
-        primary key (id)
-    );
-
-    create table j3_uddi_entity (
-        entity_key varchar(255) not null,
-        authorized_name varchar(255) not null,
-        created datetime null,
-        modified datetime not null,
-        modified_including_children datetime null,
-        node_id varchar(255) null,
-        primary key (entity_key)
-    );
-
-    alter table j3_address 
-        add constraint FKF83236BE75D860FB 
-        foreign key (address_id) 
-        references j3_contact;
-
-    alter table j3_address_line 
-        add constraint FKC665B8D5F8B8D8CF 
-        foreign key (address_id) 
-        references j3_address;
-
-    alter table j3_binding_category_bag 
-        add constraint FKCF34B2376A68D45A 
-        foreign key (id) 
-        references j3_category_bag;
-
-    alter table j3_binding_category_bag 
-        add constraint FKCF34B237CFBD88B7 
-        foreign key (entity_key) 
-        references j3_binding_template;
-
-    alter table j3_binding_descr 
-        add constraint FK5EA60911CFBD88B7 
-        foreign key (entity_key) 
-        references j3_binding_template;
-
-    alter table j3_binding_template 
-        add constraint FKD044BD6A2E448F3F 
-        foreign key (service_key) 
-        references j3_business_service;
-
-    alter table j3_binding_template 
-        add constraint FKD044BD6AD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity;
-
-    alter table j3_business_category_bag 
-        add constraint FKD6D3ECB06A68D45A 
-        foreign key (id) 
-        references j3_category_bag;
-
-    alter table j3_business_category_bag 
-        add constraint FKD6D3ECB0BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_business_descr 
-        add constraint FK3A24B4B8BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_business_entity 
-        add constraint FKCA61A0CD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity;
-
-    alter table j3_business_identifier 
-        add constraint FKB0C7A652BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_business_name 
-        add constraint FK43F526F4BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_business_service 
-        add constraint FK5D4255ACD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity;
-
-    alter table j3_business_service 
-        add constraint FK5D4255ACEF04CFEE 
-        foreign key (business_key) 
-        references j3_business_entity;
-
-    alter table j3_clerk 
-        add constraint FK34DC7D9F6BB0F935 
-        foreign key (node_name) 
-        references j3_node;
-
-    alter table j3_client_subscriptioninfo 
-        add constraint FKDF04CC095BFC6733 
-        foreign key (fromClerk_clerk_name) 
-        references j3_clerk;
-
-    alter table j3_client_subscriptioninfo 
-        add constraint FKDF04CC09F3CE9C04 
-        foreign key (toClerk_clerk_name) 
-        references j3_clerk;
-
-    alter table j3_contact 
-        add constraint FK7551BEEABEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_contact_descr 
-        add constraint FK56CA9E6C2E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact;
-
-    alter table j3_discovery_url 
-        add constraint FKA042FDAABEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_email 
-        add constraint FK34F910E62E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact;
-
-    alter table j3_instance_details_descr 
-        add constraint FK3CC165902B115C6F 
-        foreign key (tmodel_instance_info_id) 
-        references j3_tmodel_instance_info;
-
-    alter table j3_instance_details_doc_descr 
-        add constraint FK447324492B115C6F 
-        foreign key (tmodel_instance_info_id) 
-        references j3_tmodel_instance_info;
-
-    alter table j3_key_data_value 
-        add constraint FK74B7E072843143EF 
-        foreign key (key_data_value_key) 
-        references j3_key_data_value;
-
-    alter table j3_key_data_value 
-        add constraint FK74B7E07238C90470 
-        foreign key (key_info_key) 
-        references j3_key_info;
-
-    alter table j3_keyed_reference 
-        add constraint FK350C8454E075C8D7 
-        foreign key (keyed_reference_group_id) 
-        references j3_keyed_reference_group;
-
-    alter table j3_keyed_reference 
-        add constraint FK350C84541DB72652 
-        foreign key (category_bag_id) 
-        references j3_category_bag;
-
-    alter table j3_keyed_reference_group 
-        add constraint FKF6224ED41DB72652 
-        foreign key (category_bag_id) 
-        references j3_category_bag;
-
-    alter table j3_object_type 
-        add constraint FK98BBFA04BC6AD65 
-        foreign key (signature_key) 
-        references j3_signature;
-
-    alter table j3_object_type_content 
-        add constraint FK987A913E71FA643E 
-        foreign key (object_type_key) 
-        references j3_object_type;
-
-    alter table j3_overview_doc 
-        add constraint FK5CD8D0E8C5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel;
-
-    alter table j3_overview_doc 
-        add constraint FK5CD8D0E8E8CE1B36 
-        foreign key (tomodel_instance_info_id) 
-        references j3_tmodel_instance_info;
-
-    alter table j3_overview_doc_descr 
-        add constraint FK36FB9EA9BDC711C 
-        foreign key (overview_doc_id) 
-        references j3_overview_doc;
-
-    alter table j3_person_name 
-        add constraint FKCB7B8AFF2E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact;
-
-    alter table j3_phone 
-        add constraint FK359202B82E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact;
-
-    alter table j3_publisher_assertion 
-        add constraint FK8A102449E3544929 
-        foreign key (to_key) 
-        references j3_business_entity;
-
-    alter table j3_publisher_assertion 
-        add constraint FK8A102449CCEE22D8 
-        foreign key (from_key) 
-        references j3_business_entity;
-
-    alter table j3_reference 
-        add constraint FK493A4F951E480746 
-        foreign key (signed_info_key) 
-        references j3_signed_info;
-
-    alter table j3_service_category_bag 
-        add constraint FK185A68076A68D45A 
-        foreign key (id) 
-        references j3_category_bag;
-
-    alter table j3_service_category_bag 
-        add constraint FK185A680748D0656D 
-        foreign key (entity_key) 
-        references j3_business_service;
-
-    alter table j3_service_descr 
-        add constraint FKB6D63D4148D0656D 
-        foreign key (entity_key) 
-        references j3_business_service;
-
-    alter table j3_service_name 
-        add constraint FKCC1BE94B48D0656D 
-        foreign key (entity_key) 
-        references j3_business_service;
-
-    alter table j3_service_projection 
-        add constraint FK629F290F2E448F3F 
-        foreign key (service_key) 
-        references j3_business_service;
-
-    alter table j3_service_projection 
-        add constraint FK629F290FEF04CFEE 
-        foreign key (business_key) 
-        references j3_business_entity;
-
-    alter table j3_signature 
-        add constraint FKC05CA90256E87DED 
-        foreign key (publisher_key) 
-        references j3_publisher;
-
-    alter table j3_signature 
-        add constraint FKC05CA90271CD8948 
-        foreign key (binding_template_key) 
-        references j3_binding_template;
-
-    alter table j3_signature 
-        add constraint FKC05CA90212F40D40 
-        foreign key (business_service_key) 
-        references j3_business_service;
-
-    alter table j3_signature 
-        add constraint FKC05CA9028ACE9A26 
-        foreign key (signed_info) 
-        references j3_signed_info;
-
-    alter table j3_signature 
-        add constraint FKC05CA9027CE6418E 
-        foreign key (signature_value) 
-        references j3_signature_value;
-
-    alter table j3_signature 
-        add constraint FKC05CA9025793CF55 
-        foreign key (tmodel_key) 
-        references j3_tmodel;
-
-    alter table j3_signature 
-        add constraint FKC05CA902DA6C2DD0 
-        foreign key (key_info) 
-        references j3_key_info;
-
-    alter table j3_signature 
-        add constraint FKC05CA902EF04CFEE 
-        foreign key (business_key) 
-        references j3_business_entity;
-
-    alter table j3_signature_transform 
-        add constraint FK726346F9256790B 
-        foreign key (reference_key) 
-        references j3_reference;
-
-    alter table j3_signature_transform_data_v 
-        add constraint FK3242526C7B88B2A4 
-        foreign key (signature_transform_key) 
-        references j3_signature_transform;
-
-    alter table j3_signed_info 
-        add constraint FKD2E7E5BB877110CC 
-        foreign key (canonicalization_method) 
-        references j3_canonicalization_method;
-
-    alter table j3_signed_info 
-        add constraint FKD2E7E5BB1A25896 
-        foreign key (signature_method) 
-        references j3_signature_method;
-
-    alter table j3_subscription_match 
-        add constraint FK5B9C2F19BEEE42E5 
-        foreign key (subscription_key) 
-        references j3_subscription;
-
-    alter table j3_tmodel 
-        add constraint FK83C8072BD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity;
-
-    alter table j3_tmodel_category_bag 
-        add constraint FK7E0859DB6A68D45A 
-        foreign key (id) 
-        references j3_category_bag;
-
-    alter table j3_tmodel_category_bag 
-        add constraint FK7E0859DBC5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel;
-
-    alter table j3_tmodel_descr 
-        add constraint FK63DFF1EDC5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel;
-
-    alter table j3_tmodel_identifier 
-        add constraint FKD5FB623DC5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel;
-
-    alter table j3_tmodel_instance_info 
-        add constraint FKDC6C9004CFBD88B7 
-        foreign key (entity_key) 
-        references j3_binding_template;
-
-    alter table j3_tmodel_instance_info_descr 
-        add constraint FKD826B4062B115C6F 
-        foreign key (tmodel_instance_info_id) 
-        references j3_tmodel_instance_info;
-
-    alter table j3_transfer_token_keys 
-        add constraint FK8BBF49185ED9DD48 
-        foreign key (transfer_token) 
-        references j3_transfer_token;

http://git-wip-us.apache.org/repos/asf/juddi/blob/432345b0/juddi-ddl-generator/pom.xml
----------------------------------------------------------------------
diff --git a/juddi-ddl-generator/pom.xml b/juddi-ddl-generator/pom.xml
new file mode 100644
index 0000000..2d08f34
--- /dev/null
+++ b/juddi-ddl-generator/pom.xml
@@ -0,0 +1,98 @@
+<?xml version="1.0"?>
+<project xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd" xmlns="http://maven.apache.org/POM/4.0.0"
+    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
+	<modelVersion>4.0.0</modelVersion>
+	<parent>
+		<groupId>org.apache.juddi</groupId>
+		<artifactId>juddi-parent</artifactId>
+		<version>3.2.1-SNAPSHOT</version>
+	</parent>
+	<groupId>org.apache.juddi.client.plugins</groupId>
+	<artifactId>juddi-ddl-generator</artifactId>
+	<version>3.2.1-SNAPSHOT</version>
+	<name>juddi-ddl-generator</name>
+	<url>http://maven.apache.org</url>
+	<properties>
+		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
+	</properties>
+	<dependencies>
+		<dependency>
+			<groupId>junit</groupId>
+			<artifactId>junit</artifactId>
+			<version>4.11</version>
+			<scope>test</scope>
+		</dependency>
+		<dependency>
+			<groupId>org.apache.juddi</groupId>
+			<artifactId>juddi-core</artifactId>
+			<version>3.2.1-SNAPSHOT</version>
+		</dependency>
+		<dependency>
+			<groupId>org.apache.derby</groupId>
+			<artifactId>derby</artifactId>
+			<version>10.10.1.1</version>
+		</dependency>
+
+		<dependency>
+			<groupId>mysql</groupId>
+			<artifactId>mysql-connector-java</artifactId>
+			<version>5.1.29</version>
+		</dependency>
+
+
+
+
+		<dependency>
+			<groupId>postgresql</groupId>
+			<artifactId>postgresql</artifactId>
+			<version>9.1-901.jdbc4</version>
+		</dependency>
+
+	</dependencies>	
+	<build>
+		<plugins>
+			<plugin>
+				<groupId>org.codehaus.mojo</groupId>
+				<artifactId>exec-maven-plugin</artifactId>
+				<version>1.1</version>
+				<executions>
+					<execution>
+						<id>my-execution</id>
+						<phase>compile</phase>
+						<goals>
+							<goal>java</goal>
+						</goals>
+					</execution>
+				</executions>
+				<configuration>
+					<mainClass>org.apache.juddi.ddl.generator.App</mainClass>
+					 <arguments>
+						<argument>juddi-core/target/classes/org/apache/juddi/model/</argument>
+					  </arguments>
+				</configuration>
+			</plugin>
+			<plugin>
+			   <groupId>org.apache.maven.plugins</groupId>
+			   <artifactId>maven-antrun-plugin</artifactId>
+			   <version>1.7</version>
+			   <executions>
+				  <execution>
+				  <id>copy-swf-files</id>
+				  <phase>test</phase>
+				  <goals>
+							<goal>run</goal>
+						</goals>
+				  <configuration>
+					 <target name="copy ddl to doc folder">      
+						<copy todir="../docs/db/ddl/">
+							<fileset dir="${project.build.directory}/../" includes="*.ddl">
+								
+							</fileset></copy>
+					 </target>
+				  </configuration>                       
+			   </execution> 
+			 </executions>
+			</plugin>
+		</plugins>
+	</build>
+</project>


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@juddi.apache.org
For additional commands, e-mail: commits-help@juddi.apache.org


[3/4] JUDDI-876 resolved

Posted by al...@apache.org.
http://git-wip-us.apache.org/repos/asf/juddi/blob/432345b0/docs/db/ddl/mysql5.ddl
----------------------------------------------------------------------
diff --git a/docs/db/ddl/mysql5.ddl b/docs/db/ddl/mysql5.ddl
deleted file mode 100644
index 50158e5..0000000
--- a/docs/db/ddl/mysql5.ddl
+++ /dev/null
@@ -1,887 +0,0 @@
-
-    create table j3_address (
-        id bigint not null auto_increment,
-        sort_code varchar(10),
-        tmodel_key varchar(255),
-        use_type varchar(255),
-        address_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_address_line (
-        id bigint not null auto_increment,
-        key_name varchar(255),
-        key_value varchar(255),
-        line varchar(80) not null,
-        address_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_auth_token (
-        auth_token varchar(51) not null,
-        authorized_name varchar(255) not null,
-        created datetime not null,
-        last_used datetime not null,
-        number_of_uses integer not null,
-        token_state integer not null,
-		ipaddress varchar(51),
-        primary key (auth_token)
-    );
-
-    create table j3_binding_category_bag (
-        id bigint not null,
-        entity_key varchar(255) not null,
-        primary key (id),
-        unique (entity_key)
-    );
-
-    create table j3_binding_descr (
-        id bigint not null auto_increment,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_binding_template (
-        access_point_type varchar(255),
-        access_point_url varchar(4096),
-        hosting_redirector varchar(255),
-        entity_key varchar(255) not null,
-        service_key varchar(255) not null,
-        primary key (entity_key)
-    );
-
-    create table j3_business_category_bag (
-        id bigint not null,
-        entity_key varchar(255) not null,
-        primary key (id),
-        unique (entity_key)
-    );
-
-    create table j3_business_descr (
-        id bigint not null auto_increment,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_business_entity (
-        entity_key varchar(255) not null,
-        primary key (entity_key)
-    );
-
-    create table j3_business_identifier (
-        id bigint not null auto_increment,
-        key_name varchar(255),
-        key_value varchar(255) not null,
-        tmodel_key_ref varchar(255),
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_business_name (
-        id bigint not null auto_increment,
-        lang_code varchar(26),
-        name varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_business_service (
-        entity_key varchar(255) not null,
-        business_key varchar(255) not null,
-        primary key (entity_key)
-    );
-
-    create table j3_canonicalization_method (
-        id bigint not null auto_increment,
-        algorithm varchar(255),
-        primary key (id)
-    );
-
-    create table j3_category_bag (
-        id bigint not null auto_increment,
-        primary key (id)
-    );
-
-    create table j3_clerk (
-        clerk_name varchar(255) not null,
-        cred varchar(255),
-        publisher_id varchar(255) not null,
-        node_name varchar(255),
-        primary key (clerk_name)
-    );
-
-    create table j3_client_subscriptioninfo (
-        subscription_key varchar(255) not null,
-        last_notified datetime,
-        fromClerk_clerk_name varchar(255),
-        toClerk_clerk_name varchar(255),
-        primary key (subscription_key)
-    );
-
-    create table j3_contact (
-        id bigint not null auto_increment,
-        use_type varchar(255),
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_contact_descr (
-        id bigint not null auto_increment,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        contact_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_discovery_url (
-        id bigint not null auto_increment,
-        url varchar(4096) not null,
-        use_type varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_email (
-        id bigint not null auto_increment,
-        email_address varchar(4096) not null,
-        use_type varchar(255),
-        contact_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_instance_details_descr (
-        id bigint not null auto_increment,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        tmodel_instance_info_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_instance_details_doc_descr (
-        id bigint not null auto_increment,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        tmodel_instance_info_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_key_data_value (
-        id bigint not null auto_increment,
-        key_data_name varchar(255),
-        key_data_type varchar(255),
-        key_data_value longblob,
-        key_data_value_string longtext,
-        key_data_value_key bigint,
-        key_info_key bigint,
-        primary key (id)
-    );
-
-    create table j3_key_info (
-        id bigint not null auto_increment,
-        xml_id varchar(255),
-        primary key (id)
-    );
-
-    create table j3_keyed_reference (
-        id bigint not null auto_increment,
-        key_name varchar(255),
-        key_value varchar(255) not null,
-        tmodel_key_ref varchar(255),
-        category_bag_id bigint,
-        keyed_reference_group_id bigint,
-        primary key (id)
-    );
-
-    create table j3_keyed_reference_group (
-        id bigint not null auto_increment,
-        tmodel_key varchar(255),
-        category_bag_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_node (
-        name varchar(255) not null,
-        client_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),
-        proxy_transport varchar(255) not null,
-        publish_url varchar(255) not null,
-        security_url varchar(255) not null,
-        subscription_url varchar(255) not null,
-        primary key (name)
-    );
-
-    create table j3_object_type (
-        id bigint not null auto_increment,
-        encoding varchar(255),
-        mime_type varchar(255),
-        xml_id varchar(255),
-        signature_key bigint not null,
-        primary key (id)
-    );
-
-    create table j3_object_type_content (
-        id bigint not null auto_increment,
-        content longblob,
-        object_type_key bigint not null,
-        primary key (id)
-    );
-
-    create table j3_overview_doc (
-        id bigint not null auto_increment,
-        overview_url varchar(255),
-        overview_url_use_type varchar(255),
-        entity_key varchar(255),
-        tomodel_instance_info_id bigint,
-        primary key (id)
-    );
-
-    create table j3_overview_doc_descr (
-        id bigint not null auto_increment,
-        descr varchar(1024) not null,
-        lang_code varchar(26),
-        overview_doc_id bigint,
-        primary key (id)
-    );
-
-    create table j3_person_name (
-        id bigint not null auto_increment,
-        lang_code varchar(26),
-        name varchar(255) not null,
-        contact_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_phone (
-        id bigint not null auto_increment,
-        phone_number varchar(50) not null,
-        use_type varchar(255),
-        contact_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_publisher (
-        authorized_name varchar(255) not null,
-        email_address varchar(255),
-        is_admin bool,
-        is_enabled bool,
-        max_bindings_per_service integer,
-        max_businesses integer,
-        max_services_per_business integer,
-        max_tmodels integer,
-        publisher_name varchar(255) not null,
-        primary key (authorized_name)
-    );
-
-    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,
-        primary key (from_key, to_key)
-    );
-
-    create table j3_reference (
-        id bigint not null auto_increment,
-        digest_method varchar(255),
-        digest_value longblob,
-        type varchar(255),
-        uri varchar(255),
-        xml_id varchar(255),
-        signed_info_key bigint not null,
-        primary key (id)
-    );
-
-    create table j3_service_category_bag (
-        id bigint not null,
-        entity_key varchar(255) not null,
-        primary key (id),
-        unique (entity_key)
-    );
-
-    create table j3_service_descr (
-        id bigint not null auto_increment,
-        descr varchar(1024) not null,
-        lang_code varchar(26),
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_service_name (
-        id bigint not null auto_increment,
-        lang_code varchar(26),
-        name varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_service_projection (
-        business_key varchar(255) not null,
-        service_key varchar(255) not null,
-        primary key (business_key, service_key)
-    );
-
-    create table j3_signature (
-        id bigint not null auto_increment,
-        xml_id varchar(255),
-        binding_template_key varchar(255),
-        business_key varchar(255),
-        business_service_key varchar(255),
-        key_info bigint not null,
-        publisher_key varchar(255),
-        signature_value bigint not null,
-        signed_info bigint not null,
-        tmodel_key varchar(255),
-        primary key (id)
-    );
-
-    create table j3_signature_method (
-        id bigint not null auto_increment,
-        algorithm varchar(255),
-        primary key (id)
-    );
-
-    create table j3_signature_transform (
-        id bigint not null auto_increment,
-        transform varchar(255),
-        reference_key bigint not null,
-        primary key (id)
-    );
-
-    create table j3_signature_transform_data_v (
-        id bigint not null auto_increment,
-        content_bytes longblob,
-        content_type varchar(255),
-        signature_transform_key bigint not null,
-        primary key (id)
-    );
-
-    create table j3_signature_value (
-        id bigint not null auto_increment,
-        value_bytes longblob,
-        xml_id varchar(255),
-        primary key (id)
-    );
-
-    create table j3_signed_info (
-        id bigint not null auto_increment,
-        xml_id varchar(255),
-        canonicalization_method bigint not null,
-        signature_method bigint not null,
-        primary key (id)
-    );
-
-    create table j3_subscription (
-        subscription_key varchar(255) not null,
-        authorized_name varchar(255) not null,
-        binding_key varchar(255),
-        brief bit,
-        create_date datetime not null,
-        expires_after datetime,
-        last_notified datetime,
-        max_entities integer,
-        notification_interval varchar(255),
-        subscription_filter longtext not null,
-        primary key (subscription_key)
-    );
-
-    create table j3_subscription_chunk_token (
-        chunk_token varchar(255) not null,
-        data integer not null,
-        end_point datetime,
-        expires_after datetime not null,
-        start_point datetime,
-        subscription_key varchar(255) not null,
-        primary key (chunk_token)
-    );
-
-    create table j3_subscription_match (
-        id bigint not null auto_increment,
-        entity_key varchar(255) not null,
-        subscription_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_temp_key (
-        entity_key varchar(255) not null,
-        tx_id varchar(255) not null,
-        primary key (entity_key, tx_id)
-    );
-
-    create table j3_tmodel (
-        deleted bit,
-        lang_code varchar(26),
-        name varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (entity_key)
-    );
-
-    create table j3_tmodel_category_bag (
-        id bigint not null,
-        entity_key varchar(255) not null,
-        primary key (id),
-        unique (entity_key)
-    );
-
-    create table j3_tmodel_descr (
-        id bigint not null auto_increment,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_tmodel_identifier (
-        id bigint not null auto_increment,
-        key_name varchar(255),
-        key_value varchar(255) not null,
-        tmodel_key_ref varchar(255),
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_tmodel_instance_info (
-        id bigint not null auto_increment,
-        instance_parms varchar(8192),
-        tmodel_key varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_tmodel_instance_info_descr (
-        id bigint not null auto_increment,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        tmodel_instance_info_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_transfer_token (
-        transfer_token varchar(51) not null,
-        expiration_date datetime not null,
-        primary key (transfer_token)
-    );
-
-    create table j3_transfer_token_keys (
-        id bigint not null auto_increment,
-        entity_key varchar(255),
-        transfer_token varchar(51) not null,
-        primary key (id)
-    );
-
-    create table j3_uddi_entity (
-        entity_key varchar(255) not null,
-        authorized_name varchar(255) not null,
-        created datetime,
-        modified datetime not null,
-        modified_including_children datetime,
-        node_id varchar(255),
-        primary key (entity_key)
-    );
-
-    alter table j3_address 
-        add index FKF83236BE75D860FB (address_id), 
-        add constraint FKF83236BE75D860FB 
-        foreign key (address_id) 
-        references j3_contact (id);
-
-    alter table j3_address_line 
-        add index FKC665B8D5F8B8D8CF (address_id), 
-        add constraint FKC665B8D5F8B8D8CF 
-        foreign key (address_id) 
-        references j3_address (id);
-
-    alter table j3_binding_category_bag 
-        add index FKCF34B2376A68D45A (id), 
-        add constraint FKCF34B2376A68D45A 
-        foreign key (id) 
-        references j3_category_bag (id);
-
-    alter table j3_binding_category_bag 
-        add index FKCF34B237CFBD88B7 (entity_key), 
-        add constraint FKCF34B237CFBD88B7 
-        foreign key (entity_key) 
-        references j3_binding_template (entity_key);
-
-    alter table j3_binding_descr 
-        add index FK5EA60911CFBD88B7 (entity_key), 
-        add constraint FK5EA60911CFBD88B7 
-        foreign key (entity_key) 
-        references j3_binding_template (entity_key);
-
-    alter table j3_binding_template 
-        add index FKD044BD6A2E448F3F (service_key), 
-        add constraint FKD044BD6A2E448F3F 
-        foreign key (service_key) 
-        references j3_business_service (entity_key);
-
-    alter table j3_binding_template 
-        add index FKD044BD6AD1823CA5 (entity_key), 
-        add constraint FKD044BD6AD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity (entity_key);
-
-    alter table j3_business_category_bag 
-        add index FKD6D3ECB06A68D45A (id), 
-        add constraint FKD6D3ECB06A68D45A 
-        foreign key (id) 
-        references j3_category_bag (id);
-
-    alter table j3_business_category_bag 
-        add index FKD6D3ECB0BEB92A91 (entity_key), 
-        add constraint FKD6D3ECB0BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity (entity_key);
-
-    alter table j3_business_descr 
-        add index FK3A24B4B8BEB92A91 (entity_key), 
-        add constraint FK3A24B4B8BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity (entity_key);
-
-    alter table j3_business_entity 
-        add index FKCA61A0CD1823CA5 (entity_key), 
-        add constraint FKCA61A0CD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity (entity_key);
-
-    alter table j3_business_identifier 
-        add index FKB0C7A652BEB92A91 (entity_key), 
-        add constraint FKB0C7A652BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity (entity_key);
-
-    alter table j3_business_name 
-        add index FK43F526F4BEB92A91 (entity_key), 
-        add constraint FK43F526F4BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity (entity_key);
-
-    alter table j3_business_service 
-        add index FK5D4255ACD1823CA5 (entity_key), 
-        add constraint FK5D4255ACD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity (entity_key);
-
-    alter table j3_business_service 
-        add index FK5D4255ACEF04CFEE (business_key), 
-        add constraint FK5D4255ACEF04CFEE 
-        foreign key (business_key) 
-        references j3_business_entity (entity_key);
-
-    alter table j3_clerk 
-        add index FK34DC7D9F6BB0F935 (node_name), 
-        add constraint FK34DC7D9F6BB0F935 
-        foreign key (node_name) 
-        references j3_node (name);
-
-    alter table j3_client_subscriptioninfo 
-        add index FKDF04CC095BFC6733 (fromClerk_clerk_name), 
-        add constraint FKDF04CC095BFC6733 
-        foreign key (fromClerk_clerk_name) 
-        references j3_clerk (clerk_name);
-
-    alter table j3_client_subscriptioninfo 
-        add index FKDF04CC09F3CE9C04 (toClerk_clerk_name), 
-        add constraint FKDF04CC09F3CE9C04 
-        foreign key (toClerk_clerk_name) 
-        references j3_clerk (clerk_name);
-
-    alter table j3_contact 
-        add index FK7551BEEABEB92A91 (entity_key), 
-        add constraint FK7551BEEABEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity (entity_key);
-
-    alter table j3_contact_descr 
-        add index FK56CA9E6C2E3FD94F (contact_id), 
-        add constraint FK56CA9E6C2E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact (id);
-
-    alter table j3_discovery_url 
-        add index FKA042FDAABEB92A91 (entity_key), 
-        add constraint FKA042FDAABEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity (entity_key);
-
-    alter table j3_email 
-        add index FK34F910E62E3FD94F (contact_id), 
-        add constraint FK34F910E62E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact (id);
-
-    alter table j3_instance_details_descr 
-        add index FK3CC165902B115C6F (tmodel_instance_info_id), 
-        add constraint FK3CC165902B115C6F 
-        foreign key (tmodel_instance_info_id) 
-        references j3_tmodel_instance_info (id);
-
-    alter table j3_instance_details_doc_descr 
-        add index FK447324492B115C6F (tmodel_instance_info_id), 
-        add constraint FK447324492B115C6F 
-        foreign key (tmodel_instance_info_id) 
-        references j3_tmodel_instance_info (id);
-
-    alter table j3_key_data_value 
-        add index FK74B7E072843143EF (key_data_value_key), 
-        add constraint FK74B7E072843143EF 
-        foreign key (key_data_value_key) 
-        references j3_key_data_value (id);
-
-    alter table j3_key_data_value 
-        add index FK74B7E07238C90470 (key_info_key), 
-        add constraint FK74B7E07238C90470 
-        foreign key (key_info_key) 
-        references j3_key_info (id);
-
-    alter table j3_keyed_reference 
-        add index FK350C8454E075C8D7 (keyed_reference_group_id), 
-        add constraint FK350C8454E075C8D7 
-        foreign key (keyed_reference_group_id) 
-        references j3_keyed_reference_group (id);
-
-    alter table j3_keyed_reference 
-        add index FK350C84541DB72652 (category_bag_id), 
-        add constraint FK350C84541DB72652 
-        foreign key (category_bag_id) 
-        references j3_category_bag (id);
-
-    alter table j3_keyed_reference_group 
-        add index FKF6224ED41DB72652 (category_bag_id), 
-        add constraint FKF6224ED41DB72652 
-        foreign key (category_bag_id) 
-        references j3_category_bag (id);
-
-    alter table j3_object_type 
-        add index FK98BBFA04BC6AD65 (signature_key), 
-        add constraint FK98BBFA04BC6AD65 
-        foreign key (signature_key) 
-        references j3_signature (id);
-
-    alter table j3_object_type_content 
-        add index FK987A913E71FA643E (object_type_key), 
-        add constraint FK987A913E71FA643E 
-        foreign key (object_type_key) 
-        references j3_object_type (id);
-
-    alter table j3_overview_doc 
-        add index FK5CD8D0E8C5BF8903 (entity_key), 
-        add constraint FK5CD8D0E8C5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel (entity_key);
-
-    alter table j3_overview_doc 
-        add index FK5CD8D0E8E8CE1B36 (tomodel_instance_info_id), 
-        add constraint FK5CD8D0E8E8CE1B36 
-        foreign key (tomodel_instance_info_id) 
-        references j3_tmodel_instance_info (id);
-
-    alter table j3_overview_doc_descr 
-        add index FK36FB9EA9BDC711C (overview_doc_id), 
-        add constraint FK36FB9EA9BDC711C 
-        foreign key (overview_doc_id) 
-        references j3_overview_doc (id);
-
-    alter table j3_person_name 
-        add index FKCB7B8AFF2E3FD94F (contact_id), 
-        add constraint FKCB7B8AFF2E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact (id);
-
-    alter table j3_phone 
-        add index FK359202B82E3FD94F (contact_id), 
-        add constraint FK359202B82E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact (id);
-
-    alter table j3_publisher_assertion 
-        add index FK8A102449E3544929 (to_key), 
-        add constraint FK8A102449E3544929 
-        foreign key (to_key) 
-        references j3_business_entity (entity_key);
-
-    alter table j3_publisher_assertion 
-        add index FK8A102449CCEE22D8 (from_key), 
-        add constraint FK8A102449CCEE22D8 
-        foreign key (from_key) 
-        references j3_business_entity (entity_key);
-
-    alter table j3_reference 
-        add index FK493A4F951E480746 (signed_info_key), 
-        add constraint FK493A4F951E480746 
-        foreign key (signed_info_key) 
-        references j3_signed_info (id);
-
-    alter table j3_service_category_bag 
-        add index FK185A68076A68D45A (id), 
-        add constraint FK185A68076A68D45A 
-        foreign key (id) 
-        references j3_category_bag (id);
-
-    alter table j3_service_category_bag 
-        add index FK185A680748D0656D (entity_key), 
-        add constraint FK185A680748D0656D 
-        foreign key (entity_key) 
-        references j3_business_service (entity_key);
-
-    alter table j3_service_descr 
-        add index FKB6D63D4148D0656D (entity_key), 
-        add constraint FKB6D63D4148D0656D 
-        foreign key (entity_key) 
-        references j3_business_service (entity_key);
-
-    alter table j3_service_name 
-        add index FKCC1BE94B48D0656D (entity_key), 
-        add constraint FKCC1BE94B48D0656D 
-        foreign key (entity_key) 
-        references j3_business_service (entity_key);
-
-    alter table j3_service_projection 
-        add index FK629F290F2E448F3F (service_key), 
-        add constraint FK629F290F2E448F3F 
-        foreign key (service_key) 
-        references j3_business_service (entity_key);
-
-    alter table j3_service_projection 
-        add index FK629F290FEF04CFEE (business_key), 
-        add constraint FK629F290FEF04CFEE 
-        foreign key (business_key) 
-        references j3_business_entity (entity_key);
-
-    alter table j3_signature 
-        add index FKC05CA90256E87DED (publisher_key), 
-        add constraint FKC05CA90256E87DED 
-        foreign key (publisher_key) 
-        references j3_publisher (authorized_name);
-
-    alter table j3_signature 
-        add index FKC05CA90271CD8948 (binding_template_key), 
-        add constraint FKC05CA90271CD8948 
-        foreign key (binding_template_key) 
-        references j3_binding_template (entity_key);
-
-    alter table j3_signature 
-        add index FKC05CA90212F40D40 (business_service_key), 
-        add constraint FKC05CA90212F40D40 
-        foreign key (business_service_key) 
-        references j3_business_service (entity_key);
-
-    alter table j3_signature 
-        add index FKC05CA9028ACE9A26 (signed_info), 
-        add constraint FKC05CA9028ACE9A26 
-        foreign key (signed_info) 
-        references j3_signed_info (id);
-
-    alter table j3_signature 
-        add index FKC05CA9027CE6418E (signature_value), 
-        add constraint FKC05CA9027CE6418E 
-        foreign key (signature_value) 
-        references j3_signature_value (id);
-
-    alter table j3_signature 
-        add index FKC05CA9025793CF55 (tmodel_key), 
-        add constraint FKC05CA9025793CF55 
-        foreign key (tmodel_key) 
-        references j3_tmodel (entity_key);
-
-    alter table j3_signature 
-        add index FKC05CA902DA6C2DD0 (key_info), 
-        add constraint FKC05CA902DA6C2DD0 
-        foreign key (key_info) 
-        references j3_key_info (id);
-
-    alter table j3_signature 
-        add index FKC05CA902EF04CFEE (business_key), 
-        add constraint FKC05CA902EF04CFEE 
-        foreign key (business_key) 
-        references j3_business_entity (entity_key);
-
-    alter table j3_signature_transform 
-        add index FK726346F9256790B (reference_key), 
-        add constraint FK726346F9256790B 
-        foreign key (reference_key) 
-        references j3_reference (id);
-
-    alter table j3_signature_transform_data_v 
-        add index FK3242526C7B88B2A4 (signature_transform_key), 
-        add constraint FK3242526C7B88B2A4 
-        foreign key (signature_transform_key) 
-        references j3_signature_transform (id);
-
-    alter table j3_signed_info 
-        add index FKD2E7E5BB877110CC (canonicalization_method), 
-        add constraint FKD2E7E5BB877110CC 
-        foreign key (canonicalization_method) 
-        references j3_canonicalization_method (id);
-
-    alter table j3_signed_info 
-        add index FKD2E7E5BB1A25896 (signature_method), 
-        add constraint FKD2E7E5BB1A25896 
-        foreign key (signature_method) 
-        references j3_signature_method (id);
-
-    alter table j3_subscription_match 
-        add index FK5B9C2F19BEEE42E5 (subscription_key), 
-        add constraint FK5B9C2F19BEEE42E5 
-        foreign key (subscription_key) 
-        references j3_subscription (subscription_key);
-
-    alter table j3_tmodel 
-        add index FK83C8072BD1823CA5 (entity_key), 
-        add constraint FK83C8072BD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity (entity_key);
-
-    alter table j3_tmodel_category_bag 
-        add index FK7E0859DB6A68D45A (id), 
-        add constraint FK7E0859DB6A68D45A 
-        foreign key (id) 
-        references j3_category_bag (id);
-
-    alter table j3_tmodel_category_bag 
-        add index FK7E0859DBC5BF8903 (entity_key), 
-        add constraint FK7E0859DBC5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel (entity_key);
-
-    alter table j3_tmodel_descr 
-        add index FK63DFF1EDC5BF8903 (entity_key), 
-        add constraint FK63DFF1EDC5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel (entity_key);
-
-    alter table j3_tmodel_identifier 
-        add index FKD5FB623DC5BF8903 (entity_key), 
-        add constraint FKD5FB623DC5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel (entity_key);
-
-    alter table j3_tmodel_instance_info 
-        add index FKDC6C9004CFBD88B7 (entity_key), 
-        add constraint FKDC6C9004CFBD88B7 
-        foreign key (entity_key) 
-        references j3_binding_template (entity_key);
-
-    alter table j3_tmodel_instance_info_descr 
-        add index FKD826B4062B115C6F (tmodel_instance_info_id), 
-        add constraint FKD826B4062B115C6F 
-        foreign key (tmodel_instance_info_id) 
-        references j3_tmodel_instance_info (id);
-
-    alter table j3_transfer_token_keys 
-        add index FK8BBF49185ED9DD48 (transfer_token), 
-        add constraint FK8BBF49185ED9DD48 
-        foreign key (transfer_token) 
-        references j3_transfer_token (transfer_token);

http://git-wip-us.apache.org/repos/asf/juddi/blob/432345b0/docs/db/ddl/mysql5InnoDB.ddl
----------------------------------------------------------------------
diff --git a/docs/db/ddl/mysql5InnoDB.ddl b/docs/db/ddl/mysql5InnoDB.ddl
deleted file mode 100644
index 1f62cca..0000000
--- a/docs/db/ddl/mysql5InnoDB.ddl
+++ /dev/null
@@ -1,887 +0,0 @@
-
-    create table j3_address (
-        id bigint not null auto_increment,
-        sort_code varchar(10),
-        tmodel_key varchar(255),
-        use_type varchar(255),
-        address_id bigint not null,
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_address_line (
-        id bigint not null auto_increment,
-        key_name varchar(255),
-        key_value varchar(255),
-        line varchar(80) not null,
-        address_id bigint not null,
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_auth_token (
-        auth_token varchar(51) not null,
-        authorized_name varchar(255) not null,
-        created datetime not null,
-        last_used datetime not null,
-        number_of_uses integer not null,
-        token_state integer not null,
-		ipaddress varchar(51),
-        primary key (auth_token)
-    ) ENGINE=InnoDB;
-
-    create table j3_binding_category_bag (
-        id bigint not null,
-        entity_key varchar(255) not null,
-        primary key (id),
-        unique (entity_key)
-    ) ENGINE=InnoDB;
-
-    create table j3_binding_descr (
-        id bigint not null auto_increment,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        entity_key varchar(255) not null,
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_binding_template (
-        access_point_type varchar(255),
-        access_point_url varchar(4096),
-        hosting_redirector varchar(255),
-        entity_key varchar(255) not null,
-        service_key varchar(255) not null,
-        primary key (entity_key)
-    ) ENGINE=InnoDB;
-
-    create table j3_business_category_bag (
-        id bigint not null,
-        entity_key varchar(255) not null,
-        primary key (id),
-        unique (entity_key)
-    ) ENGINE=InnoDB;
-
-    create table j3_business_descr (
-        id bigint not null auto_increment,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        entity_key varchar(255) not null,
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_business_entity (
-        entity_key varchar(255) not null,
-        primary key (entity_key)
-    ) ENGINE=InnoDB;
-
-    create table j3_business_identifier (
-        id bigint not null auto_increment,
-        key_name varchar(255),
-        key_value varchar(255) not null,
-        tmodel_key_ref varchar(255),
-        entity_key varchar(255) not null,
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_business_name (
-        id bigint not null auto_increment,
-        lang_code varchar(26),
-        name varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_business_service (
-        entity_key varchar(255) not null,
-        business_key varchar(255) not null,
-        primary key (entity_key)
-    ) ENGINE=InnoDB;
-
-    create table j3_canonicalization_method (
-        id bigint not null auto_increment,
-        algorithm varchar(255),
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_category_bag (
-        id bigint not null auto_increment,
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_clerk (
-        clerk_name varchar(255) not null,
-        cred varchar(255),
-        publisher_id varchar(255) not null,
-        node_name varchar(255),
-        primary key (clerk_name)
-    ) ENGINE=InnoDB;
-
-    create table j3_client_subscriptioninfo (
-        subscription_key varchar(255) not null,
-        last_notified datetime,
-        fromClerk_clerk_name varchar(255),
-        toClerk_clerk_name varchar(255),
-        primary key (subscription_key)
-    ) ENGINE=InnoDB;
-
-    create table j3_contact (
-        id bigint not null auto_increment,
-        use_type varchar(255),
-        entity_key varchar(255) not null,
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_contact_descr (
-        id bigint not null auto_increment,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        contact_id bigint not null,
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_discovery_url (
-        id bigint not null auto_increment,
-        url varchar(4096) not null,
-        use_type varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_email (
-        id bigint not null auto_increment,
-        email_address varchar(4096) not null,
-        use_type varchar(255),
-        contact_id bigint not null,
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_instance_details_descr (
-        id bigint not null auto_increment,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        tmodel_instance_info_id bigint not null,
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_instance_details_doc_descr (
-        id bigint not null auto_increment,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        tmodel_instance_info_id bigint not null,
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_key_data_value (
-        id bigint not null auto_increment,
-        key_data_name varchar(255),
-        key_data_type varchar(255),
-        key_data_value longblob,
-        key_data_value_string longtext,
-        key_data_value_key bigint,
-        key_info_key bigint,
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_key_info (
-        id bigint not null auto_increment,
-        xml_id varchar(255),
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_keyed_reference (
-        id bigint not null auto_increment,
-        key_name varchar(255),
-        key_value varchar(255) not null,
-        tmodel_key_ref varchar(255),
-        category_bag_id bigint,
-        keyed_reference_group_id bigint,
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_keyed_reference_group (
-        id bigint not null auto_increment,
-        tmodel_key varchar(255),
-        category_bag_id bigint not null,
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_node (
-        name varchar(255) not null,
-        client_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),
-        proxy_transport varchar(255) not null,
-        publish_url varchar(255) not null,
-        security_url varchar(255) not null,
-        subscription_url varchar(255) not null,
-        primary key (name)
-    ) ENGINE=InnoDB;
-
-    create table j3_object_type (
-        id bigint not null auto_increment,
-        encoding varchar(255),
-        mime_type varchar(255),
-        xml_id varchar(255),
-        signature_key bigint not null,
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_object_type_content (
-        id bigint not null auto_increment,
-        content longblob,
-        object_type_key bigint not null,
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_overview_doc (
-        id bigint not null auto_increment,
-        overview_url varchar(255),
-        overview_url_use_type varchar(255),
-        entity_key varchar(255),
-        tomodel_instance_info_id bigint,
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_overview_doc_descr (
-        id bigint not null auto_increment,
-        descr varchar(1024) not null,
-        lang_code varchar(26),
-        overview_doc_id bigint,
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_person_name (
-        id bigint not null auto_increment,
-        lang_code varchar(26),
-        name varchar(255) not null,
-        contact_id bigint not null,
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_phone (
-        id bigint not null auto_increment,
-        phone_number varchar(50) not null,
-        use_type varchar(255),
-        contact_id bigint not null,
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_publisher (
-        authorized_name varchar(255) not null,
-        email_address varchar(255),
-        is_admin bool,
-        is_enabled bool,
-        max_bindings_per_service integer,
-        max_businesses integer,
-        max_services_per_business integer,
-        max_tmodels integer,
-        publisher_name varchar(255) not null,
-        primary key (authorized_name)
-    ) ENGINE=InnoDB;
-
-    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,
-        primary key (from_key, to_key)
-    ) ENGINE=InnoDB;
-
-    create table j3_reference (
-        id bigint not null auto_increment,
-        digest_method varchar(255),
-        digest_value longblob,
-        type varchar(255),
-        uri varchar(255),
-        xml_id varchar(255),
-        signed_info_key bigint not null,
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_service_category_bag (
-        id bigint not null,
-        entity_key varchar(255) not null,
-        primary key (id),
-        unique (entity_key)
-    ) ENGINE=InnoDB;
-
-    create table j3_service_descr (
-        id bigint not null auto_increment,
-        descr varchar(1024) not null,
-        lang_code varchar(26),
-        entity_key varchar(255) not null,
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_service_name (
-        id bigint not null auto_increment,
-        lang_code varchar(26),
-        name varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_service_projection (
-        business_key varchar(255) not null,
-        service_key varchar(255) not null,
-        primary key (business_key, service_key)
-    ) ENGINE=InnoDB;
-
-    create table j3_signature (
-        id bigint not null auto_increment,
-        xml_id varchar(255),
-        binding_template_key varchar(255),
-        business_key varchar(255),
-        business_service_key varchar(255),
-        key_info bigint not null,
-        publisher_key varchar(255),
-        signature_value bigint not null,
-        signed_info bigint not null,
-        tmodel_key varchar(255),
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_signature_method (
-        id bigint not null auto_increment,
-        algorithm varchar(255),
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_signature_transform (
-        id bigint not null auto_increment,
-        transform varchar(255),
-        reference_key bigint not null,
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_signature_transform_data_v (
-        id bigint not null auto_increment,
-        content_bytes longblob,
-        content_type varchar(255),
-        signature_transform_key bigint not null,
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_signature_value (
-        id bigint not null auto_increment,
-        value_bytes longblob,
-        xml_id varchar(255),
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_signed_info (
-        id bigint not null auto_increment,
-        xml_id varchar(255),
-        canonicalization_method bigint not null,
-        signature_method bigint not null,
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_subscription (
-        subscription_key varchar(255) not null,
-        authorized_name varchar(255) not null,
-        binding_key varchar(255),
-        brief bit,
-        create_date datetime not null,
-        expires_after datetime,
-        last_notified datetime,
-        max_entities integer,
-        notification_interval varchar(255),
-        subscription_filter longtext not null,
-        primary key (subscription_key)
-    ) ENGINE=InnoDB;
-
-    create table j3_subscription_chunk_token (
-        chunk_token varchar(255) not null,
-        data integer not null,
-        end_point datetime,
-        expires_after datetime not null,
-        start_point datetime,
-        subscription_key varchar(255) not null,
-        primary key (chunk_token)
-    ) ENGINE=InnoDB;
-
-    create table j3_subscription_match (
-        id bigint not null auto_increment,
-        entity_key varchar(255) not null,
-        subscription_key varchar(255) not null,
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_temp_key (
-        entity_key varchar(255) not null,
-        tx_id varchar(255) not null,
-        primary key (entity_key, tx_id)
-    ) ENGINE=InnoDB;
-
-    create table j3_tmodel (
-        deleted bit,
-        lang_code varchar(26),
-        name varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (entity_key)
-    ) ENGINE=InnoDB;
-
-    create table j3_tmodel_category_bag (
-        id bigint not null,
-        entity_key varchar(255) not null,
-        primary key (id),
-        unique (entity_key)
-    ) ENGINE=InnoDB;
-
-    create table j3_tmodel_descr (
-        id bigint not null auto_increment,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        entity_key varchar(255) not null,
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_tmodel_identifier (
-        id bigint not null auto_increment,
-        key_name varchar(255),
-        key_value varchar(255) not null,
-        tmodel_key_ref varchar(255),
-        entity_key varchar(255) not null,
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_tmodel_instance_info (
-        id bigint not null auto_increment,
-        instance_parms varchar(8192),
-        tmodel_key varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_tmodel_instance_info_descr (
-        id bigint not null auto_increment,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        tmodel_instance_info_id bigint not null,
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_transfer_token (
-        transfer_token varchar(51) not null,
-        expiration_date datetime not null,
-        primary key (transfer_token)
-    ) ENGINE=InnoDB;
-
-    create table j3_transfer_token_keys (
-        id bigint not null auto_increment,
-        entity_key varchar(255),
-        transfer_token varchar(51) not null,
-        primary key (id)
-    ) ENGINE=InnoDB;
-
-    create table j3_uddi_entity (
-        entity_key varchar(255) not null,
-        authorized_name varchar(255) not null,
-        created datetime,
-        modified datetime not null,
-        modified_including_children datetime,
-        node_id varchar(255),
-        primary key (entity_key)
-    ) ENGINE=InnoDB;
-
-    alter table j3_address 
-        add index FKF83236BE75D860FB (address_id), 
-        add constraint FKF83236BE75D860FB 
-        foreign key (address_id) 
-        references j3_contact (id);
-
-    alter table j3_address_line 
-        add index FKC665B8D5F8B8D8CF (address_id), 
-        add constraint FKC665B8D5F8B8D8CF 
-        foreign key (address_id) 
-        references j3_address (id);
-
-    alter table j3_binding_category_bag 
-        add index FKCF34B2376A68D45A (id), 
-        add constraint FKCF34B2376A68D45A 
-        foreign key (id) 
-        references j3_category_bag (id);
-
-    alter table j3_binding_category_bag 
-        add index FKCF34B237CFBD88B7 (entity_key), 
-        add constraint FKCF34B237CFBD88B7 
-        foreign key (entity_key) 
-        references j3_binding_template (entity_key);
-
-    alter table j3_binding_descr 
-        add index FK5EA60911CFBD88B7 (entity_key), 
-        add constraint FK5EA60911CFBD88B7 
-        foreign key (entity_key) 
-        references j3_binding_template (entity_key);
-
-    alter table j3_binding_template 
-        add index FKD044BD6A2E448F3F (service_key), 
-        add constraint FKD044BD6A2E448F3F 
-        foreign key (service_key) 
-        references j3_business_service (entity_key);
-
-    alter table j3_binding_template 
-        add index FKD044BD6AD1823CA5 (entity_key), 
-        add constraint FKD044BD6AD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity (entity_key);
-
-    alter table j3_business_category_bag 
-        add index FKD6D3ECB06A68D45A (id), 
-        add constraint FKD6D3ECB06A68D45A 
-        foreign key (id) 
-        references j3_category_bag (id);
-
-    alter table j3_business_category_bag 
-        add index FKD6D3ECB0BEB92A91 (entity_key), 
-        add constraint FKD6D3ECB0BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity (entity_key);
-
-    alter table j3_business_descr 
-        add index FK3A24B4B8BEB92A91 (entity_key), 
-        add constraint FK3A24B4B8BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity (entity_key);
-
-    alter table j3_business_entity 
-        add index FKCA61A0CD1823CA5 (entity_key), 
-        add constraint FKCA61A0CD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity (entity_key);
-
-    alter table j3_business_identifier 
-        add index FKB0C7A652BEB92A91 (entity_key), 
-        add constraint FKB0C7A652BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity (entity_key);
-
-    alter table j3_business_name 
-        add index FK43F526F4BEB92A91 (entity_key), 
-        add constraint FK43F526F4BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity (entity_key);
-
-    alter table j3_business_service 
-        add index FK5D4255ACD1823CA5 (entity_key), 
-        add constraint FK5D4255ACD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity (entity_key);
-
-    alter table j3_business_service 
-        add index FK5D4255ACEF04CFEE (business_key), 
-        add constraint FK5D4255ACEF04CFEE 
-        foreign key (business_key) 
-        references j3_business_entity (entity_key);
-
-    alter table j3_clerk 
-        add index FK34DC7D9F6BB0F935 (node_name), 
-        add constraint FK34DC7D9F6BB0F935 
-        foreign key (node_name) 
-        references j3_node (name);
-
-    alter table j3_client_subscriptioninfo 
-        add index FKDF04CC095BFC6733 (fromClerk_clerk_name), 
-        add constraint FKDF04CC095BFC6733 
-        foreign key (fromClerk_clerk_name) 
-        references j3_clerk (clerk_name);
-
-    alter table j3_client_subscriptioninfo 
-        add index FKDF04CC09F3CE9C04 (toClerk_clerk_name), 
-        add constraint FKDF04CC09F3CE9C04 
-        foreign key (toClerk_clerk_name) 
-        references j3_clerk (clerk_name);
-
-    alter table j3_contact 
-        add index FK7551BEEABEB92A91 (entity_key), 
-        add constraint FK7551BEEABEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity (entity_key);
-
-    alter table j3_contact_descr 
-        add index FK56CA9E6C2E3FD94F (contact_id), 
-        add constraint FK56CA9E6C2E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact (id);
-
-    alter table j3_discovery_url 
-        add index FKA042FDAABEB92A91 (entity_key), 
-        add constraint FKA042FDAABEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity (entity_key);
-
-    alter table j3_email 
-        add index FK34F910E62E3FD94F (contact_id), 
-        add constraint FK34F910E62E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact (id);
-
-    alter table j3_instance_details_descr 
-        add index FK3CC165902B115C6F (tmodel_instance_info_id), 
-        add constraint FK3CC165902B115C6F 
-        foreign key (tmodel_instance_info_id) 
-        references j3_tmodel_instance_info (id);
-
-    alter table j3_instance_details_doc_descr 
-        add index FK447324492B115C6F (tmodel_instance_info_id), 
-        add constraint FK447324492B115C6F 
-        foreign key (tmodel_instance_info_id) 
-        references j3_tmodel_instance_info (id);
-
-    alter table j3_key_data_value 
-        add index FK74B7E072843143EF (key_data_value_key), 
-        add constraint FK74B7E072843143EF 
-        foreign key (key_data_value_key) 
-        references j3_key_data_value (id);
-
-    alter table j3_key_data_value 
-        add index FK74B7E07238C90470 (key_info_key), 
-        add constraint FK74B7E07238C90470 
-        foreign key (key_info_key) 
-        references j3_key_info (id);
-
-    alter table j3_keyed_reference 
-        add index FK350C8454E075C8D7 (keyed_reference_group_id), 
-        add constraint FK350C8454E075C8D7 
-        foreign key (keyed_reference_group_id) 
-        references j3_keyed_reference_group (id);
-
-    alter table j3_keyed_reference 
-        add index FK350C84541DB72652 (category_bag_id), 
-        add constraint FK350C84541DB72652 
-        foreign key (category_bag_id) 
-        references j3_category_bag (id);
-
-    alter table j3_keyed_reference_group 
-        add index FKF6224ED41DB72652 (category_bag_id), 
-        add constraint FKF6224ED41DB72652 
-        foreign key (category_bag_id) 
-        references j3_category_bag (id);
-
-    alter table j3_object_type 
-        add index FK98BBFA04BC6AD65 (signature_key), 
-        add constraint FK98BBFA04BC6AD65 
-        foreign key (signature_key) 
-        references j3_signature (id);
-
-    alter table j3_object_type_content 
-        add index FK987A913E71FA643E (object_type_key), 
-        add constraint FK987A913E71FA643E 
-        foreign key (object_type_key) 
-        references j3_object_type (id);
-
-    alter table j3_overview_doc 
-        add index FK5CD8D0E8C5BF8903 (entity_key), 
-        add constraint FK5CD8D0E8C5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel (entity_key);
-
-    alter table j3_overview_doc 
-        add index FK5CD8D0E8E8CE1B36 (tomodel_instance_info_id), 
-        add constraint FK5CD8D0E8E8CE1B36 
-        foreign key (tomodel_instance_info_id) 
-        references j3_tmodel_instance_info (id);
-
-    alter table j3_overview_doc_descr 
-        add index FK36FB9EA9BDC711C (overview_doc_id), 
-        add constraint FK36FB9EA9BDC711C 
-        foreign key (overview_doc_id) 
-        references j3_overview_doc (id);
-
-    alter table j3_person_name 
-        add index FKCB7B8AFF2E3FD94F (contact_id), 
-        add constraint FKCB7B8AFF2E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact (id);
-
-    alter table j3_phone 
-        add index FK359202B82E3FD94F (contact_id), 
-        add constraint FK359202B82E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact (id);
-
-    alter table j3_publisher_assertion 
-        add index FK8A102449E3544929 (to_key), 
-        add constraint FK8A102449E3544929 
-        foreign key (to_key) 
-        references j3_business_entity (entity_key);
-
-    alter table j3_publisher_assertion 
-        add index FK8A102449CCEE22D8 (from_key), 
-        add constraint FK8A102449CCEE22D8 
-        foreign key (from_key) 
-        references j3_business_entity (entity_key);
-
-    alter table j3_reference 
-        add index FK493A4F951E480746 (signed_info_key), 
-        add constraint FK493A4F951E480746 
-        foreign key (signed_info_key) 
-        references j3_signed_info (id);
-
-    alter table j3_service_category_bag 
-        add index FK185A68076A68D45A (id), 
-        add constraint FK185A68076A68D45A 
-        foreign key (id) 
-        references j3_category_bag (id);
-
-    alter table j3_service_category_bag 
-        add index FK185A680748D0656D (entity_key), 
-        add constraint FK185A680748D0656D 
-        foreign key (entity_key) 
-        references j3_business_service (entity_key);
-
-    alter table j3_service_descr 
-        add index FKB6D63D4148D0656D (entity_key), 
-        add constraint FKB6D63D4148D0656D 
-        foreign key (entity_key) 
-        references j3_business_service (entity_key);
-
-    alter table j3_service_name 
-        add index FKCC1BE94B48D0656D (entity_key), 
-        add constraint FKCC1BE94B48D0656D 
-        foreign key (entity_key) 
-        references j3_business_service (entity_key);
-
-    alter table j3_service_projection 
-        add index FK629F290F2E448F3F (service_key), 
-        add constraint FK629F290F2E448F3F 
-        foreign key (service_key) 
-        references j3_business_service (entity_key);
-
-    alter table j3_service_projection 
-        add index FK629F290FEF04CFEE (business_key), 
-        add constraint FK629F290FEF04CFEE 
-        foreign key (business_key) 
-        references j3_business_entity (entity_key);
-
-    alter table j3_signature 
-        add index FKC05CA90256E87DED (publisher_key), 
-        add constraint FKC05CA90256E87DED 
-        foreign key (publisher_key) 
-        references j3_publisher (authorized_name);
-
-    alter table j3_signature 
-        add index FKC05CA90271CD8948 (binding_template_key), 
-        add constraint FKC05CA90271CD8948 
-        foreign key (binding_template_key) 
-        references j3_binding_template (entity_key);
-
-    alter table j3_signature 
-        add index FKC05CA90212F40D40 (business_service_key), 
-        add constraint FKC05CA90212F40D40 
-        foreign key (business_service_key) 
-        references j3_business_service (entity_key);
-
-    alter table j3_signature 
-        add index FKC05CA9028ACE9A26 (signed_info), 
-        add constraint FKC05CA9028ACE9A26 
-        foreign key (signed_info) 
-        references j3_signed_info (id);
-
-    alter table j3_signature 
-        add index FKC05CA9027CE6418E (signature_value), 
-        add constraint FKC05CA9027CE6418E 
-        foreign key (signature_value) 
-        references j3_signature_value (id);
-
-    alter table j3_signature 
-        add index FKC05CA9025793CF55 (tmodel_key), 
-        add constraint FKC05CA9025793CF55 
-        foreign key (tmodel_key) 
-        references j3_tmodel (entity_key);
-
-    alter table j3_signature 
-        add index FKC05CA902DA6C2DD0 (key_info), 
-        add constraint FKC05CA902DA6C2DD0 
-        foreign key (key_info) 
-        references j3_key_info (id);
-
-    alter table j3_signature 
-        add index FKC05CA902EF04CFEE (business_key), 
-        add constraint FKC05CA902EF04CFEE 
-        foreign key (business_key) 
-        references j3_business_entity (entity_key);
-
-    alter table j3_signature_transform 
-        add index FK726346F9256790B (reference_key), 
-        add constraint FK726346F9256790B 
-        foreign key (reference_key) 
-        references j3_reference (id);
-
-    alter table j3_signature_transform_data_v 
-        add index FK3242526C7B88B2A4 (signature_transform_key), 
-        add constraint FK3242526C7B88B2A4 
-        foreign key (signature_transform_key) 
-        references j3_signature_transform (id);
-
-    alter table j3_signed_info 
-        add index FKD2E7E5BB877110CC (canonicalization_method), 
-        add constraint FKD2E7E5BB877110CC 
-        foreign key (canonicalization_method) 
-        references j3_canonicalization_method (id);
-
-    alter table j3_signed_info 
-        add index FKD2E7E5BB1A25896 (signature_method), 
-        add constraint FKD2E7E5BB1A25896 
-        foreign key (signature_method) 
-        references j3_signature_method (id);
-
-    alter table j3_subscription_match 
-        add index FK5B9C2F19BEEE42E5 (subscription_key), 
-        add constraint FK5B9C2F19BEEE42E5 
-        foreign key (subscription_key) 
-        references j3_subscription (subscription_key);
-
-    alter table j3_tmodel 
-        add index FK83C8072BD1823CA5 (entity_key), 
-        add constraint FK83C8072BD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity (entity_key);
-
-    alter table j3_tmodel_category_bag 
-        add index FK7E0859DB6A68D45A (id), 
-        add constraint FK7E0859DB6A68D45A 
-        foreign key (id) 
-        references j3_category_bag (id);
-
-    alter table j3_tmodel_category_bag 
-        add index FK7E0859DBC5BF8903 (entity_key), 
-        add constraint FK7E0859DBC5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel (entity_key);
-
-    alter table j3_tmodel_descr 
-        add index FK63DFF1EDC5BF8903 (entity_key), 
-        add constraint FK63DFF1EDC5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel (entity_key);
-
-    alter table j3_tmodel_identifier 
-        add index FKD5FB623DC5BF8903 (entity_key), 
-        add constraint FKD5FB623DC5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel (entity_key);
-
-    alter table j3_tmodel_instance_info 
-        add index FKDC6C9004CFBD88B7 (entity_key), 
-        add constraint FKDC6C9004CFBD88B7 
-        foreign key (entity_key) 
-        references j3_binding_template (entity_key);
-
-    alter table j3_tmodel_instance_info_descr 
-        add index FKD826B4062B115C6F (tmodel_instance_info_id), 
-        add constraint FKD826B4062B115C6F 
-        foreign key (tmodel_instance_info_id) 
-        references j3_tmodel_instance_info (id);
-
-    alter table j3_transfer_token_keys 
-        add index FK8BBF49185ED9DD48 (transfer_token), 
-        add constraint FK8BBF49185ED9DD48 
-        foreign key (transfer_token) 
-        references j3_transfer_token (transfer_token);

http://git-wip-us.apache.org/repos/asf/juddi/blob/432345b0/docs/db/ddl/oracle9.ddl
----------------------------------------------------------------------
diff --git a/docs/db/ddl/oracle9.ddl b/docs/db/ddl/oracle9.ddl
deleted file mode 100644
index 758d7b0..0000000
--- a/docs/db/ddl/oracle9.ddl
+++ /dev/null
@@ -1,825 +0,0 @@
-
-    create table j3_address (
-        id number(19,0) not null,
-        sort_code varchar2(10 char),
-        tmodel_key varchar2(255 char),
-        use_type varchar2(255 char),
-        address_id number(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_address_line (
-        id number(19,0) not null,
-        key_name varchar2(255 char),
-        key_value varchar2(255 char),
-        line varchar2(80 char) not null,
-        address_id number(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_auth_token (
-        auth_token varchar2(51 char) not null,
-        authorized_name varchar2(255 char) not null,
-        created timestamp not null,
-        last_used timestamp not null,
-        number_of_uses number(10,0) not null,
-        token_state number(10,0) not null,
-		ipaddress varchar2(51),
-        primary key (auth_token)
-    );
-
-    create table j3_binding_category_bag (
-        id number(19,0) not null,
-        entity_key varchar2(255 char) not null,
-        primary key (id),
-        unique (entity_key)
-    );
-
-    create table j3_binding_descr (
-        id number(19,0) not null,
-        descr varchar2(255 char) not null,
-        lang_code varchar2(26 char),
-        entity_key varchar2(255 char) not null,
-        primary key (id)
-    );
-
-    create table j3_binding_template (
-        access_point_type varchar2(255 char),
-        access_point_url long,
-        hosting_redirector varchar2(255 char),
-        entity_key varchar2(255 char) not null,
-        service_key varchar2(255 char) not null,
-        primary key (entity_key)
-    );
-
-    create table j3_business_category_bag (
-        id number(19,0) not null,
-        entity_key varchar2(255 char) not null,
-        primary key (id),
-        unique (entity_key)
-    );
-
-    create table j3_business_descr (
-        id number(19,0) not null,
-        descr varchar2(255 char) not null,
-        lang_code varchar2(26 char),
-        entity_key varchar2(255 char) not null,
-        primary key (id)
-    );
-
-    create table j3_business_entity (
-        entity_key varchar2(255 char) not null,
-        primary key (entity_key)
-    );
-
-    create table j3_business_identifier (
-        id number(19,0) not null,
-        key_name varchar2(255 char),
-        key_value varchar2(255 char) not null,
-        tmodel_key_ref varchar2(255 char),
-        entity_key varchar2(255 char) not null,
-        primary key (id)
-    );
-
-    create table j3_business_name (
-        id number(19,0) not null,
-        lang_code varchar2(26 char),
-        name varchar2(255 char) not null,
-        entity_key varchar2(255 char) not null,
-        primary key (id)
-    );
-
-    create table j3_business_service (
-        entity_key varchar2(255 char) not null,
-        business_key varchar2(255 char) not null,
-        primary key (entity_key)
-    );
-
-    create table j3_canonicalization_method (
-        id number(19,0) not null,
-        algorithm varchar2(255 char),
-        primary key (id)
-    );
-
-    create table j3_category_bag (
-        id number(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_clerk (
-        clerk_name varchar2(255 char) not null,
-        cred varchar2(255 char),
-        publisher_id varchar2(255 char) not null,
-        node_name varchar2(255 char),
-        primary key (clerk_name)
-    );
-
-    create table j3_client_subscriptioninfo (
-        subscription_key varchar2(255 char) not null,
-        last_notified timestamp,
-        fromClerk_clerk_name varchar2(255 char),
-        toClerk_clerk_name varchar2(255 char),
-        primary key (subscription_key)
-    );
-
-    create table j3_contact (
-        id number(19,0) not null,
-        use_type varchar2(255 char),
-        entity_key varchar2(255 char) not null,
-        primary key (id)
-    );
-
-    create table j3_contact_descr (
-        id number(19,0) not null,
-        descr varchar2(255 char) not null,
-        lang_code varchar2(26 char),
-        contact_id number(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_discovery_url (
-        id number(19,0) not null,
-        url long not null,
-        use_type varchar2(255 char) not null,
-        entity_key varchar2(255 char) not null,
-        primary key (id)
-    );
-
-    create table j3_email (
-        id number(19,0) not null,
-        email_address long not null,
-        use_type varchar2(255 char),
-        contact_id number(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_instance_details_descr (
-        id number(19,0) not null,
-        descr varchar2(255 char) not null,
-        lang_code varchar2(26 char),
-        tmodel_instance_info_id number(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_instance_details_doc_descr (
-        id number(19,0) not null,
-        descr varchar2(255 char) not null,
-        lang_code varchar2(26 char),
-        tmodel_instance_info_id number(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_key_data_value (
-        id number(19,0) not null,
-        key_data_name varchar2(255 char),
-        key_data_type varchar2(255 char),
-        key_data_value blob,
-        key_data_value_string clob,
-        key_data_value_key number(19,0),
-        key_info_key number(19,0),
-        primary key (id)
-    );
-
-    create table j3_key_info (
-        id number(19,0) not null,
-        xml_id varchar2(255 char),
-        primary key (id)
-    );
-
-    create table j3_keyed_reference (
-        id number(19,0) not null,
-        key_name varchar2(255 char),
-        key_value varchar2(255 char) not null,
-        tmodel_key_ref varchar2(255 char),
-        category_bag_id number(19,0),
-        keyed_reference_group_id number(19,0),
-        primary key (id)
-    );
-
-    create table j3_keyed_reference_group (
-        id number(19,0) not null,
-        tmodel_key varchar2(255 char),
-        category_bag_id number(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_node (
-        name varchar2(255 char) not null,
-        client_name varchar2(255 char) not null,
-        custody_transfer_url varchar2(255 char) not null,
-        factory_initial varchar2(255 char),
-        factory_naming_provider varchar2(255 char),
-        factory_url_pkgs varchar2(255 char),
-        inquiry_url varchar2(255 char) not null,
-        juddi_api_url varchar2(255 char),
-        proxy_transport varchar2(255 char) not null,
-        publish_url varchar2(255 char) not null,
-        security_url varchar2(255 char) not null,
-        subscription_url varchar2(255 char) not null,
-        primary key (name)
-    );
-
-    create table j3_object_type (
-        id number(19,0) not null,
-        encoding varchar2(255 char),
-        mime_type varchar2(255 char),
-        xml_id varchar2(255 char),
-        signature_key number(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_object_type_content (
-        id number(19,0) not null,
-        content blob,
-        object_type_key number(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_overview_doc (
-        id number(19,0) not null,
-        overview_url varchar2(255 char),
-        overview_url_use_type varchar2(255 char),
-        entity_key varchar2(255 char),
-        tomodel_instance_info_id number(19,0),
-        primary key (id)
-    );
-
-    create table j3_overview_doc_descr (
-        id number(19,0) not null,
-        descr varchar2(1024 char) not null,
-        lang_code varchar2(26 char),
-        overview_doc_id number(19,0),
-        primary key (id)
-    );
-
-    create table j3_person_name (
-        id number(19,0) not null,
-        lang_code varchar2(26 char),
-        name varchar2(255 char) not null,
-        contact_id number(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_phone (
-        id number(19,0) not null,
-        phone_number varchar2(50 char) not null,
-        use_type varchar2(255 char),
-        contact_id number(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_publisher (
-        authorized_name varchar2(255 char) not null,
-        email_address varchar2(255 char),
-        is_admin bool,
-        is_enabled bool,
-        max_bindings_per_service number(10,0),
-        max_businesses number(10,0),
-        max_services_per_business number(10,0),
-        max_tmodels number(10,0),
-        publisher_name varchar2(255 char) not null,
-        primary key (authorized_name)
-    );
-
-    create table j3_publisher_assertion (
-        from_key varchar2(255 char) not null,
-        to_key varchar2(255 char) not null,
-        from_check varchar2(5 char) not null,
-        key_name varchar2(255 char) not null,
-        key_value varchar2(255 char) not null,
-        tmodel_key varchar2(255 char) not null,
-        to_check varchar2(5 char) not null,
-        primary key (from_key, to_key)
-    );
-
-    create table j3_reference (
-        id number(19,0) not null,
-        digest_method varchar2(255 char),
-        digest_value blob,
-        type varchar2(255 char),
-        uri varchar2(255 char),
-        xml_id varchar2(255 char),
-        signed_info_key number(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_service_category_bag (
-        id number(19,0) not null,
-        entity_key varchar2(255 char) not null,
-        primary key (id),
-        unique (entity_key)
-    );
-
-    create table j3_service_descr (
-        id number(19,0) not null,
-        descr varchar2(1024 char) not null,
-        lang_code varchar2(26 char),
-        entity_key varchar2(255 char) not null,
-        primary key (id)
-    );
-
-    create table j3_service_name (
-        id number(19,0) not null,
-        lang_code varchar2(26 char),
-        name varchar2(255 char) not null,
-        entity_key varchar2(255 char) not null,
-        primary key (id)
-    );
-
-    create table j3_service_projection (
-        business_key varchar2(255 char) not null,
-        service_key varchar2(255 char) not null,
-        primary key (business_key, service_key)
-    );
-
-    create table j3_signature (
-        id number(19,0) not null,
-        xml_id varchar2(255 char),
-        binding_template_key varchar2(255 char),
-        business_key varchar2(255 char),
-        business_service_key varchar2(255 char),
-        key_info number(19,0) not null,
-        publisher_key varchar2(255 char),
-        signature_value number(19,0) not null,
-        signed_info number(19,0) not null,
-        tmodel_key varchar2(255 char),
-        primary key (id)
-    );
-
-    create table j3_signature_method (
-        id number(19,0) not null,
-        algorithm varchar2(255 char),
-        primary key (id)
-    );
-
-    create table j3_signature_transform (
-        id number(19,0) not null,
-        transform varchar2(255 char),
-        reference_key number(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_signature_transform_data_v (
-        id number(19,0) not null,
-        content_bytes blob,
-        content_type varchar2(255 char),
-        signature_transform_key number(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_signature_value (
-        id number(19,0) not null,
-        value_bytes blob,
-        xml_id varchar2(255 char),
-        primary key (id)
-    );
-
-    create table j3_signed_info (
-        id number(19,0) not null,
-        xml_id varchar2(255 char),
-        canonicalization_method number(19,0) not null,
-        signature_method number(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_subscription (
-        subscription_key varchar2(255 char) not null,
-        authorized_name varchar2(255 char) not null,
-        binding_key varchar2(255 char),
-        brief number(1,0),
-        create_date timestamp not null,
-        expires_after timestamp,
-        last_notified timestamp,
-        max_entities number(10,0),
-        notification_interval varchar2(255 char),
-        subscription_filter clob not null,
-        primary key (subscription_key)
-    );
-
-    create table j3_subscription_chunk_token (
-        chunk_token varchar2(255 char) not null,
-        data number(10,0) not null,
-        end_point timestamp,
-        expires_after timestamp not null,
-        start_point timestamp,
-        subscription_key varchar2(255 char) not null,
-        primary key (chunk_token)
-    );
-
-    create table j3_subscription_match (
-        id number(19,0) not null,
-        entity_key varchar2(255 char) not null,
-        subscription_key varchar2(255 char) not null,
-        primary key (id)
-    );
-
-    create table j3_temp_key (
-        entity_key varchar2(255 char) not null,
-        tx_id varchar2(255 char) not null,
-        primary key (entity_key, tx_id)
-    );
-
-    create table j3_tmodel (
-        deleted number(1,0),
-        lang_code varchar2(26 char),
-        name varchar2(255 char) not null,
-        entity_key varchar2(255 char) not null,
-        primary key (entity_key)
-    );
-
-    create table j3_tmodel_category_bag (
-        id number(19,0) not null,
-        entity_key varchar2(255 char) not null,
-        primary key (id),
-        unique (entity_key)
-    );
-
-    create table j3_tmodel_descr (
-        id number(19,0) not null,
-        descr varchar2(255 char) not null,
-        lang_code varchar2(26 char),
-        entity_key varchar2(255 char) not null,
-        primary key (id)
-    );
-
-    create table j3_tmodel_identifier (
-        id number(19,0) not null,
-        key_name varchar2(255 char),
-        key_value varchar2(255 char) not null,
-        tmodel_key_ref varchar2(255 char),
-        entity_key varchar2(255 char) not null,
-        primary key (id)
-    );
-
-    create table j3_tmodel_instance_info (
-        id number(19,0) not null,
-        instance_parms long,
-        tmodel_key varchar2(255 char) not null,
-        entity_key varchar2(255 char) not null,
-        primary key (id)
-    );
-
-    create table j3_tmodel_instance_info_descr (
-        id number(19,0) not null,
-        descr varchar2(255 char) not null,
-        lang_code varchar2(26 char),
-        tmodel_instance_info_id number(19,0) not null,
-        primary key (id)
-    );
-
-    create table j3_transfer_token (
-        transfer_token varchar2(51 char) not null,
-        expiration_date timestamp not null,
-        primary key (transfer_token)
-    );
-
-    create table j3_transfer_token_keys (
-        id number(19,0) not null,
-        entity_key varchar2(255 char),
-        transfer_token varchar2(51 char) not null,
-        primary key (id)
-    );
-
-    create table j3_uddi_entity (
-        entity_key varchar2(255 char) not null,
-        authorized_name varchar2(255 char) not null,
-        created timestamp,
-        modified timestamp not null,
-        modified_including_children timestamp,
-        node_id varchar2(255 char),
-        primary key (entity_key)
-    );
-
-    alter table j3_address 
-        add constraint FKF83236BE75D860FB 
-        foreign key (address_id) 
-        references j3_contact;
-
-    alter table j3_address_line 
-        add constraint FKC665B8D5F8B8D8CF 
-        foreign key (address_id) 
-        references j3_address;
-
-    alter table j3_binding_category_bag 
-        add constraint FKCF34B2376A68D45A 
-        foreign key (id) 
-        references j3_category_bag;
-
-    alter table j3_binding_category_bag 
-        add constraint FKCF34B237CFBD88B7 
-        foreign key (entity_key) 
-        references j3_binding_template;
-
-    alter table j3_binding_descr 
-        add constraint FK5EA60911CFBD88B7 
-        foreign key (entity_key) 
-        references j3_binding_template;
-
-    alter table j3_binding_template 
-        add constraint FKD044BD6A2E448F3F 
-        foreign key (service_key) 
-        references j3_business_service;
-
-    alter table j3_binding_template 
-        add constraint FKD044BD6AD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity;
-
-    alter table j3_business_category_bag 
-        add constraint FKD6D3ECB06A68D45A 
-        foreign key (id) 
-        references j3_category_bag;
-
-    alter table j3_business_category_bag 
-        add constraint FKD6D3ECB0BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_business_descr 
-        add constraint FK3A24B4B8BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_business_entity 
-        add constraint FKCA61A0CD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity;
-
-    alter table j3_business_identifier 
-        add constraint FKB0C7A652BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_business_name 
-        add constraint FK43F526F4BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_business_service 
-        add constraint FK5D4255ACD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity;
-
-    alter table j3_business_service 
-        add constraint FK5D4255ACEF04CFEE 
-        foreign key (business_key) 
-        references j3_business_entity;
-
-    alter table j3_clerk 
-        add constraint FK34DC7D9F6BB0F935 
-        foreign key (node_name) 
-        references j3_node;
-
-    alter table j3_client_subscriptioninfo 
-        add constraint FKDF04CC095BFC6733 
-        foreign key (fromClerk_clerk_name) 
-        references j3_clerk;
-
-    alter table j3_client_subscriptioninfo 
-        add constraint FKDF04CC09F3CE9C04 
-        foreign key (toClerk_clerk_name) 
-        references j3_clerk;
-
-    alter table j3_contact 
-        add constraint FK7551BEEABEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_contact_descr 
-        add constraint FK56CA9E6C2E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact;
-
-    alter table j3_discovery_url 
-        add constraint FKA042FDAABEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_email 
-        add constraint FK34F910E62E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact;
-
-    alter table j3_instance_details_descr 
-        add constraint FK3CC165902B115C6F 
-        foreign key (tmodel_instance_info_id) 
-        references j3_tmodel_instance_info;
-
-    alter table j3_instance_details_doc_descr 
-        add constraint FK447324492B115C6F 
-        foreign key (tmodel_instance_info_id) 
-        references j3_tmodel_instance_info;
-
-    alter table j3_key_data_value 
-        add constraint FK74B7E072843143EF 
-        foreign key (key_data_value_key) 
-        references j3_key_data_value;
-
-    alter table j3_key_data_value 
-        add constraint FK74B7E07238C90470 
-        foreign key (key_info_key) 
-        references j3_key_info;
-
-    alter table j3_keyed_reference 
-        add constraint FK350C8454E075C8D7 
-        foreign key (keyed_reference_group_id) 
-        references j3_keyed_reference_group;
-
-    alter table j3_keyed_reference 
-        add constraint FK350C84541DB72652 
-        foreign key (category_bag_id) 
-        references j3_category_bag;
-
-    alter table j3_keyed_reference_group 
-        add constraint FKF6224ED41DB72652 
-        foreign key (category_bag_id) 
-        references j3_category_bag;
-
-    alter table j3_object_type 
-        add constraint FK98BBFA04BC6AD65 
-        foreign key (signature_key) 
-        references j3_signature;
-
-    alter table j3_object_type_content 
-        add constraint FK987A913E71FA643E 
-        foreign key (object_type_key) 
-        references j3_object_type;
-
-    alter table j3_overview_doc 
-        add constraint FK5CD8D0E8C5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel;
-
-    alter table j3_overview_doc 
-        add constraint FK5CD8D0E8E8CE1B36 
-        foreign key (tomodel_instance_info_id) 
-        references j3_tmodel_instance_info;
-
-    alter table j3_overview_doc_descr 
-        add constraint FK36FB9EA9BDC711C 
-        foreign key (overview_doc_id) 
-        references j3_overview_doc;
-
-    alter table j3_person_name 
-        add constraint FKCB7B8AFF2E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact;
-
-    alter table j3_phone 
-        add constraint FK359202B82E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact;
-
-    alter table j3_publisher_assertion 
-        add constraint FK8A102449E3544929 
-        foreign key (to_key) 
-        references j3_business_entity;
-
-    alter table j3_publisher_assertion 
-        add constraint FK8A102449CCEE22D8 
-        foreign key (from_key) 
-        references j3_business_entity;
-
-    alter table j3_reference 
-        add constraint FK493A4F951E480746 
-        foreign key (signed_info_key) 
-        references j3_signed_info;
-
-    alter table j3_service_category_bag 
-        add constraint FK185A68076A68D45A 
-        foreign key (id) 
-        references j3_category_bag;
-
-    alter table j3_service_category_bag 
-        add constraint FK185A680748D0656D 
-        foreign key (entity_key) 
-        references j3_business_service;
-
-    alter table j3_service_descr 
-        add constraint FKB6D63D4148D0656D 
-        foreign key (entity_key) 
-        references j3_business_service;
-
-    alter table j3_service_name 
-        add constraint FKCC1BE94B48D0656D 
-        foreign key (entity_key) 
-        references j3_business_service;
-
-    alter table j3_service_projection 
-        add constraint FK629F290F2E448F3F 
-        foreign key (service_key) 
-        references j3_business_service;
-
-    alter table j3_service_projection 
-        add constraint FK629F290FEF04CFEE 
-        foreign key (business_key) 
-        references j3_business_entity;
-
-    alter table j3_signature 
-        add constraint FKC05CA90256E87DED 
-        foreign key (publisher_key) 
-        references j3_publisher;
-
-    alter table j3_signature 
-        add constraint FKC05CA90271CD8948 
-        foreign key (binding_template_key) 
-        references j3_binding_template;
-
-    alter table j3_signature 
-        add constraint FKC05CA90212F40D40 
-        foreign key (business_service_key) 
-        references j3_business_service;
-
-    alter table j3_signature 
-        add constraint FKC05CA9028ACE9A26 
-        foreign key (signed_info) 
-        references j3_signed_info;
-
-    alter table j3_signature 
-        add constraint FKC05CA9027CE6418E 
-        foreign key (signature_value) 
-        references j3_signature_value;
-
-    alter table j3_signature 
-        add constraint FKC05CA9025793CF55 
-        foreign key (tmodel_key) 
-        references j3_tmodel;
-
-    alter table j3_signature 
-        add constraint FKC05CA902DA6C2DD0 
-        foreign key (key_info) 
-        references j3_key_info;
-
-    alter table j3_signature 
-        add constraint FKC05CA902EF04CFEE 
-        foreign key (business_key) 
-        references j3_business_entity;
-
-    alter table j3_signature_transform 
-        add constraint FK726346F9256790B 
-        foreign key (reference_key) 
-        references j3_reference;
-
-    alter table j3_signature_transform_data_v 
-        add constraint FK3242526C7B88B2A4 
-        foreign key (signature_transform_key) 
-        references j3_signature_transform;
-
-    alter table j3_signed_info 
-        add constraint FKD2E7E5BB877110CC 
-        foreign key (canonicalization_method) 
-        references j3_canonicalization_method;
-
-    alter table j3_signed_info 
-        add constraint FKD2E7E5BB1A25896 
-        foreign key (signature_method) 
-        references j3_signature_method;
-
-    alter table j3_subscription_match 
-        add constraint FK5B9C2F19BEEE42E5 
-        foreign key (subscription_key) 
-        references j3_subscription;
-
-    alter table j3_tmodel 
-        add constraint FK83C8072BD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity;
-
-    alter table j3_tmodel_category_bag 
-        add constraint FK7E0859DB6A68D45A 
-        foreign key (id) 
-        references j3_category_bag;
-
-    alter table j3_tmodel_category_bag 
-        add constraint FK7E0859DBC5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel;
-
-    alter table j3_tmodel_descr 
-        add constraint FK63DFF1EDC5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel;
-
-    alter table j3_tmodel_identifier 
-        add constraint FKD5FB623DC5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel;
-
-    alter table j3_tmodel_instance_info 
-        add constraint FKDC6C9004CFBD88B7 
-        foreign key (entity_key) 
-        references j3_binding_template;
-
-    alter table j3_tmodel_instance_info_descr 
-        add constraint FKD826B4062B115C6F 
-        foreign key (tmodel_instance_info_id) 
-        references j3_tmodel_instance_info;
-
-    alter table j3_transfer_token_keys 
-        add constraint FK8BBF49185ED9DD48 
-        foreign key (transfer_token) 
-        references j3_transfer_token;
-
-    create sequence hibernate_sequence;
-
-    create sequence juddi_sequence;


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@juddi.apache.org
For additional commands, e-mail: commits-help@juddi.apache.org


[4/4] git commit: JUDDI-876 resolved

Posted by al...@apache.org.
JUDDI-876 resolved


Project: http://git-wip-us.apache.org/repos/asf/juddi/repo
Commit: http://git-wip-us.apache.org/repos/asf/juddi/commit/432345b0
Tree: http://git-wip-us.apache.org/repos/asf/juddi/tree/432345b0
Diff: http://git-wip-us.apache.org/repos/asf/juddi/diff/432345b0

Branch: refs/heads/master
Commit: 432345b088cf03ebb532411b88768f1b73bd92ad
Parents: 737f293
Author: alexoree <al...@apache.org>
Authored: Fri Mar 14 18:50:51 2014 -0400
Committer: alexoree <al...@apache.org>
Committed: Fri Mar 14 18:50:51 2014 -0400

----------------------------------------------------------------------
 docs/db/ddl/README.txt                          |   2 +
 docs/db/ddl/db2.ddl                             | 821 -----------------
 docs/db/ddl/derby.ddl                           | 827 -----------------
 docs/db/ddl/mysql.ddl                           | 887 -------------------
 docs/db/ddl/mysql5.ddl                          | 887 -------------------
 docs/db/ddl/mysql5InnoDB.ddl                    | 887 -------------------
 docs/db/ddl/oracle9.ddl                         | 825 -----------------
 docs/db/ddl/postgres.ddl                        | 825 -----------------
 docs/db/ddl/sqlserver.ddl                       | 821 -----------------
 docs/db/ddl/sybase.ddl                          | 821 -----------------
 juddi-ddl-generator/pom.xml                     |  98 ++
 .../org/apache/juddi/ddl/generator/App.java     | 247 ++++++
 .../org/apache/juddi/ddl/generator/AppTest.java |  13 +
 pom.xml                                         |   2 +
 14 files changed, 362 insertions(+), 7601 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/juddi/blob/432345b0/docs/db/ddl/README.txt
----------------------------------------------------------------------
diff --git a/docs/db/ddl/README.txt b/docs/db/ddl/README.txt
index a3093d8..d9ba34b 100644
--- a/docs/db/ddl/README.txt
+++ b/docs/db/ddl/README.txt
@@ -35,3 +35,5 @@ Sybase11Dialect
 
 
 
+Since 3.2.1, these files are now no longer included in the source distribution.
+Why? because we now include DDL generation in the build process
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/juddi/blob/432345b0/docs/db/ddl/db2.ddl
----------------------------------------------------------------------
diff --git a/docs/db/ddl/db2.ddl b/docs/db/ddl/db2.ddl
deleted file mode 100644
index 32c49b9..0000000
--- a/docs/db/ddl/db2.ddl
+++ /dev/null
@@ -1,821 +0,0 @@
-
-    create table j3_address (
-        id bigint generated by default as identity,
-        sort_code varchar(10),
-        tmodel_key varchar(255),
-        use_type varchar(255),
-        address_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_address_line (
-        id bigint generated by default as identity,
-        key_name varchar(255),
-        key_value varchar(255),
-        line varchar(80) not null,
-        address_id bigint not null,
-        primary key (id)
-    );
-
-    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,
-		ipaddress varchar(51),
-        primary key (auth_token)
-    );
-
-    create table j3_binding_category_bag (
-        id bigint not null,
-        entity_key varchar(255) not null,
-        primary key (id),
-        unique (entity_key)
-    );
-
-    create table j3_binding_descr (
-        id bigint generated by default as identity,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_binding_template (
-        access_point_type varchar(255),
-        access_point_url varchar(4096),
-        hosting_redirector varchar(255),
-        entity_key varchar(255) not null,
-        service_key varchar(255) not null,
-        primary key (entity_key)
-    );
-
-    create table j3_business_category_bag (
-        id bigint not null,
-        entity_key varchar(255) not null,
-        primary key (id),
-        unique (entity_key)
-    );
-
-    create table j3_business_descr (
-        id bigint generated by default as identity,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_business_entity (
-        entity_key varchar(255) not null,
-        primary key (entity_key)
-    );
-
-    create table j3_business_identifier (
-        id bigint generated by default as identity,
-        key_name varchar(255),
-        key_value varchar(255) not null,
-        tmodel_key_ref varchar(255),
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_business_name (
-        id bigint generated by default as identity,
-        lang_code varchar(26),
-        name varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_business_service (
-        entity_key varchar(255) not null,
-        business_key varchar(255) not null,
-        primary key (entity_key)
-    );
-
-    create table j3_canonicalization_method (
-        id bigint generated by default as identity,
-        algorithm varchar(255),
-        primary key (id)
-    );
-
-    create table j3_category_bag (
-        id bigint generated by default as identity,
-        primary key (id)
-    );
-
-    create table j3_clerk (
-        clerk_name varchar(255) not null,
-        cred varchar(255),
-        publisher_id varchar(255) not null,
-        node_name varchar(255),
-        primary key (clerk_name)
-    );
-
-    create table j3_client_subscriptioninfo (
-        subscription_key varchar(255) not null,
-        last_notified timestamp,
-        fromClerk_clerk_name varchar(255),
-        toClerk_clerk_name varchar(255),
-        primary key (subscription_key)
-    );
-
-    create table j3_contact (
-        id bigint generated by default as identity,
-        use_type varchar(255),
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_contact_descr (
-        id bigint generated by default as identity,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        contact_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_discovery_url (
-        id bigint generated by default as identity,
-        url varchar(4096) not null,
-        use_type varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_email (
-        id bigint generated by default as identity,
-        email_address varchar(4096) not null,
-        use_type varchar(255),
-        contact_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_instance_details_descr (
-        id bigint generated by default as identity,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        tmodel_instance_info_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_instance_details_doc_descr (
-        id bigint generated by default as identity,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        tmodel_instance_info_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_key_data_value (
-        id bigint generated by default as identity,
-        key_data_name varchar(255),
-        key_data_type varchar(255),
-        key_data_value blob(65636),
-        key_data_value_string clob(65636),
-        key_data_value_key bigint,
-        key_info_key bigint,
-        primary key (id)
-    );
-
-    create table j3_key_info (
-        id bigint generated by default as identity,
-        xml_id varchar(255),
-        primary key (id)
-    );
-
-    create table j3_keyed_reference (
-        id bigint generated by default as identity,
-        key_name varchar(255),
-        key_value varchar(255) not null,
-        tmodel_key_ref varchar(255),
-        category_bag_id bigint,
-        keyed_reference_group_id bigint,
-        primary key (id)
-    );
-
-    create table j3_keyed_reference_group (
-        id bigint generated by default as identity,
-        tmodel_key varchar(255),
-        category_bag_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_node (
-        name varchar(255) not null,
-        client_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),
-        proxy_transport varchar(255) not null,
-        publish_url varchar(255) not null,
-        security_url varchar(255) not null,
-        subscription_url varchar(255) not null,
-        primary key (name)
-    );
-
-    create table j3_object_type (
-        id bigint generated by default as identity,
-        encoding varchar(255),
-        mime_type varchar(255),
-        xml_id varchar(255),
-        signature_key bigint not null,
-        primary key (id)
-    );
-
-    create table j3_object_type_content (
-        id bigint generated by default as identity,
-        content blob(65636),
-        object_type_key bigint not null,
-        primary key (id)
-    );
-
-    create table j3_overview_doc (
-        id bigint generated by default as identity,
-        overview_url varchar(255),
-        overview_url_use_type varchar(255),
-        entity_key varchar(255),
-        tomodel_instance_info_id bigint,
-        primary key (id)
-    );
-
-    create table j3_overview_doc_descr (
-        id bigint generated by default as identity,
-        descr varchar(1024) not null,
-        lang_code varchar(26),
-        overview_doc_id bigint,
-        primary key (id)
-    );
-
-    create table j3_person_name (
-        id bigint generated by default as identity,
-        lang_code varchar(26),
-        name varchar(255) not null,
-        contact_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_phone (
-        id bigint generated by default as identity,
-        phone_number varchar(50) not null,
-        use_type varchar(255),
-        contact_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_publisher (
-        authorized_name varchar(255) not null,
-        email_address varchar(255),
-        is_admin bool,
-        is_enabled bool,
-        max_bindings_per_service integer,
-        max_businesses integer,
-        max_services_per_business integer,
-        max_tmodels integer,
-        publisher_name varchar(255) not null,
-        primary key (authorized_name)
-    );
-
-    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,
-        primary key (from_key, to_key)
-    );
-
-    create table j3_reference (
-        id bigint generated by default as identity,
-        digest_method varchar(255),
-        digest_value blob(65636),
-        type varchar(255),
-        uri varchar(255),
-        xml_id varchar(255),
-        signed_info_key bigint not null,
-        primary key (id)
-    );
-
-    create table j3_service_category_bag (
-        id bigint not null,
-        entity_key varchar(255) not null,
-        primary key (id),
-        unique (entity_key)
-    );
-
-    create table j3_service_descr (
-        id bigint generated by default as identity,
-        descr varchar(1024) not null,
-        lang_code varchar(26),
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_service_name (
-        id bigint generated by default as identity,
-        lang_code varchar(26),
-        name varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_service_projection (
-        business_key varchar(255) not null,
-        service_key varchar(255) not null,
-        primary key (business_key, service_key)
-    );
-
-    create table j3_signature (
-        id bigint generated by default as identity,
-        xml_id varchar(255),
-        binding_template_key varchar(255),
-        business_key varchar(255),
-        business_service_key varchar(255),
-        key_info bigint not null,
-        publisher_key varchar(255),
-        signature_value bigint not null,
-        signed_info bigint not null,
-        tmodel_key varchar(255),
-        primary key (id)
-    );
-
-    create table j3_signature_method (
-        id bigint generated by default as identity,
-        algorithm varchar(255),
-        primary key (id)
-    );
-
-    create table j3_signature_transform (
-        id bigint generated by default as identity,
-        transform varchar(255),
-        reference_key bigint not null,
-        primary key (id)
-    );
-
-    create table j3_signature_transform_data_v (
-        id bigint generated by default as identity,
-        content_bytes blob(65636),
-        content_type varchar(255),
-        signature_transform_key bigint not null,
-        primary key (id)
-    );
-
-    create table j3_signature_value (
-        id bigint generated by default as identity,
-        value_bytes blob(65636),
-        xml_id varchar(255),
-        primary key (id)
-    );
-
-    create table j3_signed_info (
-        id bigint generated by default as identity,
-        xml_id varchar(255),
-        canonicalization_method bigint not null,
-        signature_method bigint not null,
-        primary key (id)
-    );
-
-    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(65636) not null,
-        primary key (subscription_key)
-    );
-
-    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,
-        primary key (chunk_token)
-    );
-
-    create table j3_subscription_match (
-        id bigint generated by default as identity,
-        entity_key varchar(255) not null,
-        subscription_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_temp_key (
-        entity_key varchar(255) not null,
-        tx_id varchar(255) not null,
-        primary key (entity_key, tx_id)
-    );
-
-    create table j3_tmodel (
-        deleted smallint,
-        lang_code varchar(26),
-        name varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (entity_key)
-    );
-
-    create table j3_tmodel_category_bag (
-        id bigint not null,
-        entity_key varchar(255) not null,
-        primary key (id),
-        unique (entity_key)
-    );
-
-    create table j3_tmodel_descr (
-        id bigint generated by default as identity,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_tmodel_identifier (
-        id bigint generated by default as identity,
-        key_name varchar(255),
-        key_value varchar(255) not null,
-        tmodel_key_ref varchar(255),
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_tmodel_instance_info (
-        id bigint generated by default as identity,
-        instance_parms varchar(8192),
-        tmodel_key varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_tmodel_instance_info_descr (
-        id bigint generated by default as identity,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        tmodel_instance_info_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_transfer_token (
-        transfer_token varchar(51) not null,
-        expiration_date timestamp not null,
-        primary key (transfer_token)
-    );
-
-    create table j3_transfer_token_keys (
-        id bigint generated by default as identity,
-        entity_key varchar(255),
-        transfer_token varchar(51) not null,
-        primary key (id)
-    );
-
-    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),
-        primary key (entity_key)
-    );
-
-    alter table j3_address 
-        add constraint FKF83236BE75D860FB 
-        foreign key (address_id) 
-        references j3_contact;
-
-    alter table j3_address_line 
-        add constraint FKC665B8D5F8B8D8CF 
-        foreign key (address_id) 
-        references j3_address;
-
-    alter table j3_binding_category_bag 
-        add constraint FKCF34B2376A68D45A 
-        foreign key (id) 
-        references j3_category_bag;
-
-    alter table j3_binding_category_bag 
-        add constraint FKCF34B237CFBD88B7 
-        foreign key (entity_key) 
-        references j3_binding_template;
-
-    alter table j3_binding_descr 
-        add constraint FK5EA60911CFBD88B7 
-        foreign key (entity_key) 
-        references j3_binding_template;
-
-    alter table j3_binding_template 
-        add constraint FKD044BD6A2E448F3F 
-        foreign key (service_key) 
-        references j3_business_service;
-
-    alter table j3_binding_template 
-        add constraint FKD044BD6AD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity;
-
-    alter table j3_business_category_bag 
-        add constraint FKD6D3ECB06A68D45A 
-        foreign key (id) 
-        references j3_category_bag;
-
-    alter table j3_business_category_bag 
-        add constraint FKD6D3ECB0BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_business_descr 
-        add constraint FK3A24B4B8BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_business_entity 
-        add constraint FKCA61A0CD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity;
-
-    alter table j3_business_identifier 
-        add constraint FKB0C7A652BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_business_name 
-        add constraint FK43F526F4BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_business_service 
-        add constraint FK5D4255ACD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity;
-
-    alter table j3_business_service 
-        add constraint FK5D4255ACEF04CFEE 
-        foreign key (business_key) 
-        references j3_business_entity;
-
-    alter table j3_clerk 
-        add constraint FK34DC7D9F6BB0F935 
-        foreign key (node_name) 
-        references j3_node;
-
-    alter table j3_client_subscriptioninfo 
-        add constraint FKDF04CC095BFC6733 
-        foreign key (fromClerk_clerk_name) 
-        references j3_clerk;
-
-    alter table j3_client_subscriptioninfo 
-        add constraint FKDF04CC09F3CE9C04 
-        foreign key (toClerk_clerk_name) 
-        references j3_clerk;
-
-    alter table j3_contact 
-        add constraint FK7551BEEABEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_contact_descr 
-        add constraint FK56CA9E6C2E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact;
-
-    alter table j3_discovery_url 
-        add constraint FKA042FDAABEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_email 
-        add constraint FK34F910E62E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact;
-
-    alter table j3_instance_details_descr 
-        add constraint FK3CC165902B115C6F 
-        foreign key (tmodel_instance_info_id) 
-        references j3_tmodel_instance_info;
-
-    alter table j3_instance_details_doc_descr 
-        add constraint FK447324492B115C6F 
-        foreign key (tmodel_instance_info_id) 
-        references j3_tmodel_instance_info;
-
-    alter table j3_key_data_value 
-        add constraint FK74B7E072843143EF 
-        foreign key (key_data_value_key) 
-        references j3_key_data_value;
-
-    alter table j3_key_data_value 
-        add constraint FK74B7E07238C90470 
-        foreign key (key_info_key) 
-        references j3_key_info;
-
-    alter table j3_keyed_reference 
-        add constraint FK350C8454E075C8D7 
-        foreign key (keyed_reference_group_id) 
-        references j3_keyed_reference_group;
-
-    alter table j3_keyed_reference 
-        add constraint FK350C84541DB72652 
-        foreign key (category_bag_id) 
-        references j3_category_bag;
-
-    alter table j3_keyed_reference_group 
-        add constraint FKF6224ED41DB72652 
-        foreign key (category_bag_id) 
-        references j3_category_bag;
-
-    alter table j3_object_type 
-        add constraint FK98BBFA04BC6AD65 
-        foreign key (signature_key) 
-        references j3_signature;
-
-    alter table j3_object_type_content 
-        add constraint FK987A913E71FA643E 
-        foreign key (object_type_key) 
-        references j3_object_type;
-
-    alter table j3_overview_doc 
-        add constraint FK5CD8D0E8C5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel;
-
-    alter table j3_overview_doc 
-        add constraint FK5CD8D0E8E8CE1B36 
-        foreign key (tomodel_instance_info_id) 
-        references j3_tmodel_instance_info;
-
-    alter table j3_overview_doc_descr 
-        add constraint FK36FB9EA9BDC711C 
-        foreign key (overview_doc_id) 
-        references j3_overview_doc;
-
-    alter table j3_person_name 
-        add constraint FKCB7B8AFF2E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact;
-
-    alter table j3_phone 
-        add constraint FK359202B82E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact;
-
-    alter table j3_publisher_assertion 
-        add constraint FK8A102449E3544929 
-        foreign key (to_key) 
-        references j3_business_entity;
-
-    alter table j3_publisher_assertion 
-        add constraint FK8A102449CCEE22D8 
-        foreign key (from_key) 
-        references j3_business_entity;
-
-    alter table j3_reference 
-        add constraint FK493A4F951E480746 
-        foreign key (signed_info_key) 
-        references j3_signed_info;
-
-    alter table j3_service_category_bag 
-        add constraint FK185A68076A68D45A 
-        foreign key (id) 
-        references j3_category_bag;
-
-    alter table j3_service_category_bag 
-        add constraint FK185A680748D0656D 
-        foreign key (entity_key) 
-        references j3_business_service;
-
-    alter table j3_service_descr 
-        add constraint FKB6D63D4148D0656D 
-        foreign key (entity_key) 
-        references j3_business_service;
-
-    alter table j3_service_name 
-        add constraint FKCC1BE94B48D0656D 
-        foreign key (entity_key) 
-        references j3_business_service;
-
-    alter table j3_service_projection 
-        add constraint FK629F290F2E448F3F 
-        foreign key (service_key) 
-        references j3_business_service;
-
-    alter table j3_service_projection 
-        add constraint FK629F290FEF04CFEE 
-        foreign key (business_key) 
-        references j3_business_entity;
-
-    alter table j3_signature 
-        add constraint FKC05CA90256E87DED 
-        foreign key (publisher_key) 
-        references j3_publisher;
-
-    alter table j3_signature 
-        add constraint FKC05CA90271CD8948 
-        foreign key (binding_template_key) 
-        references j3_binding_template;
-
-    alter table j3_signature 
-        add constraint FKC05CA90212F40D40 
-        foreign key (business_service_key) 
-        references j3_business_service;
-
-    alter table j3_signature 
-        add constraint FKC05CA9028ACE9A26 
-        foreign key (signed_info) 
-        references j3_signed_info;
-
-    alter table j3_signature 
-        add constraint FKC05CA9027CE6418E 
-        foreign key (signature_value) 
-        references j3_signature_value;
-
-    alter table j3_signature 
-        add constraint FKC05CA9025793CF55 
-        foreign key (tmodel_key) 
-        references j3_tmodel;
-
-    alter table j3_signature 
-        add constraint FKC05CA902DA6C2DD0 
-        foreign key (key_info) 
-        references j3_key_info;
-
-    alter table j3_signature 
-        add constraint FKC05CA902EF04CFEE 
-        foreign key (business_key) 
-        references j3_business_entity;
-
-    alter table j3_signature_transform 
-        add constraint FK726346F9256790B 
-        foreign key (reference_key) 
-        references j3_reference;
-
-    alter table j3_signature_transform_data_v 
-        add constraint FK3242526C7B88B2A4 
-        foreign key (signature_transform_key) 
-        references j3_signature_transform;
-
-    alter table j3_signed_info 
-        add constraint FKD2E7E5BB877110CC 
-        foreign key (canonicalization_method) 
-        references j3_canonicalization_method;
-
-    alter table j3_signed_info 
-        add constraint FKD2E7E5BB1A25896 
-        foreign key (signature_method) 
-        references j3_signature_method;
-
-    alter table j3_subscription_match 
-        add constraint FK5B9C2F19BEEE42E5 
-        foreign key (subscription_key) 
-        references j3_subscription;
-
-    alter table j3_tmodel 
-        add constraint FK83C8072BD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity;
-
-    alter table j3_tmodel_category_bag 
-        add constraint FK7E0859DB6A68D45A 
-        foreign key (id) 
-        references j3_category_bag;
-
-    alter table j3_tmodel_category_bag 
-        add constraint FK7E0859DBC5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel;
-
-    alter table j3_tmodel_descr 
-        add constraint FK63DFF1EDC5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel;
-
-    alter table j3_tmodel_identifier 
-        add constraint FKD5FB623DC5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel;
-
-    alter table j3_tmodel_instance_info 
-        add constraint FKDC6C9004CFBD88B7 
-        foreign key (entity_key) 
-        references j3_binding_template;
-
-    alter table j3_tmodel_instance_info_descr 
-        add constraint FKD826B4062B115C6F 
-        foreign key (tmodel_instance_info_id) 
-        references j3_tmodel_instance_info;
-
-    alter table j3_transfer_token_keys 
-        add constraint FK8BBF49185ED9DD48 
-        foreign key (transfer_token) 
-        references j3_transfer_token;

http://git-wip-us.apache.org/repos/asf/juddi/blob/432345b0/docs/db/ddl/derby.ddl
----------------------------------------------------------------------
diff --git a/docs/db/ddl/derby.ddl b/docs/db/ddl/derby.ddl
deleted file mode 100644
index bc02dc3..0000000
--- a/docs/db/ddl/derby.ddl
+++ /dev/null
@@ -1,827 +0,0 @@
-
-    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,
-        primary key (id)
-    );
-
-    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,
-        primary key (id)
-    );
-
-    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,
-		ipaddress varchar(51),
-        primary key (auth_token)
-    );
-
-    create table j3_binding_category_bag (
-        id bigint not null,
-        entity_key varchar(255) not null,
-        primary key (id),
-        unique (entity_key)
-    );
-
-    create table j3_binding_descr (
-        id bigint not null,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_binding_template (
-        access_point_type varchar(255),
-        access_point_url varchar(4096),
-        hosting_redirector varchar(255),
-        entity_key varchar(255) not null,
-        service_key varchar(255) not null,
-        primary key (entity_key)
-    );
-
-    create table j3_business_category_bag (
-        id bigint not null,
-        entity_key varchar(255) not null,
-        primary key (id),
-        unique (entity_key)
-    );
-
-    create table j3_business_descr (
-        id bigint not null,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_business_entity (
-        entity_key varchar(255) not null,
-        primary key (entity_key)
-    );
-
-    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,
-        primary key (id)
-    );
-
-    create table j3_business_name (
-        id bigint not null,
-        lang_code varchar(26),
-        name varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_business_service (
-        entity_key varchar(255) not null,
-        business_key varchar(255) not null,
-        primary key (entity_key)
-    );
-
-    create table j3_canonicalization_method (
-        id bigint not null,
-        algorithm varchar(255),
-        primary key (id)
-    );
-
-    create table j3_category_bag (
-        id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_clerk (
-        clerk_name varchar(255) not null,
-        cred varchar(255),
-        publisher_id varchar(255) not null,
-        node_name varchar(255),
-        primary key (clerk_name)
-    );
-
-    create table j3_client_subscriptioninfo (
-        subscription_key varchar(255) not null,
-        last_notified timestamp,
-        fromClerk_clerk_name varchar(255),
-        toClerk_clerk_name varchar(255),
-        primary key (subscription_key)
-    );
-
-    create table j3_contact (
-        id bigint not null,
-        use_type varchar(255),
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_contact_descr (
-        id bigint not null,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        contact_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_discovery_url (
-        id bigint not null,
-        url varchar(4096) not null,
-        use_type varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_email (
-        id bigint not null,
-        email_address varchar(4096) not null,
-        use_type varchar(255),
-        contact_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_instance_details_descr (
-        id bigint not null,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        tmodel_instance_info_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_instance_details_doc_descr (
-        id bigint not null,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        tmodel_instance_info_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_key_data_value (
-        id bigint not null,
-        key_data_name varchar(255),
-        key_data_type varchar(255),
-        key_data_value blob(65636),
-        key_data_value_string clob(65636),
-        key_data_value_key bigint,
-        key_info_key bigint,
-        primary key (id)
-    );
-
-    create table j3_key_info (
-        id bigint not null,
-        xml_id varchar(255),
-        primary key (id)
-    );
-
-    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,
-        primary key (id)
-    );
-
-    create table j3_keyed_reference_group (
-        id bigint not null,
-        tmodel_key varchar(255),
-        category_bag_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_node (
-        name varchar(255) not null,
-        client_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),
-        proxy_transport varchar(255) not null,
-        publish_url varchar(255) not null,
-        security_url varchar(255) not null,
-        subscription_url varchar(255) not null,
-        primary key (name)
-    );
-
-    create table j3_object_type (
-        id bigint not null,
-        encoding varchar(255),
-        mime_type varchar(255),
-        xml_id varchar(255),
-        signature_key bigint not null,
-        primary key (id)
-    );
-
-    create table j3_object_type_content (
-        id bigint not null,
-        content blob(65636),
-        object_type_key bigint not null,
-        primary key (id)
-    );
-
-    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,
-        primary key (id)
-    );
-
-    create table j3_overview_doc_descr (
-        id bigint not null,
-        descr varchar(1024) not null,
-        lang_code varchar(26),
-        overview_doc_id bigint,
-        primary key (id)
-    );
-
-    create table j3_person_name (
-        id bigint not null,
-        lang_code varchar(26),
-        name varchar(255) not null,
-        contact_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_phone (
-        id bigint not null,
-        phone_number varchar(50) not null,
-        use_type varchar(255),
-        contact_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_publisher (
-        authorized_name varchar(255) not null,
-        email_address varchar(255),
-        is_admin bool,
-        is_enabled bool,
-        max_bindings_per_service integer,
-        max_businesses integer,
-        max_services_per_business integer,
-        max_tmodels integer,
-        publisher_name varchar(255) not null,
-        primary key (authorized_name)
-    );
-
-    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,
-        primary key (from_key, to_key)
-    );
-
-    create table j3_reference (
-        id bigint not null,
-        digest_method varchar(255),
-        digest_value blob(65636),
-        type varchar(255),
-        uri varchar(255),
-        xml_id varchar(255),
-        signed_info_key bigint not null,
-        primary key (id)
-    );
-
-    create table j3_service_category_bag (
-        id bigint not null,
-        entity_key varchar(255) not null,
-        primary key (id),
-        unique (entity_key)
-    );
-
-    create table j3_service_descr (
-        id bigint not null,
-        descr varchar(1024) not null,
-        lang_code varchar(26),
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_service_name (
-        id bigint not null,
-        lang_code varchar(26),
-        name varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_service_projection (
-        business_key varchar(255) not null,
-        service_key varchar(255) not null,
-        primary key (business_key, service_key)
-    );
-
-    create table j3_signature (
-        id bigint not null,
-        xml_id varchar(255),
-        binding_template_key varchar(255),
-        business_key varchar(255),
-        business_service_key varchar(255),
-        key_info bigint not null,
-        publisher_key varchar(255),
-        signature_value bigint not null,
-        signed_info bigint not null,
-        tmodel_key varchar(255),
-        primary key (id)
-    );
-
-    create table j3_signature_method (
-        id bigint not null,
-        algorithm varchar(255),
-        primary key (id)
-    );
-
-    create table j3_signature_transform (
-        id bigint not null,
-        transform varchar(255),
-        reference_key bigint not null,
-        primary key (id)
-    );
-
-    create table j3_signature_transform_data_v (
-        id bigint not null,
-        content_bytes blob(65636),
-        content_type varchar(255),
-        signature_transform_key bigint not null,
-        primary key (id)
-    );
-
-    create table j3_signature_value (
-        id bigint not null,
-        value_bytes blob(65636),
-        xml_id varchar(255),
-        primary key (id)
-    );
-
-    create table j3_signed_info (
-        id bigint not null,
-        xml_id varchar(255),
-        canonicalization_method bigint not null,
-        signature_method bigint not null,
-        primary key (id)
-    );
-
-    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(65636) not null,
-        primary key (subscription_key)
-    );
-
-    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,
-        primary key (chunk_token)
-    );
-
-    create table j3_subscription_match (
-        id bigint not null,
-        entity_key varchar(255) not null,
-        subscription_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_temp_key (
-        entity_key varchar(255) not null,
-        tx_id varchar(255) not null,
-        primary key (entity_key, tx_id)
-    );
-
-    create table j3_tmodel (
-        deleted smallint,
-        lang_code varchar(26),
-        name varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (entity_key)
-    );
-
-    create table j3_tmodel_category_bag (
-        id bigint not null,
-        entity_key varchar(255) not null,
-        primary key (id),
-        unique (entity_key)
-    );
-
-    create table j3_tmodel_descr (
-        id bigint not null,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    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,
-        primary key (id)
-    );
-
-    create table j3_tmodel_instance_info (
-        id bigint not null,
-        instance_parms varchar(8192),
-        tmodel_key varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_tmodel_instance_info_descr (
-        id bigint not null,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        tmodel_instance_info_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_transfer_token (
-        transfer_token varchar(51) not null,
-        expiration_date timestamp not null,
-        primary key (transfer_token)
-    );
-
-    create table j3_transfer_token_keys (
-        id bigint not null,
-        entity_key varchar(255),
-        transfer_token varchar(51) not null,
-        primary key (id)
-    );
-
-    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),
-        primary key (entity_key)
-    );
-
-    alter table j3_address 
-        add constraint FKF83236BE75D860FB 
-        foreign key (address_id) 
-        references j3_contact;
-
-    alter table j3_address_line 
-        add constraint FKC665B8D5F8B8D8CF 
-        foreign key (address_id) 
-        references j3_address;
-
-    alter table j3_binding_category_bag 
-        add constraint FKCF34B2376A68D45A 
-        foreign key (id) 
-        references j3_category_bag;
-
-    alter table j3_binding_category_bag 
-        add constraint FKCF34B237CFBD88B7 
-        foreign key (entity_key) 
-        references j3_binding_template;
-
-    alter table j3_binding_descr 
-        add constraint FK5EA60911CFBD88B7 
-        foreign key (entity_key) 
-        references j3_binding_template;
-
-    alter table j3_binding_template 
-        add constraint FKD044BD6A2E448F3F 
-        foreign key (service_key) 
-        references j3_business_service;
-
-    alter table j3_binding_template 
-        add constraint FKD044BD6AD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity;
-
-    alter table j3_business_category_bag 
-        add constraint FKD6D3ECB06A68D45A 
-        foreign key (id) 
-        references j3_category_bag;
-
-    alter table j3_business_category_bag 
-        add constraint FKD6D3ECB0BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_business_descr 
-        add constraint FK3A24B4B8BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_business_entity 
-        add constraint FKCA61A0CD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity;
-
-    alter table j3_business_identifier 
-        add constraint FKB0C7A652BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_business_name 
-        add constraint FK43F526F4BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_business_service 
-        add constraint FK5D4255ACD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity;
-
-    alter table j3_business_service 
-        add constraint FK5D4255ACEF04CFEE 
-        foreign key (business_key) 
-        references j3_business_entity;
-
-    alter table j3_clerk 
-        add constraint FK34DC7D9F6BB0F935 
-        foreign key (node_name) 
-        references j3_node;
-
-    alter table j3_client_subscriptioninfo 
-        add constraint FKDF04CC095BFC6733 
-        foreign key (fromClerk_clerk_name) 
-        references j3_clerk;
-
-    alter table j3_client_subscriptioninfo 
-        add constraint FKDF04CC09F3CE9C04 
-        foreign key (toClerk_clerk_name) 
-        references j3_clerk;
-
-    alter table j3_contact 
-        add constraint FK7551BEEABEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_contact_descr 
-        add constraint FK56CA9E6C2E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact;
-
-    alter table j3_discovery_url 
-        add constraint FKA042FDAABEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity;
-
-    alter table j3_email 
-        add constraint FK34F910E62E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact;
-
-    alter table j3_instance_details_descr 
-        add constraint FK3CC165902B115C6F 
-        foreign key (tmodel_instance_info_id) 
-        references j3_tmodel_instance_info;
-
-    alter table j3_instance_details_doc_descr 
-        add constraint FK447324492B115C6F 
-        foreign key (tmodel_instance_info_id) 
-        references j3_tmodel_instance_info;
-
-    alter table j3_key_data_value 
-        add constraint FK74B7E072843143EF 
-        foreign key (key_data_value_key) 
-        references j3_key_data_value;
-
-    alter table j3_key_data_value 
-        add constraint FK74B7E07238C90470 
-        foreign key (key_info_key) 
-        references j3_key_info;
-
-    alter table j3_keyed_reference 
-        add constraint FK350C8454E075C8D7 
-        foreign key (keyed_reference_group_id) 
-        references j3_keyed_reference_group;
-
-    alter table j3_keyed_reference 
-        add constraint FK350C84541DB72652 
-        foreign key (category_bag_id) 
-        references j3_category_bag;
-
-    alter table j3_keyed_reference_group 
-        add constraint FKF6224ED41DB72652 
-        foreign key (category_bag_id) 
-        references j3_category_bag;
-
-    alter table j3_object_type 
-        add constraint FK98BBFA04BC6AD65 
-        foreign key (signature_key) 
-        references j3_signature;
-
-    alter table j3_object_type_content 
-        add constraint FK987A913E71FA643E 
-        foreign key (object_type_key) 
-        references j3_object_type;
-
-    alter table j3_overview_doc 
-        add constraint FK5CD8D0E8C5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel;
-
-    alter table j3_overview_doc 
-        add constraint FK5CD8D0E8E8CE1B36 
-        foreign key (tomodel_instance_info_id) 
-        references j3_tmodel_instance_info;
-
-    alter table j3_overview_doc_descr 
-        add constraint FK36FB9EA9BDC711C 
-        foreign key (overview_doc_id) 
-        references j3_overview_doc;
-
-    alter table j3_person_name 
-        add constraint FKCB7B8AFF2E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact;
-
-    alter table j3_phone 
-        add constraint FK359202B82E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact;
-
-    alter table j3_publisher_assertion 
-        add constraint FK8A102449E3544929 
-        foreign key (to_key) 
-        references j3_business_entity;
-
-    alter table j3_publisher_assertion 
-        add constraint FK8A102449CCEE22D8 
-        foreign key (from_key) 
-        references j3_business_entity;
-
-    alter table j3_reference 
-        add constraint FK493A4F951E480746 
-        foreign key (signed_info_key) 
-        references j3_signed_info;
-
-    alter table j3_service_category_bag 
-        add constraint FK185A68076A68D45A 
-        foreign key (id) 
-        references j3_category_bag;
-
-    alter table j3_service_category_bag 
-        add constraint FK185A680748D0656D 
-        foreign key (entity_key) 
-        references j3_business_service;
-
-    alter table j3_service_descr 
-        add constraint FKB6D63D4148D0656D 
-        foreign key (entity_key) 
-        references j3_business_service;
-
-    alter table j3_service_name 
-        add constraint FKCC1BE94B48D0656D 
-        foreign key (entity_key) 
-        references j3_business_service;
-
-    alter table j3_service_projection 
-        add constraint FK629F290F2E448F3F 
-        foreign key (service_key) 
-        references j3_business_service;
-
-    alter table j3_service_projection 
-        add constraint FK629F290FEF04CFEE 
-        foreign key (business_key) 
-        references j3_business_entity;
-
-    alter table j3_signature 
-        add constraint FKC05CA90256E87DED 
-        foreign key (publisher_key) 
-        references j3_publisher;
-
-    alter table j3_signature 
-        add constraint FKC05CA90271CD8948 
-        foreign key (binding_template_key) 
-        references j3_binding_template;
-
-    alter table j3_signature 
-        add constraint FKC05CA90212F40D40 
-        foreign key (business_service_key) 
-        references j3_business_service;
-
-    alter table j3_signature 
-        add constraint FKC05CA9028ACE9A26 
-        foreign key (signed_info) 
-        references j3_signed_info;
-
-    alter table j3_signature 
-        add constraint FKC05CA9027CE6418E 
-        foreign key (signature_value) 
-        references j3_signature_value;
-
-    alter table j3_signature 
-        add constraint FKC05CA9025793CF55 
-        foreign key (tmodel_key) 
-        references j3_tmodel;
-
-    alter table j3_signature 
-        add constraint FKC05CA902DA6C2DD0 
-        foreign key (key_info) 
-        references j3_key_info;
-
-    alter table j3_signature 
-        add constraint FKC05CA902EF04CFEE 
-        foreign key (business_key) 
-        references j3_business_entity;
-
-    alter table j3_signature_transform 
-        add constraint FK726346F9256790B 
-        foreign key (reference_key) 
-        references j3_reference;
-
-    alter table j3_signature_transform_data_v 
-        add constraint FK3242526C7B88B2A4 
-        foreign key (signature_transform_key) 
-        references j3_signature_transform;
-
-    alter table j3_signed_info 
-        add constraint FKD2E7E5BB877110CC 
-        foreign key (canonicalization_method) 
-        references j3_canonicalization_method;
-
-    alter table j3_signed_info 
-        add constraint FKD2E7E5BB1A25896 
-        foreign key (signature_method) 
-        references j3_signature_method;
-
-    alter table j3_subscription_match 
-        add constraint FK5B9C2F19BEEE42E5 
-        foreign key (subscription_key) 
-        references j3_subscription;
-
-    alter table j3_tmodel 
-        add constraint FK83C8072BD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity;
-
-    alter table j3_tmodel_category_bag 
-        add constraint FK7E0859DB6A68D45A 
-        foreign key (id) 
-        references j3_category_bag;
-
-    alter table j3_tmodel_category_bag 
-        add constraint FK7E0859DBC5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel;
-
-    alter table j3_tmodel_descr 
-        add constraint FK63DFF1EDC5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel;
-
-    alter table j3_tmodel_identifier 
-        add constraint FKD5FB623DC5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel;
-
-    alter table j3_tmodel_instance_info 
-        add constraint FKDC6C9004CFBD88B7 
-        foreign key (entity_key) 
-        references j3_binding_template;
-
-    alter table j3_tmodel_instance_info_descr 
-        add constraint FKD826B4062B115C6F 
-        foreign key (tmodel_instance_info_id) 
-        references j3_tmodel_instance_info;
-
-    alter table j3_transfer_token_keys 
-        add constraint FK8BBF49185ED9DD48 
-        foreign key (transfer_token) 
-        references j3_transfer_token;
-
-    create table hibernate_unique_key (
-         next_hi integer 
-    );
-
-    insert into hibernate_unique_key values ( 0 );

http://git-wip-us.apache.org/repos/asf/juddi/blob/432345b0/docs/db/ddl/mysql.ddl
----------------------------------------------------------------------
diff --git a/docs/db/ddl/mysql.ddl b/docs/db/ddl/mysql.ddl
deleted file mode 100644
index 79fea94..0000000
--- a/docs/db/ddl/mysql.ddl
+++ /dev/null
@@ -1,887 +0,0 @@
-
-    create table j3_address (
-        id bigint not null auto_increment,
-        sort_code varchar(10),
-        tmodel_key varchar(255),
-        use_type varchar(255),
-        address_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_address_line (
-        id bigint not null auto_increment,
-        key_name varchar(255),
-        key_value varchar(255),
-        line varchar(80) not null,
-        address_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_auth_token (
-        auth_token varchar(51) not null,
-        authorized_name varchar(255) not null,
-        created datetime not null,
-        last_used datetime not null,
-        number_of_uses integer not null,
-        token_state integer not null,
-		ipaddress varchar(51),
-        primary key (auth_token)
-    );
-
-    create table j3_binding_category_bag (
-        id bigint not null,
-        entity_key varchar(255) not null,
-        primary key (id),
-        unique (entity_key)
-    );
-
-    create table j3_binding_descr (
-        id bigint not null auto_increment,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_binding_template (
-        access_point_type varchar(255),
-        access_point_url longtext,
-        hosting_redirector varchar(255),
-        entity_key varchar(255) not null,
-        service_key varchar(255) not null,
-        primary key (entity_key)
-    );
-
-    create table j3_business_category_bag (
-        id bigint not null,
-        entity_key varchar(255) not null,
-        primary key (id),
-        unique (entity_key)
-    );
-
-    create table j3_business_descr (
-        id bigint not null auto_increment,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_business_entity (
-        entity_key varchar(255) not null,
-        primary key (entity_key)
-    );
-
-    create table j3_business_identifier (
-        id bigint not null auto_increment,
-        key_name varchar(255),
-        key_value varchar(255) not null,
-        tmodel_key_ref varchar(255),
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_business_name (
-        id bigint not null auto_increment,
-        lang_code varchar(26),
-        name varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_business_service (
-        entity_key varchar(255) not null,
-        business_key varchar(255) not null,
-        primary key (entity_key)
-    );
-
-    create table j3_canonicalization_method (
-        id bigint not null auto_increment,
-        algorithm varchar(255),
-        primary key (id)
-    );
-
-    create table j3_category_bag (
-        id bigint not null auto_increment,
-        primary key (id)
-    );
-
-    create table j3_clerk (
-        clerk_name varchar(255) not null,
-        cred varchar(255),
-        publisher_id varchar(255) not null,
-        node_name varchar(255),
-        primary key (clerk_name)
-    );
-
-    create table j3_client_subscriptioninfo (
-        subscription_key varchar(255) not null,
-        last_notified datetime,
-        fromClerk_clerk_name varchar(255),
-        toClerk_clerk_name varchar(255),
-        primary key (subscription_key)
-    );
-
-    create table j3_contact (
-        id bigint not null auto_increment,
-        use_type varchar(255),
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_contact_descr (
-        id bigint not null auto_increment,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        contact_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_discovery_url (
-        id bigint not null auto_increment,
-        url longtext not null,
-        use_type varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_email (
-        id bigint not null auto_increment,
-        email_address longtext not null,
-        use_type varchar(255),
-        contact_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_instance_details_descr (
-        id bigint not null auto_increment,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        tmodel_instance_info_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_instance_details_doc_descr (
-        id bigint not null auto_increment,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        tmodel_instance_info_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_key_data_value (
-        id bigint not null auto_increment,
-        key_data_name varchar(255),
-        key_data_type varchar(255),
-        key_data_value longblob,
-        key_data_value_string longtext,
-        key_data_value_key bigint,
-        key_info_key bigint,
-        primary key (id)
-    );
-
-    create table j3_key_info (
-        id bigint not null auto_increment,
-        xml_id varchar(255),
-        primary key (id)
-    );
-
-    create table j3_keyed_reference (
-        id bigint not null auto_increment,
-        key_name varchar(255),
-        key_value varchar(255) not null,
-        tmodel_key_ref varchar(255),
-        category_bag_id bigint,
-        keyed_reference_group_id bigint,
-        primary key (id)
-    );
-
-    create table j3_keyed_reference_group (
-        id bigint not null auto_increment,
-        tmodel_key varchar(255),
-        category_bag_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_node (
-        name varchar(255) not null,
-        client_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),
-        proxy_transport varchar(255) not null,
-        publish_url varchar(255) not null,
-        security_url varchar(255) not null,
-        subscription_url varchar(255) not null,
-        primary key (name)
-    );
-
-    create table j3_object_type (
-        id bigint not null auto_increment,
-        encoding varchar(255),
-        mime_type varchar(255),
-        xml_id varchar(255),
-        signature_key bigint not null,
-        primary key (id)
-    );
-
-    create table j3_object_type_content (
-        id bigint not null auto_increment,
-        content longblob,
-        object_type_key bigint not null,
-        primary key (id)
-    );
-
-    create table j3_overview_doc (
-        id bigint not null auto_increment,
-        overview_url varchar(255),
-        overview_url_use_type varchar(255),
-        entity_key varchar(255),
-        tomodel_instance_info_id bigint,
-        primary key (id)
-    );
-
-    create table j3_overview_doc_descr (
-        id bigint not null auto_increment,
-        descr longtext not null,
-        lang_code varchar(26),
-        overview_doc_id bigint,
-        primary key (id)
-    );
-
-    create table j3_person_name (
-        id bigint not null auto_increment,
-        lang_code varchar(26),
-        name varchar(255) not null,
-        contact_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_phone (
-        id bigint not null auto_increment,
-        phone_number varchar(50) not null,
-        use_type varchar(255),
-        contact_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_publisher (
-        authorized_name varchar(255) not null,
-        email_address varchar(255),
-        is_admin bool,
-        is_enabled bool,
-        max_bindings_per_service integer,
-        max_businesses integer,
-        max_services_per_business integer,
-        max_tmodels integer,
-        publisher_name varchar(255) not null,
-        primary key (authorized_name)
-    );
-
-    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,
-        primary key (from_key, to_key)
-    );
-
-    create table j3_reference (
-        id bigint not null auto_increment,
-        digest_method varchar(255),
-        digest_value longblob,
-        type varchar(255),
-        uri varchar(255),
-        xml_id varchar(255),
-        signed_info_key bigint not null,
-        primary key (id)
-    );
-
-    create table j3_service_category_bag (
-        id bigint not null,
-        entity_key varchar(255) not null,
-        primary key (id),
-        unique (entity_key)
-    );
-
-    create table j3_service_descr (
-        id bigint not null auto_increment,
-        descr longtext not null,
-        lang_code varchar(26),
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_service_name (
-        id bigint not null auto_increment,
-        lang_code varchar(26),
-        name varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_service_projection (
-        business_key varchar(255) not null,
-        service_key varchar(255) not null,
-        primary key (business_key, service_key)
-    );
-
-    create table j3_signature (
-        id bigint not null auto_increment,
-        xml_id varchar(255),
-        binding_template_key varchar(255),
-        business_key varchar(255),
-        business_service_key varchar(255),
-        key_info bigint not null,
-        publisher_key varchar(255),
-        signature_value bigint not null,
-        signed_info bigint not null,
-        tmodel_key varchar(255),
-        primary key (id)
-    );
-
-    create table j3_signature_method (
-        id bigint not null auto_increment,
-        algorithm varchar(255),
-        primary key (id)
-    );
-
-    create table j3_signature_transform (
-        id bigint not null auto_increment,
-        transform varchar(255),
-        reference_key bigint not null,
-        primary key (id)
-    );
-
-    create table j3_signature_transform_data_v (
-        id bigint not null auto_increment,
-        content_bytes longblob,
-        content_type varchar(255),
-        signature_transform_key bigint not null,
-        primary key (id)
-    );
-
-    create table j3_signature_value (
-        id bigint not null auto_increment,
-        value_bytes longblob,
-        xml_id varchar(255),
-        primary key (id)
-    );
-
-    create table j3_signed_info (
-        id bigint not null auto_increment,
-        xml_id varchar(255),
-        canonicalization_method bigint not null,
-        signature_method bigint not null,
-        primary key (id)
-    );
-
-    create table j3_subscription (
-        subscription_key varchar(255) not null,
-        authorized_name varchar(255) not null,
-        binding_key varchar(255),
-        brief bit,
-        create_date datetime not null,
-        expires_after datetime,
-        last_notified datetime,
-        max_entities integer,
-        notification_interval varchar(255),
-        subscription_filter longtext not null,
-        primary key (subscription_key)
-    );
-
-    create table j3_subscription_chunk_token (
-        chunk_token varchar(255) not null,
-        data integer not null,
-        end_point datetime,
-        expires_after datetime not null,
-        start_point datetime,
-        subscription_key varchar(255) not null,
-        primary key (chunk_token)
-    );
-
-    create table j3_subscription_match (
-        id bigint not null auto_increment,
-        entity_key varchar(255) not null,
-        subscription_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_temp_key (
-        entity_key varchar(255) not null,
-        tx_id varchar(255) not null,
-        primary key (entity_key, tx_id)
-    );
-
-    create table j3_tmodel (
-        deleted bit,
-        lang_code varchar(26),
-        name varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (entity_key)
-    );
-
-    create table j3_tmodel_category_bag (
-        id bigint not null,
-        entity_key varchar(255) not null,
-        primary key (id),
-        unique (entity_key)
-    );
-
-    create table j3_tmodel_descr (
-        id bigint not null auto_increment,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_tmodel_identifier (
-        id bigint not null auto_increment,
-        key_name varchar(255),
-        key_value varchar(255) not null,
-        tmodel_key_ref varchar(255),
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_tmodel_instance_info (
-        id bigint not null auto_increment,
-        instance_parms longtext,
-        tmodel_key varchar(255) not null,
-        entity_key varchar(255) not null,
-        primary key (id)
-    );
-
-    create table j3_tmodel_instance_info_descr (
-        id bigint not null auto_increment,
-        descr varchar(255) not null,
-        lang_code varchar(26),
-        tmodel_instance_info_id bigint not null,
-        primary key (id)
-    );
-
-    create table j3_transfer_token (
-        transfer_token varchar(51) not null,
-        expiration_date datetime not null,
-        primary key (transfer_token)
-    );
-
-    create table j3_transfer_token_keys (
-        id bigint not null auto_increment,
-        entity_key varchar(255),
-        transfer_token varchar(51) not null,
-        primary key (id)
-    );
-
-    create table j3_uddi_entity (
-        entity_key varchar(255) not null,
-        authorized_name varchar(255) not null,
-        created datetime,
-        modified datetime not null,
-        modified_including_children datetime,
-        node_id varchar(255),
-        primary key (entity_key)
-    );
-
-    alter table j3_address 
-        add index FKF83236BE75D860FB (address_id), 
-        add constraint FKF83236BE75D860FB 
-        foreign key (address_id) 
-        references j3_contact (id);
-
-    alter table j3_address_line 
-        add index FKC665B8D5F8B8D8CF (address_id), 
-        add constraint FKC665B8D5F8B8D8CF 
-        foreign key (address_id) 
-        references j3_address (id);
-
-    alter table j3_binding_category_bag 
-        add index FKCF34B2376A68D45A (id), 
-        add constraint FKCF34B2376A68D45A 
-        foreign key (id) 
-        references j3_category_bag (id);
-
-    alter table j3_binding_category_bag 
-        add index FKCF34B237CFBD88B7 (entity_key), 
-        add constraint FKCF34B237CFBD88B7 
-        foreign key (entity_key) 
-        references j3_binding_template (entity_key);
-
-    alter table j3_binding_descr 
-        add index FK5EA60911CFBD88B7 (entity_key), 
-        add constraint FK5EA60911CFBD88B7 
-        foreign key (entity_key) 
-        references j3_binding_template (entity_key);
-
-    alter table j3_binding_template 
-        add index FKD044BD6A2E448F3F (service_key), 
-        add constraint FKD044BD6A2E448F3F 
-        foreign key (service_key) 
-        references j3_business_service (entity_key);
-
-    alter table j3_binding_template 
-        add index FKD044BD6AD1823CA5 (entity_key), 
-        add constraint FKD044BD6AD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity (entity_key);
-
-    alter table j3_business_category_bag 
-        add index FKD6D3ECB06A68D45A (id), 
-        add constraint FKD6D3ECB06A68D45A 
-        foreign key (id) 
-        references j3_category_bag (id);
-
-    alter table j3_business_category_bag 
-        add index FKD6D3ECB0BEB92A91 (entity_key), 
-        add constraint FKD6D3ECB0BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity (entity_key);
-
-    alter table j3_business_descr 
-        add index FK3A24B4B8BEB92A91 (entity_key), 
-        add constraint FK3A24B4B8BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity (entity_key);
-
-    alter table j3_business_entity 
-        add index FKCA61A0CD1823CA5 (entity_key), 
-        add constraint FKCA61A0CD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity (entity_key);
-
-    alter table j3_business_identifier 
-        add index FKB0C7A652BEB92A91 (entity_key), 
-        add constraint FKB0C7A652BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity (entity_key);
-
-    alter table j3_business_name 
-        add index FK43F526F4BEB92A91 (entity_key), 
-        add constraint FK43F526F4BEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity (entity_key);
-
-    alter table j3_business_service 
-        add index FK5D4255ACD1823CA5 (entity_key), 
-        add constraint FK5D4255ACD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity (entity_key);
-
-    alter table j3_business_service 
-        add index FK5D4255ACEF04CFEE (business_key), 
-        add constraint FK5D4255ACEF04CFEE 
-        foreign key (business_key) 
-        references j3_business_entity (entity_key);
-
-    alter table j3_clerk 
-        add index FK34DC7D9F6BB0F935 (node_name), 
-        add constraint FK34DC7D9F6BB0F935 
-        foreign key (node_name) 
-        references j3_node (name);
-
-    alter table j3_client_subscriptioninfo 
-        add index FKDF04CC095BFC6733 (fromClerk_clerk_name), 
-        add constraint FKDF04CC095BFC6733 
-        foreign key (fromClerk_clerk_name) 
-        references j3_clerk (clerk_name);
-
-    alter table j3_client_subscriptioninfo 
-        add index FKDF04CC09F3CE9C04 (toClerk_clerk_name), 
-        add constraint FKDF04CC09F3CE9C04 
-        foreign key (toClerk_clerk_name) 
-        references j3_clerk (clerk_name);
-
-    alter table j3_contact 
-        add index FK7551BEEABEB92A91 (entity_key), 
-        add constraint FK7551BEEABEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity (entity_key);
-
-    alter table j3_contact_descr 
-        add index FK56CA9E6C2E3FD94F (contact_id), 
-        add constraint FK56CA9E6C2E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact (id);
-
-    alter table j3_discovery_url 
-        add index FKA042FDAABEB92A91 (entity_key), 
-        add constraint FKA042FDAABEB92A91 
-        foreign key (entity_key) 
-        references j3_business_entity (entity_key);
-
-    alter table j3_email 
-        add index FK34F910E62E3FD94F (contact_id), 
-        add constraint FK34F910E62E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact (id);
-
-    alter table j3_instance_details_descr 
-        add index FK3CC165902B115C6F (tmodel_instance_info_id), 
-        add constraint FK3CC165902B115C6F 
-        foreign key (tmodel_instance_info_id) 
-        references j3_tmodel_instance_info (id);
-
-    alter table j3_instance_details_doc_descr 
-        add index FK447324492B115C6F (tmodel_instance_info_id), 
-        add constraint FK447324492B115C6F 
-        foreign key (tmodel_instance_info_id) 
-        references j3_tmodel_instance_info (id);
-
-    alter table j3_key_data_value 
-        add index FK74B7E072843143EF (key_data_value_key), 
-        add constraint FK74B7E072843143EF 
-        foreign key (key_data_value_key) 
-        references j3_key_data_value (id);
-
-    alter table j3_key_data_value 
-        add index FK74B7E07238C90470 (key_info_key), 
-        add constraint FK74B7E07238C90470 
-        foreign key (key_info_key) 
-        references j3_key_info (id);
-
-    alter table j3_keyed_reference 
-        add index FK350C8454E075C8D7 (keyed_reference_group_id), 
-        add constraint FK350C8454E075C8D7 
-        foreign key (keyed_reference_group_id) 
-        references j3_keyed_reference_group (id);
-
-    alter table j3_keyed_reference 
-        add index FK350C84541DB72652 (category_bag_id), 
-        add constraint FK350C84541DB72652 
-        foreign key (category_bag_id) 
-        references j3_category_bag (id);
-
-    alter table j3_keyed_reference_group 
-        add index FKF6224ED41DB72652 (category_bag_id), 
-        add constraint FKF6224ED41DB72652 
-        foreign key (category_bag_id) 
-        references j3_category_bag (id);
-
-    alter table j3_object_type 
-        add index FK98BBFA04BC6AD65 (signature_key), 
-        add constraint FK98BBFA04BC6AD65 
-        foreign key (signature_key) 
-        references j3_signature (id);
-
-    alter table j3_object_type_content 
-        add index FK987A913E71FA643E (object_type_key), 
-        add constraint FK987A913E71FA643E 
-        foreign key (object_type_key) 
-        references j3_object_type (id);
-
-    alter table j3_overview_doc 
-        add index FK5CD8D0E8C5BF8903 (entity_key), 
-        add constraint FK5CD8D0E8C5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel (entity_key);
-
-    alter table j3_overview_doc 
-        add index FK5CD8D0E8E8CE1B36 (tomodel_instance_info_id), 
-        add constraint FK5CD8D0E8E8CE1B36 
-        foreign key (tomodel_instance_info_id) 
-        references j3_tmodel_instance_info (id);
-
-    alter table j3_overview_doc_descr 
-        add index FK36FB9EA9BDC711C (overview_doc_id), 
-        add constraint FK36FB9EA9BDC711C 
-        foreign key (overview_doc_id) 
-        references j3_overview_doc (id);
-
-    alter table j3_person_name 
-        add index FKCB7B8AFF2E3FD94F (contact_id), 
-        add constraint FKCB7B8AFF2E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact (id);
-
-    alter table j3_phone 
-        add index FK359202B82E3FD94F (contact_id), 
-        add constraint FK359202B82E3FD94F 
-        foreign key (contact_id) 
-        references j3_contact (id);
-
-    alter table j3_publisher_assertion 
-        add index FK8A102449E3544929 (to_key), 
-        add constraint FK8A102449E3544929 
-        foreign key (to_key) 
-        references j3_business_entity (entity_key);
-
-    alter table j3_publisher_assertion 
-        add index FK8A102449CCEE22D8 (from_key), 
-        add constraint FK8A102449CCEE22D8 
-        foreign key (from_key) 
-        references j3_business_entity (entity_key);
-
-    alter table j3_reference 
-        add index FK493A4F951E480746 (signed_info_key), 
-        add constraint FK493A4F951E480746 
-        foreign key (signed_info_key) 
-        references j3_signed_info (id);
-
-    alter table j3_service_category_bag 
-        add index FK185A68076A68D45A (id), 
-        add constraint FK185A68076A68D45A 
-        foreign key (id) 
-        references j3_category_bag (id);
-
-    alter table j3_service_category_bag 
-        add index FK185A680748D0656D (entity_key), 
-        add constraint FK185A680748D0656D 
-        foreign key (entity_key) 
-        references j3_business_service (entity_key);
-
-    alter table j3_service_descr 
-        add index FKB6D63D4148D0656D (entity_key), 
-        add constraint FKB6D63D4148D0656D 
-        foreign key (entity_key) 
-        references j3_business_service (entity_key);
-
-    alter table j3_service_name 
-        add index FKCC1BE94B48D0656D (entity_key), 
-        add constraint FKCC1BE94B48D0656D 
-        foreign key (entity_key) 
-        references j3_business_service (entity_key);
-
-    alter table j3_service_projection 
-        add index FK629F290F2E448F3F (service_key), 
-        add constraint FK629F290F2E448F3F 
-        foreign key (service_key) 
-        references j3_business_service (entity_key);
-
-    alter table j3_service_projection 
-        add index FK629F290FEF04CFEE (business_key), 
-        add constraint FK629F290FEF04CFEE 
-        foreign key (business_key) 
-        references j3_business_entity (entity_key);
-
-    alter table j3_signature 
-        add index FKC05CA90256E87DED (publisher_key), 
-        add constraint FKC05CA90256E87DED 
-        foreign key (publisher_key) 
-        references j3_publisher (authorized_name);
-
-    alter table j3_signature 
-        add index FKC05CA90271CD8948 (binding_template_key), 
-        add constraint FKC05CA90271CD8948 
-        foreign key (binding_template_key) 
-        references j3_binding_template (entity_key);
-
-    alter table j3_signature 
-        add index FKC05CA90212F40D40 (business_service_key), 
-        add constraint FKC05CA90212F40D40 
-        foreign key (business_service_key) 
-        references j3_business_service (entity_key);
-
-    alter table j3_signature 
-        add index FKC05CA9028ACE9A26 (signed_info), 
-        add constraint FKC05CA9028ACE9A26 
-        foreign key (signed_info) 
-        references j3_signed_info (id);
-
-    alter table j3_signature 
-        add index FKC05CA9027CE6418E (signature_value), 
-        add constraint FKC05CA9027CE6418E 
-        foreign key (signature_value) 
-        references j3_signature_value (id);
-
-    alter table j3_signature 
-        add index FKC05CA9025793CF55 (tmodel_key), 
-        add constraint FKC05CA9025793CF55 
-        foreign key (tmodel_key) 
-        references j3_tmodel (entity_key);
-
-    alter table j3_signature 
-        add index FKC05CA902DA6C2DD0 (key_info), 
-        add constraint FKC05CA902DA6C2DD0 
-        foreign key (key_info) 
-        references j3_key_info (id);
-
-    alter table j3_signature 
-        add index FKC05CA902EF04CFEE (business_key), 
-        add constraint FKC05CA902EF04CFEE 
-        foreign key (business_key) 
-        references j3_business_entity (entity_key);
-
-    alter table j3_signature_transform 
-        add index FK726346F9256790B (reference_key), 
-        add constraint FK726346F9256790B 
-        foreign key (reference_key) 
-        references j3_reference (id);
-
-    alter table j3_signature_transform_data_v 
-        add index FK3242526C7B88B2A4 (signature_transform_key), 
-        add constraint FK3242526C7B88B2A4 
-        foreign key (signature_transform_key) 
-        references j3_signature_transform (id);
-
-    alter table j3_signed_info 
-        add index FKD2E7E5BB877110CC (canonicalization_method), 
-        add constraint FKD2E7E5BB877110CC 
-        foreign key (canonicalization_method) 
-        references j3_canonicalization_method (id);
-
-    alter table j3_signed_info 
-        add index FKD2E7E5BB1A25896 (signature_method), 
-        add constraint FKD2E7E5BB1A25896 
-        foreign key (signature_method) 
-        references j3_signature_method (id);
-
-    alter table j3_subscription_match 
-        add index FK5B9C2F19BEEE42E5 (subscription_key), 
-        add constraint FK5B9C2F19BEEE42E5 
-        foreign key (subscription_key) 
-        references j3_subscription (subscription_key);
-
-    alter table j3_tmodel 
-        add index FK83C8072BD1823CA5 (entity_key), 
-        add constraint FK83C8072BD1823CA5 
-        foreign key (entity_key) 
-        references j3_uddi_entity (entity_key);
-
-    alter table j3_tmodel_category_bag 
-        add index FK7E0859DB6A68D45A (id), 
-        add constraint FK7E0859DB6A68D45A 
-        foreign key (id) 
-        references j3_category_bag (id);
-
-    alter table j3_tmodel_category_bag 
-        add index FK7E0859DBC5BF8903 (entity_key), 
-        add constraint FK7E0859DBC5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel (entity_key);
-
-    alter table j3_tmodel_descr 
-        add index FK63DFF1EDC5BF8903 (entity_key), 
-        add constraint FK63DFF1EDC5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel (entity_key);
-
-    alter table j3_tmodel_identifier 
-        add index FKD5FB623DC5BF8903 (entity_key), 
-        add constraint FKD5FB623DC5BF8903 
-        foreign key (entity_key) 
-        references j3_tmodel (entity_key);
-
-    alter table j3_tmodel_instance_info 
-        add index FKDC6C9004CFBD88B7 (entity_key), 
-        add constraint FKDC6C9004CFBD88B7 
-        foreign key (entity_key) 
-        references j3_binding_template (entity_key);
-
-    alter table j3_tmodel_instance_info_descr 
-        add index FKD826B4062B115C6F (tmodel_instance_info_id), 
-        add constraint FKD826B4062B115C6F 
-        foreign key (tmodel_instance_info_id) 
-        references j3_tmodel_instance_info (id);
-
-    alter table j3_transfer_token_keys 
-        add index FK8BBF49185ED9DD48 (transfer_token), 
-        add constraint FK8BBF49185ED9DD48 
-        foreign key (transfer_token) 
-        references j3_transfer_token (transfer_token);


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@juddi.apache.org
For additional commands, e-mail: commits-help@juddi.apache.org