Index: lams_tool_chat/db/sql/table-schema.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_chat/db/sql/table-schema.sql,v
diff -u -r1.5 -r1.6
--- lams_tool_chat/db/sql/table-schema.sql	9 Jun 2006 09:54:42 -0000	1.5
+++ lams_tool_chat/db/sql/table-schema.sql	14 Jun 2006 23:47:05 -0000	1.6
@@ -1,6 +1,6 @@
 alter table tl_lachat11_attachment drop foreign key FK9ED6CB2E1A3926E3;
-alter table tl_lachat11_message drop foreign key FKCC08C1DCC15A415F;
-alter table tl_lachat11_message drop foreign key FKCC08C1DC50B2D730;
+alter table tl_lachat11_message drop foreign key FKCC08C1DCCF3BF9B6;
+alter table tl_lachat11_message drop foreign key FKCC08C1DC2AF61E05;
 alter table tl_lachat11_message drop foreign key FKCC08C1DC9C8469FC;
 alter table tl_lachat11_session drop foreign key FK96E446B1A3926E3;
 alter table tl_lachat11_user drop foreign key FK4EB82169C8469FC;
@@ -40,8 +40,8 @@
 create table tl_lachat11_message (
    uid bigint not null auto_increment,
    chat_session_uid bigint not null,
-   from_user_id bigint,
-   to_user_id bigint,
+   from_user_uid bigint,
+   to_user_uid bigint,
    type varchar(255),
    body varchar(255),
    send_date datetime,
@@ -72,8 +72,8 @@
    primary key (uid)
 );
 alter table tl_lachat11_attachment add index FK9ED6CB2E1A3926E3 (chat_uid), add constraint FK9ED6CB2E1A3926E3 foreign key (chat_uid) references tl_lachat11_chat (uid);
-alter table tl_lachat11_message add index FKCC08C1DCC15A415F (from_user_id), add constraint FKCC08C1DCC15A415F foreign key (from_user_id) references tl_lachat11_user (uid);
-alter table tl_lachat11_message add index FKCC08C1DC50B2D730 (to_user_id), add constraint FKCC08C1DC50B2D730 foreign key (to_user_id) references tl_lachat11_user (uid);
+alter table tl_lachat11_message add index FKCC08C1DCCF3BF9B6 (from_user_uid), add constraint FKCC08C1DCCF3BF9B6 foreign key (from_user_uid) references tl_lachat11_user (uid);
+alter table tl_lachat11_message add index FKCC08C1DC2AF61E05 (to_user_uid), add constraint FKCC08C1DC2AF61E05 foreign key (to_user_uid) references tl_lachat11_user (uid);
 alter table tl_lachat11_message add index FKCC08C1DC9C8469FC (chat_session_uid), add constraint FKCC08C1DC9C8469FC foreign key (chat_session_uid) references tl_lachat11_session (uid);
 alter table tl_lachat11_session add index FK96E446B1A3926E3 (chat_uid), add constraint FK96E446B1A3926E3 foreign key (chat_uid) references tl_lachat11_chat (uid);
 alter table tl_lachat11_user add index FK4EB82169C8469FC (chat_session_uid), add constraint FK4EB82169C8469FC foreign key (chat_session_uid) references tl_lachat11_session (uid);