blob: 0df2d9aef3054c7fcacff067f2df7dfbb7eeacf0 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
drop table if exists ttrss_plugin_reddit_delay_cache;
create table ttrss_plugin_reddit_delay_cache (id integer not null primary key auto_increment,
feed_id integer not null REFERENCES ttrss_feeds(id) on DELETE cascade,
link text not null,
item text not NULL,
orig_ts datetime not null) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
create index ttrss_plugin_reddit_delay_cache_link_idx on ttrss_plugin_reddit_delay_cache(link);
create index ttrss_plugin_reddit_delay_cache_feed_id_idx on ttrss_plugin_reddit_delay_cache(feed_id);
create unique index ttrss_plugin_reddit_delay_cache_idx on ttrss_plugin_reddit_delay_cache(feed_id, link);
|