/*
Navicat MySQL Data Transfer

Source Server         : 本地mariadb
Source Server Version : 50505
Source Host           : localhost:3306
Source Database       : ant_db

Target Server Type    : MYSQL
Target Server Version : 50505
File Encoding         : 65001

Date: 2020-07-10 17:42:39
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `ant_admin_user`
-- ----------------------------
DROP TABLE IF EXISTS `ant_admin_user`;
CREATE TABLE `ant_admin_user` (
  `aid` int(11) NOT NULL AUTO_INCREMENT COMMENT '管理员id',
  `user_name` varchar(55) NOT NULL COMMENT '管理员名字',
  `password` varchar(64) NOT NULL COMMENT '管理员密码',
  `role_id` int(11) DEFAULT NULL COMMENT '所属角色',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0 禁用 1 启用',
  `create_time` datetime NOT NULL COMMENT '添加时间',
  `last_login_time` datetime DEFAULT NULL COMMENT '上次登录时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remarks` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`aid`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='管理员';

-- ----------------------------
-- Records of ant_admin_user
-- ----------------------------
INSERT INTO `ant_admin_user` VALUES ('1', 'admin_ant', 'b61ee0b37bff4a4b73b2678074d7af97763da3c1', '1', '1', '2020-07-03 13:31:20', '2020-07-10 16:10:01', '2020-07-08 10:24:18', '');

-- ----------------------------
-- Table structure for `ant_article`
-- ----------------------------
DROP TABLE IF EXISTS `ant_article`;
CREATE TABLE `ant_article` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '标题',
  `subtitle` varchar(150) DEFAULT NULL COMMENT '副标题',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1 启用  0 关闭',
  `img_url` varchar(150) NOT NULL COMMENT '图片',
  `imgs_url` varchar(500) DEFAULT NULL COMMENT '多图  用 ;切割',
  `content` text COMMENT '内容',
  `add_uid` int(11) NOT NULL COMMENT '添加人',
  `create_time` datetime NOT NULL,
  `update_uid` int(11) NOT NULL,
  `update_time` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='文章';

-- ----------------------------
-- Records of ant_article
-- ----------------------------
INSERT INTO `ant_article` VALUES ('1', '更努力更奋斗', '方向只是一部分，努力了么。', '1', '/uploads/image/1/Article/54/963d062b7a1b0af100a716d0565dae.png', '/uploads/image/1/Article/b2/5b7d902d3f699f52838dd62d1d42de.jpg;/uploads/image/1/Article/7e/455cea3e80a70dc857916a5288940e.jpg;/uploads/image/1/Article/c1/eb1a0cda98e8b49c3f433029850769.jpg', '<p>人生不就是走走停停，时不时停下来看看身边的东西，很多美好的事情就在身侧。</p><h4>（<em>错把陈醋</em>当成墨,写尽半生都是酸）走对路，很重要。珍惜当下，也很重要！', '1', '2020-07-10 16:28:58', '1', '2020-07-10 16:28:58');

-- ----------------------------
-- Table structure for `ant_login_log`
-- ----------------------------
DROP TABLE IF EXISTS `ant_login_log`;
CREATE TABLE `ant_login_log` (
  `log_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '日志id',
  `uid` int(11) NOT NULL COMMENT '登录用户',
  `login_ip` varchar(15) NOT NULL COMMENT '登录ip',
  `login_area` varchar(55) DEFAULT NULL COMMENT '登录地区',
  `create_time` datetime DEFAULT NULL COMMENT '登录时间',
  PRIMARY KEY (`log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='登录日志';

-- ----------------------------
-- Records of ant_login_log
-- ----------------------------

-- ----------------------------
-- Table structure for `ant_node`
-- ----------------------------
DROP TABLE IF EXISTS `ant_node`;
CREATE TABLE `ant_node` (
  `node_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '角色id',
  `node_name` varchar(50) NOT NULL COMMENT '节点英文名称',
  `node_enname` varchar(50) NOT NULL,
  `node_path` varchar(55) NOT NULL DEFAULT '#' COMMENT '节点路径',
  `node_pid` int(11) NOT NULL COMMENT '所属节点',
  `node_order` mediumint(5) NOT NULL DEFAULT '0',
  `node_icon` varchar(55) DEFAULT NULL COMMENT '节点图标',
  `is_menu` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否是菜单项 1 不是 2 是',
  `add_time` datetime DEFAULT NULL COMMENT '添加时间',
  PRIMARY KEY (`node_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='节点菜单表';

-- ----------------------------
-- Records of ant_node
-- ----------------------------
INSERT INTO `ant_node` VALUES ('1', '初始菜单', 'Home page', '/adminback/index/index', '0', '1000', 'layui-icon layui-icon-home', '1', '2020-07-03 14:17:38');
INSERT INTO `ant_node` VALUES ('2', '首页', 'Home', '/adminback/index/welcome', '1', '0', '', '1', '2020-07-03 14:18:24');
INSERT INTO `ant_node` VALUES ('3', '修改密码', 'Change Password', '/adminback/UserManage/editpwd', '1', '0', '', '1', '2020-07-03 14:19:03');
INSERT INTO `ant_node` VALUES ('4', '权限管理', 'Authority Management', '#', '0', '0', 'layui-icon layui-icon-template', '2', '2020-07-03 14:19:34');
INSERT INTO `ant_node` VALUES ('5', '管理员管理', 'Manage Administrator', '/adminback/UserManage/index', '4', '0', '', '2', '2020-07-03 14:27:42');
INSERT INTO `ant_node` VALUES ('6', '添加管理员', 'Add Administrator', 'adminback/UserManage/addAdminUser', '5', '0', '', '1', '2020-07-03 14:28:26');
INSERT INTO `ant_node` VALUES ('7', '编辑管理员', 'Edit Administrator', '/adminback/UserManage/editAdminUser', '5', '0', '', '1', '2020-07-03 14:28:43');
INSERT INTO `ant_node` VALUES ('8', '删除管理员', 'Remove Administrator', '/adminback/UserManage/delAdminUser', '5', '0', '', '1', '2020-07-03 14:29:14');
INSERT INTO `ant_node` VALUES ('9', '日志管理', 'Log Manage', '#', '0', '3', 'layui-icon layui-icon-table', '2', '2020-07-08 16:07:36');
INSERT INTO `ant_node` VALUES ('10', '清除菜单缓存', 'Clear Menu Cache', '/adminback/index/clearMenuCache', '1', '0', null, '1', '2020-07-07 14:41:07');
INSERT INTO `ant_node` VALUES ('11', '登录日志', 'Login log', '/adminback/log/loginLog', '9', '2', '', '2', '2020-07-08 16:26:27');
INSERT INTO `ant_node` VALUES ('12', '操作日志', 'Operation log', '/adminback/log/operateLog', '9', '0', '', '2', '2020-07-08 17:02:10');
INSERT INTO `ant_node` VALUES ('13', '角色管理', 'Role Manage', '/adminback/role/index', '4', '0', '', '2', '2020-07-09 21:35:54');
INSERT INTO `ant_node` VALUES ('14', '添加角色', 'Add Role', '/adminback/role/add', '13', '0', '', '1', '2020-07-09 21:40:06');
INSERT INTO `ant_node` VALUES ('15', '编辑角色', 'Edit Role', '/adminback/role/edit', '13', '0', '', '1', '2020-07-09 21:40:53');
INSERT INTO `ant_node` VALUES ('16', '删除角色', 'Delete Role', '/adminback/role/delete', '13', '0', '', '1', '2020-07-09 21:41:07');
INSERT INTO `ant_node` VALUES ('17', '权限分配', 'Permission Assignment', '/adminback/role/roleSetting', '13', '0', '', '1', '2020-07-09 21:41:38');
INSERT INTO `ant_node` VALUES ('18', '节点管理', 'Node Manage', '/adminback/node/index', '4', '0', '', '2', '2020-07-09 21:42:06');
INSERT INTO `ant_node` VALUES ('19', '添加节点', 'Add Node', '/adminback/node/add', '18', '0', '', '1', '2020-07-09 21:42:51');
INSERT INTO `ant_node` VALUES ('20', '编辑节点', 'Edit Node', '/adminback/node/edit', '18', '0', '', '1', '2020-07-09 21:43:29');
INSERT INTO `ant_node` VALUES ('21', '删除节点', 'Delete Node', '/adminback/node/delete', '18', '0', '', '1', '2020-07-09 21:43:44');
INSERT INTO `ant_node` VALUES ('22', '拉黑（启用）管理员', 'Blackout (enable) administrator', '/adminback/UserManage/statusAdminUser', '5', '0', '', '1', null);
INSERT INTO `ant_node` VALUES ('23', '拉黑（启用）角色', 'Blackout (Enable) Eole', '/adminback/role/statusRole', '13', '0', '', '1', null);
INSERT INTO `ant_node` VALUES ('24', '文章管理', 'Article Management', '#', '0', '2', 'layui-icon layui-icon-read', '2', '2020-07-08 10:47:57');
INSERT INTO `ant_node` VALUES ('25', '文章列表', 'Article List', '/adminback/Article/index', '24', '0', '', '2', '2020-07-08 10:49:42');
INSERT INTO `ant_node` VALUES ('26', '添加文章', 'Add Article', '/adminback/Article/add', '25', '0', '', '1', '2020-07-10 14:33:59');
INSERT INTO `ant_node` VALUES ('27', '修改文章', 'Edit Article', '/adminback/Article/edit', '25', '0', '', '1', '2020-07-10 14:35:14');
INSERT INTO `ant_node` VALUES ('28', '删除文章', 'Delete Article', '/adminback/Article/delete', '25', '0', '', '1', '2020-07-10 14:36:42');
INSERT INTO `ant_node` VALUES ('29', '禁用（启用）文章', 'Blackout (Enable) Article', '/adminback/Article/statusArticle', '25', '0', '', '1', '2020-07-10 14:37:56');

-- ----------------------------
-- Table structure for `ant_operate_log`
-- ----------------------------
DROP TABLE IF EXISTS `ant_operate_log`;
CREATE TABLE `ant_operate_log` (
  `log_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '操作日志id',
  `uid` varchar(55) NOT NULL COMMENT '操作用户',
  `operator_ip` varchar(15) NOT NULL COMMENT '操作者ip',
  `operate_desc` varchar(5000) NOT NULL COMMENT '操作简述',
  `create_time` datetime NOT NULL COMMENT '操作时间',
  PRIMARY KEY (`log_id`),
  KEY `uid_idx` (`uid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='操作日志';

-- ----------------------------
-- Records of ant_operate_log
-- ----------------------------

-- ----------------------------
-- Table structure for `ant_role`
-- ----------------------------
DROP TABLE IF EXISTS `ant_role`;
CREATE TABLE `ant_role` (
  `role_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '角色id',
  `role_name` varchar(55) NOT NULL COMMENT '角色名称',
  `role_node` varchar(300) NOT NULL COMMENT '角色拥有的权限节点',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '角色状态 1 启用 0 禁用',
  `remarks` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`role_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='角色';

-- ----------------------------
-- Records of ant_role
-- ----------------------------
INSERT INTO `ant_role` VALUES ('1', '超级管理员', '', '1', '拥有所有权限');