CRM/Upgrade/Incremental/sql/5.26.alpha1.mysql.tpl

   1 {* file to handle db changes in 5.26.alpha1 during upgrade *}
   2
   3 ALTER TABLE civicrm_option_value MODIFY COLUMN `filter` int unsigned DEFAULT NULL COMMENT 'Bitwise logic can be used to create subsets of options within an option_group for different uses.';
   4
   5 UPDATE civicrm_contact SET is_deceased = 0 WHERE is_deceased IS NULL;
   6 ALTER TABLE civicrm_contact MODIFY COLUMN is_deceased TINYINT NOT NULL DEFAULT 0;
   7
   8 -- Update Colmbra state/province to Coimbra
   9 UPDATE civicrm_state_province s
  10  INNER JOIN civicrm_country c
  11    on c.id = s.country_id AND c.name = 'Portugal'
  12      AND s.name = 'Colmbra'
  13 SET s.name = 'Coimbra';
  14
  15 UPDATE civicrm_state_province s
  16  INNER JOIN civicrm_country c
  17    on c.id = s.country_id AND c.name = 'Portugal'
  18      AND s.name = 'Braganca'
  19 SET s.name = 'Bragança';
  20
  21 UPDATE civicrm_state_province s
  22  INNER JOIN civicrm_country c
  23    on c.id = s.country_id AND c.name = 'Portugal'
  24      AND s.name = 'Ovora'
  25 SET s.name = 'Évora';
  26
  27 UPDATE civicrm_state_province s
  28  INNER JOIN civicrm_country c
  29    on c.id = s.country_id AND c.name = 'Portugal'
  30      AND s.name = 'Santarem'
  31 SET s.name = 'Santarém';
  32
  33 UPDATE civicrm_state_province s
  34  INNER JOIN civicrm_country c
  35    on c.id = s.country_id AND c.name = 'Portugal'
  36      AND s.name = 'Setubal'
  37 SET s.name = 'Setúbal';
  38
  39 UPDATE civicrm_state_province s
  40  INNER JOIN civicrm_country c
  41    on c.id = s.country_id AND c.name = 'Portugal'
  42      AND s.name = 'Regiao Autonoma dos Acores'
  43 SET s.name = 'Região Autónoma dos Açores';
  44
  45 UPDATE civicrm_state_province s
  46  INNER JOIN civicrm_country c
  47    on c.id = s.country_id AND c.name = 'Portugal'
  48      AND s.name = 'Regiao Autonoma da Madeira'
  49 SET s.name = 'Região Autónoma da Madeira';