UPDATE `skinning_loot_template` SET `maxcount` = 10 ; #剥皮最大产量为10单位
UPDATE `skinning_loot_template` SET `mincountOrRef` = 5 ; #剥皮最小产量为5单位
UPDATE `fishing_loot_template` SET `maxcount` = 10 ; #钓鱼
UPDATE `skinning_loot_template` SET `maxcount`='100' WHERE `item`='8169' ;#厚毛皮
UPDATE `skinning_loot_template` SET `mincountOrRef`='50' WHERE `item`='8169' ;#厚毛皮
UPDATE `skinning_loot_template` SET `maxcount`='100' WHERE `item`='4232' ;#中毛皮
UPDATE `skinning_loot_template` SET `mincountOrRef`='50' WHERE `item`='4232' ;#中毛皮
UPDATE `skinning_loot_template` SET `maxcount`='100' WHERE `item`='783' ;#轻毛皮
UPDATE `skinning_loot_template` SET `mincountOrRef`='50' WHERE `item`='783' ;#轻毛皮
UPDATE `skinning_loot_template` SET `maxcount`='100' WHERE `item`='8171' ;#硬甲毛皮
UPDATE `skinning_loot_template` SET `mincountOrRef`='50' WHERE `item`='8171' ;#硬甲毛皮
UPDATE `creature_loot_template` SET `maxcount`='10' WHERE `item`='2589' ;#亚麻布最大产量为10
UPDATE `creature_loot_template` SET `maxcount`='10' WHERE `item`='2592' ;#毛料
UPDATE `creature_loot_template` SET `maxcount`='10' WHERE `item`='4306' ;#丝绸
UPDATE `creature_loot_template` SET `maxcount`='10' WHERE `item`='4338' ;#魔纹布
UPDATE `creature_loot_template` SET `maxcount`='10' WHERE `item`='14047' ;#符文布
UPDATE `creature_loot_template` SET `maxcount`='10' WHERE `item`='14256' ;#恶魔布
UPDATE `creature_loot_template` SET `maxcount`='10' WHERE `item`='21877' ;#灵纹布
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='765' ;#银叶草
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='765' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='2447' ;#宁神花
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='2447' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='2449' ;#地根草
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='2449' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='785' ;#魔皇草
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='785' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='2452' ;#雨燕草
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='2452' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='2450' ;#石南草
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='2450' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='2453' ;#跌打草
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='2453' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='3355' ;#野钢花
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='3355' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='3356' ;#皇血草
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='3356' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='3369' ;#墓地苔
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='3369' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='2041' ;#活根草
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='2041' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='2042' ;#枯叶草
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='2042' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='3358' ;#卡德加的胡须
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='3358' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='3357' ;#活根草
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='3357' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='2044' ;#冬刺草
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='2044' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='3820' ;#荆棘藻
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='3820' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='3821' ;#金棘草
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='3821' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='4625' ;#火焰花
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='4625' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='8831' ;#紫莲花
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='8831' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='8153' ;#野葡萄藤
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='8153' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='8836' ;#阿尔萨斯之泪
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='8836' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='11514' ;#魔藤
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='11514' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='8838' ;#太阳草
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='8838' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='8839' ;#盲目草
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='8839' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='8845' ;#幽灵菇
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='8845' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='8846' ;#格罗姆之血
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='8846' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='13464' ;#黄金参
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='13464' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='13463' ;#梦叶草
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='13463' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='13465' ;#山鼠草
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='13465' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='13466' ;#瘟疫花
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='13466' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='19726' ;#血藤
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='19726' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='13467' ;#冰盖草
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='13467' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='13468' ;#黑莲花
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='13468' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='2770' ;#铜矿石
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='2770' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='50' WHERE `item`='2835' ;#劣质的石头
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='25' WHERE `item`='2835' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='50' WHERE `item`='2836' ;#粗糙的石头
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='25' WHERE `item`='2836' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='2771' ;#锡矿石
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='2771' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='2775' ;#银矿石
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='2775' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='50' WHERE `item`='2838' ;#沉重的石头
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='25' WHERE `item`='2838' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='2772' ;#铁矿石
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='2772' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='50' WHERE `item`='11513' ;#被污染的硫酸盐
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='25' WHERE `item`='11513' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='2776' ;#金矿石
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='2776' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='50' WHERE `item`='9262' ;#黑色硫酸盐
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='25' WHERE `item`='9262' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='50' WHERE `item`='7912' ;#坚固的石头
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='25' WHERE `item`='7912' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='3858' ; #秘银矿石
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='3858' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='7911' ; #真银矿石
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='7911' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='50' WHERE `item`='12363' ; #奥术水晶
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='25' WHERE `item`='12363' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='50' WHERE `item`='12365' ; #厚重的石头
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='25' WHERE `item`='12365' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='10620' ; #瑟银矿石
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='10620' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='50' WHERE `item`='11754' ; #黑钻石
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='25' WHERE `item`='11754' ;
UPDATE `gameobject_loot_template` SET `maxcount` ='20' WHERE `item`='11370' ; #黑铁矿石
UPDATE `gameobject_loot_template` SET `mincountOrRef` ='10' WHERE `item`='11370' ;
UPDATE `creature_loot_template` SET `maxcount`='10' WHERE `item`='818' ; #虎眼石
UPDATE `creature_loot_template` SET `mincountOrRef`='5' WHERE `item`='818' ; #虎眼石
UPDATE `creature_loot_template` SET `maxcount`='10' WHERE `item`='774' ; #孔雀石
UPDATE `creature_loot_template` SET `mincountOrRef`='5' WHERE `item`='774' ; #孔雀石
UPDATE `creature_loot_template` SET `maxcount`='10' WHERE `item`='1210' ; #暗影石
UPDATE `creature_loot_template` SET `mincountOrRef`='5' WHERE `item`='1210' ; #暗影石
UPDATE `creature_loot_template` SET `maxcount`='10' WHERE `item`='1206' ; #绿玛瑙
UPDATE `creature_loot_template` SET `mincountOrRef`='5' WHERE `item`='1206' ; #绿玛瑙
UPDATE `creature_loot_template` SET `maxcount`='10' WHERE `item`='1705' ; #次级月亮石
UPDATE `creature_loot_template` SET `mincountOrRef`='5' WHERE `item`='1705' ; #次级月亮石
UPDATE `creature_loot_template` SET `maxcount`='10' WHERE `item`='1529' ; #翡翠
UPDATE `creature_loot_template` SET `mincountOrRef`='5' WHERE `item`='1529' ; #翡翠
UPDATE `creature_loot_template` SET `maxcount`='10' WHERE `item`='7909' ; #青绿石
UPDATE `creature_loot_template` SET `mincountOrRef`='5' WHERE `item`='7909' ; #青绿石
UPDATE `creature_loot_template` SET `maxcount`='10' WHERE `item`='7910' ; #黄水晶
UPDATE `creature_loot_template` SET `mincountOrRef`='5' WHERE `item`='7910' ; #黄水晶
UPDATE `creature_loot_template` SET `maxcount`='10' WHERE `item`='12799' ; #大猫眼石
UPDATE `creature_loot_template` SET `mincountOrRef`='5' WHERE `item`='12799' ; #大猫眼石
UPDATE `creature_loot_template` SET `maxcount`='10' WHERE `item`='12361' ; #蓝宝石
UPDATE `creature_loot_template` SET `mincountOrRef`='5' WHERE `item`='12361' ; #蓝宝石
UPDATE `creature_loot_template` SET `maxcount`='10' WHERE `item`='12800' ; #艾泽拉斯钻石
UPDATE `creature_loot_template` SET `mincountOrRef`='5' WHERE `item`='12800' ; #艾泽拉斯钻石
UPDATE `creature_loot_template` SET `maxcount`='10' WHERE `item`='12364' ; #巨型绿宝石
UPDATE `creature_loot_template` SET `mincountOrRef`='5' WHERE `item`='12364' ; #巨型绿宝石
UPDATE `creature_loot_template` SET `maxcount`='10' WHERE `item`='12363' ; #奥术水晶
UPDATE `creature_loot_template` SET `mincountOrRef`='5' WHERE `item`='12363' ; #奥术水晶
UPDATE `prospecting_loot_template` SET `maxcount`='100' WHERE `item`='12364' ; #巨型绿宝石
UPDATE `prospecting_loot_template` SET `mincountOrRef`='50' WHERE `item`='12364' ; #巨型绿宝石