UPDATE album SET shared = 'f' WHERE passphrase_share NOT in (SELECT passphrase FROM share);
UPDATE album SET passphrase_share = NULL WHERE passphrase_share NOT in (SELECT passphrase FROM share);
ALTER TABLE public.normal_album ADD CONSTRAINT share_fk FOREIGN KEY (passphrase_share)
REFERENCES public.share (passphrase) MATCH FULL
ON DELETE SET NULL ON UPDATE CASCADE;
ALTER TABLE public.condition_album ADD CONSTRAINT share_fk FOREIGN KEY (passphrase_share)
REFERENCES public.share (passphrase) MATCH FULL
ON DELETE SET NULL ON UPDATE CASCADE;