3 alter table ttrss_user_entries change feed_id feed_id
integer null;
5 create table ttrss_archived_feeds (id integer not null primary key,
6 owner_uid
integer not null,
7 title
varchar(200) not null,
8 feed_url
text not null,
9 site_url
varchar(250) not null default '',
11 foreign key (owner_uid
) references ttrss_users(id) ON DELETE CASCADE) TYPE=InnoDB
;
13 alter table ttrss_user_entries
add column orig_feed_id
integer;
14 update ttrss_user_entries
set orig_feed_id
= NULL;
16 alter table ttrss_user_entries
add constraint FOREIGN KEY (orig_feed_id
) REFERENCES ttrss_archived_feeds(id) ON DELETE SET NULL;
18 update ttrss_version
set schema_version
= 60;