Author: prabath Date: Mon Feb 18 02:48:34 2008 New Revision: 13854 Log:
added new tables Modified: trunk/solutions/identity/modules/identity-provider/conf/default-store.sql Modified: trunk/solutions/identity/modules/identity-provider/conf/default-store.sql ============================================================================== --- trunk/solutions/identity/modules/identity-provider/conf/default-store.sql (original) +++ trunk/solutions/identity/modules/identity-provider/conf/default-store.sql Mon Feb 18 02:48:34 2008 @@ -6,4 +6,6 @@ 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, FOREIGN KEY (ROLE_ID) REFERENCES UM_ROLES(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, 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), USER_ID VARCHAR(255), 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) NOT NULL UNIQUE, PROFILE_ID VARCHAR(255) NOT NULL UNIQUE,PROFILE_NAME VARCHAR(255) NOT NULL,IS_DEFAULT SMALLINT NOT NULL, PRIMARY KEY (ID)); +CREATE TABLE USER_PROFILE_VALUES (ID VARCHAR(255), ATTR_NAME VARCHAR(255) NOT NULL, ATTR_VALUE VARCHAR(255), PROFILE_ID VARCHAR(255), PRIMARY KEY (ID)); _______________________________________________ Identity-dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/identity-dev
