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
);