summaryrefslogtreecommitdiff
path: root/schema/versions/mysql/5.sql
blob: e3ddb0357c4f00e24d8f49527578e7db74f86151 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
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;