You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@juddi.apache.org by sv...@apache.org on 2005/05/23 06:40:27 UTC
cvs commit: ws-juddi/sql/jdatastore create_database.sql
sviens 2005/05/22 21:40:27
Modified: sql/jdatastore create_database.sql
Log:
Removed unused create table statements for OPERATIONAL_INFO_TABLE and OPERATIONAL_INFO_CHILD_TABLE
Revision Changes Path
1.5 +0 -20 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.4
retrieving revision 1.5
diff -u -r1.4 -r1.5
--- create_database.sql 2 Mar 2005 11:13:54 -0000 1.4
+++ create_database.sql 23 May 2005 04:40:27 -0000 1.5
@@ -409,26 +409,6 @@
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);
---------------------------------------------------------------------
To unsubscribe, e-mail: juddi-cvs-unsubscribe@ws.apache.org
For additional commands, e-mail: juddi-cvs-help@ws.apache.org