CREATE OR REPLACE VIEW public.recently_added_timeline_view
AS
SELECT
  unit.id_item,
  unit.id_user,
  unit.item_type,
  unit.type AS unit_type,
  unit.createtime/1000 as createtime,
  unit.id AS id_unit
FROM unit
WHERE unit.is_major = true AND unit.createtime > (extract(epoch from now())-2592000)*1000;