[tt-rss.git] / schema / upgrade-1.1.2-1.1.3-mysql.sql

begin;

create table ttrss_scheduled_updates (id integer not null primary key auto_increment,
	owner_uid integer not null,
	feed_id integer default null,
	entered datetime not null,
	foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE,
	foreign key (feed_id) references ttrss_feeds(id) ON DELETE CASCADE) TYPE=InnoDB;

update ttrss_version set schema_version = 5;

commit;
Commit	Line	Data
b4548c32 AD	1	begin;
	2
	3	create table ttrss_scheduled_updates (id integer not null primary key auto_increment,
	4	owner_uid integer not null,
	5	feed_id integer default null,
	6	entered datetime not null,
	7	foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE,
	8	foreign key (feed_id) references ttrss_feeds(id) ON DELETE CASCADE) TYPE=InnoDB;
	9
	10	update ttrss_version set schema_version = 5;
	11
	12	commit;