initial commit

1 files changed, 11 insertions, 0 deletions

diff --git a/sql/functions/auth.registrations_gc.sql b/sql/functions/auth.registrations_gc.sql
new file mode 100644
index 0000000..c1e1d90
--- /dev/null
+++ b/sql/functions/auth.registrations_gc.sql
@@ -0,0 +1,11 @@
+drop function auth.registrations_gc ();
+
+create or replace function auth.registrations_gc ()
+returns void
+as $$
+begin
+    delete
+    from auth.registrations
+    where created < now() - interval '3 days';
+end;
+$$ language plpgsql;