schema/versions/pgsql/105.sql

   1 begin;
   2
   3 alter table ttrss_user_entries add column last_marked timestamp;
   4 alter table ttrss_user_entries add column last_published timestamp;
   5
   6 update ttrss_user_entries set last_published = last_read where published = true;
   7 update ttrss_user_entries set last_marked = last_read where marked = true;
   8
   9 update ttrss_version set schema_version = 105;
  10
  11 commit;