Added gift ribbon descriptions

This is basically just for completeness because it is unknown whether
gift ribbons other than the National Ribbon and Earth Ribbon from
Pokémon Colosseum were ever distributed.

2 files changed, 43 insertions, 0 deletions

@@ -0,0 +1,9 @@
+class CreatePokeviewerGiftRibbons < ActiveRecord::Migration[5.1]
+  def change
+    create_table :pokeviewer_gift_ribbons do |t|
+      t.string :description, null: false
+
+      t.timestamps
+    end
+  end
+end
@@ -0,0 +1,34 @@
+class AddGiftRibbonsToTrainer < ActiveRecord::Migration[5.1]
+  def change
+    change_table :pokeviewer_trainers do |t|
+      t.references :marine_ribbon, null: true
+      t.references :land_ribbon, null: true
+      t.references :sky_ribbon, null: true
+      t.references :country_ribbon, null: true
+      t.references :national_ribbon, null: true
+      t.references :earth_ribbon, null: true
+      t.references :world_ribbon, null: true
+    end
+
+    add_foreign_key :pokeviewer_trainers, :pokeviewer_gift_ribbons,
+      column: :marine_ribbon_id
+
+    add_foreign_key :pokeviewer_trainers, :pokeviewer_gift_ribbons,
+      column: :land_ribbon_id
+
+    add_foreign_key :pokeviewer_trainers, :pokeviewer_gift_ribbons,
+      column: :sky_ribbon_id
+
+    add_foreign_key :pokeviewer_trainers, :pokeviewer_gift_ribbons,
+      column: :country_ribbon_id
+
+    add_foreign_key :pokeviewer_trainers, :pokeviewer_gift_ribbons,
+      column: :national_ribbon_id
+
+    add_foreign_key :pokeviewer_trainers, :pokeviewer_gift_ribbons,
+      column: :earth_ribbon_id
+
+    add_foreign_key :pokeviewer_trainers, :pokeviewer_gift_ribbons,
+      column: :world_ribbon_id
+  end
+end