diff options
author | Andrew Dolgov <[email protected]> | 2007-08-09 11:09:22 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2007-08-09 11:09:22 +0100 |
commit | ffba8297eaada358f913d327816d4b7d91f3375b (patch) | |
tree | bace2c0fdbcb02c8e38014440f477e58638efae2 /schema/versions/mysql/19.sql | |
parent | bc0ed820d19f1ee42ae054b4f0e67f2b34d5cfea (diff) |
schema: add published column
Diffstat (limited to 'schema/versions/mysql/19.sql')
-rw-r--r-- | schema/versions/mysql/19.sql | 5 |
1 files changed, 5 insertions, 0 deletions
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; |