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

alter table ttrss_entries add column date_updated timestamp;
update ttrss_entries set date_updated = date_entered;
alter table ttrss_entries alter column date_updated set not null;

update ttrss_version set schema_version = 67;

commit;