summaryrefslogtreecommitdiff
path: root/schema/versions/pgsql/60.sql
blob: 39a2e202b1a56bfe585504c5696c579b970289ec (plain)
1
2
3
4
5
6
7
8
9
10
11
12
begin;

alter table ttrss_user_entries alter column feed_id drop not null;

alter table ttrss_user_entries add column orig_feed_id integer;
update ttrss_user_entries set orig_feed_id = NULL;

alter table ttrss_user_entries add constraint "$4" FOREIGN KEY (orig_feed_id) REFERENCES ttrss_feeds(id) ON DELETE SET NULL;

update ttrss_version set schema_version = 60;

commit;