db/migrate/20170917011258_create_pokeviewer_revision_moves.rb


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

class CreatePokeviewerRevisionMoves < ActiveRecord::Migration[5.1]
  def change
    create_table :pokeviewer_revision_moves do |t|
      t.references :revision, null: false
      t.references :move, null: false
      t.integer :number, null: false
      t.integer :pp_bonuses, null: false, default: 0

      t.timestamps
    end

    add_index :pokeviewer_revision_moves, [:revision_id, :number], unique: true

    add_foreign_key :pokeviewer_revision_moves, :pokeviewer_revisions,
      column: :revision_id

    add_foreign_key :pokeviewer_revision_moves, :pokeviewer_moves,
      column: :move_id
  end
end