26 lines
737 B
MySQL
26 lines
737 B
MySQL
|
-- ============================================
|
|||
|
|
-- 此文件由 Meoo Cloud 自动生成，请勿修改
|
|||
|
|
-- This file is auto-generated by Meoo Cloud, DO NOT MODIFY
|
|||
|
|
-- ============================================
|
|||
|
|
|
|||
|
|
|
|||
|
|
-- 创建自动检查分享链接过期的函数
|
|||
|
|
CREATE OR REPLACE FUNCTION public.check_share_links_expired()
|
|||
|
|
RETURNS void
|
|||
|
|
LANGUAGE plpgsql
|
|||
|
|
SECURITY DEFINER
|
|||
|
|
AS $function$
|
|||
|
|
BEGIN
|
|||
|
|
-- 更新已过期的分享链接状态
|
|||
|
|
UPDATE share_links
|
|||
|
|
SET status = 'expired'
|
|||
|
|
WHERE status IN ('pending', 'clicked')
|
|||
|
|
AND expires_at < NOW();
|
|||
|
|
END;
|
|||
|
|
$function$;
|
|||
|
|
|
|||
|
|
-- 创建定时触发器（每小时检查一次）
|
|||
|
|
-- 注意：Supabase 不支持 pg_cron 扩展，需要在应用层调用此函数
|
|||
|
|
-- 或者使用 Edge Function 定时任务
|
|||
|
|
|