Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | -- CRM-5030 |
2 | ||
3 | UPDATE civicrm_navigation | |
4 | SET url = 'civicrm/activity/add?atype=3&action=add&reset=1&context=standalone' | |
5 | WHERE civicrm_navigation.name= 'New Email'; | |
6 | UPDATE civicrm_navigation | |
7 | SET url = 'civicrm/contribute/add&reset=1&action=add&context=standalone' | |
8 | WHERE civicrm_navigation.name= 'New Contribution'; | |
9 | UPDATE civicrm_navigation | |
10 | SET url = 'civicrm/pledge/add&reset=1&action=add&context=standalone' | |
11 | WHERE civicrm_navigation.name= 'New Pledge'; | |
12 | UPDATE civicrm_navigation | |
13 | SET url = 'civicrm/participant/add&reset=1&action=add&context=standalone' | |
14 | WHERE civicrm_navigation.name= 'Register Event Participant'; | |
15 | UPDATE civicrm_navigation | |
16 | SET url = 'civicrm/member/add&reset=1&action=add&context=standalone' | |
17 | WHERE civicrm_navigation.name= 'New Membership'; | |
18 | UPDATE civicrm_navigation | |
19 | SET url = 'civicrm/case/add&reset=1&action=add&atype=13&context=standalone' | |
20 | WHERE civicrm_navigation.name= 'New Case'; | |
21 | UPDATE civicrm_navigation | |
22 | SET url = 'civicrm/grant/add&reset=1&action=add&context=standalone' | |
23 | WHERE civicrm_navigation.name= 'New Grant'; | |
24 | ||
25 | -- CRM-5048 | |
cff67e98 | 26 | INSERT IGNORE INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES |
6a488035 TO |
27 | (10010, 1107, "Bar", "Barletta-Andria-Trani"), |
28 | (10011, 1107, "Fer", "Fermo"), | |
29 | (10012, 1107, "Mon", "Monza e Brianza"); | |
30 | ||
31 | -- CRM-5031 | |
32 | {if $multilingual} | |
33 | {foreach from=$locales item=locale} | |
34 | ALTER TABLE civicrm_mailing ADD name_{$locale} VARCHAR(128); | |
35 | ALTER TABLE civicrm_mailing ADD from_name_{$locale} VARCHAR(128); | |
36 | ALTER TABLE civicrm_mailing ADD subject_{$locale} VARCHAR(128); | |
37 | ALTER TABLE civicrm_mailing ADD body_text_{$locale} TEXT; | |
38 | ALTER TABLE civicrm_mailing ADD body_html_{$locale} TEXT; | |
39 | ||
40 | UPDATE civicrm_mailing SET name_{$locale} = name; | |
41 | UPDATE civicrm_mailing SET from_name_{$locale} = from_name; | |
42 | UPDATE civicrm_mailing SET subject_{$locale} = subject; | |
43 | UPDATE civicrm_mailing SET body_text_{$locale} = body_text; | |
44 | UPDATE civicrm_mailing SET body_html_{$locale} = body_html; | |
45 | {/foreach} | |
46 | ||
47 | ALTER TABLE civicrm_mailing DROP name; | |
48 | ALTER TABLE civicrm_mailing DROP from_name; | |
49 | ALTER TABLE civicrm_mailing DROP subject; | |
50 | ALTER TABLE civicrm_mailing DROP body_text; | |
51 | ALTER TABLE civicrm_mailing DROP body_html; | |
52 | ||
53 | {foreach from=$locales item=locale} | |
54 | ALTER TABLE civicrm_mailing_component ADD name_{$locale} VARCHAR(64); | |
55 | ALTER TABLE civicrm_mailing_component ADD subject_{$locale} VARCHAR(255); | |
56 | ALTER TABLE civicrm_mailing_component ADD body_text_{$locale} TEXT; | |
57 | ALTER TABLE civicrm_mailing_component ADD body_html_{$locale} TEXT; | |
58 | ||
59 | UPDATE civicrm_mailing_component SET name_{$locale} = name; | |
60 | UPDATE civicrm_mailing_component SET subject_{$locale} = subject; | |
61 | UPDATE civicrm_mailing_component SET body_text_{$locale} = body_text; | |
62 | UPDATE civicrm_mailing_component SET body_html_{$locale} = body_html; | |
63 | {/foreach} | |
64 | ||
65 | ALTER TABLE civicrm_mailing_component DROP name; | |
66 | ALTER TABLE civicrm_mailing_component DROP subject; | |
67 | ALTER TABLE civicrm_mailing_component DROP body_text; | |
68 | ALTER TABLE civicrm_mailing_component DROP body_html; | |
69 | {/if} |