about summary refs log tree commit diff stats
path: root/data/maps/the_unkempt/rooms/W2 Room.txtpb
blob: 2fa07d436f95622e2096ca0e7bd75050146a4a5b (plain) (blame)
1
2
3
4
5
6
name: "W2 Room"
letters {
  key: "w"
  level2: true
  path: "Components/Collectables/w2"
}
e.Class */ .highlight .vg { color: #dd7700 } /* Name.Variable.Global */ .highlight .vi { color: #3333bb } /* Name.Variable.Instance */ .highlight .vm { color: #336699 } /* Name.Variable.Magic */ .highlight .il { color: #0000DD; font-weight: bold } /* Literal.Number.Integer.Long */
class CreatePokeviewerRevisions < ActiveRecord::Migration[5.1]
  def change
    create_table :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.references :move_1, null: false
      t.references :move_2, null: true
      t.references :move_3, null: true
      t.references :move_4, null: true
      t.integer :move_1_pp_bonuses, null: false, default: 0
      t.integer :move_2_pp_bonuses, null: false, default: 0
      t.integer :move_3_pp_bonuses, null: false, default: 0
      t.integer :move_4_pp_bonuses, null: false, default: 0

      t.timestamps
    end

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

    add_foreign_key :revisions, :pokemon,
      column: :pokemon_id

    add_foreign_key :revisions, :moves,
      column: :move_1_id

    add_foreign_key :revisions, :moves,
      column: :move_2_id

    add_foreign_key :revisions, :moves,
      column: :move_3_id

    add_foreign_key :revisions, :moves,
      column: :move_4_id
  end
end