From b8423f4d05c75094b7b9d09c6f0bb353acc9be1c Mon Sep 17 00:00:00 2001
From: ckonstanski <carlos.konstanski@olo.com>
Date: Sat, 25 May 2024 18:03:25 -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