schema/versions/mysql/3.sql

   1 begin;
   2
   3 alter table ttrss_entries add column num_comments integer;
   4
   5 update ttrss_entries set num_comments = 0;
   6
   7 alter table ttrss_entries change num_comments num_comments integer not null;
   8 alter table ttrss_entries alter column num_comments set default 0;
   9
  10 insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('COMBINED_DISPLAY_MODE', 1, 'false', 'Combined feed display',2,
  11         'Display expanded list of feed articles, instead of separate displays for headlines and article content');
  12
  13 alter table ttrss_feed_categories add column collapsed bool;
  14
  15 update ttrss_feed_categories set collapsed = false;
  16
  17 alter table ttrss_feed_categories change collapsed collapsed bool not null;
  18 alter table ttrss_feed_categories alter column collapsed set default 0;
  19
  20 alter table ttrss_feeds add column auth_login varchar(250);
  21 alter table ttrss_feeds add column auth_pass varchar(250);
  22
  23 update ttrss_feeds set auth_login = '';
  24 update ttrss_feeds set auth_pass = '';
  25
  26 alter table ttrss_feeds change auth_login auth_login varchar(250) not null;
  27 alter table ttrss_feeds alter column auth_login set default '';
  28
  29 alter table ttrss_feeds change auth_pass auth_pass varchar(250) not null;
  30 alter table ttrss_feeds alter column auth_pass set default '';
  31
  32 alter table ttrss_users add column email varchar(250);
  33
  34 update ttrss_users set email = '';
  35
  36 alter table ttrss_users change email email varchar(250) not null;
  37 alter table ttrss_users alter column email set default '';
  38
  39 insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('ENABLE_SEARCH_TOOLBAR', 1, 'false', 'Enable search toolbar',2);
  40
  41 update ttrss_version set schema_version = 3;
  42
  43 commit;