Error de sintaxis de MySQL

[gnzsoloyo]

Te falta el DEFAUL antes de '/var/spool/mail'.

Código MySQL:

CREATE TABLE  `usuarios` (
  `address` varchar(255) NOT NULL,
  `clear` varchar(20) NOT NULL,
  `uid` int(5) unsigned default '5000',
  `gid` int(5) unsigned default '5000',
  `name` varchar(128) NOT NULL,
  `home` varchar(128) NOT NULL default '/var/spool/mail',
  `domain` varchar(128) NOT NULL,
  `maildir` varchar(255) NOT NULL,
  `active` char(1) NOT NULL default '1',
  PRIMARY KEY  (`address`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;