]>
git.wh0rd.org - tt-rss.git/blob - schema/versions/mysql/84.sql
631daa03b4bb56068632b0494277c4fec4bdf83e
3 create table ttrss_linked_instances (id integer not null primary key auto_increment
,
4 access_key
varchar(250) not null,
5 access_url
text not null) TYPE=InnoDB
DEFAULT CHARSET
=UTF8
;
7 create table ttrss_linked_feeds (
8 feed_url
text not null,
10 created datetime
not null,
11 updated datetime
not null,
12 instance_id
integer not null,
13 subscribers
integer not null,
14 foreign key (instance_id
) references ttrss_linked_instances(id) ON DELETE CASCADE) TYPE=InnoDB
DEFAULT CHARSET
=UTF8
;
16 drop table ttrss_scheduled_updates
;
18 update ttrss_version
set schema_version
= 84;