summaryrefslogtreecommitdiff
path: root/sql/pgsql/migrations/105.sql
blob: 11ef679f1870258d1ef34c0b339e4f6b67faca2d (plain)
1
2
3
4
5
6
7
8
9
10
11
begin;

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

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;