Return-Path: Mailing-List: contact juddi-cvs-help@ws.apache.org; run by ezmlm Delivered-To: mailing list juddi-cvs@ws.apache.org Received: (qmail 69214 invoked from network); 8 Apr 2004 22:32:31 -0000 Received: from unknown (HELO minotaur.apache.org) (209.237.227.194) by daedalus.apache.org with SMTP; 8 Apr 2004 22:32:31 -0000 Received: (qmail 60738 invoked by uid 1760); 8 Apr 2004 22:32:44 -0000 Date: 8 Apr 2004 22:32:44 -0000 Message-ID: <20040408223244.60734.qmail@minotaur.apache.org> From: acutright@apache.org To: ws-juddi-cvs@apache.org Subject: cvs commit: ws-juddi/dbscripts juddi_jds.sql X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N acutright 2004/04/08 15:32:44 Modified: dbscripts juddi_jds.sql Log: initial work for subscription API implementation Revision Changes Path 1.2 +56 -32 ws-juddi/dbscripts/juddi_jds.sql Index: juddi_jds.sql =================================================================== RCS file: /home/cvs/ws-juddi/dbscripts/juddi_jds.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -u -r1.1 -r1.2 --- juddi_jds.sql 11 Nov 2003 13:59:22 -0000 1.1 +++ juddi_jds.sql 8 Apr 2004 22:32:44 -0000 1.2 @@ -30,6 +30,8 @@ --DROP TABLE PUBLISHER; --DROP TABLE AUTH_TOKEN; --DROP TABLE MONITOR; +--DROP TABLE OPERATIONAL_INFO; +--DROP TABLE OP_INFO_CHILD_TREE; CREATE TABLE BUSINESS_ENTITY @@ -376,55 +378,77 @@ 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) + 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) + 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 + 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'); @@ -558,10 +582,10 @@ 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'); +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.'); +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');