CREATE TABLE public.photo_request(
  passphrase_share text NOT NULL,
  id_user integer NOT NULL,
  modified_time bigint NOT NULL,
  filesize_limit bigint NOT NULL DEFAULT 0,
  subject text NOT NULL,
  description text NOT NULL DEFAULT '',
  id_album integer,
  album_passphrase_share text,
  folder_id_user integer NOT NULL,
  folder_home_path text NOT NULL,
  CONSTRAINT photo_request_primary PRIMARY KEY (passphrase_share)
);
ALTER TABLE public.photo_request ADD CONSTRAINT passphrase_share_fk FOREIGN KEY (passphrase_share)
REFERENCES public.share (passphrase) MATCH FULL
ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE public.photo_request ADD CONSTRAINT id_album_fk FOREIGN KEY (id_album)
REFERENCES public.normal_album (id) MATCH FULL
ON DELETE SET NULL ON UPDATE CASCADE;
ALTER TABLE public.photo_request ADD CONSTRAINT album_passphrase_share_fk FOREIGN KEY (album_passphrase_share)
REFERENCES public.share (passphrase) MATCH FULL
ON DELETE SET NULL ON UPDATE CASCADE;
ALTER TABLE public.photo_request ADD CONSTRAINT id_user_fk FOREIGN KEY (id_user)
REFERENCES public.user_info (id) MATCH FULL
ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE public.photo_request ADD CONSTRAINT folder_id_user_fk FOREIGN KEY (id_user)
REFERENCES public.user_info (id) MATCH FULL
ON DELETE CASCADE ON UPDATE CASCADE;