summaryrefslogtreecommitdiff
path: root/schema/versions/pgsql/84.sql
blob: 1ff253f730dc07d1331eff066f394d7349d4e54e (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
begin;

create table ttrss_linked_instances (id serial not null primary key,
	access_key varchar(250) not null,
	access_url text not null);

create table ttrss_linked_feeds (
	feed_url text not null,
	title text not null,
	created timestamp not null,
	updated timestamp not null,
	instance_id integer not null references ttrss_linked_instances(id) ON DELETE CASCADE,
	subscribers integer not null);

drop table ttrss_scheduled_updates;

update ttrss_version set schema_version = 84;

commit;