-- MySQL dump 10.13  Distrib 5.7.32, for linux-glibc2.12 (x86_64)
--
-- Host: 127.0.0.1    Database: demo
-- ------------------------------------------------------
-- Server version	5.7.32-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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 */;

--
-- Table structure for table `account_change`
--

DROP TABLE IF EXISTS `account_change`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `account_change` (
  `log_id` varchar(36) NOT NULL,
  `app_version` varchar(50) NOT NULL,
  `c_ip` varchar(50) DEFAULT NULL,
  `geo_city` varchar(255) DEFAULT NULL,
  `geo_country_long` varchar(255) DEFAULT NULL,
  `geo_latitude` float DEFAULT NULL,
  `geo_longitude` float DEFAULT NULL,
  `geo_region` varchar(255) DEFAULT NULL,
  `http_req` longtext,
  `module` varchar(255) NOT NULL,
  `rel_obj_name` varchar(100) DEFAULT NULL,
  `s_ip` varchar(50) NOT NULL,
  `tag` varchar(100) NOT NULL,
  `time` bigint(20) NOT NULL,
  `action_cn` varchar(100) DEFAULT NULL,
  `action_en` varchar(100) DEFAULT NULL,
  `action_id` bigint(20) DEFAULT NULL,
  `action_result` varchar(10) DEFAULT NULL,
  `app_name_cn` varchar(255) DEFAULT NULL,
  `app_name_en` varchar(255) DEFAULT NULL,
  `log_details` longtext,
  `log_level` int(11) DEFAULT NULL,
  `log_type` varchar(20) DEFAULT NULL,
  `operated_user_id` bigint(20) DEFAULT NULL,
  `operated_user_name` varchar(255) DEFAULT NULL,
  `operator_id` bigint(20) DEFAULT NULL,
  `operator_name` varchar(255) DEFAULT NULL,
  `result_msg` varchar(1024) DEFAULT NULL,
  `session_id` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `audit_app_change`
--

DROP TABLE IF EXISTS `audit_app_change`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `audit_app_change` (
  `log_id` varchar(36) COLLATE utf8mb4_bin NOT NULL,
  `app_version` varchar(50) COLLATE utf8mb4_bin NOT NULL,
  `c_ip` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `geo_city` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `geo_country_long` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `geo_latitude` float DEFAULT NULL,
  `geo_longitude` float DEFAULT NULL,
  `geo_region` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `http_req` longtext COLLATE utf8mb4_bin,
  `module` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `rel_obj_name` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL,
  `s_ip` varchar(50) COLLATE utf8mb4_bin NOT NULL,
  `tag` varchar(100) COLLATE utf8mb4_bin NOT NULL,
  `time` bigint(20) NOT NULL,
  `account_id` bigint(20) DEFAULT NULL,
  `account_name` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL,
  `account_type` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `action_cn` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL,
  `action_en` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL,
  `action_id` bigint(20) DEFAULT NULL,
  `action_result` varchar(10) COLLATE utf8mb4_bin DEFAULT NULL,
  `app_id` bigint(20) DEFAULT NULL,
  `app_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `app_name_cn` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `app_name_en` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `log_details` longtext COLLATE utf8mb4_bin,
  `log_level` int(11) DEFAULT NULL,
  `log_type` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
  `operated_user_id` bigint(20) DEFAULT NULL,
  `operated_user_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `operator_id` bigint(20) DEFAULT NULL,
  `operator_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `result_msg` varchar(1024) COLLATE utf8mb4_bin DEFAULT NULL,
  `session_id` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `audit_post`
--

DROP TABLE IF EXISTS `audit_post`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `audit_post` (
  `log_id` varchar(36) COLLATE utf8mb4_bin NOT NULL,
  `app_version` varchar(50) COLLATE utf8mb4_bin NOT NULL,
  `c_ip` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `geo_city` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `geo_country_long` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `geo_latitude` float DEFAULT NULL,
  `geo_longitude` float DEFAULT NULL,
  `geo_region` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `http_req` longtext COLLATE utf8mb4_bin,
  `module` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `rel_obj_name` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL,
  `s_ip` varchar(50) COLLATE utf8mb4_bin NOT NULL,
  `tag` varchar(100) COLLATE utf8mb4_bin NOT NULL,
  `time` bigint(20) NOT NULL,
  `action_cn` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL,
  `action_en` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL,
  `action_id` bigint(20) DEFAULT NULL,
  `action_result` varchar(10) COLLATE utf8mb4_bin DEFAULT NULL,
  `app_name_cn` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `app_name_en` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `job_code` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `job_id` bigint(20) DEFAULT NULL,
  `job_name` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `job_type` int(11) DEFAULT NULL,
  `log_details` longtext COLLATE utf8mb4_bin,
  `log_level` int(11) DEFAULT NULL,
  `log_type` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
  `operated_user_id` bigint(20) DEFAULT NULL,
  `operated_user_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `operator_id` bigint(20) DEFAULT NULL,
  `operator_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `result_msg` varchar(1024) COLLATE utf8mb4_bin DEFAULT NULL,
  `session_id` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Temporary table structure for view `audit_view_account`
--

DROP TABLE IF EXISTS `audit_view_account`;
/*!50001 DROP VIEW IF EXISTS `audit_view_account`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `audit_view_account` AS SELECT 
 1 AS `xAxis`,
 1 AS `total`,
 1 AS `uk_type`,
 1 AS `operated_user_name`,
 1 AS `time`*/;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `audit_view_history`
--

DROP TABLE IF EXISTS `audit_view_history`;
/*!50001 DROP VIEW IF EXISTS `audit_view_history`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `audit_view_history` AS SELECT 
 1 AS `auth_type`,
 1 AS `login_status`,
 1 AS `device_type`,
 1 AS `login_ip`,
 1 AS `city`,
 1 AS `xAxis`,
 1 AS `yAxis`,
 1 AS `login_time`,
 1 AS `username`*/;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dept`
--

DROP TABLE IF EXISTS `dept`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dept` (
  `log_id` varchar(36) NOT NULL,
  `app_version` varchar(50) NOT NULL,
  `c_ip` varchar(50) DEFAULT NULL,
  `geo_city` varchar(255) DEFAULT NULL,
  `geo_country_long` varchar(255) DEFAULT NULL,
  `geo_latitude` float DEFAULT NULL,
  `geo_longitude` float DEFAULT NULL,
  `geo_region` varchar(255) DEFAULT NULL,
  `http_req` longtext,
  `module` varchar(255) NOT NULL,
  `rel_obj_name` varchar(100) DEFAULT NULL,
  `s_ip` varchar(50) NOT NULL,
  `tag` varchar(100) NOT NULL,
  `time` bigint(20) NOT NULL,
  `action_cn` varchar(100) DEFAULT NULL,
  `action_en` varchar(100) DEFAULT NULL,
  `action_id` bigint(20) DEFAULT NULL,
  `action_result` varchar(10) DEFAULT NULL,
  `app_name_cn` varchar(255) DEFAULT NULL,
  `app_name_en` varchar(255) DEFAULT NULL,
  `leader_id` bigint(20) DEFAULT NULL,
  `leader_name` varchar(255) DEFAULT NULL,
  `log_details` longtext,
  `log_level` int(11) DEFAULT NULL,
  `log_type` varchar(20) DEFAULT NULL,
  `name_en_path` varchar(512) DEFAULT NULL,
  `name_path` varchar(512) DEFAULT NULL,
  `operated_user_id` bigint(20) DEFAULT NULL,
  `operated_user_name` varchar(255) DEFAULT NULL,
  `operator_id` bigint(20) DEFAULT NULL,
  `operator_name` varchar(255) DEFAULT NULL,
  `org_code` varchar(100) DEFAULT NULL,
  `org_name` varchar(50) DEFAULT NULL,
  `org_name_en` varchar(50) DEFAULT NULL,
  `org_path` varchar(512) DEFAULT NULL,
  `parent_org_id` bigint(20) DEFAULT NULL,
  `parent_org_name` varchar(50) DEFAULT NULL,
  `parent_org_name_en` varchar(50) DEFAULT NULL,
  `result_msg` varchar(1024) DEFAULT NULL,
  `session_id` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `login_record_history`
--

DROP TABLE IF EXISTS `login_record_history`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `login_record_history` (
  `id` varchar(36) NOT NULL DEFAULT '' COMMENT 'uuid',
  `created_at` datetime DEFAULT NULL COMMENT '登录记录创建时间',
  `username` varchar(50) DEFAULT NULL COMMENT '登录用户名',
  `login_account` varchar(50) DEFAULT NULL COMMENT '登录账户',
  `login_time` datetime DEFAULT NULL COMMENT '此次登录时间',
  `login_status` int(2) DEFAULT NULL COMMENT '登录状态描述，1 成功，0 失败',
  `auth_type` varchar(50) DEFAULT NULL COMMENT '登录认证方式，1-密码，2-人脸 3-指纹 4-微信扫码',
  `mobile_number` varchar(20) DEFAULT NULL COMMENT '手机号信息',
  `device_abbreviate` varchar(50) DEFAULT NULL COMMENT '设备简称',
  `device_type` varchar(50) DEFAULT NULL COMMENT '登录设备类型 1-windows 2-mac 3-Android  4-ios',
  `login_ip` varchar(50) DEFAULT NULL COMMENT '登录ip地址',
  `city` varchar(50) DEFAULT NULL,
  `browser_type` varchar(50) DEFAULT NULL COMMENT '浏览器类型 1-IE 2-Firefox 3-Chrome 4-Safari',
  `user_agent` varchar(1000) DEFAULT NULL,
  `device_printer` varchar(255) DEFAULT NULL COMMENT '设备号-设备唯一标识',
  `longitude` double(10,7) DEFAULT NULL COMMENT '经度',
  `latitude` double(10,7) DEFAULT NULL COMMENT '纬度',
  `protocol` varchar(50) DEFAULT NULL COMMENT '应用账号跳转协议',
  `request_application` varchar(50) DEFAULT NULL COMMENT '请求应用',
  `application_account` varchar(50) DEFAULT NULL COMMENT '应用账户',
  `valid_date` int(6) DEFAULT NULL COMMENT '此条登录记录有效期',
  `risk_trigger` varchar(255) DEFAULT NULL COMMENT '触发的风险策略描述：异常设备，ip',
  `trust_trigger` varchar(50) DEFAULT NULL COMMENT '触发信任描述：可信登录记录',
  `online_status` int(2) DEFAULT NULL COMMENT '0:失效.1:在线',
  `updated_at` datetime DEFAULT NULL,
  `domain_id` varchar(36) DEFAULT NULL COMMENT '多租户Id',
  PRIMARY KEY (`id`),
  KEY `login_account` (`login_account`) USING BTREE COMMENT '可以针对账户进行索引',
  KEY `idx_username` (`username`) USING BTREE COMMENT 'selfcare访问日志查询'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='登录记录历史表，用来存储各登录记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `platform_role`
--

DROP TABLE IF EXISTS `platform_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `platform_role` (
  `log_id` varchar(36) NOT NULL,
  `app_version` varchar(50) NOT NULL,
  `c_ip` varchar(50) DEFAULT NULL,
  `geo_city` varchar(255) DEFAULT NULL,
  `geo_country_long` varchar(255) DEFAULT NULL,
  `geo_latitude` float DEFAULT NULL,
  `geo_longitude` float DEFAULT NULL,
  `geo_region` varchar(255) DEFAULT NULL,
  `http_req` longtext,
  `module` varchar(255) NOT NULL,
  `rel_obj_name` varchar(100) DEFAULT NULL,
  `s_ip` varchar(50) NOT NULL,
  `tag` varchar(100) NOT NULL,
  `time` bigint(20) NOT NULL,
  `action_cn` varchar(100) DEFAULT NULL,
  `action_en` varchar(100) DEFAULT NULL,
  `action_id` bigint(20) DEFAULT NULL,
  `action_result` varchar(10) DEFAULT NULL,
  `app_name_cn` varchar(255) DEFAULT NULL,
  `app_name_en` varchar(255) DEFAULT NULL,
  `log_details` longtext,
  `log_level` int(11) DEFAULT NULL,
  `log_type` varchar(20) DEFAULT NULL,
  `operated_user_id` bigint(20) DEFAULT NULL,
  `operated_user_name` varchar(255) DEFAULT NULL,
  `operator_id` bigint(20) DEFAULT NULL,
  `operator_name` varchar(255) DEFAULT NULL,
  `result_msg` varchar(1024) DEFAULT NULL,
  `role_name` varchar(100) DEFAULT NULL,
  `role_no` varchar(20) DEFAULT NULL,
  `session_id` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pwd_change`
--

DROP TABLE IF EXISTS `pwd_change`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pwd_change` (
  `log_id` varchar(36) NOT NULL,
  `app_version` varchar(50) NOT NULL,
  `c_ip` varchar(50) DEFAULT NULL,
  `geo_city` varchar(255) DEFAULT NULL,
  `geo_country_long` varchar(255) DEFAULT NULL,
  `geo_latitude` float DEFAULT NULL,
  `geo_longitude` float DEFAULT NULL,
  `geo_region` varchar(255) DEFAULT NULL,
  `http_req` longtext,
  `module` varchar(255) NOT NULL,
  `rel_obj_name` varchar(100) DEFAULT NULL,
  `s_ip` varchar(50) NOT NULL,
  `tag` varchar(100) NOT NULL,
  `time` bigint(20) NOT NULL,
  `action_cn` varchar(100) DEFAULT NULL,
  `action_en` varchar(100) DEFAULT NULL,
  `action_id` bigint(20) DEFAULT NULL,
  `action_result` varchar(10) DEFAULT NULL,
  `app_name_cn` varchar(255) DEFAULT NULL,
  `app_name_en` varchar(255) DEFAULT NULL,
  `check_value` varchar(100) DEFAULT NULL,
  `field_type` varchar(20) DEFAULT NULL,
  `field_value` varchar(64) DEFAULT NULL,
  `input_value` varchar(100) DEFAULT NULL,
  `log_level` int(11) DEFAULT NULL,
  `log_type` varchar(20) DEFAULT NULL,
  `modify_type` varchar(20) DEFAULT NULL,
  `operated_user_id` bigint(20) DEFAULT NULL,
  `operated_user_name` varchar(255) DEFAULT NULL,
  `operator_id` bigint(20) DEFAULT NULL,
  `operator_name` varchar(255) DEFAULT NULL,
  `result_msg` varchar(1024) DEFAULT NULL,
  `session_id` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `user_info_change`
--

DROP TABLE IF EXISTS `user_info_change`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_info_change` (
  `log_id` varchar(36) NOT NULL,
  `app_version` varchar(50) NOT NULL,
  `c_ip` varchar(50) DEFAULT NULL,
  `geo_city` varchar(255) DEFAULT NULL,
  `geo_country_long` varchar(255) DEFAULT NULL,
  `geo_latitude` float DEFAULT NULL,
  `geo_longitude` float DEFAULT NULL,
  `geo_region` varchar(255) DEFAULT NULL,
  `http_req` longtext,
  `module` varchar(255) NOT NULL,
  `rel_obj_name` varchar(100) DEFAULT NULL,
  `s_ip` varchar(50) NOT NULL,
  `tag` varchar(100) NOT NULL,
  `time` bigint(20) NOT NULL,
  `action_cn` varchar(100) DEFAULT NULL,
  `action_en` varchar(100) DEFAULT NULL,
  `action_id` bigint(20) DEFAULT NULL,
  `action_result` varchar(10) DEFAULT NULL,
  `app_name_cn` varchar(255) DEFAULT NULL,
  `app_name_en` varchar(255) DEFAULT NULL,
  `log_details` longtext,
  `log_level` int(11) DEFAULT NULL,
  `log_type` varchar(20) DEFAULT NULL,
  `operated_user_id` bigint(20) DEFAULT NULL,
  `operated_user_name` varchar(255) DEFAULT NULL,
  `operator_id` bigint(20) DEFAULT NULL,
  `operator_name` varchar(255) DEFAULT NULL,
  `result_msg` varchar(1024) DEFAULT NULL,
  `session_id` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Final view structure for view `audit_view_account`
--

/*!50001 DROP VIEW IF EXISTS `audit_view_account`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8mb4 */;
/*!50001 SET character_set_results     = utf8mb4 */;
/*!50001 SET collation_connection      = utf8mb4_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `audit_view_account` AS select `t`.`xAxis` AS `xAxis`,`t`.`total` AS `total`,`t`.`uk_type` AS `uk_type`,`t`.`operated_user_name` AS `operated_user_name`,`t`.`time` AS `time` from (select date_format(from_unixtime((`demo`.`platform_role`.`time` / 1000)),'%k') AS `xAxis`,count(1) AS `total`,'platform_role' AS `uk_type`,`demo`.`platform_role`.`operated_user_name` AS `operated_user_name`,`demo`.`platform_role`.`time` AS `time` from `demo`.`platform_role` group by `xAxis`,`uk_type`,`demo`.`platform_role`.`operated_user_name`,`demo`.`platform_role`.`time` union all select date_format(from_unixtime((`demo`.`dept`.`time` / 1000)),'%k') AS `xAxis`,count(1) AS `total`,'dept' AS `uk_type`,`demo`.`dept`.`operated_user_name` AS `operated_user_name`,`demo`.`dept`.`time` AS `time` from `demo`.`dept` group by `xAxis`,`uk_type`,`demo`.`dept`.`operated_user_name`,`demo`.`dept`.`time` union all select date_format(from_unixtime((`demo`.`audit_post`.`time` / 1000)),'%k') AS `xAxis`,count(1) AS `count(1)`,'post' AS `uk_type`,`demo`.`audit_post`.`operated_user_name` AS `operated_user_name`,`demo`.`audit_post`.`time` AS `time` from `demo`.`audit_post` group by `xAxis`,`uk_type`,`demo`.`audit_post`.`operated_user_name`,`demo`.`audit_post`.`time` union all select date_format(from_unixtime((`demo`.`pwd_change`.`time` / 1000)),'%k') AS `xAxis`,count(1) AS `total`,'pwd_change' AS `uk_type`,`demo`.`pwd_change`.`operated_user_name` AS `operated_user_name`,`demo`.`pwd_change`.`time` AS `time` from `demo`.`pwd_change` group by `xAxis`,`uk_type`,`demo`.`pwd_change`.`operated_user_name`,`demo`.`pwd_change`.`time` union all select date_format(from_unixtime((`demo`.`account_change`.`time` / 1000)),'%k') AS `xAxis`,count(1) AS `total`,'account' AS `uk_type`,`demo`.`account_change`.`operated_user_name` AS `operated_user_name`,`demo`.`account_change`.`time` AS `time` from `demo`.`account_change` group by `xAxis`,`uk_type`,`demo`.`account_change`.`operated_user_name`,`demo`.`account_change`.`time` union all select date_format(from_unixtime((`demo`.`user_info_change`.`time` / 1000)),'%k') AS `xAxis`,count(1) AS `total`,'user_info_change' AS `uk_type`,`demo`.`user_info_change`.`operated_user_name` AS `operated_user_name`,`demo`.`user_info_change`.`time` AS `time` from `demo`.`user_info_change` group by `xAxis`,`uk_type`,`demo`.`user_info_change`.`operated_user_name`,`demo`.`user_info_change`.`time` union all select date_format(from_unixtime((`demo`.`audit_app_change`.`time` / 1000)),'%k') AS `xAxis`,count(1) AS `total`,'app_change' AS `uk_type`,`demo`.`audit_app_change`.`operated_user_name` AS `operated_user_name`,`demo`.`audit_app_change`.`time` AS `time` from `demo`.`audit_app_change` group by `xAxis`,`uk_type`,`demo`.`audit_app_change`.`operated_user_name`,`demo`.`audit_app_change`.`time`) `t` */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

--
-- Final view structure for view `audit_view_history`
--

/*!50001 DROP VIEW IF EXISTS `audit_view_history`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8mb4 */;
/*!50001 SET character_set_results     = utf8mb4 */;
/*!50001 SET collation_connection      = utf8mb4_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `audit_view_history` AS select `login_record_history`.`auth_type` AS `auth_type`,`login_record_history`.`login_status` AS `login_status`,`login_record_history`.`device_type` AS `device_type`,`login_record_history`.`login_ip` AS `login_ip`,`login_record_history`.`city` AS `city`,date_format(`login_record_history`.`login_time`,'%e') AS `xAxis`,count(1) AS `yAxis`,`login_record_history`.`login_time` AS `login_time`,`login_record_history`.`username` AS `username` from `login_record_history` group by `xAxis`,`login_record_history`.`auth_type`,`login_record_history`.`login_status`,`login_record_history`.`device_type`,`login_record_history`.`login_ip`,`login_record_history`.`city`,`login_record_history`.`login_time`,`login_record_history`.`username` */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2023-07-19 18:17:07