daily pastebin goal
32%
SHARE
TWEET

Untitled

a guest Nov 9th, 2017 62 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE IF NOT EXISTS `prefix_product` (
  2.   `product_id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `model` varchar(64) NOT NULL,
  4.   `sku` varchar(64) NOT NULL,
  5.   `upc` varchar(12) NOT NULL,
  6.   `ean` varchar(14) NOT NULL,
  7.   `jan` varchar(13) NOT NULL,
  8.   `isbn` varchar(13) NOT NULL,
  9.   `mpn` varchar(64) NOT NULL,
  10.   `location` varchar(128) NOT NULL,
  11.   `quantity` int(4) NOT NULL DEFAULT '0',
  12.   `stock_status_id` int(11) NOT NULL,
  13.   `image` varchar(255) DEFAULT NULL,
  14.   `manufacturer_id` int(11) NOT NULL,
  15.   `shipping` tinyint(1) NOT NULL DEFAULT '1',
  16.   `price` decimal(15,4) NOT NULL DEFAULT '0.0000',
  17.   `cost` decimal(15,4) NOT NULL DEFAULT '0.0000',
  18.   `cost_amount` decimal(15,4) NOT NULL DEFAULT '0.0000',
  19.   `cost_percentage` decimal(15,2) NOT NULL DEFAULT '0.00',
  20.   `cost_additional` decimal(15,4) NOT NULL DEFAULT '0.0000',
  21.   `points` int(8) NOT NULL DEFAULT '0',
  22.   `tax_class_id` int(11) NOT NULL,
  23.   `date_available` date NOT NULL,
  24.   `weight` decimal(15,8) NOT NULL DEFAULT '0.00000000',
  25.   `weight_class_id` int(11) NOT NULL DEFAULT '0',
  26.   `length` decimal(15,8) NOT NULL DEFAULT '0.00000000',
  27.   `width` decimal(15,8) NOT NULL DEFAULT '0.00000000',
  28.   `height` decimal(15,8) NOT NULL DEFAULT '0.00000000',
  29.   `length_class_id` int(11) NOT NULL DEFAULT '0',
  30.   `subtract` tinyint(1) NOT NULL DEFAULT '1',
  31.   `minimum` int(11) NOT NULL DEFAULT '1',
  32.   `sort_order` int(11) NOT NULL DEFAULT '0',
  33.   `shipping_cost` decimal(15,4) NOT NULL DEFAULT '0.0000',
  34.   `status` tinyint(1) NOT NULL DEFAULT '0',
  35.   `date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  36.   `date_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  37.   `viewed` int(5) NOT NULL DEFAULT '0',
  38.   `schemа` varchar(255) NOT NULL,
  39.   `meta_robots` varchar(40) NOT NULL,
  40.   PRIMARY KEY (`product_id`),
  41.   UNIQUE KEY `product_id` (`product_id`),
  42.   KEY `product_id_2` (`product_id`),
  43.   KEY `product_id_3` (`product_id`),
  44.   KEY `model` (`model`),
  45.   KEY `stock_status_id` (`stock_status_id`),
  46.   KEY `manufacturer_id` (`manufacturer_id`),
  47.   KEY `tax_class_id` (`tax_class_id`),
  48.   KEY `weight_class_id` (`weight_class_id`),
  49.   KEY `length_class_id` (`length_class_id`),
  50.   KEY `model_2` (`model`),
  51.   KEY `sku` (`sku`),
  52.   KEY `upc` (`upc`),
  53.   KEY `manufacturer_id_2` (`manufacturer_id`),
  54.   KEY `sort_order` (`sort_order`),
  55.   KEY `status` (`status`)
  56. ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11278 ;
  57.  
  58.  
  59.  
  60.  
  61. CREATE TABLE IF NOT EXISTS `prefix_product_to_category` (
  62.   `product_id` int(11) NOT NULL,
  63.   `category_id` int(11) NOT NULL,
  64.   PRIMARY KEY (`product_id`,`category_id`),
  65.   KEY `category_id` (`category_id`),
  66.   KEY `category_id_2` (`category_id`)
  67. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top