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/30.sql
CREATE TABLE public.folder_operation_task (
  id_folder integer NOT NULL,
  id_task integer NOT NULL,
  CONSTRAINT pk_id_folder PRIMARY KEY (id_folder),
  CONSTRAINT fk_id_task FOREIGN KEY (id_task) REFERENCES background_task(id)
);
ALTER TABLE public.background_task ADD COLUMN payload json;
CREATE TABLE public.folder_operation_error (
  id_task integer NOT NULL,
  target_id integer NOT NULL,
  reason smallint NOT NULL,
  CONSTRAINT pk_folder_operation_error PRIMARY KEY (id_task, target_id),
  CONSTRAINT fk_id_task FOREIGN KEY (id_task) REFERENCES background_task(id)
  MATCH FULL ON UPDATE CASCADE ON DELETE CASCADE
);