Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `catalog_product_index_price` (
- `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
- `customer_group_id` smallint(5) unsigned NOT NULL COMMENT 'Customer Group ID',
- `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
- `tax_class_id` smallint(5) unsigned DEFAULT '0' COMMENT 'Tax Class ID',
- `price` decimal(12,4) DEFAULT NULL COMMENT 'Price',
- `final_price` decimal(12,4) DEFAULT NULL COMMENT 'Final Price',
- `min_price` decimal(12,4) DEFAULT NULL COMMENT 'Min Price',
- `max_price` decimal(12,4) DEFAULT NULL COMMENT 'Max Price',
- `tier_price` decimal(12,4) DEFAULT NULL COMMENT 'Tier Price',
- `group_price` decimal(12,4) DEFAULT NULL COMMENT 'Group price',
- `udmp_new_min_price` decimal(12,4) DEFAULT NULL,
- `udmp_new_max_price` decimal(12,4) DEFAULT NULL,
- `udmp_new_cnt` int(10) DEFAULT NULL,
- `udmp_used_min_price` decimal(12,4) DEFAULT NULL,
- `udmp_used_max_price` decimal(12,4) DEFAULT NULL,
- `udmp_used_cnt` int(10) DEFAULT NULL,
- PRIMARY KEY (`entity_id`,`customer_group_id`,`website_id`),
- KEY `IDX_CATALOG_PRODUCT_INDEX_PRICE_CUSTOMER_GROUP_ID` (`customer_group_id`),
- KEY `IDX_CATALOG_PRODUCT_INDEX_PRICE_WEBSITE_ID` (`website_id`),
- KEY `IDX_CATALOG_PRODUCT_INDEX_PRICE_MIN_PRICE` (`min_price`),
- KEY `IDX_CAT_PRD_IDX_PRICE_WS_ID_CSTR_GROUP_ID_MIN_PRICE` (`website_id`,`customer_group_id`,`min_price`),
- CONSTRAINT `FK_CAT_PRD_IDX_PRICE_CSTR_GROUP_ID_CSTR_GROUP_CSTR_GROUP_ID` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE ON UPDATE CASCADE,
- CONSTRAINT `FK_CAT_PRD_IDX_PRICE_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
- CONSTRAINT `FK_CAT_PRD_IDX_PRICE_WS_ID_CORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Price Index Table'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement