diff options
| author | Julien Lancelot <julien.lancelot@sonarsource.com> | 2015-10-12 09:41:09 +0200 |
|---|---|---|
| committer | Julien Lancelot <julien.lancelot@sonarsource.com> | 2015-10-12 10:12:51 +0200 |
| commit | 3f20a128d9068f85965a63f4e5e28f0b6f17c230 (patch) | |
| tree | c57c7ca96d3a158df87cc17d0ea2b9f9d1a9d1c8 /server | |
| parent | e812a77ec2f9760794fefead8bd2bb6de5a6e68f (diff) | |
| download | sonarqube-3f20a128d9068f85965a63f4e5e28f0b6f17c230.tar.gz sonarqube-3f20a128d9068f85965a63f4e5e28f0b6f17c230.zip | |
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
Diffstat (limited to 'server')
| -rw-r--r-- | server/sonar-web/src/main/webapp/WEB-INF/db/migrate/941_alter_issues_char_columns_on_mssql.rb | 41 |
1 files changed, 41 insertions, 0 deletions
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 |