[7297] Fixed profession spells sorting in trainer spell list at client.

[getmangos.git] / sql / updates / 0.6 / 3075_gameobject.sql

ALTER TABLE `gameobject`
  CHANGE `respawntimer` `spawntimesecs` int(11) unsigned NOT NULL default '0';

UPDATE `gameobject` SET `spawntimesecs` = `spawntimesecs` / 1000;

DROP TABLE IF EXISTS `gameobject_respawn`;
CREATE TABLE `gameobject_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';