<*
 * Copyright 2001-2009 The Apache Software Foundation.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 *
 */
    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_canonicalization_method (
        id bigint not null auto_increment,
        algorithm varchar(255),
        primary key (id)
    ) ENGINE=InnoDB;

    create table j3_category_bag (
        id bigint not null auto_increment,
        primary key (id)
    ) ENGINE=InnoDB;

    create table j3_clerk (
        clerk_name varchar(255) not null,
        cred varchar(255),
        publisher_id varchar(255) not null,
        node_name varchar(255),
        primary key (clerk_name)
    ) ENGINE=InnoDB;

    create table j3_client_subscriptioninfo (
        subscription_key varchar(255) not null,
        last_notified datetime,
        fromClerk_clerk_name varchar(255),
        toClerk_clerk_name varchar(255),
        primary key (subscription_key)
    ) ENGINE=InnoDB;

    create table j3_contact (
        id bigint not null auto_increment,
        use_type varchar(255),
        entity_key varchar(255) not null,
        primary key (id)
    ) ENGINE=InnoDB;

    create table j3_contact_descr (
        id bigint not null auto_increment,
        descr varchar(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_key_data_value (
        id bigint not null auto_increment,
        key_data_name varchar(255),
        key_data_type varchar(255),
        key_data_value longblob,
        key_data_value_string longtext,
        key_data_value_key bigint,
        key_info_key bigint,
        primary key (id)
    ) ENGINE=InnoDB;

    create table j3_key_info (
        id bigint not null auto_increment,
        xml_id varchar(255),
        primary key (id)
    ) ENGINE=InnoDB;

    create table j3_keyed_reference (
        id bigint not null auto_increment,
        key_name varchar(255),
        key_value varchar(255) not null,
        tmodel_key_ref varchar(255),
        category_bag_id bigint,
        keyed_reference_group_id bigint,
        primary key (id)
    ) ENGINE=InnoDB;

    create table j3_keyed_reference_group (
        id bigint not null auto_increment,
        tmodel_key varchar(255),
        category_bag_id bigint not null,
        primary key (id)
    ) ENGINE=InnoDB;

    create table j3_node (
        name varchar(255) not null,
        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_object_type (
        id bigint not null auto_increment,
        encoding varchar(255),
        mime_type varchar(255),
        xml_id varchar(255),
        signature_key bigint not null,
        primary key (id)
    ) ENGINE=InnoDB;

    create table j3_object_type_content (
        id bigint not null auto_increment,
        content longblob,
        object_type_key bigint not null,
        primary key (id)
    ) ENGINE=InnoDB;

    create table j3_overview_doc (
        id bigint not null auto_increment,
        overview_url varchar(255),
        overview_url_use_type varchar(255),
        entity_key varchar(255),
        tomodel_instance_info_id bigint,
        primary key (id)
    ) ENGINE=InnoDB;

    create table j3_overview_doc_descr (
        id bigint not null auto_increment,
        descr varchar(1024) not null,
        lang_code varchar(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_reference (
        id bigint not null auto_increment,
        digest_method varchar(255),
        digest_value longblob,
        type varchar(255),
        uri varchar(255),
        xml_id varchar(255),
        signed_info_key bigint not null,
        primary key (id)
    ) ENGINE=InnoDB;

    create table j3_service_category_bag (
        id bigint not null,
        entity_key varchar(255) not null,
        primary key (id),
        unique (entity_key)
    ) ENGINE=InnoDB;

    create table j3_service_descr (
        id bigint not null auto_increment,
        descr varchar(1024) not null,
        lang_code varchar(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_signature (
        id bigint not null auto_increment,
        xml_id varchar(255),
        binding_template_key varchar(255),
        business_key varchar(255),
        business_service_key varchar(255),
        key_info bigint not null,
        publisher_key varchar(255),
        signature_value bigint not null,
        signed_info bigint not null,
        tmodel_key varchar(255),
        primary key (id)
    ) ENGINE=InnoDB;

    create table j3_signature_method (
        id bigint not null auto_increment,
        algorithm varchar(255),
        primary key (id)
    ) ENGINE=InnoDB;

    create table j3_signature_transform (
        id bigint not null auto_increment,
        transform varchar(255),
        reference_key bigint not null,
        primary key (id)
    ) ENGINE=InnoDB;

    create table j3_signature_transform_data_value (
        id bigint not null auto_increment,
        content_bytes longblob,
        content_type varchar(255),
        signature_transform_key bigint not null,
        primary key (id)
    ) ENGINE=InnoDB;

    create table j3_signature_value (
        id bigint not null auto_increment,
        value_bytes longblob,
        xml_id varchar(255),
        primary key (id)
    ) ENGINE=InnoDB;

    create table j3_signed_info (
        id bigint not null auto_increment,
        xml_id varchar(255),
        canonicalization_method bigint not null,
        signature_method bigint not null,
        primary key (id)
    ) ENGINE=InnoDB;

    create table j3_subscription (
        subscription_key varchar(255) not null,
        authorized_name varchar(255) not null,
        binding_key varchar(255),
        brief bit,
        create_date datetime not null,
        expires_after datetime,
        last_notified datetime,
        max_entities integer,
        notification_interval varchar(255),
        subscription_filter longtext not null,
        primary key (subscription_key)
    ) ENGINE=InnoDB;

    create table j3_subscription_chunk_token (
        chunk_token varchar(255) not null,
        data integer not null,
        end_point datetime,
        expires_after datetime not null,
        start_point datetime,
        subscription_key varchar(255) not null,
        primary key (chunk_token)
    ) ENGINE=InnoDB;

    create table j3_subscription_match (
        id bigint not null auto_increment,
        entity_key varchar(255) not null,
        subscription_key varchar(255) not null,
        primary key (id)
    ) ENGINE=InnoDB;

    create table j3_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_key_data_value 
        add index FK74B7E072843143EF (key_data_value_key), 
        add constraint FK74B7E072843143EF 
        foreign key (key_data_value_key) 
        references j3_key_data_value (id);

    alter table j3_key_data_value 
        add index FK74B7E07238C90470 (key_info_key), 
        add constraint FK74B7E07238C90470 
        foreign key (key_info_key) 
        references j3_key_info (id);

    alter table j3_keyed_reference 
        add index FK350C8454E075C8D7 (keyed_reference_group_id), 
        add constraint FK350C8454E075C8D7 
        foreign key (keyed_reference_group_id) 
        references j3_keyed_reference_group (id);

    alter table j3_keyed_reference 
        add index FK350C84541DB72652 (category_bag_id), 
        add constraint FK350C84541DB72652 
        foreign key (category_bag_id) 
        references j3_category_bag (id);

    alter table j3_keyed_reference_group 
        add index FKF6224ED41DB72652 (category_bag_id), 
        add constraint FKF6224ED41DB72652 
        foreign key (category_bag_id) 
        references j3_category_bag (id);

    alter table j3_object_type 
        add index FK98BBFA04BC6AD65 (signature_key), 
        add constraint FK98BBFA04BC6AD65 
        foreign key (signature_key) 
        references j3_signature (id);

    alter table j3_object_type_content 
        add index FK987A913E71FA643E (object_type_key), 
        add constraint FK987A913E71FA643E 
        foreign key (object_type_key) 
        references j3_object_type (id);

    alter table j3_overview_doc 
        add index FK5CD8D0E8C5BF8903 (entity_key), 
        add constraint FK5CD8D0E8C5BF8903 
        foreign key (entity_key) 
        references j3_tmodel (entity_key);

    alter table j3_overview_doc 
        add index FK5CD8D0E8E8CE1B36 (tomodel_instance_info_id), 
        add constraint FK5CD8D0E8E8CE1B36 
        foreign key (tomodel_instance_info_id) 
        references j3_tmodel_instance_info (id);

    alter table j3_overview_doc_descr 
        add index FK36FB9EA9BDC711C (overview_doc_id), 
        add constraint FK36FB9EA9BDC711C 
        foreign key (overview_doc_id) 
        references j3_overview_doc (id);

    alter table j3_person_name 
        add index FKCB7B8AFF2E3FD94F (contact_id), 
        add constraint FKCB7B8AFF2E3FD94F 
        foreign key (contact_id) 
        references j3_contact (id);

    alter table j3_phone 
        add index FK359202B82E3FD94F (contact_id), 
        add constraint FK359202B82E3FD94F 
        foreign key (contact_id) 
        references j3_contact (id);

    alter table j3_publisher_assertion 
        add index FK8A102449E3544929 (to_key), 
        add constraint FK8A102449E3544929 
        foreign key (to_key) 
        references j3_business_entity (entity_key);

    alter table j3_publisher_assertion 
        add index FK8A102449CCEE22D8 (from_key), 
        add constraint FK8A102449CCEE22D8 
        foreign key (from_key) 
        references j3_business_entity (entity_key);

    alter table j3_reference 
        add index FK493A4F951E480746 (signed_info_key), 
        add constraint FK493A4F951E480746 
        foreign key (signed_info_key) 
        references j3_signed_info (id);

    alter table j3_service_category_bag 
        add index FK185A68076A68D45A (id), 
        add constraint FK185A68076A68D45A 
        foreign key (id) 
        references j3_category_bag (id);

    alter table j3_service_category_bag 
        add index FK185A680748D0656D (entity_key), 
        add constraint FK185A680748D0656D 
        foreign key (entity_key) 
        references j3_business_service (entity_key);

    alter table j3_service_descr 
        add index FKB6D63D4148D0656D (entity_key), 
        add constraint FKB6D63D4148D0656D 
        foreign key (entity_key) 
        references j3_business_service (entity_key);

    alter table j3_service_name 
        add index FKCC1BE94B48D0656D (entity_key), 
        add constraint FKCC1BE94B48D0656D 
        foreign key (entity_key) 
        references j3_business_service (entity_key);

    alter table j3_service_projection 
        add index FK629F290F2E448F3F (service_key), 
        add constraint FK629F290F2E448F3F 
        foreign key (service_key) 
        references j3_business_service (entity_key);

    alter table j3_service_projection 
        add index FK629F290FEF04CFEE (business_key), 
        add constraint FK629F290FEF04CFEE 
        foreign key (business_key) 
        references j3_business_entity (entity_key);

    alter table j3_signature 
        add index FKC05CA90256E87DED (publisher_key), 
        add constraint FKC05CA90256E87DED 
        foreign key (publisher_key) 
        references j3_publisher (authorized_name);

    alter table j3_signature 
        add index FKC05CA90271CD8948 (binding_template_key), 
        add constraint FKC05CA90271CD8948 
        foreign key (binding_template_key) 
        references j3_binding_template (entity_key);

    alter table j3_signature 
        add index FKC05CA90212F40D40 (business_service_key), 
        add constraint FKC05CA90212F40D40 
        foreign key (business_service_key) 
        references j3_business_service (entity_key);

    alter table j3_signature 
        add index FKC05CA9028ACE9A26 (signed_info), 
        add constraint FKC05CA9028ACE9A26 
        foreign key (signed_info) 
        references j3_signed_info (id);

    alter table j3_signature 
        add index FKC05CA9027CE6418E (signature_value), 
        add constraint FKC05CA9027CE6418E 
        foreign key (signature_value) 
        references j3_signature_value (id);

    alter table j3_signature 
        add index FKC05CA9025793CF55 (tmodel_key), 
        add constraint FKC05CA9025793CF55 
        foreign key (tmodel_key) 
        references j3_tmodel (entity_key);

    alter table j3_signature 
        add index FKC05CA902DA6C2DD0 (key_info), 
        add constraint FKC05CA902DA6C2DD0 
        foreign key (key_info) 
        references j3_key_info (id);

    alter table j3_signature 
        add index FKC05CA902EF04CFEE (business_key), 
        add constraint FKC05CA902EF04CFEE 
        foreign key (business_key) 
        references j3_business_entity (entity_key);

    alter table j3_signature_transform 
        add index FK726346F9256790B (reference_key), 
        add constraint FK726346F9256790B 
        foreign key (reference_key) 
        references j3_reference (id);

    alter table j3_signature_transform_data_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 
        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);