-- +--------------------------------------------------------------------+
--- | CiviCRM version 5 |
--- +--------------------------------------------------------------------+
--- | Copyright CiviCRM LLC (c) 2004-2017 |
--- +--------------------------------------------------------------------+
--- | This file is a part of CiviCRM. |
--- | |
--- | CiviCRM is free software; you can copy, modify, and distribute it |
--- | under the terms of the GNU Affero General Public License |
--- | Version 3, 19 November 2007 and the CiviCRM Licensing Exception. |
--- | |
--- | CiviCRM is distributed in the hope that it will be useful, but |
--- | WITHOUT ANY WARRANTY; without even the implied warranty of |
--- | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. |
--- | See the GNU Affero General Public License for more details. |
+-- | Copyright CiviCRM LLC. All rights reserved. |
-- | |
--- | You should have received a copy of the GNU Affero General Public |
--- | License and the CiviCRM Licensing Exception along |
--- | with this program; if not, contact CiviCRM LLC |
--- | at info[AT]civicrm[DOT]org. If you have questions about the |
--- | GNU Affero General Public License or the licensing of CiviCRM, |
--- | see the CiviCRM license FAQ at http://civicrm.org/licensing |
+-- | This work is published under the GNU AGPLv3 license with some |
+-- | permitted exceptions and without any warranty. For full license |
+-- | and copyright information, see https://civicrm.org/licensing |
-- +--------------------------------------------------------------------+
-- * create option group for storing custom options for custom fields
-- *
-- *******************************************************/
-INSERT INTO `civicrm_option_group` (`name`, `title`, `is_reserved`, `is_active`) VALUES ('custom_most_important_issue', 'Most Important Issue', 1, 1), ( 'custom_marital_status', 'Marital Status', 1, 1);
+INSERT INTO `civicrm_option_group` (`name`, `title`, `is_reserved`, `is_active`) VALUES ('custom_most_important_issue', 'Most Important Issue', 0, 1), ( 'custom_marital_status', 'Marital Status', 1, 1);
SELECT @option_most_id := max(id) from civicrm_option_group where name = 'custom_most_important_issue';
SELECT @option_marital_id := max(id) from civicrm_option_group where name = 'custom_marital_status';
-- Fall Fundraiser Dinner participants’ custom data
-INSERT INTO civicrm_option_group ( name, title, is_active, is_reserved ) VALUES ('soup_selection', 'Soup Selection', 1, 1);
+INSERT INTO `civicrm_option_group` (`name`, `title`, `is_reserved`, `is_active`) VALUES ('soup_selection', 'Soup Selection', 0, 1);
SELECT @ogid := MAX(id) FROM civicrm_option_group;
INSERT INTO civicrm_custom_group ( name, title, extends, extends_entity_column_id, extends_entity_column_value, style, is_active, table_name) VALUES ('Food_Preference', 'Food Preference', 'Participant', 2, '\ 11\ 1', 'Inline', 1, 'civicrm_value_food_preference_2');
SELECT @cgid_contribution := MAX(id) FROM civicrm_custom_group;
-INSERT INTO civicrm_option_group ( name, title, is_active ) VALUES ('how_long_have_you_been_a_donor', 'How long have you been a donor?', 1);
+INSERT INTO `civicrm_option_group` (`name`, `title`, `is_reserved`, `is_active`) VALUES ('how_long_have_you_been_a_donor', 'How long have you been a donor?', 0, 1);
SELECT @ogid_contribution := MAX(id) FROM civicrm_option_group;