localization fixes and updates (bumps schema)

4 files changed, 10 insertions, 6 deletions

diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql
index e55038b7f..dfa489c42 100644
--- a/schema/ttrss_schema_mysql.sql
+++ b/schema/ttrss_schema_mysql.sql
@@ -196,7 +196,7 @@ create table ttrss_tags (id integer primary key auto_increment,
 
 create table ttrss_version (schema_version int not null) TYPE=InnoDB;
 
-insert into ttrss_version values (19);
+insert into ttrss_version values (20);
 
 create table ttrss_prefs_types (id integer not null primary key, 
 	type_name varchar(100) not null) TYPE=InnoDB;
@@ -234,8 +234,7 @@ insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_
    'Default limit for articles to display, any custom number you like (0 - disables).');
 
 insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('ALLOW_DUPLICATE_POSTS', 1, 'true', 'Allow duplicate posts',1,
-	'This option is useful when you are reading several planet-type aggregators with partially colliding userbase. 
-	When disabled, it forces same posts from different feeds to appear only once.');
+	'This option is useful when you are reading several planet-type aggregators with partially colliding userbase. When disabled, it forces same posts from different feeds to appear only once.');
 
 insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('USER_STYLESHEET_URL', 2, '', 'User stylesheet URL',2,
 	'Link to user stylesheet to override default style, disabled if empty.');
diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql
index abf74b7ed..f7ad3e4bb 100644
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -177,7 +177,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 (19);
+insert into ttrss_version values (20);
 
 create table ttrss_prefs_types (id integer not null primary key, 
 	type_name varchar(100) not null);
@@ -211,8 +211,7 @@ insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_
 	'Default limit for articles to display, any custom number you like (0 - disables).');
 
 insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('ALLOW_DUPLICATE_POSTS', 1, 'true', 'Allow duplicate posts',1,
-	'This option is useful when you are reading several planet-type aggregators with partially colliding userbase. 
-	When disabled, it forces same posts from different feeds to appear only once.');
+	'This option is useful when you are reading several planet-type aggregators with partially colliding userbase. When disabled, it forces same posts from different feeds to appear only once.');
 
 insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('USER_STYLESHEET_URL', 2, '', 'User stylesheet URL',2,
 	'Link to user stylesheet to override default style, disabled if empty.');
diff --git a/schema/versions/mysql/20.sql b/schema/versions/mysql/20.sql
new file mode 100644
index 000000000..347654512
--- /dev/null
+++ b/schema/versions/mysql/20.sql
@@ -0,0 +1,3 @@
+UPDATE ttrss_prefs SET help_text = 'This option is useful when you are reading several planet-type aggregators with partially colliding userbase. When disabled, it forces same posts from different feeds to appear only once.' WHERE pref_name = 'ALLOW_DUPLICATE_POSTS';
+
+update ttrss_version set schema_version = 20;
diff --git a/schema/versions/pgsql/20.sql b/schema/versions/pgsql/20.sql
new file mode 100644
index 000000000..347654512
--- /dev/null
+++ b/schema/versions/pgsql/20.sql
@@ -0,0 +1,3 @@
+UPDATE ttrss_prefs SET help_text = 'This option is useful when you are reading several planet-type aggregators with partially colliding userbase. When disabled, it forces same posts from different feeds to appear only once.' WHERE pref_name = 'ALLOW_DUPLICATE_POSTS';
+
+update ttrss_version set schema_version = 20;