diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/migrate/20180114170238_cache_current_pokemon_revision.rb | 19 |
1 files changed, 19 insertions, 0 deletions
| diff --git a/db/migrate/20180114170238_cache_current_pokemon_revision.rb b/db/migrate/20180114170238_cache_current_pokemon_revision.rb new file mode 100644 index 0000000..a0e1747 --- /dev/null +++ b/db/migrate/20180114170238_cache_current_pokemon_revision.rb | |||
| @@ -0,0 +1,19 @@ | |||
| 1 | class CacheCurrentPokemonRevision < ActiveRecord::Migration[5.1] | ||
| 2 | def up | ||
| 3 | change_table :pokeviewer_pokemon do |t| | ||
| 4 | t.references :current, null: true | ||
| 5 | end | ||
| 6 | |||
| 7 | add_foreign_key :pokeviewer_pokemon, :pokeviewer_revisions, | ||
| 8 | column: :current_id | ||
| 9 | |||
| 10 | Pokeviewer::Pokemon.all.each do |p| | ||
| 11 | p.current_id = p.revisions.last.id | ||
| 12 | p.save! | ||
| 13 | end | ||
| 14 | end | ||
| 15 | |||
| 16 | def down | ||
| 17 | remove_column :pokeviewer_pokemon, :current_id | ||
| 18 | end | ||
| 19 | end | ||
