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

   1 {* file to handle db changes in 5.7.alpha1 during upgrade *}
   2
   3 UPDATE civicrm_navigation SET name = "Search" WHERE name = "Search..." AND domain_id = {$domainID};
   4 UPDATE civicrm_navigation SET icon = "crm-i fa-search" WHERE name = "Search" AND domain_id = {$domainID} AND icon IS NULL;
   5 UPDATE civicrm_navigation SET icon = "crm-i fa-address-book-o" WHERE name = "Contacts" AND domain_id = {$domainID} AND icon IS NULL;
   6 UPDATE civicrm_navigation SET icon = "crm-i fa-money" WHERE name = "Contributions" AND domain_id = {$domainID} AND icon IS NULL;
   7 UPDATE civicrm_navigation SET icon = "crm-i fa-calendar" WHERE name = "Events" AND domain_id = {$domainID} AND icon IS NULL;
   8 UPDATE civicrm_navigation SET icon = "crm-i fa-envelope-o" WHERE name = "Mailings" AND domain_id = {$domainID} AND icon IS NULL;
   9 UPDATE civicrm_navigation SET icon = "crm-i fa-users" WHERE name = "Memberships" AND domain_id = {$domainID} AND icon IS NULL;
  10 UPDATE civicrm_navigation SET icon = "crm-i fa-star-o" WHERE name = "Campaigns" AND domain_id = {$domainID} AND icon IS NULL;
  11 UPDATE civicrm_navigation SET icon = "crm-i fa-folder-open-o" WHERE name = "Cases" AND domain_id = {$domainID} AND icon IS NULL;
  12 UPDATE civicrm_navigation SET icon = "crm-i fa-exchange" WHERE name = "Grants" AND domain_id = {$domainID} AND icon IS NULL;
  13 UPDATE civicrm_navigation SET icon = "crm-i fa-cog" WHERE name = "Administer" AND domain_id = {$domainID} AND icon IS NULL;
  14 UPDATE civicrm_navigation SET icon = "crm-i fa-life-ring" WHERE name = "Support" AND domain_id = {$domainID} AND icon IS NULL;
  15 UPDATE civicrm_navigation SET icon = "crm-i fa-bar-chart" WHERE name = "Reports" AND domain_id = {$domainID} AND icon IS NULL;