[tt-rss.git] / schema / versions / mysql / 44.sql

create table ttrss_counters_cache (
	feed_id integer not null,
	owner_uid integer not null,
	value integer not null default 0,
	foreign key (feed_id) references ttrss_feeds(id) ON DELETE CASCADE,
	foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE
);

update ttrss_version set schema_version = 44;
Commit	Line	Data
4d736378 AD	1	create table ttrss_counters_cache (
	2	feed_id integer not null,
	3	owner_uid integer not null,
	4	value integer not null default 0,
	5	foreign key (feed_id) references ttrss_feeds(id) ON DELETE CASCADE,
	6	foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE
	7	);
	8
	9	update ttrss_version set schema_version = 44;