Commit | Line | Data |
---|---|---|
6a488035 TO |
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 | |
10824d34 | 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`; | |
6a488035 TO |
47 | |
48 | ALTER TABLE `civicrm_activity` | |
10824d34 | 49 | ADD CONSTRAINT `FK_civicrm_activity_source_contact_id` FOREIGN KEY (`source_contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL; |
6a488035 TO |
50 | |
51 | --CRM-4605 | |
52 | ALTER TABLE `civicrm_preferences` DROP `location_count`; |