5.sql 392 B

123456789101112
  1. begin;
  2. create table ttrss_scheduled_updates (id integer not null primary key auto_increment,
  3. owner_uid integer not null,
  4. feed_id integer default null,
  5. entered datetime not null,
  6. foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE,
  7. foreign key (feed_id) references ttrss_feeds(id) ON DELETE CASCADE) ENGINE=InnoDB;
  8. update ttrss_version set schema_version = 5;
  9. commit;