[civicrm-core.git] / CRM / Upgrade / Incremental / sql / 4.1.beta1.mysql.tpl

{if $addWightForActivity}
  ALTER TABLE `civicrm_activity` ADD weight INT( 11 ) NULL DEFAULT NULL;
{/if}

-- CRM-8508
SELECT @option_group_id_cgeo := max(id) from civicrm_option_group where name = 'cg_extend_objects';

INSERT INTO civicrm_option_value
   (option_group_id, {localize field='label'}label{/localize}, value, name, grouping, filter, is_default, weight, {localize field='description'}description{/localize}, is_optgroup, is_reserved, is_active, component_id, visibility_id)
VALUES
   (@option_group_id_cgeo, {localize}'{ts escape="sql"}Cases{/ts}'{/localize},  'Case',   'civicrm_case',   NULL, 0, NULL, 2, {localize}'CRM_Case_PseudoConstant::caseType;'{/localize}, 0, 0, 1, NULL, NULL);
Commit	Line	Data
6a488035 TO	1	{if $addWightForActivity}
	2	ALTER TABLE `civicrm_activity` ADD weight INT( 11 ) NULL DEFAULT NULL;
	3	{/if}
	4
	5	-- CRM-8508
	6	SELECT @option_group_id_cgeo := max(id) from civicrm_option_group where name = 'cg_extend_objects';
	7
10824d34	8	INSERT INTO civicrm_option_value
6a488035 TO	9	(option_group_id, {localize field='label'}label{/localize}, value, name, grouping, filter, is_default, weight, {localize field='description'}description{/localize}, is_optgroup, is_reserved, is_active, component_id, visibility_id)
	10	VALUES
	11	(@option_group_id_cgeo, {localize}'{ts escape="sql"}Cases{/ts}'{/localize}, 'Case', 'civicrm_case', NULL, 0, NULL, 2, {localize}'CRM_Case_PseudoConstant::caseType;'{/localize}, 0, 0, 1, NULL, NULL);