summaryrefslogtreecommitdiff
path: root/sql/mysql/migrations/5.sql
blob: 1d8b8537b85767a6a88740b1465f1cc70b4d9187 (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) ENGINE=InnoDB;

update ttrss_version set schema_version = 5;

commit;