Index: lams_tool_larsrc/db/sql/table-schema.sql
===================================================================
diff -u -r6c82746ec6c1edbc3ef793dcf2e93aff7bf758d9 -r0cd3a215c27e8fd64b488f94fe084b665ab15567
--- lams_tool_larsrc/db/sql/table-schema.sql	(.../table-schema.sql)	(revision 6c82746ec6c1edbc3ef793dcf2e93aff7bf758d9)
+++ lams_tool_larsrc/db/sql/table-schema.sql	(.../table-schema.sql)	(revision 0cd3a215c27e8fd64b488f94fe084b665ab15567)
@@ -4,12 +4,15 @@
 alter table tl_larsrc11_resource_item drop foreign key FKF52D1F93758092FB;
 alter table tl_larsrc11_resource_item drop foreign key FKF52D1F9330E79035;
 alter table tl_larsrc11_resource_item drop foreign key FKF52D1F93EC0D3147;
+alter table tl_larsrc11_resource_item_visit_log drop foreign key FK693580A438BF8DFE;
+alter table tl_larsrc11_resource_item_visit_log drop foreign key FK693580A441F9365D;
 alter table tl_larsrc11_session drop foreign key FK24AA78C530E79035;
 alter table tl_larsrc11_user drop foreign key FK30113BFC506CD584;
 drop table if exists tl_larsrc11_attachment;
 drop table if exists tl_larsrc11_item_instruction;
 drop table if exists tl_larsrc11_resource;
 drop table if exists tl_larsrc11_resource_item;
+drop table if exists tl_larsrc11_resource_item_visit_log;
 drop table if exists tl_larsrc11_session;
 drop table if exists tl_larsrc11_user;
 create table tl_larsrc11_attachment (
@@ -70,6 +73,14 @@
    session_uid bigint,
    primary key (uid)
 );
+create table tl_larsrc11_resource_item_visit_log (
+   uid bigint not null auto_increment,
+   access_date datetime,
+   resource_item_uid bigint,
+   user_uid bigint,
+   complete bit,
+   primary key (uid)
+);
 create table tl_larsrc11_session (
    uid bigint not null auto_increment,
    session_end_date datetime,
@@ -95,5 +106,7 @@
 alter table tl_larsrc11_resource_item add index FKF52D1F93758092FB (create_by), add constraint FKF52D1F93758092FB foreign key (create_by) references tl_larsrc11_user (uid);
 alter table tl_larsrc11_resource_item add index FKF52D1F9330E79035 (resource_uid), add constraint FKF52D1F9330E79035 foreign key (resource_uid) references tl_larsrc11_resource (uid);
 alter table tl_larsrc11_resource_item add index FKF52D1F93EC0D3147 (session_uid), add constraint FKF52D1F93EC0D3147 foreign key (session_uid) references tl_larsrc11_session (uid);
+alter table tl_larsrc11_resource_item_visit_log add index FK693580A438BF8DFE (resource_item_uid), add constraint FK693580A438BF8DFE foreign key (resource_item_uid) references tl_larsrc11_resource_item (uid);
+alter table tl_larsrc11_resource_item_visit_log add index FK693580A441F9365D (user_uid), add constraint FK693580A441F9365D foreign key (user_uid) references tl_larsrc11_user (uid);
 alter table tl_larsrc11_session add index FK24AA78C530E79035 (resource_uid), add constraint FK24AA78C530E79035 foreign key (resource_uid) references tl_larsrc11_resource (uid);
 alter table tl_larsrc11_user add index FK30113BFC506CD584 (session_id), add constraint FK30113BFC506CD584 foreign key (session_id) references tl_larsrc11_session (uid);
