Index: lams_tool_larsrc/db/sql/table-schema.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_larsrc/db/sql/table-schema.sql,v diff -u -r1.10 -r1.11 --- lams_tool_larsrc/db/sql/table-schema.sql 14 Jun 2006 23:53:38 -0000 1.10 +++ lams_tool_larsrc/db/sql/table-schema.sql 17 Aug 2006 03:37:11 -0000 1.11 @@ -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);