sql/updates/0.6/3075_creature.sql


1
2
3
4
5
6
7
8

ALTER TABLE creature DROP COLUMN respawntimer;

DROP TABLE IF EXISTS `creature_respawn`;
CREATE TABLE `creature_respawn` (
  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
  `respawntime` bigint(40) NOT NULL default '0',
  PRIMARY KEY (`guid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Grid Loading System';