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/21.sql
ALTER TABLE public.unit ADD CONSTRAINT unit_uk UNIQUE (id, id_user);
ALTER TABLE public.filter ADD CONSTRAINT composite_unit_fk FOREIGN KEY (id_unit, id_user) REFERENCES unit (id, id_user) MATCH FULL ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE public.face ADD CONSTRAINT composite_unit_fk FOREIGN KEY (ref_id_unit, id_user) REFERENCES unit (id, id_user) MATCH FULL ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE public.address ADD CONSTRAINT composite_unit_fk FOREIGN KEY (id_unit, id_user) REFERENCES unit (id, id_user) MATCH FULL ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE public.one_filter_has_many_unit ADD CONSTRAINT composite_unit_fk FOREIGN KEY (id_unit, id_user) REFERENCES unit (id, id_user) MATCH FULL ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE public.many_unit_has_many_person ADD CONSTRAINT composite_unit_fk FOREIGN KEY (id_unit, id_user) REFERENCES unit (id, id_user) MATCH FULL ON UPDATE CASCADE ON DELETE CASCADE;