CREATE TABLE `catalog_category_entity_url_key` (

  `value_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Value ID',

  `entity_type_id` smallint(5) unsigned NOT NULL COMMENT 'Entity Type ID',

  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',

  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',

  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',

  `value` varchar(255) DEFAULT NULL COMMENT 'Category Url Key',

  PRIMARY KEY (`value_id`),

  UNIQUE KEY `UNQ_CATALOG_CATEGORY_ENTITY_URL_KEY_ENTITY_ID_STORE_ID` (`entity_id`,`store_id`),

  KEY `IDX_CATALOG_CATEGORY_ENTITY_URL_KEY_ATTRIBUTE_ID` (`attribute_id`),

  KEY `IDX_CATALOG_CATEGORY_ENTITY_URL_KEY_STORE_ID` (`store_id`),

  KEY `IDX_CATALOG_CATEGORY_ENTITY_URL_KEY_ENTITY_ID` (`entity_id`),

  CONSTRAINT `FK_CATALOG_CATEGORY_ENTITY_URL_KEY_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `FK_CAT_CTGR_ENTT_URL_KEY_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `FK_CAT_CTGR_ENTT_URL_KEY_ENTT_ID_CAT_CTGR_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE

) ENGINE=InnoDB AUTO_INCREMENT=1411 DEFAULT CHARSET=utf8 COMMENT='Catalog Category Url Key Attribute Backend Table'