portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tay...@apache.org
Subject cvs commit: jakarta-jetspeed/webapp/WEB-INF/db jetspeed.properties jetspeed.script
Date Thu, 28 Jun 2001 16:02:07 GMT
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: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org


Mime
View raw message