juddi-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ks...@apache.org
Subject svn commit: r1027648 - in /juddi/trunk/docs/db/ddl: README.txt sybase.dll
Date Tue, 26 Oct 2010 16:56:54 GMT
Author: kstam
Date: Tue Oct 26 16:56:53 2010
New Revision: 1027648

URL: http://svn.apache.org/viewvc?rev=1027648&view=rev
Log:
JUDDI-424, adding script for sybase (which, as expected, ended up being identical to sqlserver)

Added:
    juddi/trunk/docs/db/ddl/sybase.dll
Modified:
    juddi/trunk/docs/db/ddl/README.txt

Modified: juddi/trunk/docs/db/ddl/README.txt
URL: http://svn.apache.org/viewvc/juddi/trunk/docs/db/ddl/README.txt?rev=1027648&r1=1027647&r2=1027648&view=diff
==============================================================================
--- juddi/trunk/docs/db/ddl/README.txt (original)
+++ juddi/trunk/docs/db/ddl/README.txt Tue Oct 26 16:56:53 2010
@@ -13,6 +13,7 @@ MySQL5InnoDBDialect
 Oracle9Dialect
 PostgreSQLDialect
 SQLServerDialect
+Sybase11Dialect
 
 
 

Added: juddi/trunk/docs/db/ddl/sybase.dll
URL: http://svn.apache.org/viewvc/juddi/trunk/docs/db/ddl/sybase.dll?rev=1027648&view=auto
==============================================================================
--- juddi/trunk/docs/db/ddl/sybase.dll (added)
+++ juddi/trunk/docs/db/ddl/sybase.dll Tue Oct 26 16:56:53 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) 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;



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


Mime
View raw message