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

[svn at wso2.org]

Author: chathura
Date: Sun Mar  9 10:44:49 2008
New Revision: 14618

Log:


updated the derby scripts to support multivalued properties.



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

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	Sun Mar  9 10:44:49 2008
@@ -15,7 +15,7 @@
                 PKEY VARCHAR (100) NOT NULL,
                 PVALUE VARCHAR (500) NOT NULL,
                 PRIMARY KEY (P_ID),
-                UNIQUE (AID, PKEY),
+                UNIQUE (AID, PKEY, PVALUE),
                 FOREIGN KEY (AID) REFERENCES ARTIFACTS (AID));
 
 CREATE TABLE CHILDREN (CID INTEGER GENERATED ALWAYS AS IDENTITY,

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	Sun Mar  9 10:44:49 2008
@@ -17,7 +17,7 @@
                 PKEY VARCHAR (100) NOT NULL,
                 PVALUE VARCHAR (500) NOT NULL,
                 PRIMARY KEY (P_ID),
-                UNIQUE (AID, PKEY),
+                UNIQUE (AID, PKEY, PVALUE),
                 FOREIGN KEY (AID) REFERENCES ARTIFACTS (AID));
 
 CREATE TABLE CHILDREN (CID INTEGER GENERATED ALWAYS AS IDENTITY,