From 08e435104c42751689553537b1f20ffb14b8dfcc Mon Sep 17 00:00:00 2001 From: ckonstanski Date: Sat, 18 Jul 2026 21:18:18 -0600 Subject: initial commit --- sql/types/auth.registrations_t.sql | 12 ++++++++++++ sql/types/auth.role_groups_t.sql | 9 +++++++++ sql/types/auth.user_roles_t.sql | 13 +++++++++++++ 3 files changed, 34 insertions(+) create mode 100644 sql/types/auth.registrations_t.sql create mode 100644 sql/types/auth.role_groups_t.sql create mode 100644 sql/types/auth.user_roles_t.sql (limited to 'sql/types') 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 +); -- cgit v1.3