summaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
Diffstat (limited to 'schema')
-rw-r--r--schema/ttrss_schema_mysql.sql5
-rw-r--r--schema/ttrss_schema_pgsql.sql7
-rw-r--r--schema/versions/mysql/48.sql6
-rw-r--r--schema/versions/pgsql/48.sql9
4 files changed, 26 insertions, 1 deletions
diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql
index 00e52479a..977e56e8d 100644
--- a/schema/ttrss_schema_mysql.sql
+++ b/schema/ttrss_schema_mysql.sql
@@ -1,6 +1,7 @@
-- SET NAMES utf8;
-- SET CHARACTER SET utf8;
+drop table if exists ttrss_feedbrowser_cache;
drop table if exists ttrss_version;
drop table if exists ttrss_labels;
drop table if exists ttrss_filters;
@@ -375,4 +376,8 @@ create table ttrss_sessions (id varchar(250) unique not null primary key,
index (id),
index (expire)) TYPE=InnoDB;
+create table ttrss_feedbrowser_cache (
+ feed_url text not null,
+ subscribers integer not null);
+
commit;
diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql
index 5d818208d..142a70f95 100644
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -1,3 +1,4 @@
+drop table ttrss_feedbrowser_cache;
drop table ttrss_version;
drop table ttrss_labels;
drop table ttrss_filters;
@@ -199,7 +200,7 @@ create index ttrss_tags_owner_uid_index on ttrss_tags(owner_uid);
create table ttrss_version (schema_version int not null);
-insert into ttrss_version values (47);
+insert into ttrss_version values (48);
create table ttrss_enclosures (id serial not null primary key,
content_url text not null,
@@ -345,4 +346,8 @@ create index ttrss_sessions_expire_index on ttrss_sessions(expire);
create function SUBSTRING_FOR_DATE(timestamp, int, int) RETURNS text AS 'SELECT SUBSTRING(CAST($1 AS text), $2, $3)' LANGUAGE 'sql';
+create table ttrss_feedbrowser_cache (
+ feed_url text not null primary key,
+ subscribers integer not null);
+
commit;
diff --git a/schema/versions/mysql/48.sql b/schema/versions/mysql/48.sql
new file mode 100644
index 000000000..8c42f6e27
--- /dev/null
+++ b/schema/versions/mysql/48.sql
@@ -0,0 +1,6 @@
+create table ttrss_feedbrowser_cache (
+ feed_url text not null,
+ subscribers integer not null);
+
+update ttrss_version set schema_version = 48;
+
diff --git a/schema/versions/pgsql/48.sql b/schema/versions/pgsql/48.sql
new file mode 100644
index 000000000..e3a742ace
--- /dev/null
+++ b/schema/versions/pgsql/48.sql
@@ -0,0 +1,9 @@
+begin;
+
+create table ttrss_feedbrowser_cache (
+ feed_url text not null primary key,
+ subscribers integer not null);
+
+update ttrss_version set schema_version = 48;
+
+commit;