portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tay...@apache.org
Subject cvs commit: jakarta-jetspeed/webapp/WEB-INF/db jetspeed.script jetspeed.script.save
Date Thu, 15 Jul 2004 01:17:52 GMT
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


Mime
View raw message