summaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2006-08-21 07:12:09 +0100
committerAndrew Dolgov <[email protected]>2006-08-21 07:12:09 +0100
commit9a61ce6d2037813a20ed1e0bcbed4a530d90514a (patch)
tree3d7afd864d9e08787699d0d8b6a3638d31417ae1 /schema
parent8fb018809f07f4723a9b50905be16776303851aa (diff)
add upgrade schema files for 1.2.3, new option: DIGEST_ENABLE
Diffstat (limited to 'schema')
-rw-r--r--schema/ttrss_schema_mysql.sql3
-rw-r--r--schema/ttrss_schema_pgsql.sql3
-rw-r--r--schema/upgrade-1.2.2-1.2.3-mysql.sql3
-rw-r--r--schema/upgrade-1.2.2-1.2.3-pgsql.sql3
4 files changed, 12 insertions, 0 deletions
diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql
index b6bf13426..9894caab9 100644
--- a/schema/ttrss_schema_mysql.sql
+++ b/schema/ttrss_schema_mysql.sql
@@ -259,6 +259,9 @@ 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('REVERSE_HEADLINES', 1, 'false', 'Reverse headline order (oldest first)',2);
+insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('DIGEST_ENABLE', 1, 'false', 'Enable email digest',1,
+'This option enables sending daily digest of new (and unread) headlines on your configured e-mail address');
+
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 81c865af9..0b2ec835d 100644
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -239,6 +239,9 @@ 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('REVERSE_HEADLINES', 1, 'false', 'Reverse headline order (oldest first)',2);
+insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('DIGEST_ENABLE', 1, 'false', 'Enable email digest',1,
+'This option enables sending daily digest of new (and unread) headlines on your configured e-mail address');
+
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
new file mode 100644
index 000000000..25213d9c9
--- /dev/null
+++ b/schema/upgrade-1.2.2-1.2.3-mysql.sql
@@ -0,0 +1,3 @@
+insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('DIGEST_ENABLE', 1, 'false', 'Enable email digest',1,
+'This option enables sending daily digest of new (and unread) headlines on your configured e-mail address');
+
diff --git a/schema/upgrade-1.2.2-1.2.3-pgsql.sql b/schema/upgrade-1.2.2-1.2.3-pgsql.sql
new file mode 100644
index 000000000..25213d9c9
--- /dev/null
+++ b/schema/upgrade-1.2.2-1.2.3-pgsql.sql
@@ -0,0 +1,3 @@
+insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('DIGEST_ENABLE', 1, 'false', 'Enable email digest',1,
+'This option enables sending daily digest of new (and unread) headlines on your configured e-mail address');
+