85.sql 418 B

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