From 623d5f8e686eb37250e01ac5eea46bc70237d501 Mon Sep 17 00:00:00 2001
From: Drew Blessing <drew@gitlab.com>
Date: Thu, 4 Feb 2016 13:16:17 -0600
Subject: [PATCH] Fix category values for Jenkins and JenkinsDeprecated
 services [ci skip]

---
 CHANGELOG-EE                                  |  1 +
 ...4190809_update_jenkins_service_category.rb | 19 +++++++++++++++++++
 db/schema.rb                                  |  2 +-
 3 files changed, 21 insertions(+), 1 deletion(-)
 create mode 100644 db/migrate/20160204190809_update_jenkins_service_category.rb

diff --git a/CHANGELOG-EE b/CHANGELOG-EE
index 49180eab3c1833..82511f7541a461 100644
--- a/CHANGELOG-EE
+++ b/CHANGELOG-EE
@@ -6,6 +6,7 @@ v 8.5.0 (unreleased)
 
 v 8.4.4
   - Re-introduce "Send email to users" link in Admin area
+  - Fix category values for Jenkins and JenkinsDeprecated services
 
 v 8.4.3
   - Elasticsearch: fix partial blob indexing on push
diff --git a/db/migrate/20160204190809_update_jenkins_service_category.rb b/db/migrate/20160204190809_update_jenkins_service_category.rb
new file mode 100644
index 00000000000000..f1b0f2ee6d8d22
--- /dev/null
+++ b/db/migrate/20160204190809_update_jenkins_service_category.rb
@@ -0,0 +1,19 @@
+class UpdateJenkinsServiceCategory < ActiveRecord::Migration
+  def up
+    category = quote_column_name('category')
+    type = quote_column_name('type')
+
+    execute <<-EOS
+UPDATE services
+SET #{category} = 'ci'
+WHERE #{type} IN (
+  'JenkinsService',
+  'JenkinsDeprecatedService'
+)
+EOS
+  end
+
+  def down
+    # don't do anything
+  end
+end
diff --git a/db/schema.rb b/db/schema.rb
index 1558eb49303a1b..2804186e8f9c7b 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -11,7 +11,7 @@
 #
 # It's strongly recommended that you check this file into your version control system.
 
-ActiveRecord::Schema.define(version: 20160129075828) do
+ActiveRecord::Schema.define(version: 20160204190809) do
 
   # These are extensions that must be enabled in order to support this database
   enable_extension "plpgsql"
-- 
GitLab