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:17 UTC
[4/4] git commit: JUDDI-876 resolved
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