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/107.sql
CREATE OR REPLACE FUNCTION public.insert_similar_hash_missing_units_func( user_id integer )
  RETURNS void
  LANGUAGE plpgsql
AS $$
BEGIN
  INSERT INTO similar_hash (id_unit, id_user, takentime, is_major, id_item)
  SELECT unit.id, unit.id_user, unit.takentime, unit.is_major, unit.id_item
  FROM unit LEFT JOIN similar_hash
  ON unit.id = similar_hash.id_unit
  WHERE similar_hash.id_unit IS NULL and unit.id_user = user_id;
END;
$$;