diff options
author | Andrew Dolgov <[email protected]> | 2011-04-20 20:05:10 +0400 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2011-04-20 20:05:10 +0400 |
commit | 109662e12f858bf067f14a37942a1106c900b527 (patch) | |
tree | d34f48dcb375bf8c79639aa2cd089b5571af8ebe /schema/versions/mysql/85.sql | |
parent | 6f907113ef20b09976b1fddbc698a49dbe283519 (diff) |
feedbrowser_cache & linked feeds: add site url (bump schema)
Diffstat (limited to 'schema/versions/mysql/85.sql')
-rw-r--r-- | schema/versions/mysql/85.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/schema/versions/mysql/85.sql b/schema/versions/mysql/85.sql new file mode 100644 index 000000000..70cab0297 --- /dev/null +++ b/schema/versions/mysql/85.sql @@ -0,0 +1,13 @@ +begin; + +alter table ttrss_feedbrowser_cache add column site_url text; +update ttrss_feedbrowser_cache set site_url = ''; +alter table ttrss_feedbrowser_cache change site_url site_url text not null; + +alter table ttrss_linked_feeds add column site_url text; +update ttrss_linked_feeds set site_url = ''; +alter table ttrss_linked_feeds change site_url site_url text not null; + +update ttrss_version set schema_version = 85; + +commit; |