Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `products_attributes_new` (
- `products_attributes_id` INT(11) NOT NULL AUTO_INCREMENT,
- `products_id` INT(11) NOT NULL DEFAULT '0',
- `attributes_stock` INT(4) NULL DEFAULT NULL,
- `attributes_stock_added` INT(4) NULL DEFAULT NULL,
- `attributes_stock_log` INT(4) NULL DEFAULT NULL,
- `sortorder` INT(11) NULL DEFAULT NULL,
- `products_attributes_1c_id` VARCHAR(36) NULL DEFAULT NULL,
- `attributes_convolution` VARCHAR(1024) NULL DEFAULT NULL,
- `products_name` VARCHAR(255) NOT NULL DEFAULT '',
- `products_description` TEXT NOT NULL,
- `products_weight` DECIMAL(5,2) NOT NULL DEFAULT '0',
- `products_status` TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
- `products_attributes_1c_buh_id` VARCHAR(11) NULL DEFAULT NULL,
- `article_supplier` VARCHAR(255) NULL DEFAULT NULL,
- `delivery_quantity` INT(10) NULL DEFAULT NULL COMMENT 'Количество товаров доставляемое от поставщика по заказам (аггрегатный столбец)',
- `delivery_quantity_custom` INT(10) NULL DEFAULT NULL COMMENT 'Информация от поставщика о количестве товаров в поставке',
- `stock_quantity` INT(10) NULL DEFAULT NULL COMMENT 'Количество товаров на складе (аггрегатный столбец)',
- `catalog_products_attributes_id` INT(11) NULL DEFAULT NULL,
- `is_fragile` ENUM('glass','simple','n') NULL DEFAULT 'n',
- `last_date_update` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- PRIMARY KEY (`products_attributes_id`),
- INDEX `products_id` (`products_id`),
- INDEX `products_attributes_1c_id` (`products_attributes_1c_id`),
- INDEX `products_attributes_1c_buh_id` (`products_attributes_1c_buh_id`),
- INDEX `catalog_products_attributes_id` (`catalog_products_attributes_id`),
- INDEX `products_name` (`products_name`),
- INDEX `products_status` (`products_status`),
- INDEX `article_supplier` (`article_supplier`),
- INDEX `last_date_update` (`last_date_update`)
- )
- COLLATE='utf8_general_ci'
- ENGINE=InnoDB
- -- AUTO_INCREMENT=70076949
- ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement