implement per-feed stemming language setting

4 files changed, 12 insertions, 0 deletions

diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql
index 09234369e..8a6f7d681 100644
--- a/schema/ttrss_schema_mysql.sql
+++ b/schema/ttrss_schema_mysql.sql
@@ -127,6 +127,7 @@ create table ttrss_feeds (id integer not null auto_increment primary key,
 	view_settings varchar(250) not null default '',
 	pubsub_state integer not null default 0,
 	favicon_last_checked datetime default null,
+	feed_language varchar(100) not null default '',
 	foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE,
 	foreign key (cat_id) references ttrss_feed_categories(id) ON DELETE SET NULL,
 	foreign key (parent_feed) references ttrss_feeds(id) ON DELETE SET NULL) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql
index 4cdc15f9a..9dafa693e 100644
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -96,6 +96,7 @@ create table ttrss_feeds (id serial not null primary key,
 	view_settings varchar(250) not null default '',
 	pubsub_state integer not null default 0,
 	favicon_last_checked timestamp default null,
+	feed_language varchar(100) not null default '',
 	auth_pass_encrypted boolean not null default false);
 
 create index ttrss_feeds_owner_uid_index on ttrss_feeds(owner_uid);
diff --git a/schema/versions/mysql/128.sql b/schema/versions/mysql/128.sql
index 0545cb3ae..0a4d7ab7c 100644
--- a/schema/versions/mysql/128.sql
+++ b/schema/versions/mysql/128.sql
@@ -1,5 +1,10 @@
 BEGIN;
 
+alter table ttrss_feeds add column feed_language varchar(100);
+update ttrss_feeds set feed_language = '';
+alter table ttrss_feeds change feed_language feed_language varchar(100) not null;
+alter table ttrss_feeds alter column feed_language set default '';
+
 UPDATE ttrss_version SET schema_version = 128;
 
 COMMIT;
diff --git a/schema/versions/pgsql/128.sql b/schema/versions/pgsql/128.sql
index d85ce7fe9..3aba67220 100644
--- a/schema/versions/pgsql/128.sql
+++ b/schema/versions/pgsql/128.sql
@@ -3,6 +3,11 @@ BEGIN;
 alter table ttrss_entries add column tsvector_combined tsvector;
 create index ttrss_entries_tsvector_combined_idx on ttrss_entries using gin(tsvector_combined);
 
+alter table ttrss_feeds add column feed_language varchar(100);
+update ttrss_feeds set feed_language = '';
+alter table ttrss_feeds alter column feed_language set not null;
+alter table ttrss_feeds alter column feed_language set default '';
+
 UPDATE ttrss_version SET schema_version = 128;
 
 COMMIT;