From a7060addea52af313ed85336dc37949ad8e69f05 Mon Sep 17 00:00:00 2001 From: Kelly Rauchenberger Date: Sat, 30 Sep 2017 08:23:48 -0400 Subject: Added gift ribbon descriptions MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit 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. --- ...0170929221317_create_pokeviewer_gift_ribbons.rb | 9 +++ .../20170930021856_add_gift_ribbons_to_trainer.rb | 34 +++++++++++ db/seeds.rb | 65 ++++++++++++++++++++++ 3 files changed, 108 insertions(+) create mode 100644 db/migrate/20170929221317_create_pokeviewer_gift_ribbons.rb create mode 100644 db/migrate/20170930021856_add_gift_ribbons_to_trainer.rb (limited to 'db') diff --git a/db/migrate/20170929221317_create_pokeviewer_gift_ribbons.rb b/db/migrate/20170929221317_create_pokeviewer_gift_ribbons.rb new file mode 100644 index 0000000..deedc80 --- /dev/null +++ b/db/migrate/20170929221317_create_pokeviewer_gift_ribbons.rb @@ -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 diff --git a/db/migrate/20170930021856_add_gift_ribbons_to_trainer.rb b/db/migrate/20170930021856_add_gift_ribbons_to_trainer.rb new file mode 100644 index 0000000..2a5f9b3 --- /dev/null +++ b/db/migrate/20170930021856_add_gift_ribbons_to_trainer.rb @@ -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 diff --git a/db/seeds.rb b/db/seeds.rb index 221538e..500e3c6 100644 --- a/db/seeds.rb +++ b/db/seeds.rb @@ -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 -- cgit 1.4.1