taylor 2004/07/12 10:21:53 Modified: webapp/WEB-INF/db jetspeed.script Log: db script updated for security 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.39 +9 -6 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.38 retrieving revision 1.39 diff -u -r1.38 -r1.39 --- jetspeed.script 9 Jul 2004 22:14:29 -0000 1.38 +++ jetspeed.script 12 Jul 2004 17:21:52 -0000 1.39 @@ -1,8 +1,11 @@ -CREATE TABLE J1R_PORTLET(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,NAME VARCHAR(128),HIDDEN INTEGER,CLASSNAME VARCHAR(265),TYPE VARCHAR(32),APPLICATION INTEGER,PARENT BIGINT,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 J1R_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 J1R_CATEGORY(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,NAME VARCHAR(128),GROUPE VARCHAR(128),OWNER INTEGER,CONSTRAINT J1R_CATEGORY_FK_1 FOREIGN KEY(OWNER) REFERENCES J1R_PORTLET(ID)) -CREATE TABLE J1R_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 J1R_PORTLET_PARAMETER_FK_1 FOREIGN KEY(PORTLET_ID) REFERENCES J1R_PORTLET(ID)) -CREATE TABLE J1R_PORTLET_MEDIATYPE(ID INTEGER,MEDIA_ID INTEGER,CONSTRAINT J1R_PORTLET_MEDIATYPE_FK_1 FOREIGN KEY(ID) REFERENCES J1R_PORTLET(ID),CONSTRAINT J1R_PORTLET_MEDIATYPE_FK_2 FOREIGN KEY(MEDIA_ID) REFERENCES J1R_MEDIATYPE(ID)) +CREATE TABLE PORTLET(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,NAME VARCHAR(128),HIDDEN INTEGER,CLASSNAME VARCHAR(265),TYPE VARCHAR(32),APPLICATION INTEGER,PARENT BIGINT,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,NAME VARCHAR(128),TITLE VARCHAR(128),DESCRIPTION VARCHAR(256)) +CREATE UNIQUE INDEX SYS_FK_14 ON SECURITY_ENTRY(ID) +CREATE TABLE SECURITY_ACCESS(ID BIGINT,ACTION VARCHAR(32),ALLOW_TYPE VARCHAR(32),ALLOW_VALUE VARCHAR(32),ENTRY_ID INTEGER,CONSTRAINT SECURITY_ACCESS_FK_1 FOREIGN KEY(ENTRY_ID) REFERENCES SECURITY_ENTRY(ID)) 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) @@ -25,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]
