CREATE TABLE IF NOT EXISTS public.convert_thumbnail_allocation
(
  session_id TEXT NOT NULL,
  sent_to_client BOOLEAN NOT NULL,
  id INTEGER NOT NULL,
  id_user INTEGER NOT NULL,
  filename TEXT NOT NULL,
  unit_type SMALLINT NOT NULL,
  item_type SMALLINT NOT NULL,
  status SMALLINT NOT NULL,
  lower_extension TEXT NOT NULL,
  thumbnail_type INTEGER[] NOT NULL,
  created_at TIMESTAMP NOT NULL DEFAULT now(),
  CONSTRAINT convert_thumbnail_allocation_pkey PRIMARY KEY (session_id, id),
  CONSTRAINT convert_thumbnail_allocation_unit_fkey FOREIGN KEY (id, id_user) REFERENCES public.unit (id, id_user) ON DELETE CASCADE ON UPDATE CASCADE
);
DROP INDEX IF EXISTS convert_thumbnail_allocation_list_idx;
CREATE INDEX IF NOT EXISTS convert_thumbnail_allocation_list_idx ON public.convert_thumbnail_allocation
(
  id_user,
  session_id
);
DROP INDEX IF EXISTS convert_thumbnail_allocation_id_idx;
CREATE INDEX IF NOT EXISTS convert_thumbnail_allocation_id_idx ON public.convert_thumbnail_allocation
(
  id_user,
  id
);
DROP INDEX IF EXISTS convert_thumbnail_allocation_created_at_idx;
CREATE INDEX IF NOT EXISTS convert_thumbnail_allocation_created_at_idx ON public.convert_thumbnail_allocation
(
  created_at
);