ALTER TABLE public.album
  ADD COLUMN name_for_sort text NOT NULL DEFAULT '';
UPDATE public.album
  SET name_for_sort = name;
CREATE OR REPLACE VIEW public.album_with_share_info_view
AS
SELECT
  album.id as id,
  album.id_user as id_user,
  album.name as name,
  album.type as type,
  album.create_time as create_time,
  album.start_time as start_time,
  share.privacy_type as privacy_type,
  share.enable as enable,
  album.passphrase_share as passphrase_share,
  normal_album.status as status,
  album.name_for_sort as name_for_sort
FROM
  album LEFT JOIN share
ON album.passphrase_share = share.passphrase
  LEFT JOIN normal_album
ON album.passphrase_share = normal_album.passphrase_share;
CREATE OR REPLACE VIEW public.share_album_view
AS
SELECT album.id,
    album.id_user,
    album.name,
    album.type,
    album.shared,
    album.create_time,
    album.cover,
    album.sort_by,
    album.sort_direction,
    album.passphrase_share,
    album.version,
    album.item_count,
    share.modified_time,
    album.normalized_name,
    album.start_time,
    album.end_time,
    album.name_for_sort
FROM album, share
WHERE album.passphrase_share = share.passphrase;