add tag cache for user_entries (bump schema)

4 files changed, 14 insertions, 2 deletions

diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql
index da73cedd4..527957038 100644
--- a/schema/ttrss_schema_mysql.sql
+++ b/schema/ttrss_schema_mysql.sql
@@ -151,6 +151,7 @@ create table ttrss_user_entries (
 	owner_uid integer not null,
 	marked bool not null default 0,
 	published bool not null default 0,
+	tag_cache text not null,
 	last_read datetime,
 	score int not null default 0,
 	note longtext,
@@ -244,7 +245,7 @@ create table ttrss_tags (id integer primary key auto_increment,
 
 create table ttrss_version (schema_version int not null) TYPE=InnoDB DEFAULT CHARSET=UTF8;
 
-insert into ttrss_version values (71);
+insert into ttrss_version values (72);
 
 create table ttrss_enclosures (id integer primary key auto_increment,
 	content_url text not null,
diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql
index 3583639c6..29c82c0d2 100644
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -137,6 +137,7 @@ create table ttrss_user_entries (
 	owner_uid integer not null references ttrss_users(id) ON DELETE CASCADE,
 	marked boolean not null default false,
 	published boolean not null default false,
+	tag_cache text not null,
 	last_read timestamp,
 	score int not null default 0,
 	note text,
@@ -216,7 +217,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 (71);
+insert into ttrss_version values (72);
 
 create table ttrss_enclosures (id serial not null primary key,
 	content_url text not null,
diff --git a/schema/versions/mysql/72.sql b/schema/versions/mysql/72.sql
new file mode 100644
index 000000000..c9b74bae2
--- /dev/null
+++ b/schema/versions/mysql/72.sql
@@ -0,0 +1,5 @@
+alter table ttrss_user_entries add column tag_cache text;
+update ttrss_user_entries set tag_cache = '';
+alter table ttrss_user_entries change tag_cache tag_cache text not null;
+
+update ttrss_version set schema_version = 72;
diff --git a/schema/versions/pgsql/72.sql b/schema/versions/pgsql/72.sql
new file mode 100644
index 000000000..7b260b3d1
--- /dev/null
+++ b/schema/versions/pgsql/72.sql
@@ -0,0 +1,5 @@
+alter table ttrss_user_entries add column tag_cache text;
+update ttrss_user_entries set tag_cache = '';
+alter table ttrss_user_entries alter column tag_cache set not null;
+
+update ttrss_version set schema_version = 72;