DROP TABLE IF EXISTS `creature_template_temp`;
CREATE TABLE `creature_template_temp` (
  `entry` mediumint(8) unsigned NOT NULL default '0',
  `mindmg` mediumint(8) unsigned NOT NULL default '0',
  `maxdmg` mediumint(8) unsigned NOT NULL default '0',
  `dmgschool` mediumint(8) unsigned NOT NULL default '0',
  `attackpower` mediumint(8) unsigned NOT NULL default '0',
  `dmg_multiplier` mediumint(8) unsigned NOT NULL default '0',
  `baseattacktime` mediumint(8) unsigned NOT NULL default '0',
  `rangeattacltime` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Temp Table';

insert into creature_template_temp (`entry`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacltime`) values select `entry`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacltime` from creature_template;