]> git.wh0rd.org - tt-rss.git/blame - schema/versions/mysql/84.sql
minor css fixes (mostly for zoom mode)
[tt-rss.git] / schema / versions / mysql / 84.sql
CommitLineData
58fa1bbc
AD
1begin;
2
3create table ttrss_linked_instances (id integer not null primary key auto_increment,
afb875cc 4 last_connected timestamp not null,
cfc06471
AD
5 last_status_in integer not null,
6 last_status_out integer not null,
1eb3012f 7 access_key varchar(250) not null unique,
1aea205c 8 access_url text not null) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
58fa1bbc
AD
9
10create table ttrss_linked_feeds (
11 feed_url text not null,
12 title text not null,
13 created datetime not null,
14 updated datetime not null,
15 instance_id integer not null,
16 subscribers integer not null,
1aea205c 17 foreign key (instance_id) references ttrss_linked_instances(id) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
58fa1bbc
AD
18
19drop table ttrss_scheduled_updates;
20
21update ttrss_version set schema_version = 84;
22
23commit;