| 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} |