backend: merge with shared-feedbrowser

1 files changed, 22 insertions, 0 deletions

diff --git a/schema/versions/pgsql/84.sql b/schema/versions/pgsql/84.sql
new file mode 100644
index 000000000..56c3359c5
--- /dev/null
+++ b/schema/versions/pgsql/84.sql
@@ -0,0 +1,22 @@
+begin;
+
+create table ttrss_linked_instances (id serial not null primary key,
+	last_connected datetime not null,
+	last_status_in integer not null,
+	last_status_out integer not null,
+	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;