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 ([EMAIL PROTECTED]) -# $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','[EMAIL PROTECTED]','CONFIRMED',NULL,NULL,NULL,'aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000050000000274000a4c4153545f4c4f47494e7372000e6a6176612e7574696c2e44617465686a81014b5974190300007870770800000000000000007874000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078700000007478') -INSERT INTO TURBINE_USER VALUES(1,'admin','jetspeed','Jetspeed','Admin','[EMAIL PROTECTED]','CONFIRMED',NULL,NULL,NULL,'aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000050000000274000a4c4153545f4c4f47494e7372000e6a6176612e7574696c2e44617465686a81014b5974190300007870770800000000000000007874000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b0200007870000000a778') +INSERT INTO TURBINE_USER VALUES(0,'turbine','turbine','Tommy','Turbine','[EMAIL PROTECTED]','CONFIRMED',NULL,NULL,'2001-11-11 18:45:32.671','aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000027708000000030000000174000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078700000007678') +INSERT INTO TURBINE_USER VALUES(1,'admin','jetspeed','Jetspeed','Admin','[EMAIL PROTECTED]','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:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>