From 3dd9183cd603df99ae8d2bf5cb536b24bc030e20 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@madoka.spb.ru>
Date: Tue, 22 Aug 2006 08:29:18 +0100
Subject: schema: ttrss_feeds, new field - include_in_digest

---
 schema/upgrade-1.2.2-1.2.3-pgsql.sql | 5 +++++
 1 file changed, 5 insertions(+)

(limited to 'schema/upgrade-1.2.2-1.2.3-pgsql.sql')

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;
 
-- 
cgit v1.2.3-54-g00ecf

