File: /volume1/@appstore/SynologyPhotos/etc/sql/122.sql
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;
ALTER TABLE IF EXISTS public.person_migration
ALTER COLUMN id_user TYPE integer;