drop type auth.registrations_t cascade;
create type auth.registrations_t as (
id bigint,
hash text,
first_name character varying,
last_name character varying,
email character varying,
role_groups text,
created timestamp without time zone,
valid_for interval
);