ALTER TABLE public.face
  ADD COLUMN IF NOT EXISTS is_manual BOOLEAN NOT NULL DEFAULT FALSE,
	ALTER COLUMN feature DROP NOT NULL,
	ALTER COLUMN landmark DROP NOT NULL;
ALTER TABLE public.person_group
  ADD COLUMN IF NOT EXISTS is_manual BOOLEAN NOT NULL DEFAULT FALSE,
  ALTER COLUMN feature DROP NOT NULL;
ALTER TABLE public.cluster
  ADD COLUMN IF NOT EXISTS is_manual BOOLEAN NOT NULL DEFAULT FALSE;
CREATE INDEX IF NOT EXISTS id_person_score_id_idx ON public.face USING btree (
    id_person ASC NULLS LAST,
    score DESC NULLS LAST,
    id ASC NULLS LAST
);
DROP INDEX IF EXISTS public.id_person_id_unit_score_idx;