tinytinyrss/sql/mysql/migrations/99.sql

13 lines
372 B
PL/PgSQL

begin;
alter table ttrss_feeds add column cache_content bool;
update ttrss_feeds set cache_content = false;
alter table ttrss_feeds change cache_content cache_content bool not null;
alter table ttrss_feeds alter column cache_content set default false;
alter table ttrss_entries add column cached_content longtext;
update ttrss_version set schema_version = 99;
commit;