From ffba8297eaada358f913d327816d4b7d91f3375b Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@bah.spb.su>
Date: Thu, 9 Aug 2007 11:09:22 +0100
Subject: schema: add published column

---
 schema/versions/pgsql/19.sql | 5 +++++
 1 file changed, 5 insertions(+)

(limited to 'schema/versions/pgsql/19.sql')

diff --git a/schema/versions/pgsql/19.sql b/schema/versions/pgsql/19.sql
index 19bb4b25d..79e628464 100644
--- a/schema/versions/pgsql/19.sql
+++ b/schema/versions/pgsql/19.sql
@@ -1,3 +1,8 @@
 insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('_PREFS_PUBLISH_KEY', 2, '', '', 1);
 
+alter table ttrss_user_entries add column published boolean;
+update ttrss_user_entries set published = false;
+alter table ttrss_user_entries alter column published set not null;
+alter table ttrss_user_entries alter column published set default false;
+
 update ttrss_version set schema_version = 19;
-- 
cgit v1.2.3

