HEX
Server: Apache/2.4.63 (Unix)
System: Linux Synopilou92 4.4.302+ #72806 SMP Mon Jul 21 23:16:00 CST 2025 x86_64
User: pilou92 (1026)
PHP: 8.0.30
Disabled: NONE
Upload Files
File: /volume1/@appstore/SynologyPhotos/etc/sql/109.sql
CREATE OR REPLACE FUNCTION public.any_user_need_migrate_similar_hash ()
	RETURNS boolean
	LANGUAGE plpgsql
	IMMUTABLE
  CALLED ON NULL INPUT
	SECURITY INVOKER
	COST 1
	AS $$
BEGIN
    RETURN EXISTS (
      SELECT 1 FROM public.user_info
      WHERE user_info.config ->> 'enable_similar' = 'true'
      AND user_info.enable = 'true'
      AND NOT EXISTS (
        SELECT 1 FROM public.user_flag
        WHERE user_info.id = user_flag.id_user
        AND user_flag.flag = 'similar_hash_migration_done'
        AND (user_flag.value = 'true' OR user_flag.value = 'error')
      )
    );
END
$$;