-- Alembic Revision: bdbcca2c4ba0d5

CREATE TABLE `menu_category_types` (
  `_cache_id` varchar(128) COLLATE utf8_bin NOT NULL,
  `id` varchar(64) COLLATE utf8_bin NOT NULL,
  `name` varchar(128) COLLATE utf8_bin DEFAULT NULL,
  `_registered_property_values` blob,
  PRIMARY KEY (`_cache_id`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

   ALTER TABLE `menu_categories`
    ADD COLUMN `menu_category_type_id` varchar(64) COLLATE utf8_bin DEFAULT NULL,
ADD CONSTRAINT `fk_menu_categories_menu_category_type_id` FOREIGN KEY (`_cache_id`, `menu_category_type_id`) REFERENCES `menu_category_types` (`_cache_id`, `id`);
