diff options
author | Andrew Dolgov <[email protected]> | 2006-08-22 08:29:18 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2006-08-22 08:29:18 +0100 |
commit | 3dd9183cd603df99ae8d2bf5cb536b24bc030e20 (patch) | |
tree | 7ebf5625fad3f97676a2e0fb44232bd5199b4fcf /schema/upgrade-1.2.2-1.2.3-pgsql.sql | |
parent | 5f2cd401f983f46d26d967a677398734a4346c5f (diff) |
schema: ttrss_feeds, new field - include_in_digest
Diffstat (limited to 'schema/upgrade-1.2.2-1.2.3-pgsql.sql')
-rw-r--r-- | schema/upgrade-1.2.2-1.2.3-pgsql.sql | 5 |
1 files changed, 5 insertions, 0 deletions
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 114fa0832..9f292ec3d 100644 --- a/schema/upgrade-1.2.2-1.2.3-pgsql.sql +++ b/schema/upgrade-1.2.2-1.2.3-pgsql.sql @@ -1,5 +1,10 @@ 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'); +alter table ttrss_feeds add column include_in_digest boolean; +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; + update ttrss_version set schema_version = 10; |