crm.fsf.org/20131203/files/sites/all/modules-old/civicrm/CRM/Upgrade/Incremental/sql/4.1.0.mysql.tpl

   1
   2 {if $multilingual}
   3   {foreach from=$locales item=locale}
   4       ALTER TABLE civicrm_pcp_block ADD link_text_{$locale} varchar(255);
   5       UPDATE civicrm_pcp_block SET link_text_{$locale} = link_text;
   6   {/foreach}
   7   ALTER TABLE civicrm_pcp_block DROP link_text;
   8 {/if}