Index: tool_adapters/moodle/lams_tool_mdlchat/db/sql/create_lams_tool_mdlChat.sql
===================================================================
RCS file: /usr/local/cvsroot/tool_adapters/moodle/lams_tool_mdlchat/db/sql/create_lams_tool_mdlChat.sql,v
diff -u -r1.3 -r1.4
--- tool_adapters/moodle/lams_tool_mdlchat/db/sql/create_lams_tool_mdlChat.sql	10 Mar 2009 15:33:47 -0000	1.3
+++ tool_adapters/moodle/lams_tool_mdlchat/db/sql/create_lams_tool_mdlChat.sql	10 Mar 2009 23:13:12 -0000	1.4
@@ -1,48 +1,48 @@
--- CVS ID: $Id$
- 
-SET FOREIGN_KEY_CHECKS=0;
-drop table if exists tl_mdchat10_configuration;
-drop table if exists tl_mdchat10_mdlchat;
-drop table if exists tl_mdchat10_session;
-drop table if exists tl_mdchat10_user;
-create table tl_mdchat10_configuration (uid bigint not null auto_increment, config_key varchar(30) unique, config_value varchar(255), primary key (uid))TYPE=InnoDB;
-create table tl_mdchat10_mdlchat (uid bigint not null auto_increment, create_date datetime, update_date datetime, define_later bit, content_in_use bit, run_offline bit, tool_content_id bigint, ext_tool_content_id bigint, ext_user_name varchar(255), ext_course_id varchar(255), ext_section varchar(255), primary key (uid))TYPE=InnoDB;
-create table tl_mdchat10_session (uid bigint not null auto_increment, session_end_date datetime, session_start_date datetime, status integer, session_id bigint, ext_session_id bigint, session_name varchar(250), mdlchat_uid bigint, primary key (uid))TYPE=InnoDB;
-create table tl_mdchat10_user (uid bigint not null auto_increment, user_id bigint, last_name varchar(255), login_name varchar(255), first_name varchar(255), finishedActivity bit, mdlchat_session_uid bigint, entry_uid bigint, primary key (uid))TYPE=InnoDB;
-alter table tl_mdchat10_session add index FKmdchat10_session (mdlchat_uid), add constraint FKmdchat10_session foreign key (mdlchat_uid) references tl_mdchat10_mdlchat (uid);
-alter table tl_mdchat10_user add index FKmdchat10_user (mdlchat_session_uid), add constraint FKmdchat10_user foreign key (mdlchat_session_uid) references tl_mdchat10_session (uid);
-
-INSERT INTO tl_mdchat10_configuration (
-	config_key, 
-	config_value
-)
-VALUES(
-	"toolAdapterServlet",
-	"http://localhost:8000/lams2conf/tooladapter_mdchat10"
-);
-
-INSERT INTO tl_mdchat10_configuration (
-	config_key, 
-	config_value
-)
-VALUES(
-	"extServerUrl",
-	"http://localhost/moodle19/"
-);
-
-INSERT INTO tl_mdchat10_mdlchat (
-	tool_content_id,
-	ext_tool_content_id,
-	run_offline,
-	content_in_use,
-	define_later
-) 
-VALUES(
-	0,
-	null,
-	0,
-	0,
-	0
-);
-
-SET FOREIGN_KEY_CHECKS=1;
+-- CVS ID: $Id$
+ 
+SET FOREIGN_KEY_CHECKS=0;
+drop table if exists tl_mdchat10_configuration;
+drop table if exists tl_mdchat10_mdlchat;
+drop table if exists tl_mdchat10_session;
+drop table if exists tl_mdchat10_user;
+create table tl_mdchat10_configuration (uid bigint not null auto_increment, config_key varchar(30) unique, config_value varchar(255), primary key (uid))TYPE=InnoDB;
+create table tl_mdchat10_mdlchat (uid bigint not null auto_increment, create_date datetime, update_date datetime, define_later bit, content_in_use bit, run_offline bit, tool_content_id bigint, ext_tool_content_id bigint, ext_user_name varchar(255), ext_course_id varchar(255), ext_section varchar(255), primary key (uid))TYPE=InnoDB;
+create table tl_mdchat10_session (uid bigint not null auto_increment, session_end_date datetime, session_start_date datetime, status integer, session_id bigint, ext_session_id bigint, session_name varchar(250), mdlchat_uid bigint, primary key (uid))TYPE=InnoDB;
+create table tl_mdchat10_user (uid bigint not null auto_increment, user_id bigint, last_name varchar(255), login_name varchar(255), first_name varchar(255), finishedActivity bit, mdlchat_session_uid bigint, entry_uid bigint, primary key (uid))TYPE=InnoDB;
+alter table tl_mdchat10_session add index FKmdchat10_session (mdlchat_uid), add constraint FKmdchat10_session foreign key (mdlchat_uid) references tl_mdchat10_mdlchat (uid);
+alter table tl_mdchat10_user add index FKmdchat10_user (mdlchat_session_uid), add constraint FKmdchat10_user foreign key (mdlchat_session_uid) references tl_mdchat10_session (uid);
+
+INSERT INTO tl_mdchat10_configuration (
+	config_key, 
+	config_value
+)
+VALUES(
+	"toolAdapterServlet",
+	"http://localhost:8000/lams2conf/tooladapter_mdchat10"
+);
+
+INSERT INTO tl_mdchat10_configuration (
+	config_key, 
+	config_value
+)
+VALUES(
+	"extServerUrl",
+	"http://localhost/moodle19/"
+);
+
+INSERT INTO tl_mdchat10_mdlchat (
+	tool_content_id,
+	ext_tool_content_id,
+	run_offline,
+	content_in_use,
+	define_later
+) 
+VALUES(
+	0,
+	null,
+	0,
+	0,
+	0
+);
+
+SET FOREIGN_KEY_CHECKS=1;