CRM/Upgrade/Incremental/sql/3.0.beta1.mysql.tpl

   1 -- CRM-4932
   2    ALTER TABLE civicrm_contact MODIFY COLUMN job_title varchar(255);
   3
   4 -- CRM-4906
   5 {if $multilingual}
   6   {foreach from=$locales item=locale}
   7     ALTER TABLE civicrm_address ADD street_address_{$locale} VARCHAR(96);
   8     UPDATE civicrm_address SET street_address_{$locale} = street_address;
   9   {/foreach}
  10   ALTER TABLE civicrm_address DROP street_address;
  11
  12   {foreach from=$locales item=locale}
  13     ALTER TABLE civicrm_address ADD supplemental_address_1_{$locale} VARCHAR(96);
  14     UPDATE civicrm_address SET supplemental_address_1_{$locale} = supplemental_address_1;
  15   {/foreach}
  16   ALTER TABLE civicrm_address DROP supplemental_address_1;
  17
  18   {foreach from=$locales item=locale}
  19     ALTER TABLE civicrm_address ADD supplemental_address_2_{$locale} VARCHAR(96);
  20     UPDATE civicrm_address SET supplemental_address_2_{$locale} = supplemental_address_2;
  21   {/foreach}
  22   ALTER TABLE civicrm_address DROP supplemental_address_2;
  23
  24   {foreach from=$locales item=locale}
  25     ALTER TABLE civicrm_address ADD supplemental_address_3_{$locale} VARCHAR(96);
  26     UPDATE civicrm_address SET supplemental_address_3_{$locale} = supplemental_address_3;
  27   {/foreach}
  28   ALTER TABLE civicrm_address DROP supplemental_address_3;
  29
  30   {foreach from=$locales item=locale}
  31     ALTER TABLE civicrm_address ADD city_{$locale} VARCHAR(64);
  32     UPDATE civicrm_address SET city_{$locale} = city;
  33   {/foreach}
  34   ALTER TABLE civicrm_address DROP city;
  35
  36   {foreach from=$locales item=locale}
  37     ALTER TABLE civicrm_address ADD name_{$locale} VARCHAR(255);
  38     UPDATE civicrm_address SET name_{$locale} = name;
  39   {/foreach}
  40   ALTER TABLE civicrm_address DROP name;
  41 {/if}
  42
  43 -- CRM-4935
  44    ALTER TABLE `civicrm_activity`
  45   CHANGE `source_contact_id` `source_contact_id` INT( 10 ) UNSIGNED NULL DEFAULT NULL COMMENT 'Contact ID of the person scheduling or logging this Activity. Usually the authenticated user.',
  46   DROP FOREIGN KEY `FK_civicrm_activity_source_contact_id`;
  47
  48    ALTER TABLE `civicrm_activity`
  49       ADD CONSTRAINT `FK_civicrm_activity_source_contact_id` FOREIGN KEY (`source_contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL;
  50
  51 --CRM-4605
  52   ALTER TABLE `civicrm_preferences` DROP `location_count`;