summaryrefslogtreecommitdiff
path: root/db/migrate/20170127032550_remove_backlog_lists_from_boards.rb
blob: 2e2fecfa2a79af18479d4cdea4237585bc72c554 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
class RemoveBacklogListsFromBoards < ActiveRecord::Migration[4.2]
  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