# 角色用户中间表role\_user ## 数据表 ``` DROP TABLE IF EXISTS `cmf_role_user`; CREATE TABLE `cmf_role_user` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `role_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '角色 id', `user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '用户id', PRIMARY KEY (`id`), KEY `group_id` (`role_id`), KEY `user_id` (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='用户角色对应表'; ```