Index: openacs-4/packages/assessment/www/assessment-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/Attic/assessment-oracle.xql,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/assessment/www/assessment-oracle.xql	24 Jan 2005 14:54:30 -0000	1.7
+++ openacs-4/packages/assessment/www/assessment-oracle.xql	22 Nov 2017 10:56:39 -0000	1.8
@@ -29,36 +29,5 @@
 
 	</querytext>
 </fullquery>
-	
-<fullquery name="session_start">
-	<querytext>
 
-	update as_sessions
-	set creation_datetime = sysdate
-	where session_id = :session_id
-	and creation_datetime is null
-
-	</querytext>
-</fullquery>
-
-<fullquery name="session_updated">
-	<querytext>
-
-	UPDATE as_sessions
-	SET last_mod_datetime = sysdate
-	WHERE session_id = :session_id
-
-	</querytext>
-</fullquery>
-
-<fullquery name="session_finished">
-	<querytext>
-
-	UPDATE as_sessions
-	SET completed_datetime = sysdate
-	WHERE session_id = :session_id
-
-	</querytext>
-</fullquery>
-
 </queryset>
Index: openacs-4/packages/assessment/www/assessment-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/Attic/assessment-postgresql.xql,v
diff -u -r1.12 -r1.13
--- openacs-4/packages/assessment/www/assessment-postgresql.xql	4 Feb 2005 18:08:05 -0000	1.12
+++ openacs-4/packages/assessment/www/assessment-postgresql.xql	22 Nov 2017 10:56:39 -0000	1.13
@@ -29,36 +29,5 @@
 
 	</querytext>
 </fullquery>
-	
-<fullquery name="session_start">
-	<querytext>
 
-	update as_sessions
-	set creation_datetime = NOW()
-	where session_id = :session_id
-	and creation_datetime is null
-
-	</querytext>
-</fullquery>
-
-<fullquery name="session_updated">
-	<querytext>
-
-	UPDATE as_sessions
-	SET last_mod_datetime = NOW()
-	WHERE session_id = :session_id
-
-	</querytext>
-</fullquery>
-
-<fullquery name="session_finished">
-	<querytext>
-
-	UPDATE as_sessions
-	SET completed_datetime = NOW()
-	WHERE session_id = :session_id
-
-	</querytext>
-</fullquery>
-
 </queryset>
Index: openacs-4/packages/assessment/www/assessment.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/Attic/assessment.xql,v
diff -u -r1.18 -r1.19
--- openacs-4/packages/assessment/www/assessment.xql	12 Jun 2006 03:02:38 -0000	1.18
+++ openacs-4/packages/assessment/www/assessment.xql	22 Nov 2017 10:56:39 -0000	1.19
@@ -101,4 +101,35 @@
 	</querytext>
 </fullquery>
 
+<fullquery name="session_start">
+	<querytext>
+
+	update as_sessions
+	set creation_datetime = current_timestamp
+	where session_id = :session_id
+	and creation_datetime is null
+
+	</querytext>
+</fullquery>
+
+<fullquery name="session_updated">
+	<querytext>
+
+	UPDATE as_sessions
+	SET last_mod_datetime = current_timestamp
+	WHERE session_id = :session_id
+
+	</querytext>
+</fullquery>
+
+<fullquery name="session_finished">
+	<querytext>
+
+	UPDATE as_sessions
+	SET completed_datetime = current_timestamp
+	WHERE session_id = :session_id
+
+	</querytext>
+</fullquery>
+
 </queryset>
Fisheye: Tag 1.3 refers to a dead (removed) revision in file `openacs-4/packages/assessment/tcl/test/as-assessment-procs-oracle.xql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.3 refers to a dead (removed) revision in file `openacs-4/packages/assessment/tcl/test/as-assessment-procs-postgresql.xql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: openacs-4/packages/assessment/tcl/test/as-assessment-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/tcl/test/as-assessment-procs.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/assessment/tcl/test/as-assessment-procs.xql	22 Nov 2017 11:01:11 -0000	1.1
@@ -0,0 +1,14 @@
+<?xml version="1.0"?>
+<!DOCTYPE queryset PUBLIC "-//OpenACS//DTD XQL 1.0//EN" "http://www.thecodemill.biz/repository/xql.dtd">
+<!-- packages/assessment/tcl/test/as-assessment-procs.xql -->
+<!-- @author Dave Bauer (dave@thedesignexperience.org) -->
+<!-- @creation-date 2007-04-07 -->
+<!-- @cvs-id $Id: as-assessment-procs.xql,v 1.1 2017/11/22 11:01:11 antoniop Exp $ -->
+<queryset>
+  <fullquery name="_assessment__as_instantiate.update_session">
+    <querytext>
+      update as_sessions set last_mod_datetime=current_timestamp
+      where session_id=:session_id
+    </querytext>
+  </fullquery>
+</queryset>