taylor 2004/07/14 18:17:52 Modified: webapp/WEB-INF/db jetspeed.script jetspeed.script.save Log: add support for group/role constraints CVS: ---------------------------------------------------------------------- CVS: PR: CVS: If this change addresses a PR in the problem report tracking CVS: database, then enter the PR number(s) here. CVS: Obtained from: CVS: If this change has been taken from another system, such as NCSA, CVS: then name the system in this line, otherwise delete it. CVS: Submitted by: CVS: If this code has been contributed to Apache by someone else; i.e., CVS: they sent us a patch or a new module, then include their name/email CVS: address here. If this is your work then delete this line. CVS: Reviewed by: CVS: If we are doing pre-commit code reviews and someone else has CVS: reviewed your changes, include their name(s) here. CVS: If you have not had it reviewed then delete this line. Revision Changes Path 1.41 +2 -2 jakarta-jetspeed/webapp/WEB-INF/db/jetspeed.script Index: jetspeed.script =================================================================== RCS file: /home/cvs/jakarta-jetspeed/webapp/WEB-INF/db/jetspeed.script,v retrieving revision 1.40 retrieving revision 1.41 diff -u -r1.40 -r1.41 --- jetspeed.script 13 Jul 2004 22:57:00 -0000 1.40 +++ jetspeed.script 15 Jul 2004 01:17:52 -0000 1.41 @@ -5,7 +5,7 @@ CREATE TABLE PORTLET_MEDIATYPE(ID INTEGER,MEDIA_ID INTEGER,CONSTRAINT PORTLET_MEDIATYPE_FK_1 FOREIGN KEY(ID) REFERENCES PORTLET(ID),CONSTRAINT PORTLET_MEDIATYPE_FK_2 FOREIGN KEY(MEDIA_ID) REFERENCES MEDIATYPE(ID)) CREATE TABLE SECURITY_ENTRY(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,NAME VARCHAR(128),TITLE VARCHAR(128),DESCRIPTION VARCHAR(256),CONSTRAINT SYS_CT_13 UNIQUE(NAME)) CREATE TABLE SECURITY_ACCESS(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,ACTION VARCHAR(32),ENTRY_ID INTEGER,CONSTRAINT SECURITY_ACCESS_FK_1 FOREIGN KEY(ENTRY_ID) REFERENCES SECURITY_ENTRY(ID) ON DELETE CASCADE) -CREATE TABLE SECURITY_ALLOW(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,ALLOW_TYPE VARCHAR(32),ALLOW_VALUE VARCHAR(32),ACCESS_ID INTEGER,CONSTRAINT SECURITY_ALLOW_FK_1 FOREIGN KEY(ACCESS_ID) REFERENCES SECURITY_ACCESS(ID) ON DELETE CASCADE) +CREATE TABLE SECURITY_ALLOW(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,ALLOW_TYPE VARCHAR(32),ALLOW_VALUE VARCHAR(32),ALLOW_GROUP VARCHAR(32),ACCESS_ID INTEGER,CONSTRAINT SECURITY_ALLOW_FK_1 FOREIGN KEY(ACCESS_ID) REFERENCES SECURITY_ACCESS(ID) ON DELETE CASCADE) CREATE TABLE TURBINE_PERMISSION(PERMISSION_ID INTEGER NOT NULL IDENTITY PRIMARY KEY,PERMISSION_NAME VARCHAR NOT NULL,OBJECTDATA BINARY) CREATE TABLE TURBINE_ROLE(ROLE_ID INTEGER NOT NULL IDENTITY PRIMARY KEY,ROLE_NAME VARCHAR NOT NULL,OBJECTDATA BINARY) CREATE TABLE TURBINE_GROUP(GROUP_ID INTEGER NOT NULL IDENTITY PRIMARY KEY,GROUP_NAME VARCHAR NOT NULL,OBJECTDATA BINARY) @@ -28,8 +28,8 @@ CREATE TABLE EMAIL_INBOX(EMAIL_INBOX_ID INTEGER NOT NULL PRIMARY KEY,MESSAGE_ID VARCHAR(255),FILENAME VARCHAR(255),ATTACHMENT BINARY,READFLAG INTEGER) CREATE TABLE JETSPEED_ACL(ACL_ID INTEGER,SECURITY_ID INTEGER,RESOURCE VARCHAR,RESOURCE_TYPE VARCHAR,ACTION VARCHAR,ALLOW_TYPE VARCHAR,PRINCIPAL VARCHAR,CONSTRAINT SYS_CT_17 UNIQUE(ACL_ID)) CREATE INDEX JETSPEED_ACL_I_2 ON JETSPEED_ACL(SECURITY_ID) -GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC GRANT ALL ON CLASS "org.hsqldb.Library" TO PUBLIC +GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC GRANT ALL ON CLASS "org.hsql.Library" TO PUBLIC CREATE USER SA PASSWORD "" ADMIN CREATE ALIAS DAYNAME FOR "org.hsqldb.Library.dayname" 1.3 +2 -2 jakarta-jetspeed/webapp/WEB-INF/db/jetspeed.script.save Index: jetspeed.script.save =================================================================== RCS file: /home/cvs/jakarta-jetspeed/webapp/WEB-INF/db/jetspeed.script.save,v retrieving revision 1.2 retrieving revision 1.3 diff -u -r1.2 -r1.3 --- jetspeed.script.save 13 Jul 2004 23:03:04 -0000 1.2 +++ jetspeed.script.save 15 Jul 2004 01:17:52 -0000 1.3 @@ -5,7 +5,7 @@ CREATE TABLE PORTLET_MEDIATYPE(ID INTEGER,MEDIA_ID INTEGER,CONSTRAINT PORTLET_MEDIATYPE_FK_1 FOREIGN KEY(ID) REFERENCES PORTLET(ID),CONSTRAINT PORTLET_MEDIATYPE_FK_2 FOREIGN KEY(MEDIA_ID) REFERENCES MEDIATYPE(ID)) CREATE TABLE SECURITY_ENTRY(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,NAME VARCHAR(128),TITLE VARCHAR(128),DESCRIPTION VARCHAR(256),CONSTRAINT SYS_CT_13 UNIQUE(NAME)) CREATE TABLE SECURITY_ACCESS(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,ACTION VARCHAR(32),ENTRY_ID INTEGER,CONSTRAINT SECURITY_ACCESS_FK_1 FOREIGN KEY(ENTRY_ID) REFERENCES SECURITY_ENTRY(ID) ON DELETE CASCADE) -CREATE TABLE SECURITY_ALLOW(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,ALLOW_TYPE VARCHAR(32),ALLOW_VALUE VARCHAR(32),ACCESS_ID INTEGER,CONSTRAINT SECURITY_ALLOW_FK_1 FOREIGN KEY(ACCESS_ID) REFERENCES SECURITY_ACCESS(ID) ON DELETE CASCADE) +CREATE TABLE SECURITY_ALLOW(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,ALLOW_TYPE VARCHAR(32),ALLOW_VALUE VARCHAR(32),ALLOW_GROUP VARCHAR(32),ACCESS_ID INTEGER,CONSTRAINT SECURITY_ALLOW_FK_1 FOREIGN KEY(ACCESS_ID) REFERENCES SECURITY_ACCESS(ID) ON DELETE CASCADE) CREATE TABLE TURBINE_PERMISSION(PERMISSION_ID INTEGER NOT NULL IDENTITY PRIMARY KEY,PERMISSION_NAME VARCHAR NOT NULL,OBJECTDATA BINARY) CREATE TABLE TURBINE_ROLE(ROLE_ID INTEGER NOT NULL IDENTITY PRIMARY KEY,ROLE_NAME VARCHAR NOT NULL,OBJECTDATA BINARY) CREATE TABLE TURBINE_GROUP(GROUP_ID INTEGER NOT NULL IDENTITY PRIMARY KEY,GROUP_NAME VARCHAR NOT NULL,OBJECTDATA BINARY) @@ -28,8 +28,8 @@ CREATE TABLE EMAIL_INBOX(EMAIL_INBOX_ID INTEGER NOT NULL PRIMARY KEY,MESSAGE_ID VARCHAR(255),FILENAME VARCHAR(255),ATTACHMENT BINARY,READFLAG INTEGER) CREATE TABLE JETSPEED_ACL(ACL_ID INTEGER,SECURITY_ID INTEGER,RESOURCE VARCHAR,RESOURCE_TYPE VARCHAR,ACTION VARCHAR,ALLOW_TYPE VARCHAR,PRINCIPAL VARCHAR,CONSTRAINT SYS_CT_17 UNIQUE(ACL_ID)) CREATE INDEX JETSPEED_ACL_I_2 ON JETSPEED_ACL(SECURITY_ID) -GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC GRANT ALL ON CLASS "org.hsqldb.Library" TO PUBLIC +GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC GRANT ALL ON CLASS "org.hsql.Library" TO PUBLIC CREATE USER SA PASSWORD "" ADMIN CREATE ALIAS DAYNAME FOR "org.hsqldb.Library.dayname"
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
