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/46.sql
CREATE TABLE public.motion_photo_additional(
  duration int8 NOT NULL,
  video_info json NOT NULL,
  audio_info json NOT NULL,
  id_unit integer,
  CONSTRAINT motion_photo_additional_uq UNIQUE (id_unit)
);
ALTER TABLE public.motion_photo_additional ADD CONSTRAINT unit_fk FOREIGN KEY (id_unit)
REFERENCES public.unit (id) MATCH FULL
ON DELETE CASCADE ON UPDATE CASCADE;