diff options
Diffstat (limited to 'schema/upgrade-1.0.6-1.0.7-pgsql.sql')
| -rw-r--r-- | schema/upgrade-1.0.6-1.0.7-pgsql.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/schema/upgrade-1.0.6-1.0.7-pgsql.sql b/schema/upgrade-1.0.6-1.0.7-pgsql.sql index cd31f1375..123da12e3 100644 --- a/schema/upgrade-1.0.6-1.0.7-pgsql.sql +++ b/schema/upgrade-1.0.6-1.0.7-pgsql.sql @@ -1,7 +1,15 @@ +begin; + alter table ttrss_feeds add column last_error text; +alter table ttrss_feeds add column site_url varchar(250) not null default ''; update ttrss_feeds set last_error = ''; +update ttrss_feeds set site_url = ''; alter table ttrss_feeds alter column last_error set not null; alter table ttrss_feeds alter column last_error set default ''; +alter table ttrss_feeds alter column site_url set not null; +alter table ttrss_feeds alter column site_url set default ''; + +commit; |