Sha256: 4ed75980c359fda64997a8860d0b79616c365b385c2665d335bc108dc7a80741
Contents?: true
Size: 822 Bytes
Versions: 136
Compression:
Stored size: 822 Bytes
Contents
class DenormalizeEntriesSubjects < ActiveRecord::Migration
def self.up
add_column :entries_subjects, :language_id, :integer
add_column :entries_subjects, :grain_size, :string
add_index "entries_subjects", ["language_id"]
add_index "entries_subjects", ["grain_size"]
execute "ALTER TABLE entries_subjects DROP PRIMARY KEY, ADD PRIMARY KEY USING BTREE(subject_id, language_id, grain_size, entry_id);"
execute "UPDATE entries_subjects AS es INNER JOIN entries AS e ON e.id = es.entry_id SET es.language_id = e.language_id, es.grain_size = e.grain_size"
end
def self.down
execute "ALTER TABLE entries_subjects DROP PRIMARY KEY, ADD PRIMARY KEY USING BTREE(subject_id, entry_id);"
remove_column :entries_subjects, :language_id
remove_column :entries_subjects, :grain_size
end
end
Version data entries
136 entries across 73 versions & 3 rubygems