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/56.sql
CREATE TABLE IF NOT EXISTS public.thumbnail_version (
  id_user integer NOT NULL,
  id_unit integer NOT NULL,
  version bigint NOT NULL,
  sm_size_hash text NOT NULL DEFAULT '',
  PRIMARY KEY (id_unit)
);
ALTER TABLE
  public.thumbnail_version
ADD
  CONSTRAINT composite_unit_fk FOREIGN KEY (id_unit, id_user) REFERENCES unit (id, id_user) MATCH FULL ON DELETE CASCADE ON UPDATE CASCADE;