initial schema work on linked instances and shared feedbrowser

2 files changed, 39 insertions, 0 deletions

diff --git a/schema/versions/mysql/84.sql b/schema/versions/mysql/84.sql
new file mode 100644
index 000000000..631daa03b
--- /dev/null
+++ b/schema/versions/mysql/84.sql
@@ -0,0 +1,20 @@
+begin;
+
+create table ttrss_linked_instances (id integer not null primary key auto_increment,
+	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..1ff253f73
--- /dev/null
+++ b/schema/versions/pgsql/84.sql
@@ -0,0 +1,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;