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