taylor 01/06/28 09:02:06
Modified: webapp/WEB-INF/db jetspeed.properties jetspeed.script
Log:
- added 'property' binary-column to jobs table
i couldn't find a way to 'alter table' in hypersonic, so deleted the db, and
re-generating it.
Revision Changes Path
1.7 +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.6
retrieving revision 1.7
diff -u -r1.6 -r1.7
--- jetspeed.properties 2001/06/11 06:54:47 1.6
+++ jetspeed.properties 2001/06/28 16:01:53 1.7
@@ -1,4 +1,4 @@
#Hypersonic SQL database
-#Sun Jun 10 23:54:01 PDT 2001
+#Thu Jun 28 09:00:59 PDT 2001
version=1.4
modified=no
1.7 +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.6
retrieving revision 1.7
diff -u -r1.6 -r1.7
--- jetspeed.script 2001/06/11 06:54:48 1.6
+++ jetspeed.script 2001/06/28 16:01:56 1.7
@@ -2,7 +2,7 @@
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_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 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)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
