1 /*delete redundant column from creature table*/
2 ALTER TABLE `creature` ADD COLUMN `spawntimesecs` int(11) unsigned NOT NULL default '120' AFTER `spawntimemin`;
4 UPDATE creature SET `spawntimesecs`= (spawntimemin + spawntimemax) /2;
6 ALTER TABLE creature DROP COLUMN spawntimemax;
7 ALTER TABLE creature DROP COLUMN spawntimemin;