taylor 01/08/24 00:36:16
Modified: src/sql/external turbine-db2.sql turbine-hypersonic.sql
turbine-mysql.sql turbine-oracle.sql
turbine-postgres.sql turbine-sybase.sql
Log:
- update SQL scripts, column LAST_LOGIN was incorrect
Revision Changes Path
1.2 +1 -1 jakarta-jetspeed/src/sql/external/turbine-db2.sql
Index: turbine-db2.sql
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/turbine-db2.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- turbine-db2.sql 2000/12/05 13:26:14 1.1
+++ turbine-db2.sql 2001/08/24 07:36:16 1.2
@@ -116,7 +116,7 @@
CONFIRM_VALUE VARCHAR (99),
MODIFIED DATE,
CREATED DATE,
- LASTLOGIN DATE,
+ LAST_LOGIN DATE,
OBJECTDATA BLOB (16777215),
UNIQUE (LOGIN_NAME)
);
1.2 +1 -1 jakarta-jetspeed/src/sql/external/turbine-hypersonic.sql
Index: turbine-hypersonic.sql
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/turbine-hypersonic.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- turbine-hypersonic.sql 2000/12/05 13:26:14 1.1
+++ turbine-hypersonic.sql 2001/08/24 07:36:16 1.2
@@ -67,7 +67,7 @@
CONFIRM_VALUE VARCHAR (99),
MODIFIED timestamp,
CREATED timestamp,
- LASTLOGIN timestamp,
+ LAST_LOGIN timestamp,
OBJECTDATA BINARY,
PRIMARY KEY(USER_ID),
UNIQUE (LOGIN_NAME)
1.4 +1 -1 jakarta-jetspeed/src/sql/external/turbine-mysql.sql
Index: turbine-mysql.sql
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/turbine-mysql.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- turbine-mysql.sql 2001/06/28 08:42:16 1.3
+++ turbine-mysql.sql 2001/08/24 07:36:16 1.4
@@ -75,7 +75,7 @@
CONFIRM_VALUE VARCHAR (99),
MODIFIED TIMESTAMP,
CREATED TIMESTAMP,
- LASTLOGIN TIMESTAMP,
+ LAST_LOGIN TIMESTAMP,
OBJECTDATA MEDIUMBLOB,
PRIMARY KEY(USER_ID),
UNIQUE (LOGIN_NAME)
1.5 +1 -1 jakarta-jetspeed/src/sql/external/turbine-oracle.sql
Index: turbine-oracle.sql
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/turbine-oracle.sql,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -r1.4 -r1.5
--- turbine-oracle.sql 2001/06/28 08:42:18 1.4
+++ turbine-oracle.sql 2001/08/24 07:36:16 1.5
@@ -115,7 +115,7 @@
CONFIRM_VALUE VARCHAR2 (99),
MODIFIED DATE,
CREATED DATE,
- LASTLOGIN DATE,
+ LAST_LOGIN DATE,
OBJECTDATA LONG RAW,
UNIQUE (LOGIN_NAME)
);
1.3 +1 -1 jakarta-jetspeed/src/sql/external/turbine-postgres.sql
Index: turbine-postgres.sql
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/turbine-postgres.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- turbine-postgres.sql 2001/08/02 01:09:23 1.2
+++ turbine-postgres.sql 2001/08/24 07:36:16 1.3
@@ -79,7 +79,7 @@
CONFIRM_VALUE varchar (99),
MODIFIED timestamp,
CREATED timestamp,
- LASTLOGIN timestamp,
+ LAST_LOGIN timestamp,
OBJECTDATA oid,
PRIMARY KEY(USER_ID),
UNIQUE (LOGIN_NAME)
1.2 +1 -1 jakarta-jetspeed/src/sql/external/turbine-sybase.sql
Index: turbine-sybase.sql
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/turbine-sybase.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- turbine-sybase.sql 2000/12/05 13:26:16 1.1
+++ turbine-sybase.sql 2001/08/24 07:36:16 1.2
@@ -123,7 +123,7 @@
CONFIRM_VALUE VARCHAR (99),
MODIFIED TIMESTAMP,
CREATED TIMESTAMP,
- LASTLOGIN TIMESTAMP,
+ LAST_LOGIN TIMESTAMP,
OBJECTDATA CHAR(10),
CONSTRAINT TURBINE_USER_PK PRIMARY KEY(USER_ID),
UNIQUE (LOGIN_NAME)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
