initial commit

1 files changed, 14 insertions, 0 deletions

diff --git a/sql/functions/auth.delete_registration.sql b/sql/functions/auth.delete_registration.sql
new file mode 100644
index 0000000..5adf705
--- /dev/null
+++ b/sql/functions/auth.delete_registration.sql
@@ -0,0 +1,14 @@
+drop function auth.delete_registration (
+    p_hash text
+);
+
+create or replace function auth.delete_registration (
+    p_hash text
+)
+returns void
+as $$
+begin
+    delete from auth.registrations r
+    where r.hash = ('\x' || p_hash)::bytea;
+end;
+$$ language plpgsql;