You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@juddi.apache.org by sv...@apache.org on 2005/03/02 03:15:41 UTC
cvs commit: ws-juddi/sql/firebird insert_publishers.sql create_database.sql README
sviens 2005/03/01 18:15:41
Added: sql/firebird insert_publishers.sql create_database.sql
README
Log:
Adding support for the Firebird SQL database.
Revision Changes Path
1.1 ws-juddi/sql/firebird/insert_publishers.sql
Index: insert_publishers.sql
===================================================================
-- *** SAMPLE PUBLISHER ***
-- INSERT INTO PUBLISHER (PUBLISHER_ID,PUBLISHER_NAME,EMAIL_ADDRESS,IS_ENABLED,IS_ADMIN)
-- VALUES ('jdoe','John Doe','john.doe@apache.org','true','true');
1.1 ws-juddi/sql/firebird/create_database.sql
Index: create_database.sql
===================================================================
SET SQL DIALECT 3;
SET NAMES NONE;
/******************************************************************************/
/**** Tables ****/
/******************************************************************************/
CREATE TABLE ADDRESS (
BUSINESS_KEY VARCHAR(41) NOT NULL,
CONTACT_ID INTEGER NOT NULL,
ADDRESS_ID INTEGER NOT NULL,
USE_TYPE VARCHAR(255),
SORT_CODE VARCHAR(10),
TMODEL_KEY VARCHAR(41)
);
CREATE TABLE ADDRESS_LINE (
BUSINESS_KEY VARCHAR(41) NOT NULL,
CONTACT_ID INTEGER NOT NULL,
ADDRESS_ID INTEGER NOT NULL,
ADDRESS_LINE_ID INTEGER NOT NULL,
LINE VARCHAR(80) NOT NULL,
KEY_NAME VARCHAR(255),
KEY_VALUE VARCHAR(255)
);
CREATE TABLE AUTH_TOKEN (
AUTH_TOKEN VARCHAR(51) NOT NULL,
PUBLISHER_ID VARCHAR(20) NOT NULL,
PUBLISHER_NAME VARCHAR(255) NOT NULL,
CREATED TIMESTAMP NOT NULL,
LAST_USED TIMESTAMP NOT NULL,
NUMBER_OF_USES INTEGER NOT NULL,
TOKEN_STATE INTEGER NOT NULL
);
CREATE TABLE BINDING_CATEGORY (
BINDING_KEY VARCHAR(41) NOT NULL,
CATEGORY_ID INTEGER NOT NULL,
TMODEL_KEY_REF VARCHAR(41),
KEY_NAME VARCHAR(255),
KEY_VALUE VARCHAR(255) NOT NULL
);
CREATE TABLE BINDING_DESCR (
BINDING_KEY VARCHAR(41) NOT NULL,
BINDING_DESCR_ID INTEGER NOT NULL,
LANG_CODE VARCHAR(2),
DESCR VARCHAR(255) NOT NULL
);
CREATE TABLE BINDING_TEMPLATE (
SERVICE_KEY VARCHAR(41) NOT NULL,
BINDING_KEY VARCHAR(41) NOT NULL,
ACCESS_POINT_TYPE VARCHAR(20),
ACCESS_POINT_URL VARCHAR(255),
HOSTING_REDIRECTOR VARCHAR(255),
LAST_UPDATE TIMESTAMP NOT NULL
);
CREATE TABLE BUSINESS_CATEGORY (
BUSINESS_KEY VARCHAR(41) NOT NULL,
CATEGORY_ID INTEGER NOT NULL,
TMODEL_KEY_REF VARCHAR(41),
KEY_NAME VARCHAR(255),
KEY_VALUE VARCHAR(255) NOT NULL
);
CREATE TABLE BUSINESS_DESCR (
BUSINESS_KEY VARCHAR(41) NOT NULL,
BUSINESS_DESCR_ID INTEGER NOT NULL,
LANG_CODE VARCHAR(2),
DESCR VARCHAR(255) NOT NULL
);
CREATE TABLE BUSINESS_ENTITY (
BUSINESS_KEY VARCHAR(41) NOT NULL,
AUTHORIZED_NAME VARCHAR(255) NOT NULL,
PUBLISHER_ID VARCHAR(20),
OPERATOR VARCHAR(255) NOT NULL,
LAST_UPDATE TIMESTAMP NOT NULL
);
CREATE TABLE BUSINESS_IDENTIFIER (
BUSINESS_KEY VARCHAR(41) NOT NULL,
IDENTIFIER_ID INTEGER NOT NULL,
TMODEL_KEY_REF VARCHAR(41),
KEY_NAME VARCHAR(255),
KEY_VALUE VARCHAR(255) NOT NULL
);
CREATE TABLE BUSINESS_NAME (
BUSINESS_KEY VARCHAR(41) NOT NULL,
BUSINESS_NAME_ID INTEGER NOT NULL,
LANG_CODE VARCHAR(2),
NAME VARCHAR(255) NOT NULL
);
CREATE TABLE BUSINESS_SERVICE (
BUSINESS_KEY VARCHAR(41) NOT NULL,
SERVICE_KEY VARCHAR(41) NOT NULL,
LAST_UPDATE TIMESTAMP NOT NULL
);
CREATE TABLE CONTACT (
BUSINESS_KEY VARCHAR(41) NOT NULL,
CONTACT_ID INTEGER NOT NULL,
USE_TYPE VARCHAR(255),
PERSON_NAME VARCHAR(255) NOT NULL
);
CREATE TABLE CONTACT_DESCR (
BUSINESS_KEY VARCHAR(41) NOT NULL,
CONTACT_ID INTEGER NOT NULL,
CONTACT_DESCR_ID INTEGER NOT NULL,
LANG_CODE VARCHAR(2),
DESCR VARCHAR(255) NOT NULL
);
CREATE TABLE DISCOVERY_URL (
BUSINESS_KEY VARCHAR(41) NOT NULL,
DISCOVERY_URL_ID INTEGER NOT NULL,
USE_TYPE VARCHAR(255) NOT NULL,
URL VARCHAR(255) NOT NULL
);
CREATE TABLE EMAIL (
BUSINESS_KEY VARCHAR(41) NOT NULL,
CONTACT_ID INTEGER NOT NULL,
EMAIL_ID INTEGER NOT NULL,
USE_TYPE VARCHAR(255),
EMAIL_ADDRESS VARCHAR(255) NOT NULL
);
CREATE TABLE INSTANCE_DETAILS_DESCR (
BINDING_KEY VARCHAR(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID INTEGER NOT NULL,
INSTANCE_DETAILS_DESCR_ID INTEGER NOT NULL,
LANG_CODE VARCHAR(2),
DESCR VARCHAR(255) NOT NULL
);
CREATE TABLE INSTANCE_DETAILS_DOC_DESCR (
BINDING_KEY VARCHAR(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID INTEGER NOT NULL,
INSTANCE_DETAILS_DOC_DESCR_ID INTEGER NOT NULL,
LANG_CODE VARCHAR(2),
DESCR VARCHAR(255) NOT NULL
);
CREATE TABLE MONITOR (
REMOTE_HOST VARCHAR(51) NOT NULL,
REQUEST_URI VARCHAR(255) NOT NULL,
CALLED_FUNCTION VARCHAR(51) NOT NULL,
UDDI_VERSION VARCHAR(51) NOT NULL,
LOG_TIME TIMESTAMP NOT NULL,
AUTH_TOKEN VARCHAR(51),
FAULT VARCHAR(255)
);
CREATE TABLE PHONE (
BUSINESS_KEY VARCHAR(41) NOT NULL,
CONTACT_ID INTEGER NOT NULL,
PHONE_ID INTEGER NOT NULL,
USE_TYPE VARCHAR(255),
PHONE_NUMBER VARCHAR(50) NOT NULL
);
CREATE TABLE PUBLISHER (
PUBLISHER_ID VARCHAR(20) NOT NULL,
PUBLISHER_NAME VARCHAR(255) NOT NULL,
LAST_NAME VARCHAR(150),
FIRST_NAME VARCHAR(100),
MIDDLE_INIT VARCHAR(5),
WORK_PHONE VARCHAR(50),
MOBILE_PHONE VARCHAR(50),
PAGER VARCHAR(50),
EMAIL_ADDRESS VARCHAR(255),
IS_ADMIN VARCHAR(5),
IS_ENABLED VARCHAR(5)
);
CREATE TABLE PUBLISHER_ASSERTION (
FROM_KEY VARCHAR(41) NOT NULL,
TO_KEY VARCHAR(41) NOT NULL,
TMODEL_KEY VARCHAR(41) NOT NULL,
KEY_NAME VARCHAR(255) NOT NULL,
KEY_VALUE VARCHAR(255) NOT NULL,
FROM_CHECK VARCHAR(5) NOT NULL,
TO_CHECK VARCHAR(5) NOT NULL
);
CREATE TABLE SERVICE_CATEGORY (
SERVICE_KEY VARCHAR(41) NOT NULL,
CATEGORY_ID INTEGER NOT NULL,
TMODEL_KEY_REF VARCHAR(41),
KEY_NAME VARCHAR(255),
KEY_VALUE VARCHAR(255) NOT NULL
);
CREATE TABLE SERVICE_DESCR (
SERVICE_KEY VARCHAR(41) NOT NULL,
SERVICE_DESCR_ID INTEGER NOT NULL,
LANG_CODE VARCHAR(2),
DESCR VARCHAR(255) NOT NULL
);
CREATE TABLE SERVICE_NAME (
SERVICE_KEY VARCHAR(41) NOT NULL,
SERVICE_NAME_ID INTEGER NOT NULL,
LANG_CODE VARCHAR(2),
NAME VARCHAR(255) NOT NULL
);
CREATE TABLE TMODEL (
TMODEL_KEY VARCHAR(41) NOT NULL,
AUTHORIZED_NAME VARCHAR(255) NOT NULL,
PUBLISHER_ID VARCHAR(20),
OPERATOR VARCHAR(255) NOT NULL,
NAME VARCHAR(255) NOT NULL,
OVERVIEW_URL VARCHAR(255),
DELETED VARCHAR(5),
LAST_UPDATE TIMESTAMP NOT NULL
);
CREATE TABLE TMODEL_CATEGORY (
TMODEL_KEY VARCHAR(41) NOT NULL,
CATEGORY_ID INTEGER NOT NULL,
TMODEL_KEY_REF VARCHAR(255),
KEY_NAME VARCHAR(255),
KEY_VALUE VARCHAR(255) NOT NULL
);
CREATE TABLE TMODEL_DESCR (
TMODEL_KEY VARCHAR(41) NOT NULL,
TMODEL_DESCR_ID INTEGER NOT NULL,
LANG_CODE VARCHAR(2),
DESCR VARCHAR(255) NOT NULL
);
CREATE TABLE TMODEL_DOC_DESCR (
TMODEL_KEY VARCHAR(41) NOT NULL,
TMODEL_DOC_DESCR_ID INTEGER NOT NULL,
LANG_CODE VARCHAR(2),
DESCR VARCHAR(255) NOT NULL
);
CREATE TABLE TMODEL_IDENTIFIER (
TMODEL_KEY VARCHAR(41) NOT NULL,
IDENTIFIER_ID INTEGER NOT NULL,
TMODEL_KEY_REF VARCHAR(255),
KEY_NAME VARCHAR(255),
KEY_VALUE VARCHAR(255) NOT NULL
);
CREATE TABLE TMODEL_INSTANCE_INFO (
BINDING_KEY VARCHAR(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID INTEGER NOT NULL,
TMODEL_KEY VARCHAR(41) NOT NULL,
OVERVIEW_URL VARCHAR(255),
INSTANCE_PARMS VARCHAR(255)
);
CREATE TABLE TMODEL_INSTANCE_INFO_DESCR (
BINDING_KEY VARCHAR(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID INTEGER NOT NULL,
TMODEL_INSTANCE_INFO_DESCR_ID INTEGER NOT NULL,
LANG_CODE VARCHAR(2),
DESCR VARCHAR(255) NOT NULL
);
/******************************************************************************/
/**** Primary Keys ****/
/******************************************************************************/
ALTER TABLE ADDRESS ADD PRIMARY KEY (BUSINESS_KEY, CONTACT_ID, ADDRESS_ID);
ALTER TABLE ADDRESS_LINE ADD PRIMARY KEY (BUSINESS_KEY, CONTACT_ID, ADDRESS_ID, ADDRESS_LINE_ID);
ALTER TABLE AUTH_TOKEN ADD PRIMARY KEY (AUTH_TOKEN);
ALTER TABLE BINDING_CATEGORY ADD PRIMARY KEY (BINDING_KEY, CATEGORY_ID);
ALTER TABLE BINDING_DESCR ADD PRIMARY KEY (BINDING_KEY, BINDING_DESCR_ID);
ALTER TABLE BINDING_TEMPLATE ADD PRIMARY KEY (BINDING_KEY);
ALTER TABLE BUSINESS_CATEGORY ADD PRIMARY KEY (BUSINESS_KEY, CATEGORY_ID);
ALTER TABLE BUSINESS_DESCR ADD PRIMARY KEY (BUSINESS_KEY, BUSINESS_DESCR_ID);
ALTER TABLE BUSINESS_ENTITY ADD PRIMARY KEY (BUSINESS_KEY);
ALTER TABLE BUSINESS_IDENTIFIER ADD PRIMARY KEY (BUSINESS_KEY, IDENTIFIER_ID);
ALTER TABLE BUSINESS_NAME ADD PRIMARY KEY (BUSINESS_KEY, BUSINESS_NAME_ID);
ALTER TABLE BUSINESS_SERVICE ADD PRIMARY KEY (SERVICE_KEY);
ALTER TABLE CONTACT ADD PRIMARY KEY (BUSINESS_KEY, CONTACT_ID);
ALTER TABLE CONTACT_DESCR ADD PRIMARY KEY (BUSINESS_KEY, CONTACT_ID, CONTACT_DESCR_ID);
ALTER TABLE DISCOVERY_URL ADD PRIMARY KEY (BUSINESS_KEY, DISCOVERY_URL_ID);
ALTER TABLE EMAIL ADD PRIMARY KEY (BUSINESS_KEY, CONTACT_ID, EMAIL_ID);
ALTER TABLE INSTANCE_DETAILS_DESCR ADD PRIMARY KEY (BINDING_KEY, TMODEL_INSTANCE_INFO_ID, INSTANCE_DETAILS_DESCR_ID);
ALTER TABLE INSTANCE_DETAILS_DOC_DESCR ADD PRIMARY KEY (BINDING_KEY, TMODEL_INSTANCE_INFO_ID, INSTANCE_DETAILS_DOC_DESCR_ID);
ALTER TABLE PHONE ADD PRIMARY KEY (BUSINESS_KEY, CONTACT_ID, PHONE_ID);
ALTER TABLE PUBLISHER ADD PRIMARY KEY (PUBLISHER_ID);
ALTER TABLE SERVICE_CATEGORY ADD PRIMARY KEY (SERVICE_KEY, CATEGORY_ID);
ALTER TABLE SERVICE_DESCR ADD PRIMARY KEY (SERVICE_KEY, SERVICE_DESCR_ID);
ALTER TABLE SERVICE_NAME ADD PRIMARY KEY (SERVICE_KEY, SERVICE_NAME_ID);
ALTER TABLE TMODEL ADD PRIMARY KEY (TMODEL_KEY);
ALTER TABLE TMODEL_CATEGORY ADD PRIMARY KEY (TMODEL_KEY, CATEGORY_ID);
ALTER TABLE TMODEL_DESCR ADD PRIMARY KEY (TMODEL_KEY, TMODEL_DESCR_ID);
ALTER TABLE TMODEL_DOC_DESCR ADD PRIMARY KEY (TMODEL_KEY, TMODEL_DOC_DESCR_ID);
ALTER TABLE TMODEL_IDENTIFIER ADD PRIMARY KEY (TMODEL_KEY, IDENTIFIER_ID);
ALTER TABLE TMODEL_INSTANCE_INFO ADD PRIMARY KEY (BINDING_KEY, TMODEL_INSTANCE_INFO_ID);
ALTER TABLE TMODEL_INSTANCE_INFO_DESCR ADD PRIMARY KEY (BINDING_KEY, TMODEL_INSTANCE_INFO_ID, TMODEL_INSTANCE_INFO_DESCR_ID);
/******************************************************************************/
/**** TModels ****/
/******************************************************************************/
INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
VALUES ('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','Administrator','admin','jUDDI.org','uddi-org:types','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#UDDItypes',CURRENT_DATE);
INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4',0,'en','UDDI Type Taxonomy');
INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4',0,'en','Taxonomy used to categorize Service Descriptions.');
INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES ('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES ('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');
INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
VALUES ('uuid:DB77450D-9FA8-45D4-A7BC-04411D14E384','Administrator','admin','jUDDI.org','unspsc-org:unspsc:3-1','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#UNSPSC31',CURRENT_DATE);
INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:DB77450D-9FA8-45D4-A7BC-04411D14E384',0,'en','Product Taxonomy: UNSPSC (Version 3.1)');
INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:DB77450D-9FA8-45D4-A7BC-04411D14E384',0,'en','This tModel defines the UNSPSC product taxonomy.');
INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES ('uuid:DB77450D-9FA8-45D4-A7BC-04411D14E384',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
VALUES ('uuid:CD153257-086A-4237-B336-6BDCBDCC6634','Administrator','admin','jUDDI.org','unspsc-org:unspsc','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#UNSPSC',CURRENT_DATE);
INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:CD153257-086A-4237-B336-6BDCBDCC6634',0,'en','Product Taxonomy: UNSPSC (Version 7.3)');
INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:CD153257-086A-4237-B336-6BDCBDCC6634',0,'en','This tModel defines Version 7.3 of the UNSPSC product taxonomy.');
INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES ('uuid:CD153257-086A-4237-B336-6BDCBDCC6634',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES ('uuid:CD153257-086A-4237-B336-6BDCBDCC6634',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','Checked');
INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
VALUES ('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2','Administrator','admin','jUDDI.org','ntis-gov:naics:1997','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#NAICS',CURRENT_DATE);
INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2',0,'en','Business Taxonomy: NAICS(1997 Release)');
INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2',0,'en','This tModel defines the NAICS industry taxonomy.');
INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES ('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES ('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');
INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
VALUES ('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88','Administrator','admin','jUDDI.org','uddi-org:iso-ch:3166-1999','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#ISO3166',CURRENT_DATE);
INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88',0,'en','ISO 3166-1:1997 and 3166-2:1998. Codes for names of countries and their subdivisions. Part 1: Country codes. Part 2:Country subdivision codes. Update newsletters include ISO 3166-1 V-1 (1998-02-05), V-2 (1999-10-01), ISO 3166-2 I-1 (1998)');
INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88',0,'en','Taxonomy used to categorize entries by geographic location.');
INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES ('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES ('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');
INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
VALUES ('uuid:A035A07C-F362-44DD-8F95-E2B134BF43B4','Administrator','admin','jUDDI.org','uddi-org:general_keywords','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#GenKW',CURRENT_DATE);
INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:A035A07C-F362-44DD-8F95-E2B134BF43B4',0,'en','Special taxonomy consisting of namespace identifiers and the keywords associated with the namespaces');
INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:A035A07C-F362-44DD-8F95-E2B134BF43B4',0,'en','This tModel defines an unidentified taxonomy.');
INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES ('uuid:A035A07C-F362-44DD-8F95-E2B134BF43B4',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
VALUES ('uuid:4064C064-6D14-4F35-8953-9652106476A9','Administrator','admin','jUDDI.org','uddi-org:owningBusiness','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#owningBusiness',CURRENT_DATE);
INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:4064C064-6D14-4F35-8953-9652106476A9',0,'en','A pointer to a businessEntity that owns the tagged data.');
INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:4064C064-6D14-4F35-8953-9652106476A9',0,'en','This tModel indicates the businessEntity that published or owns the tagged tModel. Used with tModels to establish an "owned" relationship with a registered businessEntity.');
INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES ('uuid:4064C064-6D14-4F35-8953-9652106476A9',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES ('uuid:4064C064-6D14-4F35-8953-9652106476A9',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');
INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
VALUES ('uuid:807A2C6A-EE22-470D-ADC7-E0424A337C03','Administrator','admin','jUDDI.org','uddi-org:relationships','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#Relationships',CURRENT_DATE);
INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:807A2C6A-EE22-470D-ADC7-E0424A337C03',0,'en','Starter set classifications of businessEntity relationships');
INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:807A2C6A-EE22-470D-ADC7-E0424A337C03',0,'en','This tModel is used to describe business relationships. Used in the publisher assertion messages.');
INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES ('uuid:807A2C6A-EE22-470D-ADC7-E0424A337C03',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','relationship');
INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
VALUES ('uuid:327A56F0-3299-4461-BC23-5CD513E95C55','Administrator','admin','jUDDI.org','uddi-org:operators','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#Operators',CURRENT_DATE);
INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:327A56F0-3299-4461-BC23-5CD513E95C55',0,'en','Taxonomy for categorizing the businessEntity of an operator of a registry.');
INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:327A56F0-3299-4461-BC23-5CD513E95C55',0,'en','This checked value set is used to identify UDDI operators.');
INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES ('uuid:327A56F0-3299-4461-BC23-5CD513E95C55',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES ('uuid:327A56F0-3299-4461-BC23-5CD513E95C55',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');
INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
VALUES ('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E','Administrator','admin','jUDDI.org','uddi-org:isReplacedBy','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#IsReplacedBy',CURRENT_DATE);
INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E',0,'en','An identifier system used to point (using UDDI keys) to the tModel (or businessEntity) that is the logical replacement for the one in which isReplacedBy is used');
INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E',0,'en','This is a checked value set.');
INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES ('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','identifier');
INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES ('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');
INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
VALUES ('uuid:8609C81E-EE1F-4D5A-B202-3EB13AD01823','Administrator','admin','jUDDI.org','dnb-com:D-U-N-S','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#D-U-N-S',CURRENT_DATE);
INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:8609C81E-EE1F-4D5A-B202-3EB13AD01823',0,'en','Dun&Bradstreet D-U-N-S� Number');
INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:8609C81E-EE1F-4D5A-B202-3EB13AD01823',0,'en','This tModel is used for the Dun&Bradstreet D-U-N-S� Number identifier.');
INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES ('uuid:8609C81E-EE1F-4D5A-B202-3EB13AD01823',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','identifier');
INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
VALUES ('uuid:B1B1BAF5-2329-43E6-AE13-BA8E97195039','Administrator','admin','jUDDI.org','thomasregister-com:supplierID','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#Thomas',CURRENT_DATE);
INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:B1B1BAF5-2329-43E6-AE13-BA8E97195039',0,'en','Thomas Registry Suppliers');
INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:B1B1BAF5-2329-43E6-AE13-BA8E97195039',0,'en','This tModel is used for the Thomas Register supplier identifier codes.');
INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES ('uuid:B1B1BAF5-2329-43E6-AE13-BA8E97195039',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','identifier');
COMMIT WORK;
/******************************************************************************/
/**** Foreign Keys ****/
/******************************************************************************/
ALTER TABLE ADDRESS ADD FOREIGN KEY (BUSINESS_KEY, CONTACT_ID) REFERENCES CONTACT (BUSINESS_KEY, CONTACT_ID);
ALTER TABLE ADDRESS_LINE ADD FOREIGN KEY (BUSINESS_KEY, CONTACT_ID, ADDRESS_ID) REFERENCES ADDRESS (BUSINESS_KEY, CONTACT_ID, ADDRESS_ID);
ALTER TABLE BINDING_CATEGORY ADD FOREIGN KEY (BINDING_KEY) REFERENCES BINDING_TEMPLATE (BINDING_KEY);
ALTER TABLE BINDING_DESCR ADD FOREIGN KEY (BINDING_KEY) REFERENCES BINDING_TEMPLATE (BINDING_KEY);
ALTER TABLE BINDING_TEMPLATE ADD FOREIGN KEY (SERVICE_KEY) REFERENCES BUSINESS_SERVICE (SERVICE_KEY);
ALTER TABLE BUSINESS_CATEGORY ADD FOREIGN KEY (BUSINESS_KEY) REFERENCES BUSINESS_ENTITY (BUSINESS_KEY);
ALTER TABLE BUSINESS_DESCR ADD FOREIGN KEY (BUSINESS_KEY) REFERENCES BUSINESS_ENTITY (BUSINESS_KEY);
ALTER TABLE BUSINESS_NAME ADD FOREIGN KEY (BUSINESS_KEY) REFERENCES BUSINESS_ENTITY (BUSINESS_KEY);
ALTER TABLE BUSINESS_SERVICE ADD FOREIGN KEY (BUSINESS_KEY) REFERENCES BUSINESS_ENTITY (BUSINESS_KEY);
ALTER TABLE CONTACT ADD FOREIGN KEY (BUSINESS_KEY) REFERENCES BUSINESS_ENTITY (BUSINESS_KEY);
ALTER TABLE CONTACT_DESCR ADD FOREIGN KEY (BUSINESS_KEY, CONTACT_ID) REFERENCES CONTACT (BUSINESS_KEY, CONTACT_ID);
ALTER TABLE DISCOVERY_URL ADD FOREIGN KEY (BUSINESS_KEY) REFERENCES BUSINESS_ENTITY (BUSINESS_KEY);
ALTER TABLE EMAIL ADD FOREIGN KEY (BUSINESS_KEY, CONTACT_ID) REFERENCES CONTACT (BUSINESS_KEY, CONTACT_ID);
ALTER TABLE INSTANCE_DETAILS_DESCR ADD FOREIGN KEY (BINDING_KEY, TMODEL_INSTANCE_INFO_ID) REFERENCES TMODEL_INSTANCE_INFO (BINDING_KEY, TMODEL_INSTANCE_INFO_ID);
ALTER TABLE INSTANCE_DETAILS_DOC_DESCR ADD FOREIGN KEY (BINDING_KEY, TMODEL_INSTANCE_INFO_ID) REFERENCES TMODEL_INSTANCE_INFO (BINDING_KEY, TMODEL_INSTANCE_INFO_ID);
ALTER TABLE PHONE ADD FOREIGN KEY (BUSINESS_KEY, CONTACT_ID) REFERENCES CONTACT (BUSINESS_KEY, CONTACT_ID);
ALTER TABLE PUBLISHER_ASSERTION ADD FOREIGN KEY (FROM_KEY) REFERENCES BUSINESS_ENTITY (BUSINESS_KEY);
ALTER TABLE PUBLISHER_ASSERTION ADD FOREIGN KEY (TO_KEY) REFERENCES BUSINESS_ENTITY (BUSINESS_KEY);
ALTER TABLE SERVICE_CATEGORY ADD FOREIGN KEY (SERVICE_KEY) REFERENCES BUSINESS_SERVICE (SERVICE_KEY);
ALTER TABLE SERVICE_DESCR ADD FOREIGN KEY (SERVICE_KEY) REFERENCES BUSINESS_SERVICE (SERVICE_KEY);
ALTER TABLE SERVICE_NAME ADD FOREIGN KEY (SERVICE_KEY) REFERENCES BUSINESS_SERVICE (SERVICE_KEY);
ALTER TABLE TMODEL_CATEGORY ADD FOREIGN KEY (TMODEL_KEY) REFERENCES TMODEL (TMODEL_KEY);
ALTER TABLE TMODEL_DESCR ADD FOREIGN KEY (TMODEL_KEY) REFERENCES TMODEL (TMODEL_KEY);
ALTER TABLE TMODEL_DOC_DESCR ADD FOREIGN KEY (TMODEL_KEY) REFERENCES TMODEL (TMODEL_KEY);
ALTER TABLE TMODEL_IDENTIFIER ADD FOREIGN KEY (TMODEL_KEY) REFERENCES TMODEL (TMODEL_KEY);
ALTER TABLE TMODEL_INSTANCE_INFO ADD FOREIGN KEY (BINDING_KEY) REFERENCES BINDING_TEMPLATE (BINDING_KEY);
ALTER TABLE TMODEL_INSTANCE_INFO_DESCR ADD FOREIGN KEY (BINDING_KEY, TMODEL_INSTANCE_INFO_ID) REFERENCES TMODEL_INSTANCE_INFO (BINDING_KEY, TMODEL_INSTANCE_INFO_ID);
1.1 ws-juddi/sql/firebird/README
Index: README
===================================================================
CREATE/CONFIGURE A Firebird SQL DATABASE FOR jUDDI
jUDDI requires the use of a relational database (RDBMS) to
store the web services metadata it manages. This document
will walk you through the process of setting up a Firebird
SQL database as the persistent storage for a jUDDI registry.
Author: Kurt R. Hoehn
Director, Information Systems
Transcor, Inc.
http://www.etranscor.com