View Single Post
  #1  
Old 07-15-2009, 03:45 PM
mixxit
Hill Giant
 
Join Date: Sep 2006
Posts: 155
Default 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;
Reply With Quote