roles.sql

-- The enum way
create type app_public.role_types as enum (
  'READER',
  'PUBLISHER'
);

create table app_public.roles (
  id uuid primary key,
  title app_public.role_types
);

insert into app_public.roles (title) values ('READER')
insert into app_public.roles (title) values ('PUBLISHER')
insert into app_public.roles (title) values ('CURATOR') -- error: ain't no CURATOR on an app_public.role_types

alter type app_public.role_types add value 'CURATOR';

insert into app_public.roles (title) values ('CURATOR') -- all good!

-- The text way
create table app_public.roles (
  id uuid primary key,
  title text
);

insert into app_public.roles (title) values ('READER')
insert into app_public.roles (title) values ('PUBLISHER')
insert into app_public.roles (title) values ('CURATOR')
insert into app_public.roles (title) values ('CURRATOR') -- whoops, my clumsy fingers mispelled this and now what?