tp6api
/
tp6api.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 本地5.7
 Source Server Type    : MySQL
 Source Server Version : 50726
 Source Host           : localhost:3306
 Source Schema         : tp6api

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

 Date: 04/08/2020 18:36:04
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for ai_sys_config
-- ----------------------------
DROP TABLE IF EXISTS `ai_sys_config`;
CREATE TABLE `ai_sys_config`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '配置标题',
  `key` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '配置项英文名称',
  `value` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '配置项值',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '配置说明',
  `status` tinyint(1) NULL DEFAULT 1 COMMENT '状态1开启 2关闭',
  `update_time` timestamp(0) NULL DEFAULT NULL COMMENT '更新时间',
  `add_time` timestamp(0) NULL DEFAULT NULL COMMENT '新增时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of ai_sys_config
-- ----------------------------
INSERT INTO `ai_sys_config` VALUES (1, '测试配置', 'cspz', '1', '测试配置说明', 1, NULL, '2020-07-24 01:31:38');
INSERT INTO `ai_sys_config` VALUES (2, '测试配A置', 'cspz', '1121', '测试配置说明二', 1, NULL, '2020-07-24 01:36:01');

-- ----------------------------
-- Table structure for ai_sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `ai_sys_menu`;
CREATE TABLE `ai_sys_menu`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NULL DEFAULT 0 COMMENT '上级菜单 0为顶级菜单',
  `menu_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '菜单名称',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '菜单地址',
  `icon` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图标',
  `sort` int(11) NULL DEFAULT 50 COMMENT '排序越小越靠前',
  `is_show` tinyint(1) NULL DEFAULT 1 COMMENT '是否显示1显示 2不显示',
  `status` tinyint(1) NULL DEFAULT 1 COMMENT '状态1开启 2关闭',
  `add_time` timestamp(0) NULL DEFAULT NULL COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `parent_id`(`parent_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of ai_sys_menu
-- ----------------------------
INSERT INTO `ai_sys_menu` VALUES (1, 0, '权限管理', '', '', 5, 1, 1, NULL);
INSERT INTO `ai_sys_menu` VALUES (2, 1, '角色管理', '/tools/role', NULL, 50, 1, 1, NULL);
INSERT INTO `ai_sys_menu` VALUES (3, 2, '角色列表', '/tools/role/lists', NULL, 50, 1, 1, NULL);
INSERT INTO `ai_sys_menu` VALUES (4, 3, '新增角色', '/tools/role/add', NULL, 50, 1, 1, NULL);
INSERT INTO `ai_sys_menu` VALUES (5, 3, '编辑角色', '/tools/role/edit', NULL, 50, 1, 1, NULL);
INSERT INTO `ai_sys_menu` VALUES (6, 1, '菜单管理', '/tools/menu', NULL, 50, 1, 1, NULL);
INSERT INTO `ai_sys_menu` VALUES (7, 6, '菜单列表', '/tools/menu/lists', NULL, 50, 1, 1, NULL);
INSERT INTO `ai_sys_menu` VALUES (8, 7, '新增菜单', '/tools/menu/add', NULL, 50, 1, 1, NULL);
INSERT INTO `ai_sys_menu` VALUES (9, 7, '编辑菜单', '/tools/menu/edit', NULL, 50, 1, 1, NULL);
INSERT INTO `ai_sys_menu` VALUES (10, 1, '用户管理', '/tools/user', NULL, 50, 1, 1, NULL);
INSERT INTO `ai_sys_menu` VALUES (11, 10, '用户列表', '/tools/user/lists', NULL, 50, 1, 1, NULL);
INSERT INTO `ai_sys_menu` VALUES (12, 11, '新增用户', '/tools/user/add', NULL, 50, 1, 1, NULL);
INSERT INTO `ai_sys_menu` VALUES (13, 11, '编辑用户', '/tools/user/edit', NULL, 50, 1, 1, NULL);
INSERT INTO `ai_sys_menu` VALUES (14, 21, '系统配置', '/tools/conf', '', 50, 1, 1, '2020-07-22 15:28:59');
INSERT INTO `ai_sys_menu` VALUES (15, 14, '新增配置', '/tools/conf/add', '', 50, 1, 0, '2020-07-22 15:29:30');
INSERT INTO `ai_sys_menu` VALUES (16, 14, '编辑配置', '/tools/conf/edit', '', 50, 1, 0, '2020-07-22 15:29:47');
INSERT INTO `ai_sys_menu` VALUES (17, 14, '配置列表', '/tools/conf/lists', '', 50, 1, 1, '2020-07-22 15:38:40');
INSERT INTO `ai_sys_menu` VALUES (18, 0, '项目管理', '', '', 50, 1, 1, '2020-07-29 16:39:43');
INSERT INTO `ai_sys_menu` VALUES (19, 0, '订单管理', '', '', 50, 1, 1, '2020-07-29 16:41:57');
INSERT INTO `ai_sys_menu` VALUES (20, 0, '报表管理', '', '', 50, 1, 1, '2020-07-29 16:43:20');
INSERT INTO `ai_sys_menu` VALUES (21, 0, '系统管理', '', '', 10, 1, 1, '2020-07-29 16:45:13');
INSERT INTO `ai_sys_menu` VALUES (22, 0, '会员管理', '', '', 50, 1, 1, '2020-07-29 18:35:42');

-- ----------------------------
-- Table structure for ai_sys_role
-- ----------------------------
DROP TABLE IF EXISTS `ai_sys_role`;
CREATE TABLE `ai_sys_role`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '角色名称',
  `role_menu_ids` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '角色菜单列表',
  `status` tinyint(1) NULL DEFAULT 1 COMMENT '状态1正常 2禁用',
  `add_time` timestamp(0) NULL DEFAULT NULL COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of ai_sys_role
-- ----------------------------
INSERT INTO `ai_sys_role` VALUES (1, '超级管理员', '1,2,3,4,5,6,7,8,9,10,11,12,13,14,16', 1, '2020-07-20 01:10:07');

-- ----------------------------
-- Table structure for ai_sys_user
-- ----------------------------
DROP TABLE IF EXISTS `ai_sys_user`;
CREATE TABLE `ai_sys_user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户名登录名',
  `phone` char(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '电话号码',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `head_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像',
  `salt` char(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `status` tinyint(1) NULL DEFAULT 1 COMMENT '状态',
  `is_admin` tinyint(1) NULL DEFAULT 0 COMMENT '是否超级管理员1是 0否',
  `role_ids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '逗号隔开',
  `token` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '登录TOKEN值',
  `add_time` timestamp(0) NULL DEFAULT NULL COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `phone`(`phone`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of ai_sys_user
-- ----------------------------
INSERT INTO `ai_sys_user` VALUES (1, 'admin', '15859018792', '18900cf81d895310a72bf1310a73d6ca', 'http://www.tp6api.com/storage/topic/20200727\\e64e0ccbc2b36a55cad0c2b7b834f758.jpg', '7GqfCc', 1, 1, '', 'user_e640c700-5f06-48c2-8274-231cd977da9c', '2020-07-23 10:06:46');

SET FOREIGN_KEY_CHECKS = 1;