-- ##################################################################################
--  Conservation Resources Database Update Script 
--  Affects Table:  [gras].[d_forage_partition_activity_type_national_defaults] 
--  CSU ALM Tracker Item:  #92405  [ http://alm.engr.colostate.edu/cb/issue/92405 ] 
-- ##################################################################################


USE conservation_resources

BEGIN TRANSACTION update_min_grazing_util_pct

  UPDATE [conservation_resources].[gras].[d_forage_partition_activity_type_national_defaults] 
    SET min_allowed_grazing_utilization_pct=35 
        WHERE forage_partition_activity_default_harvest_efficiency_id in (2,3,4);

COMMIT TRANSACTION update_min_grazing_util_pct

