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