Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | -- http://forum.civicrm.org/?topic=12481 |
2 | UPDATE civicrm_state_province SET name = 'Guizhou' WHERE name = 'Gulzhou'; | |
3 | ||
4 | -- CRM-5824 | |
5 | {if $multilingual} | |
10824d34 | 6 | UPDATE civicrm_option_value ov |
6a488035 TO |
7 | INNER JOIN civicrm_option_group og ON ( og.id = ov.option_group_id ) |
8 | SET ov.name = ov.label_{$config->lcMessages} | |
10824d34 | 9 | WHERE og.name = 'case_type' |
6a488035 TO |
10 | AND ov.name IS NULL; |
11 | {else} | |
10824d34 | 12 | UPDATE civicrm_option_value ov |
6a488035 TO |
13 | INNER JOIN civicrm_option_group og ON ( og.id = ov.option_group_id ) |
14 | SET ov.name = ov.label | |
10824d34 | 15 | WHERE og.name = 'case_type' |
6a488035 TO |
16 | AND ov.name IS NULL; |
17 | {/if} | |
18 | ||
19 | -- CRM-6008 | |
20 | {if $multilingual} | |
10824d34 | 21 | INSERT INTO civicrm_membership_status |
6a488035 TO |
22 | ({localize field='name'}`name`{/localize}, `start_event`, `end_event`, `is_current_member`, `is_admin`, `weight`, `is_default`, `is_active`, `is_reserved`) |
23 | (SELECT {localize}'Pending'{/localize}, 'join_date', 'join_date', 0, 0, 5, 0, 1, 1 FROM dual | |
24 | WHERE NOT EXISTS (SELECT * FROM civicrm_membership_status WHERE `name_{$config->lcMessages}` = 'Pending')); | |
10824d34 | 25 | |
6a488035 TO |
26 | UPDATE `civicrm_membership_status` SET `is_reserved` = 1 WHERE `name_{$config->lcMessages}` = 'Pending'; |
27 | {else} | |
10824d34 | 28 | INSERT INTO civicrm_membership_status |
6a488035 TO |
29 | (`name`, `start_event`, `end_event`, `is_current_member`, `is_admin`, `weight`, `is_default`, `is_active`, `is_reserved`) |
30 | (SELECT 'Pending', 'join_date', 'join_date', 0, 0, 5, 0, 1, 1 FROM dual | |
31 | WHERE NOT EXISTS (SELECT * FROM civicrm_membership_status WHERE name = 'Pending')); | |
32 | UPDATE `civicrm_membership_status` SET `is_reserved` = 1 WHERE `name` = 'Pending'; | |
33 | {/if} |