taylor 01/08/24 00:36:46
Modified: webapp/WEB-INF/db jetspeed.properties jetspeed.script
Log:
- update Hypersonic DB, column LAST_LOGIN was incorrect
Revision Changes Path
1.9 +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.8
retrieving revision 1.9
diff -u -r1.8 -r1.9
--- jetspeed.properties 2001/07/30 04:33:15 1.8
+++ jetspeed.properties 2001/08/24 07:36:46 1.9
@@ -1,4 +1,4 @@
#Hypersonic SQL database
-#Sun Jul 29 21:36:51 PDT 2001
+#Fri Aug 24 00:40:38 PDT 2001
version=1.4
modified=no
1.9 +1 -1 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.8
retrieving revision 1.9
diff -u -r1.8 -r1.9
--- jetspeed.script 2001/07/30 04:33:15 1.8
+++ jetspeed.script 2001/08/24 07:36:46 1.9
@@ -1,7 +1,7 @@
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)
-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 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)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
