Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | -- schema changes for 3.2 alpha4 tag |
2 | -- change is_hidden to is_tagset in civicrm_tag | |
3 | ALTER TABLE `civicrm_tag` CHANGE `is_hidden` `is_tagset` TINYINT( 4 ) NULL DEFAULT '0'; | |
4 | ||
5 | -- CRM-6229 | |
6 | ALTER TABLE `civicrm_event` CHANGE `is_template` `is_template` TINYINT( 4 ) NULL DEFAULT '0' COMMENT 'whether the event has template'; | |
7 | UPDATE `civicrm_event` SET `is_template` = 0 WHERE `is_template` IS NULL ; | |
8 | ||
10824d34 | 9 | -- CRM-5970 |
6a488035 TO |
10 | ALTER TABLE `civicrm_financial_account` ADD `contact_id` INT UNSIGNED NOT NULL COMMENT 'FK to civicrm_contact' AFTER `id` ; |
11 | ALTER TABLE `civicrm_financial_account` | |
12 | ADD CONSTRAINT `FK_civicrm_financial_account_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE; | |
13 | ||
14 | -- CRM-6294 (event badge support) | |
15 | {if $multilingual} | |
16 | INSERT INTO civicrm_option_group | |
17 | ( name, {foreach from=$locales item=locale}description_{$locale}, {/foreach} is_reserved, is_active) | |
18 | VALUES | |
19 | ( 'event_badge', {foreach from=$locales item=locale}'Event Badge', {/foreach} 0, 1 ); | |
20 | {else} | |
21 | INSERT INTO civicrm_option_group | |
22 | (name, description, is_reserved, is_active ) | |
23 | VALUES | |
24 | ('event_badge', 'event_badge', 0, 1 ); | |
25 | {/if} | |
26 | ||
27 | SELECT @option_group_id_eventBadge := max(id) from civicrm_option_group where name = 'event_badge'; | |
28 | ||
29 | {if $multilingual} | |
30 | INSERT INTO civicrm_option_value | |
10824d34 | 31 | (option_group_id, {foreach from=$locales item=locale}label_{$locale}, description_{$locale}, {/foreach} value, name, weight, is_active, component_id ) |
6a488035 TO |
32 | VALUES |
33 | (@option_group_id_eventBadge , {foreach from=$locales item=locale}'Name Only', 'Simple Event Name Badge', {/foreach} '1', 'CRM_Event_Badge_Simple', 1, 1, NULL ), | |
34 | (@option_group_id_eventBadge , {foreach from=$locales item=locale}'Name Tent', 'Name Tent', {/foreach} '2', 'CRM_Event_Badge_NameTent', 1, 1, NULL ); | |
35 | {else} | |
36 | INSERT INTO civicrm_option_value | |
10824d34 | 37 | (option_group_id, label, description, value, name, weight, is_active, component_id ) |
6a488035 TO |
38 | VALUES |
39 | (@option_group_id_eventBadge , '{ts escape="sql"}Name Only{/ts}', '{ts escape="sql"}Simple Event Name Badge{/ts}', '1', 'CRM_Event_Badge_Simple', 1, 1, NULL ), | |
40 | (@option_group_id_eventBadge , '{ts escape="sql"}Name Tent{/ts}', '{ts escape="sql"}Name Tent{/ts}', '2', 'CRM_Event_Badge_NameTent', 1, 1, NULL ); | |
41 | {/if} | |
42 |