From 724d74449823765060650e035fbb8672e22c800b Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Tue, 6 Mar 2007 07:24:25 +0100 Subject: [PATCH] update schema --- schema/ttrss_schema_mysql.sql | 5 ++++- schema/ttrss_schema_pgsql.sql | 5 ++++- schema/versions/mysql/14.sql | 2 +- schema/versions/pgsql/14.sql | 2 +- 4 files changed, 10 insertions(+), 4 deletions(-) diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index a8747321..0fd7cafd 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -188,7 +188,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 (13); +insert into ttrss_version values (14); create table ttrss_prefs_types (id integer not null primary key, type_name varchar(100) not null) TYPE=InnoDB; @@ -264,6 +264,9 @@ insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_ insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('CONFIRM_FEED_CATCHUP', 1, 'true', 'Confirm marking feed as read',3); +insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('CDM_AUTO_CATCHUP', 1, 'false', 'Mark articles as read automatically',2, +'This option enables marking articles as read automatically in combined mode while you scroll article list'); + create table ttrss_user_prefs ( owner_uid integer not null, pref_name varchar(250), diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql index 84e6ee51..363af512 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -172,7 +172,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 (13); +insert into ttrss_version values (14); create table ttrss_prefs_types (id integer not null primary key, type_name varchar(100) not null); @@ -244,6 +244,9 @@ insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_ insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('CONFIRM_FEED_CATCHUP', 1, 'true', 'Confirm marking feed as read',3); +insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('CDM_AUTO_CATCHUP', 1, 'false', 'Mark articles as read automatically',2, +'This option enables marking articles as read automatically in combined mode while you scroll article list'); + create table ttrss_user_prefs ( owner_uid integer not null references ttrss_users(id) ON DELETE CASCADE, pref_name varchar(250) not null references ttrss_prefs(pref_name) ON DELETE CASCADE, diff --git a/schema/versions/mysql/14.sql b/schema/versions/mysql/14.sql index 10002286..029e7f3e 100644 --- a/schema/versions/mysql/14.sql +++ b/schema/versions/mysql/14.sql @@ -1,4 +1,4 @@ -insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('CDM_AUTO_CATCHUP', 1, 'false', 'Mark articles as read automatically',1, +insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('CDM_AUTO_CATCHUP', 1, 'false', 'Mark articles as read automatically',2, 'This option enables marking articles as read automatically in combined mode while you scroll article list'); update ttrss_version set schema_version = 14; diff --git a/schema/versions/pgsql/14.sql b/schema/versions/pgsql/14.sql index 10002286..029e7f3e 100644 --- a/schema/versions/pgsql/14.sql +++ b/schema/versions/pgsql/14.sql @@ -1,4 +1,4 @@ -insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('CDM_AUTO_CATCHUP', 1, 'false', 'Mark articles as read automatically',1, +insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('CDM_AUTO_CATCHUP', 1, 'false', 'Mark articles as read automatically',2, 'This option enables marking articles as read automatically in combined mode while you scroll article list'); update ttrss_version set schema_version = 14; -- 2.39.5