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

drop table if exists ttrss_counters_cache;

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

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

update ttrss_version set schema_version = 50;
Commit	Line	Data
8a4c759e AD	1	drop table if exists ttrss_counters_cache;
	2
	3	create table ttrss_counters_cache (
	4	feed_id integer not null,
	5	owner_uid integer not null,
	6	value integer not null default 0,
	7	updated datetime not null,
	8	foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE
	9	);
	10
	11	create table ttrss_cat_counters_cache (
	12	feed_id integer not null,
	13	owner_uid integer not null,
	14	value integer not null default 0,
	15	updated datetime not null,
	16	foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE
	17	);
	18
	19	update ttrss_version set schema_version = 50;