Author: dimuthul Date: Wed Feb 13 22:25:24 2008 New Revision: 13719 Log:
Adding database creation scripts. Modified: trunk/commons/usermanager/modules/core/src/main/java/org/wso2/usermanager/readwrite/create_db.sql Modified: trunk/commons/usermanager/modules/core/src/main/java/org/wso2/usermanager/readwrite/create_db.sql ============================================================================== --- trunk/commons/usermanager/modules/core/src/main/java/org/wso2/usermanager/readwrite/create_db.sql (original) +++ trunk/commons/usermanager/modules/core/src/main/java/org/wso2/usermanager/readwrite/create_db.sql Wed Feb 13 22:25:24 2008 @@ -7,4 +7,4 @@ 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, FOREIGN KEY (USER_ID) REFERENCES UM_USERS(ID) ON DELETE CASCADE, PRIMARY KEY (ID)); CREATE TABLE UM_USER_ROLES (ID VARCHAR(255), ROLE_ID VARCHAR(255) NOT NULL, USER_ID VARCHAR(255) NOT NULL, UNIQUE (USER_ID, ROLE_ID), 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 USER_PROFILE (ID VARCHAR(255), USER_ID VARCHAR(255), PROFILE_NAME VARCHAR(255), IS_DEFAULT SMALLINT, FOREIGN KEY (USER_ID) REFERENCES UM_USERS(ID) ON DELETE CASCADE, PRIMARY KEY (ID)); -CREATE TABLE PROFILE_ATTRIBUTES (ID VARCHAR(255), USER_PROFILE_ID VARCHAR(255), ATTRIBUTE_NAME VARCHAR(255), ATTRIBUTE_VALUE VARCHAR(255), FOREIGN KEY (USER_PROFILE_ID) REFERENCES USER_PROFILE(ID) ON DELETE CASCADE, PRIMARY KEY (ID)); +CREATE TABLE PROFILE_ATTRIBUTES (ID VARCHAR(255), USER_PROFILE_ID VARCHAR(255), ATTRIBUTE_NAME VARCHAR(255), ATTRIBUTE_VALUE VARCHAR(255), FOREIGN KEY (USER_PROFILE_ID) REFERENCES USER_PROFILE(ID) ON DELETE CASCADE, PRIMARY KEY (ID)); \ No newline at end of file _______________________________________________ Commons-dev mailing list Commons-dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/commons-dev
