[prev in list] [next in list] [prev in thread] [next in thread]
List: juddi-cvs
Subject: cvs commit: ws-juddi/sql/jdatastore create_database.sql README insert_publishers.sql
From: sviens () apache ! org
Date: 2004-05-31 0:37:33
Message-ID: 20040531003733.21793.qmail () minotaur ! apache ! org
[Download RAW message or body]
sviens 2004/05/30 17:37:33
Modified: sql/jdatastore README insert_publishers.sql
Added: sql/jdatastore create_database.sql
Log:
Updating master Borland JDataStore/jUDDI database setup script.
Revision Changes Path
1.2 +9 -3 ws-juddi/sql/jdatastore/README
Index: README
===================================================================
RCS file: /home/cvs/ws-juddi/sql/jdatastore/README,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- README 30 Apr 2004 04:11:09 -0000 1.1
+++ README 31 May 2004 00:37:32 -0000 1.2
@@ -1,4 +1,10 @@
-Borland JDataStore / jUDDI version 0.9rc1
+CREATE/CONFIGURE A BORLAND JDATASTORE DATABASE FOR jUDDI
-Author: Andy Cutright
-acutright@apache.org
\ No newline at end of file
+jUDDI requires the use of a relational database (RDBMS) or
+lightweight directory access protocol (LDAP) server to store
+the web services metadata it manages. This document will
+walk you through the process of setting up an JDataStore
+database as the persistante storage for a jUDDI registry.
+
+Andy Cutright
+acutright@apache.org
1.2 +3 -2 ws-juddi/sql/jdatastore/insert_publishers.sql
Index: insert_publishers.sql
===================================================================
RCS file: /home/cvs/ws-juddi/sql/jdatastore/insert_publishers.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- insert_publishers.sql 30 Apr 2004 04:11:09 -0000 1.1
+++ insert_publishers.sql 31 May 2004 00:37:32 -0000 1.2
@@ -1,2 +1,3 @@
-INSERT INTO PUBLISHER (PUBLISHER_ID,PUBLISHER_NAME,ENABLED,ADMIN
-VALUES ('jdoe','John Doe','true','true');
+-- *** SAMPLE PUBLISHER ***
+-- INSERT INTO PUBLISHER (PUBLISHER_ID,PUBLISHER_NAME,EMAIL_ADDRESS,ENABLED,ADMIN)
+-- VALUES ('jdoe','John Doe','john.doe@apache.org','true','true');
1.1 ws-juddi/sql/jdatastore/create_database.sql
Index: create_database.sql
===================================================================
-- DROP TABLE BUSINESS_DESCR;
-- DROP TABLE BUSINESS_CATEGORY;
-- DROP TABLE BUSINESS_IDENTIFIER;
-- DROP TABLE BUSINESS_NAME;
-- DROP TABLE DISCOVERY_URL;
-- DROP TABLE ADDRESS_LINE;
-- DROP TABLE ADDRESS;
-- DROP TABLE PHONE;
-- DROP TABLE EMAIL;
-- DROP TABLE CONTACT_DESCR;
-- DROP TABLE CONTACT;
-- DROP TABLE SERVICE_DESCR;
-- DROP TABLE SERVICE_CATEGORY;
-- DROP TABLE SERVICE_NAME;
-- DROP TABLE BINDING_DESCR;
-- DROP TABLE BINDING_CATEGORY;
-- DROP TABLE INSTANCE_DETAILS_DESCR;
-- DROP TABLE INSTANCE_DETAILS_DOC_DESCR;
-- DROP TABLE TMODEL_CATEGORY;
-- DROP TABLE TMODEL_DESCR;
-- DROP TABLE TMODEL_DOC_DESCR;
-- DROP TABLE TMODEL_IDENTIFIER;
-- DROP TABLE TMODEL_INSTANCE_INFO_DESCR;
-- DROP TABLE TMODEL_INSTANCE_INFO;
-- DROP TABLE PUBLISHER_ASSERTION;
-- DROP TABLE TMODEL;
-- DROP TABLE BINDING_TEMPLATE;
-- DROP TABLE BUSINESS_SERVICE;
-- DROP TABLE BUSINESS_ENTITY;
-- DROP TABLE PUBLISHER;
-- DROP TABLE AUTH_TOKEN;
-- DROP TABLE MONITOR;
-- DROP TABLE OPERATIONAL_INFO;
-- DROP TABLE OP_INFO_CHILD_TREE;
CREATE TABLE BUSINESS_ENTITY
(
BUSINESS_KEY VARCHAR(41) NOT NULL,
AUTHORIZED_NAME VARCHAR(255) NOT NULL,
PUBLISHER_ID VARCHAR(20) NULL,
OPERATOR VARCHAR(255) NOT NULL,
LAST_UPDATE TIMESTAMP NOT NULL,
PRIMARY KEY (BUSINESS_KEY)
);
CREATE TABLE BUSINESS_DESCR
(
BUSINESS_KEY VARCHAR(41) NOT NULL,
BUSINESS_DESCR_ID INT NOT NULL,
LANG_CODE VARCHAR(2) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BUSINESS_KEY,BUSINESS_DESCR_ID),
FOREIGN KEY (BUSINESS_KEY)
REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
);
CREATE TABLE BUSINESS_CATEGORY
(
BUSINESS_KEY VARCHAR(41) NOT NULL,
CATEGORY_ID INT NOT NULL,
TMODEL_KEY_REF VARCHAR(41) NULL,
KEY_NAME VARCHAR(255) NULL,
KEY_VALUE VARCHAR(255) NOT NULL,
PRIMARY KEY (BUSINESS_KEY,CATEGORY_ID),
FOREIGN KEY (BUSINESS_KEY)
REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
);
CREATE TABLE BUSINESS_IDENTIFIER
(
BUSINESS_KEY VARCHAR(41) NOT NULL,
IDENTIFIER_ID INT NOT NULL,
TMODEL_KEY_REF VARCHAR(41) NULL,
KEY_NAME VARCHAR(255) NULL,
KEY_VALUE VARCHAR(255) NOT NULL,
PRIMARY KEY (BUSINESS_KEY,IDENTIFIER_ID),
FOREIGN KEY (BUSINESS_KEY)
REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
);
CREATE TABLE BUSINESS_NAME
(
BUSINESS_KEY VARCHAR(41) NOT NULL,
BUSINESS_NAME_ID INT NOT NULL,
LANG_CODE VARCHAR(2) NULL,
NAME VARCHAR(255) NOT NULL,
PRIMARY KEY (BUSINESS_KEY,BUSINESS_NAME_ID),
FOREIGN KEY (BUSINESS_KEY)
REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
);
CREATE TABLE CONTACT
(
BUSINESS_KEY VARCHAR(41) NOT NULL,
CONTACT_ID INT NOT NULL,
USE_TYPE VARCHAR(255) NULL,
PERSON_NAME VARCHAR(255) NOT NULL,
PRIMARY KEY (BUSINESS_KEY,CONTACT_ID),
FOREIGN KEY (BUSINESS_KEY)
REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
);
CREATE TABLE CONTACT_DESCR
(
BUSINESS_KEY VARCHAR(41) NOT NULL,
CONTACT_ID INT NOT NULL,
CONTACT_DESCR_ID INT NOT NULL,
LANG_CODE VARCHAR(2) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,CONTACT_DESCR_ID),
FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
REFERENCES CONTACT (BUSINESS_KEY,CONTACT_ID)
);
CREATE TABLE ADDRESS
(
BUSINESS_KEY VARCHAR(41) NOT NULL,
CONTACT_ID INT NOT NULL,
ADDRESS_ID INT NOT NULL,
USE_TYPE VARCHAR(255) NULL,
SORT_CODE VARCHAR(10) NULL,
TMODEL_KEY VARCHAR(41) NULL,
PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,ADDRESS_ID),
FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
REFERENCES CONTACT (BUSINESS_KEY,CONTACT_ID)
);
CREATE TABLE ADDRESS_LINE
(
BUSINESS_KEY VARCHAR(41) NOT NULL,
CONTACT_ID INT NOT NULL,
ADDRESS_ID INT NOT NULL,
ADDRESS_LINE_ID INT NOT NULL,
LINE VARCHAR(80) NOT NULL,
KEY_NAME VARCHAR(255) NULL,
KEY_VALUE VARCHAR(255) NULL,
PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,ADDRESS_ID,ADDRESS_LINE_ID),
FOREIGN KEY (BUSINESS_KEY,CONTACT_ID,ADDRESS_ID)
REFERENCES ADDRESS (BUSINESS_KEY,CONTACT_ID,ADDRESS_ID)
);
CREATE TABLE EMAIL
(
BUSINESS_KEY VARCHAR(41) NOT NULL,
CONTACT_ID INT NOT NULL,
EMAIL_ID INT NOT NULL,
USE_TYPE VARCHAR(255) NULL,
EMAIL_ADDRESS VARCHAR(255) NOT NULL,
PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,EMAIL_ID),
FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
REFERENCES CONTACT (BUSINESS_KEY,CONTACT_ID)
);
CREATE TABLE PHONE
(
BUSINESS_KEY VARCHAR(41) NOT NULL,
CONTACT_ID INT NOT NULL,
PHONE_ID INT NOT NULL,
USE_TYPE VARCHAR(255) NULL,
PHONE_NUMBER VARCHAR(50) NOT NULL,
PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,PHONE_ID),
FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
REFERENCES CONTACT (BUSINESS_KEY,CONTACT_ID)
);
CREATE TABLE DISCOVERY_URL
(
BUSINESS_KEY VARCHAR(41) NOT NULL,
DISCOVERY_URL_ID INT NOT NULL,
USE_TYPE VARCHAR(255) NOT NULL,
URL VARCHAR(255) NOT NULL,
PRIMARY KEY (BUSINESS_KEY,DISCOVERY_URL_ID),
FOREIGN KEY (BUSINESS_KEY)
REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
);
CREATE TABLE BUSINESS_SERVICE
(
BUSINESS_KEY VARCHAR(41) NOT NULL,
SERVICE_KEY VARCHAR(41) NOT NULL,
LAST_UPDATE TIMESTAMP NOT NULL,
PRIMARY KEY (SERVICE_KEY),
FOREIGN KEY (BUSINESS_KEY)
REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
);
CREATE TABLE SERVICE_DESCR
(
SERVICE_KEY VARCHAR(41) NOT NULL,
SERVICE_DESCR_ID INT NOT NULL,
LANG_CODE VARCHAR(2) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (SERVICE_KEY,SERVICE_DESCR_ID),
FOREIGN KEY (SERVICE_KEY)
REFERENCES BUSINESS_SERVICE (SERVICE_KEY)
);
CREATE TABLE SERVICE_CATEGORY
(
SERVICE_KEY VARCHAR(41) NOT NULL,
CATEGORY_ID INT NOT NULL,
TMODEL_KEY_REF VARCHAR(41) NULL,
KEY_NAME VARCHAR(255) NULL,
KEY_VALUE VARCHAR(255) NOT NULL,
PRIMARY KEY (SERVICE_KEY,CATEGORY_ID),
FOREIGN KEY (SERVICE_KEY)
REFERENCES BUSINESS_SERVICE (SERVICE_KEY)
);
CREATE TABLE SERVICE_NAME
(
SERVICE_KEY VARCHAR(41) NOT NULL,
SERVICE_NAME_ID INT NOT NULL,
LANG_CODE VARCHAR(2) NULL,
NAME VARCHAR(255) NOT NULL,
PRIMARY KEY (SERVICE_KEY,SERVICE_NAME_ID),
FOREIGN KEY (SERVICE_KEY)
REFERENCES BUSINESS_SERVICE (SERVICE_KEY)
);
CREATE TABLE BINDING_TEMPLATE
(
SERVICE_KEY VARCHAR(41) NOT NULL,
BINDING_KEY VARCHAR(41) NOT NULL,
ACCESS_POINT_TYPE VARCHAR(20) NULL,
ACCESS_POINT_URL VARCHAR(255) NULL,
HOSTING_REDIRECTOR VARCHAR(255) NULL,
LAST_UPDATE TIMESTAMP NOT NULL,
PRIMARY KEY (BINDING_KEY),
FOREIGN KEY (SERVICE_KEY)
REFERENCES BUSINESS_SERVICE (SERVICE_KEY)
);
CREATE TABLE BINDING_CATEGORY
(
BINDING_KEY VARCHAR(41) NOT NULL,
CATEGORY_ID INT NOT NULL,
TMODEL_KEY_REF VARCHAR(41) NULL,
KEY_NAME VARCHAR(255) NULL,
KEY_VALUE VARCHAR(255) NOT NULL,
PRIMARY KEY (BINDING_KEY,CATEGORY_ID),
FOREIGN KEY (BINDING_KEY)
REFERENCES BINDING_TEMPLATE (BINDING_KEY)
);
CREATE TABLE BINDING_DESCR
(
BINDING_KEY VARCHAR(41) NOT NULL,
BINDING_DESCR_ID INT NOT NULL,
LANG_CODE VARCHAR(2) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BINDING_KEY,BINDING_DESCR_ID),
FOREIGN KEY (BINDING_KEY)
REFERENCES BINDING_TEMPLATE (BINDING_KEY)
);
CREATE TABLE TMODEL_INSTANCE_INFO
(
BINDING_KEY VARCHAR(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID INT NOT NULL,
TMODEL_KEY VARCHAR(41) NOT NULL,
OVERVIEW_URL VARCHAR(255) NULL,
INSTANCE_PARMS VARCHAR(255) NULL,
PRIMARY KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID),
FOREIGN KEY (BINDING_KEY)
REFERENCES BINDING_TEMPLATE (BINDING_KEY)
);
CREATE TABLE TMODEL_INSTANCE_INFO_DESCR
(
BINDING_KEY VARCHAR(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID INT NOT NULL,
TMODEL_INSTANCE_INFO_DESCR_ID INT NOT NULL,
LANG_CODE VARCHAR(2) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID,TMODEL_INSTANCE_INFO_DESCR_ID),
FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
REFERENCES TMODEL_INSTANCE_INFO (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
);
CREATE TABLE INSTANCE_DETAILS_DESCR
(
BINDING_KEY VARCHAR(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID INT NOT NULL,
INSTANCE_DETAILS_DESCR_ID INT NOT NULL,
LANG_CODE VARCHAR(2) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID,INSTANCE_DETAILS_DESCR_ID),
FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
REFERENCES TMODEL_INSTANCE_INFO (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
);
CREATE TABLE INSTANCE_DETAILS_DOC_DESCR
(
BINDING_KEY VARCHAR(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID INT NOT NULL,
INSTANCE_DETAILS_DOC_DESCR_ID INT NOT NULL,
LANG_CODE VARCHAR(2) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID,INSTANCE_DETAILS_DOC_DESCR_ID),
FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
REFERENCES TMODEL_INSTANCE_INFO (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
);
CREATE TABLE TMODEL
(
TMODEL_KEY VARCHAR(41) NOT NULL,
AUTHORIZED_NAME VARCHAR(255) NOT NULL,
PUBLISHER_ID VARCHAR(20) NULL,
OPERATOR VARCHAR(255) NOT NULL,
NAME VARCHAR(255) NOT NULL,
OVERVIEW_URL VARCHAR(255) NULL,
DELETED VARCHAR(5) NULL,
LAST_UPDATE TIMESTAMP NOT NULL,
PRIMARY KEY (TMODEL_KEY)
);
CREATE TABLE TMODEL_DESCR
(
TMODEL_KEY VARCHAR(41) NOT NULL,
TMODEL_DESCR_ID INT NOT NULL,
LANG_CODE VARCHAR(2) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (TMODEL_KEY,TMODEL_DESCR_ID),
FOREIGN KEY (TMODEL_KEY)
REFERENCES TMODEL (TMODEL_KEY)
);
CREATE TABLE TMODEL_CATEGORY
(
TMODEL_KEY VARCHAR(41) NOT NULL,
CATEGORY_ID INT NOT NULL,
TMODEL_KEY_REF VARCHAR(255) NULL,
KEY_NAME VARCHAR(255) NULL,
KEY_VALUE VARCHAR(255) NOT NULL,
PRIMARY KEY (TMODEL_KEY,CATEGORY_ID),
FOREIGN KEY (TMODEL_KEY)
REFERENCES TMODEL (TMODEL_KEY)
);
CREATE TABLE TMODEL_IDENTIFIER
(
TMODEL_KEY VARCHAR(41) NOT NULL,
IDENTIFIER_ID INT NOT NULL,
TMODEL_KEY_REF VARCHAR(255) NULL,
KEY_NAME VARCHAR(255) NULL,
KEY_VALUE VARCHAR(255) NOT NULL,
PRIMARY KEY (TMODEL_KEY,IDENTIFIER_ID),
FOREIGN KEY (TMODEL_KEY)
REFERENCES TMODEL (TMODEL_KEY)
);
CREATE TABLE TMODEL_DOC_DESCR
(
TMODEL_KEY VARCHAR(41) NOT NULL,
TMODEL_DOC_DESCR_ID INT NOT NULL,
LANG_CODE VARCHAR(2) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (TMODEL_KEY,TMODEL_DOC_DESCR_ID),
FOREIGN KEY (TMODEL_KEY)
REFERENCES TMODEL (TMODEL_KEY)
);
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,
FOREIGN KEY (FROM_KEY)
REFERENCES BUSINESS_ENTITY (BUSINESS_KEY),
FOREIGN KEY (TO_KEY)
REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
);
CREATE TABLE PUBLISHER
(
..PUBLISHER_ID VARCHAR(20) NOT NULL,
..PUBLISHER_NAME VARCHAR(255) NOT NULL,
..LAST_NAME VARCHAR(150) NULL,
..FIRST_NAME VARCHAR(100) NULL,
..MIDDLE_INIT VARCHAR(5) NULL,
..WORK_PHONE VARCHAR(50) NULL,
..MOBILE_PHONE VARCHAR(50) NULL,
..PAGER VARCHAR(50) NULL,
..EMAIL_ADDRESS VARCHAR(255) NULL,
..ADMIN VARCHAR(5) NULL,
..ENABLED VARCHAR(5) NULL,
..PRIMARY KEY (PUBLISHER_ID)
);
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 INT NOT NULL,
..TOKEN_STATE INT NOT NULL,
..PRIMARY KEY (AUTH_TOKEN)
);
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) NULL,
..FAULT VARCHAR(255) NULL
);
CREATE TABLE OPERATIONAL_INFO
(
..ENTITY_KEY VARCHAR(41) NOT NULL,
..CREATED_DATE DATE NOT NULL,
..CREATED_TIME TIME NOT NULL,
..MODIFIED_DATE DATE NOT NULL,
..MODIFIED_TIME DATE NOT NULL,
..MODIFIED_INCLUDING_CHILDREN_DATE DATE NOT NULL,
..MODIFIED_INCLUDING_CHILDREN_TIME TIME NOT NULL,
..PRIMARY KEY (ENTITY_KEY)
);
CREATE TABLE OP_INFO_CHILD_TREE (
..PARENT_ENTITY_KEY VARCHAR(41) NOT NULL,
..CHILD_ENTITY_KEY VARCHAR(41) NOT NULL,
..PRIMARY KEY (PARENT_ENTITY_KEY, CHILD_ENTITY_KEY),
..FOREIGN KEY (PARENT_ENTITY_KEY) REFERENCES OPERATIONAL_INFO (ENTITY_KEY),
..FOREIGN KEY (CHILD_ENTITY_KEY) REFERENCES OPERATIONAL_INFO (ENTITY_KEY)
);
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');
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic