From ffba8297eaada358f913d327816d4b7d91f3375b Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Thu, 9 Aug 2007 11:09:22 +0100 Subject: schema: add published column --- schema/versions/mysql/19.sql | 5 +++++ schema/versions/pgsql/19.sql | 5 +++++ 2 files changed, 10 insertions(+) (limited to 'schema/versions') diff --git a/schema/versions/mysql/19.sql b/schema/versions/mysql/19.sql index 19bb4b25d..db4237da8 100644 --- a/schema/versions/mysql/19.sql +++ b/schema/versions/mysql/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 bool; +update ttrss_user_entries set published = false; +alter table ttrss_user_entries change published published bool not null; +alter table ttrss_user_entries alter column published set default false; + update ttrss_version set schema_version = 19; 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