about summary refs log tree commit diff stats
path: root/db
diff options
context:
space:
mode:
Diffstat (limited to 'db')
-rw-r--r--db/migrate/20180114170238_cache_current_pokemon_revision.rb19
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 @@
1class 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
19end