5 files changed, 41 insertions, 2 deletions

@@ -25,7 +25,7 @@ class CreatePokeviewerPokemon < ActiveRecord::Migration[5.1]
     add_foreign_key :pokeviewer_pokemon, :pokeviewer_species,
       column: :species_id
 
-    add_foreign_key :pokeviewer_pokemon, :pokeviewer_trainer,
+    add_foreign_key :pokeviewer_pokemon, :pokeviewer_trainers,
       column: :trainer_id
   end
 end
@@ -8,7 +8,7 @@ class CreatePokeviewerBoxes < ActiveRecord::Migration[5.1]
       t.timestamps
     end
 
-    add_foreign_key :pokeviewer_boxes, :pokeviewer_trainer, column: :trainer_id
+    add_foreign_key :pokeviewer_boxes, :pokeviewer_trainers, column: :trainer_id
 
     add_index :pokeviewer_boxes, [:trainer_id, :number], unique: true
   end
@@ -0,0 +1,16 @@
+class CreatePokeviewerItems < ActiveRecord::Migration[5.1]
+  def change
+    create_table :pokeviewer_items do |t|
+      t.string :name, null: false
+      t.boolean :tm, null: false, default: false
+      t.references :move, null: true
+      t.string :rs_description
+      t.string :frlg_description
+      t.string :emerald_description
+
+      t.timestamps
+    end
+
+    add_foreign_key :pokeviewer_items, :pokeviewer_moves, column: :move_id
+  end
+end
@@ -0,0 +1,14 @@
+class AddDescriptionAndTypeToMoves < ActiveRecord::Migration[5.1]
+  def change
+    change_table :pokeviewer_moves do |t|
+      t.string :move_type, null: false, default: ""
+      t.string :rs_description, null: false, default: ""
+      t.string :frlg_description, null: false, default: ""
+      t.string :emerald_description
+    end
+
+    change_column_default :pokeviewer_moves, :move_type, nil
+    change_column_default :pokeviewer_moves, :rs_description, nil
+    change_column_default :pokeviewer_moves, :frlg_description, nil
+  end
+end
@@ -0,0 +1,9 @@
+class RenameRevisionHoldItem < ActiveRecord::Migration[5.1]
+  def change
+    change_table :pokeviewer_revisions do |t|
+      t.rename :hold_item, :item_id
+    end
+
+    add_foreign_key :pokeviewer_revisions, :pokeviewer_items, column: :item_id
+  end
+end