tt-rss/schema/versions/mysql/105.sql

begin;

alter table ttrss_user_entries add column last_marked datetime;
alter table ttrss_user_entries add column last_published datetime;

update ttrss_user_entries set last_published = last_read where published = true;
update ttrss_user_entries set last_marked = last_read where marked = true;

update ttrss_version set schema_version = 105;

commit;