From 3f20a128d9068f85965a63f4e5e28f0b6f17c230 Mon Sep 17 00:00:00 2001 From: Julien Lancelot Date: Mon, 12 Oct 2015 09:41:09 +0200 Subject: SONAR-6915 Change type of character columns of ISSUES table on MsSQL Type of following columns are updtated to NVARCHAR on MsSQL : ISSUES.TAGS ISSUES.COMPONENT_UUID ISSUES.PROJECT_UUID --- .../941_alter_issues_char_columns_on_mssql.rb | 41 ++++++++++++++++++++++ 1 file changed, 41 insertions(+) create mode 100644 server/sonar-web/src/main/webapp/WEB-INF/db/migrate/941_alter_issues_char_columns_on_mssql.rb (limited to 'server') diff --git a/server/sonar-web/src/main/webapp/WEB-INF/db/migrate/941_alter_issues_char_columns_on_mssql.rb b/server/sonar-web/src/main/webapp/WEB-INF/db/migrate/941_alter_issues_char_columns_on_mssql.rb new file mode 100644 index 00000000000..f74a068eb50 --- /dev/null +++ b/server/sonar-web/src/main/webapp/WEB-INF/db/migrate/941_alter_issues_char_columns_on_mssql.rb @@ -0,0 +1,41 @@ +# +# SonarQube, open source software quality management tool. +# Copyright (C) 2008-2014 SonarSource +# mailto:contact AT sonarsource DOT com +# +# SonarQube is free software; you can redistribute it and/or +# modify it under the terms of the GNU Lesser General Public +# License as published by the Free Software Foundation; either +# version 3 of the License, or (at your option) any later version. +# +# SonarQube is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU +# Lesser General Public License for more details. +# +# You should have received a copy of the GNU Lesser General Public License +# along with this program; if not, write to the Free Software Foundation, +# Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA. +# + +# +# SonarQube 5.2 +# SONAR-6915 +# +class AlterIssuesCharColumnsOnMssql < ActiveRecord::Migration + + def self.up + if dialect()=='sqlserver' + remove_index :issues, :name => 'issues_component_uuid' + remove_index :issues, :name => 'issues_project_uuid' + + change_column :issues, :tags, :string, :limit => 4000 + change_column :issues, :component_uuid, :string, :limit => 50 + change_column :issues, :project_uuid, :string, :limit => 50 + + add_index :issues, :component_uuid, :name => 'issues_component_uuid' + add_index :issues, :project_uuid, :name => 'issues_project_uuid' + end + end + +end -- cgit v1.2.3