Index: openacs-4/packages/assessment/lib/assessment-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/lib/assessment-oracle.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/assessment/lib/assessment-oracle.xql 12 Jun 2006 03:30:09 -0000 1.1 +++ openacs-4/packages/assessment/lib/assessment-oracle.xql 20 Nov 2017 16:56:36 -0000 1.2 @@ -29,36 +29,5 @@ - - - - update as_sessions - set creation_datetime = sysdate - where session_id = :session_id - and creation_datetime is null - - - - - - - - UPDATE as_sessions - SET last_mod_datetime = sysdate - WHERE session_id = :session_id - - - - - - - - UPDATE as_sessions - SET completed_datetime = sysdate - WHERE session_id = :session_id - - - - Index: openacs-4/packages/assessment/lib/assessment-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/lib/assessment-postgresql.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/assessment/lib/assessment-postgresql.xql 12 Jun 2006 03:30:09 -0000 1.1 +++ openacs-4/packages/assessment/lib/assessment-postgresql.xql 20 Nov 2017 16:56:36 -0000 1.2 @@ -28,37 +28,6 @@ and d.section_id = m.section_id - - - - + - update as_sessions - set creation_datetime = NOW() - where session_id = :session_id - and creation_datetime is null - - - - - - - - UPDATE as_sessions - SET last_mod_datetime = NOW() - WHERE session_id = :session_id - - - - - - - - UPDATE as_sessions - SET completed_datetime = NOW() - WHERE session_id = :session_id - - - - Index: openacs-4/packages/assessment/lib/assessment.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/lib/assessment.xql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/assessment/lib/assessment.xql 13 Nov 2006 18:24:00 -0000 1.2 +++ openacs-4/packages/assessment/lib/assessment.xql 20 Nov 2017 16:56:36 -0000 1.3 @@ -101,4 +101,36 @@ + + + + update as_sessions + set creation_datetime = current_timestamp + where session_id = :session_id + and creation_datetime is null + + + + + + + + UPDATE as_sessions + SET last_mod_datetime = current_timestamp + WHERE session_id = :session_id + + + + + + + + UPDATE as_sessions + SET completed_datetime = current_timestamp + WHERE session_id = :session_id + + + + +