Sequel.migration do
  change do
    create_table(:roles) do
      primary_key :id
      String :name, null: false
      foreign_key :parent_id, :roles, deferrable: true, type: :integer
      DateTime :created_at, null: false, default: Sequel::CURRENT_TIMESTAMP
      DateTime :updated_at, null: false, default: Sequel::CURRENT_TIMESTAMP
    end
  end
end