Context Navigation

3032_creature.sql @ 2

Revision 2, 326 bytes (checked in by yumileroy, 17 years ago)

[svn] * Proper SVN structure

Original author: Neo2003
Date: 2008-10-02 16:23:55-05:00

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

Note: See TracBrowser for help on using the browser.