[civicrm-core.git] / CRM / Upgrade / Incremental / sql / 3.3.7.mysql.tpl

-- CRM-8113 We need a 3.3.7.mysql.tpl file to exist in order for CRM_Upgrade_Incremental_php_ThreeThree::upgrade_3_3_7 to be run

-- CRM-8218, contact dashboard changes
{if $alterContactDashboard}
ALTER TABLE `civicrm_dashboard` DROP `content`, DROP `created_date`;

ALTER TABLE `civicrm_dashboard_contact`  ADD `content` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL AFTER `weight`,  ADD `created_date` DATETIME NULL DEFAULT NULL AFTER `content`;
{/if}
Commit	Line	Data
6a488035 TO	1	-- CRM-8113 We need a 3.3.7.mysql.tpl file to exist in order for CRM_Upgrade_Incremental_php_ThreeThree::upgrade_3_3_7 to be run
	2
	3	-- CRM-8218, contact dashboard changes
	4	{if $alterContactDashboard}
	5	ALTER TABLE `civicrm_dashboard` DROP `content`, DROP `created_date`;
	6
	7	ALTER TABLE `civicrm_dashboard_contact` ADD `content` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL AFTER `weight`, ADD `created_date` DATETIME NULL DEFAULT NULL AFTER `content`;
	8	{/if}