Log in

View Full Version : Proximities Table / Task Master


mixxit
07-15-2009, 03:45 PM
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;