Index: lams_tool_forum/db/sql/table-schema.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_forum/db/sql/table-schema.sql,v
diff -u -r1.8 -r1.9
--- lams_tool_forum/db/sql/table-schema.sql	8 Nov 2005 06:15:01 -0000	1.8
+++ lams_tool_forum/db/sql/table-schema.sql	9 Nov 2005 06:23:05 -0000	1.9
@@ -3,9 +3,8 @@
 alter table tl_lafrum11_message drop foreign key FK4A6067E8E42F4351;
 alter table tl_lafrum11_message drop foreign key FK4A6067E8131CE31E;
 alter table tl_lafrum11_message drop foreign key FK4A6067E824089E4D;
-alter table tl_lafrum11_message drop foreign key FK4A6067E8C6FF3C72;
+alter table tl_lafrum11_message drop foreign key FK4A6067E89357B45B;
 alter table tl_lafrum11_message drop foreign key FK4A6067E8647A7264;
-alter table tl_lafrum11_message drop foreign key FK4A6067E8B0A7E6B3;
 alter table tl_lafrum11_message_seq drop foreign key FKD2C71F88FE939F2A;
 alter table tl_lafrum11_message_seq drop foreign key FKD2C71F8845213B4D;
 alter table tl_lafrum11_tool_session drop foreign key FK5A04D7AE131CE31E;
@@ -55,6 +54,7 @@
 create table tl_lafrum11_message (
    uid bigint not null auto_increment,
    create_date datetime,
+   last_reply_date datetime,
    update_date datetime,
    create_by bigint,
    modified_by bigint,
@@ -63,9 +63,8 @@
    is_authored bit,
    is_anonymous bit,
    forum_session_uid bigint,
-   user_uid bigint,
-   forum_uid bigint,
    parent_uid bigint,
+   forum_uid bigint,
    primary key (uid)
 );
 create table tl_lafrum11_message_seq (
@@ -89,9 +88,8 @@
 alter table tl_lafrum11_message add index FK4A6067E8E42F4351 (create_by), add constraint FK4A6067E8E42F4351 foreign key (create_by) references tl_lafrum11_forum_user (uid);
 alter table tl_lafrum11_message add index FK4A6067E8131CE31E (forum_uid), add constraint FK4A6067E8131CE31E foreign key (forum_uid) references tl_lafrum11_forum (uid);
 alter table tl_lafrum11_message add index FK4A6067E824089E4D (parent_uid), add constraint FK4A6067E824089E4D foreign key (parent_uid) references tl_lafrum11_message (uid);
-alter table tl_lafrum11_message add index FK4A6067E8C6FF3C72 (forum_session_uid), add constraint FK4A6067E8C6FF3C72 foreign key (forum_session_uid) references tl_lafrum11_tool_session (uid);
+alter table tl_lafrum11_message add index FK4A6067E89357B45B (forum_session_uid), add constraint FK4A6067E89357B45B foreign key (forum_session_uid) references tl_lafrum11_tool_session (uid);
 alter table tl_lafrum11_message add index FK4A6067E8647A7264 (modified_by), add constraint FK4A6067E8647A7264 foreign key (modified_by) references tl_lafrum11_forum_user (uid);
-alter table tl_lafrum11_message add index FK4A6067E8B0A7E6B3 (user_uid), add constraint FK4A6067E8B0A7E6B3 foreign key (user_uid) references tl_lafrum11_forum_user (uid);
 alter table tl_lafrum11_message_seq add index FKD2C71F88FE939F2A (message_uid), add constraint FKD2C71F88FE939F2A foreign key (message_uid) references tl_lafrum11_message (uid);
 alter table tl_lafrum11_message_seq add index FKD2C71F8845213B4D (root_message_uid), add constraint FKD2C71F8845213B4D foreign key (root_message_uid) references tl_lafrum11_message (uid);
 alter table tl_lafrum11_tool_session add index FK5A04D7AE131CE31E (forum_uid), add constraint FK5A04D7AE131CE31E foreign key (forum_uid) references tl_lafrum11_forum (uid);