Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | -- CRM-7901 |
2 | ||
3 | ALTER TABLE `civicrm_custom_group` CHANGE `extends` `extends` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT 'Contact' COMMENT 'Type of object this group extends (can add other options later e.g. contact_address, etc.).'; | |
4 | ||
5 | INSERT INTO civicrm_option_group | |
6 | (name, {localize field='description'}description{/localize}, is_reserved, is_active) | |
7 | VALUES | |
8 | ('cg_extend_objects', {localize}'{ts escape="sql"}Objects a custom group extends to{/ts}'{/localize}, 0, 1); | |
9 | ||
10 | SELECT @option_group_id_cgeo := max(id) from civicrm_option_group where name = 'cg_extend_objects'; | |
11 | ||
10824d34 | 12 | INSERT INTO civicrm_option_value |
6a488035 TO |
13 | (option_group_id, {localize field='label'}label{/localize}, value, name, grouping, filter, is_default, weight, is_optgroup, is_reserved, is_active, component_id, visibility_id) |
14 | VALUES | |
15 | (@option_group_id_cgeo, {localize}'{ts escape="sql"}Survey{/ts}'{/localize}, 'Survey', 'civicrm_survey', NULL, 0, NULL, 1, 0, 0, 1, NULL, NULL); |