Вот Вам структура таблицы product:
CREATE TABLE `product` (
`product_id` int(11) NOT NULL auto_increment,
`model` varchar(64) NOT NULL,
`sku` varchar(64) NOT NULL,
`location` varchar(128) NOT NULL,
`quantity` int(4) NOT NULL default '0',
`stock_status_id` int(11) NOT NULL,
`image` varchar(255) default NULL,
`manufacturer_id` int(11) NOT NULL,
`shipping` int(1) NOT NULL default '1',
`price` decimal(15,4) NOT NULL default '0.0000',
`tax_class_id` int(11) NOT NULL,
`date_available` date NOT NULL,
`weight` decimal(5,2) NOT NULL default '0.00',
`weight_class_id` int(11) NOT NULL default '0',
`length` decimal(5,2) NOT NULL default '0.00',
`width` decimal(5,2) NOT NULL default '0.00',
`height` decimal(5,2) NOT NULL default '0.00',
`length_class_id` int(11) NOT NULL default '0',
`status` int(1) NOT NULL default '0',
`date_added` datetime NOT NULL default '0000-00-00 00:00:00',
`date_modified` datetime NOT NULL default '0000-00-00 00:00:00',
`viewed` int(5) NOT NULL default '0',
`sort_order` int(11) NOT NULL default '0',
`subtract` int(1) NOT NULL default '1',
`minimum` int(11) NOT NULL default '1',
`cost` decimal(15,4) NOT NULL default '0.0000',
`main_category_id` int(11) default NULL,
PRIMARY KEY (`product_id`),
KEY `status` (`status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;