-- Alembic Revision: 6ce2245413b5

CREATE TABLE `menu_item_versions` (
  `_cache_id` varchar(128) COLLATE utf8_bin NOT NULL,
  `menu_item_id` varchar(64) COLLATE utf8_bin NOT NULL,
  `version_string` varchar(64) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`_cache_id`,`menu_item_id`,`version_string`),
  KEY `idx_menu_item_versions_version_string` (`_cache_id`,`version_string`),
  CONSTRAINT `fk_menu_item_version_menu_items` FOREIGN KEY (`_cache_id`, `menu_item_id`) REFERENCES `menu_items` (`_cache_id`, `id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
