juddi-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From svi...@apache.org
Subject cvs commit: ws-juddi/sql/firebird insert_publishers.sql create_database.sql README
Date Wed, 02 Mar 2005 02:15:41 GMT
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
  
  
  
  

Mime
View raw message