128.sql 465 B

12345678910111213
  1. BEGIN;
  2. alter table ttrss_entries add column tsvector_combined tsvector;
  3. create index ttrss_entries_tsvector_combined_idx on ttrss_entries using gin(tsvector_combined);
  4. alter table ttrss_feeds add column feed_language varchar(100);
  5. update ttrss_feeds set feed_language = '';
  6. alter table ttrss_feeds alter column feed_language set not null;
  7. alter table ttrss_feeds alter column feed_language set default '';
  8. UPDATE ttrss_version SET schema_version = 128;
  9. COMMIT;