CREATE TABLE `anc_products` (
  `id` int(11) NOT NULL auto_increment,
  `SKU` int(11) NOT NULL default '0',
  `sName` text NOT NULL,
  `sDescription` text,
  `bFreeShipping` tinyint(1) NOT NULL default '0',
  `nCategory` int(11) NOT NULL default '-1',
  `eGender` enum('m','w','u') NOT NULL default 'u',
  `nOrder` int(11) NOT NULL default '1',
  `sFeatureColor` text,
  PRIMARY KEY  (`id`),
  KEY `ix_sname` (`sName`(255)),
  KEY `ix_sku` (`SKU`)
) TYPE=MyISAM AUTO_INCREMENT=7 ;