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.

3 files changed, 108 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
@@ -954,4 +954,69 @@ module Pokeviewer
   Location.create(id: 210, name: "Altering Cave")
   Location.create(id: 211, name: "Navel Rock")
   Location.create(id: 212, name: "Trainer Hill")
+
+  GiftRibbon.create(id: 1, description: "2003 REGIONAL TOURNEY CHAMPION RIBBON")
+  GiftRibbon.create(id: 2, description: "2003 NATIONAL TOURNEY CHAMPION RIBBON")
+  GiftRibbon.create(id: 3, description: "2003 GLOBAL CUP CHAMPION RIBBON")
+  GiftRibbon.create(id: 4, description: "2003 REGIONAL TOURNEY Runner-up RIBBON")
+  GiftRibbon.create(id: 5, description: "2003 NATIONAL TOURNEY Runner-up RIBBON")
+  GiftRibbon.create(id: 6, description: "2003 GLOBAL CUP Runner-up RIBBON")
+  GiftRibbon.create(id: 7, description: "2003 REGIONAL TOURNEY Semifinalist RIBBON")
+  GiftRibbon.create(id: 8, description: "2003 NATIONAL TOURNEY Semifinalist RIBBON")
+  GiftRibbon.create(id: 9, description: "2003 GLOBAL CUP Semifinalist RIBBON")
+  GiftRibbon.create(id: 10, description: "2004 REGIONAL TOURNEY CHAMPION RIBBON")
+  GiftRibbon.create(id: 11, description: "2004 NATIONAL TOURNEY CHAMPION RIBBON")
+  GiftRibbon.create(id: 12, description: "2004 GLOBAL CUP CHAMPION RIBBON")
+  GiftRibbon.create(id: 13, description: "2004 REGIONAL TOURNEY Runner-up RIBBON")
+  GiftRibbon.create(id: 14, description: "2004 NATIONAL TOURNEY Runner-up RIBBON")
+  GiftRibbon.create(id: 15, description: "2004 GLOBAL CUP Runner-up RIBBON")
+  GiftRibbon.create(id: 16, description: "2004 REGIONAL TOURNEY Semifinalist RIBBON")
+  GiftRibbon.create(id: 17, description: "2004 NATIONAL TOURNEY Semifinalist RIBBON")
+  GiftRibbon.create(id: 18, description: "2004 GLOBAL CUP Semifinalist RIBBON")
+  GiftRibbon.create(id: 19, description: "2005 REGIONAL TOURNEY CHAMPION RIBBON")
+  GiftRibbon.create(id: 20, description: "2005 NATIONAL TOURNEY CHAMPION RIBBON")
+  GiftRibbon.create(id: 21, description: "2005 GLOBAL CUP CHAMPION RIBBON")
+  GiftRibbon.create(id: 22, description: "2005 REGIONAL TOURNEY Runner-up RIBBON")
+  GiftRibbon.create(id: 23, description: "2005 NATIONAL TOURNEY Runner-up RIBBON")
+  GiftRibbon.create(id: 24, description: "2005 GLOBAL CUP Runner-up RIBBON")
+  GiftRibbon.create(id: 25, description: "2005 REGIONAL TOURNEY Semifinalist RIBBON")
+  GiftRibbon.create(id: 26, description: "2005 NATIONAL TOURNEY Semifinalist RIBBON")
+  GiftRibbon.create(id: 27, description: "2005 GLOBAL CUP Semifinalist RIBBON")
+  GiftRibbon.create(id: 28, description: "POKéMON BATTLE CUP CHAMPION RIBBON")
+  GiftRibbon.create(id: 29, description: "POKéMON BATTLE CUP Runner-up RIBBON")
+  GiftRibbon.create(id: 30, description: "POKéMON BATTLE CUP Semifinalist RIBBON")
+  GiftRibbon.create(id: 31, description: "POKéMON BATTLE CUP Participation RIBBON")
+  GiftRibbon.create(id: 32, description: "POKéMON LEAGUE CHAMPION RIBBON")
+  GiftRibbon.create(id: 33, description: "POKéMON LEAGUE Runner-up RIBBON")
+  GiftRibbon.create(id: 34, description: "POKéMON LEAGUE Semifinalist RIBBON")
+  GiftRibbon.create(id: 35, description: "POKéMON LEAGUE Participation RIBBON")
+  GiftRibbon.create(id: 36, description: "ADVANCE CUP CHAMPION RIBBON")
+  GiftRibbon.create(id: 37, description: "ADVANCE CUP Runner-up RIBBON")
+  GiftRibbon.create(id: 38, description: "ADVANCE CUP Semifinalist RIBBON")
+  GiftRibbon.create(id: 39, description: "ADVANCE CUP Participation RIBBON")
+  GiftRibbon.create(id: 40, description: "POKéMON Tournament Participation RIBBON")
+  GiftRibbon.create(id: 41, description: "POKéMON Event Participation RIBBON")
+  GiftRibbon.create(id: 42, description: "POKéMON Festival Participation RIBBON")
+  GiftRibbon.create(id: 43, description: "Difficulty-clearing Commemorative RIBBON")
+  GiftRibbon.create(id: 44, description: "RIBBON awarded for clearing all difficulties.")
+  GiftRibbon.create(id: 45, description: "100-straight Win Commemorative RIBBON")
+  GiftRibbon.create(id: 46, description: "DARKNESS TOWER Clear Commemorative RIBBON")
+  GiftRibbon.create(id: 47, description: "RED TOWER Clear Commemorative RIBBON")
+  GiftRibbon.create(id: 48, description: "BLACKIRON TOWER Clear Commemorative RIBBON")
+  GiftRibbon.create(id: 49, description: "FINAL TOWER Clear Commemorative RIBBON")
+  GiftRibbon.create(id: 50, description: "Legend-making Commemorative RIBBON")
+  GiftRibbon.create(id: 51, description: "POKéMON CENTER TOKYO Commemorative RIBBON")
+  GiftRibbon.create(id: 52, description: "POKéMON CENTER OSAKA Commemorative RIBBON")
+  GiftRibbon.create(id: 53, description: "POKéMON CENTER NAGOYA Commemorative RIBBON")
+  GiftRibbon.create(id: 54, description: "POKéMON CENTER NY Commemorative RIBBON")
+  GiftRibbon.create(id: 55, description: "Summer Holidays RIBBON")
+  GiftRibbon.create(id: 56, description: "Winter Holidays RIBBON")
+  GiftRibbon.create(id: 57, description: "Spring Holidays RIBBON")
+  GiftRibbon.create(id: 58, description: "Evergreen RIBBON")
+  GiftRibbon.create(id: 59, description: "Special Holiday RIBBON")
+  GiftRibbon.create(id: 60, description: "Hard Worker RIBBON")
+  GiftRibbon.create(id: 61, description: "Lots of Friends RIBBON")
+  GiftRibbon.create(id: 62, description: "Full of Energy RIBBON")
+  GiftRibbon.create(id: 63, description: "A commemorative RIBBON for a loved POKéMON.")
+  GiftRibbon.create(id: 64, description: "RIBBON that shows love for POKéMON.")
 end