From 07d0efe959e6ee03a7a4d2dca11a69e35a265461 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Thu, 15 Nov 2007 06:41:53 +0100 Subject: new preference: PURGE_UNREAD_ARTICLES (closes #161), fix bug in user purge --- schema/ttrss_schema_pgsql.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'schema/ttrss_schema_pgsql.sql') diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql index c75e210f1..af8f1c54f 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -179,7 +179,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 (25); +insert into ttrss_version values (26); create table ttrss_prefs_types (id integer not null primary key, type_name varchar(100) not null); @@ -279,6 +279,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) values('CDM_EXPANDED', 1, 'true', 'Automatically expand articles in combined mode',3); +insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('PURGE_UNREAD_ARTICLES', 1, 'true', 'Purge unread articles',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, -- cgit v1.2.3