Author: tyrell
Date: Thu Feb 28 22:07:30 2008
New Revision: 14334

Log:

Fixing MASHUP-699

Modified:
   
trunk/registry/modules/core/src/main/resources/database-scripts/derby-registry.sql

Modified: 
trunk/registry/modules/core/src/main/resources/database-scripts/derby-registry.sql
==============================================================================
--- 
trunk/registry/modules/core/src/main/resources/database-scripts/derby-registry.sql
  (original)
+++ 
trunk/registry/modules/core/src/main/resources/database-scripts/derby-registry.sql
  Thu Feb 28 22:07:30 2008
@@ -79,3 +79,12 @@
             FOREIGN KEY (DAID) REFERENCES ARTIFACTS (AID),
             FOREIGN KEY (AID) REFERENCES ARTIFACTS (AID));
 
+CREATE TABLE DEPENDENCY_MANAGEMENT (
+            AID INTEGER NOT NULL,
+            VN INTEGER NOT NULL,
+            DAID INTEGER NOT NULL,
+            DVN INTEGER NOT NULL,
+            DTYPE VARCHAR (20),
+            UNIQUE (AID,VN,DAID,DVN),
+            FOREIGN KEY (DAID) REFERENCES ARTIFACTS (AID),
+            FOREIGN KEY (AID) REFERENCES ARTIFACTS (AID));

_______________________________________________
Registry-dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/registry-dev

Reply via email to