Added hold items

An items model was created, but the seed only contains items that can be
held, which excludes key items and HMs. Berry Juice, while unobtainable,
is still included. The item model contains three description fields: one
for Ruby/Sapphire, one for FireRed/LeafGreen, and one for Emerald. This
is because the descriptions for items are different between the games.
In a lot of cases, the Emerald description is the same as the
Ruby/Sapphire one, so in those cases, the Emerald description is nil.
The purpose of having the different descriptions is so that when a
Pokémon holds an item, the website can display the description that is
accurate to the game that that Pokémon is currently in.

In order to fully support TMs, the move model was improved to
additionally contain type and also the three description fields which
operate similarly to those of the item model. For TMs, the description
fields on the item are usually nil. However, some TMs in Ruby/Sapphire,
as well as Emerald, have different descriptions than the moves that
they correspond with. In these cases, those descriptions are in the item
model, and override the move descriptions when the move is looked at as
a TM.

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