]>
git.wh0rd.org - tt-rss.git/blob - schema/versions/pgsql/84.sql
3 create table ttrss_linked_instances (id serial
not null primary key,
4 last_connected
timestamp not null,
5 last_status_in
integer not null,
6 last_status_out
integer not null,
7 access_key
varchar(250) not null unique,
8 access_url
text not null);
10 create table ttrss_linked_feeds (
11 feed_url
text not null,
13 created
timestamp not null,
14 updated
timestamp not null,
15 instance_id
integer not null references ttrss_linked_instances(id) ON DELETE CASCADE,
16 subscribers
integer not null);
18 drop table ttrss_scheduled_updates
;
20 update ttrss_version
set schema_version
= 84;