heres a basic products table.
CREATE TABLE `Products` (
`ProductID` int(11) NOT NULL AUTO_INCREMENT,
`ProductSKU` varchar(50) DEFAULT NULL,
`ProductName` varchar(100) NOT NULL,
`ProductPrice` float(12,2) NOT NULL,
`ProductShipping` float(12,2) DEFAULT NULL,
`ProductWeight` float(12,2) DEFAULT NULL,
`ProductCartDesc` varchar(250) DEFAULT NULL,
`ProductShortDesc` varchar(1000) DEFAULT NULL,
`ProductLongDesc` text,
`ProductThumb` varchar(100) NOT NULL,
`ProductImage` varchar(100) NOT NULL,
PRIMARY KEY (`ProductID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8
