-- --------------------------------------------------------
-- 主机:                           127.0.0.1
-- 服务器版本:                        10.8.7-MariaDB - mariadb.org binary distribution
-- 服务器操作系统:                      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 */;


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

-- 导出  表 urego.system_dept 结构
CREATE TABLE IF NOT EXISTS `system_dept` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `parent_id` int(20) NOT NULL,
  `ancestors` varchar(255) NOT NULL DEFAULT '',
  `dept_name` varchar(255) NOT NULL DEFAULT '',
  `leader` varchar(255) DEFAULT '',
  `phone` varchar(255) DEFAULT '',
  `email` varchar(255) DEFAULT '',
  `is_deleted` int(4) DEFAULT 0,
  `created_at` datetime DEFAULT NULL,
  `update_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- 正在导出表  urego.system_dept 的数据：~9 rows (大约)
/*!40000 ALTER TABLE `system_dept` DISABLE KEYS */;
INSERT INTO `system_dept` (`id`, `parent_id`, `ancestors`, `dept_name`, `leader`, `phone`, `email`, `is_deleted`, `created_at`, `update_at`) VALUES
	(1, 0, '0', '公司总部', '张三', '', '', 0, '2024-02-25 14:44:02', NULL),
	(2, 1, '0,1', '财务部', '李四', '', '', 0, '2024-02-25 14:44:03', NULL),
	(3, 1, '0,1', '技术部', '王五', '', '', 0, '2024-02-25 14:44:03', NULL),
	(4, 2, '0,1,2', '财务三组', '赵六', '', '', 0, '2024-02-25 14:44:04', NULL),
	(5, 4, '0,1,2,4', '财务三组1队', '李斌', '', '', 0, '2024-02-25 14:44:04', NULL),
	(12, 0, '0', '分公司', '李伟', '大苏打', '倒萨', 0, '2024-02-25 22:57:40', '2024-02-25 22:57:40'),
	(13, 0, '0', '测试', '', '', '', 0, '2024-02-25 23:21:34', '2024-02-25 23:21:34'),
	(14, 0, '0', '测试2', '', '', '', 0, '2024-02-25 23:23:04', '2024-02-25 23:23:04'),
	(15, 14, '0,14', '测试山东', '', '', '', 0, '2024-02-25 23:24:40', '2024-02-25 23:24:40'),
	(16, 15, '0,14,15', '测试大撒大撒', '', '', '', 0, '2024-02-25 23:24:49', '2024-02-25 23:24:49');
/*!40000 ALTER TABLE `system_dept` ENABLE KEYS */;

-- 导出  表 urego.system_role 结构
CREATE TABLE IF NOT EXISTS `system_role` (
  `id` int(20) NOT NULL,
  `role_name` varchar(255) NOT NULL DEFAULT '',
  `role_key` varchar(50) DEFAULT NULL,
  `is_deleted` int(11) DEFAULT NULL,
  `remark` varchar(50) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `update_at` datetime DEFAULT NULL,
  `perms` varchar(1024) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- 正在导出表  urego.system_role 的数据：~0 rows (大约)
/*!40000 ALTER TABLE `system_role` DISABLE KEYS */;
INSERT INTO `system_role` (`id`, `role_name`, `role_key`, `is_deleted`, `remark`, `status`, `created_at`, `update_at`, `perms`) VALUES
	(1, '超级管理员', 'admin', NULL, NULL, NULL, '2024-02-22 15:25:11', '2024-03-02 22:59:38', '[]'),
	(2, '测试', 'test', NULL, NULL, NULL, '2024-03-02 22:59:39', '2024-03-02 22:35:19', '["system","User","Role","Dept"]');
/*!40000 ALTER TABLE `system_role` ENABLE KEYS */;

-- 导出  表 urego.system_user 结构
CREATE TABLE IF NOT EXISTS `system_user` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL,
  `nick_name` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `role_id` int(20) NOT NULL,
  `icon` text NOT NULL,
  `is_deleted` int(10) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `update_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- 正在导出表  urego.system_user 的数据：~1 rows (大约)
/*!40000 ALTER TABLE `system_user` DISABLE KEYS */;
INSERT INTO `system_user` (`id`, `username`, `nick_name`, `password`, `role_id`, `icon`, `is_deleted`, `created_at`, `update_at`) VALUES
	(1, 'admin', '管理', 'admin123', 1, '', NULL, '2024-02-24 19:38:30', '2024-02-24 19:38:32');
/*!40000 ALTER TABLE `system_user` ENABLE KEYS */;

-- 导出  表 urego.system_user_dept 结构
CREATE TABLE IF NOT EXISTS `system_user_dept` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `dept_id` int(10) NOT NULL DEFAULT 0,
  `user_id` int(10) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `update_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `dept_id` (`dept_id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- 正在导出表  urego.system_user_dept 的数据：~0 rows (大约)
/*!40000 ALTER TABLE `system_user_dept` DISABLE KEYS */;
/*!40000 ALTER TABLE `system_user_dept` 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) */;