react_admin.sql · future2018/react-ant-admin-server

代码拉取完成,页面将自动刷新

扫描微信二维码支付

取消

支付完成

richgiteeai

Watch

不关注关注所有动态仅关注版本发行动态关注但不提醒动态

1 Star 0 Fork 20

future2018/react-ant-admin-server

forked from 孔乙己拉夫米/react-ant-admin-server

代码 Issues 0 Pull Requests 0 Wiki 统计流水线

服务

加入 Gitee

与超过 1400万开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)

免费加入

已有帐号? 立即登录

文件

master

分支 (1)

管理

master

克隆/下载

HTTPS SSH SVN SVN+SSH 下载ZIP

提示

下载代码请复制以下命令到终端执行

为确保你提交的代码身份被 Gitee 正确识别,请执行以下命令完成配置

git config --global user.name userName 
git config --global user.email userEmail

初次使用 SSH 协议进行代码克隆、推送等操作时,需按下述提示完成 SSH 配置

1 生成 RSA 密钥

2 获取 RSA 公钥内容,并配置到 SSH公钥中

在 Gitee 上使用 SVN,请访问使用指南

使用 HTTPS 协议时,命令行会出现如下账号密码验证步骤。基于安全考虑,Gitee 建议配置并使用私人令牌替代登录密码进行克隆、推送等操作

Username for 'https://gitee.com': userName

Password for 'https://userName@gitee.com': # 私人令牌

分支 1

标签 0

react-ant-admin-server

react_admin.sql

react_admin.sql 7.87 KB

/*
 Navicat Premium Data Transfer

Source Server : localhost_3306
 Source Server Type : MySQL
 Source Server Version : 50624
 Source Host : localhost:3306
 Source Schema : react_admin

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

Date: 16/11/2023 09:50:10
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for menu
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
 `m_id` int(8) NOT NULL AUTO_INCREMENT COMMENT '菜单id',
 `parent_m_id` int(8) NULL DEFAULT NULL COMMENT '父菜单id',
 `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜单名称',
 `path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜单路径',
 `icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单图标',
 `keep_alive` enum('true','false') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'false' COMMENT '页面是否保持状态',
 `order` int(8) NOT NULL COMMENT '菜单排序',
 `show` enum('true','false') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'true' COMMENT '是否显示在菜单上',
 PRIMARY KEY (`m_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of menu
-- ----------------------------
INSERT INTO `menu` VALUES (1, NULL, '系统管理', '/power', 'icon_set', 'true', 10000, 'true');
INSERT INTO `menu` VALUES (2, NULL, '列表页', '/list', 'icon_list', 'true', 1, 'true');
INSERT INTO `menu` VALUES (3, NULL, '结果页', '/result', 'icon_voiceprint', 'true', 5, 'true');
INSERT INTO `menu` VALUES (4, NULL, '表单页', '/form', 'icon_form', 'true', 3, 'true');
INSERT INTO `menu` VALUES (5, NULL, '详情页', '/details', 'icon_edit', 'true', 3, 'true');
INSERT INTO `menu` VALUES (6, NULL, '统计', '/statistics', 'icon_MTR', 'true', 4, 'true');
INSERT INTO `menu` VALUES (7, NULL, '图标库', '/icons', 'icon_bluray', 'true', 10, 'true');
INSERT INTO `menu` VALUES (8, 1, '菜单管理', '/menu', 'icon_menu', 'true', 1475, 'true');
INSERT INTO `menu` VALUES (9, 1, '权限类别', '/type', 'icon_safety', 'true', 12, 'true');
INSERT INTO `menu` VALUES (10, 1, '用户管理', '/user', 'icon_infopersonal', 'true', 1593, 'true');
INSERT INTO `menu` VALUES (11, 6, '访客统计', '/visitor', 'icon_addresslist', 'true', 2, 'true');
INSERT INTO `menu` VALUES (12, 6, '反馈统计', '/feedback', 'icon_feeding', 'true', 1, 'true');
INSERT INTO `menu` VALUES (13, 2, '卡片列表', '/card', NULL, 'false', 5485, 'true');
INSERT INTO `menu` VALUES (14, 2, '查询列表', '/search', NULL, 'false', 9588, 'true');
INSERT INTO `menu` VALUES (15, 3, '403', '/403', 'icon_locking', 'false', 0, 'true');
INSERT INTO `menu` VALUES (16, 3, '404', '/404', 'icon_close', 'false', 1, 'true');
INSERT INTO `menu` VALUES (17, 3, '500', '/500', 'icon_privacy_closed', 'false', 4568, 'true');
INSERT INTO `menu` VALUES (18, 5, '个人中心', '/person', 'icon_infopersonal', 'false', 9998, 'true');
INSERT INTO `menu` VALUES (19, 4, '基础表单', '/index', NULL, 'false', 9654, 'true');

-- ----------------------------
-- Table structure for message
-- ----------------------------
DROP TABLE IF EXISTS `message`;
CREATE TABLE `message` (
 `m_id` int(8) NOT NULL AUTO_INCREMENT COMMENT '消息id',
 `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '消息名称',
 `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '消息描述词',
 `creator` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
 `add_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
 PRIMARY KEY (`m_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of message
-- ----------------------------
INSERT INTO `message` VALUES (1, '第一条消息', '我创建的第一天消息', '超级管理员', '2021年04月20日 17:01:09');
INSERT INTO `message` VALUES (2, 'RegExp', 'RegExp 对象表示正则表达式,它是对字符串执行模式匹配的强大工具。 ', '超级管理员', '2021年04月20日 17:48:42');
INSERT INTO `message` VALUES (3, 'Ant Design', 'antd 是基于 Ant Design 设计体系的 React UI 组件库,主要用于研发企业级中后台产品。', '超级管理员', '2021年04月20日 17:46:44');
INSERT INTO `message` VALUES (4, 'react-ant-admin', '此框架使用与二次开发,前端框架使用react,UI框架使用ant-design,全局数据状态管理使用redux,ajax使用库为axios。用于快速搭建中后台页面。', '超级管理员', '2021年04月20日 17:28:45');

-- ----------------------------
-- Table structure for power
-- ----------------------------
DROP TABLE IF EXISTS `power`;
CREATE TABLE `power` (
 `type_id` int(4) NOT NULL AUTO_INCREMENT COMMENT '权限id',
 `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '权限简称',
 `menu_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '显示菜单列表id',
 PRIMARY KEY (`type_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of power
-- ----------------------------
INSERT INTO `power` VALUES (1, '超级管理员', '2,3,4,5,6,7,8,10,11,12,13,14,15,16,17,18,19,9,1');
INSERT INTO `power` VALUES (2, '用户', '11,2,7,6,17,18,16,3,4,5,13,14,15,19,12');
INSERT INTO `power` VALUES (3, '游客', '2,7,18,13,14,5');
INSERT INTO `power` VALUES (4, '低权游客', '2,13,14,7');

-- ----------------------------
-- Table structure for statistics
-- ----------------------------
DROP TABLE IF EXISTS `statistics`;
CREATE TABLE `statistics` (
 `s_id` int(8) NOT NULL AUTO_INCREMENT COMMENT '请求序号',
 `ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'ip地址',
 `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求地址',
 `time` datetime NULL DEFAULT NULL COMMENT '请求时间',
 `status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'http状态码',
 PRIMARY KEY (`s_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 134 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of statistics
-- ----------------------------

-- ----------------------------
-- Table structure for user_info
-- ----------------------------
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info` (
 `user_id` int(8) NOT NULL AUTO_INCREMENT COMMENT '用户id',
 `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
 `account` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '登录账号',
 `pswd` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '登录密码',
 `type_id` int(4) NOT NULL COMMENT '用户权限',
 PRIMARY KEY (`user_id`) USING BTREE,
 UNIQUE INDEX `uq_account`(`account`) USING BTREE,
 INDEX `fk_type`(`type_id`) USING BTREE,
 CONSTRAINT `fk_type_id` FOREIGN KEY (`type_id`) REFERENCES `power` (`type_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of user_info
-- ----------------------------
INSERT INTO `user_info` VALUES (1, '张同学', 'admin', 'admin123', 1);
INSERT INTO `user_info` VALUES (2, '王五', 'user', 'user123', 2);
INSERT INTO `user_info` VALUES (4, '李四', 'qq123456', 'qq123456', 3);
INSERT INTO `user_info` VALUES (5, '路过的老鼠', 'jake', 'jake123', 4);

SET FOREIGN_KEY_CHECKS = 1;

一键复制编辑原始数据按行查看历史

孔乙己拉夫米提交于 2023年11月16日 10:07 +08:00 . 数据库结构调整

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140

/*
 Navicat Premium Data Transfer

 Source Server : localhost_3306
 Source Server Type : MySQL
 Source Server Version : 50624
 Source Host : localhost:3306
 Source Schema : react_admin

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

 Date: 16/11/2023 09:50:10
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for menu
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
 `m_id` int(8) NOT NULL AUTO_INCREMENT COMMENT '菜单id',
 `parent_m_id` int(8) NULL DEFAULT NULL COMMENT '父菜单id',
 `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜单名称',
 `path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜单路径',
 `icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单图标',
 `keep_alive` enum('true','false') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'false' COMMENT '页面是否保持状态',
 `order` int(8) NOT NULL COMMENT '菜单排序',
 `show` enum('true','false') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'true' COMMENT '是否显示在菜单上',
 PRIMARY KEY (`m_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of menu
-- ----------------------------
INSERT INTO `menu` VALUES (1, NULL, '系统管理', '/power', 'icon_set', 'true', 10000, 'true');
INSERT INTO `menu` VALUES (2, NULL, '列表页', '/list', 'icon_list', 'true', 1, 'true');
INSERT INTO `menu` VALUES (3, NULL, '结果页', '/result', 'icon_voiceprint', 'true', 5, 'true');
INSERT INTO `menu` VALUES (4, NULL, '表单页', '/form', 'icon_form', 'true', 3, 'true');
INSERT INTO `menu` VALUES (5, NULL, '详情页', '/details', 'icon_edit', 'true', 3, 'true');
INSERT INTO `menu` VALUES (6, NULL, '统计', '/statistics', 'icon_MTR', 'true', 4, 'true');
INSERT INTO `menu` VALUES (7, NULL, '图标库', '/icons', 'icon_bluray', 'true', 10, 'true');
INSERT INTO `menu` VALUES (8, 1, '菜单管理', '/menu', 'icon_menu', 'true', 1475, 'true');
INSERT INTO `menu` VALUES (9, 1, '权限类别', '/type', 'icon_safety', 'true', 12, 'true');
INSERT INTO `menu` VALUES (10, 1, '用户管理', '/user', 'icon_infopersonal', 'true', 1593, 'true');
INSERT INTO `menu` VALUES (11, 6, '访客统计', '/visitor', 'icon_addresslist', 'true', 2, 'true');
INSERT INTO `menu` VALUES (12, 6, '反馈统计', '/feedback', 'icon_feeding', 'true', 1, 'true');
INSERT INTO `menu` VALUES (13, 2, '卡片列表', '/card', NULL, 'false', 5485, 'true');
INSERT INTO `menu` VALUES (14, 2, '查询列表', '/search', NULL, 'false', 9588, 'true');
INSERT INTO `menu` VALUES (15, 3, '403', '/403', 'icon_locking', 'false', 0, 'true');
INSERT INTO `menu` VALUES (16, 3, '404', '/404', 'icon_close', 'false', 1, 'true');
INSERT INTO `menu` VALUES (17, 3, '500', '/500', 'icon_privacy_closed', 'false', 4568, 'true');
INSERT INTO `menu` VALUES (18, 5, '个人中心', '/person', 'icon_infopersonal', 'false', 9998, 'true');
INSERT INTO `menu` VALUES (19, 4, '基础表单', '/index', NULL, 'false', 9654, 'true');

-- ----------------------------
-- Table structure for message
-- ----------------------------
DROP TABLE IF EXISTS `message`;
CREATE TABLE `message` (
 `m_id` int(8) NOT NULL AUTO_INCREMENT COMMENT '消息id',
 `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '消息名称',
 `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '消息描述词',
 `creator` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
 `add_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
 PRIMARY KEY (`m_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of message
-- ----------------------------
INSERT INTO `message` VALUES (1, '第一条消息', '我创建的第一天消息', '超级管理员', '2021-04-20 17:01:09');
INSERT INTO `message` VALUES (2, 'RegExp', 'RegExp 对象表示正则表达式,它是对字符串执行模式匹配的强大工具。 ', '超级管理员', '2021-04-20 17:48:42');
INSERT INTO `message` VALUES (3, 'Ant Design', 'antd 是基于 Ant Design 设计体系的 React UI 组件库,主要用于研发企业级中后台产品。', '超级管理员', '2021-04-20 17:46:44');
INSERT INTO `message` VALUES (4, 'react-ant-admin', '此框架使用与二次开发,前端框架使用react,UI框架使用ant-design,全局数据状态管理使用redux,ajax使用库为axios。用于快速搭建中后台页面。', '超级管理员', '2021-04-20 17:28:45');

-- ----------------------------
-- Table structure for power
-- ----------------------------
DROP TABLE IF EXISTS `power`;
CREATE TABLE `power` (
 `type_id` int(4) NOT NULL AUTO_INCREMENT COMMENT '权限id',
 `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '权限简称',
 `menu_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '显示菜单列表id',
 PRIMARY KEY (`type_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of power
-- ----------------------------
INSERT INTO `power` VALUES (1, '超级管理员', '2,3,4,5,6,7,8,10,11,12,13,14,15,16,17,18,19,9,1');
INSERT INTO `power` VALUES (2, '用户', '11,2,7,6,17,18,16,3,4,5,13,14,15,19,12');
INSERT INTO `power` VALUES (3, '游客', '2,7,18,13,14,5');
INSERT INTO `power` VALUES (4, '低权游客', '2,13,14,7');

-- ----------------------------
-- Table structure for statistics
-- ----------------------------
DROP TABLE IF EXISTS `statistics`;
CREATE TABLE `statistics` (
 `s_id` int(8) NOT NULL AUTO_INCREMENT COMMENT '请求序号',
 `ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'ip地址',
 `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求地址',
 `time` datetime NULL DEFAULT NULL COMMENT '请求时间',
 `status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'http状态码',
 PRIMARY KEY (`s_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 134 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of statistics
-- ----------------------------

-- ----------------------------
-- Table structure for user_info
-- ----------------------------
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info` (
 `user_id` int(8) NOT NULL AUTO_INCREMENT COMMENT '用户id',
 `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
 `account` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '登录账号',
 `pswd` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '登录密码',
 `type_id` int(4) NOT NULL COMMENT '用户权限',
 PRIMARY KEY (`user_id`) USING BTREE,
 UNIQUE INDEX `uq_account`(`account`) USING BTREE,
 INDEX `fk_type`(`type_id`) USING BTREE,
 CONSTRAINT `fk_type_id` FOREIGN KEY (`type_id`) REFERENCES `power` (`type_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of user_info
-- ----------------------------
INSERT INTO `user_info` VALUES (1, '张同学', 'admin', 'admin123', 1);
INSERT INTO `user_info` VALUES (2, '王五', 'user', 'user123', 2);
INSERT INTO `user_info` VALUES (4, '李四', 'qq123456', 'qq123456', 3);
INSERT INTO `user_info` VALUES (5, '路过的老鼠', 'jake', 'jake123', 4);

SET FOREIGN_KEY_CHECKS = 1;