From daf1342c047d43779b609bdfb94b14cb7725dcae Mon Sep 17 00:00:00 2001 From: Jean-Philippe Lang Date: Mon, 10 Oct 2016 08:22:49 +0000 Subject: [PATCH] Raises length of issue description and journals for MySQL (#20127). git-svn-id: http://svn.redmine.org/redmine/trunk@15905 e93f8b46-1217-0410-a6f0-8f06a7374b81 --- ...0161010081301_change_issues_description_limit.rb | 12 ++++++++++++ ...1010081528_change_journal_details_value_limit.rb | 13 +++++++++++++ .../20161010081600_change_journals_notes_limit.rb | 12 ++++++++++++ 3 files changed, 37 insertions(+) create mode 100644 db/migrate/20161010081301_change_issues_description_limit.rb create mode 100644 db/migrate/20161010081528_change_journal_details_value_limit.rb create mode 100644 db/migrate/20161010081600_change_journals_notes_limit.rb diff --git a/db/migrate/20161010081301_change_issues_description_limit.rb b/db/migrate/20161010081301_change_issues_description_limit.rb new file mode 100644 index 000000000..0f20466a1 --- /dev/null +++ b/db/migrate/20161010081301_change_issues_description_limit.rb @@ -0,0 +1,12 @@ +class ChangeIssuesDescriptionLimit < ActiveRecord::Migration + def up + if ActiveRecord::Base.connection.adapter_name =~ /mysql/i + max_size = 16.megabytes + change_column :issues, :description, :text, :limit => max_size + end + end + + def down + # no-op + end +end diff --git a/db/migrate/20161010081528_change_journal_details_value_limit.rb b/db/migrate/20161010081528_change_journal_details_value_limit.rb new file mode 100644 index 000000000..2314dd535 --- /dev/null +++ b/db/migrate/20161010081528_change_journal_details_value_limit.rb @@ -0,0 +1,13 @@ +class ChangeJournalDetailsValueLimit < ActiveRecord::Migration + def up + if ActiveRecord::Base.connection.adapter_name =~ /mysql/i + max_size = 16.megabytes + change_column :journal_details, :value, :text, :limit => max_size + change_column :journal_details, :old_value, :text, :limit => max_size + end + end + + def down + # no-op + end +end diff --git a/db/migrate/20161010081600_change_journals_notes_limit.rb b/db/migrate/20161010081600_change_journals_notes_limit.rb new file mode 100644 index 000000000..8a2ba9be6 --- /dev/null +++ b/db/migrate/20161010081600_change_journals_notes_limit.rb @@ -0,0 +1,12 @@ +class ChangeJournalsNotesLimit < ActiveRecord::Migration + def up + if ActiveRecord::Base.connection.adapter_name =~ /mysql/i + max_size = 16.megabytes + change_column :journals, :notes, :text, :limit => max_size + end + end + + def down + # no-op + end +end -- 2.39.5