master

分支 (1)

管理

管理

master

ysm-admin
/
yms.sql

/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50726
 Source Host           : localhost:3306
 Source Schema         : yms

 Target Server Type    : MySQL
 Target Server Version : 50726
 File Encoding         : 65001

 Date: 18/05/2021 15:29:37
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for yms_aconfig
-- ----------------------------
DROP TABLE IF EXISTS `yms_aconfig`;
CREATE TABLE `yms_aconfig`  (
  `cid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '配置id',
  `name` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '配置名',
  `value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '配置值',
  `tab` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '分类 ',
  `type` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '类型(0,text;1,img;2,json)',
  `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '状态(0,正常;1,禁用;)',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '描述',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '后台用户创建时间',
  `update_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '后台用户更新时间',
  PRIMARY KEY (`cid`) USING BTREE,
  UNIQUE INDEX `name`(`name`) USING BTREE,
  INDEX `create_time`(`create_time`) USING BTREE,
  INDEX `update_time`(`update_time`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '后台配置' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of yms_aconfig
-- ----------------------------

-- ----------------------------
-- Table structure for yms_alogs
-- ----------------------------
DROP TABLE IF EXISTS `yms_alogs`;
CREATE TABLE `yms_alogs`  (
  `alid` tinyint(3) NOT NULL AUTO_INCREMENT COMMENT '后台日志id',
  `adid` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '后台用户id',
  `type` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '类型',
  `addlogip` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '127.0.0.1' COMMENT '后台用户ip',
  `describe` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '描述',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
  `update_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
  PRIMARY KEY (`alid`) USING BTREE,
  INDEX `create_time`(`create_time`) USING BTREE,
  INDEX `update_time`(`update_time`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '后台日志表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of yms_alogs
-- ----------------------------

-- ----------------------------
-- Table structure for yms_apower
-- ----------------------------
DROP TABLE IF EXISTS `yms_apower`;
CREATE TABLE `yms_apower`  (
  `powerid` tinyint(4) NOT NULL AUTO_INCREMENT COMMENT '后台权限id',
  `columnid` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '所属栏目(0为顶级)',
  `powername` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '后台权限名',
  `controller` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '后台权限访问(如:admin/admin/admin)',
  `class` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '后台权限图标',
  `type` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '权限类型(1菜单,2方法)',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '状态(0正常,1禁用)',
  `describe` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '描述',
  `weight` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '权重,越小越靠前',
  PRIMARY KEY (`powerid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '后台权限表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of yms_apower
-- ----------------------------
INSERT INTO `yms_apower` VALUES (1, 0, '系统', '', '', 1, 0, '系统相关', 0);
INSERT INTO `yms_apower` VALUES (2, 1, '设置', 'Config/Index', '', 1, 1, '设置', 1);
INSERT INTO `yms_apower` VALUES (3, 1, '节点', 'Node/index', '', 1, 0, '节点相关', 2);
INSERT INTO `yms_apower` VALUES (4, 3, '节点保存', 'Node/save', '', 2, 0, '添加/编辑节点', 0);
INSERT INTO `yms_apower` VALUES (5, 3, '节点删除', 'Node/del', '', 2, 0, '删除节点', 0);
INSERT INTO `yms_apower` VALUES (6, 1, '首页', 'Index/index', '', 1, 0, '首页展示', 0);
INSERT INTO `yms_apower` VALUES (7, 1, '用户', 'User/index', '', 1, 0, '后台用户', 4);
INSERT INTO `yms_apower` VALUES (8, 1, '角色', 'Role/index', '', 1, 0, '权限管理', 5);
INSERT INTO `yms_apower` VALUES (9, 7, '用户保存', 'User/save', '', 2, 0, '用户添加,编辑', 0);
INSERT INTO `yms_apower` VALUES (10, 7, '用户删除', 'User/del', '', 2, 0, '删除用户', 0);
INSERT INTO `yms_apower` VALUES (11, 1, '其他操作', '', '', 1, 1, '针对额外操作', 99);
INSERT INTO `yms_apower` VALUES (12, 11, '图片上传', 'Admin/uploads', '', 2, 0, '图片上传', 0);
INSERT INTO `yms_apower` VALUES (13, 3, '权限展示', 'Role/power', '', 2, 0, '', 3);
INSERT INTO `yms_apower` VALUES (14, 3, '权限保存', 'Node/powerSave', '', 2, 0, '', 0);

-- ----------------------------
-- Table structure for yms_arole
-- ----------------------------
DROP TABLE IF EXISTS `yms_arole`;
CREATE TABLE `yms_arole`  (
  `roleid` tinyint(3) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '后台角色id',
  `rolename` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '后台角色名',
  `powerid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '后台角色权限集',
  `status` tinyint(4) UNSIGNED NOT NULL COMMENT '角色状态:0禁用;1正常',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
  `update_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
  PRIMARY KEY (`roleid`) USING BTREE,
  INDEX `create_time`(`create_time`) USING BTREE,
  INDEX `update_time`(`update_time`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '后台角色表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of yms_arole
-- ----------------------------
INSERT INTO `yms_arole` VALUES (1, '超级管理员', '1,6,2,3,4,5,7,9,10,8', 1, 0, 1621303609);
INSERT INTO `yms_arole` VALUES (2, '测试角色', '1,6,2,3,4,5,7,9,10,8', 1, 1618470588, 1621303863);

-- ----------------------------
-- Table structure for yms_auser
-- ----------------------------
DROP TABLE IF EXISTS `yms_auser`;
CREATE TABLE `yms_auser`  (
  `adid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '后台用户id',
  `adname` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '后台用户名',
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '后台用户密码',
  `salt` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '盐',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '后台用户状态(1正常,0禁止)',
  `rid` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '后台用户所属角色',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '后台用户创建时间',
  `update_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '后台用户更新时间',
  PRIMARY KEY (`adid`) USING BTREE,
  UNIQUE INDEX `adname`(`adname`) USING BTREE,
  INDEX `create_time`(`create_time`) USING BTREE,
  INDEX `update_time`(`update_time`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '后台用户表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of yms_auser
-- ----------------------------
INSERT INTO `yms_auser` VALUES (1, 'admin', '53942f595d61bf73d45bfa5bc2a8ff89', 'TZbK', 1, 1, 1616564925, 1621243978);
INSERT INTO `yms_auser` VALUES (2, 'yms', 'f635174aba770331b9a1b27f40005b9b', 'Clg7', 1, 2, 1618296362, 1621243955);

SET FOREIGN_KEY_CHECKS = 1;