summaryrefslogtreecommitdiff
path: root/db/migrate/20160416182152_convert_award_note_to_emoji_award.rb
blob: c226bc11f6c31fc424e419b3eb96fe7c63d95a0f (plain)
1
2
3
4
5
6
7
8
9
10
# rubocop:disable all
class ConvertAwardNoteToEmojiAward < ActiveRecord::Migration
  def change
    def up
      execute "INSERT INTO award_emoji (awardable_type, awardable_id, user_id, name, created_at, updated_at) (SELECT noteable_type, noteable_id, author_id, note, created_at, updated_at FROM notes WHERE is_award = true)"

      execute "DELETE FROM notes WHERE is_award = true"
    end
  end
end