diff options
author | Andrew Dolgov <[email protected]> | 2005-11-02 12:53:06 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2005-11-02 12:53:06 +0100 |
commit | 37d379de29265eb18622984575fb45c8fe89f647 (patch) | |
tree | 15a0142c3f42c52b1efa83fb742f359ea6221829 /schema/upgrade-1.0.6-1.0.7-pgsql.sql | |
parent | 32bd6e262f3794fc603ffa848548fbab3bea7e75 (diff) |
reserve column in ttrss_feeds for site url (schema+upgrade script updated)
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; |