What in the world is wrong with this table...

[Night4554]

CREATE TABLE `listings` (
  `id` int(11) NOT NULL auto_increment,
  `formName` varchar(255) NOT NULL default 'freePostingForm',
  `dataPresent` varchar(255) NOT NULL default 'dataPresent',
  `areaID` varchar(255) NOT NULL default '',
  `subAreaID` varchar(255) NOT NULL default '',
  `categoryID` varchar(255) NOT NULL default '',
  `neighborhood` varchar(255) NOT NULL default '',
  `mix` varchar(255) NOT NULL default '',
  `ptype` varchar(255) NOT NULL default '',
  `posting_key` text NOT NULL,
  `ask` varchar(9) NOT NULL default '',
  `postingSubject` varchar(70) NOT NULL default '',
  `location` varchar(80) NOT NULL default '',
  `postingDescription` text NOT NULL,
  `postingReplyEm` varchar(60) NOT NULL default '',
  `xstreet0` varchar(80) NOT NULL default '',
  `xstreet1` varchar(80) NOT NULL default '',
  `city` varchar(80) NOT NULL default '',
  `state` varchar(40) NOT NULL default '',
  `okToContact` tinyint(2) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

And I get this:

ALTER TABLE `listings` ADD `privacy` VARCHAR NOT NULL AFTER `postingReplyEm` 

MySQL said: 


You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL AFTER `postingReplyEm`' at line 1

And why...? I can't add any named column there. "other", "p" anything.

[LordShryku]

varchar needs to have a size...

ALTER TABLE listings ADD privacy VARCHAR(???) NOT NULL AFTER postingReplyEm

[drawmack]

here take the error messages advice and check the manual.

[Night4554]

Thank You very much Lord!