tracks/db/migrate/043_add_updated_at_to_todos.rb
2019-05-13 18:42:57 +02:00

10 lines
368 B
Ruby

class AddUpdatedAtToTodos < ActiveRecord::Migration[5.2]
def self.up
add_column :todos, :updated_at, :timestamp
execute 'update todos set updated_at = created_at where completed_at IS NULL'
execute 'update todos set updated_at = completed_at where NOT (completed_at IS NULL)'
end
def self.down
remove_column :todos, :updated_at
end
end