CREATE DATABASE  IF NOT EXISTS `auto_admin` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `auto_admin`;

/*菜单表*/
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `url` varchar(200) DEFAULT NULL,
  `icon` varchar(50) DEFAULT NULL,
  `parent_id` bigint(20) NOT NULL DEFAULT '0',
  `order_no` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `update_time` int NOT NULL COMMENT '更新时间',
  `create_time` int NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;


/*系统角色表*/
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL COMMENT '名称',
  `des` varchar(300) DEFAULT NULL COMMENT '描述',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `update_time` int NOT NULL COMMENT '更新时间',
  `create_time` int NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


/*系统角色权限表*/
DROP TABLE IF EXISTS `sys_role_permission`;
CREATE TABLE `sys_role_permission` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `role_id` bigint(20) NOT NULL,
  `menu_id` bigint(20) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `update_time` int NOT NULL COMMENT '更新时间',
  `create_time` int NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


/*系统用户表*/
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `account` varchar(30) NOT NULL COMMENT '账号',
  `password` varchar(36) NOT NULL COMMENT '密码',
  `name` varchar(30) NOT NULL COMMENT '姓名',
  `salt` varchar(36) NOT NULL COMMENT '密码加密盐',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `update_time` int NOT NULL COMMENT '更新时间',
  `create_time` int NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


/*系统用户角色表*/
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL,
  `role_id` bigint(20) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `update_time` int NOT NULL COMMENT '更新时间',
  `create_time` int NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


/*

初始化数据
 创建超级管理用户，默认账号密码都为admin
*/

INSERT INTO `menu` VALUES (1,'系统','','layui-icon-set',0,0,0,1571194240,1571194240);
INSERT INTO `menu` VALUES (2,'菜单管理','/admin/menu/menuView','',1,1,0,1571194240,1571194240);
INSERT INTO `menu` VALUES (3,'角色管理','/admin/sysRole/sysRoleView','',1,2,0,1571194240,1571194240);
INSERT INTO `menu` VALUES (4,'系统用户','/admin/sysUser/sysUserView','',1,3,0,1571194240,1571194240);

INSERT INTO `sys_role` VALUES (1,'超级管理员','超级管理员',0,1571194240,1571194240);
INSERT INTO `sys_role_permission` VALUES (1,1,1,0,1571194240,1571194240);

INSERT INTO `sys_user` VALUES (1,'admin','5a8595d82228d6015aea78682df657f9','Admin','df54a192-bbf0-43ca-b4be-0484e56559bc',0,1571194240,1571194240);
INSERT INTO `sys_user_role` VALUES (1,1,1,0,1571194240,1571194240);