From 4183323fb4fd54346cbf3c824d24021a3f7729c3 Mon Sep 17 00:00:00 2001 From: Coleman Watts Date: Tue, 22 Mar 2022 08:51:06 -0400 Subject: [PATCH] SampleData - Fix missing option value names --- sql/civicrm_sample_custom_data.mysql | 18 +++++++++--------- 1 file changed, 9 insertions(+), 9 deletions(-) diff --git a/sql/civicrm_sample_custom_data.mysql b/sql/civicrm_sample_custom_data.mysql index 91abd7b371..eefd6bd4af 100644 --- a/sql/civicrm_sample_custom_data.mysql +++ b/sql/civicrm_sample_custom_data.mysql @@ -42,15 +42,15 @@ SELECT @option_marital_id := max(id) from civicrm_option_group where name = 'cus -- * create option values (custom options for custom fields) -- * -- *******************************************************/ -INSERT INTO `civicrm_option_value` (`option_group_id`, `label`, `value`, `weight`, `is_active`, `is_default`) - VALUES (@option_most_id , 'Education', 'Edu', 1, 1,0), - (@option_most_id , 'Environment', 'Env', 2, 1,0), - (@option_most_id , 'Social Justice', 'SocJus', 3, 1,0), - (@option_marital_id, 'Single', 'S', 1, 1,0), - (@option_marital_id, 'Married', 'M', 2, 1,0), - (@option_marital_id, 'Domestic Partner', 'D', 3, 1,0), - (@option_marital_id, 'Widowed', 'W', 4, 1,0), - (@option_marital_id, 'Other', 'O', 5, 1,0); +INSERT INTO `civicrm_option_value` (`option_group_id`, `label`, `name`, `value`, `weight`, `is_active`, `is_default`) + VALUES (@option_most_id , 'Education', 'Education', 'Edu', 1, 1,0), + (@option_most_id , 'Environment', 'Environment', 'Env', 2, 1,0), + (@option_most_id , 'Social Justice', 'Social_Justice', 'SocJus', 3, 1,0), + (@option_marital_id, 'Single', 'Single', 'S', 1, 1,0), + (@option_marital_id, 'Married', 'Married', 'M', 2, 1,0), + (@option_marital_id, 'Domestic Partner', 'Domestic_Partner', 'D', 3, 1,0), + (@option_marital_id, 'Widowed', 'Widowed', 'W', 4, 1,0), + (@option_marital_id, 'Other', 'Other', 'O', 5, 1,0); -- /******************************************************* -- 2.25.1