Index: lams_tool_larsrc/db/sql/create_lams_tool_rsrc.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_larsrc/db/sql/create_lams_tool_rsrc.sql,v
diff -u -r1.17 -r1.18
--- lams_tool_larsrc/db/sql/create_lams_tool_rsrc.sql	10 Oct 2006 04:19:40 -0000	1.17
+++ lams_tool_larsrc/db/sql/create_lams_tool_rsrc.sql	2 Nov 2006 02:32:48 -0000	1.18
@@ -114,11 +114,11 @@
 INSERT INTO `tl_larsrc11_resource` (`uid`, `create_date`, `update_date`, `create_by`, `title`, `run_offline`, `lock_on_finished`,
  `instructions`, `online_instructions`, `offline_instructions`, `content_in_use`, `define_later`, `content_id`, `allow_add_files`, 
  `allow_add_urls`, `mini_view_resource_number`, `allow_auto_run`,`reflect_on_activity`) VALUES
-  (1,NULL,NULL,NULL,'Shared Resources','0','0','Instruction','Online instruction','Offline instruction',0,0,${default_content_id},0,0,0,0,0);
+  (1,NULL,NULL,NULL,'Resources','0','0','Instructions ',null,null,0,0,${default_content_id},0,0,0,0,0);
   
 INSERT INTO `tl_larsrc11_resource_item` (`uid`, `file_uuid`, `file_version_id`, `description`, `ims_schema`, `init_item`, `organization_xml`, `title`, `url`, `create_by`, `create_date`, `create_by_author`, `is_hide`, `item_type`, `file_type`, `file_name`, `open_url_new_window`, `resource_uid`, `session_uid`) VALUES 
   (1,NULL,NULL,NULL,NULL,NULL,NULL,'Web Search','http://www.google.com ',null,NOW(),1,0,1,NULL,NULL,0,1,NULL);
 INSERT INTO `tl_larsrc11_item_instruction` (`uid`, `description`, `sequence_id`, `item_uid`) VALUES 
-  (1,'Use Google to search on the web ',0,1);
+  (1,'Use Google to search the web',0,1);
     
 SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Index: lams_tool_sbmt/db/sql/create_lams_tool_sbmt.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_sbmt/db/sql/create_lams_tool_sbmt.sql,v
diff -u -r1.24 -r1.25
--- lams_tool_sbmt/db/sql/create_lams_tool_sbmt.sql	5 Sep 2006 04:04:59 -0000	1.24
+++ lams_tool_sbmt/db/sql/create_lams_tool_sbmt.sql	2 Nov 2006 02:32:17 -0000	1.25
@@ -80,5 +80,6 @@
 alter table tl_lasbmt11_submission_details add index FK1411A53C93C861A (session_id), add constraint FK1411A53C93C861A foreign key (session_id) references tl_lasbmt11_session (session_id);
 
 
-INSERT INTO `tl_lasbmt11_content` (content_id,title,instruction,define_later,run_offline,content_in_use,lock_on_finished,reflect_on_activity,limit_upload,limit_upload_number) values(${default_content_id},"Submit files","Upload your files below...",0,0,0,0,0,0,1);
+INSERT INTO `tl_lasbmt11_content` (content_id,title,instruction,define_later,run_offline,content_in_use,lock_on_finished,reflect_on_activity,limit_upload,limit_upload_number) 
+values(${default_content_id},"Submit Files","Instructions",0,0,0,0,0,0,1);
 SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Index: lams_tool_survey/db/sql/create_lams_tool_survey.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_survey/db/sql/create_lams_tool_survey.sql,v
diff -u -r1.7 -r1.8
--- lams_tool_survey/db/sql/create_lams_tool_survey.sql	10 Oct 2006 04:19:51 -0000	1.7
+++ lams_tool_survey/db/sql/create_lams_tool_survey.sql	2 Nov 2006 02:31:48 -0000	1.8
@@ -110,7 +110,7 @@
 INSERT INTO `tl_lasurv11_survey` (`uid`, `create_date`, `update_date`, `create_by`, `title`, 
   `run_offline`, `lock_on_finished`, `instructions`, `online_instructions`, `offline_instructions`,
  `content_in_use`, `define_later`, `content_id`,`show_questions_on_one_page`,`reflect_on_activity`) VALUES
-  (1,NULL,NULL,NULL,'Survey','0','0','Instruction','Online instruction','Offline instruction',0,0,${default_content_id},1,0);
+  (1,NULL,NULL,NULL,'Survey','0','1','Instructions',null,null,0,0,${default_content_id},1,0);
   
 INSERT INTO `tl_lasurv11_question` (`uid`, `sequence_id`, `description`, `create_by`, `create_date`, `question_type`, `append_text`, `optional`, `allow_multiple_answer`, `survey_uid`) VALUES 
   (1,1,'Sample Multiple choice - only one response allowed?',null,NOW(),1,0,0,0,1);
Index: lams_tool_survey/db/sql/table-schema.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_survey/db/sql/table-schema.sql,v
diff -u -r1.4 -r1.5
--- lams_tool_survey/db/sql/table-schema.sql	21 Sep 2006 07:46:41 -0000	1.4
+++ lams_tool_survey/db/sql/table-schema.sql	2 Nov 2006 02:31:48 -0000	1.5
@@ -1,7 +1,7 @@
 alter table tl_lasurv11_answer drop foreign key FK6DAAFE3BB1423DC1;
 alter table tl_lasurv11_answer drop foreign key FK6DAAFE3B25F3BB77;
 alter table tl_lasurv11_attachment drop foreign key FKD92A9120D14146E5;
-alter table tl_lasurv11_option drop foreign key FK85AB46F26966134F;
+alter table tl_lasurv11_option drop foreign key FK85AB46F225F3BB77;
 alter table tl_lasurv11_question drop foreign key FK872D4F23D14146E5;
 alter table tl_lasurv11_question drop foreign key FK872D4F23E4C99A5F;
 alter table tl_lasurv11_session drop foreign key FKF08793B9D14146E5;
@@ -17,15 +17,15 @@
 drop table if exists tl_lasurv11_user;
 create table tl_lasurv11_answer (uid bigint not null auto_increment, question_uid bigint, user_uid bigint, answer_choices varchar(255), udpate_date datetime, answer_text varchar(255), primary key (uid));
 create table tl_lasurv11_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, survey_uid bigint, primary key (uid));
-create table tl_lasurv11_option (uid bigint not null auto_increment, description text, sequence_id integer, answer_uid bigint, primary key (uid));
+create table tl_lasurv11_option (uid bigint not null auto_increment, description text, sequence_id integer, question_uid bigint, primary key (uid));
 create table tl_lasurv11_question (uid bigint not null auto_increment, description text, create_by bigint, create_date datetime, question_type smallint, append_text bit, optional bit, allow_multiple_answer bit, sequence_id integer, survey_uid bigint, primary key (uid));
 create table tl_lasurv11_session (uid bigint not null auto_increment, session_end_date datetime, session_start_date datetime, survey_uid bigint, session_id bigint, session_name varchar(250), primary key (uid));
 create table tl_lasurv11_survey (uid bigint not null auto_increment, create_date datetime, update_date datetime, create_by bigint, title varchar(255), run_offline bit, lock_on_finished bit, instructions text, online_instructions text, offline_instructions text, content_in_use bit, define_later bit, content_id bigint unique, reflect_instructions varchar(255), reflect_on_activity bit, show_questions_on_one_page bit, primary key (uid));
 create table tl_lasurv11_user (uid bigint not null auto_increment, user_id bigint, last_name varchar(255), first_name varchar(255), login_name varchar(255), session_uid bigint, survey_uid bigint, session_finished bit, primary key (uid));
 alter table tl_lasurv11_answer add index FK6DAAFE3BB1423DC1 (user_uid), add constraint FK6DAAFE3BB1423DC1 foreign key (user_uid) references tl_lasurv11_user (uid);
 alter table tl_lasurv11_answer add index FK6DAAFE3B25F3BB77 (question_uid), add constraint FK6DAAFE3B25F3BB77 foreign key (question_uid) references tl_lasurv11_question (uid);
 alter table tl_lasurv11_attachment add index FKD92A9120D14146E5 (survey_uid), add constraint FKD92A9120D14146E5 foreign key (survey_uid) references tl_lasurv11_survey (uid);
-alter table tl_lasurv11_option add index FK85AB46F26966134F (answer_uid), add constraint FK85AB46F26966134F foreign key (answer_uid) references tl_lasurv11_question (uid);
+alter table tl_lasurv11_option add index FK85AB46F225F3BB77 (question_uid), add constraint FK85AB46F225F3BB77 foreign key (question_uid) references tl_lasurv11_question (uid);
 alter table tl_lasurv11_question add index FK872D4F23D14146E5 (survey_uid), add constraint FK872D4F23D14146E5 foreign key (survey_uid) references tl_lasurv11_survey (uid);
 alter table tl_lasurv11_question add index FK872D4F23E4C99A5F (create_by), add constraint FK872D4F23E4C99A5F foreign key (create_by) references tl_lasurv11_user (uid);
 alter table tl_lasurv11_session add index FKF08793B9D14146E5 (survey_uid), add constraint FKF08793B9D14146E5 foreign key (survey_uid) references tl_lasurv11_survey (uid);