about summary refs log tree commit diff stats
path: root/db/migrate/20170917002857_create_pokeviewer_revisions.rb
blob: f6755da50b597f6fa70b0bec188536fd00932bf7 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
class CreatePokeviewerRevisions < ActiveRecord::Migration[5.1]
  def change
    create_table :pokeviewer_revisions do |t|
      t.references :pokemon, null: false
      t.integer :sequential_id, null: false
      t.string :nickname, null: false
      t.integer :experience, null: false
      t.integer :level, null: false
      t.integer :hp, null: false
      t.integer :attack, null: false
      t.integer :defense, null: false
      t.integer :special_attack, null: false
      t.integer :special_defense, null: false
      t.integer :speed, null: false
      t.integer :coolness, null: false
      t.integer :beauty, null: false
      t.integer :cuteness, null: false
      t.integer :smartness, null: false
      t.integer :toughness, null: false
      t.integer :sheen, null: false
      t.integer :hold_item, null: true

      t.timestamps
    end

    add_index :pokeviewer_revisions, [:pokemon_id, :sequential_id], unique: true

    add_foreign_key :pokeviewer_revisions, :pokewalker_pokemon,
      column: :pokemon_id
  end
end