Skip to content

Instantly share code, notes, and snippets.

@jimwhimpey

jimwhimpey/gist:8866956

Created February 7, 2014 17:01
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save jimwhimpey/8866956 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save jimwhimpey/8866956 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. jimwhimpey created this gist Feb 7, 2014.
    27 changes: 27 additions & 0 deletions gistfile1.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,27 @@
    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;