backend: merge with shared-feedbrowser

2 files changed, 45 insertions, 0 deletions

diff --git a/schema/versions/mysql/84.sql b/schema/versions/mysql/84.sql
new file mode 100644
index 000000000..3255d6f56
--- /dev/null
+++ b/schema/versions/mysql/84.sql
@@ -0,0 +1,23 @@
+begin;
+
+create table ttrss_linked_instances (id integer not null primary key auto_increment,
+	last_connected timestamp 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) TYPE=InnoDB DEFAULT CHARSET=UTF8;
+
+create table ttrss_linked_feeds (
+	feed_url text not null,
+	title text not null,
+	created datetime not null,
+	updated datetime not null,
+	instance_id integer not null,
+	subscribers integer not null,
+ 	foreign key (instance_id) references ttrss_linked_instances(id) ON DELETE CASCADE) TYPE=InnoDB DEFAULT CHARSET=UTF8;
+
+drop table ttrss_scheduled_updates;
+
+update ttrss_version set schema_version = 84;
+
+commit;
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;