You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by ta...@apache.org on 2004/07/15 03:17:52 UTC
cvs commit: jakarta-jetspeed/webapp/WEB-INF/db jetspeed.script jetspeed.script.save
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: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org