discourse/db/migrate/20131209091742_create_topic...

Ignoring revisions in .git-blame-ignore-revs. Click here to bypass and see the normal blame view.

28 lines
722 B
Ruby
Raw Permalink Normal View History

# frozen_string_literal: true
class CreateTopicRevisions < ActiveRecord::Migration[4.2]
2013-12-11 21:41:34 -05:00
def up
create_table :topic_revisions do |t|
t.belongs_to :user
t.belongs_to :topic
t.text :modifications
t.integer :number
2017-08-07 11:48:36 -04:00
t.timestamps null: false
2013-12-11 21:41:34 -05:00
end
execute "INSERT INTO topic_revisions (user_id, topic_id, modifications, number, created_at, updated_at)
SELECT user_id, versioned_id, modifications, number, created_at, updated_at
FROM versions
WHERE versioned_type = 'Topic'"
change_table :topic_revisions do |t|
t.index :topic_id
t.index %i[topic_id number]
end
end
def down
drop_table :topic_revisions
end
end