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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
