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.properties jetspeed.script.save
Date Tue, 20 Jul 2004 04:15:06 GMT
taylor      2004/07/19 21:15:06

  Modified:    webapp/WEB-INF/db jetspeed.script jetspeed.properties
                        jetspeed.script.save
  Log:
  latest portlet registry schema
  
  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.42      +8 -9      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.41
  retrieving revision 1.42
  diff -u -r1.41 -r1.42
  --- jetspeed.script	15 Jul 2004 01:17:52 -0000	1.41
  +++ jetspeed.script	20 Jul 2004 04:15:06 -0000	1.42
  @@ -1,11 +1,3 @@
  -CREATE TABLE PORTLET(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,NAME VARCHAR(128),HIDDEN
INTEGER,CLASSNAME VARCHAR(265),TYPE VARCHAR(32),APPLICATION INTEGER,PARENT INTEGER,URL VARCHAR(265),CACHEDONURL
INTEGER,ROLE VARCHAR(99),TITLE VARCHAR(128),DESCRIPTION VARCHAR(256),IMAGE VARCHAR(128),SECURITY
VARCHAR(500),CONSTRAINT SYS_CT_1 UNIQUE(NAME))
  -CREATE TABLE MEDIATYPE(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,NAME VARCHAR(128),HIDDEN
INTEGER,MIMETYPE VARCHAR(128),ROLE VARCHAR(99),TITLE VARCHAR(128),DESCRIPTION VARCHAR(256),IMAGE
VARCHAR(128),CONSTRAINT SYS_CT_3 UNIQUE(NAME))
  -CREATE TABLE CATEGORY(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,NAME VARCHAR(128),GROUPE
VARCHAR(128),OWNER INTEGER,CONSTRAINT CATEGORY_FK_1 FOREIGN KEY(OWNER) REFERENCES PORTLET(ID))
  -CREATE TABLE PORTLET_PARAMETER(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,NAME VARCHAR(128),VALUE
VARCHAR(256),TYPE VARCHAR(64),HIDDEN INTEGER,ROLE VARCHAR(99),CACHEDONVALUE INTEGER,CACHEDONNAME
INTEGER,TITLE VARCHAR(128),DESCRIPTION VARCHAR(256),IMAGE VARCHAR(128),PORTLET_ID INTEGER,SECURITY
VARCHAR(500),CONSTRAINT PORTLET_PARAMETER_FK_1 FOREIGN KEY(PORTLET_ID) REFERENCES PORTLET(ID))
  -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),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 +20,15 @@
   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 "org.hsqldb.Library" TO PUBLIC
  +CREATE TABLE PORTLET(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,NAME VARCHAR(128),HIDDEN
INTEGER,CLASSNAME VARCHAR(255),TYPE VARCHAR(32),APPLICATION INTEGER,PARENT VARCHAR(128),URL
VARCHAR(255),CACHED_ON_URL INTEGER,TITLE VARCHAR(128),DESCRIPTION VARCHAR(255),IMAGE VARCHAR(128),SECURITY
VARCHAR(128),CONSTRAINT SYS_CT_1 UNIQUE(NAME))
  +CREATE TABLE PORTLET_CATEGORY(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,NAME VARCHAR(128),GROUPE
VARCHAR(128),PORTLET_ID INTEGER)
  +CREATE TABLE PORTLET_PARAMETER(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,NAME VARCHAR(128),VALUE
VARCHAR(255),TYPE VARCHAR(64),HIDDEN INTEGER,CACHED_ON_VALUE INTEGER,CACHED_ON_NAME INTEGER,TITLE
VARCHAR(128),DESCRIPTION VARCHAR(255),IMAGE VARCHAR(128),PORTLET_ID BIGINT,SECURITY VARCHAR(128))
  +CREATE TABLE PORTLET_MEDIATYPE(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,NAME VARCHAR(128),PORTLET_ID
INTEGER)
  +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),ALLOW_GROUP VARCHAR(32),ACCESS_ID INTEGER,CONSTRAINT SECURITY_ALLOW_FK_1 FOREIGN
KEY(ACCESS_ID) REFERENCES SECURITY_ACCESS(ID) ON DELETE CASCADE)
   GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC
  +GRANT ALL ON CLASS "org.hsqldb.Library" 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.37      +1 -1      jakarta-jetspeed/webapp/WEB-INF/db/jetspeed.properties
  
  Index: jetspeed.properties
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed/webapp/WEB-INF/db/jetspeed.properties,v
  retrieving revision 1.36
  retrieving revision 1.37
  diff -u -r1.36 -r1.37
  --- jetspeed.properties	13 Jul 2004 23:03:14 -0000	1.36
  +++ jetspeed.properties	20 Jul 2004 04:15:06 -0000	1.37
  @@ -1,5 +1,5 @@
   #HSQL database
  -#Tue Jul 13 15:36:30 PDT 2004
  +#Mon Jul 19 21:05:25 PDT 2004
   sql.strict_fk=false
   readonly=false
   sql.strong_fk=true
  
  
  
  1.4       +8 -9      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.3
  retrieving revision 1.4
  diff -u -r1.3 -r1.4
  --- jetspeed.script.save	15 Jul 2004 01:17:52 -0000	1.3
  +++ jetspeed.script.save	20 Jul 2004 04:15:06 -0000	1.4
  @@ -1,11 +1,3 @@
  -CREATE TABLE PORTLET(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,NAME VARCHAR(128),HIDDEN
INTEGER,CLASSNAME VARCHAR(265),TYPE VARCHAR(32),APPLICATION INTEGER,PARENT INTEGER,URL VARCHAR(265),CACHEDONURL
INTEGER,ROLE VARCHAR(99),TITLE VARCHAR(128),DESCRIPTION VARCHAR(256),IMAGE VARCHAR(128),SECURITY
VARCHAR(500),CONSTRAINT SYS_CT_1 UNIQUE(NAME))
  -CREATE TABLE MEDIATYPE(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,NAME VARCHAR(128),HIDDEN
INTEGER,MIMETYPE VARCHAR(128),ROLE VARCHAR(99),TITLE VARCHAR(128),DESCRIPTION VARCHAR(256),IMAGE
VARCHAR(128),CONSTRAINT SYS_CT_3 UNIQUE(NAME))
  -CREATE TABLE CATEGORY(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,NAME VARCHAR(128),GROUPE
VARCHAR(128),OWNER INTEGER,CONSTRAINT CATEGORY_FK_1 FOREIGN KEY(OWNER) REFERENCES PORTLET(ID))
  -CREATE TABLE PORTLET_PARAMETER(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,NAME VARCHAR(128),VALUE
VARCHAR(256),TYPE VARCHAR(64),HIDDEN INTEGER,ROLE VARCHAR(99),CACHEDONVALUE INTEGER,CACHEDONNAME
INTEGER,TITLE VARCHAR(128),DESCRIPTION VARCHAR(256),IMAGE VARCHAR(128),PORTLET_ID INTEGER,SECURITY
VARCHAR(500),CONSTRAINT PORTLET_PARAMETER_FK_1 FOREIGN KEY(PORTLET_ID) REFERENCES PORTLET(ID))
  -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),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 +20,15 @@
   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 "org.hsqldb.Library" TO PUBLIC
  +CREATE TABLE PORTLET(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,NAME VARCHAR(128),HIDDEN
INTEGER,CLASSNAME VARCHAR(255),TYPE VARCHAR(32),APPLICATION INTEGER,PARENT VARCHAR(128),URL
VARCHAR(255),CACHED_ON_URL INTEGER,TITLE VARCHAR(128),DESCRIPTION VARCHAR(255),IMAGE VARCHAR(128),SECURITY
VARCHAR(128),CONSTRAINT SYS_CT_1 UNIQUE(NAME))
  +CREATE TABLE PORTLET_CATEGORY(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,NAME VARCHAR(128),GROUPE
VARCHAR(128),PORTLET_ID INTEGER)
  +CREATE TABLE PORTLET_PARAMETER(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,NAME VARCHAR(128),VALUE
VARCHAR(255),TYPE VARCHAR(64),HIDDEN INTEGER,CACHED_ON_VALUE INTEGER,CACHED_ON_NAME INTEGER,TITLE
VARCHAR(128),DESCRIPTION VARCHAR(255),IMAGE VARCHAR(128),PORTLET_ID BIGINT,SECURITY VARCHAR(128))
  +CREATE TABLE PORTLET_MEDIATYPE(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,NAME VARCHAR(128),PORTLET_ID
INTEGER)
  +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),ALLOW_GROUP VARCHAR(32),ACCESS_ID INTEGER,CONSTRAINT SECURITY_ALLOW_FK_1 FOREIGN
KEY(ACCESS_ID) REFERENCES SECURITY_ACCESS(ID) ON DELETE CASCADE)
   GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC
  +GRANT ALL ON CLASS "org.hsqldb.Library" 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