Attachment 648690 Details for Bug 874669 – jUDDI database DDL upgrade statements

jUDDI database DDL upgrade statements

juddi_db_upgrades.txt (text/plain), 60.65 KB, created by tcunning on 2012-11-20 17:46:04 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: tcunning

Created: 2012-11-20 17:46:04 UTC

Size: 60.65 KB

patch

obsolete

>Index: derby/import.sql
>===================================================================
>--- derby/import.sql	(revision 38244)
>+++ derby/import.sql	(working copy)
>@@ -94,6 +94,12 @@
>         primary key (entity_key)
>     );
> 
>+    create table j3_canonicalization_method (
>+        id bigint not null,
>+        algorithm varchar(255),
>+        primary key (id)
>+    );
>+
>     create table j3_category_bag (
>         id bigint not null,
>         primary key (id)
>@@ -162,6 +168,23 @@
>         primary key (id)
>     );
> 
>+    create table j3_key_data_value (
>+        id bigint not null,
>+        key_data_name varchar(255),
>+        key_data_type varchar(255),
>+        key_data_value blob(255),
>+        key_data_value_string clob(255),
>+        key_data_value_key bigint,
>+        key_info_key bigint,
>+        primary key (id)
>+    );
>+
>+    create table j3_key_info (
>+        id bigint not null,
>+        xml_id varchar(255),
>+        primary key (id)
>+    );
>+
>     create table j3_keyed_reference (
>         id bigint not null,
>         key_name varchar(255),
>@@ -195,6 +218,22 @@
>         primary key (name)
>     );
> 
>+    create table j3_object_type (
>+        id bigint not null,
>+        encoding varchar(255),
>+        mime_type varchar(255),
>+        xml_id varchar(255),
>+        signature_key bigint not null,
>+        primary key (id)
>+    );
>+
>+    create table j3_object_type_content (
>+        id bigint not null,
>+        content blob(255),
>+        object_type_key bigint not null,
>+        primary key (id)
>+    );
>+
>     create table j3_overview_doc (
>         id bigint not null,
>         overview_url varchar(255) not null,
>@@ -252,6 +291,17 @@
>         primary key (from_key, to_key)
>     );
> 
>+    create table j3_reference (
>+        id bigint not null,
>+        digest_method varchar(255),
>+        digest_value blob(255),
>+        type varchar(255),
>+        uri varchar(255),
>+        xml_id varchar(255),
>+        signed_info_key bigint not null,
>+        primary key (id)
>+    );
>+
>     create table j3_service_category_bag (
>         id bigint not null,
>         entity_key varchar(255) not null,
>@@ -281,6 +331,56 @@
>         primary key (business_key, service_key)
>     );
> 
>+    create table j3_signature (
>+        id bigint not null,
>+        xml_id varchar(255),
>+        binding_template_key varchar(255),
>+        business_key varchar(255),
>+        business_service_key varchar(255),
>+        key_info bigint not null,
>+        publisher_key varchar(255),
>+        signature_value bigint not null,
>+        signed_info bigint not null,
>+        tmodel_key varchar(255),
>+        primary key (id)
>+    );
>+
>+    create table j3_signature_method (
>+        id bigint not null,
>+        algorithm varchar(255),
>+        primary key (id)
>+    );
>+
>+    create table j3_signature_transform (
>+        id bigint not null,
>+        transform varchar(255),
>+        reference_key bigint not null,
>+        primary key (id)
>+    );
>+
>+    create table j3_signature_transform_data_value (
>+        id bigint not null,
>+        content_bytes blob(255),
>+        content_type varchar(255),
>+        signature_transform_key bigint not null,
>+        primary key (id)
>+    );
>+
>+    create table j3_signature_value (
>+        id bigint not null,
>+        value_bytes blob(255),
>+        xml_id varchar(255),
>+        primary key (id)
>+    );
>+
>+    create table j3_signed_info (
>+        id bigint not null,
>+        xml_id varchar(255),
>+        canonicalization_method bigint not null,
>+        signature_method bigint not null,
>+        primary key (id)
>+    );
>+
>     create table j3_subscription (
>         subscription_key varchar(255) not null,
>         authorized_name varchar(255) not null,
>@@ -503,6 +603,16 @@
>         foreign key (tmodel_instance_info_id) 
>         references j3_tmodel_instance_info;
> 
>+    alter table j3_key_data_value 
>+        add constraint FK74B7E072843143EF 
>+        foreign key (key_data_value_key) 
>+        references j3_key_data_value;
>+
>+    alter table j3_key_data_value 
>+        add constraint FK74B7E07238C90470 
>+        foreign key (key_info_key) 
>+        references j3_key_info;
>+
>     alter table j3_keyed_reference 
>         add constraint FK350C8454E075C8D7 
>         foreign key (keyed_reference_group_id) 
>@@ -518,6 +628,16 @@
>         foreign key (category_bag_id) 
>         references j3_category_bag;
> 
>+    alter table j3_object_type 
>+        add constraint FK98BBFA04BC6AD65 
>+        foreign key (signature_key) 
>+        references j3_signature;
>+
>+    alter table j3_object_type_content 
>+        add constraint FK987A913E71FA643E 
>+        foreign key (object_type_key) 
>+        references j3_object_type;
>+
>     alter table j3_overview_doc 
>         add constraint FK5CD8D0E8C5BF8903 
>         foreign key (entity_key) 
>@@ -553,6 +673,11 @@
>         foreign key (from_key) 
>         references j3_business_entity;
> 
>+    alter table j3_reference 
>+        add constraint FK493A4F951E480746 
>+        foreign key (signed_info_key) 
>+        references j3_signed_info;
>+
>     alter table j3_service_category_bag 
>         add constraint FK185A68076A68D45A 
>         foreign key (id) 
>@@ -583,6 +708,66 @@
>         foreign key (business_key) 
>         references j3_business_entity;
> 
>+    alter table j3_signature 
>+        add constraint FKC05CA90256E87DED 
>+        foreign key (publisher_key) 
>+        references j3_publisher;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA90271CD8948 
>+        foreign key (binding_template_key) 
>+        references j3_binding_template;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA90212F40D40 
>+        foreign key (business_service_key) 
>+        references j3_business_service;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA9028ACE9A26 
>+        foreign key (signed_info) 
>+        references j3_signed_info;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA9027CE6418E 
>+        foreign key (signature_value) 
>+        references j3_signature_value;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA9025793CF55 
>+        foreign key (tmodel_key) 
>+        references j3_tmodel;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA902DA6C2DD0 
>+        foreign key (key_info) 
>+        references j3_key_info;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA902EF04CFEE 
>+        foreign key (business_key) 
>+        references j3_business_entity;
>+
>+    alter table j3_signature_transform 
>+        add constraint FK726346F9256790B 
>+        foreign key (reference_key) 
>+        references j3_reference;
>+
>+    alter table j3_signature_transform_data_value 
>+        add constraint FK3242526C7B88B2A4 
>+        foreign key (signature_transform_key) 
>+        references j3_signature_transform;
>+
>+    alter table j3_signed_info 
>+        add constraint FKD2E7E5BB877110CC 
>+        foreign key (canonicalization_method) 
>+        references j3_canonicalization_method;
>+
>+    alter table j3_signed_info 
>+        add constraint FKD2E7E5BB1A25896 
>+        foreign key (signature_method) 
>+        references j3_signature_method;
>+
>     alter table j3_subscription_match 
>         add constraint FK5B9C2F19BEEE42E5 
>         foreign key (subscription_key) 
>Index: mysql/import.sql
>===================================================================
>--- mysql/import.sql	(revision 38244)
>+++ mysql/import.sql	(working copy)
>@@ -94,6 +94,12 @@
>         primary key (entity_key)
>     );
> 
>+    create table j3_canonicalization_method (
>+        id bigint not null auto_increment,
>+        algorithm varchar(255),
>+        primary key (id)
>+    );
>+
>     create table j3_category_bag (
>         id bigint not null auto_increment,
>         primary key (id)
>@@ -162,6 +168,23 @@
>         primary key (id)
>     );
> 
>+    create table j3_key_data_value (
>+        id bigint not null auto_increment,
>+        key_data_name varchar(255),
>+        key_data_type varchar(255),
>+        key_data_value longblob,
>+        key_data_value_string longtext,
>+        key_data_value_key bigint,
>+        key_info_key bigint,
>+        primary key (id)
>+    );
>+
>+    create table j3_key_info (
>+        id bigint not null auto_increment,
>+        xml_id varchar(255),
>+        primary key (id)
>+    );
>+
>     create table j3_keyed_reference (
>         id bigint not null auto_increment,
>         key_name varchar(255),
>@@ -195,6 +218,22 @@
>         primary key (name)
>     );
> 
>+    create table j3_object_type (
>+        id bigint not null auto_increment,
>+        encoding varchar(255),
>+        mime_type varchar(255),
>+        xml_id varchar(255),
>+        signature_key bigint not null,
>+        primary key (id)
>+    );
>+
>+    create table j3_object_type_content (
>+        id bigint not null auto_increment,
>+        content longblob,
>+        object_type_key bigint not null,
>+        primary key (id)
>+    );
>+
>     create table j3_overview_doc (
>         id bigint not null auto_increment,
>         overview_url varchar(255) not null,
>@@ -252,6 +291,17 @@
>         primary key (from_key, to_key)
>     );
> 
>+    create table j3_reference (
>+        id bigint not null auto_increment,
>+        digest_method varchar(255),
>+        digest_value longblob,
>+        type varchar(255),
>+        uri varchar(255),
>+        xml_id varchar(255),
>+        signed_info_key bigint not null,
>+        primary key (id)
>+    );
>+
>     create table j3_service_category_bag (
>         id bigint not null,
>         entity_key varchar(255) not null,
>@@ -281,6 +331,56 @@
>         primary key (business_key, service_key)
>     );
> 
>+    create table j3_signature (
>+        id bigint not null auto_increment,
>+        xml_id varchar(255),
>+        binding_template_key varchar(255),
>+        business_key varchar(255),
>+        business_service_key varchar(255),
>+        key_info bigint not null,
>+        publisher_key varchar(255),
>+        signature_value bigint not null,
>+        signed_info bigint not null,
>+        tmodel_key varchar(255),
>+        primary key (id)
>+    );
>+
>+    create table j3_signature_method (
>+        id bigint not null auto_increment,
>+        algorithm varchar(255),
>+        primary key (id)
>+    );
>+
>+    create table j3_signature_transform (
>+        id bigint not null auto_increment,
>+        transform varchar(255),
>+        reference_key bigint not null,
>+        primary key (id)
>+    );
>+
>+    create table j3_signature_transform_data_value (
>+        id bigint not null auto_increment,
>+        content_bytes longblob,
>+        content_type varchar(255),
>+        signature_transform_key bigint not null,
>+        primary key (id)
>+    );
>+
>+    create table j3_signature_value (
>+        id bigint not null auto_increment,
>+        value_bytes longblob,
>+        xml_id varchar(255),
>+        primary key (id)
>+    );
>+
>+    create table j3_signed_info (
>+        id bigint not null auto_increment,
>+        xml_id varchar(255),
>+        canonicalization_method bigint not null,
>+        signature_method bigint not null,
>+        primary key (id)
>+    );
>+
>     create table j3_subscription (
>         subscription_key varchar(255) not null,
>         authorized_name varchar(255) not null,
>@@ -527,6 +627,18 @@
>         foreign key (tmodel_instance_info_id) 
>         references j3_tmodel_instance_info (id);
> 
>+    alter table j3_key_data_value 
>+        add index FK74B7E072843143EF (key_data_value_key), 
>+        add constraint FK74B7E072843143EF 
>+        foreign key (key_data_value_key) 
>+        references j3_key_data_value (id);
>+
>+    alter table j3_key_data_value 
>+        add index FK74B7E07238C90470 (key_info_key), 
>+        add constraint FK74B7E07238C90470 
>+        foreign key (key_info_key) 
>+        references j3_key_info (id);
>+
>     alter table j3_keyed_reference 
>         add index FK350C8454E075C8D7 (keyed_reference_group_id), 
>         add constraint FK350C8454E075C8D7 
>@@ -545,6 +657,18 @@
>         foreign key (category_bag_id) 
>         references j3_category_bag (id);
> 
>+    alter table j3_object_type 
>+        add index FK98BBFA04BC6AD65 (signature_key), 
>+        add constraint FK98BBFA04BC6AD65 
>+        foreign key (signature_key) 
>+        references j3_signature (id);
>+
>+    alter table j3_object_type_content 
>+        add index FK987A913E71FA643E (object_type_key), 
>+        add constraint FK987A913E71FA643E 
>+        foreign key (object_type_key) 
>+        references j3_object_type (id);
>+
>     alter table j3_overview_doc 
>         add index FK5CD8D0E8C5BF8903 (entity_key), 
>         add constraint FK5CD8D0E8C5BF8903 
>@@ -587,6 +711,12 @@
>         foreign key (from_key) 
>         references j3_business_entity (entity_key);
> 
>+    alter table j3_reference 
>+        add index FK493A4F951E480746 (signed_info_key), 
>+        add constraint FK493A4F951E480746 
>+        foreign key (signed_info_key) 
>+        references j3_signed_info (id);
>+
>     alter table j3_service_category_bag 
>         add index FK185A68076A68D45A (id), 
>         add constraint FK185A68076A68D45A 
>@@ -623,6 +753,78 @@
>         foreign key (business_key) 
>         references j3_business_entity (entity_key);
> 
>+    alter table j3_signature 
>+        add index FKC05CA90256E87DED (publisher_key), 
>+        add constraint FKC05CA90256E87DED 
>+        foreign key (publisher_key) 
>+        references j3_publisher (authorized_name);
>+
>+    alter table j3_signature 
>+        add index FKC05CA90271CD8948 (binding_template_key), 
>+        add constraint FKC05CA90271CD8948 
>+        foreign key (binding_template_key) 
>+        references j3_binding_template (entity_key);
>+
>+    alter table j3_signature 
>+        add index FKC05CA90212F40D40 (business_service_key), 
>+        add constraint FKC05CA90212F40D40 
>+        foreign key (business_service_key) 
>+        references j3_business_service (entity_key);
>+
>+    alter table j3_signature 
>+        add index FKC05CA9028ACE9A26 (signed_info), 
>+        add constraint FKC05CA9028ACE9A26 
>+        foreign key (signed_info) 
>+        references j3_signed_info (id);
>+
>+    alter table j3_signature 
>+        add index FKC05CA9027CE6418E (signature_value), 
>+        add constraint FKC05CA9027CE6418E 
>+        foreign key (signature_value) 
>+        references j3_signature_value (id);
>+
>+    alter table j3_signature 
>+        add index FKC05CA9025793CF55 (tmodel_key), 
>+        add constraint FKC05CA9025793CF55 
>+        foreign key (tmodel_key) 
>+        references j3_tmodel (entity_key);
>+
>+    alter table j3_signature 
>+        add index FKC05CA902DA6C2DD0 (key_info), 
>+        add constraint FKC05CA902DA6C2DD0 
>+        foreign key (key_info) 
>+        references j3_key_info (id);
>+
>+    alter table j3_signature 
>+        add index FKC05CA902EF04CFEE (business_key), 
>+        add constraint FKC05CA902EF04CFEE 
>+        foreign key (business_key) 
>+        references j3_business_entity (entity_key);
>+
>+    alter table j3_signature_transform 
>+        add index FK726346F9256790B (reference_key), 
>+        add constraint FK726346F9256790B 
>+        foreign key (reference_key) 
>+        references j3_reference (id);
>+
>+    alter table j3_signature_transform_data_value 
>+        add index FK3242526C7B88B2A4 (signature_transform_key), 
>+        add constraint FK3242526C7B88B2A4 
>+        foreign key (signature_transform_key) 
>+        references j3_signature_transform (id);
>+
>+    alter table j3_signed_info 
>+        add index FKD2E7E5BB877110CC (canonicalization_method), 
>+        add constraint FKD2E7E5BB877110CC 
>+        foreign key (canonicalization_method) 
>+        references j3_canonicalization_method (id);
>+
>+    alter table j3_signed_info 
>+        add index FKD2E7E5BB1A25896 (signature_method), 
>+        add constraint FKD2E7E5BB1A25896 
>+        foreign key (signature_method) 
>+        references j3_signature_method (id);
>+
>     alter table j3_subscription_match 
>         add index FK5B9C2F19BEEE42E5 (subscription_key), 
>         add constraint FK5B9C2F19BEEE42E5 
>Index: postgres/import.sql
>===================================================================
>--- postgres/import.sql	(revision 38244)
>+++ postgres/import.sql	(working copy)
>@@ -94,6 +94,12 @@
>         primary key (entity_key)
>     );
> 
>+    create table j3_canonicalization_method (
>+        id int8 not null,
>+        algorithm varchar(255),
>+        primary key (id)
>+    );
>+
>     create table j3_category_bag (
>         id int8 not null,
>         primary key (id)
>@@ -162,6 +168,23 @@
>         primary key (id)
>     );
> 
>+    create table j3_key_data_value (
>+        id int8 not null,
>+        key_data_name varchar(255),
>+        key_data_type varchar(255),
>+        key_data_value oid,
>+        key_data_value_string text,
>+        key_data_value_key int8,
>+        key_info_key int8,
>+        primary key (id)
>+    );
>+
>+    create table j3_key_info (
>+        id int8 not null,
>+        xml_id varchar(255),
>+        primary key (id)
>+    );
>+
>     create table j3_keyed_reference (
>         id int8 not null,
>         key_name varchar(255),
>@@ -195,6 +218,22 @@
>         primary key (name)
>     );
> 
>+    create table j3_object_type (
>+        id int8 not null,
>+        encoding varchar(255),
>+        mime_type varchar(255),
>+        xml_id varchar(255),
>+        signature_key int8 not null,
>+        primary key (id)
>+    );
>+
>+    create table j3_object_type_content (
>+        id int8 not null,
>+        content oid,
>+        object_type_key int8 not null,
>+        primary key (id)
>+    );
>+
>     create table j3_overview_doc (
>         id int8 not null,
>         overview_url varchar(255) not null,
>@@ -252,6 +291,17 @@
>         primary key (from_key, to_key)
>     );
> 
>+    create table j3_reference (
>+        id int8 not null,
>+        digest_method varchar(255),
>+        digest_value oid,
>+        type varchar(255),
>+        uri varchar(255),
>+        xml_id varchar(255),
>+        signed_info_key int8 not null,
>+        primary key (id)
>+    );
>+
>     create table j3_service_category_bag (
>         id int8 not null,
>         entity_key varchar(255) not null,
>@@ -281,6 +331,56 @@
>         primary key (business_key, service_key)
>     );
> 
>+    create table j3_signature (
>+        id int8 not null,
>+        xml_id varchar(255),
>+        binding_template_key varchar(255),
>+        business_key varchar(255),
>+        business_service_key varchar(255),
>+        key_info int8 not null,
>+        publisher_key varchar(255),
>+        signature_value int8 not null,
>+        signed_info int8 not null,
>+        tmodel_key varchar(255),
>+        primary key (id)
>+    );
>+
>+    create table j3_signature_method (
>+        id int8 not null,
>+        algorithm varchar(255),
>+        primary key (id)
>+    );
>+
>+    create table j3_signature_transform (
>+        id int8 not null,
>+        transform varchar(255),
>+        reference_key int8 not null,
>+        primary key (id)
>+    );
>+
>+    create table j3_signature_transform_data_value (
>+        id int8 not null,
>+        content_bytes oid,
>+        content_type varchar(255),
>+        signature_transform_key int8 not null,
>+        primary key (id)
>+    );
>+
>+    create table j3_signature_value (
>+        id int8 not null,
>+        value_bytes oid,
>+        xml_id varchar(255),
>+        primary key (id)
>+    );
>+
>+    create table j3_signed_info (
>+        id int8 not null,
>+        xml_id varchar(255),
>+        canonicalization_method int8 not null,
>+        signature_method int8 not null,
>+        primary key (id)
>+    );
>+
>     create table j3_subscription (
>         subscription_key varchar(255) not null,
>         authorized_name varchar(255) not null,
>@@ -503,6 +603,16 @@
>         foreign key (tmodel_instance_info_id) 
>         references j3_tmodel_instance_info;
> 
>+    alter table j3_key_data_value 
>+        add constraint FK74B7E072843143EF 
>+        foreign key (key_data_value_key) 
>+        references j3_key_data_value;
>+
>+    alter table j3_key_data_value 
>+        add constraint FK74B7E07238C90470 
>+        foreign key (key_info_key) 
>+        references j3_key_info;
>+
>     alter table j3_keyed_reference 
>         add constraint FK350C8454E075C8D7 
>         foreign key (keyed_reference_group_id) 
>@@ -518,6 +628,16 @@
>         foreign key (category_bag_id) 
>         references j3_category_bag;
> 
>+    alter table j3_object_type 
>+        add constraint FK98BBFA04BC6AD65 
>+        foreign key (signature_key) 
>+        references j3_signature;
>+
>+    alter table j3_object_type_content 
>+        add constraint FK987A913E71FA643E 
>+        foreign key (object_type_key) 
>+        references j3_object_type;
>+
>     alter table j3_overview_doc 
>         add constraint FK5CD8D0E8C5BF8903 
>         foreign key (entity_key) 
>@@ -553,6 +673,11 @@
>         foreign key (from_key) 
>         references j3_business_entity;
> 
>+    alter table j3_reference 
>+        add constraint FK493A4F951E480746 
>+        foreign key (signed_info_key) 
>+        references j3_signed_info;
>+
>     alter table j3_service_category_bag 
>         add constraint FK185A68076A68D45A 
>         foreign key (id) 
>@@ -583,6 +708,66 @@
>         foreign key (business_key) 
>         references j3_business_entity;
> 
>+    alter table j3_signature 
>+        add constraint FKC05CA90256E87DED 
>+        foreign key (publisher_key) 
>+        references j3_publisher;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA90271CD8948 
>+        foreign key (binding_template_key) 
>+        references j3_binding_template;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA90212F40D40 
>+        foreign key (business_service_key) 
>+        references j3_business_service;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA9028ACE9A26 
>+        foreign key (signed_info) 
>+        references j3_signed_info;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA9027CE6418E 
>+        foreign key (signature_value) 
>+        references j3_signature_value;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA9025793CF55 
>+        foreign key (tmodel_key) 
>+        references j3_tmodel;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA902DA6C2DD0 
>+        foreign key (key_info) 
>+        references j3_key_info;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA902EF04CFEE 
>+        foreign key (business_key) 
>+        references j3_business_entity;
>+
>+    alter table j3_signature_transform 
>+        add constraint FK726346F9256790B 
>+        foreign key (reference_key) 
>+        references j3_reference;
>+
>+    alter table j3_signature_transform_data_value 
>+        add constraint FK3242526C7B88B2A4 
>+        foreign key (signature_transform_key) 
>+        references j3_signature_transform;
>+
>+    alter table j3_signed_info 
>+        add constraint FKD2E7E5BB877110CC 
>+        foreign key (canonicalization_method) 
>+        references j3_canonicalization_method;
>+
>+    alter table j3_signed_info 
>+        add constraint FKD2E7E5BB1A25896 
>+        foreign key (signature_method) 
>+        references j3_signature_method;
>+
>     alter table j3_subscription_match 
>         add constraint FK5B9C2F19BEEE42E5 
>         foreign key (subscription_key) 
>Index: sqlserver/import.sql
>===================================================================
>--- sqlserver/import.sql	(revision 38244)
>+++ sqlserver/import.sql	(working copy)
>@@ -94,6 +94,12 @@
>         primary key (entity_key)
>     );
> 
>+    create table j3_canonicalization_method (
>+        id numeric(19,0) identity not null,
>+        algorithm varchar(255) null,
>+        primary key (id)
>+    );
>+
>     create table j3_category_bag (
>         id numeric(19,0) identity not null,
>         primary key (id)
>@@ -162,6 +168,23 @@
>         primary key (id)
>     );
> 
>+    create table j3_key_data_value (
>+        id numeric(19,0) identity not null,
>+        key_data_name varchar(255) null,
>+        key_data_type varchar(255) null,
>+        key_data_value image null,
>+        key_data_value_string text null,
>+        key_data_value_key numeric(19,0) null,
>+        key_info_key numeric(19,0) null,
>+        primary key (id)
>+    );
>+
>+    create table j3_key_info (
>+        id numeric(19,0) identity not null,
>+        xml_id varchar(255) null,
>+        primary key (id)
>+    );
>+
>     create table j3_keyed_reference (
>         id numeric(19,0) identity not null,
>         key_name varchar(255) null,
>@@ -195,6 +218,22 @@
>         primary key (name)
>     );
> 
>+    create table j3_object_type (
>+        id numeric(19,0) identity not null,
>+        encoding varchar(255) null,
>+        mime_type varchar(255) null,
>+        xml_id varchar(255) null,
>+        signature_key numeric(19,0) not null,
>+        primary key (id)
>+    );
>+
>+    create table j3_object_type_content (
>+        id numeric(19,0) identity not null,
>+        content image null,
>+        object_type_key numeric(19,0) not null,
>+        primary key (id)
>+    );
>+
>     create table j3_overview_doc (
>         id numeric(19,0) identity not null,
>         overview_url varchar(255) not null,
>@@ -252,6 +291,17 @@
>         primary key (from_key, to_key)
>     );
> 
>+    create table j3_reference (
>+        id numeric(19,0) identity not null,
>+        digest_method varchar(255) null,
>+        digest_value image null,
>+        type varchar(255) null,
>+        uri varchar(255) null,
>+        xml_id varchar(255) null,
>+        signed_info_key numeric(19,0) not null,
>+        primary key (id)
>+    );
>+
>     create table j3_service_category_bag (
>         id numeric(19,0) not null,
>         entity_key varchar(255) not null,
>@@ -281,6 +331,56 @@
>         primary key (business_key, service_key)
>     );
> 
>+    create table j3_signature (
>+        id numeric(19,0) identity not null,
>+        xml_id varchar(255) null,
>+        binding_template_key varchar(255) null,
>+        business_key varchar(255) null,
>+        business_service_key varchar(255) null,
>+        key_info numeric(19,0) not null,
>+        publisher_key varchar(255) null,
>+        signature_value numeric(19,0) not null,
>+        signed_info numeric(19,0) not null,
>+        tmodel_key varchar(255) null,
>+        primary key (id)
>+    );
>+
>+    create table j3_signature_method (
>+        id numeric(19,0) identity not null,
>+        algorithm varchar(255) null,
>+        primary key (id)
>+    );
>+
>+    create table j3_signature_transform (
>+        id numeric(19,0) identity not null,
>+        transform varchar(255) null,
>+        reference_key numeric(19,0) not null,
>+        primary key (id)
>+    );
>+
>+    create table j3_signature_transform_data_value (
>+        id numeric(19,0) identity not null,
>+        content_bytes image null,
>+        content_type varchar(255) null,
>+        signature_transform_key numeric(19,0) not null,
>+        primary key (id)
>+    );
>+
>+    create table j3_signature_value (
>+        id numeric(19,0) identity not null,
>+        value_bytes image null,
>+        xml_id varchar(255) null,
>+        primary key (id)
>+    );
>+
>+    create table j3_signed_info (
>+        id numeric(19,0) identity not null,
>+        xml_id varchar(255) null,
>+        canonicalization_method numeric(19,0) not null,
>+        signature_method numeric(19,0) not null,
>+        primary key (id)
>+    );
>+
>     create table j3_subscription (
>         subscription_key varchar(255) not null,
>         authorized_name varchar(255) not null,
>@@ -503,6 +603,16 @@
>         foreign key (tmodel_instance_info_id) 
>         references j3_tmodel_instance_info;
> 
>+    alter table j3_key_data_value 
>+        add constraint FK74B7E072843143EF 
>+        foreign key (key_data_value_key) 
>+        references j3_key_data_value;
>+
>+    alter table j3_key_data_value 
>+        add constraint FK74B7E07238C90470 
>+        foreign key (key_info_key) 
>+        references j3_key_info;
>+
>     alter table j3_keyed_reference 
>         add constraint FK350C8454E075C8D7 
>         foreign key (keyed_reference_group_id) 
>@@ -518,6 +628,16 @@
>         foreign key (category_bag_id) 
>         references j3_category_bag;
> 
>+    alter table j3_object_type 
>+        add constraint FK98BBFA04BC6AD65 
>+        foreign key (signature_key) 
>+        references j3_signature;
>+
>+    alter table j3_object_type_content 
>+        add constraint FK987A913E71FA643E 
>+        foreign key (object_type_key) 
>+        references j3_object_type;
>+
>     alter table j3_overview_doc 
>         add constraint FK5CD8D0E8C5BF8903 
>         foreign key (entity_key) 
>@@ -553,6 +673,11 @@
>         foreign key (from_key) 
>         references j3_business_entity;
> 
>+    alter table j3_reference 
>+        add constraint FK493A4F951E480746 
>+        foreign key (signed_info_key) 
>+        references j3_signed_info;
>+
>     alter table j3_service_category_bag 
>         add constraint FK185A68076A68D45A 
>         foreign key (id) 
>@@ -583,6 +708,66 @@
>         foreign key (business_key) 
>         references j3_business_entity;
> 
>+    alter table j3_signature 
>+        add constraint FKC05CA90256E87DED 
>+        foreign key (publisher_key) 
>+        references j3_publisher;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA90271CD8948 
>+        foreign key (binding_template_key) 
>+        references j3_binding_template;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA90212F40D40 
>+        foreign key (business_service_key) 
>+        references j3_business_service;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA9028ACE9A26 
>+        foreign key (signed_info) 
>+        references j3_signed_info;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA9027CE6418E 
>+        foreign key (signature_value) 
>+        references j3_signature_value;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA9025793CF55 
>+        foreign key (tmodel_key) 
>+        references j3_tmodel;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA902DA6C2DD0 
>+        foreign key (key_info) 
>+        references j3_key_info;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA902EF04CFEE 
>+        foreign key (business_key) 
>+        references j3_business_entity;
>+
>+    alter table j3_signature_transform 
>+        add constraint FK726346F9256790B 
>+        foreign key (reference_key) 
>+        references j3_reference;
>+
>+    alter table j3_signature_transform_data_value 
>+        add constraint FK3242526C7B88B2A4 
>+        foreign key (signature_transform_key) 
>+        references j3_signature_transform;
>+
>+    alter table j3_signed_info 
>+        add constraint FKD2E7E5BB877110CC 
>+        foreign key (canonicalization_method) 
>+        references j3_canonicalization_method;
>+
>+    alter table j3_signed_info 
>+        add constraint FKD2E7E5BB1A25896 
>+        foreign key (signature_method) 
>+        references j3_signature_method;
>+
>     alter table j3_subscription_match 
>         add constraint FK5B9C2F19BEEE42E5 
>         foreign key (subscription_key) 
>Index: sybase/import.sql
>===================================================================
>--- sybase/import.sql	(revision 38244)
>+++ sybase/import.sql	(working copy)
>@@ -94,6 +94,12 @@
>         primary key (entity_key)
>     );
> 
>+    create table j3_canonicalization_method (
>+        id numeric(19,0) identity not null,
>+        algorithm varchar(255) null,
>+        primary key (id)
>+    );
>+
>     create table j3_category_bag (
>         id numeric(19,0) identity not null,
>         primary key (id)
>@@ -162,6 +168,23 @@
>         primary key (id)
>     );
> 
>+    create table j3_key_data_value (
>+        id numeric(19,0) identity not null,
>+        key_data_name varchar(255) null,
>+        key_data_type varchar(255) null,
>+        key_data_value image null,
>+        key_data_value_string text null,
>+        key_data_value_key numeric(19,0) null,
>+        key_info_key numeric(19,0) null,
>+        primary key (id)
>+    );
>+
>+    create table j3_key_info (
>+        id numeric(19,0) identity not null,
>+        xml_id varchar(255) null,
>+        primary key (id)
>+    );
>+
>     create table j3_keyed_reference (
>         id numeric(19,0) identity not null,
>         key_name varchar(255) null,
>@@ -195,6 +218,22 @@
>         primary key (name)
>     );
> 
>+    create table j3_object_type (
>+        id numeric(19,0) identity not null,
>+        encoding varchar(255) null,
>+        mime_type varchar(255) null,
>+        xml_id varchar(255) null,
>+        signature_key numeric(19,0) not null,
>+        primary key (id)
>+    );
>+
>+    create table j3_object_type_content (
>+        id numeric(19,0) identity not null,
>+        content image null,
>+        object_type_key numeric(19,0) not null,
>+        primary key (id)
>+    );
>+
>     create table j3_overview_doc (
>         id numeric(19,0) identity not null,
>         overview_url varchar(255) not null,
>@@ -252,6 +291,17 @@
>         primary key (from_key, to_key)
>     );
> 
>+    create table j3_reference (
>+        id numeric(19,0) identity not null,
>+        digest_method varchar(255) null,
>+        digest_value image null,
>+        type varchar(255) null,
>+        uri varchar(255) null,
>+        xml_id varchar(255) null,
>+        signed_info_key numeric(19,0) not null,
>+        primary key (id)
>+    );
>+
>     create table j3_service_category_bag (
>         id numeric(19,0) not null,
>         entity_key varchar(255) not null,
>@@ -281,6 +331,56 @@
>         primary key (business_key, service_key)
>     );
> 
>+    create table j3_signature (
>+        id numeric(19,0) identity not null,
>+        xml_id varchar(255) null,
>+        binding_template_key varchar(255) null,
>+        business_key varchar(255) null,
>+        business_service_key varchar(255) null,
>+        key_info numeric(19,0) not null,
>+        publisher_key varchar(255) null,
>+        signature_value numeric(19,0) not null,
>+        signed_info numeric(19,0) not null,
>+        tmodel_key varchar(255) null,
>+        primary key (id)
>+    );
>+
>+    create table j3_signature_method (
>+        id numeric(19,0) identity not null,
>+        algorithm varchar(255) null,
>+        primary key (id)
>+    );
>+
>+    create table j3_signature_transform (
>+        id numeric(19,0) identity not null,
>+        transform varchar(255) null,
>+        reference_key numeric(19,0) not null,
>+        primary key (id)
>+    );
>+
>+    create table j3_signature_transform_data_value (
>+        id numeric(19,0) identity not null,
>+        content_bytes image null,
>+        content_type varchar(255) null,
>+        signature_transform_key numeric(19,0) not null,
>+        primary key (id)
>+    );
>+
>+    create table j3_signature_value (
>+        id numeric(19,0) identity not null,
>+        value_bytes image null,
>+        xml_id varchar(255) null,
>+        primary key (id)
>+    );
>+
>+    create table j3_signed_info (
>+        id numeric(19,0) identity not null,
>+        xml_id varchar(255) null,
>+        canonicalization_method numeric(19,0) not null,
>+        signature_method numeric(19,0) not null,
>+        primary key (id)
>+    );
>+
>     create table j3_subscription (
>         subscription_key varchar(255) not null,
>         authorized_name varchar(255) not null,
>@@ -503,6 +603,16 @@
>         foreign key (tmodel_instance_info_id) 
>         references j3_tmodel_instance_info;
> 
>+    alter table j3_key_data_value 
>+        add constraint FK74B7E072843143EF 
>+        foreign key (key_data_value_key) 
>+        references j3_key_data_value;
>+
>+    alter table j3_key_data_value 
>+        add constraint FK74B7E07238C90470 
>+        foreign key (key_info_key) 
>+        references j3_key_info;
>+
>     alter table j3_keyed_reference 
>         add constraint FK350C8454E075C8D7 
>         foreign key (keyed_reference_group_id) 
>@@ -518,6 +628,16 @@
>         foreign key (category_bag_id) 
>         references j3_category_bag;
> 
>+    alter table j3_object_type 
>+        add constraint FK98BBFA04BC6AD65 
>+        foreign key (signature_key) 
>+        references j3_signature;
>+
>+    alter table j3_object_type_content 
>+        add constraint FK987A913E71FA643E 
>+        foreign key (object_type_key) 
>+        references j3_object_type;
>+
>     alter table j3_overview_doc 
>         add constraint FK5CD8D0E8C5BF8903 
>         foreign key (entity_key) 
>@@ -553,6 +673,11 @@
>         foreign key (from_key) 
>         references j3_business_entity;
> 
>+    alter table j3_reference 
>+        add constraint FK493A4F951E480746 
>+        foreign key (signed_info_key) 
>+        references j3_signed_info;
>+
>     alter table j3_service_category_bag 
>         add constraint FK185A68076A68D45A 
>         foreign key (id) 
>@@ -583,6 +708,66 @@
>         foreign key (business_key) 
>         references j3_business_entity;
> 
>+    alter table j3_signature 
>+        add constraint FKC05CA90256E87DED 
>+        foreign key (publisher_key) 
>+        references j3_publisher;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA90271CD8948 
>+        foreign key (binding_template_key) 
>+        references j3_binding_template;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA90212F40D40 
>+        foreign key (business_service_key) 
>+        references j3_business_service;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA9028ACE9A26 
>+        foreign key (signed_info) 
>+        references j3_signed_info;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA9027CE6418E 
>+        foreign key (signature_value) 
>+        references j3_signature_value;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA9025793CF55 
>+        foreign key (tmodel_key) 
>+        references j3_tmodel;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA902DA6C2DD0 
>+        foreign key (key_info) 
>+        references j3_key_info;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA902EF04CFEE 
>+        foreign key (business_key) 
>+        references j3_business_entity;
>+
>+    alter table j3_signature_transform 
>+        add constraint FK726346F9256790B 
>+        foreign key (reference_key) 
>+        references j3_reference;
>+
>+    alter table j3_signature_transform_data_value 
>+        add constraint FK3242526C7B88B2A4 
>+        foreign key (signature_transform_key) 
>+        references j3_signature_transform;
>+
>+    alter table j3_signed_info 
>+        add constraint FKD2E7E5BB877110CC 
>+        foreign key (canonicalization_method) 
>+        references j3_canonicalization_method;
>+
>+    alter table j3_signed_info 
>+        add constraint FKD2E7E5BB1A25896 
>+        foreign key (signature_method) 
>+        references j3_signature_method;
>+
>     alter table j3_subscription_match 
>         add constraint FK5B9C2F19BEEE42E5 
>         foreign key (subscription_key) 
>Index: db2/import.sql
>===================================================================
>--- db2/import.sql	(revision 38244)
>+++ db2/import.sql	(working copy)
>@@ -94,6 +94,12 @@
>         primary key (entity_key)
>     );
> 
>+    create table j3_canonicalization_method (
>+        id bigint generated by default as identity,
>+        algorithm varchar(255),
>+        primary key (id)
>+    );
>+
>     create table j3_category_bag (
>         id bigint generated by default as identity,
>         primary key (id)
>@@ -162,6 +168,23 @@
>         primary key (id)
>     );
> 
>+    create table j3_key_data_value (
>+        id bigint generated by default as identity,
>+        key_data_name varchar(255),
>+        key_data_type varchar(255),
>+        key_data_value blob(255),
>+        key_data_value_string clob(255),
>+        key_data_value_key bigint,
>+        key_info_key bigint,
>+        primary key (id)
>+    );
>+
>+    create table j3_key_info (
>+        id bigint generated by default as identity,
>+        xml_id varchar(255),
>+        primary key (id)
>+    );
>+
>     create table j3_keyed_reference (
>         id bigint generated by default as identity,
>         key_name varchar(255),
>@@ -195,6 +218,22 @@
>         primary key (name)
>     );
> 
>+    create table j3_object_type (
>+        id bigint generated by default as identity,
>+        encoding varchar(255),
>+        mime_type varchar(255),
>+        xml_id varchar(255),
>+        signature_key bigint not null,
>+        primary key (id)
>+    );
>+
>+    create table j3_object_type_content (
>+        id bigint generated by default as identity,
>+        content blob(255),
>+        object_type_key bigint not null,
>+        primary key (id)
>+    );
>+
>     create table j3_overview_doc (
>         id bigint generated by default as identity,
>         overview_url varchar(255) not null,
>@@ -252,6 +291,17 @@
>         primary key (from_key, to_key)
>     );
> 
>+    create table j3_reference (
>+        id bigint generated by default as identity,
>+        digest_method varchar(255),
>+        digest_value blob(255),
>+        type varchar(255),
>+        uri varchar(255),
>+        xml_id varchar(255),
>+        signed_info_key bigint not null,
>+        primary key (id)
>+    );
>+
>     create table j3_service_category_bag (
>         id bigint not null,
>         entity_key varchar(255) not null,
>@@ -281,6 +331,56 @@
>         primary key (business_key, service_key)
>     );
> 
>+    create table j3_signature (
>+        id bigint generated by default as identity,
>+        xml_id varchar(255),
>+        binding_template_key varchar(255),
>+        business_key varchar(255),
>+        business_service_key varchar(255),
>+        key_info bigint not null,
>+        publisher_key varchar(255),
>+        signature_value bigint not null,
>+        signed_info bigint not null,
>+        tmodel_key varchar(255),
>+        primary key (id)
>+    );
>+
>+    create table j3_signature_method (
>+        id bigint generated by default as identity,
>+        algorithm varchar(255),
>+        primary key (id)
>+    );
>+
>+    create table j3_signature_transform (
>+        id bigint generated by default as identity,
>+        transform varchar(255),
>+        reference_key bigint not null,
>+        primary key (id)
>+    );
>+
>+    create table j3_signature_transform_data_value (
>+        id bigint generated by default as identity,
>+        content_bytes blob(255),
>+        content_type varchar(255),
>+        signature_transform_key bigint not null,
>+        primary key (id)
>+    );
>+
>+    create table j3_signature_value (
>+        id bigint generated by default as identity,
>+        value_bytes blob(255),
>+        xml_id varchar(255),
>+        primary key (id)
>+    );
>+
>+    create table j3_signed_info (
>+        id bigint generated by default as identity,
>+        xml_id varchar(255),
>+        canonicalization_method bigint not null,
>+        signature_method bigint not null,
>+        primary key (id)
>+    );
>+
>     create table j3_subscription (
>         subscription_key varchar(255) not null,
>         authorized_name varchar(255) not null,
>@@ -503,6 +603,16 @@
>         foreign key (tmodel_instance_info_id) 
>         references j3_tmodel_instance_info;
> 
>+    alter table j3_key_data_value 
>+        add constraint FK74B7E072843143EF 
>+        foreign key (key_data_value_key) 
>+        references j3_key_data_value;
>+
>+    alter table j3_key_data_value 
>+        add constraint FK74B7E07238C90470 
>+        foreign key (key_info_key) 
>+        references j3_key_info;
>+
>     alter table j3_keyed_reference 
>         add constraint FK350C8454E075C8D7 
>         foreign key (keyed_reference_group_id) 
>@@ -518,6 +628,16 @@
>         foreign key (category_bag_id) 
>         references j3_category_bag;
> 
>+    alter table j3_object_type 
>+        add constraint FK98BBFA04BC6AD65 
>+        foreign key (signature_key) 
>+        references j3_signature;
>+
>+    alter table j3_object_type_content 
>+        add constraint FK987A913E71FA643E 
>+        foreign key (object_type_key) 
>+        references j3_object_type;
>+
>     alter table j3_overview_doc 
>         add constraint FK5CD8D0E8C5BF8903 
>         foreign key (entity_key) 
>@@ -553,6 +673,11 @@
>         foreign key (from_key) 
>         references j3_business_entity;
> 
>+    alter table j3_reference 
>+        add constraint FK493A4F951E480746 
>+        foreign key (signed_info_key) 
>+        references j3_signed_info;
>+
>     alter table j3_service_category_bag 
>         add constraint FK185A68076A68D45A 
>         foreign key (id) 
>@@ -583,6 +708,66 @@
>         foreign key (business_key) 
>         references j3_business_entity;
> 
>+    alter table j3_signature 
>+        add constraint FKC05CA90256E87DED 
>+        foreign key (publisher_key) 
>+        references j3_publisher;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA90271CD8948 
>+        foreign key (binding_template_key) 
>+        references j3_binding_template;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA90212F40D40 
>+        foreign key (business_service_key) 
>+        references j3_business_service;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA9028ACE9A26 
>+        foreign key (signed_info) 
>+        references j3_signed_info;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA9027CE6418E 
>+        foreign key (signature_value) 
>+        references j3_signature_value;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA9025793CF55 
>+        foreign key (tmodel_key) 
>+        references j3_tmodel;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA902DA6C2DD0 
>+        foreign key (key_info) 
>+        references j3_key_info;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA902EF04CFEE 
>+        foreign key (business_key) 
>+        references j3_business_entity;
>+
>+    alter table j3_signature_transform 
>+        add constraint FK726346F9256790B 
>+        foreign key (reference_key) 
>+        references j3_reference;
>+
>+    alter table j3_signature_transform_data_value 
>+        add constraint FK3242526C7B88B2A4 
>+        foreign key (signature_transform_key) 
>+        references j3_signature_transform;
>+
>+    alter table j3_signed_info 
>+        add constraint FKD2E7E5BB877110CC 
>+        foreign key (canonicalization_method) 
>+        references j3_canonicalization_method;
>+
>+    alter table j3_signed_info 
>+        add constraint FKD2E7E5BB1A25896 
>+        foreign key (signature_method) 
>+        references j3_signature_method;
>+
>     alter table j3_subscription_match 
>         add constraint FK5B9C2F19BEEE42E5 
>         foreign key (subscription_key) 
>Index: hsqldb/import.sql
>===================================================================
>--- hsqldb/import.sql	(revision 38244)
>+++ hsqldb/import.sql	(working copy)
>@@ -94,6 +94,12 @@
>         primary key (entity_key)
>     );
> 
>+    create table j3_canonicalization_method (
>+        id bigint generated by default as identity (start with 1),
>+        algorithm varchar(255),
>+        primary key (id)
>+    );
>+
>     create table j3_category_bag (
>         id bigint generated by default as identity (start with 1),
>         primary key (id)
>@@ -162,6 +168,23 @@
>         primary key (id)
>     );
> 
>+    create table j3_key_data_value (
>+        id bigint generated by default as identity (start with 1),
>+        key_data_name varchar(255),
>+        key_data_type varchar(255),
>+        key_data_value longvarbinary not null,
>+        key_data_value_string longvarchar not null,
>+        key_data_value_key bigint,
>+        key_info_key bigint,
>+        primary key (id)
>+    );
>+
>+    create table j3_key_info (
>+        id bigint generated by default as identity (start with 1),
>+        xml_id varchar(255),
>+        primary key (id)
>+    );
>+
>     create table j3_keyed_reference (
>         id bigint generated by default as identity (start with 1),
>         key_name varchar(255),
>@@ -195,6 +218,22 @@
>         primary key (name)
>     );
> 
>+    create table j3_object_type (
>+        id bigint generated by default as identity (start with 1),
>+        encoding varchar(255),
>+        mime_type varchar(255),
>+        xml_id varchar(255),
>+        signature_key bigint not null,
>+        primary key (id)
>+    );
>+
>+    create table j3_object_type_content (
>+        id bigint generated by default as identity (start with 1),
>+        content longvarbinary not null,
>+        object_type_key bigint not null,
>+        primary key (id)
>+    );
>+
>     create table j3_overview_doc (
>         id bigint generated by default as identity (start with 1),
>         overview_url varchar(255) not null,
>@@ -252,6 +291,17 @@
>         primary key (from_key, to_key)
>     );
> 
>+    create table j3_reference (
>+        id bigint generated by default as identity (start with 1),
>+        digest_method varchar(255),
>+        digest_value longvarbinary not null,
>+        type varchar(255),
>+        uri varchar(255),
>+        xml_id varchar(255),
>+        signed_info_key bigint not null,
>+        primary key (id)
>+    );
>+
>     create table j3_service_category_bag (
>         id bigint not null,
>         entity_key varchar(255) not null,
>@@ -281,6 +331,56 @@
>         primary key (business_key, service_key)
>     );
> 
>+    create table j3_signature (
>+        id bigint generated by default as identity (start with 1),
>+        xml_id varchar(255),
>+        binding_template_key varchar(255),
>+        business_key varchar(255),
>+        business_service_key varchar(255),
>+        key_info bigint not null,
>+        publisher_key varchar(255),
>+        signature_value bigint not null,
>+        signed_info bigint not null,
>+        tmodel_key varchar(255),
>+        primary key (id)
>+    );
>+
>+    create table j3_signature_method (
>+        id bigint generated by default as identity (start with 1),
>+        algorithm varchar(255),
>+        primary key (id)
>+    );
>+
>+    create table j3_signature_transform (
>+        id bigint generated by default as identity (start with 1),
>+        transform varchar(255),
>+        reference_key bigint not null,
>+        primary key (id)
>+    );
>+
>+    create table j3_signature_transform_data_value (
>+        id bigint generated by default as identity (start with 1),
>+        content_bytes longvarbinary not null,
>+        content_type varchar(255),
>+        signature_transform_key bigint not null,
>+        primary key (id)
>+    );
>+
>+    create table j3_signature_value (
>+        id bigint generated by default as identity (start with 1),
>+        value_bytes longvarbinary not null,
>+        xml_id varchar(255),
>+        primary key (id)
>+    );
>+
>+    create table j3_signed_info (
>+        id bigint generated by default as identity (start with 1),
>+        xml_id varchar(255),
>+        canonicalization_method bigint not null,
>+        signature_method bigint not null,
>+        primary key (id)
>+    );
>+
>     create table j3_subscription (
>         subscription_key varchar(255) not null,
>         authorized_name varchar(255) not null,
>@@ -503,6 +603,16 @@
>         foreign key (tmodel_instance_info_id) 
>         references j3_tmodel_instance_info;
> 
>+    alter table j3_key_data_value 
>+        add constraint FK74B7E072843143EF 
>+        foreign key (key_data_value_key) 
>+        references j3_key_data_value;
>+
>+    alter table j3_key_data_value 
>+        add constraint FK74B7E07238C90470 
>+        foreign key (key_info_key) 
>+        references j3_key_info;
>+
>     alter table j3_keyed_reference 
>         add constraint FK350C8454E075C8D7 
>         foreign key (keyed_reference_group_id) 
>@@ -518,6 +628,16 @@
>         foreign key (category_bag_id) 
>         references j3_category_bag;
> 
>+    alter table j3_object_type 
>+        add constraint FK98BBFA04BC6AD65 
>+        foreign key (signature_key) 
>+        references j3_signature;
>+
>+    alter table j3_object_type_content 
>+        add constraint FK987A913E71FA643E 
>+        foreign key (object_type_key) 
>+        references j3_object_type;
>+
>     alter table j3_overview_doc 
>         add constraint FK5CD8D0E8C5BF8903 
>         foreign key (entity_key) 
>@@ -553,6 +673,11 @@
>         foreign key (from_key) 
>         references j3_business_entity;
> 
>+    alter table j3_reference 
>+        add constraint FK493A4F951E480746 
>+        foreign key (signed_info_key) 
>+        references j3_signed_info;
>+
>     alter table j3_service_category_bag 
>         add constraint FK185A68076A68D45A 
>         foreign key (id) 
>@@ -583,6 +708,66 @@
>         foreign key (business_key) 
>         references j3_business_entity;
> 
>+    alter table j3_signature 
>+        add constraint FKC05CA90256E87DED 
>+        foreign key (publisher_key) 
>+        references j3_publisher;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA90271CD8948 
>+        foreign key (binding_template_key) 
>+        references j3_binding_template;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA90212F40D40 
>+        foreign key (business_service_key) 
>+        references j3_business_service;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA9028ACE9A26 
>+        foreign key (signed_info) 
>+        references j3_signed_info;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA9027CE6418E 
>+        foreign key (signature_value) 
>+        references j3_signature_value;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA9025793CF55 
>+        foreign key (tmodel_key) 
>+        references j3_tmodel;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA902DA6C2DD0 
>+        foreign key (key_info) 
>+        references j3_key_info;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA902EF04CFEE 
>+        foreign key (business_key) 
>+        references j3_business_entity;
>+
>+    alter table j3_signature_transform 
>+        add constraint FK726346F9256790B 
>+        foreign key (reference_key) 
>+        references j3_reference;
>+
>+    alter table j3_signature_transform_data_value 
>+        add constraint FK3242526C7B88B2A4 
>+        foreign key (signature_transform_key) 
>+        references j3_signature_transform;
>+
>+    alter table j3_signed_info 
>+        add constraint FKD2E7E5BB877110CC 
>+        foreign key (canonicalization_method) 
>+        references j3_canonicalization_method;
>+
>+    alter table j3_signed_info 
>+        add constraint FKD2E7E5BB1A25896 
>+        foreign key (signature_method) 
>+        references j3_signature_method;
>+
>     alter table j3_subscription_match 
>         add constraint FK5B9C2F19BEEE42E5 
>         foreign key (subscription_key) 
>Index: oracle9/import.sql
>===================================================================
>--- oracle9/import.sql	(revision 38244)
>+++ oracle9/import.sql	(working copy)
>@@ -94,6 +94,12 @@
>         primary key (entity_key)
>     );
> 
>+    create table j3_canonicalization_method (
>+        id number(19,0) not null,
>+        algorithm varchar2(255 char),
>+        primary key (id)
>+    );
>+
>     create table j3_category_bag (
>         id number(19,0) not null,
>         primary key (id)
>@@ -162,6 +168,23 @@
>         primary key (id)
>     );
> 
>+    create table j3_key_data_value (
>+        id number(19,0) not null,
>+        key_data_name varchar2(255 char),
>+        key_data_type varchar2(255 char),
>+        key_data_value blob,
>+        key_data_value_string clob,
>+        key_data_value_key number(19,0),
>+        key_info_key number(19,0),
>+        primary key (id)
>+    );
>+
>+    create table j3_key_info (
>+        id number(19,0) not null,
>+        xml_id varchar2(255 char),
>+        primary key (id)
>+    );
>+
>     create table j3_keyed_reference (
>         id number(19,0) not null,
>         key_name varchar2(255 char),
>@@ -195,6 +218,22 @@
>         primary key (name)
>     );
> 
>+    create table j3_object_type (
>+        id number(19,0) not null,
>+        encoding varchar2(255 char),
>+        mime_type varchar2(255 char),
>+        xml_id varchar2(255 char),
>+        signature_key number(19,0) not null,
>+        primary key (id)
>+    );
>+
>+    create table j3_object_type_content (
>+        id number(19,0) not null,
>+        content blob,
>+        object_type_key number(19,0) not null,
>+        primary key (id)
>+    );
>+
>     create table j3_overview_doc (
>         id number(19,0) not null,
>         overview_url varchar2(255 char) not null,
>@@ -252,6 +291,17 @@
>         primary key (from_key, to_key)
>     );
> 
>+    create table j3_reference (
>+        id number(19,0) not null,
>+        digest_method varchar2(255 char),
>+        digest_value blob,
>+        type varchar2(255 char),
>+        uri varchar2(255 char),
>+        xml_id varchar2(255 char),
>+        signed_info_key number(19,0) not null,
>+        primary key (id)
>+    );
>+
>     create table j3_service_category_bag (
>         id number(19,0) not null,
>         entity_key varchar2(255 char) not null,
>@@ -281,6 +331,56 @@
>         primary key (business_key, service_key)
>     );
> 
>+    create table j3_signature (
>+        id number(19,0) not null,
>+        xml_id varchar2(255 char),
>+        binding_template_key varchar2(255 char),
>+        business_key varchar2(255 char),
>+        business_service_key varchar2(255 char),
>+        key_info number(19,0) not null,
>+        publisher_key varchar2(255 char),
>+        signature_value number(19,0) not null,
>+        signed_info number(19,0) not null,
>+        tmodel_key varchar2(255 char),
>+        primary key (id)
>+    );
>+
>+    create table j3_signature_method (
>+        id number(19,0) not null,
>+        algorithm varchar2(255 char),
>+        primary key (id)
>+    );
>+
>+    create table j3_signature_transform (
>+        id number(19,0) not null,
>+        transform varchar2(255 char),
>+        reference_key number(19,0) not null,
>+        primary key (id)
>+    );
>+
>+    create table j3_signature_transform_data_value (
>+        id number(19,0) not null,
>+        content_bytes blob,
>+        content_type varchar2(255 char),
>+        signature_transform_key number(19,0) not null,
>+        primary key (id)
>+    );
>+
>+    create table j3_signature_value (
>+        id number(19,0) not null,
>+        value_bytes blob,
>+        xml_id varchar2(255 char),
>+        primary key (id)
>+    );
>+
>+    create table j3_signed_info (
>+        id number(19,0) not null,
>+        xml_id varchar2(255 char),
>+        canonicalization_method number(19,0) not null,
>+        signature_method number(19,0) not null,
>+        primary key (id)
>+    );
>+
>     create table j3_subscription (
>         subscription_key varchar2(255 char) not null,
>         authorized_name varchar2(255 char) not null,
>@@ -503,6 +603,16 @@
>         foreign key (tmodel_instance_info_id) 
>         references j3_tmodel_instance_info;
> 
>+    alter table j3_key_data_value 
>+        add constraint FK74B7E072843143EF 
>+        foreign key (key_data_value_key) 
>+        references j3_key_data_value;
>+
>+    alter table j3_key_data_value 
>+        add constraint FK74B7E07238C90470 
>+        foreign key (key_info_key) 
>+        references j3_key_info;
>+
>     alter table j3_keyed_reference 
>         add constraint FK350C8454E075C8D7 
>         foreign key (keyed_reference_group_id) 
>@@ -518,6 +628,16 @@
>         foreign key (category_bag_id) 
>         references j3_category_bag;
> 
>+    alter table j3_object_type 
>+        add constraint FK98BBFA04BC6AD65 
>+        foreign key (signature_key) 
>+        references j3_signature;
>+
>+    alter table j3_object_type_content 
>+        add constraint FK987A913E71FA643E 
>+        foreign key (object_type_key) 
>+        references j3_object_type;
>+
>     alter table j3_overview_doc 
>         add constraint FK5CD8D0E8C5BF8903 
>         foreign key (entity_key) 
>@@ -553,6 +673,11 @@
>         foreign key (from_key) 
>         references j3_business_entity;
> 
>+    alter table j3_reference 
>+        add constraint FK493A4F951E480746 
>+        foreign key (signed_info_key) 
>+        references j3_signed_info;
>+
>     alter table j3_service_category_bag 
>         add constraint FK185A68076A68D45A 
>         foreign key (id) 
>@@ -583,6 +708,66 @@
>         foreign key (business_key) 
>         references j3_business_entity;
> 
>+    alter table j3_signature 
>+        add constraint FKC05CA90256E87DED 
>+        foreign key (publisher_key) 
>+        references j3_publisher;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA90271CD8948 
>+        foreign key (binding_template_key) 
>+        references j3_binding_template;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA90212F40D40 
>+        foreign key (business_service_key) 
>+        references j3_business_service;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA9028ACE9A26 
>+        foreign key (signed_info) 
>+        references j3_signed_info;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA9027CE6418E 
>+        foreign key (signature_value) 
>+        references j3_signature_value;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA9025793CF55 
>+        foreign key (tmodel_key) 
>+        references j3_tmodel;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA902DA6C2DD0 
>+        foreign key (key_info) 
>+        references j3_key_info;
>+
>+    alter table j3_signature 
>+        add constraint FKC05CA902EF04CFEE 
>+        foreign key (business_key) 
>+        references j3_business_entity;
>+
>+    alter table j3_signature_transform 
>+        add constraint FK726346F9256790B 
>+        foreign key (reference_key) 
>+        references j3_reference;
>+
>+    alter table j3_signature_transform_data_value 
>+        add constraint FK3242526C7B88B2A4 
>+        foreign key (signature_transform_key) 
>+        references j3_signature_transform;
>+
>+    alter table j3_signed_info 
>+        add constraint FKD2E7E5BB877110CC 
>+        foreign key (canonicalization_method) 
>+        references j3_canonicalization_method;
>+
>+    alter table j3_signed_info 
>+        add constraint FKD2E7E5BB1A25896 
>+        foreign key (signature_method) 
>+        references j3_signature_method;
>+
>     alter table j3_subscription_match 
>         add constraint FK5B9C2F19BEEE42E5 
>         foreign key (subscription_key)

Actions: View

Attachments on bug 874669: 648690