Contents

class AddForeignKeysToPermissoes < ActiveRecord::Migration[5.0]
  def up
    ActiveRecord::Base.connection.execute(
        "UPDATE permissoes SET created_at = NOW(), updated_at = NOW() WHERE CAST(created_at AS CHAR(20)) = '0000-00-00 00:00:00'"
    )

    add_foreign_key :permissoes, :perfis, on_delete: :cascade
    add_foreign_key :permissoes, :recursos, on_delete: :cascade
  end

  def down
    remove_foreign_key :permissoes, :perfis
    remove_foreign_key :permissoes, :recursos
  end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
omniauth-sabia-1.0.1	db/migrate/20170524133040_add_foreign_keys_to_permissoes.rb