Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | -- CRM-6400 |
2 | INSERT INTO civicrm_uf_group | |
3 | (name, group_type, {localize field='title'}title{/localize}, is_reserved ) VALUES | |
4 | ('summary_overlay', 'Contact', {localize}'Summary Overlay'{/localize}, 1 ); | |
10824d34 | 5 | |
6a488035 TO |
6 | SELECT @uf_group_id_summary := max(id) from civicrm_uf_group where name = 'summary_overlay'; |
7 | ||
8 | INSERT INTO civicrm_uf_join | |
9 | (is_active,module,entity_table,entity_id,weight,uf_group_id) VALUES | |
10 | (1, 'Profile', NULL, NULL, 6, @uf_group_id_summary ); | |
10824d34 | 11 | |
6a488035 TO |
12 | INSERT INTO civicrm_uf_field |
13 | ( uf_group_id, field_name, is_required, is_reserved, weight, visibility, in_selector, is_searchable, location_type_id, {localize field='label'}label{/localize},field_type ) VALUES | |
10824d34 | 14 | ( @uf_group_id_summary, 'phone' ,1, 0, 1, 'User and User Admin Only', 0, 0, 1, {localize}'Home Phone'{/localize}, 'Contact'), |
15 | ( @uf_group_id_summary, 'phone' ,1, 0, 2, 'User and User Admin Only', 0, 0, 2, {localize}'Home Mobile'{/localize}, 'Contact' ), | |
16 | ( @uf_group_id_summary, 'street_address', 1, 0, 3, 'User and User Admin Only', 0, 0, NULL, {localize}'Primary Address'{/localize}, 'Contact' ), | |
17 | ( @uf_group_id_summary, 'city', 1, 0, 4, 'User and User Admin Only', 0, 0, NULL, {localize}'City'{/localize}, 'Contact' ), | |
18 | ( @uf_group_id_summary, 'state_province', 1, 0, 5, 'User and User Admin Only', 0, 0, NULL, {localize}'State'{/localize}, 'Contact' ), | |
19 | ( @uf_group_id_summary, 'postal_code', 1, 0, 6, 'User and User Admin Only', 0, 0, NULL, {localize}'Postal Code'{/localize}, 'Contact' ), | |
20 | ( @uf_group_id_summary, 'email', 1, 0, 7, 'User and User Admin Only', 0, 0, NULL, {localize}'Primary Email'{/localize}, 'Contact' ), | |
21 | ( @uf_group_id_summary, 'group', 1, 0, 8, 'User and User Admin Only', 0, 0, NULL, {localize}'Groups'{/localize}, 'Contact' ), | |
22 | ( @uf_group_id_summary, 'tag', 1, 0, 9, 'User and User Admin Only', 0, 0, NULL, {localize}'Tags'{/localize}, 'Contact' ), | |
23 | ( @uf_group_id_summary, 'gender', 1, 0, 10, 'User and User Admin Only', 0, 0, NULL, {localize}'Gender'{/localize}, 'Individual' ), | |
24 | ( @uf_group_id_summary, 'birth_date', 1, 0, 11, 'User and User Admin Only', 0, 0, NULL, {localize}'Date of Birth'{/localize}, 'Individual' ); | |
6a488035 TO |
25 | |
26 | -- CRM-6416 | |
27 | SELECT @option_group_id_ceOpt := max(id) from civicrm_option_group where name = 'contact_edit_options'; | |
28 | SELECT @option_value_ceOpt := max(round(value)) from civicrm_option_value where option_group_id = @option_group_id_ceOpt; | |
29 | SELECT @option_weight_ceOpt := max(round(weight)) from civicrm_option_value where option_group_id = @option_group_id_ceOpt; | |
30 | ||
10824d34 | 31 | INSERT INTO |
32 | civicrm_option_value (`option_group_id`, {localize field='label'}`label`{/localize}, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `is_optgroup`, `is_reserved`, `is_active`, `component_id`, `domain_id`, `visibility_id`) | |
6a488035 TO |
33 | VALUES( @option_group_id_ceOpt, {localize}'Website'{/localize}, @option_value_ceOpt+1, 'Website', NULL, 1, NULL, @option_weight_ceOpt+1, 0, 0, 1, NULL, NULL, NULL ); |
34 | ||
35 | UPDATE civicrm_preferences SET contact_edit_options = CONCAT(contact_edit_options, @option_value_ceOpt+1, '\ 1'); | |
36 | ||
37 | -- CRM-6410 | |
38 | SELECT @bounceTypeID := MAX(id) FROM civicrm_mailing_bounce_type WHERE name = 'Invalid'; | |
39 | INSERT INTO civicrm_mailing_bounce_pattern (bounce_type_id, pattern) VALUES (@bounceTypeID, '^Validation failed for:'); |