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