crm.fsf.org/20131203/files/sites/all/modules-old/civicrm/CRM/Upgrade/Incremental/sql/4.1.beta1.mysql.tpl

   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
   8 INSERT INTO civicrm_option_value
   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);