summaryrefslogtreecommitdiff
path: root/db/post_migrate/20200420162730_remove_additional_application_settings_rows.rb
diff options
context:
space:
mode:
Diffstat (limited to 'db/post_migrate/20200420162730_remove_additional_application_settings_rows.rb')
-rw-r--r--db/post_migrate/20200420162730_remove_additional_application_settings_rows.rb17
1 files changed, 17 insertions, 0 deletions
diff --git a/db/post_migrate/20200420162730_remove_additional_application_settings_rows.rb b/db/post_migrate/20200420162730_remove_additional_application_settings_rows.rb
new file mode 100644
index 00000000000..e4a0ec1eb4a
--- /dev/null
+++ b/db/post_migrate/20200420162730_remove_additional_application_settings_rows.rb
@@ -0,0 +1,17 @@
+# frozen_string_literal: true
+
+class RemoveAdditionalApplicationSettingsRows < ActiveRecord::Migration[6.0]
+ class ApplicationSetting < ActiveRecord::Base
+ self.table_name = 'application_settings'
+ end
+
+ def up
+ return if ApplicationSetting.count == 1
+
+ execute "DELETE from application_settings WHERE id NOT IN (SELECT MAX(id) FROM application_settings);"
+ end
+
+ def down
+ # no changes
+ end
+end