drop table ttrss_entries;
drop table ttrss_scheduled_updates;
drop table ttrss_counters_cache;
+drop table ttrss_cat_counters_cache;
drop table ttrss_feeds;
drop table ttrss_feed_categories;
drop table ttrss_users;
(1, 'Tiny Tiny RSS: Forum', 'http://tt-rss.spb.ru/forum/rss.php');
create table ttrss_counters_cache (
- feed_id integer not null references ttrss_feeds(id) ON DELETE CASCADE,
+ feed_id integer not null,
+ owner_uid integer not null references ttrss_users(id) ON DELETE CASCADE,
+ updated timestamp not null,
+ value integer not null default 0);
+
+create table ttrss_cat_counters_cache (
+ feed_id integer not null,
owner_uid integer not null references ttrss_users(id) ON DELETE CASCADE,
updated timestamp not null,
value integer not null default 0);
create table ttrss_version (schema_version int not null);
-insert into ttrss_version values (49);
+insert into ttrss_version values (50);
create table ttrss_enclosures (id serial not null primary key,
content_url text not null,