CREATE TABLE public.team_library_folder_has_many_sorting(
  id_user integer NOT NULL,
  id_folder integer NOT NULL,
  sort_by int2 NOT NULL DEFAULT 0,
  sort_direction int2 NOT NULL DEFAULT 0,
  CONSTRAINT team_library_folder_sorting_pk PRIMARY KEY (id_user,id_folder)
);
ALTER TABLE public.team_library_folder_has_many_sorting 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.team_library_folder_has_many_sorting ADD CONSTRAINT folder_fk FOREIGN KEY (id_folder)
REFERENCES public.folder (id) MATCH FULL
ON DELETE CASCADE ON UPDATE CASCADE;