[Registry-dev] svn commit r15517 - trunk/registry/modules/core/src/main/resources/database-scripts

[svn at wso2.org]

Author: deepal
Date: Thu Apr  3 04:17:11 2008
New Revision: 15517

Log:

adding SQL to other db scripts 

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

Modified: trunk/registry/modules/core/src/main/resources/database-scripts/derby-complete.sql
==============================================================================
--- trunk/registry/modules/core/src/main/resources/database-scripts/derby-complete.sql	(original)
+++ trunk/registry/modules/core/src/main/resources/database-scripts/derby-complete.sql	Thu Apr  3 04:17:11 2008
@@ -150,3 +150,11 @@
 			FOREIGN KEY (ROLE_ID) REFERENCES UM_ROLES(ID) ON DELETE CASCADE, 
 			FOREIGN KEY (USER_ID) REFERENCES UM_USERS(ID) ON DELETE CASCADE, 
 			PRIMARY KEY (ID));
+
+CREATE TABLE ASSOCIATION (
+            ASSOCIATION_ID INTEGER GENERATED BY DEFAULT AS IDENTITY,
+            RID1 INTEGER  NOT NULL,
+            RID2 INTEGER  NOT NULL,
+            ASSOCIATION_TYPE VARCHAR (20) NOT NULL,
+            UNIQUE (RID1, RID2, ASSOCIATION_TYPE),
+            FOREIGN KEY (RID1) REFERENCES ARTIFACTS (AID),FOREIGN KEY (RID2) REFERENCES ARTIFACTS (AID));

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 Apr  3 04:17:11 2008
@@ -88,3 +88,11 @@
             UNIQUE (AID,VN,DAID,DVN),
             FOREIGN KEY (DAID) REFERENCES ARTIFACTS (AID),
             FOREIGN KEY (AID) REFERENCES ARTIFACTS (AID));
+
+CREATE TABLE ASSOCIATION (
+            ASSOCIATION_ID INTEGER GENERATED BY DEFAULT AS IDENTITY,
+            RID1 INTEGER  NOT NULL,
+            RID2 INTEGER  NOT NULL,
+            ASSOCIATION_TYPE VARCHAR (20) NOT NULL,
+            UNIQUE (RID1, RID2, ASSOCIATION_TYPE),
+            FOREIGN KEY (RID1) REFERENCES ARTIFACTS (AID),FOREIGN KEY (RID2) REFERENCES ARTIFACTS (AID));

Modified: trunk/registry/modules/core/src/main/resources/database-scripts/hsql-registry.sql
==============================================================================
--- trunk/registry/modules/core/src/main/resources/database-scripts/hsql-registry.sql	(original)
+++ trunk/registry/modules/core/src/main/resources/database-scripts/hsql-registry.sql	Thu Apr  3 04:17:11 2008
@@ -140,3 +140,11 @@
 			FOREIGN KEY (ROLE_ID) REFERENCES UM_ROLES(ID) ON DELETE CASCADE, 
 			FOREIGN KEY (USER_ID) REFERENCES UM_USERS(ID) ON DELETE CASCADE, 
 			PRIMARY KEY (ID));
+			
+CREATE TABLE ASSOCIATION (
+            ASSOCIATION_ID INTEGER GENERATED BY DEFAULT AS IDENTITY,
+            RID1 INTEGER  NOT NULL,
+            RID2 INTEGER  NOT NULL,
+            ASSOCIATION_TYPE VARCHAR (20) NOT NULL,
+            UNIQUE (RID1, RID2, ASSOCIATION_TYPE),
+            FOREIGN KEY (RID1) REFERENCES ARTIFACTS (AID),FOREIGN KEY (RID2) REFERENCES ARTIFACTS (AID));
\ No newline at end of file