SHARE
TWEET

Untitled

a guest Jun 19th, 2019 63 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE `products_attributes_new` (
  2.     `products_attributes_id` INT(11) NOT NULL AUTO_INCREMENT,
  3.     `products_id` INT(11) NOT NULL DEFAULT '0',
  4.     `attributes_stock` INT(4) NULL DEFAULT NULL,
  5.     `attributes_stock_added` INT(4) NULL DEFAULT NULL,
  6.     `attributes_stock_log` INT(4) NULL DEFAULT NULL,
  7.     `sortorder` INT(11) NULL DEFAULT NULL,
  8.     `products_attributes_1c_id` VARCHAR(36) NULL DEFAULT NULL,
  9.     `attributes_convolution` VARCHAR(1024) NULL DEFAULT NULL,
  10.     `products_name` VARCHAR(255) NOT NULL DEFAULT '',
  11.     `products_description` TEXT NOT NULL,
  12.     `products_weight` DECIMAL(5,2) NOT NULL DEFAULT '0',
  13.     `products_status` TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
  14.     `products_attributes_1c_buh_id` VARCHAR(11) NULL DEFAULT NULL,
  15.     `article_supplier` VARCHAR(255) NULL DEFAULT NULL,
  16.     `delivery_quantity` INT(10) NULL DEFAULT NULL COMMENT 'Количество товаров доставляемое от поставщика по заказам (аггрегатный столбец)',
  17.     `delivery_quantity_custom` INT(10) NULL DEFAULT NULL COMMENT 'Информация от поставщика о количестве товаров в поставке',
  18.     `stock_quantity` INT(10) NULL DEFAULT NULL COMMENT 'Количество товаров на складе (аггрегатный столбец)',
  19.     `catalog_products_attributes_id` INT(11) NULL DEFAULT NULL,
  20.     `is_fragile` ENUM('glass','simple','n') NULL DEFAULT 'n',
  21.     `last_date_update` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  22.     PRIMARY KEY (`products_attributes_id`),
  23.     INDEX `products_id` (`products_id`),
  24.     INDEX `products_attributes_1c_id` (`products_attributes_1c_id`),
  25.     INDEX `products_attributes_1c_buh_id` (`products_attributes_1c_buh_id`),
  26.     INDEX `catalog_products_attributes_id` (`catalog_products_attributes_id`),
  27.     INDEX `products_name` (`products_name`),
  28.     INDEX `products_status` (`products_status`),
  29.     INDEX `article_supplier` (`article_supplier`),
  30.     INDEX `last_date_update` (`last_date_update`)
  31. )
  32. COLLATE='utf8_general_ci'
  33. ENGINE=InnoDB
  34. -- AUTO_INCREMENT=70076949
  35. ;
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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top