You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@juddi.apache.org by ac...@apache.org on 2004/07/08 21:23:10 UTC
cvs commit: ws-juddi/sql/jdatastore create_database.sql
acutright 2004/07/08 12:23:10
Modified: sql/jdatastore create_database.sql
Log:
fixed some minor text bugs.
Revision Changes Path
1.2 +40 -40 ws-juddi/sql/jdatastore/create_database.sql
Index: create_database.sql
===================================================================
RCS file: /home/cvs/ws-juddi/sql/jdatastore/create_database.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- create_database.sql 31 May 2004 00:37:32 -0000 1.1
+++ create_database.sql 8 Jul 2004 19:23:10 -0000 1.2
@@ -378,61 +378,61 @@
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)
+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)
+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)