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

{if $multilingual}
  {foreach from=$locales item=locale}
     DROP VIEW IF EXISTS civicrm_event_page_{$locale};
  {/foreach}
{/if}

ALTER TABLE `civicrm_domain`
  MODIFY version varchar(32) COMMENT 'The civicrm version this instance is running';

{if $notifyAbsent}
-- CRM-3989
ALTER TABLE `civicrm_pcp_block`
  ADD notify_email varchar(255) DEFAULT NULL COMMENT 'If set, notification is automatically emailed to this email-address on create/update Personal Campaign Page';
{/if}

ALTER TABLE `civicrm_custom_group` ALTER `min_multiple` DROP DEFAULT, ALTER `max_multiple` DROP DEFAULT;
Commit	Line	Data
6a488035 TO	1	{if $multilingual}
	2	{foreach from=$locales item=locale}
	3	DROP VIEW IF EXISTS civicrm_event_page_{$locale};
	4	{/foreach}
	5	{/if}
	6
10824d34	7	ALTER TABLE `civicrm_domain`
6a488035 TO	8	MODIFY version varchar(32) COMMENT 'The civicrm version this instance is running';
	9
	10	{if $notifyAbsent}
	11	-- CRM-3989
	12	ALTER TABLE `civicrm_pcp_block`
	13	ADD notify_email varchar(255) DEFAULT NULL COMMENT 'If set, notification is automatically emailed to this email-address on create/update Personal Campaign Page';
	14	{/if}
	15
	16	ALTER TABLE `civicrm_custom_group` ALTER `min_multiple` DROP DEFAULT, ALTER `max_multiple` DROP DEFAULT;