taylor 2004/07/21 11:59:19 Modified: webapp/WEB-INF/db jetspeed.script jetspeed.properties Log: update the db 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.43 +4 -4 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.42 retrieving revision 1.43 diff -u -r1.42 -r1.43 --- jetspeed.script 20 Jul 2004 04:15:06 -0000 1.42 +++ jetspeed.script 21 Jul 2004 18:59:19 -0000 1.43 @@ -21,10 +21,10 @@ 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) 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 PORTLET_CATEGORY(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,NAME VARCHAR(128),GROUPE VARCHAR(128),PORTLET_ID INTEGER,CONSTRAINT PORTLET_CATEGORY_FK_1 FOREIGN KEY(PORTLET_ID) REFERENCES PORTLET(ID) ON DELETE CASCADE) +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 INTEGER,SECURITY VARCHAR(128),CONSTRAINT PORTLET_PARAMETER_FK_1 FOREIGN KEY(PORTLET_ID) REFERENCES PORTLET(ID) ON DELETE CASCADE) +CREATE TABLE PORTLET_MEDIATYPE(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,NAME VARCHAR(128),PORTLET_ID INTEGER,CONSTRAINT PORTLET_MEDIATYPE_FK_1 FOREIGN KEY(PORTLET_ID) REFERENCES PORTLET(ID) ON DELETE CASCADE) +CREATE TABLE SECURITY_ENTRY(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,NAME VARCHAR(128),TITLE VARCHAR(128),DESCRIPTION VARCHAR(256),CONSTRAINT SYS_CT_21 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 1.38 +2 -2 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.37 retrieving revision 1.38 diff -u -r1.37 -r1.38 --- jetspeed.properties 20 Jul 2004 04:15:06 -0000 1.37 +++ jetspeed.properties 21 Jul 2004 18:59:19 -0000 1.38 @@ -1,5 +1,5 @@ #HSQL database -#Mon Jul 19 21:05:25 PDT 2004 +#Wed Jul 21 11:44:06 PDT 2004 sql.strict_fk=false readonly=false sql.strong_fk=true @@ -9,7 +9,7 @@ sql.compare_in_locale=false sql.month=true hsqldb.log_size=200 -modified=no +modified=yes hsqldb.cache_version=1.7.0 hsqldb.original_version=1.7.1 hsqldb.compatible_version=1.7.0
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
