CRM/Upgrade/Incremental/sql/3.2.alpha4.mysql.tpl

   1 -- schema changes for 3.2 alpha4 tag
   2 --  change is_hidden to is_tagset in civicrm_tag
   3 ALTER TABLE `civicrm_tag` CHANGE `is_hidden` `is_tagset` TINYINT( 4 ) NULL DEFAULT '0';
   4
   5 -- CRM-6229
   6 ALTER TABLE `civicrm_event` CHANGE `is_template` `is_template` TINYINT( 4 ) NULL DEFAULT '0' COMMENT 'whether the event has template';
   7 UPDATE `civicrm_event` SET `is_template` = 0 WHERE `is_template` IS NULL ;
   8
   9 -- CRM-5970
  10 ALTER TABLE `civicrm_financial_account` ADD `contact_id` INT UNSIGNED NOT NULL COMMENT 'FK to civicrm_contact' AFTER `id` ;
  11 ALTER TABLE `civicrm_financial_account`
  12      ADD CONSTRAINT `FK_civicrm_financial_account_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE;
  13
  14 -- CRM-6294 (event badge support)
  15 {if $multilingual}
  16     INSERT INTO civicrm_option_group
  17         ( name,                 {foreach from=$locales item=locale}description_{$locale},   {/foreach} is_reserved, is_active)
  18     VALUES
  19         ( 'event_badge',    {foreach from=$locales item=locale}'Event Badge',       {/foreach} 0, 1 );
  20 {else}
  21     INSERT INTO civicrm_option_group
  22         (name, description, is_reserved, is_active )
  23     VALUES
  24         ('event_badge', 'event_badge', 0, 1 );
  25 {/if}
  26
  27 SELECT @option_group_id_eventBadge         := max(id) from civicrm_option_group where name = 'event_badge';
  28
  29 {if $multilingual}
  30     INSERT INTO civicrm_option_value
  31   (option_group_id, {foreach from=$locales item=locale}label_{$locale}, description_{$locale}, {/foreach} value, name, weight, is_active, component_id )
  32     VALUES
  33         (@option_group_id_eventBadge , {foreach from=$locales item=locale}'Name Only', 'Simple Event Name Badge', {/foreach} '1', 'CRM_Event_Badge_Simple', 1,   1, NULL ),
  34         (@option_group_id_eventBadge , {foreach from=$locales item=locale}'Name Tent', 'Name Tent', {/foreach} '2', 'CRM_Event_Badge_NameTent', 1,   1, NULL );
  35 {else}
  36     INSERT INTO civicrm_option_value
  37   (option_group_id, label, description, value, name, weight, is_active, component_id )
  38     VALUES
  39         (@option_group_id_eventBadge , '{ts escape="sql"}Name Only{/ts}', '{ts escape="sql"}Simple Event Name Badge{/ts}', '1', 'CRM_Event_Badge_Simple', 1,   1, NULL ),
  40         (@option_group_id_eventBadge , '{ts escape="sql"}Name Tent{/ts}', '{ts escape="sql"}Name Tent{/ts}', '2', 'CRM_Event_Badge_NameTent', 1,   1, NULL );
  41 {/if}
  42