From 08e435104c42751689553537b1f20ffb14b8dfcc Mon Sep 17 00:00:00 2001
From: ckonstanski <kostcarl@isu.edu>
Date: Sat, 18 Jul 2026 21:18:18 -0600
Subject: initial commit

---
 sql/functions/auth.registrations_gc.sql | 11 +++++++++++
 1 file changed, 11 insertions(+)
 create mode 100644 sql/functions/auth.registrations_gc.sql

(limited to 'sql/functions/auth.registrations_gc.sql')

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;
-- 
cgit v1.3