From 76589f9b65e2f35f3e8b657831372ab7a57cf423 Mon Sep 17 00:00:00 2001 From: gah242s Date: Wed, 2 Sep 2015 09:18:30 -0400 Subject: [PATCH] Update 4.7.alpha1.mysql.tpl CRM-17136 Added Punjab Province for Pakistan Conflicts: CRM/Upgrade/Incremental/sql/4.7.alpha1.mysql.tpl ---------------------------------------- * CRM-17136: Missing PK-PB Province https://issues.civicrm.org/jira/browse/CRM-17136 --- CRM/Upgrade/Incremental/sql/4.7.alpha1.mysql.tpl | 6 ++++++ 1 file changed, 6 insertions(+) diff --git a/CRM/Upgrade/Incremental/sql/4.7.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.7.alpha1.mysql.tpl index 19f3598b55..d1f2d595f4 100644 --- a/CRM/Upgrade/Incremental/sql/4.7.alpha1.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.7.alpha1.mysql.tpl @@ -88,5 +88,11 @@ CREATE TABLE IF NOT EXISTS `civicrm_status_pref` ( -- CRM-17005 UPDATE civicrm_country SET name = 'PALESTINIAN TERRITORY' WHERE name = 'PALESTINIAN TERRITORY, OCCUPIED'; + -- CRM-17145 update Activity detail data type ALTER TABLE `civicrm_activity` CHANGE `details` `details` LONGTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT 'Details about the activity (agenda, notes, etc).'; + +-- CRM-17136 Added Punjab Province for Pakistan +INSERT IGNORE INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES +(NULL, 1163, "PB", "Punjab"); + -- 2.25.1