Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20180425.sql =================================================================== diff -u --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20180425.sql (revision 0) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20180425.sql (revision b91cd3c97761ce67a4bd1a81f6734769dfc760e6) @@ -0,0 +1,35 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +----------------------Put all sql statements below here------------------------- + +-- LDEV-4558 Increase db text size for all user inputs +ALTER TABLE lams_comment MODIFY body MEDIUMTEXT; +ALTER TABLE lams_competence MODIFY description MEDIUMTEXT; +ALTER TABLE lams_email_notification_archive MODIFY body MEDIUMTEXT; +ALTER TABLE lams_ext_server_org_map MODIFY serverdesc MEDIUMTEXT; +ALTER TABLE lams_gradebook_user_activity MODIFY feedback MEDIUMTEXT; +ALTER TABLE lams_gradebook_user_activity_archive MODIFY feedback MEDIUMTEXT; +ALTER TABLE lams_gradebook_user_lesson_archive MODIFY feedback MEDIUMTEXT; +ALTER TABLE lams_learning_activity MODIFY description MEDIUMTEXT; +ALTER TABLE lams_learning_activity MODIFY options_instructions MEDIUMTEXT; +ALTER TABLE lams_learning_design MODIFY description MEDIUMTEXT; +ALTER TABLE lams_learning_design MODIFY help_text MEDIUMTEXT; +ALTER TABLE lams_learning_design MODIFY license_TEXT MEDIUMTEXT; +ALTER TABLE lams_learning_library MODIFY description MEDIUMTEXT; +ALTER TABLE lams_learning_transition MODIFY description MEDIUMTEXT; +ALTER TABLE lams_lesson MODIFY description MEDIUMTEXT; +ALTER TABLE lams_notebook_entry MODIFY entry MEDIUMTEXT; +ALTER TABLE lams_notification_event MODIFY message MEDIUMTEXT; +ALTER TABLE lams_notification_subscription MODIFY last_operation_message MEDIUMTEXT; +ALTER TABLE lams_organisation MODIFY description MEDIUMTEXT; +ALTER TABLE lams_planner_nodes MODIFY brief_desc MEDIUMTEXT; +ALTER TABLE lams_planner_nodes MODIFY full_desc MEDIUMTEXT; +ALTER TABLE lams_rating_comment MODIFY comment MEDIUMTEXT; + +----------------------Put all sql statements above here------------------------- + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Fisheye: Tag b91cd3c97761ce67a4bd1a81f6734769dfc760e6 refers to a dead (removed) revision in file `lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20180525.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20180425.sql =================================================================== diff -u --- lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20180425.sql (revision 0) +++ lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20180425.sql (revision b91cd3c97761ce67a4bd1a81f6734769dfc760e6) @@ -0,0 +1,26 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +----------------------Put all sql statements below here------------------------- + +-- LDEV-4558 Increase db text size for all user inputs +ALTER TABLE tl_laasse10_assessment MODIFY instructions MEDIUMTEXT; +ALTER TABLE tl_laasse10_assessment MODIFY reflect_instructions MEDIUMTEXT; +ALTER TABLE tl_laasse10_assessment_overall_feedback MODIFY feedback MEDIUMTEXT; +ALTER TABLE tl_laasse10_assessment_question MODIFY question MEDIUMTEXT; +ALTER TABLE tl_laasse10_assessment_question MODIFY general_feedback MEDIUMTEXT; +ALTER TABLE tl_laasse10_assessment_question MODIFY feedback MEDIUMTEXT; +ALTER TABLE tl_laasse10_assessment_question MODIFY feedback_on_correct MEDIUMTEXT; +ALTER TABLE tl_laasse10_assessment_question MODIFY feedback_on_partially_correct MEDIUMTEXT; +ALTER TABLE tl_laasse10_assessment_question MODIFY feedback_on_incorrect MEDIUMTEXT; +ALTER TABLE tl_laasse10_question_option MODIFY question MEDIUMTEXT; +ALTER TABLE tl_laasse10_question_option MODIFY option_string MEDIUMTEXT; +ALTER TABLE tl_laasse10_question_option MODIFY feedback MEDIUMTEXT; +ALTER TABLE tl_laasse10_question_result MODIFY answer_string MEDIUMTEXT; + +----------------------Put all sql statements above here------------------------- + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Fisheye: Tag b91cd3c97761ce67a4bd1a81f6734769dfc760e6 refers to a dead (removed) revision in file `lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20180525.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/patch20180425.sql =================================================================== diff -u --- lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/patch20180425.sql (revision 0) +++ lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/patch20180425.sql (revision b91cd3c97761ce67a4bd1a81f6734769dfc760e6) @@ -0,0 +1,17 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +----------------------Put all sql statements below here------------------------- + +-- LDEV-4558 Increase db text size for all user inputs +ALTER TABLE tl_ladaco10_answers MODIFY answer MEDIUMTEXT; +ALTER TABLE tl_ladaco10_contents MODIFY instructions MEDIUMTEXT; +ALTER TABLE tl_ladaco10_contents MODIFY reflect_instructions MEDIUMTEXT; +ALTER TABLE tl_ladaco10_questions MODIFY description MEDIUMTEXT; + +----------------------Put all sql statements above here------------------------- + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Fisheye: Tag b91cd3c97761ce67a4bd1a81f6734769dfc760e6 refers to a dead (removed) revision in file `lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/patch20180525.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_doku/src/java/org/lamsfoundation/lams/tool/dokumaran/dbupdates/patch20180425.sql =================================================================== diff -u --- lams_tool_doku/src/java/org/lamsfoundation/lams/tool/dokumaran/dbupdates/patch20180425.sql (revision 0) +++ lams_tool_doku/src/java/org/lamsfoundation/lams/tool/dokumaran/dbupdates/patch20180425.sql (revision b91cd3c97761ce67a4bd1a81f6734769dfc760e6) @@ -0,0 +1,15 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +----------------------Put all sql statements below here------------------------- + +-- LDEV-4558 Increase db text size for all user inputs +ALTER TABLE tl_ladoku11_dokumaran MODIFY instructions MEDIUMTEXT; +ALTER TABLE tl_ladoku11_dokumaran MODIFY reflect_instructions MEDIUMTEXT; + +----------------------Put all sql statements above here------------------------- + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Fisheye: Tag b91cd3c97761ce67a4bd1a81f6734769dfc760e6 refers to a dead (removed) revision in file `lams_tool_doku/src/java/org/lamsfoundation/lams/tool/dokumaran/dbupdates/patch20180525.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20180425.sql =================================================================== diff -u --- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20180425.sql (revision 0) +++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20180425.sql (revision b91cd3c97761ce67a4bd1a81f6734769dfc760e6) @@ -0,0 +1,17 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +----------------------Put all sql statements below here------------------------- + +-- LDEV-4558 Increase db text size for all user inputs +ALTER TABLE tl_lafrum11_forum MODIFY instructions MEDIUMTEXT; +ALTER TABLE tl_lafrum11_forum MODIFY reflect_instructions MEDIUMTEXT; +ALTER TABLE tl_lafrum11_message MODIFY body MEDIUMTEXT; +ALTER TABLE tl_lafrum11_report MODIFY comment MEDIUMTEXT; + +----------------------Put all sql statements above here------------------------- + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Fisheye: Tag b91cd3c97761ce67a4bd1a81f6734769dfc760e6 refers to a dead (removed) revision in file `lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20180525.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20180425.sql =================================================================== diff -u --- lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20180425.sql (revision 0) +++ lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20180425.sql (revision b91cd3c97761ce67a4bd1a81f6734769dfc760e6) @@ -0,0 +1,16 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +----------------------Put all sql statements below here------------------------- + +-- LDEV-4558 Increase db text size for all user inputs +ALTER TABLE tl_laimag10_imagegallery MODIFY instructions MEDIUMTEXT; +ALTER TABLE tl_laimag10_imagegallery MODIFY reflect_instructions MEDIUMTEXT; +ALTER TABLE tl_laimag10_imagegallery_item MODIFY description MEDIUMTEXT; + +----------------------Put all sql statements above here------------------------- + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Fisheye: Tag b91cd3c97761ce67a4bd1a81f6734769dfc760e6 refers to a dead (removed) revision in file `lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20180525.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_imscc/src/java/org/lamsfoundation/lams/tool/commonCartridge/dbupdates/patch20180425.sql =================================================================== diff -u --- lams_tool_imscc/src/java/org/lamsfoundation/lams/tool/commonCartridge/dbupdates/patch20180425.sql (revision 0) +++ lams_tool_imscc/src/java/org/lamsfoundation/lams/tool/commonCartridge/dbupdates/patch20180425.sql (revision b91cd3c97761ce67a4bd1a81f6734769dfc760e6) @@ -0,0 +1,15 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +----------------------Put all sql statements below here------------------------- + +-- LDEV-4558 Increase db text size for all user inputs +ALTER TABLE tl_laimsc11_commoncartridge MODIFY instructions MEDIUMTEXT; +ALTER TABLE tl_laimsc11_commoncartridge MODIFY reflect_instructions MEDIUMTEXT; + +----------------------Put all sql statements above here------------------------- + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Fisheye: Tag b91cd3c97761ce67a4bd1a81f6734769dfc760e6 refers to a dead (removed) revision in file `lams_tool_imscc/src/java/org/lamsfoundation/lams/tool/commonCartridge/dbupdates/patch20180525.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_kaltura/src/java/org/lamsfoundation/lams/tool/kaltura/dbupdates/patch20180425.sql =================================================================== diff -u --- lams_tool_kaltura/src/java/org/lamsfoundation/lams/tool/kaltura/dbupdates/patch20180425.sql (revision 0) +++ lams_tool_kaltura/src/java/org/lamsfoundation/lams/tool/kaltura/dbupdates/patch20180425.sql (revision b91cd3c97761ce67a4bd1a81f6734769dfc760e6) @@ -0,0 +1,16 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +----------------------Put all sql statements below here------------------------- + +-- LDEV-4558 Increase db text size for all user inputs +ALTER TABLE tl_lakalt11_comment MODIFY comment MEDIUMTEXT; +ALTER TABLE tl_lakalt11_kaltura MODIFY instructions MEDIUMTEXT; +ALTER TABLE tl_lakalt11_kaltura MODIFY reflect_instructions MEDIUMTEXT; + +----------------------Put all sql statements above here------------------------- + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Fisheye: Tag b91cd3c97761ce67a4bd1a81f6734769dfc760e6 refers to a dead (removed) revision in file `lams_tool_kaltura/src/java/org/lamsfoundation/lams/tool/kaltura/dbupdates/patch20180525.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20180425.sql =================================================================== diff -u --- lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20180425.sql (revision 0) +++ lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20180425.sql (revision b91cd3c97761ce67a4bd1a81f6734769dfc760e6) @@ -0,0 +1,18 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +----------------------Put all sql statements below here------------------------- + +-- LDEV-4558 Increase db text size for all user inputs +ALTER TABLE tl_lamc11_content MODIFY instructions MEDIUMTEXT; +ALTER TABLE tl_lamc11_content MODIFY reflectionSubject MEDIUMTEXT; +ALTER TABLE tl_lamc11_options_content MODIFY mc_que_option_text MEDIUMTEXT; + +ALTER TABLE tl_lamc11_que_content MODIFY question MEDIUMTEXT; +ALTER TABLE tl_lamc11_que_content MODIFY feedback MEDIUMTEXT; +----------------------Put all sql statements above here------------------------- + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Fisheye: Tag b91cd3c97761ce67a4bd1a81f6734769dfc760e6 refers to a dead (removed) revision in file `lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20180525.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20180425.sql =================================================================== diff -u --- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20180425.sql (revision 0) +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20180425.sql (revision b91cd3c97761ce67a4bd1a81f6734769dfc760e6) @@ -0,0 +1,19 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +----------------------Put all sql statements below here------------------------- + +-- LDEV-4558 Increase db text size for all user inputs +ALTER TABLE tl_laqa11_content MODIFY instructions MEDIUMTEXT; +ALTER TABLE tl_laqa11_content MODIFY reflectionSubject MEDIUMTEXT; +ALTER TABLE tl_laqa11_que_content MODIFY question MEDIUMTEXT; +ALTER TABLE tl_laqa11_que_content MODIFY feedback MEDIUMTEXT; +ALTER TABLE tl_laqa11_usr_resp MODIFY answer MEDIUMTEXT; +ALTER TABLE tl_laqa11_usr_resp MODIFY answer_autosaved MEDIUMTEXT; + +----------------------Put all sql statements above here------------------------- + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Fisheye: Tag b91cd3c97761ce67a4bd1a81f6734769dfc760e6 refers to a dead (removed) revision in file `lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20180525.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20180425.sql =================================================================== diff -u --- lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20180425.sql (revision 0) +++ lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20180425.sql (revision b91cd3c97761ce67a4bd1a81f6734769dfc760e6) @@ -0,0 +1,16 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +----------------------Put all sql statements below here------------------------- + +-- LDEV-4558 Increase db text size for all user inputs +ALTER TABLE tl_larsrc11_item_instruction MODIFY description MEDIUMTEXT; +ALTER TABLE tl_larsrc11_resource MODIFY instructions MEDIUMTEXT; +ALTER TABLE tl_larsrc11_resource MODIFY reflect_instructions MEDIUMTEXT; + +----------------------Put all sql statements above here------------------------- + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Fisheye: Tag b91cd3c97761ce67a4bd1a81f6734769dfc760e6 refers to a dead (removed) revision in file `lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20180525.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dbupdates/patch20180425.sql =================================================================== diff -u --- lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dbupdates/patch20180425.sql (revision 0) +++ lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dbupdates/patch20180425.sql (revision b91cd3c97761ce67a4bd1a81f6734769dfc760e6) @@ -0,0 +1,15 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +----------------------Put all sql statements below here------------------------- + +-- LDEV-4558 Increase db text size for all user inputs +ALTER TABLE tl_lanb11_content MODIFY content MEDIUMTEXT; +ALTER TABLE tl_lanb11_content MODIFY reflect_instructions MEDIUMTEXT; + +----------------------Put all sql statements above here------------------------- + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Fisheye: Tag b91cd3c97761ce67a4bd1a81f6734769dfc760e6 refers to a dead (removed) revision in file `lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dbupdates/patch20180525.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20180425.sql =================================================================== diff -u --- lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20180425.sql (revision 0) +++ lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20180425.sql (revision b91cd3c97761ce67a4bd1a81f6734769dfc760e6) @@ -0,0 +1,15 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +----------------------Put all sql statements below here------------------------- + +-- LDEV-4558 Increase db text size for all user inputs +ALTER TABLE tl_laprev11_peerreview MODIFY instructions MEDIUMTEXT; +ALTER TABLE tl_laprev11_peerreview MODIFY reflect_instructions MEDIUMTEXT; + +----------------------Put all sql statements above here------------------------- + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Fisheye: Tag b91cd3c97761ce67a4bd1a81f6734769dfc760e6 refers to a dead (removed) revision in file `lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20180525.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20180425.sql =================================================================== diff -u --- lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20180425.sql (revision 0) +++ lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20180425.sql (revision b91cd3c97761ce67a4bd1a81f6734769dfc760e6) @@ -0,0 +1,17 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +----------------------Put all sql statements below here------------------------- + +-- LDEV-4558 Increase db text size for all user inputs +ALTER TABLE tl_lasbmt11_content MODIFY instruction MEDIUMTEXT; +ALTER TABLE tl_lasbmt11_content MODIFY reflect_instructions MEDIUMTEXT; +ALTER TABLE tl_lasbmt11_report MODIFY comments MEDIUMTEXT; +ALTER TABLE tl_lasbmt11_submission_details MODIFY fileDescription MEDIUMTEXT; + +----------------------Put all sql statements above here------------------------- + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Fisheye: Tag b91cd3c97761ce67a4bd1a81f6734769dfc760e6 refers to a dead (removed) revision in file `lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20180525.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20180425.sql =================================================================== diff -u --- lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20180425.sql (revision 0) +++ lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20180425.sql (revision b91cd3c97761ce67a4bd1a81f6734769dfc760e6) @@ -0,0 +1,17 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +----------------------Put all sql statements below here------------------------- + +-- LDEV-4558 Increase db text size for all user inputs +ALTER TABLE tl_lascrt11_scratchie MODIFY instructions MEDIUMTEXT; +ALTER TABLE tl_lascrt11_scratchie MODIFY reflect_instructions MEDIUMTEXT; +ALTER TABLE tl_lascrt11_scratchie_answer MODIFY description MEDIUMTEXT; +ALTER TABLE tl_lascrt11_scratchie_item MODIFY description MEDIUMTEXT; + +----------------------Put all sql statements above here------------------------- + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Fisheye: Tag b91cd3c97761ce67a4bd1a81f6734769dfc760e6 refers to a dead (removed) revision in file `lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20180525.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/dbupdates/patch20180425.sql =================================================================== diff -u --- lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/dbupdates/patch20180425.sql (revision 0) +++ lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/dbupdates/patch20180425.sql (revision b91cd3c97761ce67a4bd1a81f6734769dfc760e6) @@ -0,0 +1,16 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +----------------------Put all sql statements below here------------------------- + +-- LDEV-4558 Increase db text size for all user inputs +ALTER TABLE tl_lasprd10_spreadsheet MODIFY instructions MEDIUMTEXT; +ALTER TABLE tl_lasprd10_spreadsheet MODIFY reflect_instructions MEDIUMTEXT; +ALTER TABLE tl_lasprd10_spreadsheet_mark MODIFY comments MEDIUMTEXT; + +----------------------Put all sql statements above here------------------------- + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Fisheye: Tag b91cd3c97761ce67a4bd1a81f6734769dfc760e6 refers to a dead (removed) revision in file `lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/dbupdates/patch20180525.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20180425.sql =================================================================== diff -u --- lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20180425.sql (revision 0) +++ lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20180425.sql (revision b91cd3c97761ce67a4bd1a81f6734769dfc760e6) @@ -0,0 +1,18 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +----------------------Put all sql statements below here------------------------- + +-- LDEV-4558 Increase db text size for all user inputs +ALTER TABLE tl_lasurv11_question MODIFY description MEDIUMTEXT; +ALTER TABLE tl_lasurv11_answer MODIFY answer_text MEDIUMTEXT; +ALTER TABLE tl_lasurv11_option MODIFY description MEDIUMTEXT; +ALTER TABLE tl_lasurv11_survey MODIFY instructions MEDIUMTEXT; +ALTER TABLE tl_lasurv11_survey MODIFY reflect_instructions MEDIUMTEXT; + +----------------------Put all sql statements above here------------------------- + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Fisheye: Tag b91cd3c97761ce67a4bd1a81f6734769dfc760e6 refers to a dead (removed) revision in file `lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20180525.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20180425.sql =================================================================== diff -u --- lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20180425.sql (revision 0) +++ lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20180425.sql (revision b91cd3c97761ce67a4bd1a81f6734769dfc760e6) @@ -0,0 +1,17 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +----------------------Put all sql statements below here------------------------- + +-- LDEV-4558 Increase db text size for all user inputs +ALTER TABLE tl_latask10_item_comment MODIFY comment MEDIUMTEXT; +ALTER TABLE tl_latask10_tasklist MODIFY instructions MEDIUMTEXT; +ALTER TABLE tl_latask10_tasklist MODIFY reflect_instructions MEDIUMTEXT; +ALTER TABLE tl_latask10_tasklist_item MODIFY description MEDIUMTEXT; + +----------------------Put all sql statements above here------------------------- + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Fisheye: Tag b91cd3c97761ce67a4bd1a81f6734769dfc760e6 refers to a dead (removed) revision in file `lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20180525.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/patch20180425.sql =================================================================== diff -u --- lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/patch20180425.sql (revision 0) +++ lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/patch20180425.sql (revision b91cd3c97761ce67a4bd1a81f6734769dfc760e6) @@ -0,0 +1,16 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +----------------------Put all sql statements below here------------------------- + +-- LDEV-4558 Increase db text size for all user inputs +ALTER TABLE tl_lavote11_content MODIFY instructions MEDIUMTEXT; +ALTER TABLE tl_lavote11_content MODIFY reflectionSubject MEDIUMTEXT; +ALTER TABLE tl_lavote11_nomination_content MODIFY nomination MEDIUMTEXT; + +----------------------Put all sql statements above here------------------------- + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Fisheye: Tag b91cd3c97761ce67a4bd1a81f6734769dfc760e6 refers to a dead (removed) revision in file `lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/patch20180525.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/patch20180425.sql =================================================================== diff -u --- lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/patch20180425.sql (revision 0) +++ lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/patch20180425.sql (revision b91cd3c97761ce67a4bd1a81f6734769dfc760e6) @@ -0,0 +1,15 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +----------------------Put all sql statements below here------------------------- + +-- LDEV-4558 Increase db text size for all user inputs +ALTER TABLE tl_lanb11_content MODIFY content MEDIUMTEXT; +ALTER TABLE tl_lanb11_content MODIFY reflect_instructions MEDIUMTEXT; + +----------------------Put all sql statements above here------------------------- + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Fisheye: Tag b91cd3c97761ce67a4bd1a81f6734769dfc760e6 refers to a dead (removed) revision in file `lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/patch20180525.sql'. Fisheye: No comparison available. Pass `N' to diff?