CRM/Upgrade/Incremental/sql/2.2.alpha3.mysql.tpl

   1 -- Do not make any changes to this file once alpha3 is tagged
   2 -- CRM-3546 CRM-2105 CRM-3248 CRM-3869 CRM-4013
   3
   4  {if $multilingual}
   5    INSERT INTO civicrm_option_group (name, {foreach from=$locales item=locale}description_{$locale},{/foreach} is_reserved, is_active) VALUES ('mail_protocol', {foreach from=$locales item=locale}'Mail Protocol',{/foreach} 0, 1 );
   6  {else}
   7    INSERT INTO civicrm_option_group (name, description, is_reserved, is_active ) VALUES ('mail_protocol', 'Mail Protocol', 0, 1 );
   8  {/if}
   9
  10  UPDATE civicrm_option_group SET is_reserved = 0, is_active = 1 WHERE name IN( 'mail_protocol', 'visibility', 'greeting_type', 'phone_type' );
  11  UPDATE civicrm_option_group SET is_active   = 1 WHERE name = 'encounter_medium';
  12  SELECT @option_group_id_mp := max(id) from civicrm_option_group where name = 'mail_protocol';
  13
  14 {if $multilingual}
  15   INSERT INTO civicrm_option_value
  16     (option_group_id,     {foreach from=$locales item=locale}label_{$locale},{/foreach} value, name,       weight) VALUES
  17     (@option_group_id_mp, {foreach from=$locales item=locale}'IMAP',{/foreach}          1,     'IMAP',     1),
  18     (@option_group_id_mp, {foreach from=$locales item=locale}'Maildir',{/foreach}       2,     'Maildir',  2),
  19     (@option_group_id_mp, {foreach from=$locales item=locale}'POP3',{/foreach}          3,     'POP3',     3);
  20 {else}
  21   INSERT INTO civicrm_option_value
  22     (option_group_id,     label,       value, name,       weight) VALUES
  23     (@option_group_id_mp, 'IMAP' ,     1,     'IMAP',     1),
  24     (@option_group_id_mp, 'Maildir',   2,     'Maildir',  2),
  25     (@option_group_id_mp, 'POP3'   ,   3,     'POP3',     3);
  26 {/if}
  27
  28 ALTER TABLE `civicrm_domain`
  29   MODIFY version varchar(32) COMMENT 'The civicrm version this instance is running';
  30
  31 -- CRM-3989
  32 ALTER TABLE `civicrm_pcp_block`
  33   ADD notify_email varchar(255) DEFAULT NULL COMMENT 'If set, notification is automatically emailed to this email-address on create/update Personal Campaign Page';
  34
  35 -- PCP userDashboard Option
  36
  37  SELECT @option_group_id_udOpt  := max(id) from civicrm_option_group where name = 'user_dashboard_options';
  38  SELECT @maxValue  := max(value) from civicrm_option_value where option_group_id=@option_group_id_udOpt ;
  39
  40 {if $multilingual}
  41   INSERT INTO civicrm_option_value
  42     (option_group_id, {foreach from=$locales item=locale}label_{$locale},{/foreach} value, name, weight, is_reserved, is_active) VALUES
  43     (@option_group_id_udOpt, {foreach from=$locales item=locale}'Personal Campaign Pages',{/foreach} @maxValue + 1,'PCP', @maxValue + 1, 0, 1);
  44 {else}
  45   INSERT INTO civicrm_option_value
  46     (option_group_id,        label,                    value,          name,  weight, is_reserved, is_active) VALUES
  47     (@option_group_id_udOpt, 'Personal Campaign Pages', @maxValue + 1, 'PCP', @maxValue + 1, 0, 1 );
  48 {/if}
  49
  50 -- PCP Status Option Group
  51 {if $multilingual}
  52   INSERT INTO civicrm_option_group
  53     (name, {foreach from=$locales item=locale}description_{$locale},{/foreach} is_reserved, is_active) VALUES
  54     ('pcp_status', {foreach from=$locales item=locale}'PCP Status',{/foreach} 0, 1);
  55
  56   SELECT @option_group_id_pcp  := max(id) from civicrm_option_group where name = 'pcp_status';
  57
  58   INSERT INTO civicrm_option_value
  59     (option_group_id, {foreach from=$locales item=locale}label_{$locale},{/foreach} value, name, weight, is_reserved, is_active) VALUES
  60     (@option_group_id_pcp, {foreach from=$locales item=locale}'Waiting Review',{/foreach} 1, 'Waiting Review', 1, 1, 1 ),
  61     (@option_group_id_pcp, {foreach from=$locales item=locale}'Approved',{/foreach}       2, 'Approved',       2, 1, 1 ),
  62     (@option_group_id_pcp, {foreach from=$locales item=locale}'Not Approved',{/foreach}   3, 'Not Approved',   3, 1, 1 );
  63 {else}
  64   INSERT INTO civicrm_option_group
  65     ( name, description, is_reserved, is_active) VALUES
  66     ('pcp_status','PCP Status', 0, 1 );
  67
  68   SELECT @option_group_id_pcp  := max(id) from civicrm_option_group where name = 'pcp_status';
  69
  70   INSERT INTO civicrm_option_value
  71     (option_group_id, label, value, name, weight, is_reserved, is_active) VALUES
  72     (@option_group_id_pcp, 'Waiting Review', 1, 'Waiting Review',  1, 1, 1 ),
  73     (@option_group_id_pcp, 'Approved'      , 2, 'Approved'      ,  2, 1, 1 ),
  74     (@option_group_id_pcp, 'Not Approved'  , 3, 'Not Approved'  ,  3, 1, 1 );
  75 {/if}