DROP VIEW IF EXISTS public.person_album_view;
ALTER TABLE public.person
  ALTER COLUMN id_user TYPE integer;
CREATE VIEW public.person_album_view AS
  SELECT person_item_count.id_person,
    person.id_user,
    person.name,
    person.hidden,
    person.cover,
    person_item_count.item_count,
    person.normalized_name
   FROM person,
    person_item_count
  WHERE person_item_count.id_person = person.id AND person_item_count.id_user = person.id_user;