1 files changed, 12 insertions, 0 deletions
diff --git a/sql/types/auth.registrations_t.sql b/sql/types/auth.registrations_t.sql
new file mode 100644
index 0000000..cde66d0
--- /dev/null
+++ b/sql/types/auth.registrations_t.sql
@@ -0,0 +1,12 @@
+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
+);