From 58fa1bbc00f1e8ba48ea30332d61bbbe99c21398 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@madoka.volgo-balt.ru>
Date: Wed, 20 Apr 2011 11:40:41 +0400
Subject: initial schema work on linked instances and shared feedbrowser

---
 schema/versions/pgsql/84.sql | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)
 create mode 100644 schema/versions/pgsql/84.sql

(limited to 'schema/versions/pgsql/84.sql')

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;
-- 
cgit v1.2.3


From afb875ccd704dec355b73eecb2ded23f047414d8 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@madoka.volgo-balt.ru>
Date: Wed, 20 Apr 2011 12:06:30 +0400
Subject: add rpc method to export feedbrowser data; update schema

---
 schema/versions/pgsql/84.sql | 1 +
 1 file changed, 1 insertion(+)

(limited to 'schema/versions/pgsql/84.sql')

diff --git a/schema/versions/pgsql/84.sql b/schema/versions/pgsql/84.sql
index 1ff253f73..77212317b 100644
--- a/schema/versions/pgsql/84.sql
+++ b/schema/versions/pgsql/84.sql
@@ -1,6 +1,7 @@
 begin;
 
 create table ttrss_linked_instances (id serial not null primary key,
+	last_connected datetime not null,
 	access_key varchar(250) not null,
 	access_url text not null);
 
-- 
cgit v1.2.3


From cfc0647184933b042b9929ede09f52e7d3f3318f Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@madoka.volgo-balt.ru>
Date: Wed, 20 Apr 2011 14:46:53 +0400
Subject: schema: add status codes

---
 schema/versions/pgsql/84.sql | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'schema/versions/pgsql/84.sql')

diff --git a/schema/versions/pgsql/84.sql b/schema/versions/pgsql/84.sql
index 77212317b..56c3359c5 100644
--- a/schema/versions/pgsql/84.sql
+++ b/schema/versions/pgsql/84.sql
@@ -2,6 +2,8 @@ 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);
 
-- 
cgit v1.2.3

