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

begin;

create table ttrss_scheduled_updates (id serial not null primary key,
	owner_uid integer not null references ttrss_users(id) ON DELETE CASCADE,
	feed_id integer default null references ttrss_feeds(id) ON DELETE CASCADE,
	entered timestamp not null default NOW());

update ttrss_version set schema_version = 5;

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