taylor 2004/07/09 15:14:29 Modified: webapp/WEB-INF/db jetspeed.script jetspeed.properties Log: adding schema for DB registry 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.38 +6 -5 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.37 retrieving revision 1.38 diff -u -r1.37 -r1.38 --- jetspeed.script 10 Mar 2004 23:56:33 -0000 1.37 +++ jetspeed.script 9 Jul 2004 22:14:29 -0000 1.38 @@ -1,3 +1,8 @@ +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 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) @@ -124,6 +129,7 @@ INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,1) INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,2) INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(3,1,3) +INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(8,1,1) INSERT INTO ID_TABLE VALUES(1,'TURBINE_PERMISSION',450,10) INSERT INTO ID_TABLE VALUES(2,'TURBINE_ROLE',530,10) INSERT INTO ID_TABLE VALUES(3,'TURBINE_GROUP',460,10) @@ -172,8 +178,3 @@ INSERT INTO COFFEES VALUES(9,'KenyanGrade',2,7.99E0,1,2) INSERT INTO COFFEES VALUES(10,'JoeGrade',3,7.99E0,1,2) INSERT INTO COFFEES VALUES(11,'CantThinkOfAnymoreGrade',4,7.99E0,1,2) -/*C2*/CONNECT USER sa PASSWORD "" -SET AUTOCOMMIT TRUE -SET READONLY FALSE -SET AUTOCOMMIT TRUE -SET READONLY FALSE 1.35 +2 -16 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.34 retrieving revision 1.35 diff -u -r1.34 -r1.35 --- jetspeed.properties 17 Mar 2004 19:22:48 -0000 1.34 +++ jetspeed.properties 9 Jul 2004 22:14:29 -0000 1.35 @@ -1,19 +1,5 @@ -# Copyright 2004 The Apache Software Foundation -# -# Licensed under the Apache License, Version 2.0 (the "License"); -# you may not use this file except in compliance with the License. -# You may obtain a copy of the License at -# -# http://www.apache.org/licenses/LICENSE-2.0 -# -# Unless required by applicable law or agreed to in writing, software -# distributed under the License is distributed on an "AS IS" BASIS, -# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. -# See the License for the specific language governing permissions and -# limitations under the License. - #HSQL database -#Wed Feb 18 08:56:03 CST 2004 +#Fri Jul 09 15:12:37 PDT 2004 sql.strict_fk=false readonly=false sql.strong_fk=true @@ -23,7 +9,7 @@ sql.compare_in_locale=false sql.month=true hsqldb.log_size=200 -modified=yes +modified=no 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]
