luckybooru/db/migrations/00000000000002_create_roles.cr

23 lines
454 B
Crystal

class CreateRoles::V00000000000002 < Avram::Migrator::Migration::V1
def migrate
create table_for(Role) do
primary_key id : Int64
add name : String, unique: true
add description : String?
end
alter table_for(User) do
add_belongs_to primary_role : Role, on_delete: :restrict
end
end
def rollback
alter table_for(User) do
remove_belongs_to :primary_role
end
drop table_for(Role)
end
end