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 2001/06/04 09:53:21 UTC
cvs commit: jakarta-jetspeed/webapp/WEB-INF/db hsql.jar manageDB.bat jetspeed.properties jetspeed.script
taylor 01/06/04 00:53:21
Modified: webapp/WEB-INF/db jetspeed.properties jetspeed.script
Added: webapp/WEB-INF/db hsql.jar manageDB.bat
Log:
- updated database with permissions, roles
- modified hsql.jar to have default parameters for jetspeed when logging on
- added simple .bat file to run database manager
Revision Changes Path
1.3 +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.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- jetspeed.properties 2001/01/23 08:48:31 1.2
+++ jetspeed.properties 2001/06/04 07:53:20 1.3
@@ -1,4 +1,4 @@
#Hypersonic SQL database
-#Tue Jan 23 09:45:52 CET 2001
+#Mon Jun 04 00:42:52 PDT 2001
version=1.4
modified=no
1.3 +17 -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.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- jetspeed.script 2001/01/23 08:48:31 1.2
+++ jetspeed.script 2001/06/04 07:53:20 1.3
@@ -1,19 +1,12 @@
CREATE TABLE TURBINE_PERMISSION(PERMISSION_ID INTEGER NOT NULL IDENTITY PRIMARY KEY,PERMISSION_NAME VARCHAR NOT NULL,OBJECTDATA BINARY)
-CREATE UNIQUE INDEX SYSTEM_CONSTRAINT0 ON TURBINE_PERMISSION(PERMISSION_ID)
CREATE TABLE TURBINE_ROLE(ROLE_ID INTEGER NOT NULL IDENTITY PRIMARY KEY,ROLE_NAME VARCHAR NOT NULL,OBJECTDATA BINARY)
-CREATE UNIQUE INDEX SYSTEM_CONSTRAINT0 ON TURBINE_ROLE(ROLE_ID)
CREATE TABLE TURBINE_GROUP(GROUP_ID INTEGER NOT NULL IDENTITY PRIMARY KEY,GROUP_NAME VARCHAR NOT NULL,OBJECTDATA BINARY)
-CREATE UNIQUE INDEX SYSTEM_CONSTRAINT0 ON TURBINE_GROUP(GROUP_ID)
CREATE TABLE TURBINE_ROLE_PERMISSION(ROLE_ID INTEGER NOT NULL,PERMISSION_ID INTEGER NOT NULL)
-CREATE UNIQUE INDEX SYSTEM_CONSTRAINT0 ON TURBINE_ROLE_PERMISSION(ROLE_ID,PERMISSION_ID)
CREATE INDEX ROLE_PERMISSION_INDEX ON TURBINE_ROLE_PERMISSION(ROLE_ID,PERMISSION_ID)
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,LASTLOGIN TIMESTAMP,OBJECTDATA BINARY)
-CREATE UNIQUE INDEX SYSTEM_CONSTRAINT0 ON TURBINE_USER(USER_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 SYSTEM_CONSTRAINT0 ON TURBINE_USER_GROUP_ROLE(USER_ID,GROUP_ID,ROLE_ID)
CREATE INDEX USER_GROUP_ROLE_INDEX ON TURBINE_USER_GROUP_ROLE(USER_ID,GROUP_ID,ROLE_ID)
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)
-CREATE UNIQUE INDEX SYSTEM_CONSTRAINT0 ON TURBINE_SCHEDULED_JOB(JOB_ID)
GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC
GRANT ALL ON CLASS "org.hsql.Library" TO PUBLIC
CREATE USER SA PASSWORD "" ADMIN
@@ -82,6 +75,21 @@
CREATE ALIAS LENGTH FOR "org.hsql.Library.length"
CREATE ALIAS ROUND FOR "org.hsql.Library.round"
CREATE ALIAS REPLACE FOR "org.hsql.Library.replace"
+INSERT INTO TURBINE_PERMISSION VALUES(1,'view',NULL)
+INSERT INTO TURBINE_PERMISSION VALUES(2,'customize',NULL)
+INSERT INTO TURBINE_PERMISSION VALUES(3,'maximize',NULL)
+INSERT INTO TURBINE_PERMISSION VALUES(4,'minimize',NULL)
+INSERT INTO TURBINE_PERMISSION VALUES(5,'personalize',NULL)
+INSERT INTO TURBINE_PERMISSION VALUES(6,'detach',NULL)
+INSERT INTO TURBINE_PERMISSION VALUES(7,'close',NULL)
INSERT INTO TURBINE_ROLE VALUES(1,'authenticated_user',NULL)
-INSERT INTO TURBINE_USER VALUES(0,'turbine','turbine','Turbine','Turbine',NULL,'CONFIRMED',NULL,NULL,NULL,NULL)
-INSERT INTO TURBINE_USER VALUES(1,'admin','jetspeed','Jetspeed','Admin',NULL,'CONFIRMED',NULL,NULL,NULL,NULL)
+INSERT INTO TURBINE_GROUP VALUES(1,'Jetspeed',NULL)
+INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,1)
+INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,2)
+INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,3)
+INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,4)
+INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,5)
+INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,6)
+INSERT INTO TURBINE_USER VALUES(0,'turbine','turbine','Turbine','Turbine 2','david@bluesunrise.com','CONFIRMED',NULL,NULL,NULL,'aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000050000000274000a4c4153545f4c4f47494e7372000e6a6176612e7574696c2e44617465686a81014b59741903000078707708000000e6e1b60d247874000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078700000004478')
+INSERT INTO TURBINE_USER VALUES(1,'admin','jetspeed','Jetspeed','Admin',NULL,'CONFIRMED',NULL,NULL,NULL,'aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000050000000274000a4c4153545f4c4f47494e7372000e6a6176612e7574696c2e44617465686a81014b59741903000078707708000000e6c291f20f7874000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078700000000a78')
+INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(0,1,1)
1.1 jakarta-jetspeed/webapp/WEB-INF/db/hsql.jar
<<Binary file>>
1.1 jakarta-jetspeed/webapp/WEB-INF/db/manageDB.bat
Index: manageDB.bat
===================================================================
@ECHO OFF
REM ***
@java -classpath %CLASSPATH%;hsql.jar org.hsql.util.DatabaseManager
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org