DROP TABLE IF EXISTS `bro_wechat_menu`; CREATE TABLE `bro_wechat_menu` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `index` bigint(20) DEFAULT NULL, `parent_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '父id', `type` varchar(24) NOT NULL DEFAULT '' COMMENT '菜单类型 null主菜单 link链接 keys关键字', `name` varchar(256) NOT NULL DEFAULT '' COMMENT '菜单名称', `content` text NOT NULL COMMENT '文字内容', `sort` bigint(20) unsigned DEFAULT '0' COMMENT '排序', `status` tinyint(1) unsigned DEFAULT '1' COMMENT '状态(0禁用1启用)', `create_by` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '创建人', `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', PRIMARY KEY (`id`), KEY `index_wechat_menu_pindex` (`parent_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=365 DEFAULT CHARSET=utf8 COMMENT='微信菜单配置';