You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by ta...@apache.org on 2004/07/10 00:14:29 UTC
cvs commit: jakarta-jetspeed/webapp/WEB-INF/db jetspeed.script jetspeed.properties
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: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org