File: /volume1/@appstore/SynologyPhotos/etc/sql/24.sql
CREATE TABLE IF NOT EXISTS public.person_migration_mapping(
id_user integer NOT NULL,
id_person_source integer NOT NULL,
id_person integer NOT NULL,
named_by_migration boolean NOT NULL,
CONSTRAINT person_migration_mapping_primary PRIMARY KEY (id_user, id_person_source)
);
ALTER TABLE public.person_migration_mapping ADD CONSTRAINT id_user_fk FOREIGN KEY (id_user)
REFERENCES public.user_info (id) MATCH FULL
ON DELETE CASCADE ON UPDATE CASCADE;
DROP TABLE IF EXISTS public.moments_person_migration_mapping;