ALTER TABLE public.unit
  ADD COLUMN name_for_sort text NOT NULL DEFAULT '';
CREATE OR REPLACE VIEW public.folder_timeline_view
AS
SELECT
  u.id_item,
  u.id_user,
  u.item_type,
  u.type as unit_type,
  u.id AS id_unit,
  u.id_folder AS id_folder,
  u.takentime AS takentime,
  u.filesize,
  u.normalized_filename,
  u.name_for_sort
FROM
  folder f,
  unit u
WHERE f.id = u.id_folder AND u.id_user = f.id_user AND u.is_major = 't';
CREATE OR REPLACE VIEW public.normal_album_photowall_view
AS
SELECT
  M.id_normal_album,
  M.id_item,
  M.item_provider_id_user,
  U.id_unit,
  U.takentime,
  U.filesize,
  U.normalized_filename,
  M.sequence,
  M.album_id_user AS id_user,
  I.type AS item_type,
  U.name_for_sort
FROM
  many_item_has_many_normal_album M,
  item I,
  (SELECT
    id_item,
    id AS id_unit,
    takentime,
    filesize,
    normalized_filename,
    name_for_sort
  FROM unit WHERE is_major = 't') AS U
WHERE U.id_item = M.id_item and I.id = M.id_item;