documentation/Reference Code/Wedge/installation/mysql/is4c_op/tables/UNFI.table
use is4c_op;
DROP TABLE IF EXISTS `UNFI`;
CREATE TABLE `UNFI` (
`brand` varchar(30) default NULL,
`sku` int(6) default NULL,
`size` varchar(25) default NULL,
`upc` bigint(13) unsigned zerofill NOT NULL default '0000000000000',
`units` int(3) default NULL,
`cost` decimal(9,2) default NULL,
`description` varchar(35) default NULL,
`depart` varchar(15) default NULL,
PRIMARY KEY (`upc`),
KEY `newindex` (`upc`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;