Index: tool_adapters/moodle/lams_tool_mdlassignment/db/sql/activity_insert.sql =================================================================== diff -u -r03cfe4c9ea322f2291e0e45c9e4879f67f4c5e85 -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdlassignment/db/sql/activity_insert.sql (.../activity_insert.sql) (revision 03cfe4c9ea322f2291e0e45c9e4879f67f4c5e85) +++ tool_adapters/moodle/lams_tool_mdlassignment/db/sql/activity_insert.sql (.../activity_insert.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,80 +1,80 @@ --- CVS ID: $Id$ - -INSERT INTO lams_learning_activity -( -activity_ui_id -, description -, title -, help_text -, xcoord -, ycoord -, parent_activity_id -, parent_ui_id -, learning_activity_type_id -, grouping_support_type_id -, apply_grouping_flag -, grouping_id -, grouping_ui_id -, order_id -, define_later_flag -, learning_design_id -, learning_library_id -, create_date_time -, run_offline_flag -, max_number_of_options -, min_number_of_options -, options_instructions -, tool_id -, tool_content_id -, activity_category_id -, gate_activity_level_id -, gate_open_flag -, gate_start_time_offset -, gate_end_time_offset -, gate_start_date_time -, gate_end_date_time -, library_activity_ui_image -, create_grouping_id -, create_grouping_ui_id -, library_activity_id -, language_file -) -VALUES -( -NULL -, 'Moodle Assignment Tool' -, 'Moodle Assignment Tool' -, 'Moodle Assignment Tool.' -, NULL -, NULL -, NULL -, NULL -, 1 -, 2 -, 0 -, NULL -, NULL -, NULL -, 0 -, NULL -, ${learning_library_id} -, NOW() -, 0 -, NULL -, NULL -, NULL -, ${tool_id} -, NULL -, 6 -, NULL -, NULL -, NULL -, NULL -, NULL -, NULL -, 'tool/mdasgm10/images/icon_mdlAssignment.swf' -, NULL -, NULL -, NULL -, 'org.lamsfoundation.lams.tool.mdasgm.ApplicationResources' -) +-- CVS ID: $Id$ + +INSERT INTO lams_learning_activity +( +activity_ui_id +, description +, title +, help_text +, xcoord +, ycoord +, parent_activity_id +, parent_ui_id +, learning_activity_type_id +, grouping_support_type_id +, apply_grouping_flag +, grouping_id +, grouping_ui_id +, order_id +, define_later_flag +, learning_design_id +, learning_library_id +, create_date_time +, run_offline_flag +, max_number_of_options +, min_number_of_options +, options_instructions +, tool_id +, tool_content_id +, activity_category_id +, gate_activity_level_id +, gate_open_flag +, gate_start_time_offset +, gate_end_time_offset +, gate_start_date_time +, gate_end_date_time +, library_activity_ui_image +, create_grouping_id +, create_grouping_ui_id +, library_activity_id +, language_file +) +VALUES +( +NULL +, 'Moodle Assignment Tool' +, 'Moodle Assignment Tool' +, 'Moodle Assignment Tool.' +, NULL +, NULL +, NULL +, NULL +, 1 +, 2 +, 0 +, NULL +, NULL +, NULL +, 0 +, NULL +, ${learning_library_id} +, NOW() +, 0 +, NULL +, NULL +, NULL +, ${tool_id} +, NULL +, 6 +, NULL +, NULL +, NULL +, NULL +, NULL +, NULL +, 'tool/mdasgm10/images/icon_mdlAssignment.swf' +, NULL +, NULL +, NULL +, 'org.lamsfoundation.lams.tool.mdasgm.ApplicationResources' +) Index: tool_adapters/moodle/lams_tool_mdlassignment/db/sql/create_lams_tool_mdlAssignment.sql =================================================================== diff -u -ra0b65d229f3b02db82d0a6ea563c0d4e540e8118 -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdlassignment/db/sql/create_lams_tool_mdlAssignment.sql (.../create_lams_tool_mdlAssignment.sql) (revision a0b65d229f3b02db82d0a6ea563c0d4e540e8118) +++ tool_adapters/moodle/lams_tool_mdlassignment/db/sql/create_lams_tool_mdlAssignment.sql (.../create_lams_tool_mdlAssignment.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,29 +1,29 @@ --- CVS ID: $Id$ - -SET FOREIGN_KEY_CHECKS=0; -drop table if exists tl_mdasgm10_mdlassignment; -drop table if exists tl_mdasgm10_session; -drop table if exists tl_mdasgm10_user; -create table tl_mdasgm10_mdlassignment (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_lms_id varchar(255), ext_course_id varchar(255), ext_section varchar(255), primary key (uid))TYPE=InnoDB; -create table tl_mdasgm10_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), mdlassignment_uid bigint, primary key (uid))TYPE=InnoDB; -create table tl_mdasgm10_user (uid bigint not null auto_increment, user_id bigint, last_name varchar(255), login_name varchar(255), first_name varchar(255), finishedActivity bit, mdlassignment_session_uid bigint, entry_uid bigint, primary key (uid))TYPE=InnoDB; -alter table tl_mdasgm10_session add index FKFKmdasgm10_session (mdlAssignment_uid), add constraint FKmdasgm10_session foreign key (mdlAssignment_uid) references tl_mdasgm10_mdlassignment (uid); -alter table tl_mdasgm10_user add index FKmdasgm10_user (mdlassignment_session_uid), add constraint FKmdasgm10_user foreign key (mdlassignment_session_uid) references tl_mdasgm10_session (uid); - - -INSERT INTO tl_mdasgm10_mdlassignment ( - 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_mdasgm10_mdlassignment; +drop table if exists tl_mdasgm10_session; +drop table if exists tl_mdasgm10_user; +create table tl_mdasgm10_mdlassignment (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_lms_id varchar(255), ext_course_id varchar(255), ext_section varchar(255), primary key (uid))TYPE=InnoDB; +create table tl_mdasgm10_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), mdlassignment_uid bigint, primary key (uid))TYPE=InnoDB; +create table tl_mdasgm10_user (uid bigint not null auto_increment, user_id bigint, last_name varchar(255), login_name varchar(255), first_name varchar(255), finishedActivity bit, mdlassignment_session_uid bigint, entry_uid bigint, primary key (uid))TYPE=InnoDB; +alter table tl_mdasgm10_session add index FKFKmdasgm10_session (mdlAssignment_uid), add constraint FKmdasgm10_session foreign key (mdlAssignment_uid) references tl_mdasgm10_mdlassignment (uid); +alter table tl_mdasgm10_user add index FKmdasgm10_user (mdlassignment_session_uid), add constraint FKmdasgm10_user foreign key (mdlassignment_session_uid) references tl_mdasgm10_session (uid); + + +INSERT INTO tl_mdasgm10_mdlassignment ( + 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; Index: tool_adapters/moodle/lams_tool_mdlassignment/db/sql/drop_lams_tool_mdlAssignment.sql =================================================================== diff -u -r03cfe4c9ea322f2291e0e45c9e4879f67f4c5e85 -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdlassignment/db/sql/drop_lams_tool_mdlAssignment.sql (.../drop_lams_tool_mdlAssignment.sql) (revision 03cfe4c9ea322f2291e0e45c9e4879f67f4c5e85) +++ tool_adapters/moodle/lams_tool_mdlassignment/db/sql/drop_lams_tool_mdlAssignment.sql (.../drop_lams_tool_mdlAssignment.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,13 +1,13 @@ --- CVS ID: $Id$ - -SET FOREIGN_KEY_CHECKS=0; -DROP TABLE IF EXISTS tl_mdasgm10_user; -DROP TABLE IF EXISTS tl_mdasgm10_attachment; -DROP TABLE IF EXISTS tl_mdasgm10_session; -DROP TABLE IF EXISTS tl_mdasgm10_mdlassignment; -SET FOREIGN_KEY_CHECKS=1; - - - - - +-- CVS ID: $Id$ + +SET FOREIGN_KEY_CHECKS=0; +DROP TABLE IF EXISTS tl_mdasgm10_user; +DROP TABLE IF EXISTS tl_mdasgm10_attachment; +DROP TABLE IF EXISTS tl_mdasgm10_session; +DROP TABLE IF EXISTS tl_mdasgm10_mdlassignment; +SET FOREIGN_KEY_CHECKS=1; + + + + + Index: tool_adapters/moodle/lams_tool_mdlassignment/db/sql/library_insert.sql =================================================================== diff -u -r03cfe4c9ea322f2291e0e45c9e4879f67f4c5e85 -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdlassignment/db/sql/library_insert.sql (.../library_insert.sql) (revision 03cfe4c9ea322f2291e0e45c9e4879f67f4c5e85) +++ tool_adapters/moodle/lams_tool_mdlassignment/db/sql/library_insert.sql (.../library_insert.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,16 +1,16 @@ --- CVS ID: $Id$ - -INSERT INTO lams_learning_library -( -description, -title, -valid_flag, -create_date_time -) -VALUES -( -'MdlAssignment Tool', -'MdlAssignment', -0, -NOW() -) +-- CVS ID: $Id$ + +INSERT INTO lams_learning_library +( +description, +title, +valid_flag, +create_date_time +) +VALUES +( +'MdlAssignment Tool', +'MdlAssignment', +0, +NOW() +) Index: tool_adapters/moodle/lams_tool_mdlassignment/db/sql/table-schema.sql =================================================================== diff -u -r03cfe4c9ea322f2291e0e45c9e4879f67f4c5e85 -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdlassignment/db/sql/table-schema.sql (.../table-schema.sql) (revision 03cfe4c9ea322f2291e0e45c9e4879f67f4c5e85) +++ tool_adapters/moodle/lams_tool_mdlassignment/db/sql/table-schema.sql (.../table-schema.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,12 +1,12 @@ -alter table tl_mdasgm10_session drop foreign key FKE2A598184D07F6E8; -alter table tl_mdasgm10_user drop foreign key FK108B9589C7050F3F; -drop table if exists tl_mdasgm10_configuration; -drop table if exists tl_mdasgm10_mdlassignment; -drop table if exists tl_mdasgm10_session; -drop table if exists tl_mdasgm10_user; -create table tl_mdasgm10_configuration (uid bigint not null auto_increment, config_key varchar(30) unique, config_value varchar(255), primary key (uid)); -create table tl_mdasgm10_mdlassignment (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)); -create table tl_mdasgm10_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), mdlAssignment_uid bigint, primary key (uid)); -create table tl_mdasgm10_user (uid bigint not null auto_increment, user_id bigint, last_name varchar(255), login_name varchar(255), first_name varchar(255), finishedActivity bit, mdlassignment_session_uid bigint, entry_uid bigint, primary key (uid)); -alter table tl_mdasgm10_session add index FKE2A598184D07F6E8 (mdlAssignment_uid), add constraint FKE2A598184D07F6E8 foreign key (mdlAssignment_uid) references tl_mdasgm10_mdlassignment (uid); -alter table tl_mdasgm10_user add index FK108B9589C7050F3F (mdlassignment_session_uid), add constraint FK108B9589C7050F3F foreign key (mdlassignment_session_uid) references tl_mdasgm10_session (uid); +alter table tl_mdasgm10_session drop foreign key FKE2A598184D07F6E8; +alter table tl_mdasgm10_user drop foreign key FK108B9589C7050F3F; +drop table if exists tl_mdasgm10_configuration; +drop table if exists tl_mdasgm10_mdlassignment; +drop table if exists tl_mdasgm10_session; +drop table if exists tl_mdasgm10_user; +create table tl_mdasgm10_configuration (uid bigint not null auto_increment, config_key varchar(30) unique, config_value varchar(255), primary key (uid)); +create table tl_mdasgm10_mdlassignment (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)); +create table tl_mdasgm10_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), mdlAssignment_uid bigint, primary key (uid)); +create table tl_mdasgm10_user (uid bigint not null auto_increment, user_id bigint, last_name varchar(255), login_name varchar(255), first_name varchar(255), finishedActivity bit, mdlassignment_session_uid bigint, entry_uid bigint, primary key (uid)); +alter table tl_mdasgm10_session add index FKE2A598184D07F6E8 (mdlAssignment_uid), add constraint FKE2A598184D07F6E8 foreign key (mdlAssignment_uid) references tl_mdasgm10_mdlassignment (uid); +alter table tl_mdasgm10_user add index FK108B9589C7050F3F (mdlassignment_session_uid), add constraint FK108B9589C7050F3F foreign key (mdlassignment_session_uid) references tl_mdasgm10_session (uid); Index: tool_adapters/moodle/lams_tool_mdlassignment/db/sql/tool_insert.sql =================================================================== diff -u -rb6544cfe682554653a9590c0bf74ed52186d71ff -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdlassignment/db/sql/tool_insert.sql (.../tool_insert.sql) (revision b6544cfe682554653a9590c0bf74ed52186d71ff) +++ tool_adapters/moodle/lams_tool_mdlassignment/db/sql/tool_insert.sql (.../tool_insert.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,64 +1,64 @@ --- CVS ID: $Id$ - -INSERT INTO lams_tool -( -tool_signature, -service_name, -tool_display_name, -description, -tool_identifier, -tool_version, -learning_library_id, -default_tool_content_id, -valid_flag, -grouping_support_type_id, -supports_run_offline_flag, -learner_url, -learner_preview_url, -learner_progress_url, -author_url, -monitor_url, -define_later_url, -export_pfolio_learner_url, -export_pfolio_class_url, -contribute_url, -moderation_url, -help_url, -admin_url, -language_file, -create_date_time, -modified_date_time, -ext_lms_id, -supports_outputs -) -VALUES -( -'mdasgm10', -'mdlAssignmentService', -'MdlAssignment', -'MdlAssignment', -'mdlAssignment', -'@tool_version@', -NULL, -NULL, -0, -2, -1, -'tool/mdasgm10/learning.do?mode=learner', -'tool/mdasgm10/learning.do?mode=author', -'tool/mdasgm10/learning.do?mode=teacher', -'tool/mdasgm10/authoring.do', -'tool/mdasgm10/monitoring.do', -'tool/mdasgm10/authoring.do?mode=teacher', -'tool/mdasgm10/exportPortfolio?mode=learner', -'tool/mdasgm10/exportPortfolio?mode=teacher', -'tool/mdasgm10/contribute.do', -'tool/mdasgm10/moderate.do', -'http://wiki.lamsfoundation.org/display/lamsdocs/mdasgm10', -'tool/mdasgm10/mdasgm10admin.do', -'org.lamsfoundation.lams.tool.mdasgm.ApplicationResources', -NOW(), -NOW(), -'moodle', -true -) +-- CVS ID: $Id$ + +INSERT INTO lams_tool +( +tool_signature, +service_name, +tool_display_name, +description, +tool_identifier, +tool_version, +learning_library_id, +default_tool_content_id, +valid_flag, +grouping_support_type_id, +supports_run_offline_flag, +learner_url, +learner_preview_url, +learner_progress_url, +author_url, +monitor_url, +define_later_url, +export_pfolio_learner_url, +export_pfolio_class_url, +contribute_url, +moderation_url, +help_url, +admin_url, +language_file, +create_date_time, +modified_date_time, +ext_lms_id, +supports_outputs +) +VALUES +( +'mdasgm10', +'mdlAssignmentService', +'MdlAssignment', +'MdlAssignment', +'mdlAssignment', +'@tool_version@', +NULL, +NULL, +0, +2, +1, +'tool/mdasgm10/learning.do?mode=learner', +'tool/mdasgm10/learning.do?mode=author', +'tool/mdasgm10/learning.do?mode=teacher', +'tool/mdasgm10/authoring.do', +'tool/mdasgm10/monitoring.do', +'tool/mdasgm10/authoring.do?mode=teacher', +'tool/mdasgm10/exportPortfolio?mode=learner', +'tool/mdasgm10/exportPortfolio?mode=teacher', +'tool/mdasgm10/contribute.do', +'tool/mdasgm10/moderate.do', +'http://wiki.lamsfoundation.org/display/lamsdocs/mdasgm10', +'tool/mdasgm10/mdasgm10admin.do', +'org.lamsfoundation.lams.tool.mdasgm.ApplicationResources', +NOW(), +NOW(), +'moodle', +true +) Index: tool_adapters/moodle/lams_tool_mdlchat/db/sql/activity_insert.sql =================================================================== diff -u -r5fa2b7156e4da1c53222aa8a5eea1594b72665a5 -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdlchat/db/sql/activity_insert.sql (.../activity_insert.sql) (revision 5fa2b7156e4da1c53222aa8a5eea1594b72665a5) +++ tool_adapters/moodle/lams_tool_mdlchat/db/sql/activity_insert.sql (.../activity_insert.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,80 +1,80 @@ --- CVS ID: $Id$ - -INSERT INTO lams_learning_activity -( -activity_ui_id -, description -, title -, help_text -, xcoord -, ycoord -, parent_activity_id -, parent_ui_id -, learning_activity_type_id -, grouping_support_type_id -, apply_grouping_flag -, grouping_id -, grouping_ui_id -, order_id -, define_later_flag -, learning_design_id -, learning_library_id -, create_date_time -, run_offline_flag -, max_number_of_options -, min_number_of_options -, options_instructions -, tool_id -, tool_content_id -, activity_category_id -, gate_activity_level_id -, gate_open_flag -, gate_start_time_offset -, gate_end_time_offset -, gate_start_date_time -, gate_end_date_time -, library_activity_ui_image -, create_grouping_id -, create_grouping_ui_id -, library_activity_id -, language_file -) -VALUES -( -NULL -, 'Moodle Chat Tool' -, 'Moodle Chat Tool' -, 'Moodle Chat Tool.' -, NULL -, NULL -, NULL -, NULL -, 1 -, 2 -, 0 -, NULL -, NULL -, NULL -, 0 -, NULL -, ${learning_library_id} -, NOW() -, 0 -, NULL -, NULL -, NULL -, ${tool_id} -, NULL -, 6 -, NULL -, NULL -, NULL -, NULL -, NULL -, NULL -, 'tool/mdchat10/images/icon_mdlChat.swf' -, NULL -, NULL -, NULL -, 'org.lamsfoundation.lams.tool.mdchat.ApplicationResources' -) +-- CVS ID: $Id$ + +INSERT INTO lams_learning_activity +( +activity_ui_id +, description +, title +, help_text +, xcoord +, ycoord +, parent_activity_id +, parent_ui_id +, learning_activity_type_id +, grouping_support_type_id +, apply_grouping_flag +, grouping_id +, grouping_ui_id +, order_id +, define_later_flag +, learning_design_id +, learning_library_id +, create_date_time +, run_offline_flag +, max_number_of_options +, min_number_of_options +, options_instructions +, tool_id +, tool_content_id +, activity_category_id +, gate_activity_level_id +, gate_open_flag +, gate_start_time_offset +, gate_end_time_offset +, gate_start_date_time +, gate_end_date_time +, library_activity_ui_image +, create_grouping_id +, create_grouping_ui_id +, library_activity_id +, language_file +) +VALUES +( +NULL +, 'Moodle Chat Tool' +, 'Moodle Chat Tool' +, 'Moodle Chat Tool.' +, NULL +, NULL +, NULL +, NULL +, 1 +, 2 +, 0 +, NULL +, NULL +, NULL +, 0 +, NULL +, ${learning_library_id} +, NOW() +, 0 +, NULL +, NULL +, NULL +, ${tool_id} +, NULL +, 6 +, NULL +, NULL +, NULL +, NULL +, NULL +, NULL +, 'tool/mdchat10/images/icon_mdlChat.swf' +, NULL +, NULL +, NULL +, 'org.lamsfoundation.lams.tool.mdchat.ApplicationResources' +) Index: tool_adapters/moodle/lams_tool_mdlchat/db/sql/drop_lams_tool_mdlChat.sql =================================================================== diff -u -r5fa2b7156e4da1c53222aa8a5eea1594b72665a5 -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdlchat/db/sql/drop_lams_tool_mdlChat.sql (.../drop_lams_tool_mdlChat.sql) (revision 5fa2b7156e4da1c53222aa8a5eea1594b72665a5) +++ tool_adapters/moodle/lams_tool_mdlchat/db/sql/drop_lams_tool_mdlChat.sql (.../drop_lams_tool_mdlChat.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,13 +1,13 @@ --- CVS ID: $Id$ - -SET FOREIGN_KEY_CHECKS=0; -DROP TABLE IF EXISTS tl_mdchat10_user; -DROP TABLE IF EXISTS tl_mdchat10_attachment; -DROP TABLE IF EXISTS tl_mdchat10_session; -DROP TABLE IF EXISTS tl_mdchat10_mdlchat; -SET FOREIGN_KEY_CHECKS=1; - - - - - +-- CVS ID: $Id$ + +SET FOREIGN_KEY_CHECKS=0; +DROP TABLE IF EXISTS tl_mdchat10_user; +DROP TABLE IF EXISTS tl_mdchat10_attachment; +DROP TABLE IF EXISTS tl_mdchat10_session; +DROP TABLE IF EXISTS tl_mdchat10_mdlchat; +SET FOREIGN_KEY_CHECKS=1; + + + + + Index: tool_adapters/moodle/lams_tool_mdlchat/db/sql/library_insert.sql =================================================================== diff -u -r5fa2b7156e4da1c53222aa8a5eea1594b72665a5 -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdlchat/db/sql/library_insert.sql (.../library_insert.sql) (revision 5fa2b7156e4da1c53222aa8a5eea1594b72665a5) +++ tool_adapters/moodle/lams_tool_mdlchat/db/sql/library_insert.sql (.../library_insert.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,16 +1,16 @@ --- CVS ID: $Id$ - -INSERT INTO lams_learning_library -( -description, -title, -valid_flag, -create_date_time -) -VALUES -( -'MdlChat Tool', -'MdlChat', -0, -NOW() -) +-- CVS ID: $Id$ + +INSERT INTO lams_learning_library +( +description, +title, +valid_flag, +create_date_time +) +VALUES +( +'MdlChat Tool', +'MdlChat', +0, +NOW() +) Index: tool_adapters/moodle/lams_tool_mdlchat/db/sql/table-schema.sql =================================================================== diff -u -r5fa2b7156e4da1c53222aa8a5eea1594b72665a5 -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdlchat/db/sql/table-schema.sql (.../table-schema.sql) (revision 5fa2b7156e4da1c53222aa8a5eea1594b72665a5) +++ tool_adapters/moodle/lams_tool_mdlchat/db/sql/table-schema.sql (.../table-schema.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,12 +1,12 @@ -alter table tl_mdchat10_session drop foreign key FKE2A598184D07F6E8; -alter table tl_mdchat10_user drop foreign key FK108B9589C7050F3F; -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)); -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)); -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)); -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)); -alter table tl_mdchat10_session add index FKE2A598184D07F6E8 (mdlChat_uid), add constraint FKE2A598184D07F6E8 foreign key (mdlChat_uid) references tl_mdchat10_mdlchat (uid); -alter table tl_mdchat10_user add index FK108B9589C7050F3F (mdlchat_session_uid), add constraint FK108B9589C7050F3F foreign key (mdlchat_session_uid) references tl_mdchat10_session (uid); +alter table tl_mdchat10_session drop foreign key FKE2A598184D07F6E8; +alter table tl_mdchat10_user drop foreign key FK108B9589C7050F3F; +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)); +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)); +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)); +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)); +alter table tl_mdchat10_session add index FKE2A598184D07F6E8 (mdlChat_uid), add constraint FKE2A598184D07F6E8 foreign key (mdlChat_uid) references tl_mdchat10_mdlchat (uid); +alter table tl_mdchat10_user add index FK108B9589C7050F3F (mdlchat_session_uid), add constraint FK108B9589C7050F3F foreign key (mdlchat_session_uid) references tl_mdchat10_session (uid); Index: tool_adapters/moodle/lams_tool_mdlchat/db/sql/tool_insert.sql =================================================================== diff -u -rb6544cfe682554653a9590c0bf74ed52186d71ff -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdlchat/db/sql/tool_insert.sql (.../tool_insert.sql) (revision b6544cfe682554653a9590c0bf74ed52186d71ff) +++ tool_adapters/moodle/lams_tool_mdlchat/db/sql/tool_insert.sql (.../tool_insert.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,64 +1,64 @@ --- CVS ID: $Id$ - -INSERT INTO lams_tool -( -tool_signature, -service_name, -tool_display_name, -description, -tool_identifier, -tool_version, -learning_library_id, -default_tool_content_id, -valid_flag, -grouping_support_type_id, -supports_run_offline_flag, -learner_url, -learner_preview_url, -learner_progress_url, -author_url, -monitor_url, -define_later_url, -export_pfolio_learner_url, -export_pfolio_class_url, -contribute_url, -moderation_url, -help_url, -admin_url, -language_file, -create_date_time, -modified_date_time, -ext_lms_id, -supports_outputs -) -VALUES -( -'mdchat10', -'mdlChatService', -'MdlChat', -'MdlChat', -'mdlChat', -'@tool_version@', -NULL, -NULL, -0, -2, -1, -'tool/mdchat10/learning.do?mode=learner', -'tool/mdchat10/learning.do?mode=author', -'tool/mdchat10/learning.do?mode=teacher', -'tool/mdchat10/authoring.do', -'tool/mdchat10/monitoring.do', -'tool/mdchat10/authoring.do?mode=teacher', -'tool/mdchat10/exportPortfolio?mode=learner', -'tool/mdchat10/exportPortfolio?mode=teacher', -'tool/mdchat10/contribute.do', -'tool/mdchat10/moderate.do', -'http://wiki.lamsfoundation.org/display/lamsdocs/mdchat10', -'tool/mdchat10/mdchat10admin.do', -'org.lamsfoundation.lams.tool.mdchat.ApplicationResources', -NOW(), -NOW(), -'moodle', -true -) +-- CVS ID: $Id$ + +INSERT INTO lams_tool +( +tool_signature, +service_name, +tool_display_name, +description, +tool_identifier, +tool_version, +learning_library_id, +default_tool_content_id, +valid_flag, +grouping_support_type_id, +supports_run_offline_flag, +learner_url, +learner_preview_url, +learner_progress_url, +author_url, +monitor_url, +define_later_url, +export_pfolio_learner_url, +export_pfolio_class_url, +contribute_url, +moderation_url, +help_url, +admin_url, +language_file, +create_date_time, +modified_date_time, +ext_lms_id, +supports_outputs +) +VALUES +( +'mdchat10', +'mdlChatService', +'MdlChat', +'MdlChat', +'mdlChat', +'@tool_version@', +NULL, +NULL, +0, +2, +1, +'tool/mdchat10/learning.do?mode=learner', +'tool/mdchat10/learning.do?mode=author', +'tool/mdchat10/learning.do?mode=teacher', +'tool/mdchat10/authoring.do', +'tool/mdchat10/monitoring.do', +'tool/mdchat10/authoring.do?mode=teacher', +'tool/mdchat10/exportPortfolio?mode=learner', +'tool/mdchat10/exportPortfolio?mode=teacher', +'tool/mdchat10/contribute.do', +'tool/mdchat10/moderate.do', +'http://wiki.lamsfoundation.org/display/lamsdocs/mdchat10', +'tool/mdchat10/mdchat10admin.do', +'org.lamsfoundation.lams.tool.mdchat.ApplicationResources', +NOW(), +NOW(), +'moodle', +true +) Index: tool_adapters/moodle/lams_tool_mdlglossary/db/sql/activity_insert.sql =================================================================== diff -u -ra0090b285b6cc7ba32abea09e3ad97c90c28ad3b -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdlglossary/db/sql/activity_insert.sql (.../activity_insert.sql) (revision a0090b285b6cc7ba32abea09e3ad97c90c28ad3b) +++ tool_adapters/moodle/lams_tool_mdlglossary/db/sql/activity_insert.sql (.../activity_insert.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,80 +1,80 @@ --- CVS ID: $Id$ - -INSERT INTO lams_learning_activity -( -activity_ui_id -, description -, title -, help_text -, xcoord -, ycoord -, parent_activity_id -, parent_ui_id -, learning_activity_type_id -, grouping_support_type_id -, apply_grouping_flag -, grouping_id -, grouping_ui_id -, order_id -, define_later_flag -, learning_design_id -, learning_library_id -, create_date_time -, run_offline_flag -, max_number_of_options -, min_number_of_options -, options_instructions -, tool_id -, tool_content_id -, activity_category_id -, gate_activity_level_id -, gate_open_flag -, gate_start_time_offset -, gate_end_time_offset -, gate_start_date_time -, gate_end_date_time -, library_activity_ui_image -, create_grouping_id -, create_grouping_ui_id -, library_activity_id -, language_file -) -VALUES -( -NULL -, 'Moodle Glossary Tool' -, 'Moodle Glossary Tool' -, 'Moodle Glossary Tool.' -, NULL -, NULL -, NULL -, NULL -, 1 -, 2 -, 0 -, NULL -, NULL -, NULL -, 0 -, NULL -, ${learning_library_id} -, NOW() -, 0 -, NULL -, NULL -, NULL -, ${tool_id} -, NULL -, 6 -, NULL -, NULL -, NULL -, NULL -, NULL -, NULL -, 'tool/mdglos10/images/icon_mdlGlossary.swf' -, NULL -, NULL -, NULL -, 'org.lamsfoundation.lams.tool.mdglos.ApplicationResources' -) +-- CVS ID: $Id$ + +INSERT INTO lams_learning_activity +( +activity_ui_id +, description +, title +, help_text +, xcoord +, ycoord +, parent_activity_id +, parent_ui_id +, learning_activity_type_id +, grouping_support_type_id +, apply_grouping_flag +, grouping_id +, grouping_ui_id +, order_id +, define_later_flag +, learning_design_id +, learning_library_id +, create_date_time +, run_offline_flag +, max_number_of_options +, min_number_of_options +, options_instructions +, tool_id +, tool_content_id +, activity_category_id +, gate_activity_level_id +, gate_open_flag +, gate_start_time_offset +, gate_end_time_offset +, gate_start_date_time +, gate_end_date_time +, library_activity_ui_image +, create_grouping_id +, create_grouping_ui_id +, library_activity_id +, language_file +) +VALUES +( +NULL +, 'Moodle Glossary Tool' +, 'Moodle Glossary Tool' +, 'Moodle Glossary Tool.' +, NULL +, NULL +, NULL +, NULL +, 1 +, 2 +, 0 +, NULL +, NULL +, NULL +, 0 +, NULL +, ${learning_library_id} +, NOW() +, 0 +, NULL +, NULL +, NULL +, ${tool_id} +, NULL +, 6 +, NULL +, NULL +, NULL +, NULL +, NULL +, NULL +, 'tool/mdglos10/images/icon_mdlGlossary.swf' +, NULL +, NULL +, NULL +, 'org.lamsfoundation.lams.tool.mdglos.ApplicationResources' +) Index: tool_adapters/moodle/lams_tool_mdlglossary/db/sql/create_lams_tool_mdlGlossary.sql =================================================================== diff -u -rfa37195a28464d5c7753243498cce58c46084240 -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdlglossary/db/sql/create_lams_tool_mdlGlossary.sql (.../create_lams_tool_mdlGlossary.sql) (revision fa37195a28464d5c7753243498cce58c46084240) +++ tool_adapters/moodle/lams_tool_mdlglossary/db/sql/create_lams_tool_mdlGlossary.sql (.../create_lams_tool_mdlGlossary.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,28 +1,28 @@ --- CVS ID: $Id$ - -SET FOREIGN_KEY_CHECKS=0; -drop table if exists tl_mdglos10_mdlglossary; -drop table if exists tl_mdglos10_session; -drop table if exists tl_mdglos10_user; -create table tl_mdglos10_mdlglossary (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_lms_id varchar(255), ext_course_id varchar(255), ext_section varchar(255), primary key (uid))TYPE=InnoDB; -create table tl_mdglos10_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), mdlglossary_uid bigint, primary key (uid))TYPE=InnoDB; -create table tl_mdglos10_user (uid bigint not null auto_increment, user_id bigint, last_name varchar(255), login_name varchar(255), first_name varchar(255), finishedActivity bit, mdlglossary_session_uid bigint, entry_uid bigint, primary key (uid))TYPE=InnoDB; -alter table tl_mdglos10_session add index FKGLOSBA4AC37B89669C81 (mdlglossary_uid), add constraint FKGLOSBA4AC37B89669C81 foreign key (mdlglossary_uid) references tl_mdglos10_mdlglossary (uid); -alter table tl_mdglos10_user add index FKGLOS1B25DD0618E034DA (mdlglossary_session_uid), add constraint FKGLOS1B25DD0618E034DA foreign key (mdlglossary_session_uid) references tl_mdglos10_session (uid); - -INSERT INTO tl_mdglos10_mdlglossary ( - 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_mdglos10_mdlglossary; +drop table if exists tl_mdglos10_session; +drop table if exists tl_mdglos10_user; +create table tl_mdglos10_mdlglossary (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_lms_id varchar(255), ext_course_id varchar(255), ext_section varchar(255), primary key (uid))TYPE=InnoDB; +create table tl_mdglos10_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), mdlglossary_uid bigint, primary key (uid))TYPE=InnoDB; +create table tl_mdglos10_user (uid bigint not null auto_increment, user_id bigint, last_name varchar(255), login_name varchar(255), first_name varchar(255), finishedActivity bit, mdlglossary_session_uid bigint, entry_uid bigint, primary key (uid))TYPE=InnoDB; +alter table tl_mdglos10_session add index FKGLOSBA4AC37B89669C81 (mdlglossary_uid), add constraint FKGLOSBA4AC37B89669C81 foreign key (mdlglossary_uid) references tl_mdglos10_mdlglossary (uid); +alter table tl_mdglos10_user add index FKGLOS1B25DD0618E034DA (mdlglossary_session_uid), add constraint FKGLOS1B25DD0618E034DA foreign key (mdlglossary_session_uid) references tl_mdglos10_session (uid); + +INSERT INTO tl_mdglos10_mdlglossary ( + 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; Index: tool_adapters/moodle/lams_tool_mdlglossary/db/sql/drop_lams_tool_mdlGlossary.sql =================================================================== diff -u -ra0090b285b6cc7ba32abea09e3ad97c90c28ad3b -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdlglossary/db/sql/drop_lams_tool_mdlGlossary.sql (.../drop_lams_tool_mdlGlossary.sql) (revision a0090b285b6cc7ba32abea09e3ad97c90c28ad3b) +++ tool_adapters/moodle/lams_tool_mdlglossary/db/sql/drop_lams_tool_mdlGlossary.sql (.../drop_lams_tool_mdlGlossary.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,13 +1,13 @@ --- CVS ID: $Id$ - -SET FOREIGN_KEY_CHECKS=0; -DROP TABLE IF EXISTS tl_mdglos10_user; -DROP TABLE IF EXISTS tl_mdglos10_attachment; -DROP TABLE IF EXISTS tl_mdglos10_session; -DROP TABLE IF EXISTS tl_mdglos10_mdlglossary; -SET FOREIGN_KEY_CHECKS=1; - - - - - +-- CVS ID: $Id$ + +SET FOREIGN_KEY_CHECKS=0; +DROP TABLE IF EXISTS tl_mdglos10_user; +DROP TABLE IF EXISTS tl_mdglos10_attachment; +DROP TABLE IF EXISTS tl_mdglos10_session; +DROP TABLE IF EXISTS tl_mdglos10_mdlglossary; +SET FOREIGN_KEY_CHECKS=1; + + + + + Index: tool_adapters/moodle/lams_tool_mdlglossary/db/sql/library_insert.sql =================================================================== diff -u -ra0090b285b6cc7ba32abea09e3ad97c90c28ad3b -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdlglossary/db/sql/library_insert.sql (.../library_insert.sql) (revision a0090b285b6cc7ba32abea09e3ad97c90c28ad3b) +++ tool_adapters/moodle/lams_tool_mdlglossary/db/sql/library_insert.sql (.../library_insert.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,16 +1,16 @@ --- CVS ID: $Id$ - -INSERT INTO lams_learning_library -( -description, -title, -valid_flag, -create_date_time -) -VALUES -( -'MdlGlossary Tool', -'MdlGlossary', -0, -NOW() -) +-- CVS ID: $Id$ + +INSERT INTO lams_learning_library +( +description, +title, +valid_flag, +create_date_time +) +VALUES +( +'MdlGlossary Tool', +'MdlGlossary', +0, +NOW() +) Index: tool_adapters/moodle/lams_tool_mdlglossary/db/sql/table-schema.sql =================================================================== diff -u -ra0090b285b6cc7ba32abea09e3ad97c90c28ad3b -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdlglossary/db/sql/table-schema.sql (.../table-schema.sql) (revision a0090b285b6cc7ba32abea09e3ad97c90c28ad3b) +++ tool_adapters/moodle/lams_tool_mdlglossary/db/sql/table-schema.sql (.../table-schema.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,12 +1,12 @@ -alter table tl_mdglos10_session drop foreign key FKBA4AC37B89669C81; -alter table tl_mdglos10_user drop foreign key FK1B25DD0618E034DA; -drop table if exists tl_mdglos10_configuration; -drop table if exists tl_mdglos10_mdlglossary; -drop table if exists tl_mdglos10_session; -drop table if exists tl_mdglos10_user; -create table tl_mdglos10_configuration (uid bigint not null auto_increment, config_key varchar(30) unique, config_value varchar(255), primary key (uid)); -create table tl_mdglos10_mdlglossary (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)); -create table tl_mdglos10_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), mdlglossary_uid bigint, primary key (uid)); -create table tl_mdglos10_user (uid bigint not null auto_increment, user_id bigint, last_name varchar(255), login_name varchar(255), first_name varchar(255), finishedActivity bit, mdlglossary_session_uid bigint, entry_uid bigint, primary key (uid)); -alter table tl_mdglos10_session add index FKBA4AC37B89669C81 (mdlglossary_uid), add constraint FKBA4AC37B89669C81 foreign key (mdlglossary_uid) references tl_mdglos10_mdlglossary (uid); -alter table tl_mdglos10_user add index FK1B25DD0618E034DA (mdlglossary_session_uid), add constraint FK1B25DD0618E034DA foreign key (mdlglossary_session_uid) references tl_mdglos10_session (uid); +alter table tl_mdglos10_session drop foreign key FKBA4AC37B89669C81; +alter table tl_mdglos10_user drop foreign key FK1B25DD0618E034DA; +drop table if exists tl_mdglos10_configuration; +drop table if exists tl_mdglos10_mdlglossary; +drop table if exists tl_mdglos10_session; +drop table if exists tl_mdglos10_user; +create table tl_mdglos10_configuration (uid bigint not null auto_increment, config_key varchar(30) unique, config_value varchar(255), primary key (uid)); +create table tl_mdglos10_mdlglossary (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)); +create table tl_mdglos10_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), mdlglossary_uid bigint, primary key (uid)); +create table tl_mdglos10_user (uid bigint not null auto_increment, user_id bigint, last_name varchar(255), login_name varchar(255), first_name varchar(255), finishedActivity bit, mdlglossary_session_uid bigint, entry_uid bigint, primary key (uid)); +alter table tl_mdglos10_session add index FKBA4AC37B89669C81 (mdlglossary_uid), add constraint FKBA4AC37B89669C81 foreign key (mdlglossary_uid) references tl_mdglos10_mdlglossary (uid); +alter table tl_mdglos10_user add index FK1B25DD0618E034DA (mdlglossary_session_uid), add constraint FK1B25DD0618E034DA foreign key (mdlglossary_session_uid) references tl_mdglos10_session (uid); Index: tool_adapters/moodle/lams_tool_mdlglossary/db/sql/tool_insert.sql =================================================================== diff -u -rb6544cfe682554653a9590c0bf74ed52186d71ff -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdlglossary/db/sql/tool_insert.sql (.../tool_insert.sql) (revision b6544cfe682554653a9590c0bf74ed52186d71ff) +++ tool_adapters/moodle/lams_tool_mdlglossary/db/sql/tool_insert.sql (.../tool_insert.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,64 +1,64 @@ --- CVS ID: $Id$ - -INSERT INTO lams_tool -( -tool_signature, -service_name, -tool_display_name, -description, -tool_identifier, -tool_version, -learning_library_id, -default_tool_content_id, -valid_flag, -grouping_support_type_id, -supports_run_offline_flag, -learner_url, -learner_preview_url, -learner_progress_url, -author_url, -monitor_url, -define_later_url, -export_pfolio_learner_url, -export_pfolio_class_url, -contribute_url, -moderation_url, -help_url, -admin_url, -language_file, -create_date_time, -modified_date_time, -ext_lms_id, -supports_outputs -) -VALUES -( -'mdglos10', -'mdlGlossaryService', -'MdlGlossary', -'MdlGlossary', -'mdlGlossary', -'@tool_version@', -NULL, -NULL, -0, -2, -1, -'tool/mdglos10/learning.do?mode=learner', -'tool/mdglos10/learning.do?mode=author', -'tool/mdglos10/learning.do?mode=teacher', -'tool/mdglos10/authoring.do', -'tool/mdglos10/monitoring.do', -'tool/mdglos10/authoring.do?mode=teacher', -'tool/mdglos10/exportPortfolio?mode=learner', -'tool/mdglos10/exportPortfolio?mode=teacher', -'tool/mdglos10/contribute.do', -'tool/mdglos10/moderate.do', -'http://wiki.lamsfoundation.org/display/lamsdocs/mdglos10', -'tool/mdglos10/mdglos10admin.do', -'org.lamsfoundation.lams.tool.mdglos.ApplicationResources', -NOW(), -NOW(), -'moodle', -true -) +-- CVS ID: $Id$ + +INSERT INTO lams_tool +( +tool_signature, +service_name, +tool_display_name, +description, +tool_identifier, +tool_version, +learning_library_id, +default_tool_content_id, +valid_flag, +grouping_support_type_id, +supports_run_offline_flag, +learner_url, +learner_preview_url, +learner_progress_url, +author_url, +monitor_url, +define_later_url, +export_pfolio_learner_url, +export_pfolio_class_url, +contribute_url, +moderation_url, +help_url, +admin_url, +language_file, +create_date_time, +modified_date_time, +ext_lms_id, +supports_outputs +) +VALUES +( +'mdglos10', +'mdlGlossaryService', +'MdlGlossary', +'MdlGlossary', +'mdlGlossary', +'@tool_version@', +NULL, +NULL, +0, +2, +1, +'tool/mdglos10/learning.do?mode=learner', +'tool/mdglos10/learning.do?mode=author', +'tool/mdglos10/learning.do?mode=teacher', +'tool/mdglos10/authoring.do', +'tool/mdglos10/monitoring.do', +'tool/mdglos10/authoring.do?mode=teacher', +'tool/mdglos10/exportPortfolio?mode=learner', +'tool/mdglos10/exportPortfolio?mode=teacher', +'tool/mdglos10/contribute.do', +'tool/mdglos10/moderate.do', +'http://wiki.lamsfoundation.org/display/lamsdocs/mdglos10', +'tool/mdglos10/mdglos10admin.do', +'org.lamsfoundation.lams.tool.mdglos.ApplicationResources', +NOW(), +NOW(), +'moodle', +true +) Index: tool_adapters/moodle/lams_tool_mdllesson/db/sql/activity_insert.sql =================================================================== diff -u -r1900d45594cf161971a48d0e596b36fbcf06a0eb -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdllesson/db/sql/activity_insert.sql (.../activity_insert.sql) (revision 1900d45594cf161971a48d0e596b36fbcf06a0eb) +++ tool_adapters/moodle/lams_tool_mdllesson/db/sql/activity_insert.sql (.../activity_insert.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,80 +1,80 @@ --- CVS ID: $Id$ - -INSERT INTO lams_learning_activity -( -activity_ui_id -, description -, title -, help_text -, xcoord -, ycoord -, parent_activity_id -, parent_ui_id -, learning_activity_type_id -, grouping_support_type_id -, apply_grouping_flag -, grouping_id -, grouping_ui_id -, order_id -, define_later_flag -, learning_design_id -, learning_library_id -, create_date_time -, run_offline_flag -, max_number_of_options -, min_number_of_options -, options_instructions -, tool_id -, tool_content_id -, activity_category_id -, gate_activity_level_id -, gate_open_flag -, gate_start_time_offset -, gate_end_time_offset -, gate_start_date_time -, gate_end_date_time -, library_activity_ui_image -, create_grouping_id -, create_grouping_ui_id -, library_activity_id -, language_file -) -VALUES -( -NULL -, 'Moodle Lesson Tool' -, 'Moodle Lesson Tool' -, 'Moodle Lesson Tool.' -, NULL -, NULL -, NULL -, NULL -, 1 -, 2 -, 0 -, NULL -, NULL -, NULL -, 0 -, NULL -, ${learning_library_id} -, NOW() -, 0 -, NULL -, NULL -, NULL -, ${tool_id} -, NULL -, 6 -, NULL -, NULL -, NULL -, NULL -, NULL -, NULL -, 'tool/mdlesn10/images/icon_mdlLesson.swf' -, NULL -, NULL -, NULL -, 'org.lamsfoundation.lams.tool.mdlesn.ApplicationResources' -) +-- CVS ID: $Id$ + +INSERT INTO lams_learning_activity +( +activity_ui_id +, description +, title +, help_text +, xcoord +, ycoord +, parent_activity_id +, parent_ui_id +, learning_activity_type_id +, grouping_support_type_id +, apply_grouping_flag +, grouping_id +, grouping_ui_id +, order_id +, define_later_flag +, learning_design_id +, learning_library_id +, create_date_time +, run_offline_flag +, max_number_of_options +, min_number_of_options +, options_instructions +, tool_id +, tool_content_id +, activity_category_id +, gate_activity_level_id +, gate_open_flag +, gate_start_time_offset +, gate_end_time_offset +, gate_start_date_time +, gate_end_date_time +, library_activity_ui_image +, create_grouping_id +, create_grouping_ui_id +, library_activity_id +, language_file +) +VALUES +( +NULL +, 'Moodle Lesson Tool' +, 'Moodle Lesson Tool' +, 'Moodle Lesson Tool.' +, NULL +, NULL +, NULL +, NULL +, 1 +, 2 +, 0 +, NULL +, NULL +, NULL +, 0 +, NULL +, ${learning_library_id} +, NOW() +, 0 +, NULL +, NULL +, NULL +, ${tool_id} +, NULL +, 6 +, NULL +, NULL +, NULL +, NULL +, NULL +, NULL +, 'tool/mdlesn10/images/icon_mdlLesson.swf' +, NULL +, NULL +, NULL +, 'org.lamsfoundation.lams.tool.mdlesn.ApplicationResources' +) Index: tool_adapters/moodle/lams_tool_mdllesson/db/sql/create_lams_tool_mdlLesson.sql =================================================================== diff -u -r64c4c1fda7389d9cb57ac4b3876099f543cf6512 -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdllesson/db/sql/create_lams_tool_mdlLesson.sql (.../create_lams_tool_mdlLesson.sql) (revision 64c4c1fda7389d9cb57ac4b3876099f543cf6512) +++ tool_adapters/moodle/lams_tool_mdllesson/db/sql/create_lams_tool_mdlLesson.sql (.../create_lams_tool_mdlLesson.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,28 +1,28 @@ --- CVS ID: $Id$ - -SET FOREIGN_KEY_CHECKS=0; -drop table if exists tl_mdlesn10_mdllesson; -drop table if exists tl_mdlesn10_session; -drop table if exists tl_mdlesn10_user; -create table tl_mdlesn10_mdllesson (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_lms_id varchar(255), ext_course_id varchar(255), ext_section varchar(255), primary key (uid))TYPE=InnoDB; -create table tl_mdlesn10_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), mdllesson_uid bigint, primary key (uid))TYPE=InnoDB; -create table tl_mdlesn10_user (uid bigint not null auto_increment, user_id bigint, last_name varchar(255), login_name varchar(255), first_name varchar(255), finishedActivity bit, mdllesson_session_uid bigint, entry_uid bigint, primary key (uid))TYPE=InnoDB; -alter table tl_mdlesn10_session add index FKLESSBA4AC37B89669C81 (mdllesson_uid), add constraint FKLESSBA4AC37B89669C81 foreign key (mdllesson_uid) references tl_mdlesn10_mdllesson (uid); -alter table tl_mdlesn10_user add index FKLESS1B25DD0618E034DA (mdllesson_session_uid), add constraint FKLESS1B25DD0618E034DA foreign key (mdllesson_session_uid) references tl_mdlesn10_session (uid); - -INSERT INTO tl_mdlesn10_mdllesson ( - 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_mdlesn10_mdllesson; +drop table if exists tl_mdlesn10_session; +drop table if exists tl_mdlesn10_user; +create table tl_mdlesn10_mdllesson (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_lms_id varchar(255), ext_course_id varchar(255), ext_section varchar(255), primary key (uid))TYPE=InnoDB; +create table tl_mdlesn10_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), mdllesson_uid bigint, primary key (uid))TYPE=InnoDB; +create table tl_mdlesn10_user (uid bigint not null auto_increment, user_id bigint, last_name varchar(255), login_name varchar(255), first_name varchar(255), finishedActivity bit, mdllesson_session_uid bigint, entry_uid bigint, primary key (uid))TYPE=InnoDB; +alter table tl_mdlesn10_session add index FKLESSBA4AC37B89669C81 (mdllesson_uid), add constraint FKLESSBA4AC37B89669C81 foreign key (mdllesson_uid) references tl_mdlesn10_mdllesson (uid); +alter table tl_mdlesn10_user add index FKLESS1B25DD0618E034DA (mdllesson_session_uid), add constraint FKLESS1B25DD0618E034DA foreign key (mdllesson_session_uid) references tl_mdlesn10_session (uid); + +INSERT INTO tl_mdlesn10_mdllesson ( + 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; Index: tool_adapters/moodle/lams_tool_mdllesson/db/sql/drop_lams_tool_mdlLesson.sql =================================================================== diff -u -r1900d45594cf161971a48d0e596b36fbcf06a0eb -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdllesson/db/sql/drop_lams_tool_mdlLesson.sql (.../drop_lams_tool_mdlLesson.sql) (revision 1900d45594cf161971a48d0e596b36fbcf06a0eb) +++ tool_adapters/moodle/lams_tool_mdllesson/db/sql/drop_lams_tool_mdlLesson.sql (.../drop_lams_tool_mdlLesson.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,13 +1,13 @@ --- CVS ID: $Id$ - -SET FOREIGN_KEY_CHECKS=0; -DROP TABLE IF EXISTS tl_mdlesn10_user; -DROP TABLE IF EXISTS tl_mdlesn10_attachment; -DROP TABLE IF EXISTS tl_mdlesn10_session; -DROP TABLE IF EXISTS tl_mdlesn10_mdllesson; -SET FOREIGN_KEY_CHECKS=1; - - - - - +-- CVS ID: $Id$ + +SET FOREIGN_KEY_CHECKS=0; +DROP TABLE IF EXISTS tl_mdlesn10_user; +DROP TABLE IF EXISTS tl_mdlesn10_attachment; +DROP TABLE IF EXISTS tl_mdlesn10_session; +DROP TABLE IF EXISTS tl_mdlesn10_mdllesson; +SET FOREIGN_KEY_CHECKS=1; + + + + + Index: tool_adapters/moodle/lams_tool_mdllesson/db/sql/library_insert.sql =================================================================== diff -u -r1900d45594cf161971a48d0e596b36fbcf06a0eb -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdllesson/db/sql/library_insert.sql (.../library_insert.sql) (revision 1900d45594cf161971a48d0e596b36fbcf06a0eb) +++ tool_adapters/moodle/lams_tool_mdllesson/db/sql/library_insert.sql (.../library_insert.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,16 +1,16 @@ --- CVS ID: $Id$ - -INSERT INTO lams_learning_library -( -description, -title, -valid_flag, -create_date_time -) -VALUES -( -'MdlLesson Tool', -'MdlLesson', -0, -NOW() -) +-- CVS ID: $Id$ + +INSERT INTO lams_learning_library +( +description, +title, +valid_flag, +create_date_time +) +VALUES +( +'MdlLesson Tool', +'MdlLesson', +0, +NOW() +) Index: tool_adapters/moodle/lams_tool_mdllesson/db/sql/table-schema.sql =================================================================== diff -u -r1900d45594cf161971a48d0e596b36fbcf06a0eb -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdllesson/db/sql/table-schema.sql (.../table-schema.sql) (revision 1900d45594cf161971a48d0e596b36fbcf06a0eb) +++ tool_adapters/moodle/lams_tool_mdllesson/db/sql/table-schema.sql (.../table-schema.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,12 +1,12 @@ -alter table tl_mdlesn10_session drop foreign key FKBA4AC37B89669C81; -alter table tl_mdlesn10_user drop foreign key FK1B25DD0618E034DA; -drop table if exists tl_mdlesn10_configuration; -drop table if exists tl_mdlesn10_mdllesson; -drop table if exists tl_mdlesn10_session; -drop table if exists tl_mdlesn10_user; -create table tl_mdlesn10_configuration (uid bigint not null auto_increment, config_key varchar(30) unique, config_value varchar(255), primary key (uid)); -create table tl_mdlesn10_mdllesson (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)); -create table tl_mdlesn10_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), mdllesson_uid bigint, primary key (uid)); -create table tl_mdlesn10_user (uid bigint not null auto_increment, user_id bigint, last_name varchar(255), login_name varchar(255), first_name varchar(255), finishedActivity bit, mdllesson_session_uid bigint, entry_uid bigint, primary key (uid)); -alter table tl_mdlesn10_session add index FKBA4AC37B89669C81 (mdllesson_uid), add constraint FKBA4AC37B89669C81 foreign key (mdllesson_uid) references tl_mdlesn10_mdllesson (uid); -alter table tl_mdlesn10_user add index FK1B25DD0618E034DA (mdllesson_session_uid), add constraint FK1B25DD0618E034DA foreign key (mdllesson_session_uid) references tl_mdlesn10_session (uid); +alter table tl_mdlesn10_session drop foreign key FKBA4AC37B89669C81; +alter table tl_mdlesn10_user drop foreign key FK1B25DD0618E034DA; +drop table if exists tl_mdlesn10_configuration; +drop table if exists tl_mdlesn10_mdllesson; +drop table if exists tl_mdlesn10_session; +drop table if exists tl_mdlesn10_user; +create table tl_mdlesn10_configuration (uid bigint not null auto_increment, config_key varchar(30) unique, config_value varchar(255), primary key (uid)); +create table tl_mdlesn10_mdllesson (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)); +create table tl_mdlesn10_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), mdllesson_uid bigint, primary key (uid)); +create table tl_mdlesn10_user (uid bigint not null auto_increment, user_id bigint, last_name varchar(255), login_name varchar(255), first_name varchar(255), finishedActivity bit, mdllesson_session_uid bigint, entry_uid bigint, primary key (uid)); +alter table tl_mdlesn10_session add index FKBA4AC37B89669C81 (mdllesson_uid), add constraint FKBA4AC37B89669C81 foreign key (mdllesson_uid) references tl_mdlesn10_mdllesson (uid); +alter table tl_mdlesn10_user add index FK1B25DD0618E034DA (mdllesson_session_uid), add constraint FK1B25DD0618E034DA foreign key (mdllesson_session_uid) references tl_mdlesn10_session (uid); Index: tool_adapters/moodle/lams_tool_mdllesson/db/sql/tool_insert.sql =================================================================== diff -u -rb6544cfe682554653a9590c0bf74ed52186d71ff -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdllesson/db/sql/tool_insert.sql (.../tool_insert.sql) (revision b6544cfe682554653a9590c0bf74ed52186d71ff) +++ tool_adapters/moodle/lams_tool_mdllesson/db/sql/tool_insert.sql (.../tool_insert.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,64 +1,64 @@ --- CVS ID: $Id$ - -INSERT INTO lams_tool -( -tool_signature, -service_name, -tool_display_name, -description, -tool_identifier, -tool_version, -learning_library_id, -default_tool_content_id, -valid_flag, -grouping_support_type_id, -supports_run_offline_flag, -learner_url, -learner_preview_url, -learner_progress_url, -author_url, -monitor_url, -define_later_url, -export_pfolio_learner_url, -export_pfolio_class_url, -contribute_url, -moderation_url, -help_url, -admin_url, -language_file, -create_date_time, -modified_date_time, -ext_lms_id, -supports_outputs -) -VALUES -( -'mdlesn10', -'mdlLessonService', -'MdlLesson', -'MdlLesson', -'mdlLesson', -'@tool_version@', -NULL, -NULL, -0, -2, -1, -'tool/mdlesn10/learning.do?mode=learner', -'tool/mdlesn10/learning.do?mode=author', -'tool/mdlesn10/learning.do?mode=teacher', -'tool/mdlesn10/authoring.do', -'tool/mdlesn10/monitoring.do', -'tool/mdlesn10/authoring.do?mode=teacher', -'tool/mdlesn10/exportPortfolio?mode=learner', -'tool/mdlesn10/exportPortfolio?mode=teacher', -'tool/mdlesn10/contribute.do', -'tool/mdlesn10/moderate.do', -'http://wiki.lamsfoundation.org/display/lamsdocs/mdlesn10', -'tool/mdlesn10/mdlesn10admin.do', -'org.lamsfoundation.lams.tool.mdlesn.ApplicationResources', -NOW(), -NOW(), -'moodle', -true -) +-- CVS ID: $Id$ + +INSERT INTO lams_tool +( +tool_signature, +service_name, +tool_display_name, +description, +tool_identifier, +tool_version, +learning_library_id, +default_tool_content_id, +valid_flag, +grouping_support_type_id, +supports_run_offline_flag, +learner_url, +learner_preview_url, +learner_progress_url, +author_url, +monitor_url, +define_later_url, +export_pfolio_learner_url, +export_pfolio_class_url, +contribute_url, +moderation_url, +help_url, +admin_url, +language_file, +create_date_time, +modified_date_time, +ext_lms_id, +supports_outputs +) +VALUES +( +'mdlesn10', +'mdlLessonService', +'MdlLesson', +'MdlLesson', +'mdlLesson', +'@tool_version@', +NULL, +NULL, +0, +2, +1, +'tool/mdlesn10/learning.do?mode=learner', +'tool/mdlesn10/learning.do?mode=author', +'tool/mdlesn10/learning.do?mode=teacher', +'tool/mdlesn10/authoring.do', +'tool/mdlesn10/monitoring.do', +'tool/mdlesn10/authoring.do?mode=teacher', +'tool/mdlesn10/exportPortfolio?mode=learner', +'tool/mdlesn10/exportPortfolio?mode=teacher', +'tool/mdlesn10/contribute.do', +'tool/mdlesn10/moderate.do', +'http://wiki.lamsfoundation.org/display/lamsdocs/mdlesn10', +'tool/mdlesn10/mdlesn10admin.do', +'org.lamsfoundation.lams.tool.mdlesn.ApplicationResources', +NOW(), +NOW(), +'moodle', +true +) Index: tool_adapters/moodle/lams_tool_mdlscorm/db/sql/activity_insert.sql =================================================================== diff -u -r968652e19244d6d982a0c82df6c6d464d2edbec4 -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdlscorm/db/sql/activity_insert.sql (.../activity_insert.sql) (revision 968652e19244d6d982a0c82df6c6d464d2edbec4) +++ tool_adapters/moodle/lams_tool_mdlscorm/db/sql/activity_insert.sql (.../activity_insert.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,80 +1,80 @@ --- CVS ID: $Id$ - -INSERT INTO lams_learning_activity -( -activity_ui_id -, description -, title -, help_text -, xcoord -, ycoord -, parent_activity_id -, parent_ui_id -, learning_activity_type_id -, grouping_support_type_id -, apply_grouping_flag -, grouping_id -, grouping_ui_id -, order_id -, define_later_flag -, learning_design_id -, learning_library_id -, create_date_time -, run_offline_flag -, max_number_of_options -, min_number_of_options -, options_instructions -, tool_id -, tool_content_id -, activity_category_id -, gate_activity_level_id -, gate_open_flag -, gate_start_time_offset -, gate_end_time_offset -, gate_start_date_time -, gate_end_date_time -, library_activity_ui_image -, create_grouping_id -, create_grouping_ui_id -, library_activity_id -, language_file -) -VALUES -( -NULL -, 'Moodle Scorm Tool' -, 'Moodle Scorm Tool' -, 'Moodle Scorm Tool.' -, NULL -, NULL -, NULL -, NULL -, 1 -, 2 -, 0 -, NULL -, NULL -, NULL -, 0 -, NULL -, ${learning_library_id} -, NOW() -, 0 -, NULL -, NULL -, NULL -, ${tool_id} -, NULL -, 6 -, NULL -, NULL -, NULL -, NULL -, NULL -, NULL -, 'tool/mdscrm10/images/icon_mdlScorm.swf' -, NULL -, NULL -, NULL -, 'org.lamsfoundation.lams.tool.mdscrm.ApplicationResources' -) +-- CVS ID: $Id$ + +INSERT INTO lams_learning_activity +( +activity_ui_id +, description +, title +, help_text +, xcoord +, ycoord +, parent_activity_id +, parent_ui_id +, learning_activity_type_id +, grouping_support_type_id +, apply_grouping_flag +, grouping_id +, grouping_ui_id +, order_id +, define_later_flag +, learning_design_id +, learning_library_id +, create_date_time +, run_offline_flag +, max_number_of_options +, min_number_of_options +, options_instructions +, tool_id +, tool_content_id +, activity_category_id +, gate_activity_level_id +, gate_open_flag +, gate_start_time_offset +, gate_end_time_offset +, gate_start_date_time +, gate_end_date_time +, library_activity_ui_image +, create_grouping_id +, create_grouping_ui_id +, library_activity_id +, language_file +) +VALUES +( +NULL +, 'Moodle Scorm Tool' +, 'Moodle Scorm Tool' +, 'Moodle Scorm Tool.' +, NULL +, NULL +, NULL +, NULL +, 1 +, 2 +, 0 +, NULL +, NULL +, NULL +, 0 +, NULL +, ${learning_library_id} +, NOW() +, 0 +, NULL +, NULL +, NULL +, ${tool_id} +, NULL +, 6 +, NULL +, NULL +, NULL +, NULL +, NULL +, NULL +, 'tool/mdscrm10/images/icon_mdlScorm.swf' +, NULL +, NULL +, NULL +, 'org.lamsfoundation.lams.tool.mdscrm.ApplicationResources' +) Index: tool_adapters/moodle/lams_tool_mdlscorm/db/sql/create_lams_tool_mdlScorm.sql =================================================================== diff -u -rb496c494338c07b9cb4c9b92c89696d72d5d895c -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdlscorm/db/sql/create_lams_tool_mdlScorm.sql (.../create_lams_tool_mdlScorm.sql) (revision b496c494338c07b9cb4c9b92c89696d72d5d895c) +++ tool_adapters/moodle/lams_tool_mdlscorm/db/sql/create_lams_tool_mdlScorm.sql (.../create_lams_tool_mdlScorm.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,29 +1,29 @@ --- CVS ID: $Id$ - -SET FOREIGN_KEY_CHECKS=0; -drop table if exists tl_mdscrm10_mdlscorm; -drop table if exists tl_mdscrm10_session; -drop table if exists tl_mdscrm10_user; -create table tl_mdscrm10_mdlscorm (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_lms_id varchar(255), ext_course_id varchar(255), ext_section varchar(255), primary key (uid))TYPE=InnoDB; -create table tl_mdscrm10_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), mdlscorm_uid bigint, primary key (uid))TYPE=InnoDB; -create table tl_mdscrm10_user (uid bigint not null auto_increment, user_id bigint, last_name varchar(255), login_name varchar(255), first_name varchar(255), finishedActivity bit, mdlscorm_session_uid bigint, entry_uid bigint, primary key (uid))TYPE=InnoDB; -alter table tl_mdscrm10_session add index FKFKmdscrm10_session (mdlScorm_uid), add constraint FKmdscrm10_session foreign key (mdlScorm_uid) references tl_mdscrm10_mdlscorm (uid); -alter table tl_mdscrm10_user add index FKmdscrm10_user (mdlscorm_session_uid), add constraint FKmdscrm10_user foreign key (mdlscorm_session_uid) references tl_mdscrm10_session (uid); - - -INSERT INTO tl_mdscrm10_mdlscorm ( - 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_mdscrm10_mdlscorm; +drop table if exists tl_mdscrm10_session; +drop table if exists tl_mdscrm10_user; +create table tl_mdscrm10_mdlscorm (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_lms_id varchar(255), ext_course_id varchar(255), ext_section varchar(255), primary key (uid))TYPE=InnoDB; +create table tl_mdscrm10_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), mdlscorm_uid bigint, primary key (uid))TYPE=InnoDB; +create table tl_mdscrm10_user (uid bigint not null auto_increment, user_id bigint, last_name varchar(255), login_name varchar(255), first_name varchar(255), finishedActivity bit, mdlscorm_session_uid bigint, entry_uid bigint, primary key (uid))TYPE=InnoDB; +alter table tl_mdscrm10_session add index FKFKmdscrm10_session (mdlScorm_uid), add constraint FKmdscrm10_session foreign key (mdlScorm_uid) references tl_mdscrm10_mdlscorm (uid); +alter table tl_mdscrm10_user add index FKmdscrm10_user (mdlscorm_session_uid), add constraint FKmdscrm10_user foreign key (mdlscorm_session_uid) references tl_mdscrm10_session (uid); + + +INSERT INTO tl_mdscrm10_mdlscorm ( + 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; Index: tool_adapters/moodle/lams_tool_mdlscorm/db/sql/drop_lams_tool_mdlScorm.sql =================================================================== diff -u -r968652e19244d6d982a0c82df6c6d464d2edbec4 -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdlscorm/db/sql/drop_lams_tool_mdlScorm.sql (.../drop_lams_tool_mdlScorm.sql) (revision 968652e19244d6d982a0c82df6c6d464d2edbec4) +++ tool_adapters/moodle/lams_tool_mdlscorm/db/sql/drop_lams_tool_mdlScorm.sql (.../drop_lams_tool_mdlScorm.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,13 +1,13 @@ --- CVS ID: $Id$ - -SET FOREIGN_KEY_CHECKS=0; -DROP TABLE IF EXISTS tl_mdscrm10_user; -DROP TABLE IF EXISTS tl_mdscrm10_attachment; -DROP TABLE IF EXISTS tl_mdscrm10_session; -DROP TABLE IF EXISTS tl_mdscrm10_mdlscorm; -SET FOREIGN_KEY_CHECKS=1; - - - - - +-- CVS ID: $Id$ + +SET FOREIGN_KEY_CHECKS=0; +DROP TABLE IF EXISTS tl_mdscrm10_user; +DROP TABLE IF EXISTS tl_mdscrm10_attachment; +DROP TABLE IF EXISTS tl_mdscrm10_session; +DROP TABLE IF EXISTS tl_mdscrm10_mdlscorm; +SET FOREIGN_KEY_CHECKS=1; + + + + + Index: tool_adapters/moodle/lams_tool_mdlscorm/db/sql/library_insert.sql =================================================================== diff -u -r968652e19244d6d982a0c82df6c6d464d2edbec4 -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdlscorm/db/sql/library_insert.sql (.../library_insert.sql) (revision 968652e19244d6d982a0c82df6c6d464d2edbec4) +++ tool_adapters/moodle/lams_tool_mdlscorm/db/sql/library_insert.sql (.../library_insert.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,16 +1,16 @@ --- CVS ID: $Id$ - -INSERT INTO lams_learning_library -( -description, -title, -valid_flag, -create_date_time -) -VALUES -( -'MdlScorm Tool', -'MdlScorm', -0, -NOW() -) +-- CVS ID: $Id$ + +INSERT INTO lams_learning_library +( +description, +title, +valid_flag, +create_date_time +) +VALUES +( +'MdlScorm Tool', +'MdlScorm', +0, +NOW() +) Index: tool_adapters/moodle/lams_tool_mdlscorm/db/sql/table-schema.sql =================================================================== diff -u -r968652e19244d6d982a0c82df6c6d464d2edbec4 -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdlscorm/db/sql/table-schema.sql (.../table-schema.sql) (revision 968652e19244d6d982a0c82df6c6d464d2edbec4) +++ tool_adapters/moodle/lams_tool_mdlscorm/db/sql/table-schema.sql (.../table-schema.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,12 +1,12 @@ -alter table tl_mdscrm10_session drop foreign key FKE2A598184D07F6E8; -alter table tl_mdscrm10_user drop foreign key FK108B9589C7050F3F; -drop table if exists tl_mdscrm10_configuration; -drop table if exists tl_mdscrm10_mdlscorm; -drop table if exists tl_mdscrm10_session; -drop table if exists tl_mdscrm10_user; -create table tl_mdscrm10_configuration (uid bigint not null auto_increment, config_key varchar(30) unique, config_value varchar(255), primary key (uid)); -create table tl_mdscrm10_mdlscorm (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)); -create table tl_mdscrm10_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), mdlScorm_uid bigint, primary key (uid)); -create table tl_mdscrm10_user (uid bigint not null auto_increment, user_id bigint, last_name varchar(255), login_name varchar(255), first_name varchar(255), finishedActivity bit, mdlscorm_session_uid bigint, entry_uid bigint, primary key (uid)); -alter table tl_mdscrm10_session add index FKE2A598184D07F6E8 (mdlScorm_uid), add constraint FKE2A598184D07F6E8 foreign key (mdlScorm_uid) references tl_mdscrm10_mdlscorm (uid); -alter table tl_mdscrm10_user add index FK108B9589C7050F3F (mdlscorm_session_uid), add constraint FK108B9589C7050F3F foreign key (mdlscorm_session_uid) references tl_mdscrm10_session (uid); +alter table tl_mdscrm10_session drop foreign key FKE2A598184D07F6E8; +alter table tl_mdscrm10_user drop foreign key FK108B9589C7050F3F; +drop table if exists tl_mdscrm10_configuration; +drop table if exists tl_mdscrm10_mdlscorm; +drop table if exists tl_mdscrm10_session; +drop table if exists tl_mdscrm10_user; +create table tl_mdscrm10_configuration (uid bigint not null auto_increment, config_key varchar(30) unique, config_value varchar(255), primary key (uid)); +create table tl_mdscrm10_mdlscorm (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)); +create table tl_mdscrm10_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), mdlScorm_uid bigint, primary key (uid)); +create table tl_mdscrm10_user (uid bigint not null auto_increment, user_id bigint, last_name varchar(255), login_name varchar(255), first_name varchar(255), finishedActivity bit, mdlscorm_session_uid bigint, entry_uid bigint, primary key (uid)); +alter table tl_mdscrm10_session add index FKE2A598184D07F6E8 (mdlScorm_uid), add constraint FKE2A598184D07F6E8 foreign key (mdlScorm_uid) references tl_mdscrm10_mdlscorm (uid); +alter table tl_mdscrm10_user add index FK108B9589C7050F3F (mdlscorm_session_uid), add constraint FK108B9589C7050F3F foreign key (mdlscorm_session_uid) references tl_mdscrm10_session (uid); Index: tool_adapters/moodle/lams_tool_mdlscorm/db/sql/tool_insert.sql =================================================================== diff -u -rb6544cfe682554653a9590c0bf74ed52186d71ff -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdlscorm/db/sql/tool_insert.sql (.../tool_insert.sql) (revision b6544cfe682554653a9590c0bf74ed52186d71ff) +++ tool_adapters/moodle/lams_tool_mdlscorm/db/sql/tool_insert.sql (.../tool_insert.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,64 +1,64 @@ --- CVS ID: $Id$ - -INSERT INTO lams_tool -( -tool_signature, -service_name, -tool_display_name, -description, -tool_identifier, -tool_version, -learning_library_id, -default_tool_content_id, -valid_flag, -grouping_support_type_id, -supports_run_offline_flag, -learner_url, -learner_preview_url, -learner_progress_url, -author_url, -monitor_url, -define_later_url, -export_pfolio_learner_url, -export_pfolio_class_url, -contribute_url, -moderation_url, -help_url, -admin_url, -language_file, -create_date_time, -modified_date_time, -ext_lms_id, -supports_outputs -) -VALUES -( -'mdscrm10', -'mdlScormService', -'MdlScorm', -'MdlScorm', -'mdlScorm', -'@tool_version@', -NULL, -NULL, -0, -2, -1, -'tool/mdscrm10/learning.do?mode=learner', -'tool/mdscrm10/learning.do?mode=author', -'tool/mdscrm10/learning.do?mode=teacher', -'tool/mdscrm10/authoring.do', -'tool/mdscrm10/monitoring.do', -'tool/mdscrm10/authoring.do?mode=teacher', -'tool/mdscrm10/exportPortfolio?mode=learner', -'tool/mdscrm10/exportPortfolio?mode=teacher', -'tool/mdscrm10/contribute.do', -'tool/mdscrm10/moderate.do', -'http://wiki.lamsfoundation.org/display/lamsdocs/mdscrm10', -'tool/mdscrm10/mdscrm10admin.do', -'org.lamsfoundation.lams.tool.mdscrm.ApplicationResources', -NOW(), -NOW(), -'moodle', -true -) +-- CVS ID: $Id$ + +INSERT INTO lams_tool +( +tool_signature, +service_name, +tool_display_name, +description, +tool_identifier, +tool_version, +learning_library_id, +default_tool_content_id, +valid_flag, +grouping_support_type_id, +supports_run_offline_flag, +learner_url, +learner_preview_url, +learner_progress_url, +author_url, +monitor_url, +define_later_url, +export_pfolio_learner_url, +export_pfolio_class_url, +contribute_url, +moderation_url, +help_url, +admin_url, +language_file, +create_date_time, +modified_date_time, +ext_lms_id, +supports_outputs +) +VALUES +( +'mdscrm10', +'mdlScormService', +'MdlScorm', +'MdlScorm', +'mdlScorm', +'@tool_version@', +NULL, +NULL, +0, +2, +1, +'tool/mdscrm10/learning.do?mode=learner', +'tool/mdscrm10/learning.do?mode=author', +'tool/mdscrm10/learning.do?mode=teacher', +'tool/mdscrm10/authoring.do', +'tool/mdscrm10/monitoring.do', +'tool/mdscrm10/authoring.do?mode=teacher', +'tool/mdscrm10/exportPortfolio?mode=learner', +'tool/mdscrm10/exportPortfolio?mode=teacher', +'tool/mdscrm10/contribute.do', +'tool/mdscrm10/moderate.do', +'http://wiki.lamsfoundation.org/display/lamsdocs/mdscrm10', +'tool/mdscrm10/mdscrm10admin.do', +'org.lamsfoundation.lams.tool.mdscrm.ApplicationResources', +NOW(), +NOW(), +'moodle', +true +) Index: tool_adapters/moodle/lams_tool_mdlwiki/db/sql/activity_insert.sql =================================================================== diff -u -r086d0769471647a32761d96d5fb630b4787880d1 -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdlwiki/db/sql/activity_insert.sql (.../activity_insert.sql) (revision 086d0769471647a32761d96d5fb630b4787880d1) +++ tool_adapters/moodle/lams_tool_mdlwiki/db/sql/activity_insert.sql (.../activity_insert.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,80 +1,80 @@ --- CVS ID: $Id$ - -INSERT INTO lams_learning_activity -( -activity_ui_id -, description -, title -, help_text -, xcoord -, ycoord -, parent_activity_id -, parent_ui_id -, learning_activity_type_id -, grouping_support_type_id -, apply_grouping_flag -, grouping_id -, grouping_ui_id -, order_id -, define_later_flag -, learning_design_id -, learning_library_id -, create_date_time -, run_offline_flag -, max_number_of_options -, min_number_of_options -, options_instructions -, tool_id -, tool_content_id -, activity_category_id -, gate_activity_level_id -, gate_open_flag -, gate_start_time_offset -, gate_end_time_offset -, gate_start_date_time -, gate_end_date_time -, library_activity_ui_image -, create_grouping_id -, create_grouping_ui_id -, library_activity_id -, language_file -) -VALUES -( -NULL -, 'Moodle Wiki Tool' -, 'Moodle Wiki Tool' -, 'Moodle Wiki Tool.' -, NULL -, NULL -, NULL -, NULL -, 1 -, 2 -, 0 -, NULL -, NULL -, NULL -, 0 -, NULL -, ${learning_library_id} -, NOW() -, 0 -, NULL -, NULL -, NULL -, ${tool_id} -, NULL -, 6 -, NULL -, NULL -, NULL -, NULL -, NULL -, NULL -, 'tool/mdwiki10/images/icon_mdlWiki.swf' -, NULL -, NULL -, NULL -, 'org.lamsfoundation.lams.tool.mdwiki.ApplicationResources' -) +-- CVS ID: $Id$ + +INSERT INTO lams_learning_activity +( +activity_ui_id +, description +, title +, help_text +, xcoord +, ycoord +, parent_activity_id +, parent_ui_id +, learning_activity_type_id +, grouping_support_type_id +, apply_grouping_flag +, grouping_id +, grouping_ui_id +, order_id +, define_later_flag +, learning_design_id +, learning_library_id +, create_date_time +, run_offline_flag +, max_number_of_options +, min_number_of_options +, options_instructions +, tool_id +, tool_content_id +, activity_category_id +, gate_activity_level_id +, gate_open_flag +, gate_start_time_offset +, gate_end_time_offset +, gate_start_date_time +, gate_end_date_time +, library_activity_ui_image +, create_grouping_id +, create_grouping_ui_id +, library_activity_id +, language_file +) +VALUES +( +NULL +, 'Moodle Wiki Tool' +, 'Moodle Wiki Tool' +, 'Moodle Wiki Tool.' +, NULL +, NULL +, NULL +, NULL +, 1 +, 2 +, 0 +, NULL +, NULL +, NULL +, 0 +, NULL +, ${learning_library_id} +, NOW() +, 0 +, NULL +, NULL +, NULL +, ${tool_id} +, NULL +, 6 +, NULL +, NULL +, NULL +, NULL +, NULL +, NULL +, 'tool/mdwiki10/images/icon_mdlWiki.swf' +, NULL +, NULL +, NULL +, 'org.lamsfoundation.lams.tool.mdwiki.ApplicationResources' +) Index: tool_adapters/moodle/lams_tool_mdlwiki/db/sql/create_lams_tool_mdlWiki.sql =================================================================== diff -u -r106d3a2ed1f8ca0a9c507031af82a49f9ac02130 -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdlwiki/db/sql/create_lams_tool_mdlWiki.sql (.../create_lams_tool_mdlWiki.sql) (revision 106d3a2ed1f8ca0a9c507031af82a49f9ac02130) +++ tool_adapters/moodle/lams_tool_mdlwiki/db/sql/create_lams_tool_mdlWiki.sql (.../create_lams_tool_mdlWiki.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,28 +1,28 @@ --- CVS ID: $Id$ - -SET FOREIGN_KEY_CHECKS=0; -drop table if exists tl_mdwiki10_mdlwiki; -drop table if exists tl_mdwiki10_session; -drop table if exists tl_mdwiki10_user; -create table tl_mdwiki10_mdlwiki (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_lms_id varchar(255), ext_course_id varchar(255), ext_section varchar(255), primary key (uid))TYPE=InnoDB; -create table tl_mdwiki10_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), mdlWiki_uid bigint, primary key (uid))TYPE=InnoDB; -create table tl_mdwiki10_user (uid bigint not null auto_increment, user_id bigint, last_name varchar(255), login_name varchar(255), first_name varchar(255), finishedActivity bit, mdlwiki_session_uid bigint, entry_uid bigint, primary key (uid))TYPE=InnoDB; -alter table tl_mdwiki10_session add index FKmdwiki10_session (mdlWiki_uid), add constraint FKmdwiki10_session foreign key (mdlWiki_uid) references tl_mdwiki10_mdlwiki (uid); -alter table tl_mdwiki10_user add index FKmdwiki10_user (mdlwiki_session_uid), add constraint FKmdwiki10_user foreign key (mdlwiki_session_uid) references tl_mdwiki10_session (uid); - -INSERT INTO tl_mdwiki10_mdlwiki ( - 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_mdwiki10_mdlwiki; +drop table if exists tl_mdwiki10_session; +drop table if exists tl_mdwiki10_user; +create table tl_mdwiki10_mdlwiki (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_lms_id varchar(255), ext_course_id varchar(255), ext_section varchar(255), primary key (uid))TYPE=InnoDB; +create table tl_mdwiki10_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), mdlWiki_uid bigint, primary key (uid))TYPE=InnoDB; +create table tl_mdwiki10_user (uid bigint not null auto_increment, user_id bigint, last_name varchar(255), login_name varchar(255), first_name varchar(255), finishedActivity bit, mdlwiki_session_uid bigint, entry_uid bigint, primary key (uid))TYPE=InnoDB; +alter table tl_mdwiki10_session add index FKmdwiki10_session (mdlWiki_uid), add constraint FKmdwiki10_session foreign key (mdlWiki_uid) references tl_mdwiki10_mdlwiki (uid); +alter table tl_mdwiki10_user add index FKmdwiki10_user (mdlwiki_session_uid), add constraint FKmdwiki10_user foreign key (mdlwiki_session_uid) references tl_mdwiki10_session (uid); + +INSERT INTO tl_mdwiki10_mdlwiki ( + 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; Index: tool_adapters/moodle/lams_tool_mdlwiki/db/sql/drop_lams_tool_mdlWiki.sql =================================================================== diff -u -r086d0769471647a32761d96d5fb630b4787880d1 -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdlwiki/db/sql/drop_lams_tool_mdlWiki.sql (.../drop_lams_tool_mdlWiki.sql) (revision 086d0769471647a32761d96d5fb630b4787880d1) +++ tool_adapters/moodle/lams_tool_mdlwiki/db/sql/drop_lams_tool_mdlWiki.sql (.../drop_lams_tool_mdlWiki.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,13 +1,13 @@ --- CVS ID: $Id$ - -SET FOREIGN_KEY_CHECKS=0; -DROP TABLE IF EXISTS tl_mdwiki10_user; -DROP TABLE IF EXISTS tl_mdwiki10_attachment; -DROP TABLE IF EXISTS tl_mdwiki10_session; -DROP TABLE IF EXISTS tl_mdwiki10_mdlwiki; -SET FOREIGN_KEY_CHECKS=1; - - - - - +-- CVS ID: $Id$ + +SET FOREIGN_KEY_CHECKS=0; +DROP TABLE IF EXISTS tl_mdwiki10_user; +DROP TABLE IF EXISTS tl_mdwiki10_attachment; +DROP TABLE IF EXISTS tl_mdwiki10_session; +DROP TABLE IF EXISTS tl_mdwiki10_mdlwiki; +SET FOREIGN_KEY_CHECKS=1; + + + + + Index: tool_adapters/moodle/lams_tool_mdlwiki/db/sql/library_insert.sql =================================================================== diff -u -r086d0769471647a32761d96d5fb630b4787880d1 -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdlwiki/db/sql/library_insert.sql (.../library_insert.sql) (revision 086d0769471647a32761d96d5fb630b4787880d1) +++ tool_adapters/moodle/lams_tool_mdlwiki/db/sql/library_insert.sql (.../library_insert.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,16 +1,16 @@ --- CVS ID: $Id$ - -INSERT INTO lams_learning_library -( -description, -title, -valid_flag, -create_date_time -) -VALUES -( -'MdlWiki Tool', -'MdlWiki', -0, -NOW() -) +-- CVS ID: $Id$ + +INSERT INTO lams_learning_library +( +description, +title, +valid_flag, +create_date_time +) +VALUES +( +'MdlWiki Tool', +'MdlWiki', +0, +NOW() +) Index: tool_adapters/moodle/lams_tool_mdlwiki/db/sql/table-schema.sql =================================================================== diff -u -r086d0769471647a32761d96d5fb630b4787880d1 -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdlwiki/db/sql/table-schema.sql (.../table-schema.sql) (revision 086d0769471647a32761d96d5fb630b4787880d1) +++ tool_adapters/moodle/lams_tool_mdlwiki/db/sql/table-schema.sql (.../table-schema.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,12 +1,12 @@ -alter table tl_mdwiki10_session drop foreign key FK95FFA8C9AE31EDB7; -alter table tl_mdwiki10_user drop foreign key FKA675AA78DC83E94C; -drop table if exists tl_mdwiki10_configuration; -drop table if exists tl_mdwiki10_mdlwiki; -drop table if exists tl_mdwiki10_session; -drop table if exists tl_mdwiki10_user; -create table tl_mdwiki10_configuration (uid bigint not null auto_increment, config_key varchar(30) unique, config_value varchar(255), primary key (uid)); -create table tl_mdwiki10_mdlwiki (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)); -create table tl_mdwiki10_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), mdlWiki_uid bigint, primary key (uid)); -create table tl_mdwiki10_user (uid bigint not null auto_increment, user_id bigint, last_name varchar(255), login_name varchar(255), first_name varchar(255), finishedActivity bit, mdlwiki_session_uid bigint, entry_uid bigint, primary key (uid)); -alter table tl_mdwiki10_session add index FK95FFA8C9AE31EDB7 (mdlWiki_uid), add constraint FK95FFA8C9AE31EDB7 foreign key (mdlWiki_uid) references tl_mdwiki10_mdlwiki (uid); -alter table tl_mdwiki10_user add index FKA675AA78DC83E94C (mdlwiki_session_uid), add constraint FKA675AA78DC83E94C foreign key (mdlwiki_session_uid) references tl_mdwiki10_session (uid); +alter table tl_mdwiki10_session drop foreign key FK95FFA8C9AE31EDB7; +alter table tl_mdwiki10_user drop foreign key FKA675AA78DC83E94C; +drop table if exists tl_mdwiki10_configuration; +drop table if exists tl_mdwiki10_mdlwiki; +drop table if exists tl_mdwiki10_session; +drop table if exists tl_mdwiki10_user; +create table tl_mdwiki10_configuration (uid bigint not null auto_increment, config_key varchar(30) unique, config_value varchar(255), primary key (uid)); +create table tl_mdwiki10_mdlwiki (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)); +create table tl_mdwiki10_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), mdlWiki_uid bigint, primary key (uid)); +create table tl_mdwiki10_user (uid bigint not null auto_increment, user_id bigint, last_name varchar(255), login_name varchar(255), first_name varchar(255), finishedActivity bit, mdlwiki_session_uid bigint, entry_uid bigint, primary key (uid)); +alter table tl_mdwiki10_session add index FK95FFA8C9AE31EDB7 (mdlWiki_uid), add constraint FK95FFA8C9AE31EDB7 foreign key (mdlWiki_uid) references tl_mdwiki10_mdlwiki (uid); +alter table tl_mdwiki10_user add index FKA675AA78DC83E94C (mdlwiki_session_uid), add constraint FKA675AA78DC83E94C foreign key (mdlwiki_session_uid) references tl_mdwiki10_session (uid); Index: tool_adapters/moodle/lams_tool_mdlwiki/db/sql/tool_insert.sql =================================================================== diff -u -rb6544cfe682554653a9590c0bf74ed52186d71ff -rae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e --- tool_adapters/moodle/lams_tool_mdlwiki/db/sql/tool_insert.sql (.../tool_insert.sql) (revision b6544cfe682554653a9590c0bf74ed52186d71ff) +++ tool_adapters/moodle/lams_tool_mdlwiki/db/sql/tool_insert.sql (.../tool_insert.sql) (revision ae37d70e3f57f05fd394d2dbdab4232c2d3dbc3e) @@ -1,64 +1,64 @@ --- CVS ID: $Id$ - -INSERT INTO lams_tool -( -tool_signature, -service_name, -tool_display_name, -description, -tool_identifier, -tool_version, -learning_library_id, -default_tool_content_id, -valid_flag, -grouping_support_type_id, -supports_run_offline_flag, -learner_url, -learner_preview_url, -learner_progress_url, -author_url, -monitor_url, -define_later_url, -export_pfolio_learner_url, -export_pfolio_class_url, -contribute_url, -moderation_url, -help_url, -admin_url, -language_file, -create_date_time, -modified_date_time, -ext_lms_id, -supports_outputs -) -VALUES -( -'mdwiki10', -'mdlWikiService', -'MdlWiki', -'MdlWiki', -'mdlWiki', -'@tool_version@', -NULL, -NULL, -0, -2, -1, -'tool/mdwiki10/learning.do?mode=learner', -'tool/mdwiki10/learning.do?mode=author', -'tool/mdwiki10/learning.do?mode=teacher', -'tool/mdwiki10/authoring.do', -'tool/mdwiki10/monitoring.do', -'tool/mdwiki10/authoring.do?mode=teacher', -'tool/mdwiki10/exportPortfolio?mode=learner', -'tool/mdwiki10/exportPortfolio?mode=teacher', -'tool/mdwiki10/contribute.do', -'tool/mdwiki10/moderate.do', -'http://wiki.lamsfoundation.org/display/lamsdocs/mdwiki10', -'tool/mdwiki10/mdwiki10admin.do', -'org.lamsfoundation.lams.tool.mdwiki.ApplicationResources', -NOW(), -NOW(), -'moodle', -true -) +-- CVS ID: $Id$ + +INSERT INTO lams_tool +( +tool_signature, +service_name, +tool_display_name, +description, +tool_identifier, +tool_version, +learning_library_id, +default_tool_content_id, +valid_flag, +grouping_support_type_id, +supports_run_offline_flag, +learner_url, +learner_preview_url, +learner_progress_url, +author_url, +monitor_url, +define_later_url, +export_pfolio_learner_url, +export_pfolio_class_url, +contribute_url, +moderation_url, +help_url, +admin_url, +language_file, +create_date_time, +modified_date_time, +ext_lms_id, +supports_outputs +) +VALUES +( +'mdwiki10', +'mdlWikiService', +'MdlWiki', +'MdlWiki', +'mdlWiki', +'@tool_version@', +NULL, +NULL, +0, +2, +1, +'tool/mdwiki10/learning.do?mode=learner', +'tool/mdwiki10/learning.do?mode=author', +'tool/mdwiki10/learning.do?mode=teacher', +'tool/mdwiki10/authoring.do', +'tool/mdwiki10/monitoring.do', +'tool/mdwiki10/authoring.do?mode=teacher', +'tool/mdwiki10/exportPortfolio?mode=learner', +'tool/mdwiki10/exportPortfolio?mode=teacher', +'tool/mdwiki10/contribute.do', +'tool/mdwiki10/moderate.do', +'http://wiki.lamsfoundation.org/display/lamsdocs/mdwiki10', +'tool/mdwiki10/mdwiki10admin.do', +'org.lamsfoundation.lams.tool.mdwiki.ApplicationResources', +NOW(), +NOW(), +'moodle', +true +)