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

alter table ttrss_user_entries change feed_id feed_id integer 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 FOREIGN KEY (orig_feed_id) REFERENCES ttrss_feeds(id) ON DELETE SET NULL;

update ttrss_version set schema_version = 60;

commit;