summaryrefslogtreecommitdiff
path: root/schema/versions/pgsql/50.sql
blob: 86846242c6c9e978ded4309e6cafb5ef5de2ac48 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
begin;

drop table ttrss_counters_cache;

create table ttrss_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_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);

update ttrss_version set schema_version = 50;

commit;