taylor 01/11/11 19:43:01
Modified: webapp/WEB-INF/conf JetspeedResources.properties
webapp/WEB-INF/db jetspeed.properties jetspeed.script
Log:
-added an PsmlImportManager service - this is still a little under construction
- updated the default hypersonic database to now contain the dbpsml tables
Revision Changes Path
1.43 +11 -1 jakarta-jetspeed/webapp/WEB-INF/conf/JetspeedResources.properties
Index: JetspeedResources.properties
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/webapp/WEB-INF/conf/JetspeedResources.properties,v
retrieving revision 1.42
retrieving revision 1.43
diff -u -r1.42 -r1.43
--- JetspeedResources.properties 2001/10/27 04:31:19 1.42
+++ JetspeedResources.properties 2001/11/12 03:43:01 1.43
@@ -1,7 +1,7 @@
################################################################################
# Jetspeed Configuration
# Author: Kevin A. Burton (burton@apache.org)
-# $Id: JetspeedResources.properties,v 1.42 2001/10/27 04:31:19 paulsp Exp $
+# $Id: JetspeedResources.properties,v 1.43 2001/11/12 03:43:01 taylor Exp $
################################################################################
# This is the main file you will need to configuration Jetspeed. If there are
# any secondary files they will be pointed to from this file.
@@ -318,9 +318,19 @@
# PSMLManager Service #
#########################################
services.PsmlManager.classname=org.apache.jetspeed.services.psmlmanager.CastorPsmlManagerService
+#services.PsmlManager.classname=org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService
+#services.PsmlImportManager.classname=org.apache.jetspeed.services.psmlmanager.CastorPsmlManagerService
+# DST: imo this should be removed and the DatabaseInitializer should be replaced with
the PsmlImporter
# The webapp relative path to the root profiling directory
services.PsmlManager.root=/WEB-INF/psml
+services.PsmlManager.refresh-rate=28800000
+services.PsmlManager.templates=/WEB-INF/psml/
+services.PsmlManager.ext=.psml
+services.PsmlManager.default-resource=default.psml
+services.PsmlManager.media-types=html:wml
+services.PsmlManager.admin=admin
+
#########################################
# Portlet Factory #
1.10 +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.9
retrieving revision 1.10
diff -u -r1.9 -r1.10
--- jetspeed.properties 2001/08/24 07:36:46 1.9
+++ jetspeed.properties 2001/11/12 03:43:01 1.10
@@ -1,4 +1,4 @@
#Hypersonic SQL database
-#Fri Aug 24 00:40:38 PDT 2001
+#Sun Nov 11 18:51:45 PST 2001
version=1.4
modified=no
1.10 +10 -3 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.9
retrieving revision 1.10
diff -u -r1.9 -r1.10
--- jetspeed.script 2001/08/24 07:36:46 1.9
+++ jetspeed.script 2001/11/12 03:43:01 1.10
@@ -2,13 +2,20 @@
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)
CREATE TABLE TURBINE_USER(USER_ID INTEGER NOT NULL IDENTITY PRIMARY KEY,LOGIN_NAME VARCHAR
NOT NULL,PASSWORD_VALUE VARCHAR NOT NULL,FIRST_NAME VARCHAR NOT NULL,LAST_NAME VARCHAR NOT
NULL,EMAIL VARCHAR,CONFIRM_VALUE VARCHAR,MODIFIED TIMESTAMP,CREATED TIMESTAMP,LAST_LOGIN TIMESTAMP,OBJECTDATA
BINARY)
-CREATE TABLE TURBINE_SCHEDULED_JOB(JOB_ID INTEGER NOT NULL,SECOND INTEGER NOT NULL,MINUTE
INTEGER NOT NULL,HOUR INTEGER NOT NULL,WEEK_DAY INTEGER NOT NULL,DAY_OF_MONTH INTEGER NOT
NULL,TASK VARCHAR NOT NULL,EMAIL VARCHAR,PROPERTY BINARY,UNIQUE(JOB_ID))
CREATE TABLE TURBINE_ROLE_PERMISSION(ROLE_ID INTEGER NOT NULL,PERMISSION_ID INTEGER NOT
NULL)
CREATE UNIQUE INDEX ROLE_PERMISSION_INDEX ON TURBINE_ROLE_PERMISSION(ROLE_ID,PERMISSION_ID)
CREATE TABLE TURBINE_USER_GROUP_ROLE(USER_ID INTEGER NOT NULL,GROUP_ID INTEGER NOT NULL,ROLE_ID
INTEGER NOT NULL)
CREATE UNIQUE INDEX USER_GROUP_ROLE_INDEX ON TURBINE_USER_GROUP_ROLE(USER_ID,GROUP_ID,ROLE_ID)
CREATE TABLE ID_TABLE(ID_TABLE_ID INTEGER NOT NULL PRIMARY KEY,TABLE_NAME VARCHAR NOT NULL,NEXT_ID
INTEGER,QUANTITY INTEGER)
CREATE UNIQUE INDEX ID_TABLE_NAME_INDEX ON ID_TABLE(TABLE_NAME)
+CREATE TABLE JETSPEED_USER_PROFILE(PSML_ID INTEGER IDENTITY PRIMARY KEY,USER_NAME VARCHAR,MEDIA_TYPE
VARCHAR,LANGUAGE VARCHAR,COUNTRY VARCHAR,PAGE VARCHAR,PROFILE BINARY,UNIQUE(PSML_ID),UNIQUE(USER_NAME,MEDIA_TYPE,LANGUAGE,COUNTRY,PAGE))
+CREATE INDEX JETSPEED_USER_PROFILE_INDEX ON JETSPEED_USER_PROFILE(USER_NAME,MEDIA_TYPE,LANGUAGE,COUNTRY,PAGE)
+CREATE TABLE JETSPEED_GROUP_PROFILE(PSML_ID INTEGER IDENTITY PRIMARY KEY,GROUP_NAME VARCHAR,MEDIA_TYPE
VARCHAR,LANGUAGE VARCHAR,COUNTRY VARCHAR,PAGE VARCHAR,PROFILE BINARY,UNIQUE(PSML_ID),UNIQUE(GROUP_NAME,MEDIA_TYPE,LANGUAGE,COUNTRY,PAGE))
+CREATE INDEX JETSPEED_GROUP_PROFILE_INDEX ON JETSPEED_GROUP_PROFILE(GROUP_NAME,MEDIA_TYPE,LANGUAGE,COUNTRY,PAGE)
+CREATE TABLE JETSPEED_ROLE_PROFILE(PSML_ID INTEGER IDENTITY PRIMARY KEY,ROLE_NAME VARCHAR,MEDIA_TYPE
VARCHAR,LANGUAGE VARCHAR,COUNTRY VARCHAR,PAGE VARCHAR,PROFILE BINARY,UNIQUE(PSML_ID),UNIQUE(ROLE_NAME,MEDIA_TYPE,LANGUAGE,COUNTRY,PAGE))
+CREATE INDEX JETSPEED_ROLE_PROFILE_INDEX ON JETSPEED_ROLE_PROFILE(ROLE_NAME,MEDIA_TYPE,LANGUAGE,COUNTRY,PAGE)
+CREATE TABLE JETSPEED_ANON_PROFILE(PSML_ID INTEGER IDENTITY PRIMARY KEY,MEDIA_TYPE VARCHAR,LANGUAGE
VARCHAR,COUNTRY VARCHAR,PAGE VARCHAR,PROFILE BINARY,UNIQUE(PSML_ID),UNIQUE(MEDIA_TYPE,LANGUAGE,COUNTRY,PAGE))
+CREATE INDEX JETSPEED_ANON_PROFILE_INDEX ON JETSPEED_ANON_PROFILE(MEDIA_TYPE,LANGUAGE,COUNTRY,PAGE)
GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC
GRANT ALL ON CLASS "org.hsql.Library" TO PUBLIC
CREATE USER SA PASSWORD "" ADMIN
@@ -89,8 +96,8 @@
INSERT INTO TURBINE_ROLE VALUES(2,'admin',NULL)
INSERT INTO TURBINE_GROUP VALUES(1,'Jetspeed',NULL)
INSERT INTO TURBINE_GROUP VALUES(2,'apache',NULL)
-INSERT INTO TURBINE_USER VALUES(0,'turbine','turbine','Tommy','Turbine','david@bluesunrise.com','CONFIRMED',NULL,NULL,NULL,'aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000050000000274000a4c4153545f4c4f47494e7372000e6a6176612e7574696c2e44617465686a81014b5974190300007870770800000000000000007874000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078700000007478')
-INSERT INTO TURBINE_USER VALUES(1,'admin','jetspeed','Jetspeed','Admin','david@bluesunrise.com','CONFIRMED',NULL,NULL,NULL,'aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000050000000274000a4c4153545f4c4f47494e7372000e6a6176612e7574696c2e44617465686a81014b5974190300007870770800000000000000007874000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b0200007870000000a778')
+INSERT INTO TURBINE_USER VALUES(0,'turbine','turbine','Tommy','Turbine','david@bluesunrise.com','CONFIRMED',NULL,NULL,'2001-11-11
18:45:32.671','aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000027708000000030000000174000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078700000007678')
+INSERT INTO TURBINE_USER VALUES(1,'admin','jetspeed','Jetspeed','Admin','david@bluesunrise.com','CONFIRMED',NULL,NULL,'2001-11-11
18:45:41.671','aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000027708000000030000000174000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b0200007870000000a978')
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,1)
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,2)
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,3)
--
To unsubscribe, e-mail: <mailto:jetspeed-dev-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:jetspeed-dev-help@jakarta.apache.org>
|