juddi-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From acutri...@apache.org
Subject cvs commit: ws-juddi/dbscripts juddi_jds.sql
Date Thu, 08 Apr 2004 22:32:44 GMT
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');
  
  
  

Mime
View raw message