Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | -- CRM-8356 added missing option values |
2 | SELECT @option_group_id_acConRef := max(id) from civicrm_option_group where name = 'contact_reference_options'; | |
3 | ||
10824d34 | 4 | INSERT INTO civicrm_option_value |
5 | (option_group_id, {localize field='label'}label{/localize}, value, name, filter, weight, is_active ) | |
6a488035 TO |
6 | VALUES |
7 | (@option_group_id_acConRef, {localize}'{ts escape="sql"}Email Address{/ts}'{/localize} , 2, 'email' , 0, 2, 1 ), | |
8 | (@option_group_id_acConRef, {localize}'{ts escape="sql"}Phone{/ts}'{/localize} , 3, 'phone' , 0, 3, 1 ), | |
9 | (@option_group_id_acConRef, {localize}'{ts escape="sql"}Street Address{/ts}'{/localize} , 4, 'street_address', 0, 4, 1 ), | |
10 | (@option_group_id_acConRef, {localize}'{ts escape="sql"}City{/ts}'{/localize} , 5, 'city' , 0, 5, 1 ), | |
11 | (@option_group_id_acConRef, {localize}'{ts escape="sql"}State/Province{/ts}'{/localize} , 6, 'state_province', 0, 6, 1 ), | |
12 | (@option_group_id_acConRef, {localize}'{ts escape="sql"}Country{/ts}'{/localize} , 7, 'country' , 0, 7, 1 ); |