schema/versions/mysql/112.sql

   1 begin;
   2
   3 alter table ttrss_filters2 add column order_id integer;
   4 update ttrss_filters2 set order_id = 0;
   5 alter table ttrss_filters2 change order_id order_id integer not null;
   6 alter table ttrss_filters2 alter column order_id set default 0;
   7
   8 alter table ttrss_filters2 add column title varchar(250);
   9 update ttrss_filters2 set title = '';
  10 alter table ttrss_filters2 change title title varchar(250) not null;
  11 alter table ttrss_filters2 alter column title set default '';
  12
  13 update ttrss_version set schema_version = 112;
  14
  15 commit;