initial commit

3 files changed, 34 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
+);
diff --git a/sql/types/auth.role_groups_t.sql b/sql/types/auth.role_groups_t.sql
new file mode 100644
index 0000000..615c481
--- /dev/null
+++ b/sql/types/auth.role_groups_t.sql
@@ -0,0 +1,9 @@
+drop type auth.role_groups_t cascade;
+
+CREATE TYPE auth.role_groups_t AS (
+    user_role_group_id bigint,
+    user_id bigint,
+    role_group_id bigint,
+    name character varying,
+    description character varying
+);
diff --git a/sql/types/auth.user_roles_t.sql b/sql/types/auth.user_roles_t.sql
new file mode 100644
index 0000000..e6b8443
--- /dev/null
+++ b/sql/types/auth.user_roles_t.sql
@@ -0,0 +1,13 @@
+drop type auth.user_roles_t cascade;
+
+CREATE TYPE auth.user_roles_t AS (
+    user_role_group_id bigint,
+    user_id bigint,
+    role_group_id bigint,
+    role_group_name character varying,
+    role_group_description character varying,
+    role_group_role_id bigint,
+    role_id bigint,
+    role_name character varying,
+    role_description character varying
+);