summaryrefslogtreecommitdiff
path: root/db/migrate/20160119112418_add_services_default.rb
diff options
context:
space:
mode:
Diffstat (limited to 'db/migrate/20160119112418_add_services_default.rb')
-rw-r--r--db/migrate/20160119112418_add_services_default.rb20
1 files changed, 20 insertions, 0 deletions
diff --git a/db/migrate/20160119112418_add_services_default.rb b/db/migrate/20160119112418_add_services_default.rb
new file mode 100644
index 00000000000..69a42d7b873
--- /dev/null
+++ b/db/migrate/20160119112418_add_services_default.rb
@@ -0,0 +1,20 @@
+class AddServicesDefault < ActiveRecord::Migration
+ def up
+ add_column :services, :default, :boolean, default: false
+
+ default = quote_column_name('default')
+ type = quote_column_name('type')
+
+ execute <<-EOF
+UPDATE services
+SET #{default} = true
+WHERE #{type} = 'GitlabIssueTrackerService'
+EOF
+
+ add_index :services, :default
+ end
+
+ def down
+ remove_column :services, :default
+ end
+end