sql/updates/0.6/3090_creature_template.sql

   1 ALTER TABLE `creature_template`
   2   ADD COLUMN `pickpocketloot` int(10) unsigned NOT NULL default '0' AFTER `lootid`;
   3
   4 UPDATE `creature_template`,`pickpocketing_loot_template`
   5   SET `creature_template`.`pickpocketloot` = `creature_template`.`lootid`
   6   WHERE `creature_template`.`lootid` = `pickpocketing_loot_template`.`entry`;