Return-Path: Delivered-To: apmail-ws-juddi-cvs-archive@www.apache.org Received: (qmail 25811 invoked from network); 21 Jan 2010 06:42:42 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 21 Jan 2010 06:42:42 -0000 Received: (qmail 87248 invoked by uid 500); 21 Jan 2010 06:42:42 -0000 Delivered-To: apmail-ws-juddi-cvs-archive@ws.apache.org Received: (qmail 87206 invoked by uid 500); 21 Jan 2010 06:42:42 -0000 Mailing-List: contact juddi-cvs-help@ws.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Delivered-To: mailing list juddi-cvs@ws.apache.org Received: (qmail 87197 invoked by uid 99); 21 Jan 2010 06:42:41 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 21 Jan 2010 06:42:41 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO eris.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 21 Jan 2010 06:42:38 +0000 Received: by eris.apache.org (Postfix, from userid 65534) id EF4B82388A23; Thu, 21 Jan 2010 06:42:17 +0000 (UTC) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r901566 [2/2] - in /webservices/juddi/trunk: docs/db/ddl/ juddi-core/ Date: Thu, 21 Jan 2010 06:42:09 -0000 To: juddi-cvs@ws.apache.org From: kstam@apache.org X-Mailer: svnmailer-1.0.8 Message-Id: <20100121064217.EF4B82388A23@eris.apache.org> Added: webservices/juddi/trunk/docs/db/ddl/mysql5InnoDB.ddl URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/docs/db/ddl/mysql5InnoDB.ddl?rev=901566&view=auto ============================================================================== --- webservices/juddi/trunk/docs/db/ddl/mysql5InnoDB.ddl (added) +++ webservices/juddi/trunk/docs/db/ddl/mysql5InnoDB.ddl Thu Jan 21 06:41:57 2010 @@ -0,0 +1,678 @@ + + 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, + 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(1024) not null, + lang_code varchar(5), + 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(4000), + 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(1024) not null, + lang_code varchar(5), + 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(5), + 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_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(1024) not null, + lang_code varchar(5), + contact_id bigint not null, + primary key (id) + ) ENGINE=InnoDB; + + create table j3_discovery_url ( + id bigint not null auto_increment, + url varchar(255) 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(255) 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(1024) not null, + lang_code varchar(5), + 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(1024) not null, + lang_code varchar(5), + tmodel_instance_info_id bigint not null, + 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, + custody_transfer_url varchar(255) not null, + factory_initial varchar(255), + factory_naming_provider varchar(255), + factory_url_pkgs varchar(255), + inquiry_url varchar(255) not null, + juddi_api_url varchar(255), + manager_name varchar(255) not null, + proxy_transport varchar(255) not null, + publish_url varchar(255) not null, + security_url varchar(255) not null, + subscription_url varchar(255) not null, + primary key (name) + ) ENGINE=InnoDB; + + create table j3_overview_doc ( + id bigint not null auto_increment, + overview_url varchar(255) not null, + 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(5), + overview_doc_id bigint, + primary key (id) + ) ENGINE=InnoDB; + + create table j3_person_name ( + id bigint not null auto_increment, + lang_code varchar(5), + 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 varchar(5), + is_enabled varchar(5), + max_bindings_per_service integer, + max_businesses integer, + max_services_per_business integer, + max_tmodels integer, + publisher_name varchar(255) not null, + 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_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(5), + 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(5), + 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_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_tmodel ( + deleted bit, + lang_code varchar(5), + 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(1024) not null, + lang_code varchar(5), + 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(512), + 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(1024) not null, + lang_code varchar(5), + 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_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_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_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_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); Added: webservices/juddi/trunk/docs/db/ddl/oracle9.ddl URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/docs/db/ddl/oracle9.ddl?rev=901566&view=auto ============================================================================== --- webservices/juddi/trunk/docs/db/ddl/oracle9.ddl (added) +++ webservices/juddi/trunk/docs/db/ddl/oracle9.ddl Thu Jan 21 06:41:57 2010 @@ -0,0 +1,631 @@ + + 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, + 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(1024 char) not null, + lang_code varchar2(5 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 varchar2(4000 char), + 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(1024 char) not null, + lang_code varchar2(5 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(5 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_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(1024 char) not null, + lang_code varchar2(5 char), + contact_id number(19,0) not null, + primary key (id) + ); + + create table j3_discovery_url ( + id number(19,0) not null, + url varchar2(255 char) 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 varchar2(255 char) 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(1024 char) not null, + lang_code varchar2(5 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(1024 char) not null, + lang_code varchar2(5 char), + tmodel_instance_info_id number(19,0) not null, + 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, + 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), + manager_name varchar2(255 char) not null, + 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_overview_doc ( + id number(19,0) not null, + overview_url varchar2(255 char) not null, + 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(5 char), + overview_doc_id number(19,0), + primary key (id) + ); + + create table j3_person_name ( + id number(19,0) not null, + lang_code varchar2(5 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 varchar2(5 char), + is_enabled varchar2(5 char), + 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_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(5 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(5 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_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_tmodel ( + deleted number(1,0), + lang_code varchar2(5 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(1024 char) not null, + lang_code varchar2(5 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 varchar2(512 char), + 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(1024 char) not null, + lang_code varchar2(5 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_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_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_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_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; Added: webservices/juddi/trunk/docs/db/ddl/postgres.ddl URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/docs/db/ddl/postgres.ddl?rev=901566&view=auto ============================================================================== --- webservices/juddi/trunk/docs/db/ddl/postgres.ddl (added) +++ webservices/juddi/trunk/docs/db/ddl/postgres.ddl Thu Jan 21 06:41:57 2010 @@ -0,0 +1,631 @@ + + 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, + 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(1024) not null, + lang_code varchar(5), + entity_key varchar(255) not null, + primary key (id) + ); + + create table j3_binding_template ( + access_point_type varchar(255), + access_point_url varchar(4000), + 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(1024) not null, + lang_code varchar(5), + 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(5), + 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_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(1024) not null, + lang_code varchar(5), + contact_id int8 not null, + primary key (id) + ); + + create table j3_discovery_url ( + id int8 not null, + url varchar(255) 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(255) 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(1024) not null, + lang_code varchar(5), + tmodel_instance_info_id int8 not null, + primary key (id) + ); + + create table j3_instance_details_doc_descr ( + id int8 not null, + descr varchar(1024) not null, + lang_code varchar(5), + tmodel_instance_info_id int8 not null, + 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, + custody_transfer_url varchar(255) not null, + factory_initial varchar(255), + factory_naming_provider varchar(255), + factory_url_pkgs varchar(255), + inquiry_url varchar(255) not null, + juddi_api_url varchar(255), + manager_name varchar(255) not null, + proxy_transport varchar(255) not null, + publish_url varchar(255) not null, + security_url varchar(255) not null, + subscription_url varchar(255) not null, + primary key (name) + ); + + create table j3_overview_doc ( + id int8 not null, + overview_url varchar(255) not null, + 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(5), + overview_doc_id int8, + primary key (id) + ); + + create table j3_person_name ( + id int8 not null, + lang_code varchar(5), + 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 varchar(5), + is_enabled varchar(5), + 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_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(5), + entity_key varchar(255) not null, + primary key (id) + ); + + create table j3_service_name ( + id int8 not null, + lang_code varchar(5), + 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_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_tmodel ( + deleted bool, + lang_code varchar(5), + 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(1024) not null, + lang_code varchar(5), + 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(512), + 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(1024) not null, + lang_code varchar(5), + 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_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_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_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_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; Added: webservices/juddi/trunk/docs/db/ddl/sqlserver.ddl URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/docs/db/ddl/sqlserver.ddl?rev=901566&view=auto ============================================================================== --- webservices/juddi/trunk/docs/db/ddl/sqlserver.ddl (added) +++ webservices/juddi/trunk/docs/db/ddl/sqlserver.ddl Thu Jan 21 06:41:57 2010 @@ -0,0 +1,629 @@ + + 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, + 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(1024) not null, + lang_code varchar(5) 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(4000) 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(1024) not null, + lang_code varchar(5) 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(5) 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_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(1024) not null, + lang_code varchar(5) 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(255) 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(255) 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(1024) not null, + lang_code varchar(5) 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(1024) not null, + lang_code varchar(5) null, + tmodel_instance_info_id numeric(19,0) not 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, + 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, + manager_name varchar(255) not null, + proxy_transport varchar(255) not null, + publish_url varchar(255) not null, + security_url varchar(255) not null, + subscription_url varchar(255) not null, + primary key (name) + ); + + create table j3_overview_doc ( + id numeric(19,0) identity not null, + overview_url varchar(255) not 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(5) 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(5) 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 varchar(5) null, + is_enabled varchar(5) 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_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(5) 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(5) 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_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_tmodel ( + deleted tinyint null, + lang_code varchar(5) 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(1024) not null, + lang_code varchar(5) 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(512) 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(1024) not null, + lang_code varchar(5) 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_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_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_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_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; Modified: webservices/juddi/trunk/juddi-core/pom.xml URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/juddi-core/pom.xml?rev=901566&r1=901565&r2=901566&view=diff ============================================================================== --- webservices/juddi/trunk/juddi-core/pom.xml (original) +++ webservices/juddi/trunk/juddi-core/pom.xml Thu Jan 21 06:41:57 2010 @@ -235,6 +235,40 @@ + + + org.codehaus.mojo + hibernate3-maven-plugin + 2.2 + + + + + hbm2ddl + jpaconfiguration + + + + juddiDatabase + schema.ddl + false + true + false + true + + + + + --------------------------------------------------------------------- To unsubscribe, e-mail: juddi-cvs-unsubscribe@ws.apache.org For additional commands, e-mail: juddi-cvs-help@ws.apache.org