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.

1 files changed, 34 insertions, 0 deletions

@@ -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