java-admin
/
java_admin.sql

-- --------------------------------------------------------
-- 主机:                           localhost
-- 服务器版本:                        5.7.18-log - MySQL Community Server (GPL)
-- 服务器操作系统:                      Win64
-- HeidiSQL 版本:                  11.3.0.6295
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


-- 导出 java_admin 的数据库结构
CREATE DATABASE IF NOT EXISTS `java_admin` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */;
USE `java_admin`;

-- 导出  表 java_admin.global_config 结构
CREATE TABLE IF NOT EXISTS `global_config` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(300) NOT NULL COMMENT '名称',
  `remark` varchar(300) NOT NULL COMMENT '备注',
  `content` varchar(1000) NOT NULL COMMENT '内容',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `update_time` datetime NOT NULL,
  `create_time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- 正在导出表  java_admin.global_config 的数据：~2 rows (大约)
DELETE FROM `global_config`;
/*!40000 ALTER TABLE `global_config` DISABLE KEYS */;
INSERT INTO `global_config` (`id`, `name`, `remark`, `content`, `deleted`, `update_time`, `create_time`) VALUES
	(1, 'sysConfigDomain', '', 'https://gitee.com/HarlanSong/java-admin', 0, '2021-12-19 21:08:32', '2021-12-19 21:08:32'),
	(2, 'sysConfigUploadImageType', '', 'jpg|jpeg|png', 0, '2021-12-19 21:08:32', '2021-12-19 21:08:32');
/*!40000 ALTER TABLE `global_config` ENABLE KEYS */;

-- 导出  表 java_admin.sys_resource 结构
CREATE TABLE IF NOT EXISTS `sys_resource` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `button` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否是操作',
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '名称',
  `url` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '地址',
  `parent_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '父ID',
  `icon` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '图标',
  `permission` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '权限',
  `order_number` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `update_time` datetime NOT NULL,
  `create_time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系统资源';

-- 正在导出表  java_admin.sys_resource 的数据：~16 rows (大约)
DELETE FROM `sys_resource`;
/*!40000 ALTER TABLE `sys_resource` DISABLE KEYS */;
INSERT INTO `sys_resource` (`id`, `button`, `name`, `url`, `parent_id`, `icon`, `permission`, `order_number`, `deleted`, `update_time`, `create_time`) VALUES
	(1, 0, '系统管理', NULL, 0, 'fa fa-cog', NULL, 0, 0, '2021-12-18 22:23:04', '2021-12-18 22:23:05'),
	(2, 0, '系统管理', '', 1, 'fa fa-cog', '', 2, 0, '2021-12-22 01:00:01', '2021-12-18 22:24:06'),
	(3, 0, '角色管理', '/admin/sysRole/sysRoleView', 2, 'fa fa-user-secret', 'sys:role:list', 0, 0, '2021-12-19 17:26:50', '2021-12-18 22:27:20'),
	(4, 1, '添加角色', '', 3, '', 'sys:role:add', 0, 0, '2021-12-21 23:59:41', '2021-12-18 22:29:38'),
	(5, 0, '资源管理', '/admin/sysResource/listView', 2, 'fa fa-th-large', 'sys:resource:list', 0, 0, '2021-12-19 17:26:37', '2021-12-19 02:06:09'),
	(6, 0, '开发工具', '', 1, 'fa fa-code', NULL, 0, 0, '2021-12-19 09:47:47', '2021-12-19 09:47:49'),
	(7, 0, '图标', '/admin/sys/devTool/iconView', 6, 'fa fa-smile-o', 'sys:deveTool:icon', 0, 0, '2021-12-21 11:11:37', '2021-12-19 09:48:25'),
	(8, 0, '系统用户', '/admin/sysUser/listView', 2, 'fa fa-user', 'sys:user:list', 10, 0, '2021-12-19 17:39:48', '2021-12-19 16:28:39'),
	(9, 0, '全局配置', '/admin/globalConfig/sysConfigView', 2, 'fa fa-th-list', 'sys:globalConfig', 0, 0, '2021-12-19 20:48:57', '2021-12-19 20:47:31'),
	(10, 0, '常规管理', '', 0, '', '', 1000, 0, '2021-12-20 19:57:20', '2021-12-19 20:49:41'),
	(11, 0, '用户管理', '', 10, 'fa fa-user', '', 0, 0, '2021-12-19 20:50:51', '2021-12-19 20:50:39'),
	(12, 0, '用户列表', '/admin/user/userView', 11, 'fa fa-user', 'user:list', 0, 0, '2021-12-19 20:51:43', '2021-12-19 20:51:43'),
	(13, 0, '按钮', '/admin/sys/devTool/buttonView', 6, '', 'sys:deveTool:button', 0, 0, '2021-12-21 11:08:45', '2021-12-21 11:08:45'),
	(14, 1, '编辑角色', '', 3, '', 'sys:role:update', 0, 0, '2021-12-21 23:59:15', '2021-12-21 23:59:15'),
	(15, 1, '删除角色', '', 3, '', 'sys:role:delete', 0, 0, '2021-12-22 00:00:18', '2021-12-22 00:00:13'),
	(16, 1, '角色列表', '', 3, '', 'sys:role:list', 0, 0, '2021-12-22 00:00:44', '2021-12-22 00:00:44');
/*!40000 ALTER TABLE `sys_resource` ENABLE KEYS */;

-- 导出  表 java_admin.sys_role 结构
CREATE TABLE IF NOT EXISTS `sys_role` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL COMMENT '名称',
  `remark` varchar(300) DEFAULT NULL COMMENT '备注',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- 正在导出表  java_admin.sys_role 的数据：~4 rows (大约)
DELETE FROM `sys_role`;
/*!40000 ALTER TABLE `sys_role` DISABLE KEYS */;
INSERT INTO `sys_role` (`id`, `name`, `remark`, `deleted`, `update_time`, `create_time`) VALUES
	(1, '超级管理员', '超级管理员', 0, '2021-12-22 00:58:00', '2021-12-19 01:45:51'),
	(8, '管理员', '12312', 0, '2021-12-19 14:37:04', '2021-12-19 01:45:53'),
	(9, '运营管理员', NULL, 0, '2021-12-22 00:15:22', '2021-12-20 20:17:57'),
	(10, '客服', NULL, 0, '2021-12-21 23:45:43', '2021-12-20 21:24:45');
/*!40000 ALTER TABLE `sys_role` ENABLE KEYS */;

-- 导出  表 java_admin.sys_role_resource 结构
CREATE TABLE IF NOT EXISTS `sys_role_resource` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  `resource_id` bigint(20) NOT NULL COMMENT '资源ID',
  `create_time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8 COMMENT='系统角色资源';

-- 正在导出表  java_admin.sys_role_resource 的数据：~19 rows (大约)
DELETE FROM `sys_role_resource`;
/*!40000 ALTER TABLE `sys_role_resource` DISABLE KEYS */;
INSERT INTO `sys_role_resource` (`id`, `role_id`, `resource_id`, `create_time`) VALUES
	(3, 1, 1, '2021-12-18 22:32:13'),
	(18, 1, 2, '2021-12-18 22:35:13'),
	(19, 1, 3, '2021-12-18 22:36:44'),
	(20, 1, 4, '2021-12-18 22:37:05'),
	(21, 1, 5, '2021-12-19 02:06:46'),
	(22, 1, 6, '2021-12-19 09:48:43'),
	(23, 1, 7, '2021-12-19 09:48:51'),
	(27, 1, 8, '2021-12-19 16:30:00'),
	(28, 1, 9, '2021-12-19 20:48:02'),
	(29, 1, 10, '2021-12-19 20:51:57'),
	(30, 1, 11, '2021-12-19 20:51:57'),
	(31, 1, 12, '2021-12-19 20:51:57'),
	(33, 1, 15, '2021-12-22 00:01:16'),
	(34, 1, 16, '2021-12-22 00:01:16'),
	(35, 1, 13, '2021-12-22 00:01:23'),
	(36, 1, 14, '2021-12-22 00:55:57'),
	(37, 8, 10, '2021-12-22 00:58:38'),
	(46, 8, 11, '2021-12-22 00:58:51'),
	(47, 8, 12, '2021-12-22 00:58:51');
/*!40000 ALTER TABLE `sys_role_resource` ENABLE KEYS */;

-- 导出  表 java_admin.sys_user 结构
CREATE TABLE IF NOT EXISTS `sys_user` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(30) NOT NULL COMMENT '账号',
  `password` varchar(36) NOT NULL COMMENT '密码',
  `name` varchar(30) NOT NULL COMMENT '姓名',
  `mobile` varchar(20) DEFAULT '' COMMENT '手机号',
  `salt` varchar(50) NOT NULL COMMENT '密码加密盐',
  `email` varchar(100) DEFAULT '' COMMENT '邮箱',
  `status` int(11) NOT NULL DEFAULT '0' COMMENT '状态 0 正常 1 禁用 2 锁定',
  `role` varchar(300) DEFAULT NULL COMMENT '角色ID,多个英文逗号隔开',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- 正在导出表  java_admin.sys_user 的数据：~4 rows (大约)
DELETE FROM `sys_user`;
/*!40000 ALTER TABLE `sys_user` DISABLE KEYS */;
INSERT INTO `sys_user` (`id`, `username`, `password`, `name`, `mobile`, `salt`, `email`, `status`, `role`, `deleted`, `update_time`, `create_time`) VALUES
	(1, 'admin', '5a8595d82228d6015aea78682df657f9', '超级管理员', '18600000000', 'df54a192-bbf0-43ca-b4be-0484e56559bc', 'harlansong@qq.com', 0, '1', 0, '2021-12-22 00:15:34', '2021-12-18 20:56:48'),
	(2, 'zhangsan', 'bdf21906f44af0f4a1e90c6595f715ab', '张三', '', 'b13fa0b3-ac86-4d7f-baea-f41d6d3f6d06', '', 0, '8', 0, '2021-12-22 00:53:48', '2021-12-19 17:38:54'),
	(3, 'lisi', '86fc79e3a90c82a4e83f90c936f7f9a5', '李四', '', '70910690-f367-4009-9a84-cb71c835d720', '', 0, '1', 0, '2021-12-22 00:54:16', '2021-12-20 14:55:26'),
	(4, 'wangwu', 'f88024f770c6ce053f400c5cd5be6d68', '王五', '', '89884b34-b69d-4e7a-8a8d-987fe945aa71', '', 0, '8', 0, '2021-12-22 00:54:24', '2021-12-20 19:43:29');
/*!40000 ALTER TABLE `sys_user` ENABLE KEYS */;

-- 导出  表 java_admin.sys_user_role 结构
CREATE TABLE IF NOT EXISTS `sys_user_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL,
  `role_id` bigint(20) NOT NULL,
  `create_time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系统用户角色';

-- 正在导出表  java_admin.sys_user_role 的数据：~4 rows (大约)
DELETE FROM `sys_user_role`;
/*!40000 ALTER TABLE `sys_user_role` DISABLE KEYS */;
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`, `create_time`) VALUES
	(1, 1, 1, '2021-12-18 22:02:20'),
	(3, 2, 9, '2021-12-22 00:53:48'),
	(4, 3, 8, '2021-12-22 00:54:16'),
	(5, 4, 9, '2021-12-22 00:54:24');
/*!40000 ALTER TABLE `sys_user_role` ENABLE KEYS */;

-- 导出  表 java_admin.user 结构
CREATE TABLE IF NOT EXISTS `user` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `email` varchar(50) DEFAULT NULL COMMENT '邮箱',
  `phone` varchar(11) DEFAULT NULL COMMENT '手机号',
  `password` varchar(50) DEFAULT NULL COMMENT '密码',
  `nickname` varchar(50) NOT NULL COMMENT '昵称',
  `avatar_id` bigint(20) DEFAULT NULL COMMENT '头像ID',
  `salt` varchar(50) NOT NULL COMMENT '密码盐',
  `sex` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0-未知；1-男；2-女',
  `birthday` date DEFAULT NULL COMMENT '生日',
  `height` smallint(6) DEFAULT NULL COMMENT '身高(cm)',
  `weight` smallint(6) DEFAULT NULL COMMENT '体重（kg）',
  `channel` int(11) NOT NULL COMMENT '注册渠道（1 Android ; 2 IOS; 3 小程序）',
  `recommendId` bigint(20) NOT NULL DEFAULT '0' COMMENT '推荐人',
  `last_login_time` datetime NOT NULL COMMENT '最后一次登录时间',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `update_time` datetime NOT NULL,
  `create_time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户';

-- 正在导出表  java_admin.user 的数据：~0 rows (大约)
DELETE FROM `user`;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
/*!40000 ALTER TABLE `user` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;