Index: lams_tool_chat/db/sql/table-schema.sql
===================================================================
diff -u
--- lams_tool_chat/db/sql/table-schema.sql	(revision 0)
+++ lams_tool_chat/db/sql/table-schema.sql	(revision f6896d81b085f15a8903660c926abf0ad7b2d4bf)
@@ -0,0 +1,57 @@
+alter table tl_lachat11_attachment drop foreign key FK9ED6CB2E1A3926E3;
+alter table tl_lachat11_session drop foreign key FK96E446B1A3926E3;
+alter table tl_lachat11_user drop foreign key FK4EB8216C10360A0;
+drop table if exists tl_lachat11_attachment;
+drop table if exists tl_lachat11_chat;
+drop table if exists tl_lachat11_session;
+drop table if exists tl_lachat11_user;
+create table tl_lachat11_attachment (
+   uid bigint not null auto_increment,
+   file_version_id bigint,
+   file_type varchar(255),
+   file_name varchar(255),
+   file_uuid bigint,
+   create_date datetime,
+   chat_uid bigint,
+   primary key (uid)
+);
+create table tl_lachat11_chat (
+   uid bigint not null auto_increment,
+   create_date datetime,
+   update_date datetime,
+   create_by bigint,
+   title varchar(255),
+   instructions text,
+   run_offline bit,
+   lock_on_finished bit,
+   online_instructions text,
+   offline_instructions text,
+   content_in_use bit,
+   define_later bit,
+   tool_content_id bigint,
+   primary key (uid)
+);
+create table tl_lachat11_session (
+   uid bigint not null auto_increment,
+   session_end_date datetime,
+   session_start_date datetime,
+   status integer,
+   session_id bigint,
+   session_name varchar(250),
+   chat_uid bigint,
+   jabber_room varchar(250),
+   primary key (uid)
+);
+create table tl_lachat11_user (
+   uid bigint not null auto_increment,
+   user_id bigint,
+   last_name varchar(255),
+   login_name varchar(255),
+   first_name varchar(255),
+   jabber_id varchar(255),
+   session_id bigint,
+   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_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 FK4EB8216C10360A0 (session_id), add constraint FK4EB8216C10360A0 foreign key (session_id) references tl_lachat11_session (uid);