CREATE TABLE `products` (
  `pro_id` int(11) NOT NULL auto_increment,
  `pro_name` varchar(255) NOT NULL,
  `pro_sdesc` text NOT NULL,
  `pro_desc` longtext NOT NULL,
  `pro_reference` varchar(255) NOT NULL,
  `pro_ean` varchar(255) NOT NULL,
  `pro_upc` varchar(255) NOT NULL,
  `pro_active` varchar(100) NOT NULL,
  `pro_price` varchar(255) NOT NULL,
  `pro_pricefob` varchar(255) NOT NULL,
  `pro_wholesaleprice` varchar(255) NOT NULL,
  `pro_height` varchar(255) NOT NULL,
  `pro_weight` varchar(255) NOT NULL,
  `pro_depth` varchar(255) NOT NULL,
  `pro_width` varchar(255) NOT NULL,
  `com_id` int(11) NOT NULL,
  `cli_id` int(11) NOT NULL,
  `cat_id` int(11) NOT NULL,
  PRIMARY KEY  (`pro_id`)
) ENGINE=MyISAM ;