schema/versions/pgsql/84.sql

   1 begin;
   2
   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,
   8         access_url text not null);
   9
  10 create table ttrss_linked_feeds (
  11         feed_url text not null,
  12         title 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);
  17
  18 drop table ttrss_scheduled_updates;
  19
  20 update ttrss_version set schema_version = 84;
  21
  22 commit;