gistfile1.sql

CREATE TABLE `products` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `merchant_id` int(11) DEFAULT NULL,
  `merchant_name` text,
  `merchant_product_id` text,
  `name` text,
  `url_merchant` text,
  `url_affiliate` text,
  `description` text,
  `price_gbp` float DEFAULT NULL,
  `price_aud` float DEFAULT NULL,
  `price_usd` float DEFAULT NULL,
  `updated_gbp` datetime DEFAULT NULL,
  `updated_aud` datetime DEFAULT NULL,
  `updated_usd` datetime DEFAULT NULL,
  `image_large` text,
  `image_small` text,
  `model_number` text,
  `delivery_time` text,
  `delivery_cost` float DEFAULT NULL,
  `stock_available` tinyint(1) DEFAULT NULL,
  `stock_quantity` int(11) DEFAULT NULL,
  `brand_name` text,
  `specifications` text,
  `available` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=113317 DEFAULT CHARSET=utf8;