| products | CREATE TABLE `products` (
  `product_id` int(10) NOT NULL default '0',
  `product_code` varchar(20) default NULL,
  `brand` varchar(100) default NULL,
  `product_name` varchar(255) default NULL,
  `manufacturer_id` int(10) default NULL,
  `product_type` varchar(255) default NULL,
  `description` text,
  `rrp` varchar(20) default NULL,
  `potsize` int(20) default NULL,
  `frequency_of_use` varchar(255) default NULL,
  `lasts` varchar(255) default NULL,
  `ingredients_id` text
) TYPE=MyISAM |