UPDATE item_template SET armor = armor*1.1 where quality=3;
UPDATE item_template SET armor = armor*1.2 where quality=4;
UPDATE item_template SET armor = armor*1.4 where quality=5;
UPDATE item_template SET armor = armor*1.14 where quality=5 and name LIKE '%|cFF00FFFF%';
UPDATE item_template SET armor = armor*1.3 where quality=5 and name LIKE '%|cffffff00%';
UPDATE item_template SET armor = armor*1.42 where quality=5 and name LIKE '%|cffff0000%';
UPDATE item_template SET dmg_min1 = dmg_min1*1.1 where quality=3;
UPDATE item_template SET dmg_min1 = dmg_min1*1.2 where quality=4;
UPDATE item_template SET dmg_min1 = dmg_min1*1.4 where quality=5;
UPDATE item_template SET dmg_min1 = dmg_min1*1.14 where quality=5 and name LIKE '%|cFF00FFFF%';
UPDATE item_template SET dmg_min1 = dmg_min1*1.3 where quality=5 and name LIKE '%|cffffff00%';
UPDATE item_template SET dmg_min1 = dmg_min1*1.42 where quality=5 and name LIKE '%|cffff0000%';