schema/versions/mysql/84.sql

   1 begin;
   2
   3 create table ttrss_linked_instances (id integer not null primary key auto_increment,
   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) TYPE=InnoDB DEFAULT CHARSET=UTF8;
   9
  10 create 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,
  17         foreign key (instance_id) references ttrss_linked_instances(id) ON DELETE CASCADE) TYPE=InnoDB DEFAULT CHARSET=UTF8;
  18
  19 drop table ttrss_scheduled_updates;
  20
  21 update ttrss_version set schema_version = 84;
  22
  23 commit;