Moved revision moves into revision table

This is a retroactive schema change, so there's no easy way to migrate
into it without losing data, but this is so early into the development
of this project that it really doesn't matter.

1 files changed, 51 insertions, 0 deletions

@@ -0,0 +1,51 @@
+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.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 :pokeviewer_revisions, [:pokemon_id, :sequential_id], unique: true
+
+    add_foreign_key :pokeviewer_revisions, :pokewalker_pokemon,
+      column: :pokemon_id
+
+    add_foreign_key :pokeviewer_revisions, :pokewalker_moves,
+      column: :move_1_id
+
+    add_foreign_key :pokeviewer_revisions, :pokewalker_moves,
+      column: :move_2_id
+
+    add_foreign_key :pokeviewer_revisions, :pokewalker_moves,
+      column: :move_3_id
+
+    add_foreign_key :pokeviewer_revisions, :pokewalker_moves,
+      column: :move_4_id
+  end
+end