summaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2006-01-05 16:12:40 +0100
committerAndrew Dolgov <[email protected]>2006-01-05 16:12:40 +0100
commit7f123cdab43e1d8087481958155304dac5fd2c64 (patch)
treea4b7aa94ee609e13f3c846d774a3c39e613863ac /schema
parent13b983335588e7871035f15260ce819e5c0d381e (diff)
new option: HIDE_READ_FEEDS (+ pref setting RPC calls) (closes #23)
Diffstat (limited to 'schema')
-rw-r--r--schema/ttrss_schema_mysql.sql2
-rw-r--r--schema/ttrss_schema_pgsql.sql2
-rw-r--r--schema/upgrade-1.1.1-1.1.2-mysql.sql2
-rw-r--r--schema/upgrade-1.1.1-1.1.2-pgsql.sql2
4 files changed, 8 insertions, 0 deletions
diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql
index c80d18445..8b62cd837 100644
--- a/schema/ttrss_schema_mysql.sql
+++ b/schema/ttrss_schema_mysql.sql
@@ -235,6 +235,8 @@ 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('ENABLE_SEARCH_TOOLBAR', 1, 'false', 'Enable search toolbar',2);
+insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('HIDE_READ_FEEDS', 1, 'false', 'Hide feeds with no unread messages',2);
+
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 2deae6060..a0d570d36 100644
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -213,6 +213,8 @@ 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('ENABLE_SEARCH_TOOLBAR', 1, 'false', 'Enable search toolbar',2);
+insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('HIDE_READ_FEEDS', 1, 'false', 'Hide feeds with no unread messages',2);
+
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.1.1-1.1.2-mysql.sql b/schema/upgrade-1.1.1-1.1.2-mysql.sql
index d6c8a522d..6dfc5f82f 100644
--- a/schema/upgrade-1.1.1-1.1.2-mysql.sql
+++ b/schema/upgrade-1.1.1-1.1.2-mysql.sql
@@ -10,6 +10,8 @@ update ttrss_feeds set private = false;
alter table ttrss_feeds change private private bool not null;
alter table ttrss_feeds alter column private set default 0;
+insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('HIDE_READ_FEEDS', 1, 'false', 'Hide feeds with no unread messages',2);
+
update ttrss_version set schema_version = 4;
commit;
diff --git a/schema/upgrade-1.1.1-1.1.2-pgsql.sql b/schema/upgrade-1.1.1-1.1.2-pgsql.sql
index 960ed8b64..1f926eaeb 100644
--- a/schema/upgrade-1.1.1-1.1.2-pgsql.sql
+++ b/schema/upgrade-1.1.1-1.1.2-pgsql.sql
@@ -10,6 +10,8 @@ update ttrss_feeds set private = false;
alter table ttrss_feeds alter column private set not null;
alter table ttrss_feeds alter column private set default false;
+insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('HIDE_READ_FEEDS', 1, 'false', 'Hide feeds with no unread messages',2);
+
update ttrss_version set schema_version = 4;
commit;