DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
                        `id` int NOT NULL AUTO_INCREMENT,
                        `menu_group_id` int NOT NULL,
                        `desc` text NOT NULL,
                        `icon` text NOT NULL,
                        `image` varchar(200) DEFAULT '',
                        `menu_type` varchar(10) NOT NULL DEFAULT 'backend',
                        `parent_id` int NOT NULL,
                        `status` tinyint(1) NOT NULL DEFAULT '1',
                        `presenter` varchar(55) NOT NULL,
                        `sort` int DEFAULT '0',
                        `shop_id` int NOT NULL DEFAULT '0',
                        `date_added` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
                        PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb3;