token_cleanup cron_job_supabase_sql.txt

CREATE OR REPLACE FUNCTION delete_expired_sessions() 
RETURNS void AS $$
BEGIN
    DELETE FROM sessions 
    WHERE expires < NOW();
END;
$$ LANGUAGE plpgsql;

CREATE EXTENSION IF NOT EXISTS pg_cron;

SELECT cron.schedule('0 0 * * *', 'SELECT delete_expired_sessions();');