Scarab commit: svn commit: r10435 - trunk/src/sql

Author: ronvoe122
Date: 2007-03-28 08:55:26-0700
New Revision: 10435

Modified:
   trunk/src/sql/scarab-anonymous.sql
   trunk/src/sql/scarab-sample-data.sql
   trunk/src/sql/scarab-security.sql

Log:
Some Tests failed because of a strange behavior of columns of the datatype timestamp in mySQL.
The test data inserted by the sql scripts contained '0000-00-00 00:00:00' in the timestamp columns.
JDBC does not accept this value.

Modified: trunk/src/sql/scarab-anonymous.sql
Url: http://scarab.tigris.org/source/browse/scarab/trunk/src/sql/scarab-anonymous.sql?view=diff&rev=10435&p1=trunk/src/sql/scarab-anonymous.sql&p2=trunk/src/sql/scarab-anonymous.sql&r1=10434&r2=10435
==============================================================================
--- trunk/src/sql/scarab-anonymous.sql	(original)
+++ trunk/src/sql/scarab-anonymous.sql	2007-03-28 08:55:26-0700
@@ -1,7 +1,7 @@
 -- Create an account for anonymous user
 
-INSERT INTO TURBINE_USER (USER_ID, LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME, EMAIL, CONFIRM_VALUE) 
-    VALUES (9, '@ANONYMOUS_USERNAME@', 'NWoZK3kTsExUV00Ywo1G5jlUKKs=', 'Scarab', 'anonymous', '[email protected]', 'CONFIRMED');
+INSERT INTO TURBINE_USER (USER_ID, LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME, EMAIL, CONFIRM_VALUE, MODIFIED, CREATED, LAST_LOGIN) 
+    VALUES (9, '@ANONYMOUS_USERNAME@', 'NWoZK3kTsExUV00Ywo1G5jlUKKs=', 'Scarab', 'anonymous', '[email protected]', 'CONFIRMED', null, null, null );
 
 
 -- Script to fill the tables with default roles and permissions

Modified: trunk/src/sql/scarab-sample-data.sql
Url: http://scarab.tigris.org/source/browse/scarab/trunk/src/sql/scarab-sample-data.sql?view=diff&rev=10435&p1=trunk/src/sql/scarab-sample-data.sql&p2=trunk/src/sql/scarab-sample-data.sql&r1=10434&r2=10435
==============================================================================
--- trunk/src/sql/scarab-sample-data.sql	(original)
+++ trunk/src/sql/scarab-sample-data.sql	2007-03-28 08:55:26-0700
@@ -4329,20 +4329,20 @@
 
 -- SECURITY - Sample Users
 
-insert into TURBINE_USER (USER_ID, LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME, EMAIL, CONFIRM_VALUE ) 
-    values (2, '[email protected]', 'NWoZK3kTsExUV00Ywo1G5jlUKKs=', 'Jon', 'Stevens', '[email protected]', 'CONFIRMED' );
-insert into TURBINE_USER (USER_ID, LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME, EMAIL, CONFIRM_VALUE ) 
-    values (3, '[email protected]', 'NWoZK3kTsExUV00Ywo1G5jlUKKs=', 'Jon', 'Stevens', '[email protected]', 'abcdef' );
-insert into TURBINE_USER (USER_ID, LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME, EMAIL, CONFIRM_VALUE ) 
-    values (4, '[email protected]', 'NWoZK3kTsExUV00Ywo1G5jlUKKs=', 'John', 'McNally', '[email protected]', 'CONFIRMED' );
-insert into TURBINE_USER (USER_ID, LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME, EMAIL, CONFIRM_VALUE ) 
-    values (5, '[email protected]', 'NWoZK3kTsExUV00Ywo1G5jlUKKs=', 'Elicia', 'David', '[email protected]', 'CONFIRMED' );
-insert into TURBINE_USER (USER_ID, LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME, EMAIL, CONFIRM_VALUE ) 
-    values (6, '[email protected]', 'NWoZK3kTsExUV00Ywo1G5jlUKKs=', 'Observer', 'Test', '[email protected]', 'CONFIRMED' );
-insert into TURBINE_USER (USER_ID, LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME, EMAIL, CONFIRM_VALUE ) 
-    values (7, '[email protected]', 'NWoZK3kTsExUV00Ywo1G5jlUKKs=', 'Neal', 'Reizer', '[email protected]', 'CONFIRMED' );
-insert into TURBINE_USER (USER_ID, LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME, EMAIL, CONFIRM_VALUE ) 
-    values (8, '[email protected]', 'NWoZK3kTsExUV00Ywo1G5jlUKKs=', 'Thena', 'Berry', '[email protected]', 'CONFIRMED' );
+insert into TURBINE_USER (USER_ID, LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME, EMAIL, CONFIRM_VALUE, MODIFIED, CREATED, LAST_LOGIN ) 
+    values (2, '[email protected]', 'NWoZK3kTsExUV00Ywo1G5jlUKKs=', 'Jon', 'Stevens', '[email protected]', 'CONFIRMED', null, null, null );
+insert into TURBINE_USER (USER_ID, LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME, EMAIL, CONFIRM_VALUE, MODIFIED, CREATED, LAST_LOGIN ) 
+    values (3, '[email protected]', 'NWoZK3kTsExUV00Ywo1G5jlUKKs=', 'Jon', 'Stevens', '[email protected]', 'abcdef', null, null, null );
+insert into TURBINE_USER (USER_ID, LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME, EMAIL, CONFIRM_VALUE, MODIFIED, CREATED, LAST_LOGIN ) 
+    values (4, '[email protected]', 'NWoZK3kTsExUV00Ywo1G5jlUKKs=', 'John', 'McNally', '[email protected]', 'CONFIRMED', null, null, null );
+insert into TURBINE_USER (USER_ID, LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME, EMAIL, CONFIRM_VALUE, MODIFIED, CREATED, LAST_LOGIN ) 
+    values (5, '[email protected]', 'NWoZK3kTsExUV00Ywo1G5jlUKKs=', 'Elicia', 'David', '[email protected]', 'CONFIRMED', null, null, null );
+insert into TURBINE_USER (USER_ID, LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME, EMAIL, CONFIRM_VALUE, MODIFIED, CREATED, LAST_LOGIN ) 
+    values (6, '[email protected]', 'NWoZK3kTsExUV00Ywo1G5jlUKKs=', 'Observer', 'Test', '[email protected]', 'CONFIRMED', null, null, null );
+insert into TURBINE_USER (USER_ID, LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME, EMAIL, CONFIRM_VALUE, MODIFIED, CREATED, LAST_LOGIN ) 
+    values (7, '[email protected]', 'NWoZK3kTsExUV00Ywo1G5jlUKKs=', 'Neal', 'Reizer', '[email protected]', 'CONFIRMED', null, null, null );
+insert into TURBINE_USER (USER_ID, LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME, EMAIL, CONFIRM_VALUE, MODIFIED, CREATED, LAST_LOGIN ) 
+    values (8, '[email protected]', 'NWoZK3kTsExUV00Ywo1G5jlUKKs=', 'Thena', 'Berry', '[email protected]', 'CONFIRMED', null, null, null );
 
 -- Sample Issues
 

Modified: trunk/src/sql/scarab-security.sql
Url: http://scarab.tigris.org/source/browse/scarab/trunk/src/sql/scarab-security.sql?view=diff&rev=10435&p1=trunk/src/sql/scarab-security.sql&p2=trunk/src/sql/scarab-security.sql&r1=10434&r2=10435
==============================================================================
--- trunk/src/sql/scarab-security.sql	(original)
+++ trunk/src/sql/scarab-security.sql	2007-03-28 08:55:26-0700
@@ -3,8 +3,8 @@
 -- data population, etc.).
 -- Remember to set a good password for this user in a production system!
 
-INSERT INTO TURBINE_USER (USER_ID, LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME, EMAIL, CONFIRM_VALUE) 
-    VALUES (1, '@ADMIN_USERNAME@', 'NWoZK3kTsExUV00Ywo1G5jlUKKs=', 'Scarab', 'Administrator', '[email protected]', 'CONFIRMED');
+INSERT INTO TURBINE_USER (USER_ID, LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME, EMAIL, CONFIRM_VALUE, MODIFIED, CREATED, LAST_LOGIN) 
+    VALUES (1, '@ADMIN_USERNAME@', 'NWoZK3kTsExUV00Ywo1G5jlUKKs=', 'Scarab', 'Administrator', '[email protected]', 'CONFIRMED', null, null, null);
 
 -- root module
 INSERT INTO SCARAB_MODULE(MODULE_ID, MODULE_NAME, MODULE_CODE, MODULE_DESCRIPTION, MODULE_URL, PARENT_ID, CLASS_KEY)