Index: lams_tool_larsrc/db/model/resource.clay =================================================================== diff -u -r0cd3a215c27e8fd64b488f94fe084b665ab15567 -r4812e830a27ccc4127bc6f3043258b16776f314b --- lams_tool_larsrc/db/model/resource.clay (.../resource.clay) (revision 0cd3a215c27e8fd64b488f94fe084b665ab15567) +++ lams_tool_larsrc/db/model/resource.clay (.../resource.clay) (revision 4812e830a27ccc4127bc6f3043258b16776f314b) @@ -19,8 +19,8 @@ - + @@ -32,8 +32,8 @@ - + @@ -59,8 +59,8 @@ - + @@ -78,8 +78,8 @@ - + @@ -121,8 +121,8 @@ - + @@ -141,8 +141,8 @@ - + @@ -154,8 +154,8 @@ - + @@ -197,8 +197,8 @@ - + @@ -222,8 +222,8 @@ - + @@ -284,8 +284,8 @@ - + @@ -309,8 +309,8 @@ - + @@ -362,8 +362,8 @@ - + @@ -375,8 +375,8 @@ - + @@ -388,8 +388,8 @@ - + @@ -441,8 +441,8 @@ - + @@ -472,8 +472,8 @@ - + @@ -499,8 +499,8 @@ - + @@ -512,8 +512,8 @@ - + @@ -570,15 +570,15 @@ - +
- + @@ -596,8 +596,8 @@ - + @@ -609,8 +609,8 @@ - + @@ -669,8 +669,8 @@ - + @@ -694,8 +694,8 @@ - + @@ -707,8 +707,8 @@ - + @@ -720,8 +720,8 @@ - + @@ -770,8 +770,8 @@ - + @@ -783,8 +783,8 @@ - + @@ -817,8 +817,8 @@ - + Index: lams_tool_larsrc/db/sql/create_lams_tool_rsrc.sql =================================================================== diff -u -r357e625187f695331b3ede826f4047a7b6a8355e -r4812e830a27ccc4127bc6f3043258b16776f314b --- lams_tool_larsrc/db/sql/create_lams_tool_rsrc.sql (.../create_lams_tool_rsrc.sql) (revision 357e625187f695331b3ede826f4047a7b6a8355e) +++ lams_tool_larsrc/db/sql/create_lams_tool_rsrc.sql (.../create_lams_tool_rsrc.sql) (revision 4812e830a27ccc4127bc6f3043258b16776f314b) @@ -65,7 +65,7 @@ session_uid bigint, primary key (uid) ); -create table tl_larsrc11_resource_item_visit_log ( +create table tl_larsrc11_item_log ( uid bigint not null auto_increment, access_date datetime, resource_item_uid bigint, @@ -99,8 +99,8 @@ 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_item_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_item_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); Index: lams_tool_larsrc/db/sql/drop_lams_tool_rsrc.sql =================================================================== diff -u -r0cd3a215c27e8fd64b488f94fe084b665ab15567 -r4812e830a27ccc4127bc6f3043258b16776f314b --- lams_tool_larsrc/db/sql/drop_lams_tool_rsrc.sql (.../drop_lams_tool_rsrc.sql) (revision 0cd3a215c27e8fd64b488f94fe084b665ab15567) +++ lams_tool_larsrc/db/sql/drop_lams_tool_rsrc.sql (.../drop_lams_tool_rsrc.sql) (revision 4812e830a27ccc4127bc6f3043258b16776f314b) @@ -3,7 +3,7 @@ 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_item_log; drop table if exists tl_larsrc11_session; drop table if exists tl_larsrc11_user; SET FOREIGN_KEY_CHECKS=1; Index: lams_tool_larsrc/db/sql/table-schema.sql =================================================================== diff -u -rdd8218cfa50710015a253505c93a4070e6b29435 -r4812e830a27ccc4127bc6f3043258b16776f314b --- lams_tool_larsrc/db/sql/table-schema.sql (.../table-schema.sql) (revision dd8218cfa50710015a253505c93a4070e6b29435) +++ lams_tool_larsrc/db/sql/table-schema.sql (.../table-schema.sql) (revision 4812e830a27ccc4127bc6f3043258b16776f314b) @@ -4,15 +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_item_log drop foreign key FK693580A438BF8DFE; +alter table tl_larsrc11_item_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_item_log; drop table if exists tl_larsrc11_session; drop table if exists tl_larsrc11_user; create table tl_larsrc11_attachment ( @@ -74,7 +74,7 @@ session_uid bigint, primary key (uid) ); -create table tl_larsrc11_resource_item_visit_log ( +create table tl_larsrc11_item_log ( uid bigint not null auto_increment, access_date datetime, resource_item_uid bigint, @@ -108,7 +108,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_item_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_item_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);