EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Development::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=596)
-   -   Proximities Table / Task Master (https://www.eqemulator.org/forums/showthread.php?t=28904)

mixxit 07-15-2009 03:45 PM

Proximities Table / Task Master
 
hey all,

Might have missed a sql update here - if so can you point me int he right direction. If not, to use the proximities in Task Master i've changed the proximities table to avoid the error

[Debug] [07.15.09 - 20:33:02] MySQL Error: Field 'minx' doesn't have a default value

DROP TABLE IF EXISTS `ax_classic`.`proximities`;
CREATE TABLE `ax_classic`.`proximities` (
`zoneid` int(10) unsigned NOT NULL,
`exploreid` int(10) unsigned NOT NULL,
`minx` float(14,6) NOT NULL DEFAULT '0.000000',
`maxx` float(14,6) NOT NULL DEFAULT '1.000000',
`miny` float(14,6) NOT NULL DEFAULT '0.000000',
`maxy` float(14,6) NOT NULL DEFAULT '1.000000',
`minz` float(14,6) NOT NULL DEFAULT '0.000000',
`maxz` float(14,6) NOT NULL DEFAULT '1.000000',
PRIMARY KEY (`zoneid`,`exploreid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


All times are GMT -4. The time now is 12:25 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.