CRM/Upgrade/Incremental/sql/4.7.32.mysql.tpl

   1 {* file to handle db changes in 4.7.32 during upgrade *}
   2
   3 -- CRM-21837 - Missing states for Gabon
   4 SELECT @country_id := id from civicrm_country where name = 'Gabon' AND iso_code = 'GA';
   5 INSERT IGNORE INTO `civicrm_state_province` (`id`, `country_id`, `abbreviation`, `name`) VALUES
   6 (NULL, @country_id, "01", "Estuaire"),
   7 (NULL, @country_id, "02", "Haut-Ogooué"),
   8 (NULL, @country_id, "03", "Moyen-Ogooué"),
   9 (NULL, @country_id, "04", "Ngounié"),
  10 (NULL, @country_id, "05", "Nyanga"),
  11 (NULL, @country_id, "06", "Ogooué-Ivindo"),
  12 (NULL, @country_id, "07", "Ogooué-Lolo"),
  13 (NULL, @country_id, "08", "Ogooué-Maritime"),
  14 (NULL, @country_id, "09", "Woleu-Ntem");