root/trunk/sql/updates/0.6/3075_gameobject.sql @ 2

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';