summaryrefslogtreecommitdiff
path: root/db/migrate/20170127032550_remove_backlog_lists_from_boards.rb
diff options
context:
space:
mode:
Diffstat (limited to 'db/migrate/20170127032550_remove_backlog_lists_from_boards.rb')
-rw-r--r--db/migrate/20170127032550_remove_backlog_lists_from_boards.rb17
1 files changed, 17 insertions, 0 deletions
diff --git a/db/migrate/20170127032550_remove_backlog_lists_from_boards.rb b/db/migrate/20170127032550_remove_backlog_lists_from_boards.rb
new file mode 100644
index 00000000000..0ee4229d1f8
--- /dev/null
+++ b/db/migrate/20170127032550_remove_backlog_lists_from_boards.rb
@@ -0,0 +1,17 @@
+class RemoveBacklogListsFromBoards < ActiveRecord::Migration
+ DOWNTIME = false
+
+ def up
+ execute <<-SQL
+ DELETE FROM lists WHERE list_type = 0;
+ SQL
+ end
+
+ def down
+ execute <<-SQL
+ INSERT INTO lists (board_id, list_type, created_at, updated_at)
+ SELECT boards.id, 0, NOW(), NOW()
+ FROM boards;
+ SQL
+ end
+end