Sha256: 72a08a4475787dc14a8f9bbf09747d695b7494d3c58a2eea2ebb129ffe8810b2
Contents?: true
Size: 1 KB
Versions: 1
Compression:
Stored size: 1 KB
Contents
class AddForeignKeysToConsultas < ActiveRecord::Migration[5.0] def up ActiveRecord::Base.connection.execute( "UPDATE consultas SET agendamento_id = null WHERE agendamento_id NOT IN (SELECT id FROM agendamentos)" ) add_foreign_key :consultas, :pacientes, on_delete: :cascade add_foreign_key :consultas, :profissionais, on_delete: :cascade add_foreign_key :consultas, :unidades_saude, on_delete: :cascade add_foreign_key :consultas, :agendamentos, on_delete: :cascade add_foreign_key :consultas, :profissionais, column: :supervisor_id, on_delete: :cascade add_foreign_key :consultas, :profissionais, column: :aluno_id, on_delete: :cascade end def down remove_foreign_key :consultas, :pacientes remove_foreign_key :consultas, :unidades_saude remove_foreign_key :consultas, :agendamentos remove_foreign_key :consultas, column: :profissional_id remove_foreign_key :consultas, column: :supervisor_id remove_foreign_key :consultas, column: :aluno_id end end
Version data entries
1 entries across 1 versions & 1 rubygems
Version | Path |
---|---|
omniauth-sabia-1.0.1 | db/migrate/20170524124536_add_foreign_keys_to_consultas.rb |