RBAC建表SQL

CREATE TABLE IF NOT EXISTS `user` (
  `id` int(32) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `is_delete` tinyint(2) DEFAULT '0' COMMENT '是否删除(0.未删除;1.已删除)',
  `operator` varchar(32) DEFAULT NULL COMMENT '操作人',
  `username` varchar(32) NOT NULL DEFAULT '' COMMENT '用户',
  `password` varchar(64) NOT NULL DEFAULT '' COMMENT '密码',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户表';

CREATE TABLE IF NOT EXISTS `role` (
  `id` int(32) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `is_delete` tinyint(2) DEFAULT '0' COMMENT '是否删除(0.未删除;1.已删除)',
  `operator` varchar(32) DEFAULT NULL COMMENT '操作人',
  `role_name` varchar(64) NOT NULL COMMENT '角色名称',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色表';

CREATE TABLE IF NOT EXISTS  `role_user` (
  `id` int(32) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `is_delete` tinyint(2) DEFAULT '0' COMMENT '是否删除(0.未删除;1.已删除)',
  `operator` varchar(32) DEFAULT NULL COMMENT '操作人',
  `role_id` int(32) DEFAULT NULL COMMENT 'roleid',
  `user_id` int(32) DEFAULT NULL COMMENT 'userid',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色用户表';

CREATE TABLE IF NOT EXISTS `menu` (
  `id` int(32) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `is_delete` tinyint(2) DEFAULT '0' COMMENT '是否删除(0.未删除;1.已删除)',
  `operator` varchar(32) DEFAULT NULL COMMENT '操作人',
  `menu_name` varchar(64) NOT NULL DEFAULT '' COMMENT '菜单名称',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='菜单表';


CREATE TABLE IF NOT EXISTS `role_menu` (
  `id` int(32) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `is_delete` tinyint(2) DEFAULT '0' COMMENT '是否删除(0.未删除;1.已删除)',
  `operator` varchar(32) DEFAULT NULL COMMENT '操作人',
  `role_id` int(32) DEFAULT NULL COMMENT 'role id',
  `menu_id` int(32) DEFAULT NULL COMMENT '菜单id',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色菜单表';