Index: openacs-4/packages/scorm-core/sql/postgresql/scorm-datamodel-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/scorm-core/sql/postgresql/scorm-datamodel-create.sql,v diff -u -r1.5 -r1.6 --- openacs-4/packages/scorm-core/sql/postgresql/scorm-datamodel-create.sql 23 May 2010 20:27:51 -0000 1.5 +++ openacs-4/packages/scorm-core/sql/postgresql/scorm-datamodel-create.sql 8 Jul 2010 01:14:22 -0000 1.6 @@ -361,10 +361,10 @@ c_raw real, scaled real, scaled_passing_score real, - session_time text, + session_time interval, success_status text, suspend_data text, - total_time text, + total_time interval, user_id integer constraint cp_node_user_id_fk references users @@ -450,6 +450,7 @@ scope_id integer, status text, objective_id text, + c_timestamp timestamptz, constraint cmi_gobjective_pk primary key (user_id, objective_id, scope_id) );