Author: dimuthul
Date: Fri Jan 4 00:48:00 2008
New Revision: 11837
Log:
Adding the uniqueness constraint.
Modified:
trunk/mashup/java/modules/distribution/src/database-scripts/usermanager/create_db.sql
Modified:
trunk/mashup/java/modules/distribution/src/database-scripts/usermanager/create_db.sql
==============================================================================
---
trunk/mashup/java/modules/distribution/src/database-scripts/usermanager/create_db.sql
(original)
+++
trunk/mashup/java/modules/distribution/src/database-scripts/usermanager/create_db.sql
Fri Jan 4 00:48:00 2008
@@ -1,5 +1,5 @@
CREATE TABLE UM_USER_ATTRIBUTES (ID VARCHAR(255), ATTR_NAME VARCHAR(255) NOT
NULL, ATTR_VALUE VARCHAR(255), USER_ID VARCHAR(255), PRIMARY KEY (ID));
CREATE TABLE UM_ROLE_ATTRIBUTES (ID VARCHAR(255), ATTR_NAME VARCHAR(255) NOT
NULL, ATTR_VALUE VARCHAR(255), ROLE_ID VARCHAR(255), PRIMARY KEY (ID));
CREATE TABLE UM_PERMISSIONS (ID VARCHAR(255), RESOURCE_ID VARCHAR(255) NOT
NULL, ACTION VARCHAR(255) NOT NULL, PRIMARY KEY (ID));
-CREATE TABLE UM_ROLE_PERMISSIONS (ID VARCHAR(255), PERMISSION_ID VARCHAR(255),
ROLE_ID VARCHAR(255), IS_ALLOWED SMALLINT NOT NULL, FOREIGN KEY (PERMISSION_ID)
REFERENCES UM_PERMISSIONS(ID) ON DELETE CASCADE, PRIMARY KEY (ID));
-CREATE TABLE UM_USER_PERMISSIONS (ID VARCHAR(255), IS_ALLOWED SMALLINT NOT
NULL, PERMISSION_ID VARCHAR(255), USER_ID VARCHAR(255), FOREIGN KEY
(PERMISSION_ID) REFERENCES UM_PERMISSIONS(ID) ON DELETE CASCADE, PRIMARY KEY
(ID));
\ No newline at end of file
+CREATE TABLE UM_ROLE_PERMISSIONS (ID VARCHAR(255), PERMISSION_ID VARCHAR(255)
NOT NULL, ROLE_ID VARCHAR(255) NOT NULL, IS_ALLOWED SMALLINT NOT NULL, UNIQUE
(PERMISSION_ID, ROLE_ID), FOREIGN KEY (PERMISSION_ID) REFERENCES
UM_PERMISSIONS(ID) ON DELETE CASCADE, PRIMARY KEY (ID));
+CREATE TABLE UM_USER_PERMISSIONS (ID VARCHAR(255), PERMISSION_ID VARCHAR(255)
NOT NULL, USER_ID VARCHAR(255) NOT NULL, IS_ALLOWED SMALLINT NOT NULL, UNIQUE
(PERMISSION_ID, USER_ID), FOREIGN KEY (PERMISSION_ID) REFERENCES
UM_PERMISSIONS(ID) ON DELETE CASCADE, PRIMARY KEY (ID));
_______________________________________________
Mashup-dev mailing list
[email protected]
http://www.wso2.org/cgi-bin/mailman/listinfo/mashup-dev
