From 4fb2af56675db4faa0df2f9d6c6e9c6726e73083 Mon Sep 17 00:00:00 2001 From: Teryk Bellahsene Date: Tue, 19 Apr 2016 15:58:55 +0200 Subject: SONAR-7553 Create composite DB index CE_ACTIVITY(is_last, status) --- .../1125_add_index_ce_activity_islast_status.rb | 31 ++++++++++++++++++++++ 1 file changed, 31 insertions(+) create mode 100644 server/sonar-web/src/main/webapp/WEB-INF/db/migrate/1125_add_index_ce_activity_islast_status.rb (limited to 'server') diff --git a/server/sonar-web/src/main/webapp/WEB-INF/db/migrate/1125_add_index_ce_activity_islast_status.rb b/server/sonar-web/src/main/webapp/WEB-INF/db/migrate/1125_add_index_ce_activity_islast_status.rb new file mode 100644 index 00000000000..b4d4d180cae --- /dev/null +++ b/server/sonar-web/src/main/webapp/WEB-INF/db/migrate/1125_add_index_ce_activity_islast_status.rb @@ -0,0 +1,31 @@ +# +# 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.5 +# SONAR-7187 & SONAR-7553 +# +class AddIndexCeActivityIslastStatus < ActiveRecord::Migration + + def self.up + add_index :ce_activity, ['is_last','status'], :name => 'ce_activity_islast_status' + end + +end -- cgit v1.2.3