schema/versions/mysql/85.sql

   1 begin;
   2
   3 alter table ttrss_feedbrowser_cache add column site_url text;
   4 update ttrss_feedbrowser_cache set site_url = '';
   5 alter table ttrss_feedbrowser_cache change site_url site_url text not null;
   6
   7 alter table ttrss_linked_feeds add column site_url text;
   8 update ttrss_linked_feeds set site_url = '';
   9 alter table ttrss_linked_feeds change site_url site_url text not null;
  10
  11 update ttrss_version set schema_version = 85;
  12
  13 commit;