From df659891ac0597c3f58b7714ddd4103ccad66b07 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Tue, 4 Aug 2015 13:32:52 +0300 Subject: implement per-feed stemming language setting --- schema/ttrss_schema_mysql.sql | 1 + schema/ttrss_schema_pgsql.sql | 1 + schema/versions/mysql/128.sql | 5 +++++ schema/versions/pgsql/128.sql | 5 +++++ 4 files changed, 12 insertions(+) (limited to 'schema') 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; -- cgit v1.2.3