From f6d6e22ff49d44986f2bbf0e82e0b56a4d7a04ff Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Mon, 28 Aug 2006 05:03:26 +0100 Subject: new option: CONFIRM_FEED_CATCHUP (closes #106) --- schema/ttrss_schema_mysql.sql | 2 ++ schema/ttrss_schema_pgsql.sql | 2 ++ schema/upgrade-1.2.2-1.2.3-mysql.sql | 2 ++ schema/upgrade-1.2.2-1.2.3-pgsql.sql | 2 ++ 4 files changed, 8 insertions(+) (limited to 'schema') diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index 961abe811..50c3013fb 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -263,6 +263,8 @@ insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) valu insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('DIGEST_ENABLE', 1, 'false', 'Enable e-mail digest',1, 'This option enables sending daily digest of new (and unread) headlines on your configured e-mail address'); +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); + 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 b08644581..9b4988bbb 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -243,6 +243,8 @@ insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) valu insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('DIGEST_ENABLE', 1, 'false', 'Enable e-mail digest',1, 'This option enables sending daily digest of new (and unread) headlines on your configured e-mail address'); +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); + 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/upgrade-1.2.2-1.2.3-mysql.sql b/schema/upgrade-1.2.2-1.2.3-mysql.sql index 5839e8faa..e951f482f 100644 --- a/schema/upgrade-1.2.2-1.2.3-mysql.sql +++ b/schema/upgrade-1.2.2-1.2.3-mysql.sql @@ -6,5 +6,7 @@ update ttrss_feeds set include_in_digest = true; alter table ttrss_feeds change include_in_digest include_in_digest bool not null; alter table ttrss_feeds alter column include_in_digest set default true; +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); + update ttrss_version set schema_version = 10; diff --git a/schema/upgrade-1.2.2-1.2.3-pgsql.sql b/schema/upgrade-1.2.2-1.2.3-pgsql.sql index 9f292ec3d..764b4b763 100644 --- a/schema/upgrade-1.2.2-1.2.3-pgsql.sql +++ b/schema/upgrade-1.2.2-1.2.3-pgsql.sql @@ -6,5 +6,7 @@ update ttrss_feeds set include_in_digest = true; alter table ttrss_feeds alter column include_in_digest set not null; alter table ttrss_feeds alter column include_in_digest set default true; +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); + update ttrss_version set schema_version = 10; -- cgit v1.2.3