--- CAUTION: use this update only once and before the 2642_loot_template update from mangos.
--- quest items, that do not drop FOR a quest, but rather START a quest, are not really "quest items" as such
UPDATE `creature_loot_template`
  SET `chance` = `questchance`,`questchance` = '0'
  WHERE `item` IN (19018,19002,19003,18422,18423,21220,20644,16408,10454,8704,8623,8705,16304,16305,7666,16303,11446,2839,3317,4881,2794,2874,3668,12564,18987,13140,12558,5352,1357,5877,12842,12771,4903,20310,11668,12780,1962,10441,1307,9326,11818,5138,13250,13920,5099,10000,5179,10589,18972,18969,9250,5103,1972) AND `chance` = 0 AND `questchance` != 0;

UPDATE `gameobject_loot_template`
  SET `chance` = `questchance`,`questchance` = '0'
  WHERE `item` IN (18703,18706,4926,4851,3706,5791,6172,4433) AND `chance` = 0 AND `questchance` != 0;

--- preparation for tinyint in questchance
UPDATE `creature_loot_template`
  SET `questchance` = ROUND(questchance)
  WHERE `questchance` != 0;
  
UPDATE `gameobject_loot_template`
  SET `questchance` = ROUND(questchance)
  WHERE `questchance` != 0;

UPDATE `creature_loot_template`
  SET `questchance` = '1'
  WHERE `questchance` < 1 AND `questchance` > 0;

UPDATE `gameobject_loot_template`
  SET `questchance` = '1'
  WHERE `questchance` < 1 AND `questchance` > 0;