登录 注册
开源 企业版 高校版 私有云 Gitee AI NEW
扫描微信二维码支付
取消
支付完成
Watch
不关注 关注所有动态 仅关注版本发行动态 关注但不提醒动态
1 Star 0 Fork 75

zyqcome/queer

forked from song/queer
关闭
 
代码 Issues 0 Pull Requests 0 Wiki 统计 流水线
服务
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
文件
克隆/下载
mysql.sql 228.63 KB
一键复制 编辑 原始数据 按行查看 历史
song 提交于 2021-05-31 15:58 . 增加MYSQL的支持
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325
/*

 Navicat Premium Data Transfer



 Source Server         : 39.107.66.106

 Source Server Type    : MySQL

 Source Server Version : 80024

 Source Host           : 39.107.66.106:3306

 Source Schema         : queer



 Target Server Type    : MySQL

 Target Server Version : 80024

 File Encoding         : 65001



 Date: 31/05/2021 15:58:00

*/



SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;



-- ----------------------------

-- Table structure for sysapiauthorize

-- ----------------------------

DROP TABLE IF EXISTS `sysapiauthorize`;

CREATE TABLE `sysapiauthorize`  (

  `Id` bigint(0) NOT NULL COMMENT ' ',

  `Url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求接口',

  `Authorize` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '菜单权限标识',

  PRIMARY KEY (`Id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '接口权限' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of sysapiauthorize

-- ----------------------------

INSERT INTO `sysapiauthorize` VALUES (46049625945280512, '/SystemManage/LogApi/GetPageListJson', 'system:logapi:search');



-- ----------------------------

-- Table structure for sysautojob

-- ----------------------------

DROP TABLE IF EXISTS `sysautojob`;

CREATE TABLE `sysautojob`  (

  `Id` bigint(0) NOT NULL,

  `JobGroupName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务组名称',

  `JobName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务名称',

  `JobStatus` int(0) NOT NULL COMMENT '任务状态(0禁用 1启用)',

  `CronExpression` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'cron表达式',

  `StartTime` datetime(0) NOT NULL COMMENT '运行开始时间',

  `EndTime` datetime(0) NOT NULL COMMENT '运行结束时间',

  `NextStartTime` datetime(0) NOT NULL COMMENT '下次执行时间',

  `Remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注',

  `CreateUserId` bigint(0) NULL DEFAULT NULL COMMENT '创建人ID编号',

  `DeleteTime` datetime(0) NULL DEFAULT NULL COMMENT '删除时间',

  `DeleteUserId` bigint(0) NULL DEFAULT NULL COMMENT '删除人ID编号',

  `LastModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '最后修改时间',

  `LastModifyUserId` bigint(0) NULL DEFAULT NULL COMMENT '最后修改人ID编号',

  `IsDelete` tinyint(0) NOT NULL,

  `CreateTime` datetime(0) NULL DEFAULT NULL,

  PRIMARY KEY (`Id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of sysautojob

-- ----------------------------

INSERT INTO `sysautojob` VALUES (318071827001774080, '系统', '数据库备份', 1, '0 0 3 1/1 * ?', '2021-05-27 17:03:35', '2031-05-27 17:03:33', '2021-05-27 17:03:35', '', 16508640061130151, NULL, NULL, '2021-05-27 17:03:53', 16508640061130151, 0, '2021-05-27 17:03:53');



-- ----------------------------

-- Table structure for sysautojoblog

-- ----------------------------

DROP TABLE IF EXISTS `sysautojoblog`;

CREATE TABLE `sysautojoblog`  (

  `Id` bigint(0) NOT NULL,

  `BaseCreateTime` datetime(0) NOT NULL,

  `BaseCreatorId` bigint(0) NULL DEFAULT NULL,

  `JobGroupName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务组名称',

  `JobName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务名称',

  `LogStatus` int(0) NOT NULL COMMENT '执行状态(0失败 1成功)',

  `Remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '备注',

  PRIMARY KEY (`Id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of sysautojoblog

-- ----------------------------



-- ----------------------------

-- Table structure for syscodetemplet

-- ----------------------------

DROP TABLE IF EXISTS `syscodetemplet`;

CREATE TABLE `syscodetemplet`  (

  `Id` bigint(0) NOT NULL,

  `Code` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '代码',

  `Remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',

  `Flag` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标识',

  `Type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '代码类型（cs java html 等）',

  PRIMARY KEY (`Id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代码生成模板' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of syscodetemplet

-- ----------------------------

INSERT INTO `syscodetemplet` VALUES (45368218067537920, 'using Furion.DatabaseAccessor;\nusing Microsoft.EntityFrameworkCore;\nusing Microsoft.EntityFrameworkCore.Metadata.Builders;\nusing Newtonsoft.Json;\nusing System;\nusing System.Collections.Generic;\nusing System.ComponentModel.DataAnnotations.Schema;\nusing {项目名称}.Util.Helper;\nusing {项目名称}.Data.BaseEntity;\n\nnamespace {项目名称}.Entity\n{\n{描述}\n    [Table(\"{表名称}\")]\n    public partial class {类名} : {继承实体}\n    {\n{字段}\n    }\n}', '实体类', 'Entity', 'csharp');

INSERT INTO `syscodetemplet` VALUES (45368219082559488, 'using System;\nusing System.Collections.Generic;\nusing System.Linq;\nusing System.Text;\nusing System.Threading.Tasks;\nusing {项目名称}.Util.Helper;\nusing Newtonsoft.Json;\n\nnamespace {项目名称}.Model.Param.{命名空间}\n{\n{描述}\n    public class {类名}\n    {\n{字段}\n    }\n}', '查询类', 'ListParam', 'csharp');

INSERT INTO `syscodetemplet` VALUES (45368219468435456, 'using Furion.DatabaseAccessor;\nusing Furion.DependencyInjection;\nusing Furion.LinqBuilder;\nusing System;\nusing System.Collections.Generic;\nusing System.Linq;\nusing System.Text;\nusing System.Threading.Tasks;\nusing Microsoft.EntityFrameworkCore;\nusing {项目名称}.Entity;\nusing {项目名称}.IService.{命名空间};\nusing {项目名称}.Model.Param.{命名空间};\nusing {项目名称}.Util;\nusing {项目名称}.Util.Helper;\nusing {项目名称}.Util.Model;\n\nnamespace {项目名称}.Service.{命名空间}\n{\n{描述}\n    public class {类名} : I{类名}, ITransient\n    {\n        private readonly IRepository<{实体类名}> _{驼峰实体类名}DB;\n\n        public {类名}(IRepository<{实体类名}> {驼峰实体类名}DB)\n        {\n            _{驼峰实体类名}DB = {驼峰实体类名}DB;\n        }\n\n        #region 获取数据\n\n        /// <summary>\n        /// 带条件查询所有\n        /// </summary>\n        public async Task<List<{实体类名}>> GetList({查询类名} param)\n        {\n            IQueryable<{实体类名}> query =  ListFilter(param);\n            var data = await query.ToListAsync();\n            return data;\n        }\n\n        /// <summary>\n        /// 分页查询\n        /// </summary>\n        public async Task<List<{实体类名}>> GetPageList({查询类名} param, Pagination pagination)\n        {\n            IQueryable<{实体类名}> query =  ListFilter(param);\n            var data = await query.OrderByDescending(a => a.Id).ToPagedListAsync(pagination.PageIndex, pagination.PageSize);\n\n            // 分页参数赋值\n            pagination.TotalCount = data.TotalCount;\n            return data.Items.ToList();\n        }\n\n        /// <summary>\n        /// 根据ID获取对象\n        /// </summary>\n        public async Task<{实体类名}> GetEntity(long id)\n        {\n            var data =  await _{驼峰实体类名}DB.AsQueryable(p => p.Id == id).FirstOrDefaultAsync();\n            return data;\n        }\n\n        /// <summary>\n        /// 查询多个ID主键数据\n        /// </summary>\n        public async Task<List<{实体类名}>> GetListByIds(string ids)\n        {\n            if (ids.IsNullOrEmpty())\n                throw new Exception(\"参数不合法！\");\n\n            var idArr = TextHelper.SplitToArray<long>(ids, \',\').ToList();\n            var data = await _{驼峰实体类名}DB.AsQueryable(a => idArr.Contains(a.Id.GetValueOrDefault())).ToListAsync();\n\n            return data;\n        }\n\n        #endregion\n\n        #region 提交数据\n\n        public async Task SaveForm({实体类名} entity)\n        {\n            if (entity.Id.IsNullOrZero())\n            {\n                await _{驼峰实体类名}DB.InsertNowAsync(entity);\n            }\n            else\n            {\n                await _{驼峰实体类名}DB.UpdateNowAsync(entity, ignoreNullValues: true);\n            }\n        }\n\n        public async Task DeleteForm(string ids)\n        {\n            if(string.IsNullOrWhiteSpace(ids))\n                throw new Exception(\"参数不合法！\");\n\n            var _ids = ids.Split(\",\");\n            await _{驼峰实体类名}DB.{删除方法}(_ids);\n        }\n\n        #endregion\n\n        #region 私有方法\n        private IQueryable<{实体类名}> ListFilter({查询类名} param)\n        {\n            IQueryable<{实体类名}> query = _{驼峰实体类名}DB.AsQueryable();\n            if (param != null)\n            {\n{查询条件}\n            }\n{是否伪删除}\n            return query;\n        }\n\n        #endregion\n    }\n}', '数据服务类', 'Service', 'csharp');

INSERT INTO `syscodetemplet` VALUES (45368219850117120, 'using Furion.DependencyInjection;\nusing System;\nusing System.Collections.Generic;\nusing System.Linq;\nusing System.Text;\nusing System.Threading.Tasks;\nusing {项目名称}.Entity;\nusing {项目名称}.IBusiness.{命名空间};\nusing {项目名称}.IService.{命名空间};\nusing {项目名称}.Model.Param.{命名空间};\nusing {项目名称}.Util;\nusing {项目名称}.Util.Model;\n\nnamespace {项目名称}.Business.{命名空间}\n{\n{描述}\n    public class {类名}: I{类名}, ITransient\n    {\n        private readonly I{数据服务类名} _{驼峰数据服务类名};\n        \n        public {类名}(I{数据服务类名} {驼峰数据服务类名})\n        {\n            _{驼峰数据服务类名} = {驼峰数据服务类名};\n        }\n\n        #region 获取数据\n\n        public async Task<TData<List<{实体类名}>>> GetList({查询类名} param)\n        {\n            TData<List<{实体类名}>> obj = new TData<List<{实体类名}>>();\n            obj.Data = await _{驼峰数据服务类名}.GetList(param);\n            obj.Tag = 1;\n            return obj;\n        }\n\n        public async Task<TData<List<{实体类名}>>> GetPageList({查询类名} param, Pagination pagination)\n        {\n            TData<List<{实体类名}>> obj = new TData<List<{实体类名}>>();\n            obj.Data = await _{驼峰数据服务类名}.GetPageList(param, pagination);\n            obj.Total = pagination.TotalCount;\n            obj.Tag = 1;\n            return obj;\n        }\n\n        public async Task<TData<{实体类名}>> GetEntity(long id)\n        {\n            TData<{实体类名}> obj = new TData<{实体类名}>();\n            obj.Data = await _{驼峰数据服务类名}.GetEntity(id);\n            obj.Tag = 1;\n            return obj;\n        }\n\n        #endregion\n\n        #region 提交数据\n\n        public async Task<TData<string>> SaveForm({实体类名} entity)\n        {\n            TData<string> obj = new TData<string>();\n            await _{驼峰数据服务类名}.SaveForm(entity);\n            obj.Data = entity.Id.ParseToString();\n            obj.Tag = 1;\n            return obj;\n        }\n\n        public async Task<TData> DeleteForm(string ids)\n        {\n            TData obj = new TData();\n            await _{驼峰数据服务类名}.DeleteForm(ids);\n            obj.Tag = 1;\n            return obj;\n        }\n\n        #endregion\n    }\n}', '业务类', 'BLL', 'csharp');

INSERT INTO `syscodetemplet` VALUES (45368220223410176, 'using System;\nusing System.Collections.Generic;\nusing System.Linq;\nusing System.Text;\nusing System.Threading.Tasks;\nusing {项目名称}.Entity;\nusing {项目名称}.Model.Param.{命名空间};\nusing {项目名称}.Util;\nusing {项目名称}.Util.Model;\n\nnamespace {项目名称}.IService.{命名空间}\n{\n{描述}\n    public interface I{类名}\n    {\n        #region 获取数据\n\n        Task<List<{实体类名}>> GetList({查询类名} param);\n\n        Task<List<{实体类名}>> GetPageList({查询类名} param, Pagination pagination);\n\n        Task<{实体类名}> GetEntity(long id);\n\n        #endregion\n\n        #region 提交数据\n\n        Task SaveForm({实体类名} entity);\n\n        Task DeleteForm(string ids);\n\n        #endregion\n\n        #region 私有方法\n\n        #endregion\n    }\n}', '数据服务接口', 'IService', 'csharp');

INSERT INTO `syscodetemplet` VALUES (45368220596703232, 'using System;\nusing System.Collections.Generic;\nusing System.Linq;\nusing System.Text;\nusing System.Threading.Tasks;\nusing {项目名称}.Entity;\nusing {项目名称}.Model.Param.{命名空间};\nusing {项目名称}.Util.Model;\n\nnamespace {项目名称}.IBusiness.{命名空间}\n{\n    public interface I{类名}\n    {\n        #region 获取数据\n\n        Task<TData<List<{实体类名}>>> GetList({查询类名} param);\n\n        Task<TData<List<{实体类名}>>> GetPageList({查询类名} param, Pagination pagination);\n\n        Task<TData<{实体类名}>> GetEntity(long id);\n\n        #endregion\n\n        #region 提交数据\n\n        Task<TData<string>> SaveForm({实体类名} entity);\n\n        Task<TData> DeleteForm(string ids);\n\n        #endregion\n    }\n}', '业务接口', 'IBLL', 'csharp');

INSERT INTO `syscodetemplet` VALUES (45368220965801984, 'using Microsoft.AspNetCore.Mvc;\nusing System;\nusing System.Collections.Generic;\nusing System.Linq;\nusing System.Threading.Tasks;\nusing {项目名称}.Entity;\nusing {项目名称}.IBusiness.{命名空间};\nusing {项目名称}.Model.Param.{命名空间};\nusing {项目名称}.Util.Model;\nusing {项目名称}.WebApi.Areas;\n\nnamespace {项目名称}.WebApi.Areas.{模块}.{命名空间}\n{\n{描述}\n    [Route(\"{命名空间}/[controller]\")]\n    public class {类名} : BaseAdminController\n    {\n        private readonly I{业务类名} _{驼峰业务类名};\n\n        public {类名}(I{业务类名} {驼峰业务类名})\n        {\n            _{驼峰业务类名} = {驼峰业务类名};\n        }\n\n        #region 获取数据\n\n        /// <summary>\n        /// 条件查询\n        /// </summary>\n        [HttpGet]\n        public async Task<TData<List<{实体类名}>>> GetListJson([FromQuery] {查询类名} param)\n        {\n            TData<List<{实体类名}>> obj = await _{驼峰业务类名}.GetList(param);\n            return obj;\n        }\n\n        /// <summary>\n        /// 条件查询-分页\n        /// </summary>\n        [HttpGet]\n        public async Task<TData<List<{实体类名}>>> GetPageListJson([FromQuery] {查询类名} param, [FromQuery] Pagination pagination)\n        {\n            TData<List<{实体类名}>> obj = await _{驼峰业务类名}.GetPageList(param, pagination);\n            return obj;\n        }\n\n        /// <summary>\n        /// 根据ID查询\n        /// </summary>\n        [HttpGet]\n        public async Task<TData<{实体类名}>> GetFormJson([FromQuery] long id)\n        {\n            TData<{实体类名}> obj = await _{驼峰业务类名}.GetEntity(id);\n            return obj;\n        }\n\n        #endregion\n\n        #region 提交数据\n\n        /// <summary>\n        /// 新增/修改 数据\n        /// </summary>\n        [HttpPost]\n        public async Task<TData<string>> SaveFormJson([FromBody] {实体类名} entity)\n        {\n            TData<string> obj = await _{驼峰业务类名}.SaveForm(entity);\n            return obj;\n        }\n\n        /// <summary>\n        /// 删除数据\n        /// </summary>\n        [HttpPost]\n        public async Task<TData> DeleteFormJson([FromBody] Model.Param.ParamModel model)\n        {\n            TData obj = await _{驼峰业务类名}.DeleteForm(model.ids);\n            return obj;\n        }\n\n        #endregion\n    }\n}', '控制器', 'Controller', 'csharp');

INSERT INTO `syscodetemplet` VALUES (45368221347483648, '<!DOCTYPE html>\n<html>\n<head>\n    <meta charset=\"utf-8\" />\n    <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />\n    <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge,chrome=1\">\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1, maximum-scale=1\">\n    <link rel=\"stylesheet\" href=\"/assets/libs/layui/css/layui.css\" />\n    <link rel=\"stylesheet\" href=\"/assets/module/admin.css\">\n    <!--[if lt IE 9]>\n    <script src=\"https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js\"></script>\n    <script src=\"https://oss.maxcdn.com/respond/1.4.2/respond.min.js\"></script>\n    <![endif]-->\n    <style>\n        {启用搜索}\n    </style>\n</head>\n<body>\n    <!-- 主体部分 -->\n    <div class=\"layui-fluid\">\n        <div class=\"layui-card\">\n            <div class=\"layui-card-body\">\n                <!-- 表格工具栏 -->\n                <form class=\"layui-form toolbar searchbar\">\n                    <div class=\"layui-form-item\">\n\n{查询条件}\n\n                        <div class=\"layui-inline\">\n                             \n                            <button class=\"layui-btn icon-btn\" lay-filter=\"TbSearch\" lay-submit>\n                                <i class=\"layui-icon\"></i>搜索\n                            </button>\n                        </div>\n                    </div>\n                </form>\n                <!-- 数据表格 -->\n                <table id=\"gridTable\" lay-filter=\"gridTable\"></table>\n            </div>\n        </div>\n    </div>\n\n    <!-- 表格操作列 -->\n    <script type=\"text/html\" id=\"toolbar\">\n        {新增按钮}\n        {修改按钮}\n        {删除按钮}\n    </script>\n\n    <!-- js部分 -->\n    <script src=\"/assets/libs/jquery/jquery-3.2.1.min.js\"></script>\n    <script src=\"/assets/libs/layui/layui.js\"></script>\n    <script src=\"/assets/js/utils.js\"></script>\n    <script src=\"/assets/js/main.js\"></script>\n    <script>\n\n        // 全局变量\n        var table;\n\n        layui.use([\'layer\', \'form\', \'table\', \'util\', \'admin\', \'setter\'], function () {\n            var $ = layui.jquery;\n            var layer = layui.layer;\n            var form = layui.form;\n            table = layui.table;\n            var util = layui.util;\n            var admin = layui.admin;\n            var setter = layui.setter;\n\n            // 表格初始化\n            layuiTableSet();\n\n            /* 渲染表格 */\n            var insTb = table.render({\n                elem: \'#gridTable\',\n                url: setter.baseServer + \'/{命名空间}/{类名前缀}/GetPageListJson\',\n                page: true,\n                toolbar: \"#toolbar\",\n                cols: [[\n                    { type: \'checkbox\' },\n                    { type: \'numbers\' },\n{表格列}\n                ]]\n            });\n\n            /* 表格搜索 */\n            form.on(\'submit(TbSearch)\', function (data) {\n                insTb.reload({ where: data.field, page: { curr: 1 } });\n                return false;\n            });\n\n            /* 表格头工具栏点击事件 */\n            table.on(\'toolbar(gridTable)\', function (obj) {\n                if (obj.event === \'add\') { // 添加\n                    showEditModel();\n                } else if (obj.event === \'edit\') { // 修改\n                    var checkRows = table.checkStatus(\'gridTable\');\n                    if (checkRows.data.length === 0 || checkRows.data.length > 1) {\n                        layer.msg(\'请选择且只选择一条数据\', { icon: 2 });\n                        return;\n                    }\n                    showEditModel(checkRows.data[0]);\n                } else if (obj.event === \'del\') { // 删除\n                    var checkRows = table.checkStatus(\'gridTable\');\n                    if (checkRows.data.length === 0) {\n                        layer.msg(\'请选择要删除的数据\', { icon: 2 });\n                        return;\n                    }\n                    var ids = checkRows.data.map(function (d) {\n                        return d.Id;\n                    });\n                    doDel({ ids: ids });\n                }\n            });\n\n            /* 显示表单弹窗 */\n            function showEditModel(mData) {\n                var id = 0;\n                if (mData != undefined && mData != null) { id = mData.Id; }\n                admin.open({\n                    type: 2,\n                    area: [\'768px\', \'600px\'],\n                    title: (mData ? \'修改\' : \'添加\'),\n                    content: \'{驼峰类名前缀}Form.html?id=\' + id,\n                });\n            }\n\n            /* 删除 */\n            function doDel(obj) {\n                layer.confirm(\'确定要删除选中数据吗？\', {\n                    skin: \'layui-layer-admin\',\n                    shade: .1\n                }, function (i) {\n                    layer.close(i);\n                    var loadIndex = layer.load(2);\n                    admin.req(\'/{命名空间}/{类名前缀}/DeleteFormJson\',  obj.ids.join(\',\') , function (res) {\n                        layer.close(loadIndex);\n                        if (1 === res.Tag) {\n                            layer.msg(\"操作成功\", { icon: 1 });\n                            insTb.reload({ page: { curr: 1 } });\n                        } else {\n                            layer.msg(res.Message, { icon: 2 });\n                        }\n                    }, \'post\');\n                });\n            }\n\n        });\n    </script>\n</body>\n</html>', '列表页面', 'Index', 'html');

INSERT INTO `syscodetemplet` VALUES (45368221750136832, '<!DOCTYPE html>\n<html>\n<head>\n    <meta charset=\"utf-8\" />\n    <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />\n    <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge,chrome=1\">\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1, maximum-scale=1\">\n    <link rel=\"stylesheet\" href=\"/assets/libs/layui/css/layui.css\" />\n    <link rel=\"stylesheet\" href=\"/assets/module/admin.css?v=318\">\n    <!--[if lt IE 9]>\n    <script src=\"https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js\"></script>\n    <script src=\"https://oss.maxcdn.com/respond/1.4.2/respond.min.js\"></script>\n    <![endif]-->\n    <style>\n        .form-div {\n            padding: 5px;\n            background-color: white;\n        }\n    </style>\n</head>\n<body>\n    <div class=\"layui-row form-div\">\n        <form id=\"dataform\" lay-filter=\"dataform\" class=\"layui-form model-form\">\n\n{表单控件}\n          \n            <div class=\"layui-form-item text-right\">\n                <button class=\"layui-btn\" lay-filter=\"formSubmit\" lay-submit>保存</button>\n                <button class=\"layui-btn layui-btn-primary\" type=\"button\"  ew-event=\"closeDialog\">取消</button>\n            </div>\n        </form>\n    </div>\n\n    <!-- 初始加载动画 -->\n    <div class=\"page-loading\">\n        <div class=\"signal-loader\">\n            <span></span><span></span><span></span><span></span>\n        </div>\n    </div>\n\n    <!-- js部分 -->\n    <script src=\"/assets/libs/jquery/jquery-3.2.1.min.js\"></script>\n    <script src=\"/assets/libs/layui/layui.js\"></script>\n    <script src=\"/assets/js/utils.js\"></script>\n    <script src=\"/assets/js/main.js\"></script>\n    <script type=\"text/javascript\">\n        var id = getRequestData(\"id\");\n\n        layui.use([\'layer\', \'form\', \'admin\', \'laydate\', \'formX\'], function () {\n            var layer = layui.layer;\n            var form = layui.form;\n            var admin = layui.admin;\n            var formX = layui.formX;\n            var laydate = layui.laydate;\n\n            /* // 时间弹窗模板\n            laydate.render({\n                elem: \'#StartTime\'\n                , type: \'datetime\'\n                , trigger: \'click\'\n            });\n            */\n\n            // 初始化\n            if (id > 0) {\n                admin.req(\'/{命名空间}/{类名前缀}/GetFormJson\', { id: id }, function (res) {\n                    admin.removeLoading();\n                    if (res.Tag == 1) {\n                        form.val(\'dataform\', res.Data);\n                    }\n                }, \'get\');\n            } else {\n                admin.removeLoading();\n            }\n\n            // 表单提交\n            form.on(\'submit(formSubmit)\', function (data) {\n                data.field.Id = id;\n                admin.showLoading(\'body\', 3, \'.8\');\n\n                admin.req(\'/{命名空间}/{类名前缀}/SaveFormJson\', data.field, function (res) {\n                    admin.removeLoading(\'body\', true, true);\n                    if (res.Tag == 1) {\n                        parent.layer.msg(\'操作成功\', { icon: 1, time: 1500 });\n                        parent.table.reload(\'gridTable\');\n                        parent.layer.close(parent.layer.getFrameIndex(window.name));\n                    }\n                    else {\n                        layer.msg(res.Message, { icon: 2 });\n                    }\n                }, \'post\');\n\n                return false;\n            });\n\n        });\n    </script>\n</body>\n</html>', '表单页面', 'Form', 'html');



-- ----------------------------

-- Table structure for sysdatadict

-- ----------------------------

DROP TABLE IF EXISTS `sysdatadict`;

CREATE TABLE `sysdatadict`  (

  `Id` bigint(0) NOT NULL,

  `DictType` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字典类型',

  `DictSort` int(0) NULL DEFAULT NULL COMMENT '字典排序',

  `Remark` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',

  `CreateUserId` bigint(0) NULL DEFAULT NULL COMMENT '创建人ID编号',

  `DeleteTime` datetime(0) NULL DEFAULT NULL COMMENT '删除时间',

  `DeleteUserId` bigint(0) NULL DEFAULT NULL COMMENT '删除人ID编号',

  `LastModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '最后修改时间',

  `LastModifyUserId` bigint(0) NULL DEFAULT NULL COMMENT '最后修改人ID编号',

  `IsDelete` tinyint(0) NULL DEFAULT NULL,

  `CreateTime` datetime(0) NULL DEFAULT NULL,

  PRIMARY KEY (`Id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of sysdatadict

-- ----------------------------

INSERT INTO `sysdatadict` VALUES (297048410391842816, 'NewsType', 1, '新闻类别', 16508640061130151, NULL, NULL, '2021-03-30 16:44:20', 16508640061130151, 0, '2021-03-30 16:44:20');

INSERT INTO `sysdatadict` VALUES (298021235281891328, 'HospitalLevel', 1, '医院级别', 16508640061130151, NULL, NULL, '2021-04-02 09:09:59', 16508640061130151, 0, '2021-04-02 09:09:59');

INSERT INTO `sysdatadict` VALUES (298087260148994048, 'education', 3, '文化程度', 16508640061130151, NULL, NULL, '2021-04-02 13:32:21', 16508640061130151, 0, '2021-04-02 13:32:21');

INSERT INTO `sysdatadict` VALUES (298087856058929152, 'OccupationType', 4, '职业类型', 16508640061130151, NULL, NULL, '2021-04-02 13:34:43', 16508640061130151, 0, '2021-04-02 13:34:43');

INSERT INTO `sysdatadict` VALUES (299483175439044608, 'HospitalTitle', 1, '医院职称', 16508640061130151, NULL, NULL, '2021-04-06 09:59:13', 16508640061130151, 0, '2021-04-06 09:59:13');

INSERT INTO `sysdatadict` VALUES (299831330701578240, 'BillingMethod', 11, '计费方式', 16508640061130151, NULL, NULL, '2021-04-07 09:02:40', 16508640061130151, 0, '2021-04-07 09:02:40');

INSERT INTO `sysdatadict` VALUES (299862772919832576, 'CommissionType', 11, '提成类型', 16508640061130151, NULL, NULL, '2021-04-07 11:07:36', 16508640061130151, 0, '2021-04-07 11:07:36');

INSERT INTO `sysdatadict` VALUES (300209943582085120, 'BusinessNature', 45, '商家描述', 16508640061130151, NULL, NULL, '2021-04-08 10:07:08', 16508640061130151, 0, '2021-04-08 10:07:08');

INSERT INTO `sysdatadict` VALUES (300273499560218624, 'OrganizationLevel', 1, '机构等级', 16508640061130151, NULL, NULL, '2021-04-08 14:19:41', 16508640061130151, 0, '2021-04-08 14:19:41');

INSERT INTO `sysdatadict` VALUES (300275362703609856, 'LocationType', 1, '所处位置', 16508640061130151, NULL, NULL, '2021-04-08 14:27:05', 16508640061130151, 0, '2021-04-08 14:27:05');

INSERT INTO `sysdatadict` VALUES (300276361942011904, 'MedicalServiceMode', 1, '医疗服务方式', 16508640061130151, NULL, NULL, '2021-04-08 14:31:04', 16508640061130151, 0, '2021-04-08 14:31:04');

INSERT INTO `sysdatadict` VALUES (300281726146449408, 'OrgHousingSource', 1, '机构用房来源', 16508640061130151, NULL, NULL, '2021-04-08 14:52:22', 16508640061130151, 0, '2021-04-08 14:52:22');

INSERT INTO `sysdatadict` VALUES (300590727996379136, 'OrgFirstType', 1, '机构大类', 16508640061130151, NULL, NULL, '2021-04-09 11:20:14', 16508640061130151, 0, '2021-04-09 11:20:14');

INSERT INTO `sysdatadict` VALUES (300590816039014400, 'OrgSecondType', 1, '机构小类', 16508640061130151, '2021-04-09 11:20:50', 16508640061130151, '2021-04-09 11:20:50', 16508640061130151, 1, '2021-04-09 11:20:35');

INSERT INTO `sysdatadict` VALUES (300620670704816128, '民办', 1, '机构民办类型', 16508640061130151, NULL, NULL, '2021-04-09 16:12:49', 16508640061130151, 0, '2021-04-09 13:19:13');

INSERT INTO `sysdatadict` VALUES (300621436530200576, '乡镇（街道）敬老院', 1, '机构乡镇类型', 16508640061130151, NULL, NULL, '2021-04-09 16:15:27', 16508640061130151, 0, '2021-04-09 13:22:16');

INSERT INTO `sysdatadict` VALUES (300621920267669504, 'OrgDeviceType', 1, '机构设施设备信息类型', 16508640061130151, NULL, NULL, '2021-04-09 13:24:11', 16508640061130151, 0, '2021-04-09 13:24:11');

INSERT INTO `sysdatadict` VALUES (300638727267422208, 'PublicServiceRoom', 1, '公共服务用房', 16508640061130151, NULL, NULL, '2021-04-09 14:30:58', 16508640061130151, 0, '2021-04-09 14:30:58');

INSERT INTO `sysdatadict` VALUES (300638937381081088, 'MedicalRoom', 2, '医疗康复用房', 16508640061130151, NULL, NULL, '2021-04-09 14:31:48', 16508640061130151, 0, '2021-04-09 14:31:48');

INSERT INTO `sysdatadict` VALUES (300649705019281408, 'CultureRoom', 1, '文化娱乐用房', 16508640061130151, NULL, NULL, '2021-04-09 15:14:35', 16508640061130151, 0, '2021-04-09 15:14:35');

INSERT INTO `sysdatadict` VALUES (300650354519838720, 'AssistRoom', 1, '行政辅助用房', 16508640061130151, NULL, NULL, '2021-04-09 15:17:25', 16508640061130151, 0, '2021-04-09 15:17:10');

INSERT INTO `sysdatadict` VALUES (300650792048660480, 'RoomDevice', 1, '房间设备', 16508640061130151, NULL, NULL, '2021-04-09 15:18:55', 16508640061130151, 0, '2021-04-09 15:18:55');

INSERT INTO `sysdatadict` VALUES (300651445558972416, 'PublicServiceDevice', 1, '公共服务设备', 16508640061130151, NULL, NULL, '2021-04-09 15:21:30', 16508640061130151, 0, '2021-04-09 15:21:30');

INSERT INTO `sysdatadict` VALUES (300651900729036800, 'MedicalDevice', 1, '医疗康复设备', 16508640061130151, NULL, NULL, '2021-04-09 15:23:19', 16508640061130151, 0, '2021-04-09 15:23:19');

INSERT INTO `sysdatadict` VALUES (300652478813179904, 'SafeDevice', 1, '安全保障设备', 16508640061130151, NULL, NULL, '2021-04-09 15:25:37', 16508640061130151, 0, '2021-04-09 15:25:37');

INSERT INTO `sysdatadict` VALUES (300652886872821760, 'FireControlDevice', 1, '消防安全设备', 16508640061130151, NULL, NULL, '2021-04-09 15:27:14', 16508640061130151, 0, '2021-04-09 15:27:14');

INSERT INTO `sysdatadict` VALUES (300653340474216448, 'OfficeDevice', 1, '行政办公设备', 16508640061130151, NULL, NULL, '2021-04-09 15:29:02', 16508640061130151, 0, '2021-04-09 15:29:02');

INSERT INTO `sysdatadict` VALUES (301749420565729280, 'OldmanLivingSituation', 99, '老人居住情况', 16508640061130151, NULL, NULL, '2021-04-12 16:04:28', 16508640061130151, 0, '2021-04-12 16:04:28');

INSERT INTO `sysdatadict` VALUES (301749868349624320, 'FamilyTies', 99, '家庭关系', 16508640061130151, NULL, NULL, '2021-04-12 16:06:15', 16508640061130151, 0, '2021-04-12 16:06:15');

INSERT INTO `sysdatadict` VALUES (301751317313884160, 'FinanceSource', 99, '经济来源', 16508640061130151, NULL, NULL, '2021-04-12 16:12:00', 16508640061130151, 0, '2021-04-12 16:12:00');

INSERT INTO `sysdatadict` VALUES (301752460559519744, 'MedicalSecurity', 99, '医疗保障', 16508640061130151, NULL, NULL, '2021-04-12 16:16:33', 16508640061130151, 0, '2021-04-12 16:16:33');

INSERT INTO `sysdatadict` VALUES (301752763455377408, 'Disability', 99, '残疾情况', 16508640061130151, NULL, NULL, '2021-04-12 16:17:45', 16508640061130151, 0, '2021-04-12 16:17:45');

INSERT INTO `sysdatadict` VALUES (301753164841881600, 'StandardCulture', 99, '文化程度', 16508640061130151, NULL, NULL, '2021-04-12 16:19:21', 16508640061130151, 0, '2021-04-12 16:19:21');

INSERT INTO `sysdatadict` VALUES (302012987898597376, 'CardStatus', 11, '会员卡状态', 16508640061130151, NULL, NULL, '2021-04-13 09:31:47', 16508640061130151, 0, '2021-04-13 09:31:47');

INSERT INTO `sysdatadict` VALUES (302023625039417344, 'OldmanType', 99, '老人类别', 16508640061130151, NULL, NULL, '2021-04-13 10:14:04', 16508640061130151, 0, '2021-04-13 10:14:04');

INSERT INTO `sysdatadict` VALUES (302024080788295680, 'MaritalStatus', 99, '婚姻状态', 16508640061130151, NULL, NULL, '2021-04-13 10:15:52', 16508640061130151, 0, '2021-04-13 10:15:52');

INSERT INTO `sysdatadict` VALUES (302095883661479936, 'LostOfAbility', 99, '失去能力情况', 16508640061130151, NULL, NULL, '2021-04-13 15:01:11', 16508640061130151, 0, '2021-04-13 15:01:11');

INSERT INTO `sysdatadict` VALUES (302099923854168064, 'ChronicDisease', 99, '慢性病', 16508640061130151, NULL, NULL, '2021-04-13 15:17:15', 16508640061130151, 0, '2021-04-13 15:17:15');

INSERT INTO `sysdatadict` VALUES (302392563975852032, 'RechargeMethod', 1, '充值方式', 16508640061130151, NULL, NULL, '2021-04-14 10:40:05', 16508640061130151, 0, '2021-04-14 10:40:05');

INSERT INTO `sysdatadict` VALUES (302450751047733248, 'ServiceState', 99, '服务状态', 16508640061130151, NULL, NULL, '2021-04-14 14:31:18', 16508640061130151, 0, '2021-04-14 14:31:18');

INSERT INTO `sysdatadict` VALUES (302451880116621312, 'CapabilityRating', 110, '能力分级', 16508640061130151, NULL, NULL, '2021-04-14 14:35:48', 16508640061130151, 0, '2021-04-14 14:35:48');

INSERT INTO `sysdatadict` VALUES (304630699376250880, 'PaymentType', 88, '付款方式', 16508640061130151, NULL, NULL, '2021-04-20 14:53:39', 16508640061130151, 0, '2021-04-20 14:53:39');

INSERT INTO `sysdatadict` VALUES (304899853379440640, 'AllergicDrug', 99, '过敏源药品', 16508640061130151, NULL, NULL, '2021-04-21 08:43:10', 16508640061130151, 0, '2021-04-21 08:43:10');

INSERT INTO `sysdatadict` VALUES (304911735897198592, 'DisabilityTypes', 99, '残疾类型', 16508640061130151, NULL, NULL, '2021-04-21 09:30:23', 16508640061130151, 0, '2021-04-21 09:30:23');

INSERT INTO `sysdatadict` VALUES (304925836073504768, 'Hobbies', 99, '兴趣爱好', 16508640061130151, NULL, NULL, '2021-04-21 10:31:13', 16508640061130151, 0, '2021-04-21 10:26:25');

INSERT INTO `sysdatadict` VALUES (304933458843537408, 'Speciality', 99, '技能特长', 16508640061130151, NULL, NULL, '2021-04-21 10:56:49', 16508640061130151, 0, '2021-04-21 10:56:42');

INSERT INTO `sysdatadict` VALUES (305373514662154240, 'DeviceMainType', 99, '设备大类', 16508640061130151, NULL, NULL, '2021-04-22 16:05:19', 16508640061130151, 0, '2021-04-22 16:05:19');

INSERT INTO `sysdatadict` VALUES (307191180968333312, 'specifications', 66, '商品规格', 16508640061130151, NULL, NULL, '2021-04-27 16:28:05', 16508640061130151, 0, '2021-04-27 16:28:05');

INSERT INTO `sysdatadict` VALUES (308255639316992000, 'PaymentMethod', 55, '支付类型', 16508640061130151, NULL, NULL, '2021-04-30 14:57:52', 16508640061130151, 0, '2021-04-30 14:57:52');

INSERT INTO `sysdatadict` VALUES (308272598146355200, 'LogisticsCompany', 22, '物流公司', 16508640061130151, NULL, NULL, '2021-04-30 16:05:15', 16508640061130151, 0, '2021-04-30 16:05:15');

INSERT INTO `sysdatadict` VALUES (310465955039809536, 'HealthInfoType', 99, '健康资讯类型', 16508640061130151, NULL, NULL, '2021-05-06 17:20:52', 16508640061130151, 0, '2021-05-06 17:20:52');

INSERT INTO `sysdatadict` VALUES (311805528412000256, 'HealthVisitType', 99, '健康随访类型', 16508640061130151, NULL, NULL, '2021-05-10 10:03:51', 16508640061130151, 0, '2021-05-10 10:03:51');

INSERT INTO `sysdatadict` VALUES (311817087200792576, 'HealthAssessType', 99, '健康评估类型', 16508640061130151, NULL, NULL, '2021-05-10 10:49:47', 16508640061130151, 0, '2021-05-10 10:49:47');



-- ----------------------------

-- Table structure for sysdatadictdetail

-- ----------------------------

DROP TABLE IF EXISTS `sysdatadictdetail`;

CREATE TABLE `sysdatadictdetail`  (

  `Id` bigint(0) NOT NULL,

  `DictType` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字典类型(外键)',

  `DictSort` int(0) NULL DEFAULT NULL COMMENT '字典排序',

  `DictKey` int(0) NULL DEFAULT NULL COMMENT '字典键(一般从1开始)',

  `DictValue` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字典值',

  `ListClass` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '显示样式(default primary success info warning danger)',

  `DictStatus` int(0) NULL DEFAULT NULL COMMENT '字典状态(0禁用 1启用)',

  `IsDefault` int(0) NULL DEFAULT NULL COMMENT '默认选中(0不是 1是)',

  `Remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注',

  `CreateUserId` bigint(0) NULL DEFAULT NULL COMMENT '创建人ID编号',

  `DeleteTime` datetime(0) NULL DEFAULT NULL COMMENT '删除时间',

  `DeleteUserId` bigint(0) NULL DEFAULT NULL COMMENT '删除人ID编号',

  `LastModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '最后修改时间',

  `LastModifyUserId` bigint(0) NULL DEFAULT NULL COMMENT '最后修改人ID编号',

  `IsDelete` tinyint(0) NULL DEFAULT NULL,

  `CreateTime` datetime(0) NULL DEFAULT NULL,

  PRIMARY KEY (`Id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of sysdatadictdetail

-- ----------------------------

INSERT INTO `sysdatadictdetail` VALUES (297289317041049600, 'NewsType', 1, 1, '每日趣闻', NULL, 1, 0, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysdatadictdetail` VALUES (298021336935043072, 'HospitalLevel', 1, 1, '一级', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-02 09:10:24', 16508640061130151, 0, '2021-04-02 09:10:24');

INSERT INTO `sysdatadictdetail` VALUES (298021396053757952, 'HospitalLevel', 2, 2, '二级', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-02 09:10:38', 16508640061130151, 0, '2021-04-02 09:10:38');

INSERT INTO `sysdatadictdetail` VALUES (298021432649060352, 'HospitalLevel', 3, 3, '三级', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-02 09:10:47', 16508640061130151, 0, '2021-04-02 09:10:47');

INSERT INTO `sysdatadictdetail` VALUES (298087346266443776, 'education', 1, 1, '小学', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-02 13:32:42', 16508640061130151, 0, '2021-04-02 13:32:42');

INSERT INTO `sysdatadictdetail` VALUES (298087374317948928, 'education', 2, 2, '初中', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-02 13:32:48', 16508640061130151, 0, '2021-04-02 13:32:48');

INSERT INTO `sysdatadictdetail` VALUES (298087424452464640, 'education', 3, 3, '中专', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-02 13:33:00', 16508640061130151, 0, '2021-04-02 13:33:00');

INSERT INTO `sysdatadictdetail` VALUES (298087456564056064, 'education', 4, 4, '高中', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-02 13:33:08', 16508640061130151, 0, '2021-04-02 13:33:08');

INSERT INTO `sysdatadictdetail` VALUES (298087503900971008, 'education', 5, 5, '大专', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-02 13:33:19', 16508640061130151, 0, '2021-04-02 13:33:19');

INSERT INTO `sysdatadictdetail` VALUES (298087573018906624, 'education', 6, 6, '本科', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-02 13:33:36', 16508640061130151, 0, '2021-04-02 13:33:36');

INSERT INTO `sysdatadictdetail` VALUES (298087653734092800, 'education', 7, 7, '硕士', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-02 13:33:55', 16508640061130151, 0, '2021-04-02 13:33:55');

INSERT INTO `sysdatadictdetail` VALUES (298087907883749376, 'OccupationType', 1, 1, '企业职工', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-02 13:34:55', 16508640061130151, 0, '2021-04-02 13:34:55');

INSERT INTO `sysdatadictdetail` VALUES (298087937558450176, 'OccupationType', 2, 2, '在校学生', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-02 13:35:03', 16508640061130151, 0, '2021-04-02 13:35:03');

INSERT INTO `sysdatadictdetail` VALUES (298087969858785280, 'OccupationType', 3, 3, '自由职业', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-02 13:35:10', 16508640061130151, 0, '2021-04-02 13:35:10');

INSERT INTO `sysdatadictdetail` VALUES (298088001509003264, 'OccupationType', 4, 4, '退休人员', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-02 13:35:18', 16508640061130151, 0, '2021-04-02 13:35:18');

INSERT INTO `sysdatadictdetail` VALUES (299483272834977792, 'HospitalTitle', 1, 1, '专家', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-06 09:59:36', 16508640061130151, 0, '2021-04-06 09:59:36');

INSERT INTO `sysdatadictdetail` VALUES (299483307832250368, 'HospitalTitle', 2, 2, '主任医师', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-06 09:59:45', 16508640061130151, 0, '2021-04-06 09:59:45');

INSERT INTO `sysdatadictdetail` VALUES (299831472506802176, 'BillingMethod', 1, 1, '次', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-07 09:03:14', 16508640061130151, 0, '2021-04-07 09:03:14');

INSERT INTO `sysdatadictdetail` VALUES (299831541930921984, 'BillingMethod', 2, 2, '小时', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-07 09:03:30', 16508640061130151, 0, '2021-04-07 09:03:30');

INSERT INTO `sysdatadictdetail` VALUES (299831621685612544, 'BillingMethod', 3, 3, '件', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-07 09:03:49', 16508640061130151, 0, '2021-04-07 09:03:49');

INSERT INTO `sysdatadictdetail` VALUES (299862905476616192, 'CommissionType', 1, 1, '按比例', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-07 11:08:08', 16508640061130151, 0, '2021-04-07 11:08:08');

INSERT INTO `sysdatadictdetail` VALUES (299862953354596352, 'CommissionType', 2, 2, '按固定金额', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-07 11:08:19', 16508640061130151, 0, '2021-04-07 11:08:19');

INSERT INTO `sysdatadictdetail` VALUES (300210139925843968, 'BusinessNature', 1, 1, '国有企业', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-08 10:07:55', 16508640061130151, 0, '2021-04-08 10:07:55');

INSERT INTO `sysdatadictdetail` VALUES (300210164168921088, 'BusinessNature', 2, 2, '私营企业', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-08 10:08:01', 16508640061130151, 0, '2021-04-08 10:08:01');

INSERT INTO `sysdatadictdetail` VALUES (300210192824406016, 'BusinessNature', 3, 3, '社会团体', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-08 10:08:08', 16508640061130151, 0, '2021-04-08 10:08:08');

INSERT INTO `sysdatadictdetail` VALUES (300210222687850496, 'BusinessNature', 4, 4, '集体企业', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-08 10:08:15', 16508640061130151, 0, '2021-04-08 10:08:15');

INSERT INTO `sysdatadictdetail` VALUES (300210253633425408, 'BusinessNature', 5, 5, '股份合作制企业', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-08 10:08:22', 16508640061130151, 0, '2021-04-08 10:08:22');

INSERT INTO `sysdatadictdetail` VALUES (300273546473508864, 'OrganizationLevel', 1, 1, 'A', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-08 14:19:52', 16508640061130151, 0, '2021-04-08 14:19:52');

INSERT INTO `sysdatadictdetail` VALUES (300273599829250048, 'OrganizationLevel', 2, 2, 'AA', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-08 14:20:05', 16508640061130151, 0, '2021-04-08 14:20:05');

INSERT INTO `sysdatadictdetail` VALUES (300273633635340288, 'OrganizationLevel', 3, 3, 'AAA', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-08 14:20:13', 16508640061130151, 0, '2021-04-08 14:20:13');

INSERT INTO `sysdatadictdetail` VALUES (300275469981323264, 'LocationType', 1, 1, '城区', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-08 14:27:31', 16508640061130151, 0, '2021-04-08 14:27:31');

INSERT INTO `sysdatadictdetail` VALUES (300275500742348800, 'LocationType', 2, 2, '郊区', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-08 14:27:38', 16508640061130151, 0, '2021-04-08 14:27:38');

INSERT INTO `sysdatadictdetail` VALUES (300275549438218240, 'LocationType', 3, 3, '农村', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-08 14:27:50', 16508640061130151, 0, '2021-04-08 14:27:50');

INSERT INTO `sysdatadictdetail` VALUES (300275596557029376, 'LocationType', 4, 4, '风景区', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-08 14:28:01', 16508640061130151, 0, '2021-04-08 14:28:01');

INSERT INTO `sysdatadictdetail` VALUES (300276481391595520, 'MedicalServiceMode', 1, 1, '自办医院', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-08 14:31:32', 16508640061130151, 0, '2021-04-08 14:31:32');

INSERT INTO `sysdatadictdetail` VALUES (300276557493047296, 'MedicalServiceMode', 2, 2, '护理站', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-08 14:31:50', 16508640061130151, 0, '2021-04-08 14:31:50');

INSERT INTO `sysdatadictdetail` VALUES (300276628410339328, 'MedicalServiceMode', 3, 3, '医务室', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-08 14:32:07', 16508640061130151, 0, '2021-04-08 14:32:07');

INSERT INTO `sysdatadictdetail` VALUES (300276678922342400, 'MedicalServiceMode', 4, 4, '医院', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-08 14:32:19', 16508640061130151, 0, '2021-04-08 14:32:19');

INSERT INTO `sysdatadictdetail` VALUES (300276735306371072, 'MedicalServiceMode', 5, 5, '乡镇卫生院', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-08 14:32:33', 16508640061130151, 0, '2021-04-08 14:32:33');

INSERT INTO `sysdatadictdetail` VALUES (300276782169329664, 'MedicalServiceMode', 6, 6, '村（社区）卫生服务站（中心）', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-08 14:32:44', 16508640061130151, 0, '2021-04-08 14:32:44');

INSERT INTO `sysdatadictdetail` VALUES (300276821297991680, 'MedicalServiceMode', 7, 7, '未开展', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-08 14:32:53', 16508640061130151, 0, '2021-04-08 14:32:53');

INSERT INTO `sysdatadictdetail` VALUES (300281804676403200, 'OrgHousingSource', 1, 1, '自有产权', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-08 14:52:41', 16508640061130151, 0, '2021-04-08 14:52:41');

INSERT INTO `sysdatadictdetail` VALUES (300281839128416256, 'OrgHousingSource', 2, 2, '租赁', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-08 14:52:49', 16508640061130151, 0, '2021-04-08 14:52:49');

INSERT INTO `sysdatadictdetail` VALUES (300281876101206016, 'OrgHousingSource', 3, 3, '合作使用', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-08 14:52:58', 16508640061130151, 0, '2021-04-08 14:52:58');

INSERT INTO `sysdatadictdetail` VALUES (300281918644031488, 'OrgHousingSource', 4, 4, '其他', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-08 14:53:08', 16508640061130151, 0, '2021-04-08 14:53:08');

INSERT INTO `sysdatadictdetail` VALUES (300620120969973760, 'OrgFirstType', 1, 1, '国办', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 13:17:02', 16508640061130151, 0, '2021-04-09 13:17:02');

INSERT INTO `sysdatadictdetail` VALUES (300620159226220544, 'OrgFirstType', 2, 2, '民办', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 13:17:11', 16508640061130151, 0, '2021-04-09 13:17:11');

INSERT INTO `sysdatadictdetail` VALUES (300620212934283264, 'OrgFirstType', 3, 3, '乡镇（街道）敬老院', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 13:17:24', 16508640061130151, 0, '2021-04-09 13:17:24');

INSERT INTO `sysdatadictdetail` VALUES (300620780780130304, '民办', 1, 1, '民非登记', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 13:19:39', 16508640061130151, 0, '2021-04-09 13:19:39');

INSERT INTO `sysdatadictdetail` VALUES (300620834458832896, '民办', 2, 2, '工商登记', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 13:19:52', 16508640061130151, 0, '2021-04-09 13:19:52');

INSERT INTO `sysdatadictdetail` VALUES (300620907091595264, '民办', 3, 3, '未登记', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 13:20:10', 16508640061130151, 0, '2021-04-09 13:20:10');

INSERT INTO `sysdatadictdetail` VALUES (300621555325472768, '乡镇（街道）敬老院', 1, 1, '事业登记', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 13:22:44', 16508640061130151, 0, '2021-04-09 13:22:44');

INSERT INTO `sysdatadictdetail` VALUES (300621602574307328, '乡镇（街道）敬老院', 2, 2, '民非登记', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 13:22:55', 16508640061130151, 0, '2021-04-09 13:22:55');

INSERT INTO `sysdatadictdetail` VALUES (300621657054121984, '乡镇（街道）敬老院', 3, 3, '未登记', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 13:23:08', 16508640061130151, 0, '2021-04-09 13:23:08');

INSERT INTO `sysdatadictdetail` VALUES (300622186417229824, 'OrgDeviceType', 1, 1, '公共服务用房', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 13:25:15', 16508640061130151, 0, '2021-04-09 13:25:15');

INSERT INTO `sysdatadictdetail` VALUES (300624412107870208, 'OrgDeviceType', 2, 2, '医疗康复用房', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 13:34:05', 16508640061130151, 0, '2021-04-09 13:34:05');

INSERT INTO `sysdatadictdetail` VALUES (300624471817981952, 'OrgDeviceType', 3, 3, '文化娱乐用房', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 13:34:19', 16508640061130151, 0, '2021-04-09 13:34:19');

INSERT INTO `sysdatadictdetail` VALUES (300624543888707584, 'OrgDeviceType', 4, 4, '行政辅助用房', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 13:34:37', 16508640061130151, 0, '2021-04-09 13:34:37');

INSERT INTO `sysdatadictdetail` VALUES (300624574989471744, 'OrgDeviceType', 5, 5, '房间设备', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 13:34:44', 16508640061130151, 0, '2021-04-09 13:34:44');

INSERT INTO `sysdatadictdetail` VALUES (300624626587799552, 'OrgDeviceType', 6, 6, '公共服务设备', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 13:34:56', 16508640061130151, 0, '2021-04-09 13:34:56');

INSERT INTO `sysdatadictdetail` VALUES (300624698578833408, 'OrgDeviceType', 7, 7, '医疗康复设备', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 13:35:13', 16508640061130151, 0, '2021-04-09 13:35:13');

INSERT INTO `sysdatadictdetail` VALUES (300624764970471424, 'OrgDeviceType', 8, 8, '安全保障设备', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 13:35:37', 16508640061130151, 0, '2021-04-09 13:35:29');

INSERT INTO `sysdatadictdetail` VALUES (300624841726234624, 'OrgDeviceType', 9, 9, '消防安全设备', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 13:35:48', 16508640061130151, 0, '2021-04-09 13:35:48');

INSERT INTO `sysdatadictdetail` VALUES (300624900379381760, 'OrgDeviceType', 10, 10, '行政办公设备', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 13:36:02', 16508640061130151, 0, '2021-04-09 13:36:02');

INSERT INTO `sysdatadictdetail` VALUES (300638997510623232, 'PublicServiceRoom', 1, 1, '厨房', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 14:32:03', 16508640061130151, 0, '2021-04-09 14:32:03');

INSERT INTO `sysdatadictdetail` VALUES (300639031945859072, 'PublicServiceRoom', 2, 2, '餐厅', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 14:32:11', 16508640061130151, 0, '2021-04-09 14:32:11');

INSERT INTO `sysdatadictdetail` VALUES (300639066511118336, 'PublicServiceRoom', 3, 3, '公共浴室', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 14:32:19', 16508640061130151, 0, '2021-04-09 14:32:19');

INSERT INTO `sysdatadictdetail` VALUES (300639102456303616, 'PublicServiceRoom', 4, 4, '洗衣房', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 14:32:28', 16508640061130151, 0, '2021-04-09 14:32:28');

INSERT INTO `sysdatadictdetail` VALUES (300639143451430912, 'PublicServiceRoom', 5, 5, '其他', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 14:32:37', 16508640061130151, 0, '2021-04-09 14:32:37');

INSERT INTO `sysdatadictdetail` VALUES (300639194710020096, 'MedicalRoom', 1, 1, '医务室', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 14:32:50', 16508640061130151, 0, '2021-04-09 14:32:50');

INSERT INTO `sysdatadictdetail` VALUES (300639245222023168, 'MedicalRoom', 2, 2, '观察室', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 14:33:02', 16508640061130151, 0, '2021-04-09 14:33:02');

INSERT INTO `sysdatadictdetail` VALUES (300639286997291008, 'MedicalRoom', 3, 3, '康复室', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 14:33:12', 16508640061130151, 0, '2021-04-09 14:33:12');

INSERT INTO `sysdatadictdetail` VALUES (300639323164774400, 'MedicalRoom', 4, 4, '治疗室', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 14:33:20', 16508640061130151, 0, '2021-04-09 14:33:20');

INSERT INTO `sysdatadictdetail` VALUES (300639371676094464, 'MedicalRoom', 5, 5, '灭菌室', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 14:33:32', 16508640061130151, 0, '2021-04-09 14:33:32');

INSERT INTO `sysdatadictdetail` VALUES (300639426420150272, 'MedicalRoom', 6, 6, '隔离室', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 14:33:45', 16508640061130151, 0, '2021-04-09 14:33:45');

INSERT INTO `sysdatadictdetail` VALUES (300639486952345600, 'MedicalRoom', 7, 7, '其他', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 14:33:59', 16508640061130151, 0, '2021-04-09 14:33:59');

INSERT INTO `sysdatadictdetail` VALUES (300649819083378688, 'CultureRoom', 1, 1, '活动室', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:15:03', 16508640061130151, 0, '2021-04-09 15:15:03');

INSERT INTO `sysdatadictdetail` VALUES (300649893532274688, 'CultureRoom', 2, 2, '健身房', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:15:20', 16508640061130151, 0, '2021-04-09 15:15:20');

INSERT INTO `sysdatadictdetail` VALUES (300649933663375360, 'CultureRoom', 3, 3, '书画室', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:15:30', 16508640061130151, 0, '2021-04-09 15:15:30');

INSERT INTO `sysdatadictdetail` VALUES (300649989263069184, 'CultureRoom', 4, 4, '图书室', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:15:43', 16508640061130151, 0, '2021-04-09 15:15:43');

INSERT INTO `sysdatadictdetail` VALUES (300650034876125184, 'CultureRoom', 5, 5, '手工制作表', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:15:54', 16508640061130151, 0, '2021-04-09 15:15:54');

INSERT INTO `sysdatadictdetail` VALUES (300650080703090688, 'CultureRoom', 6, 6, '多功能厅', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:16:05', 16508640061130151, 0, '2021-04-09 15:16:05');

INSERT INTO `sysdatadictdetail` VALUES (300650124630036480, 'CultureRoom', 7, 7, '音乐舞蹈室', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:16:16', 16508640061130151, 0, '2021-04-09 15:16:16');

INSERT INTO `sysdatadictdetail` VALUES (300650168137551872, 'CultureRoom', 8, 8, '心理疏导室', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:16:26', 16508640061130151, 0, '2021-04-09 15:16:26');

INSERT INTO `sysdatadictdetail` VALUES (300650225125560320, 'CultureRoom', 9, 9, '其他', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:16:48', 16508640061130151, 0, '2021-04-09 15:16:39');

INSERT INTO `sysdatadictdetail` VALUES (300650477828182016, 'AssistRoom', 1, 1, '办公室', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:17:40', 16508640061130151, 0, '2021-04-09 15:17:40');

INSERT INTO `sysdatadictdetail` VALUES (300650510833160192, 'AssistRoom', 2, 2, '门卫室', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:17:48', 16508640061130151, 0, '2021-04-09 15:17:48');

INSERT INTO `sysdatadictdetail` VALUES (300650549185875968, 'AssistRoom', 3, 3, '接待室', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:17:57', 16508640061130151, 0, '2021-04-09 15:17:57');

INSERT INTO `sysdatadictdetail` VALUES (300650592991186944, 'AssistRoom', 4, 4, '会议室', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:18:07', 16508640061130151, 0, '2021-04-09 15:18:07');

INSERT INTO `sysdatadictdetail` VALUES (300650635630481408, 'AssistRoom', 5, 5, '库房', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:18:17', 16508640061130151, 0, '2021-04-09 15:18:17');

INSERT INTO `sysdatadictdetail` VALUES (300650677057622016, 'AssistRoom', 6, 6, '培训室', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:18:27', 16508640061130151, 0, '2021-04-09 15:18:27');

INSERT INTO `sysdatadictdetail` VALUES (300650718686089216, 'AssistRoom', 7, 7, '其他', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:18:37', 16508640061130151, 0, '2021-04-09 15:18:37');

INSERT INTO `sysdatadictdetail` VALUES (300650851184152576, 'RoomDevice', 1, 1, '床头灯', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:19:09', 16508640061130151, 0, '2021-04-09 15:19:09');

INSERT INTO `sysdatadictdetail` VALUES (300650890375729152, 'RoomDevice', 2, 2, '电视机', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:19:18', 16508640061130151, 0, '2021-04-09 15:19:18');

INSERT INTO `sysdatadictdetail` VALUES (300650924416700416, 'RoomDevice', 3, 3, '电风扇', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:19:26', 16508640061130151, 0, '2021-04-09 15:19:26');

INSERT INTO `sysdatadictdetail` VALUES (300650960714207232, 'RoomDevice', 4, 4, '暖气', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:19:35', 16508640061130151, 0, '2021-04-09 15:19:35');

INSERT INTO `sysdatadictdetail` VALUES (300651002636275712, 'RoomDevice', 5, 5, '衣柜', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:19:45', 16508640061130151, 0, '2021-04-09 15:19:45');

INSERT INTO `sysdatadictdetail` VALUES (300651043576877056, 'RoomDevice', 6, 6, '空调', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:19:55', 16508640061130151, 0, '2021-04-09 15:19:55');

INSERT INTO `sysdatadictdetail` VALUES (300651081824735232, 'RoomDevice', 7, 7, '电冰箱', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:20:04', 16508640061130151, 0, '2021-04-09 15:20:04');

INSERT INTO `sysdatadictdetail` VALUES (300651129241341952, 'RoomDevice', 8, 8, '电话', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:20:15', 16508640061130151, 0, '2021-04-09 15:20:15');

INSERT INTO `sysdatadictdetail` VALUES (300651170681065472, 'RoomDevice', 9, 9, '洗衣机', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:20:25', 16508640061130151, 0, '2021-04-09 15:20:25');

INSERT INTO `sysdatadictdetail` VALUES (300651213815287808, 'RoomDevice', 10, 10, '电脑', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:20:35', 16508640061130151, 0, '2021-04-09 15:20:35');

INSERT INTO `sysdatadictdetail` VALUES (300651255275982848, 'RoomDevice', 11, 11, '网络', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:20:45', 16508640061130151, 0, '2021-04-09 15:20:45');

INSERT INTO `sysdatadictdetail` VALUES (300651300293447680, 'RoomDevice', 12, 12, '紧急呼叫设备', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:20:56', 16508640061130151, 0, '2021-04-09 15:20:56');

INSERT INTO `sysdatadictdetail` VALUES (300651340353245184, 'RoomDevice', 13, 13, '其他', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:21:05', 16508640061130151, 0, '2021-04-09 15:21:05');

INSERT INTO `sysdatadictdetail` VALUES (300651535581319168, 'PublicServiceDevice', 1, 1, '公用电话', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:21:52', 16508640061130151, 0, '2021-04-09 15:21:52');

INSERT INTO `sysdatadictdetail` VALUES (300651574571569152, 'PublicServiceDevice', 2, 2, '普通电梯', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:22:01', 16508640061130151, 0, '2021-04-09 15:22:01');

INSERT INTO `sysdatadictdetail` VALUES (300651619870052352, 'PublicServiceDevice', 3, 3, '医用电梯', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:22:12', 16508640061130151, 0, '2021-04-09 15:22:12');

INSERT INTO `sysdatadictdetail` VALUES (300651656142393344, 'PublicServiceDevice', 4, 4, '生活用车', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:22:21', 16508640061130151, 0, '2021-04-09 15:22:21');

INSERT INTO `sysdatadictdetail` VALUES (300651694100844544, 'PublicServiceDevice', 5, 5, '公共上网区域', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:22:30', 16508640061130151, 0, '2021-04-09 15:22:30');

INSERT INTO `sysdatadictdetail` VALUES (300651734278082560, 'PublicServiceDevice', 6, 6, '救护车', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:22:39', 16508640061130151, 0, '2021-04-09 15:22:39');

INSERT INTO `sysdatadictdetail` VALUES (300651772593049600, 'PublicServiceDevice', 7, 7, '其他', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:22:48', 16508640061130151, 0, '2021-04-09 15:22:48');

INSERT INTO `sysdatadictdetail` VALUES (300651810564083712, 'PublicServiceDevice', 8, 8, '全无', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:22:57', 16508640061130151, 0, '2021-04-09 15:22:57');

INSERT INTO `sysdatadictdetail` VALUES (300651973684760576, 'MedicalDevice', 1, 1, '制氧机', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:23:36', 16508640061130151, 0, '2021-04-09 15:23:36');

INSERT INTO `sysdatadictdetail` VALUES (300652014428229632, 'MedicalDevice', 2, 2, '呼吸机', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:23:46', 16508640061130151, 0, '2021-04-09 15:23:46');

INSERT INTO `sysdatadictdetail` VALUES (300652054857125888, 'MedicalDevice', 3, 3, '血压计', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:23:56', 16508640061130151, 0, '2021-04-09 15:23:56');

INSERT INTO `sysdatadictdetail` VALUES (300652099694235648, 'MedicalDevice', 4, 4, '血糖仪', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:24:06', 16508640061130151, 0, '2021-04-09 15:24:06');

INSERT INTO `sysdatadictdetail` VALUES (300652141175902208, 'MedicalDevice', 5, 5, '代步车', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:24:16', 16508640061130151, 0, '2021-04-09 15:24:16');

INSERT INTO `sysdatadictdetail` VALUES (300652180480724992, 'MedicalDevice', 6, 6, '心电图', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:24:26', 16508640061130151, 0, '2021-04-09 15:24:26');

INSERT INTO `sysdatadictdetail` VALUES (300652221899476992, 'MedicalDevice', 7, 7, '吸痰器', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:24:36', 16508640061130151, 0, '2021-04-09 15:24:36');

INSERT INTO `sysdatadictdetail` VALUES (300652264773652480, 'MedicalDevice', 8, 8, '中医理疗康复', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:24:46', 16508640061130151, 0, '2021-04-09 15:24:46');

INSERT INTO `sysdatadictdetail` VALUES (300652303600324608, 'MedicalDevice', 9, 9, '轮椅', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:24:55', 16508640061130151, 0, '2021-04-09 15:24:55');

INSERT INTO `sysdatadictdetail` VALUES (300652347531464704, 'MedicalDevice', 10, 10, '其他', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:25:18', 16508640061130151, 0, '2021-04-09 15:25:06');

INSERT INTO `sysdatadictdetail` VALUES (300652529199353856, 'SafeDevice', 1, 1, '轮椅坡道', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:25:49', 16508640061130151, 0, '2021-04-09 15:25:49');

INSERT INTO `sysdatadictdetail` VALUES (300652571536658432, 'SafeDevice', 2, 2, '安全扶手', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:25:59', 16508640061130151, 0, '2021-04-09 15:25:59');

INSERT INTO `sysdatadictdetail` VALUES (300652609318948864, 'SafeDevice', 3, 3, '防滑地板', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:26:08', 16508640061130151, 0, '2021-04-09 15:26:08');

INSERT INTO `sysdatadictdetail` VALUES (300652648602800128, 'SafeDevice', 4, 4, '监控设备', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:26:17', 16508640061130151, 0, '2021-04-09 15:26:17');

INSERT INTO `sysdatadictdetail` VALUES (300652689170108416, 'SafeDevice', 5, 5, '消防设备', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:26:27', 16508640061130151, 0, '2021-04-09 15:26:27');

INSERT INTO `sysdatadictdetail` VALUES (300652743347933184, 'SafeDevice', 6, 6, '无障碍卫生间', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:26:40', 16508640061130151, 0, '2021-04-09 15:26:40');

INSERT INTO `sysdatadictdetail` VALUES (300652793662803968, 'SafeDevice', 7, 7, '其他', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:26:52', 16508640061130151, 0, '2021-04-09 15:26:52');

INSERT INTO `sysdatadictdetail` VALUES (300652930413891584, 'FireControlDevice', 1, 1, '火灾自动报警系统', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:27:24', 16508640061130151, 0, '2021-04-09 15:27:24');

INSERT INTO `sysdatadictdetail` VALUES (300652973996904448, 'FireControlDevice', 2, 2, '简易喷淋装置', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:27:35', 16508640061130151, 0, '2021-04-09 15:27:35');

INSERT INTO `sysdatadictdetail` VALUES (300653018192285696, 'FireControlDevice', 3, 3, '应急照明', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:27:45', 16508640061130151, 0, '2021-04-09 15:27:45');

INSERT INTO `sysdatadictdetail` VALUES (300653059489402880, 'FireControlDevice', 4, 4, '灭火器', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:27:55', 16508640061130151, 0, '2021-04-09 15:27:55');

INSERT INTO `sysdatadictdetail` VALUES (300653099096215552, 'FireControlDevice', 5, 5, '消防水栓', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:28:05', 16508640061130151, 0, '2021-04-09 15:28:05');

INSERT INTO `sysdatadictdetail` VALUES (300653144033988608, 'FireControlDevice', 6, 6, '防排烟风机', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:28:15', 16508640061130151, 0, '2021-04-09 15:28:15');

INSERT INTO `sysdatadictdetail` VALUES (300653190989221888, 'FireControlDevice', 7, 7, '防火卷帘', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:28:27', 16508640061130151, 0, '2021-04-09 15:28:27');

INSERT INTO `sysdatadictdetail` VALUES (300653237076234240, 'FireControlDevice', 8, 8, '其他', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:28:38', 16508640061130151, 0, '2021-04-09 15:28:38');

INSERT INTO `sysdatadictdetail` VALUES (300653420606394368, 'OfficeDevice', 1, 1, '电脑', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:29:21', 16508640061130151, 0, '2021-04-09 15:29:21');

INSERT INTO `sysdatadictdetail` VALUES (300653464038412288, 'OfficeDevice', 2, 2, '传真机', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:29:32', 16508640061130151, 0, '2021-04-09 15:29:32');

INSERT INTO `sysdatadictdetail` VALUES (300653505717211136, 'OfficeDevice', 3, 3, '养老服务管理软件', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:29:42', 16508640061130151, 0, '2021-04-09 15:29:42');

INSERT INTO `sysdatadictdetail` VALUES (300653550529155072, 'OfficeDevice', 4, 4, '电话 ', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:29:52', 16508640061130151, 0, '2021-04-09 15:29:52');

INSERT INTO `sysdatadictdetail` VALUES (300653599602511872, 'OfficeDevice', 5, 5, '网络', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:30:04', 16508640061130151, 0, '2021-04-09 15:30:04');

INSERT INTO `sysdatadictdetail` VALUES (300653640329203712, 'OfficeDevice', 6, 6, '办公用车', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:30:14', 16508640061130151, 0, '2021-04-09 15:30:14');

INSERT INTO `sysdatadictdetail` VALUES (300653698323845120, 'OfficeDevice', 7, 7, '全无', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-09 15:30:28', 16508640061130151, 0, '2021-04-09 15:30:28');

INSERT INTO `sysdatadictdetail` VALUES (301749558654799872, 'OldmanLivingSituation', 1, 1, '独自居住', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:05:01', 16508640061130151, 0, '2021-04-12 16:05:01');

INSERT INTO `sysdatadictdetail` VALUES (301749593748541440, 'OldmanLivingSituation', 2, 2, '与配偶居住', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:05:09', 16508640061130151, 0, '2021-04-12 16:05:09');

INSERT INTO `sysdatadictdetail` VALUES (301749625897881600, 'OldmanLivingSituation', 3, 3, '与子女合住', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:05:17', 16508640061130151, 0, '2021-04-12 16:05:17');

INSERT INTO `sysdatadictdetail` VALUES (301749657158029312, 'OldmanLivingSituation', 4, 4, '其他', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:05:25', 16508640061130151, 0, '2021-04-12 16:05:25');

INSERT INTO `sysdatadictdetail` VALUES (301749698312540160, 'OldmanLivingSituation', 5, 5, '与亲戚合住', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:05:34', 16508640061130151, 0, '2021-04-12 16:05:34');

INSERT INTO `sysdatadictdetail` VALUES (301749735516016640, 'OldmanLivingSituation', 6, 6, '居无定所', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:05:43', 16508640061130151, 0, '2021-04-12 16:05:43');

INSERT INTO `sysdatadictdetail` VALUES (301750313155563520, 'FamilyTies', 1, 1, '祖孙', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:08:01', 16508640061130151, 0, '2021-04-12 16:08:01');

INSERT INTO `sysdatadictdetail` VALUES (301750377106116608, 'FamilyTies', 2, 2, '父子', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:08:16', 16508640061130151, 0, '2021-04-12 16:08:16');

INSERT INTO `sysdatadictdetail` VALUES (301750408198492160, 'FamilyTies', 3, 3, '母子', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:08:24', 16508640061130151, 0, '2021-04-12 16:08:24');

INSERT INTO `sysdatadictdetail` VALUES (301750437994827776, 'FamilyTies', 4, 4, '父女', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:08:31', 16508640061130151, 0, '2021-04-12 16:08:31');

INSERT INTO `sysdatadictdetail` VALUES (301750466297991168, 'FamilyTies', 5, 5, '母女', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:08:37', 16508640061130151, 0, '2021-04-12 16:08:37');

INSERT INTO `sysdatadictdetail` VALUES (301750491149242368, 'FamilyTies', 6, 6, '姐妹', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:08:43', 16508640061130151, 0, '2021-04-12 16:08:43');

INSERT INTO `sysdatadictdetail` VALUES (301750513949478912, 'FamilyTies', 7, 7, '兄妹', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:08:49', 16508640061130151, 0, '2021-04-12 16:08:49');

INSERT INTO `sysdatadictdetail` VALUES (301750585609162752, 'FamilyTies', 8, 8, '姐弟', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:09:06', 16508640061130151, 0, '2021-04-12 16:09:06');

INSERT INTO `sysdatadictdetail` VALUES (301750610611408896, 'FamilyTies', 9, 9, '叔侄', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:09:12', 16508640061130151, 0, '2021-04-12 16:09:12');

INSERT INTO `sysdatadictdetail` VALUES (301750648548888576, 'FamilyTies', 10, 10, '公孙', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:09:21', 16508640061130151, 0, '2021-04-12 16:09:21');

INSERT INTO `sysdatadictdetail` VALUES (301750680522067968, 'FamilyTies', 11, 11, '孙女', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:09:28', 16508640061130151, 0, '2021-04-12 16:09:28');

INSERT INTO `sysdatadictdetail` VALUES (301750704282800128, 'FamilyTies', 12, 12, '孙子', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:09:34', 16508640061130151, 0, '2021-04-12 16:09:34');

INSERT INTO `sysdatadictdetail` VALUES (301750732309139456, 'FamilyTies', 13, 13, '兄弟', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:09:41', 16508640061130151, 0, '2021-04-12 16:09:41');

INSERT INTO `sysdatadictdetail` VALUES (301750768321433600, 'FamilyTies', 15, 15, '侄女', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:09:49', 16508640061130151, 0, '2021-04-12 16:09:49');

INSERT INTO `sysdatadictdetail` VALUES (301750792031834112, 'FamilyTies', 16, 16, '外孙女', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:09:55', 16508640061130151, 0, '2021-04-12 16:09:55');

INSERT INTO `sysdatadictdetail` VALUES (301750832427175936, 'FamilyTies', 17, 17, '妻子', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:10:05', 16508640061130151, 0, '2021-04-12 16:10:05');

INSERT INTO `sysdatadictdetail` VALUES (301750864874311680, 'FamilyTies', 18, 18, '姊妹', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:10:12', 16508640061130151, 0, '2021-04-12 16:10:12');

INSERT INTO `sysdatadictdetail` VALUES (301750904774725632, 'FamilyTies', 19, 19, '配偶', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:10:22', 16508640061130151, 0, '2021-04-12 16:10:22');

INSERT INTO `sysdatadictdetail` VALUES (301751000010592256, 'FamilyTies', 20, 20, '女婿', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:10:45', 16508640061130151, 0, '2021-04-12 16:10:45');

INSERT INTO `sysdatadictdetail` VALUES (301751045996941312, 'FamilyTies', 14, 14, '儿媳', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:10:56', 16508640061130151, 0, '2021-04-12 16:10:56');

INSERT INTO `sysdatadictdetail` VALUES (301751096085319680, 'FamilyTies', 21, 21, '婆媳', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:11:08', 16508640061130151, 0, '2021-04-12 16:11:08');

INSERT INTO `sysdatadictdetail` VALUES (301751123826446336, 'FamilyTies', 22, 22, '夫妻', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:11:14', 16508640061130151, 0, '2021-04-12 16:11:14');

INSERT INTO `sysdatadictdetail` VALUES (301751162615369728, 'FamilyTies', 23, 23, '子女', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:11:23', 16508640061130151, 0, '2021-04-12 16:11:23');

INSERT INTO `sysdatadictdetail` VALUES (301751443788926976, 'FinanceSource', 1, 1, '出租房子', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:12:30', 16508640061130151, 0, '2021-04-12 16:12:30');

INSERT INTO `sysdatadictdetail` VALUES (301751475804049408, 'FinanceSource', 2, 2, '子女赡养', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:12:38', 16508640061130151, 0, '2021-04-12 16:12:38');

INSERT INTO `sysdatadictdetail` VALUES (301751499980017664, 'FinanceSource', 3, 3, '做小生意', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:12:44', 16508640061130151, 0, '2021-04-12 16:12:44');

INSERT INTO `sysdatadictdetail` VALUES (301751525611409408, 'FinanceSource', 4, 4, '未知', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:12:50', 16508640061130151, 0, '2021-04-12 16:12:50');

INSERT INTO `sysdatadictdetail` VALUES (301751575964028928, 'FinanceSource', 5, 5, '子女', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:13:02', 16508640061130151, 0, '2021-04-12 16:13:02');

INSERT INTO `sysdatadictdetail` VALUES (301751608587325440, 'FinanceSource', 6, 6, '退休金/子女', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:13:10', 16508640061130151, 0, '2021-04-12 16:13:10');

INSERT INTO `sysdatadictdetail` VALUES (301751657711013888, 'FinanceSource', 7, 7, '退休金', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:13:21', 16508640061130151, 0, '2021-04-12 16:13:21');

INSERT INTO `sysdatadictdetail` VALUES (301751690032320512, 'FinanceSource', 8, 8, '子女/养老金', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:13:29', 16508640061130151, 0, '2021-04-12 16:13:29');

INSERT INTO `sysdatadictdetail` VALUES (301751715886010368, 'FinanceSource', 9, 9, '社保工资', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:13:35', 16508640061130151, 0, '2021-04-12 16:13:35');

INSERT INTO `sysdatadictdetail` VALUES (301751751881527296, 'FinanceSource', 10, 10, '退休金/养老金', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:13:44', 16508640061130151, 0, '2021-04-12 16:13:44');

INSERT INTO `sysdatadictdetail` VALUES (301751778892845056, 'FinanceSource', 11, 11, '低保', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:13:50', 16508640061130151, 0, '2021-04-12 16:13:50');

INSERT INTO `sysdatadictdetail` VALUES (301751805509898240, 'FinanceSource', 12, 12, '其他补贴', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:13:57', 16508640061130151, 0, '2021-04-12 16:13:57');

INSERT INTO `sysdatadictdetail` VALUES (301751833917919232, 'FinanceSource', 13, 13, '亲友资助', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:14:03', 16508640061130151, 0, '2021-04-12 16:14:03');

INSERT INTO `sysdatadictdetail` VALUES (301752573214330880, 'MedicalSecurity', 1, 1, '城镇居民医疗保险', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:17:00', 16508640061130151, 0, '2021-04-12 16:17:00');

INSERT INTO `sysdatadictdetail` VALUES (301752597545488384, 'MedicalSecurity', 2, 2, '城镇职工医疗保险', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:17:06', 16508640061130151, 0, '2021-04-12 16:17:06');

INSERT INTO `sysdatadictdetail` VALUES (301752630135230464, 'MedicalSecurity', 3, 3, '其他', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:17:13', 16508640061130151, 0, '2021-04-12 16:17:13');

INSERT INTO `sysdatadictdetail` VALUES (301752652625088512, 'MedicalSecurity', 4, 4, '商业保险', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:17:19', 16508640061130151, 0, '2021-04-12 16:17:19');

INSERT INTO `sysdatadictdetail` VALUES (301752680395575296, 'MedicalSecurity', 5, 5, '新兴农村合作医疗', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:17:25', 16508640061130151, 0, '2021-04-12 16:17:25');

INSERT INTO `sysdatadictdetail` VALUES (301752837568729088, 'Disability', 1, 1, '无残疾', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:18:03', 16508640061130151, 0, '2021-04-12 16:18:03');

INSERT INTO `sysdatadictdetail` VALUES (301752857185488896, 'Disability', 2, 2, '中度残疾', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:18:07', 16508640061130151, 0, '2021-04-12 16:18:07');

INSERT INTO `sysdatadictdetail` VALUES (301752878228312064, 'Disability', 3, 3, '重度残疾', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:18:12', 16508640061130151, 0, '2021-04-12 16:18:12');

INSERT INTO `sysdatadictdetail` VALUES (301752901745774592, 'Disability', 4, 4, '轻度残疾', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:18:18', 16508640061130151, 0, '2021-04-12 16:18:18');

INSERT INTO `sysdatadictdetail` VALUES (301753641985904640, 'StandardCulture', 1, 1, '大专', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:21:15', 16508640061130151, 0, '2021-04-12 16:21:15');

INSERT INTO `sysdatadictdetail` VALUES (301753666698743808, 'StandardCulture', 2, 2, '中专', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:21:20', 16508640061130151, 0, '2021-04-12 16:21:20');

INSERT INTO `sysdatadictdetail` VALUES (301753687959670784, 'StandardCulture', 3, 3, '小学', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:21:26', 16508640061130151, 0, '2021-04-12 16:21:26');

INSERT INTO `sysdatadictdetail` VALUES (301753709610668032, 'StandardCulture', 4, 4, '硕士', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:21:31', 16508640061130151, 0, '2021-04-12 16:21:31');

INSERT INTO `sysdatadictdetail` VALUES (301753737079164928, 'StandardCulture', 5, 5, '高中', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:21:37', 16508640061130151, 0, '2021-04-12 16:21:37');

INSERT INTO `sysdatadictdetail` VALUES (301753763008352256, 'StandardCulture', 6, 6, '初中', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:21:43', 16508640061130151, 0, '2021-04-12 16:21:43');

INSERT INTO `sysdatadictdetail` VALUES (301753789596045312, 'StandardCulture', 7, 7, '本科', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:21:50', 16508640061130151, 0, '2021-04-12 16:21:50');

INSERT INTO `sysdatadictdetail` VALUES (301753812849266688, 'StandardCulture', 8, 8, '大学专科及以上', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:21:55', 16508640061130151, 0, '2021-04-12 16:21:55');

INSERT INTO `sysdatadictdetail` VALUES (301753838317080576, 'StandardCulture', 9, 9, '未上学', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:22:01', 16508640061130151, 0, '2021-04-12 16:22:01');

INSERT INTO `sysdatadictdetail` VALUES (301753869497536512, 'StandardCulture', 10, 10, '未知', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-12 16:22:09', 16508640061130151, 0, '2021-04-12 16:22:09');

INSERT INTO `sysdatadictdetail` VALUES (302013066436939776, 'CardStatus', 1, 1, '未发放', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-13 09:32:06', 16508640061130151, 0, '2021-04-13 09:32:06');

INSERT INTO `sysdatadictdetail` VALUES (302013261589516288, 'CardStatus', 2, 2, '已发放', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-13 09:32:53', 16508640061130151, 0, '2021-04-13 09:32:53');

INSERT INTO `sysdatadictdetail` VALUES (302013291423600640, 'CardStatus', 3, 3, '注销', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-13 09:33:00', 16508640061130151, 0, '2021-04-13 09:33:00');

INSERT INTO `sysdatadictdetail` VALUES (302023686485970944, 'OldmanType', 1, 1, 'A类：重点对象', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-13 10:14:18', 16508640061130151, 0, '2021-04-13 10:14:18');

INSERT INTO `sysdatadictdetail` VALUES (302023738520506368, 'OldmanType', 2, 2, 'B类：高龄对象', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-13 10:14:31', 16508640061130151, 0, '2021-04-13 10:14:31');

INSERT INTO `sysdatadictdetail` VALUES (302023772452425728, 'OldmanType', 3, 3, 'C类：一般对象', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-13 10:14:39', 16508640061130151, 0, '2021-04-13 10:14:39');

INSERT INTO `sysdatadictdetail` VALUES (302024155602096128, 'MaritalStatus', 1, 1, '已婚', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-13 10:16:10', 16508640061130151, 0, '2021-04-13 10:16:10');

INSERT INTO `sysdatadictdetail` VALUES (302024179815813120, 'MaritalStatus', 2, 2, '未婚', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-13 10:16:16', 16508640061130151, 0, '2021-04-13 10:16:16');

INSERT INTO `sysdatadictdetail` VALUES (302024208198668288, 'MaritalStatus', 3, 3, '离异', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-13 10:16:23', 16508640061130151, 0, '2021-04-13 10:16:23');

INSERT INTO `sysdatadictdetail` VALUES (302024233658093568, 'MaritalStatus', 4, 4, '丧偶', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-13 10:16:29', 16508640061130151, 0, '2021-04-13 10:16:29');

INSERT INTO `sysdatadictdetail` VALUES (302024261646684160, 'MaritalStatus', 5, 5, '再婚', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-13 10:16:35', 16508640061130151, 0, '2021-04-13 10:16:35');

INSERT INTO `sysdatadictdetail` VALUES (302095962086576128, 'LostOfAbility', 1, 1, '能力完好', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-13 15:01:30', 16508640061130151, 0, '2021-04-13 15:01:30');

INSERT INTO `sysdatadictdetail` VALUES (302095999352967168, 'LostOfAbility', 2, 2, '轻度失能', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-13 15:01:39', 16508640061130151, 0, '2021-04-13 15:01:39');

INSERT INTO `sysdatadictdetail` VALUES (302096035470118912, 'LostOfAbility', 3, 3, '中度失能', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-13 15:01:48', 16508640061130151, 0, '2021-04-13 15:01:48');

INSERT INTO `sysdatadictdetail` VALUES (302096069393649664, 'LostOfAbility', 4, 4, '重度失能', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-13 15:01:56', 16508640061130151, 0, '2021-04-13 15:01:56');

INSERT INTO `sysdatadictdetail` VALUES (302100054758395904, 'ChronicDisease', 1, 1, '高血压', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-13 15:17:46', 16508640061130151, 0, '2021-04-13 15:17:46');

INSERT INTO `sysdatadictdetail` VALUES (302100090900713472, 'ChronicDisease', 2, 2, '高血糖', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-13 15:17:54', 16508640061130151, 0, '2021-04-13 15:17:54');

INSERT INTO `sysdatadictdetail` VALUES (302100135259672576, 'ChronicDisease', 3, 3, '其他', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-13 15:18:05', 16508640061130151, 0, '2021-04-13 15:18:05');

INSERT INTO `sysdatadictdetail` VALUES (302100160782012416, 'ChronicDisease', 4, 4, '冠心病', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-13 15:18:11', 16508640061130151, 0, '2021-04-13 15:18:11');

INSERT INTO `sysdatadictdetail` VALUES (302100196026748928, 'ChronicDisease', 5, 5, '慢性支气管炎', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-13 15:18:19', 16508640061130151, 0, '2021-04-13 15:18:19');

INSERT INTO `sysdatadictdetail` VALUES (302100221179990016, 'ChronicDisease', 6, 6, '哮喘', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-13 15:18:25', 16508640061130151, 0, '2021-04-13 15:18:25');

INSERT INTO `sysdatadictdetail` VALUES (302100251051823104, 'ChronicDisease', 7, 7, '癌症', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-13 15:18:33', 16508640061130151, 0, '2021-04-13 15:18:33');

INSERT INTO `sysdatadictdetail` VALUES (302100273621372928, 'ChronicDisease', 8, 8, '慢性肝炎', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-13 15:18:38', 16508640061130151, 0, '2021-04-13 15:18:38');

INSERT INTO `sysdatadictdetail` VALUES (302100300158734336, 'ChronicDisease', 9, 9, '慢性肾功能不全', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-13 15:18:44', 16508640061130151, 0, '2021-04-13 15:18:44');

INSERT INTO `sysdatadictdetail` VALUES (302100341275496448, 'ChronicDisease', 10, 10, '慢性贫血', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-13 15:18:54', 16508640061130151, 0, '2021-04-13 15:18:54');

INSERT INTO `sysdatadictdetail` VALUES (302100378617384960, 'ChronicDisease', 11, 11, '慢性关节炎', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-13 15:19:03', 16508640061130151, 0, '2021-04-13 15:19:03');

INSERT INTO `sysdatadictdetail` VALUES (302100405830029312, 'ChronicDisease', 12, 12, '慢性颈椎疼痛', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-13 15:19:10', 16508640061130151, 0, '2021-04-13 15:19:10');

INSERT INTO `sysdatadictdetail` VALUES (302100712282656768, 'ChronicDisease', 13, 13, '老年智力障碍', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-13 15:20:23', 16508640061130151, 0, '2021-04-13 15:20:23');

INSERT INTO `sysdatadictdetail` VALUES (302100767051878400, 'ChronicDisease', 14, 14, '痛风', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-13 15:20:36', 16508640061130151, 0, '2021-04-13 15:20:36');

INSERT INTO `sysdatadictdetail` VALUES (302392668544045056, 'RechargeMethod', 1, 1, '现金充值', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-14 10:40:30', 16508640061130151, 0, '2021-04-14 10:40:30');

INSERT INTO `sysdatadictdetail` VALUES (302392734650470400, 'RechargeMethod', 2, 2, '刷卡充值', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-14 10:40:46', 16508640061130151, 0, '2021-04-14 10:40:46');

INSERT INTO `sysdatadictdetail` VALUES (302392783669301248, 'RechargeMethod', 3, 3, '支付宝充值', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-14 10:40:58', 16508640061130151, 0, '2021-04-14 10:40:58');

INSERT INTO `sysdatadictdetail` VALUES (302392821120241664, 'RechargeMethod', 4, 4, '微信充值', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-14 10:41:07', 16508640061130151, 0, '2021-04-14 10:41:07');

INSERT INTO `sysdatadictdetail` VALUES (302450853216784384, 'ServiceState', 1, 1, '正常服务', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-14 14:31:43', 16508640061130151, 0, '2021-04-14 14:31:43');

INSERT INTO `sysdatadictdetail` VALUES (302450881314426880, 'ServiceState', 2, 2, '停止服务', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-14 14:31:49', 16508640061130151, 0, '2021-04-14 14:31:49');

INSERT INTO `sysdatadictdetail` VALUES (302451924999868416, 'CapabilityRating', 1, 1, '特级', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-14 14:35:58', 16508640061130151, 0, '2021-04-14 14:35:58');

INSERT INTO `sysdatadictdetail` VALUES (302763843883372544, 'CardStatus', 4, 4, '挂失', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-15 11:15:25', 16508640061130151, 0, '2021-04-15 11:15:25');

INSERT INTO `sysdatadictdetail` VALUES (303183459885518848, 'RechargeMethod', 0, 0, '老人卡付款', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-16 15:02:50', 16508640061130151, 0, '2021-04-16 15:02:50');

INSERT INTO `sysdatadictdetail` VALUES (304630752207704064, 'PaymentType', 1, 1, '现金支付', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-20 14:53:51', 16508640061130151, 0, '2021-04-20 14:53:51');

INSERT INTO `sysdatadictdetail` VALUES (304630786613579776, 'PaymentType', 2, 2, '余额支付', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-20 14:53:59', 16508640061130151, 0, '2021-04-20 14:53:59');

INSERT INTO `sysdatadictdetail` VALUES (304630837947666432, 'PaymentType', 3, 3, '套餐支付', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-20 14:54:12', 16508640061130151, 0, '2021-04-20 14:54:12');

INSERT INTO `sysdatadictdetail` VALUES (304630872731029504, 'PaymentType', 4, 4, '线上支付', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-20 14:54:20', 16508640061130151, 0, '2021-04-20 14:54:20');

INSERT INTO `sysdatadictdetail` VALUES (304899921083895808, 'AllergicDrug', 1, 1, '抗生药', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 08:43:26', 16508640061130151, 0, '2021-04-21 08:43:26');

INSERT INTO `sysdatadictdetail` VALUES (304899960199974912, 'AllergicDrug', 2, 2, '长效磺胺', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 08:43:35', 16508640061130151, 0, '2021-04-21 08:43:35');

INSERT INTO `sysdatadictdetail` VALUES (304900012737826816, 'AllergicDrug', 3, 3, '舒乐安定', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 08:43:48', 16508640061130151, 0, '2021-04-21 08:43:48');

INSERT INTO `sysdatadictdetail` VALUES (304900124046266368, 'AllergicDrug', 4, 4, '左洛复', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 08:44:14', 16508640061130151, 0, '2021-04-21 08:44:14');

INSERT INTO `sysdatadictdetail` VALUES (304900163581775872, 'AllergicDrug', 5, 5, '镇定剂', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 08:44:24', 16508640061130151, 0, '2021-04-21 08:44:24');

INSERT INTO `sysdatadictdetail` VALUES (304900191067049984, 'AllergicDrug', 6, 6, '异博定片', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 08:44:30', 16508640061130151, 0, '2021-04-21 08:44:30');

INSERT INTO `sysdatadictdetail` VALUES (304900219194052608, 'AllergicDrug', 7, 7, '巴比妥类药', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 08:44:37', 16508640061130151, 0, '2021-04-21 08:44:37');

INSERT INTO `sysdatadictdetail` VALUES (304900248914890752, 'AllergicDrug', 8, 8, '普鲁卡因', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 08:44:44', 16508640061130151, 0, '2021-04-21 08:44:44');

INSERT INTO `sysdatadictdetail` VALUES (304900283450789888, 'AllergicDrug', 9, 9, '动物血清', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 08:44:52', 16508640061130151, 0, '2021-04-21 08:44:52');

INSERT INTO `sysdatadictdetail` VALUES (304900323711913984, 'AllergicDrug', 10, 10, '六神丸', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 08:45:02', 16508640061130151, 0, '2021-04-21 08:45:02');

INSERT INTO `sysdatadictdetail` VALUES (304900361422901248, 'AllergicDrug', 11, 11, '花青素', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 08:45:11', 16508640061130151, 0, '2021-04-21 08:45:11');

INSERT INTO `sysdatadictdetail` VALUES (304900404871696384, 'AllergicDrug', 12, 12, '霍南大', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 08:45:21', 16508640061130151, 0, '2021-04-21 08:45:21');

INSERT INTO `sysdatadictdetail` VALUES (304900429672615936, 'AllergicDrug', 13, 13, '奥氮平', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 08:45:27', 16508640061130151, 0, '2021-04-21 08:45:27');

INSERT INTO `sysdatadictdetail` VALUES (304900466641211392, 'AllergicDrug', 14, 14, '皮炎平', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 08:45:36', 16508640061130151, 0, '2021-04-21 08:45:36');

INSERT INTO `sysdatadictdetail` VALUES (304911779249524736, 'DisabilityTypes', 1, 1, '无残疾', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 09:30:33', 16508640061130151, 0, '2021-04-21 09:30:33');

INSERT INTO `sysdatadictdetail` VALUES (304911813596680192, 'DisabilityTypes', 2, 2, '听力残疾', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 09:30:41', 16508640061130151, 0, '2021-04-21 09:30:41');

INSERT INTO `sysdatadictdetail` VALUES (304911845431447552, 'DisabilityTypes', 3, 3, '言语残疾', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 09:30:49', 16508640061130151, 0, '2021-04-21 09:30:49');

INSERT INTO `sysdatadictdetail` VALUES (304911882316156928, 'DisabilityTypes', 4, 4, '肢体残疾', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 09:30:58', 16508640061130151, 0, '2021-04-21 09:30:58');

INSERT INTO `sysdatadictdetail` VALUES (304911907632975872, 'DisabilityTypes', 6, 6, '智力残疾', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 09:31:04', 16508640061130151, 0, '2021-04-21 09:31:04');

INSERT INTO `sysdatadictdetail` VALUES (304911950993690624, 'DisabilityTypes', 5, 5, '视力残疾', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 09:31:14', 16508640061130151, 0, '2021-04-21 09:31:14');

INSERT INTO `sysdatadictdetail` VALUES (304911982102843392, 'DisabilityTypes', 7, 7, '精神残疾', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 09:31:22', 16508640061130151, 0, '2021-04-21 09:31:22');

INSERT INTO `sysdatadictdetail` VALUES (304928503814426624, 'Hobbies', 1, 1, '棋牌', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 10:37:01', 16508640061130151, 0, '2021-04-21 10:37:01');

INSERT INTO `sysdatadictdetail` VALUES (304928531735908352, 'Hobbies', 2, 2, '歌舞', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 10:37:07', 16508640061130151, 0, '2021-04-21 10:37:07');

INSERT INTO `sysdatadictdetail` VALUES (304928570579357696, 'Hobbies', 3, 3, '戏曲评书', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 10:37:17', 16508640061130151, 0, '2021-04-21 10:37:17');

INSERT INTO `sysdatadictdetail` VALUES (304928594864377856, 'Hobbies', 4, 4, '钓鱼', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 10:37:22', 16508640061130151, 0, '2021-04-21 10:37:22');

INSERT INTO `sysdatadictdetail` VALUES (304928619791126528, 'Hobbies', 5, 5, '门球', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 10:37:28', 16508640061130151, 0, '2021-04-21 10:37:28');

INSERT INTO `sysdatadictdetail` VALUES (304928668751237120, 'Hobbies', 6, 6, '书画', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 10:37:40', 16508640061130151, 0, '2021-04-21 10:37:40');

INSERT INTO `sysdatadictdetail` VALUES (304928844400300032, 'Hobbies', 7, 7, '集邮收藏', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 10:38:22', 16508640061130151, 0, '2021-04-21 10:38:22');

INSERT INTO `sysdatadictdetail` VALUES (304928870027497472, 'Hobbies', 8, 8, '摄影', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 10:38:28', 16508640061130151, 0, '2021-04-21 10:38:28');

INSERT INTO `sysdatadictdetail` VALUES (304928902785011712, 'Hobbies', 9, 9, '晨练活动', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 10:38:36', 16508640061130151, 0, '2021-04-21 10:38:36');

INSERT INTO `sysdatadictdetail` VALUES (304928942752534528, 'Hobbies', 10, 10, '旅游', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 10:38:45', 16508640061130151, 0, '2021-04-21 10:38:45');

INSERT INTO `sysdatadictdetail` VALUES (304928980195086336, 'Hobbies', 11, 11, '健康养生', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 10:38:54', 16508640061130151, 0, '2021-04-21 10:38:54');

INSERT INTO `sysdatadictdetail` VALUES (304929101343363072, 'Hobbies', 12, 12, '阅读', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 10:39:23', 16508640061130151, 0, '2021-04-21 10:39:23');

INSERT INTO `sysdatadictdetail` VALUES (304930492719828992, 'Hobbies', 13, 13, '理疗', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 10:44:55', 16508640061130151, 0, '2021-04-21 10:44:55');

INSERT INTO `sysdatadictdetail` VALUES (304930591294361600, 'Hobbies', 14, 14, '唱歌', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 10:45:18', 16508640061130151, 0, '2021-04-21 10:45:18');

INSERT INTO `sysdatadictdetail` VALUES (304933526686404608, 'Speciality', 1, 1, '棋牌', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 10:56:58', 16508640061130151, 0, '2021-04-21 10:56:58');

INSERT INTO `sysdatadictdetail` VALUES (304933574405001216, 'Speciality', 2, 2, '戏曲评书', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 10:57:10', 16508640061130151, 0, '2021-04-21 10:57:10');

INSERT INTO `sysdatadictdetail` VALUES (304933602490060800, 'Speciality', 3, 3, '歌舞', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 10:57:16', 16508640061130151, 0, '2021-04-21 10:57:16');

INSERT INTO `sysdatadictdetail` VALUES (304933627362283520, 'Speciality', 4, 4, '门球', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 10:57:22', 16508640061130151, 0, '2021-04-21 10:57:22');

INSERT INTO `sysdatadictdetail` VALUES (304934325013450752, 'Speciality', 5, 5, '摄影', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-21 11:00:08', 16508640061130151, 0, '2021-04-21 11:00:08');

INSERT INTO `sysdatadictdetail` VALUES (305373598338519040, 'DeviceMainType', 1, 1, '健康设备', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-22 16:05:39', 16508640061130151, 0, '2021-04-22 16:05:39');

INSERT INTO `sysdatadictdetail` VALUES (305374262875656192, 'DeviceMainType', 2, 2, '安防设备', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-22 16:08:18', 16508640061130151, 0, '2021-04-22 16:08:18');

INSERT INTO `sysdatadictdetail` VALUES (305374302457303040, 'DeviceMainType', 3, 3, '视频监控', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-22 16:08:27', 16508640061130151, 0, '2021-04-22 16:08:27');

INSERT INTO `sysdatadictdetail` VALUES (305374345042071552, 'DeviceMainType', 4, 4, '定位设备', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-22 16:08:37', 16508640061130151, 0, '2021-04-22 16:08:37');

INSERT INTO `sysdatadictdetail` VALUES (305374382778224640, 'DeviceMainType', 5, 5, '安防配套', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-22 16:08:46', 16508640061130151, 0, '2021-04-22 16:08:46');

INSERT INTO `sysdatadictdetail` VALUES (307191222621966336, 'specifications', 1, 1, '个', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-27 16:28:15', 16508640061130151, 0, '2021-04-27 16:28:15');

INSERT INTO `sysdatadictdetail` VALUES (307191248328855552, 'specifications', 2, 2, '只', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-27 16:28:21', 16508640061130151, 0, '2021-04-27 16:28:21');

INSERT INTO `sysdatadictdetail` VALUES (307191293157576704, 'specifications', 3, 3, '件', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-27 16:28:32', 16508640061130151, 0, '2021-04-27 16:28:32');

INSERT INTO `sysdatadictdetail` VALUES (308255886084673536, 'PaymentMethod', 1, 1, '在线支付', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-30 14:58:50', 16508640061130151, 0, '2021-04-30 14:58:50');

INSERT INTO `sysdatadictdetail` VALUES (308272633051353088, 'LogisticsCompany', 1, 1, '顺丰', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-30 16:05:23', 16508640061130151, 0, '2021-04-30 16:05:23');

INSERT INTO `sysdatadictdetail` VALUES (308272655859978240, 'LogisticsCompany', 2, 2, '京东', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-30 16:05:29', 16508640061130151, 0, '2021-04-30 16:05:29');

INSERT INTO `sysdatadictdetail` VALUES (308272684045701120, 'LogisticsCompany', 3, 3, '圆通', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-04-30 16:05:35', 16508640061130151, 0, '2021-04-30 16:05:35');

INSERT INTO `sysdatadictdetail` VALUES (310466024602341376, 'HealthInfoType', 1, 1, '糖尿病', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-05-06 17:21:08', 16508640061130151, 0, '2021-05-06 17:21:08');

INSERT INTO `sysdatadictdetail` VALUES (310466056411942912, 'HealthInfoType', 2, 2, '高血压', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-05-06 17:21:16', 16508640061130151, 0, '2021-05-06 17:21:16');

INSERT INTO `sysdatadictdetail` VALUES (310698639330643968, 'HealthInfoType', 3, 3, '健康养生', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-05-07 08:45:28', 16508640061130151, 0, '2021-05-07 08:45:28');

INSERT INTO `sysdatadictdetail` VALUES (310698683798654976, 'HealthInfoType', 4, 4, '急救常识', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-05-07 08:45:39', 16508640061130151, 0, '2021-05-07 08:45:39');

INSERT INTO `sysdatadictdetail` VALUES (311814260344754176, 'HealthVisitType', 1, 1, '诊所', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-05-10 10:38:33', 16508640061130151, 0, '2021-05-10 10:38:33');

INSERT INTO `sysdatadictdetail` VALUES (311814293018382336, 'HealthVisitType', 2, 2, '家庭', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-05-10 10:38:41', 16508640061130151, 0, '2021-05-10 10:38:41');

INSERT INTO `sysdatadictdetail` VALUES (311814320797257728, 'HealthVisitType', 3, 3, '电话', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-05-10 10:38:47', 16508640061130151, 0, '2021-05-10 10:38:47');

INSERT INTO `sysdatadictdetail` VALUES (311817138299998208, 'HealthAssessType', 1, 1, '健康', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-05-10 10:49:59', 16508640061130151, 0, '2021-05-10 10:49:59');

INSERT INTO `sysdatadictdetail` VALUES (311817169249767424, 'HealthAssessType', 2, 2, '慢病', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-05-10 10:50:06', 16508640061130151, 0, '2021-05-10 10:50:06');

INSERT INTO `sysdatadictdetail` VALUES (311817206134476800, 'HealthAssessType', 3, 3, '老人能力', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-05-10 10:50:15', 16508640061130151, 0, '2021-05-10 10:50:15');

INSERT INTO `sysdatadictdetail` VALUES (311817233745580032, 'HealthAssessType', 4, 4, '日常生活能力', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-05-10 10:50:22', 16508640061130151, 0, '2021-05-10 10:50:22');

INSERT INTO `sysdatadictdetail` VALUES (311817265139945472, 'HealthAssessType', 5, 5, '精神状态', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-05-10 10:50:29', 16508640061130151, 0, '2021-05-10 10:50:29');

INSERT INTO `sysdatadictdetail` VALUES (311817301361954816, 'HealthAssessType', 6, 6, '感知/沟通能力', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-05-10 10:50:38', 16508640061130151, 0, '2021-05-10 10:50:38');

INSERT INTO `sysdatadictdetail` VALUES (311817337424580608, 'HealthAssessType', 7, 7, '社会参与', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-05-10 10:50:47', 16508640061130151, 0, '2021-05-10 10:50:47');

INSERT INTO `sysdatadictdetail` VALUES (311817368332406784, 'HealthAssessType', 8, 8, '营养不良风险', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-05-10 10:50:54', 16508640061130151, 0, '2021-05-10 10:50:54');

INSERT INTO `sysdatadictdetail` VALUES (311817402201411584, 'HealthAssessType', 9, 9, '跌倒风险', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-05-10 10:51:02', 16508640061130151, 0, '2021-05-10 10:51:02');

INSERT INTO `sysdatadictdetail` VALUES (311817457486532608, 'HealthAssessType', 10, 10, '抑郁自测、焦虑自评', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-05-10 10:51:15', 16508640061130151, 0, '2021-05-10 10:51:15');

INSERT INTO `sysdatadictdetail` VALUES (311817487098318848, 'HealthAssessType', 11, 11, '噎食危险因子', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-05-10 10:51:22', 16508640061130151, 0, '2021-05-10 10:51:22');

INSERT INTO `sysdatadictdetail` VALUES (311817517452496896, 'HealthAssessType', 12, 12, '压疮风险', NULL, 1, 0, '', 16508640061130151, NULL, NULL, '2021-05-10 10:51:29', 16508640061130151, 0, '2021-05-10 10:51:29');



-- ----------------------------

-- Table structure for sysdepartment

-- ----------------------------

DROP TABLE IF EXISTS `sysdepartment`;

CREATE TABLE `sysdepartment`  (

  `Id` bigint(0) NOT NULL,

  `ParentId` bigint(0) NULL DEFAULT NULL COMMENT '父部门Id(0表示是根部门)',

  `DepartmentName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门名称',

  `Telephone` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门电话',

  `Fax` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门传真',

  `Email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门Email',

  `PrincipalId` bigint(0) NULL DEFAULT NULL COMMENT '部门负责人Id',

  `DepartmentSort` int(0) NULL DEFAULT NULL COMMENT '部门排序',

  `Remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注',

  `Enable` tinyint(0) NULL DEFAULT NULL COMMENT '是否启用',

  `PrincipalPhone` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '负责人电话',

  `DepartmentCode` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门编号',

  `CreateUserId` bigint(0) NULL DEFAULT NULL COMMENT '创建人ID编号',

  `DeleteTime` datetime(0) NULL DEFAULT NULL COMMENT '删除时间',

  `DeleteUserId` bigint(0) NULL DEFAULT NULL COMMENT '删除人ID编号',

  `LastModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '最后修改时间',

  `LastModifyUserId` bigint(0) NULL DEFAULT NULL COMMENT '最后修改人ID编号',

  `IsDelete` tinyint(0) NULL DEFAULT NULL,

  `CreateTime` datetime(0) NULL DEFAULT NULL,

  `DeptType` int(0) NULL DEFAULT NULL COMMENT '部门类型（DepartmentType枚举值）',

  PRIMARY KEY (`Id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of sysdepartment

-- ----------------------------

INSERT INTO `sysdepartment` VALUES (16508640061124402, NULL, '主公司', '0551-6666666', '0551-8888888', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);

INSERT INTO `sysdepartment` VALUES (16508640061124403, 16508640061124402, '一号子公司', '111', '11', '11', 16508640061130151, 1, '', 1, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);

INSERT INTO `sysdepartment` VALUES (16508640061124404, 16508640061124402, '二号子公司', '1', '', '', 16505640061130150, 1, '', 1, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);

INSERT INTO `sysdepartment` VALUES (16508640061124405, 16508640061124403, '研发部', '3', '', '', 16508640061130153, 1, '专注前端与后端结合的开发模式', 1, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);

INSERT INTO `sysdepartment` VALUES (16508640061124406, 16508640061124403, '测试部', '1', '', '', 0, 3, '', 1, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);

INSERT INTO `sysdepartment` VALUES (16508640061124407, 16508640061124403, '前端设计部', '1', '', '', 16508640061130150, 2, '', 1, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);

INSERT INTO `sysdepartment` VALUES (16508640061124408, 16508640061124403, '财务部', '0551-87654321', '0551-12345678', 'wangxue@yishasoft.com', 0, 15, '2', 1, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);

INSERT INTO `sysdepartment` VALUES (16508640061124409, 16508640061124403, '市场部', '111', '111', '11', 16508640061130150, 7, '', 1, '', '', NULL, NULL, NULL, '2021-03-31 10:12:47', 16508640061130151, NULL, NULL, 0);

INSERT INTO `sysdepartment` VALUES (297043731545067520, 16508640061124405, '11', '11', '11', '11', 16508640061130150, 1, NULL, NULL, NULL, NULL, 16508640061130151, NULL, NULL, '2021-03-30 16:25:44', 16508640061130151, 0, '2021-03-30 16:25:44', 0);

INSERT INTO `sysdepartment` VALUES (313344111564296192, 16508640061124402, '爱期颐', '', '', '', 297033728075501568, NULL, NULL, NULL, NULL, NULL, 16508640061130151, NULL, NULL, '2021-05-14 15:57:38', 16508640061130151, 0, '2021-05-14 15:57:38', 1);



-- ----------------------------

-- Table structure for syslogapi

-- ----------------------------

DROP TABLE IF EXISTS `syslogapi`;

CREATE TABLE `syslogapi`  (

  `Id` bigint(0) NOT NULL,

  `CreateTime` datetime(0) NULL DEFAULT NULL,

  `CreatorId` bigint(0) NULL DEFAULT NULL,

  `LogStatus` int(0) NULL DEFAULT NULL COMMENT '执行状态(0失败 1成功)',

  `Remark` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',

  `ExecuteUrl` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '接口地址',

  `ExecuteParam` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '请求参数',

  `ExecuteResult` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '请求结果',

  `ExecuteTime` int(0) NULL DEFAULT NULL COMMENT '执行时间',

  `IpAddress` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'IP地址',

  `CreateUserId` bigint(0) NULL DEFAULT NULL COMMENT '创建人ID编号',

  `DeleteTime` datetime(0) NULL DEFAULT NULL COMMENT '删除时间',

  `DeleteUserId` bigint(0) NULL DEFAULT NULL COMMENT '删除人ID编号',

  `LastModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '最后修改时间',

  `LastModifyUserId` bigint(0) NULL DEFAULT NULL COMMENT '最后修改人ID编号',

  `IsDelete` tinyint(0) NULL DEFAULT NULL COMMENT '删除标识 0：未删除 1：已删除',

  PRIMARY KEY (`Id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of syslogapi

-- ----------------------------

INSERT INTO `syslogapi` VALUES (318065253323640832, '2021-05-27 16:37:46', NULL, 1, NULL, '/HomeManage/Home/GetPageListAndUserInfo', '', NULL, 286, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (318065253323640833, '2021-05-27 16:37:46', NULL, 1, NULL, '/HomeManage/Home/GetUserAuthorizeJson', '', NULL, 274, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (318069709809389568, '2021-05-27 16:55:28', NULL, 1, NULL, '/HomeManage/Home/GetPageListAndUserInfo', '', NULL, 313, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (318069709809389569, '2021-05-27 16:55:28', NULL, 1, NULL, '/HomeManage/Home/GetUserAuthorizeJson', '', NULL, 267, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (318070064349712384, '2021-05-27 16:56:53', NULL, 1, NULL, '/HomeManage/Home/GetUserAuthorizeJson', '', NULL, 76, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (318070064504901632, '2021-05-27 16:56:53', NULL, 1, NULL, '/HomeManage/Home/GetPageListAndUserInfo', '', NULL, 112, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (318070164467748864, '2021-05-27 16:57:17', NULL, 1, NULL, '/SystemManage/LogLogin/GetPageListJson', '?PageIndex=1&PageSize=15', NULL, 70, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (318070290250731520, '2021-05-27 16:57:47', NULL, 1, NULL, '/SystemManage/AutoJob/GetPageListJson', '?PageIndex=1&PageSize=15', NULL, 65, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (318070587664633856, '2021-05-27 16:58:58', NULL, 0, NULL, '/SystemManage/AutoJob/SaveFormJson', '{\"entity\":{\"JobGroupName\":null,\"JobName\":null,\"JobStatus\":null,\"CronExpression\":null,\"StartTime\":null,\"EndTime\":null,\"NextStartTime\":null,\"Remark\":null,\"IsDelete\":false,\"CreateTime\":\"2021-05-27 16:58:57\",\"CreateUserId\":\"16508640061130151\",\"DeleteTime\":null,\"DeleteUserId\":null,\"LastModifyTime\":\"2021-05-27 16:58:57\",\"LastModifyUserId\":\"16508640061130151\",\"Id\":\"318070585928192000\"}}', 'An error occurred while updating the entries. See the inner exception for details.\r\n不能将值 NULL 插入列 \'CronExpression\'，表 \'queer.dbo.SysAutoJob\'；列不允许有 Null 值。INSERT 失败。\r\n语句已终止。\r\n   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(DbContext _, Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)\r\n   at Furion.DatabaseAccessor.PrivateRepository`1.InsertNowAsync(TEntity entity, Nullable`1 ignoreNullValues, CancellationToken cancellationToken)\r\n   at Queer.Service.SystemManage.AutoJobService.SaveForm(AutoJobEntity entity) in F:\\GIT\\queer\\MyProject\\Queer.Service\\SystemManage\\AutoJobService.cs:line 92\r\n   at Queer.Business.SystemManage.AutoJobBLL.SaveForm(AutoJobEntity entity) in F:\\GIT\\queer\\MyProject\\Queer.Business\\SystemManage\\AutoJobBLL.cs:line 65\r\n   at Queer.WebApi.Areas.Admin.SystemManage.AutoJobController.SaveFormJson(AutoJobEntity entity) in F:\\GIT\\queer\\MyProject\\Queer.WebApi\\Areas\\Admin\\SystemManage\\AutoJobController.cs:line 84\r\n   at lambda_method691(Closure , Object )\r\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)\r\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Logged|12_1(ControllerActionInvoker invoker)\r\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)\r\n', 535, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (318070612016762880, '2021-05-27 16:59:03', NULL, 1, NULL, '/SystemManage/LogApi/GetPageListJson', '?PageIndex=1&PageSize=15', NULL, 133, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (318070853403152384, '2021-05-27 17:00:01', NULL, 0, NULL, '/SystemManage/AutoJob/SaveFormJson', '{\"entity\":{\"JobGroupName\":null,\"JobName\":null,\"JobStatus\":null,\"CronExpression\":null,\"StartTime\":null,\"EndTime\":null,\"NextStartTime\":null,\"Remark\":null,\"IsDelete\":false,\"CreateTime\":\"2021-05-27 17:00:00\",\"CreateUserId\":\"16508640061130151\",\"DeleteTime\":null,\"DeleteUserId\":null,\"LastModifyTime\":\"2021-05-27 17:00:00\",\"LastModifyUserId\":\"16508640061130151\",\"Id\":\"318070852623011840\"}}', 'An error occurred while updating the entries. See the inner exception for details.\r\n不能将值 NULL 插入列 \'CronExpression\'，表 \'queer.dbo.SysAutoJob\'；列不允许有 Null 值。INSERT 失败。\r\n语句已终止。\r\n   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(DbContext _, Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)\r\n   at Furion.DatabaseAccessor.PrivateRepository`1.InsertNowAsync(TEntity entity, Nullable`1 ignoreNullValues, CancellationToken cancellationToken)\r\n   at Queer.Service.SystemManage.AutoJobService.SaveForm(AutoJobEntity entity) in F:\\GIT\\queer\\MyProject\\Queer.Service\\SystemManage\\AutoJobService.cs:line 92\r\n   at Queer.Business.SystemManage.AutoJobBLL.SaveForm(AutoJobEntity entity) in F:\\GIT\\queer\\MyProject\\Queer.Business\\SystemManage\\AutoJobBLL.cs:line 65\r\n   at Queer.WebApi.Areas.Admin.SystemManage.AutoJobController.SaveFormJson(AutoJobEntity entity) in F:\\GIT\\queer\\MyProject\\Queer.WebApi\\Areas\\Admin\\SystemManage\\AutoJobController.cs:line 84\r\n   at lambda_method691(Closure , Object )\r\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)\r\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Logged|12_1(ControllerActionInvoker invoker)\r\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)\r\n', 224, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (318070945082249216, '2021-05-27 17:00:23', NULL, 0, NULL, '/SystemManage/AutoJob/SaveFormJson', '{\"entity\":{\"JobGroupName\":null,\"JobName\":null,\"JobStatus\":null,\"CronExpression\":null,\"StartTime\":null,\"EndTime\":null,\"NextStartTime\":null,\"Remark\":null,\"IsDelete\":false,\"CreateTime\":\"2021-05-27 17:00:22\",\"CreateUserId\":\"16508640061130151\",\"DeleteTime\":null,\"DeleteUserId\":null,\"LastModifyTime\":\"2021-05-27 17:00:22\",\"LastModifyUserId\":\"16508640061130151\",\"Id\":\"318070944310497280\"}}', 'An error occurred while updating the entries. See the inner exception for details.\r\n不能将值 NULL 插入列 \'CronExpression\'，表 \'queer.dbo.SysAutoJob\'；列不允许有 Null 值。INSERT 失败。\r\n语句已终止。\r\n   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(DbContext _, Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)\r\n   at Furion.DatabaseAccessor.PrivateRepository`1.InsertNowAsync(TEntity entity, Nullable`1 ignoreNullValues, CancellationToken cancellationToken)\r\n   at Queer.Service.SystemManage.AutoJobService.SaveForm(AutoJobEntity entity) in F:\\GIT\\queer\\MyProject\\Queer.Service\\SystemManage\\AutoJobService.cs:line 92\r\n   at Queer.Business.SystemManage.AutoJobBLL.SaveForm(AutoJobEntity entity) in F:\\GIT\\queer\\MyProject\\Queer.Business\\SystemManage\\AutoJobBLL.cs:line 65\r\n   at Queer.WebApi.Areas.Admin.SystemManage.AutoJobController.SaveFormJson(AutoJobEntity entity) in F:\\GIT\\queer\\MyProject\\Queer.WebApi\\Areas\\Admin\\SystemManage\\AutoJobController.cs:line 84\r\n   at lambda_method691(Closure , Object )\r\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)\r\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Logged|12_1(ControllerActionInvoker invoker)\r\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)\r\n', 216, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (318071412352880640, '2021-05-27 17:02:14', NULL, 1, NULL, '/HomeManage/Home/GetPageListAndUserInfo', '', NULL, 301, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (318071412357074944, '2021-05-27 17:02:14', NULL, 1, NULL, '/HomeManage/Home/GetUserAuthorizeJson', '', NULL, 291, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (318071470917947392, '2021-05-27 17:02:28', NULL, 0, NULL, '/SystemManage/AutoJob/SaveFormJson', '{\"entity\":{\"JobGroupName\":\"系统\",\"JobName\":\"数据库备份\",\"JobStatus\":1,\"CronExpression\":\"0 0 3 1/1 * ?\",\"StartTime\":\"2021-05-27 16:59:52\",\"EndTime\":\"2031-05-27 16:59:41\",\"NextStartTime\":null,\"Remark\":\"\",\"IsDelete\":false,\"CreateTime\":\"2021-05-27 17:02:27\",\"CreateUserId\":\"16508640061130151\",\"DeleteTime\":null,\"DeleteUserId\":null,\"LastModifyTime\":\"2021-05-27 17:02:27\",\"LastModifyUserId\":\"16508640061130151\",\"Id\":\"318071469160534016\"}}', 'An error occurred while updating the entries. See the inner exception for details.\r\n不能将值 NULL 插入列 \'NextStartTime\'，表 \'queer.dbo.SysAutoJob\'；列不允许有 Null 值。INSERT 失败。\r\n语句已终止。\r\n   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(DbContext _, Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)\r\n   at Furion.DatabaseAccessor.PrivateRepository`1.InsertNowAsync(TEntity entity, Nullable`1 ignoreNullValues, CancellationToken cancellationToken)\r\n   at Queer.Service.SystemManage.AutoJobService.SaveForm(AutoJobEntity entity) in F:\\GIT\\queer\\MyProject\\Queer.Service\\SystemManage\\AutoJobService.cs:line 92\r\n   at Queer.Business.SystemManage.AutoJobBLL.SaveForm(AutoJobEntity entity) in F:\\GIT\\queer\\MyProject\\Queer.Business\\SystemManage\\AutoJobBLL.cs:line 65\r\n   at Queer.WebApi.Areas.Admin.SystemManage.AutoJobController.SaveFormJson(AutoJobEntity entity) in F:\\GIT\\queer\\MyProject\\Queer.WebApi\\Areas\\Admin\\SystemManage\\AutoJobController.cs:line 84\r\n   at lambda_method617(Closure , Object )\r\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)\r\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Logged|12_1(ControllerActionInvoker invoker)\r\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)\r\n', 8308, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (318071486415900672, '2021-05-27 17:02:32', NULL, 1, NULL, '/SystemManage/LogApi/GetPageListJson', '?PageIndex=1&PageSize=15', NULL, 121, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (318071742931144704, '2021-05-27 17:03:33', NULL, 1, NULL, '/SystemManage/AutoJob/GetPageListJson', '?PageIndex=1&PageSize=15', NULL, 70, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (318071827190517760, '2021-05-27 17:03:53', NULL, 1, NULL, '/SystemManage/AutoJob/SaveFormJson', '{\"entity\":{\"JobGroupName\":\"系统\",\"JobName\":\"数据库备份\",\"JobStatus\":1,\"CronExpression\":\"0 0 3 1/1 * ?\",\"StartTime\":\"2021-05-27 17:03:35\",\"EndTime\":\"2031-05-27 17:03:33\",\"NextStartTime\":\"2021-05-27 17:03:35\",\"Remark\":\"\",\"IsDelete\":false,\"CreateTime\":\"2021-05-27 17:03:53\",\"CreateUserId\":\"16508640061130151\",\"DeleteTime\":null,\"DeleteUserId\":null,\"LastModifyTime\":\"2021-05-27 17:03:53\",\"LastModifyUserId\":\"16508640061130151\",\"Id\":\"318071827001774080\"}}', NULL, 84, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (318071827798691840, '2021-05-27 17:03:53', NULL, 1, NULL, '/SystemManage/AutoJob/GetPageListJson', '?PageIndex=1&PageSize=15', NULL, 68, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (318072087283503104, '2021-05-27 17:04:55', NULL, 0, NULL, '/SystemManage/AutoJob/GetPageListJsonForLog', '?PageIndex=1&PageSize=15&JobName=%E6%95%B0%E6%8D%AE%E5%BA%93%E5%A4%87%E4%BB%BD', '列名 \'CreateTime\' 无效。\r\n列名 \'CreateUserId\' 无效。\r\n列名 \'DeleteTime\' 无效。\r\n列名 \'DeleteUserId\' 无效。\r\n列名 \'IsDelete\' 无效。\r\n列名 \'LastModifyTime\' 无效。\r\n列名 \'LastModifyUserId\' 无效。\r\n   at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__169_0(Task`1 result)\r\n   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()\r\n   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)\r\n--- End of stack trace from previous location ---\r\n   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)\r\n--- End of stack trace from previous location ---\r\n   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(DbContext _, Boolean result, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()\r\n   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)\r\n   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)\r\n   at Furion.DatabaseAccessor.PagedQueryableExtensions.ToPagedListAsync[TEntity](IQueryable`1 entities, Int32 pageIndex, Int32 pageSize, CancellationToken cancellationToken)\r\n   at Queer.Service.SystemManage.AutoJobLogService.GetPageList(AutoJobLogListParam param, Pagination pagination) in F:\\GIT\\queer\\MyProject\\Queer.Service\\SystemManage\\AutoJobLogService.cs:line 52\r\n   at Queer.Business.SystemManage.AutoJobLogBLL.GetPageList(AutoJobLogListParam param, Pagination pagination) in F:\\GIT\\queer\\MyProject\\Queer.Business\\SystemManage\\AutoJobLogBLL.cs:line 44\r\n   at Queer.WebApi.Areas.Admin.SystemManage.AutoJobController.GetPageListJsonForLog(AutoJobLogListParam param, Pagination pagination) in F:\\GIT\\queer\\MyProject\\Queer.WebApi\\Areas\\Admin\\SystemManage\\AutoJobController.cs:line 70\r\n   at lambda_method902(Closure , Object )\r\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)\r\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Logged|12_1(ControllerActionInvoker invoker)\r\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)\r\n', 293, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (318072369031680000, '2021-05-27 17:06:02', NULL, 1, NULL, '/SystemManage/Database/GetTablePageListJson', '?PageIndex=1&PageSize=15', NULL, 382, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (318072375482519552, '2021-05-27 17:06:04', NULL, 1, NULL, '/ToolManage/Server/GetServerInfo', '', NULL, 574, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (318072380167557120, '2021-05-27 17:06:05', NULL, 1, NULL, '/SystemManage/CodeTemplet/GetListJson', '', NULL, 93, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (318072382101131264, '2021-05-27 17:06:05', NULL, 1, NULL, '/ToolManage/Server/GetServerStatus', '', NULL, 2117, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (318072400895807488, '2021-05-27 17:06:10', NULL, 1, NULL, '/ToolManage/Server/GetServerStatus', '', NULL, 1419, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (318072420583870464, '2021-05-27 17:06:15', NULL, 1, NULL, '/ToolManage/Server/GetServerStatus', '', NULL, 1650, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (318076418120486912, '2021-05-27 17:22:08', NULL, 1, NULL, '/HomeManage/Home/GetPageListAndUserInfo', '', NULL, 284, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (318076418120486913, '2021-05-27 17:22:08', NULL, 1, NULL, '/HomeManage/Home/GetUserAuthorizeJson', '', NULL, 281, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (318076457299480576, '2021-05-27 17:22:17', NULL, 1, NULL, '/SystemManage/Role/GetPageListJson', '?PageIndex=1&PageSize=15', NULL, 94, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (318313902410567680, '2021-05-28 09:05:48', NULL, 1, NULL, '/HomeManage/Home/GetUserAuthorizeJson', '', NULL, 240, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (318313902435733504, '2021-05-28 09:05:48', NULL, 1, NULL, '/HomeManage/Home/GetPageListAndUserInfo', '', NULL, 247, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (318313920106336256, '2021-05-28 09:05:53', NULL, 1, NULL, '/SystemManage/Database/GetTablePageListJson', '?PageIndex=1&PageSize=15', NULL, 164, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (318313924250308608, '2021-05-28 09:05:54', NULL, 1, NULL, '/SystemManage/Cache/GetPageListJson', '?PageIndex=1&PageSize=15', NULL, 22, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (319504138423504896, '2021-05-31 15:55:23', NULL, 1, NULL, '/HomeManage/Home/GetUserAuthorizeJson', '', NULL, 314, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (319504142303236096, '2021-05-31 15:55:24', NULL, 1, NULL, '/HomeManage/Home/GetPageListAndUserInfo', '', NULL, 1240, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (319504479282008064, '2021-05-31 15:56:44', NULL, 1, NULL, '/SystemManage/Database/GetTablePageListJson', '?PageIndex=1&PageSize=15', NULL, 929, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (319504510533767168, '2021-05-31 15:56:51', NULL, 1, NULL, '/SystemManage/Cache/GetPageListJson', '?PageIndex=1&PageSize=15', NULL, 298, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (319504525813616640, '2021-05-31 15:56:55', NULL, 1, NULL, '/SystemManage/LogLogin/GetPageListJson', '?PageIndex=1&PageSize=15', NULL, 529, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (319504533027819520, '2021-05-31 15:56:57', NULL, 1, NULL, '/SystemManage/LogApi/GetPageListJson', '?PageIndex=1&PageSize=15', NULL, 515, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `syslogapi` VALUES (319504545161940992, '2021-05-31 15:57:00', NULL, 1, NULL, '/SystemManage/Menu/GetListJson', '', NULL, 391, '192.168.10.12', 16508640061130151, NULL, NULL, NULL, NULL, NULL);



-- ----------------------------

-- Table structure for sysloglogin

-- ----------------------------

DROP TABLE IF EXISTS `sysloglogin`;

CREATE TABLE `sysloglogin`  (

  `Id` bigint(0) NOT NULL,

  `CreateTime` datetime(0) NOT NULL,

  `CreatorId` bigint(0) NULL DEFAULT NULL,

  `LogStatus` int(0) NOT NULL COMMENT '执行状态(0失败 1成功)',

  `IpAddress` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ip地址',

  `IpLocation` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ip位置',

  `Browser` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '浏览器',

  `OS` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '操作系统',

  `Remark` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',

  `ExtraRemark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '额外备注',

  `CreateUserId` bigint(0) NULL DEFAULT NULL COMMENT '创建人ID编号',

  `DeleteTime` datetime(0) NULL DEFAULT NULL COMMENT '删除时间',

  `DeleteUserId` bigint(0) NULL DEFAULT NULL COMMENT '删除人ID编号',

  `LastModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '最后修改时间',

  `LastModifyUserId` bigint(0) NULL DEFAULT NULL COMMENT '最后修改人ID编号',

  `IsDelete` tinyint(0) NULL DEFAULT NULL COMMENT '删除标识 0：未删除 1：已删除',

  PRIMARY KEY (`Id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of sysloglogin

-- ----------------------------

INSERT INTO `sysloglogin` VALUES (318313891148861440, '2021-05-28 09:05:46', NULL, 1, '192.168.10.12', '', 'Chrome 89.0.4389.72', 'Windows 10', '登录成功', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.72 Safari/537.36 Edg/89.0.774.45', 0, NULL, NULL, '2021-05-28 09:05:46', 0, 0);

INSERT INTO `sysloglogin` VALUES (319504130412384256, '2021-05-31 15:55:21', NULL, 1, '192.168.10.12', '', 'Chrome 89.0.4389.72', 'Windows 10', '登录成功', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.72 Safari/537.36 Edg/89.0.774.45', 0, NULL, NULL, '2021-05-31 15:55:21', 0, 0);



-- ----------------------------

-- Table structure for sysmenu

-- ----------------------------

DROP TABLE IF EXISTS `sysmenu`;

CREATE TABLE `sysmenu`  (

  `Id` bigint(0) NOT NULL,

  `ParentId` bigint(0) NULL DEFAULT NULL COMMENT '父菜单Id(0表示是根菜单)',

  `MenuName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '菜单名称',

  `MenuIcon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '菜单图标',

  `MenuUrl` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '菜单Url',

  `MenuTarget` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '链接打开方式',

  `MenuSort` int(0) NULL DEFAULT NULL COMMENT '菜单排序',

  `MenuType` int(0) NULL DEFAULT NULL COMMENT '菜单类型(1目录 2页面 3按钮)',

  `MenuStatus` int(0) NULL DEFAULT NULL COMMENT '菜单状态(0禁用 1启用)',

  `Authorize` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '菜单权限标识',

  `Remark` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',

  `CreateUserId` bigint(0) NULL DEFAULT NULL COMMENT '创建人ID编号',

  `DeleteTime` datetime(0) NULL DEFAULT NULL COMMENT '删除时间',

  `DeleteUserId` bigint(0) NULL DEFAULT NULL COMMENT '删除人ID编号',

  `LastModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '最后修改时间',

  `LastModifyUserId` bigint(0) NULL DEFAULT NULL COMMENT '最后修改人ID编号',

  `IsDelete` tinyint(0) NULL DEFAULT NULL,

  `CreateTime` datetime(0) NULL DEFAULT NULL,

  PRIMARY KEY (`Id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of sysmenu

-- ----------------------------

INSERT INTO `sysmenu` VALUES (16508640061130069, 0, '单位组织', 'layui-icon layui-icon-user', '', '', 100, 1, 1, '', '', NULL, NULL, NULL, '2021-04-12 14:22:56', 16508640061130151, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130070, 0, '系统管理', 'layui-icon layui-icon-set', '', '', 101, 1, 1, '', '', NULL, NULL, NULL, '2021-04-12 14:23:02', 16508640061130151, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130071, 0, '系统工具', 'layui-icon layui-icon-util', '', '', 102, 1, 1, '', '', NULL, NULL, NULL, '2021-04-12 14:23:07', 16508640061130151, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130072, 16508640061130069, '员工管理', 'layui-icon layui-icon-set', '#/organization/user/userIndex', '', 1, 2, 1, 'organization:user:view', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130073, 16508640061130069, '部门管理', '', '#/organization/department/departmentIndex', '', 2, 2, 1, 'organization:department:view', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130074, 16508640061130070, '系统角色', 'layui-icon ', '#/system/role/roleIndex', '', 1, 2, 1, 'system:role:view', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130075, 16508640061130070, '系统菜单', 'layui-icon ', '#/system/menu/menuIndex', '', 2, 2, 1, 'system:menu:view', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130076, 16508640061130070, '系统日志', 'layui-icon layui-icon-align-left', NULL, '', 10, 1, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130077, 16508640061130070, '通用字典', NULL, '#/system/datadict/datadictIndex', '', 5, 2, 1, 'system:datadict:view', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130079, 16508640061130070, '数据表管理', NULL, '#/system/database/databaseIndex', '', 14, 2, 1, 'system:datatable:view', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130080, 16508640061130071, '代码生成', '', '#/tool/codeGenerator/codeGeneratorIndex', '', 1, 2, 1, 'tool:codegenerator:view', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130082, 16508640061130076, '登录日志', NULL, '#/system/logLogin/logLoginIndex', '', 1, 2, 1, 'system:loglogin:view', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130083, 16508640061130069, '职位管理', '', '#/organization/position/positionIndex', '', 3, 2, 1, 'organization:position:view', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130084, 16508640061130072, '员工查询', '', '', '', 1, 3, 1, 'organization:user:search', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130085, 16508640061130072, '员工新增', '', '', '', 2, 3, 1, 'organization:user:add', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130086, 16508640061130072, '员工修改', '', '', '', 3, 3, 2, 'organization:user:edit', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130087, 16508640061130072, '员工删除', '', '', '', 4, 3, 1, 'organization:user:delete', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130088, 16508640061130072, '员工导出', '', '', '', 5, 3, 1, 'organization:user:export', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130089, 16508640061130072, '重置密码', '', '', '', 6, 3, 1, 'system:user:resetpassword', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130090, 16508640061130073, '部门查询', '', '', '', 1, 3, 1, 'organization:department:search', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130091, 16508640061130073, '部门新增', '', '', '', 2, 3, 1, 'organization:department:add', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130092, 16508640061130073, '部门修改', '', '', '', 3, 3, 1, 'organization:department:edit', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130093, 16508640061130073, '部门删除', '', '', '', 4, 3, 1, 'organization:department:delete', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130094, 16508640061130083, '职位查询', '', '', '', 1, 3, 1, 'organization:position:search', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130095, 16508640061130083, '职位新增', '', '', '', 2, 3, 1, 'organization:position:add', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130096, 16508640061130083, '职位修改', '', '', '', 3, 3, 1, 'organization:position:edit', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130097, 16508640061130083, '职位删除', '', '', '', 4, 3, 1, 'organization:position:delete', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130098, 16508640061130074, '角色查询', '', '', '', 1, 3, 1, 'system:role:search', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130099, 16508640061130074, '角色新增', '', '', '', 2, 3, 1, 'system:role:add', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130100, 16508640061130074, '角色修改', '', '', '', 3, 3, 1, 'system:role:edit', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130101, 16508640061130074, '角色删除', '', '', '', 4, 3, 1, 'system:role:delete', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130102, 16508640061130075, '菜单查询', '', '', '', 1, 3, 1, 'system:menu:search', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130103, 16508640061130075, '菜单新增', '', '', '', 2, 3, 1, 'system:menu:add', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130104, 16508640061130075, '菜单修改', '', '', '', 3, 3, 1, 'system:menu:edit', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130105, 16508640061130075, '菜单删除', '', '', '', 4, 3, 1, 'system:menu:delete', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130106, 16508640061130077, '字典查询', '', '', '', 1, 3, 1, 'system:datadict:search', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130107, 16508640061130077, '字典新增', '', '', '', 2, 3, 1, 'system:datadict:add', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130108, 16508640061130077, '字典修改', '', '', '', 3, 3, 1, 'system:datadict:edit', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130109, 16508640061130077, '字典删除', '', '', '', 4, 3, 1, 'system:datadict:delete', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130114, 16508640061130082, '登录日志查询', '', '', '', 1, 3, 1, 'system:loglogin:search', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130115, 16508640061130082, '登录日志删除', '', '', '', 2, 3, 1, 'system:loglogin:delete', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130118, 16508640061130079, '数据表查询', '', '', '', 1, 3, 1, 'system:datatable:search', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130119, 16508640061130080, '代码生成新增', '', '', '', 2, 3, 1, 'tool:codegenerator:add', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130120, 16508640061130080, '代码生成查询', '', '', '', 1, 3, 1, 'tool:codegenerator:search', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130121, 16508640061130071, '服务器信息', NULL, '#/tool/server/serverIndex', '', 15, 2, 1, 'tool:server:view', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130122, 16508640061130070, '定时任务', NULL, '#/system/autoJob/autoJobIndex', '', 12, 2, 1, 'system:autojob:view', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130123, 16508640061130122, '定时任务查询', '', '', '', 1, 3, 1, 'system:autojob:search', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130124, 16508640061130122, '定时任务新增', '', '', '', 2, 3, 1, 'system:autojob:add', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130125, 16508640061130122, '定时任务修改', '', '', '', 3, 3, 1, 'system:autojob:edit', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130126, 16508640061130122, '定时任务删除', '', '', '', 4, 3, 1, 'system:autojob:delete', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130127, 16508640061130122, '定时任务暂停', '', '', '', 5, 3, 1, 'system:autojob:pause', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130128, 16508640061130122, '定时任务日志查看', '', '', '', 6, 3, 1, 'system:autojob:logview', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130134, 16508640061130070, '系统api', 'layui-icon ', '#/api', '', 13, 2, 1, 'system:api:view', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130135, 16508640061130076, 'Api日志', NULL, '#/system/logApi/logApiIndex', '', 3, 2, 1, 'system:logapi:view', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130136, 16508640061130135, 'Api日志查询', '', '', '', 1, 3, 1, 'system:logapi:search', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (16508640061130137, 16508640061130135, 'Api日志删除', '', '', '', 2, 3, 1, 'system:logapi:delete', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (260867164880244736, 16508640061130070, '缓存管理', NULL, '#/system/cache/cacheIndex', NULL, 14, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (261771075572994048, 16508640061130070, 'MQTT主题订阅', NULL, '#/system/mqttTheme/mqttThemeIndex', NULL, 16, 2, 1, 'system:mqtttheme:view', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (261771076357328896, 261771075572994048, 'MQTT主题订阅搜索', NULL, NULL, NULL, 17, 3, 1, 'system:mqtttheme:search', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (261771077133275136, 261771075572994048, 'MQTT主题订阅新增', NULL, NULL, NULL, 18, 3, 1, 'system:mqtttheme:add', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (261771077850501120, 261771075572994048, 'MQTT主题订阅修改', NULL, NULL, NULL, 19, 3, 1, 'system:mqtttheme:edit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenu` VALUES (261771078534172672, 261771075572994048, 'MQTT主题订阅删除', NULL, NULL, NULL, 20, 3, 1, 'system:mqtttheme:delete', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);



-- ----------------------------

-- Table structure for sysmenuauthorize

-- ----------------------------

DROP TABLE IF EXISTS `sysmenuauthorize`;

CREATE TABLE `sysmenuauthorize`  (

  `Id` bigint(0) NOT NULL,

  `CreateTime` datetime(0) NOT NULL,

  `CreatorId` bigint(0) NOT NULL,

  `MenuId` bigint(0) NOT NULL COMMENT '菜单Id',

  `AuthorizeId` bigint(0) NOT NULL COMMENT '授权Id(角色Id或者用户Id)',

  `AuthorizeType` int(0) NOT NULL COMMENT '授权类型(1角色 2用户)',

  `CreateUserId` bigint(0) NULL DEFAULT NULL COMMENT '创建人ID编号',

  `DeleteTime` datetime(0) NULL DEFAULT NULL COMMENT '删除时间',

  `DeleteUserId` bigint(0) NULL DEFAULT NULL COMMENT '删除人ID编号',

  `LastModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '最后修改时间',

  `LastModifyUserId` bigint(0) NULL DEFAULT NULL COMMENT '最后修改人ID编号',

  `IsDelete` tinyint(0) NULL DEFAULT NULL,

  PRIMARY KEY (`Id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of sysmenuauthorize

-- ----------------------------

INSERT INTO `sysmenuauthorize` VALUES (46081509060382720, '2020-12-06 11:51:28', 16508640061130151, 16508640061130069, 253512862180315136, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (46081509404315648, '2020-12-06 11:51:28', 16508640061130151, 16508640061130072, 253512862180315136, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (46081509710499840, '2020-12-06 11:51:28', 16508640061130151, 16508640061130084, 253512862180315136, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (46081510016684032, '2020-12-06 11:51:28', 16508640061130151, 16508640061130085, 253512862180315136, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (46081510314479616, '2020-12-06 11:51:28', 16508640061130151, 16508640061130086, 253512862180315136, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (46081510620663808, '2020-12-06 11:51:28', 16508640061130151, 16508640061130087, 253512862180315136, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (46081510918459392, '2020-12-06 11:51:28', 16508640061130151, 16508640061130088, 253512862180315136, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (46081511224643584, '2020-12-06 11:51:28', 16508640061130151, 16508640061130089, 253512862180315136, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (46081511535022080, '2020-12-06 11:51:29', 16508640061130151, 16508640061130073, 253512862180315136, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (46081511837011968, '2020-12-06 11:51:29', 16508640061130151, 16508640061130090, 253512862180315136, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (46081512143196160, '2020-12-06 11:51:29', 16508640061130151, 16508640061130091, 253512862180315136, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (46081512453574656, '2020-12-06 11:51:29', 16508640061130151, 16508640061130092, 253512862180315136, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (46081512755564544, '2020-12-06 11:51:29', 16508640061130151, 16508640061130093, 253512862180315136, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (46081513057554432, '2020-12-06 11:51:29', 16508640061130151, 16508640061130083, 253512862180315136, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (46081513359544320, '2020-12-06 11:51:29', 16508640061130151, 16508640061130094, 253512862180315136, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (46081513665728512, '2020-12-06 11:51:29', 16508640061130151, 16508640061130095, 253512862180315136, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (46081513967718400, '2020-12-06 11:51:29', 16508640061130151, 16508640061130096, 253512862180315136, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (46081514273902592, '2020-12-06 11:51:29', 16508640061130151, 16508640061130097, 253512862180315136, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (46123151389757440, '2020-12-06 14:36:56', 16508640061130151, 16508640061130069, 16508640061130147, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (46123151687553024, '2020-12-06 14:36:56', 16508640061130151, 16508640061130072, 16508640061130147, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (46123151972765696, '2020-12-06 14:36:56', 16508640061130151, 16508640061130084, 16508640061130147, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (46123152245395456, '2020-12-06 14:36:56', 16508640061130151, 16508640061130085, 16508640061130147, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (46123152513830912, '2020-12-06 14:36:56', 16508640061130151, 16508640061130086, 16508640061130147, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (46123152786460672, '2020-12-06 14:36:57', 16508640061130151, 16508640061130070, 16508640061130147, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (46123153059090432, '2020-12-06 14:36:57', 16508640061130151, 16508640061130076, 16508640061130147, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (46123153327525888, '2020-12-06 14:36:57', 16508640061130151, 16508640061130135, 16508640061130147, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (46123153591767040, '2020-12-06 14:36:57', 16508640061130151, 16508640061130136, 16508640061130147, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (46123153868591104, '2020-12-06 14:36:57', 16508640061130151, 16508640061130137, 16508640061130147, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (103195241783234560, '2019-03-01 06:54:31', 16508640061130151, 16508640061130069, 103195209390624768, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (103195241787428864, '2019-03-01 06:54:31', 16508640061130151, 16508640061130072, 103195209390624768, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (103195241791623168, '2019-03-01 06:54:31', 16508640061130151, 16508640061130084, 103195209390624768, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (103195241800011776, '2019-03-01 06:54:31', 16508640061130151, 16508640061130085, 103195209390624768, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (103195241804206080, '2019-03-01 06:54:31', 16508640061130151, 16508640061130086, 103195209390624768, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (103195241808400384, '2019-03-01 06:54:31', 16508640061130151, 16508640061130087, 103195209390624768, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (103195241812594688, '2019-03-01 06:54:31', 16508640061130151, 16508640061130088, 103195209390624768, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (103195241820983296, '2019-03-01 06:54:31', 16508640061130151, 16508640061130089, 103195209390624768, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (103195241825177600, '2019-03-01 06:54:31', 16508640061130151, 16508640061130073, 103195209390624768, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (103195241829371904, '2019-03-01 06:54:31', 16508640061130151, 16508640061130090, 103195209390624768, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (103195241837760512, '2019-03-01 06:54:31', 16508640061130151, 16508640061130091, 103195209390624768, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (103195241841954816, '2019-03-01 06:54:31', 16508640061130151, 16508640061130092, 103195209390624768, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (103195241850343424, '2019-03-01 06:54:31', 16508640061130151, 16508640061130093, 103195209390624768, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (103195241854537728, '2019-03-01 06:54:31', 16508640061130151, 16508640061130083, 103195209390624768, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (103195241862926336, '2019-03-01 06:54:31', 16508640061130151, 16508640061130094, 103195209390624768, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (103195241871314944, '2019-03-01 06:54:31', 16508640061130151, 16508640061130095, 103195209390624768, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (103195241875509248, '2019-03-01 06:54:31', 16508640061130151, 16508640061130096, 103195209390624768, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (103195241883897856, '2019-03-01 06:54:31', 16508640061130151, 16508640061130097, 103195209390624768, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (103195241892286464, '2019-03-01 06:54:31', 16508640061130151, 16508640061130129, 103195209390624768, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (103195241900675072, '2019-03-01 06:54:31', 16508640061130151, 16508640061130130, 103195209390624768, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (103195241909063680, '2019-03-01 06:54:31', 16508640061130151, 16508640061130131, 103195209390624768, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (103195241913257984, '2019-03-01 06:54:31', 16508640061130151, 16508640061130132, 103195209390624768, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (103195241921646592, '2019-03-01 06:54:31', 16508640061130151, 16508640061130133, 103195209390624768, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092413965762560, '2020-11-26 15:25:15', 0, 16508640061130069, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092414716542976, '2020-11-26 15:25:15', 0, 16508640061130072, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092414955618304, '2020-11-26 15:25:15', 0, 16508640061130084, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092415169527808, '2020-11-26 15:25:15', 0, 16508640061130085, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092415383437312, '2020-11-26 15:25:15', 0, 16508640061130086, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092415593152512, '2020-11-26 15:25:16', 0, 16508640061130087, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092415798673408, '2020-11-26 15:25:16', 0, 16508640061130088, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092416008388608, '2020-11-26 15:25:16', 0, 16508640061130089, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092416222298112, '2020-11-26 15:25:16', 0, 16508640061130073, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092416427819008, '2020-11-26 15:25:16', 0, 16508640061130090, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092416629145600, '2020-11-26 15:25:16', 0, 16508640061130091, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092416834666496, '2020-11-26 15:25:16', 0, 16508640061130092, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092417044381696, '2020-11-26 15:25:16', 0, 16508640061130093, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092417249902592, '2020-11-26 15:25:16', 0, 16508640061130083, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092417455423488, '2020-11-26 15:25:16', 0, 16508640061130094, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092417669332992, '2020-11-26 15:25:16', 0, 16508640061130095, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092417874853888, '2020-11-26 15:25:16', 0, 16508640061130096, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092418088763392, '2020-11-26 15:25:16', 0, 16508640061130097, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092418294284288, '2020-11-26 15:25:16', 0, 16508640061130070, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092418503999488, '2020-11-26 15:25:16', 0, 16508640061130074, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092418722103296, '2020-11-26 15:25:16', 0, 16508640061130098, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092418927624192, '2020-11-26 15:25:16', 0, 16508640061130099, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092419133145088, '2020-11-26 15:25:16', 0, 16508640061130100, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092419351248896, '2020-11-26 15:25:16', 0, 16508640061130101, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092419569352704, '2020-11-26 15:25:16', 0, 16508640061130075, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092419783262208, '2020-11-26 15:25:17', 0, 16508640061130102, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092419992977408, '2020-11-26 15:25:17', 0, 16508640061130103, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092420219469824, '2020-11-26 15:25:17', 0, 16508640061130104, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092420500488192, '2020-11-26 15:25:17', 0, 16508640061130105, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092420714397696, '2020-11-26 15:25:17', 0, 16508640061130076, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092420919918592, '2020-11-26 15:25:17', 0, 16508640061130082, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092421125439488, '2020-11-26 15:25:17', 0, 16508640061130114, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092421326766080, '2020-11-26 15:25:17', 0, 16508640061130115, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092421528092672, '2020-11-26 15:25:17', 0, 16508640061130135, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092421729419264, '2020-11-26 15:25:17', 0, 16508640061130136, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092421939134464, '2020-11-26 15:25:17', 0, 16508640061130137, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092422144655360, '2020-11-26 15:25:17', 0, 16508640061130077, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092422350176256, '2020-11-26 15:25:17', 0, 16508640061130106, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092422551502848, '2020-11-26 15:25:17', 0, 16508640061130107, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092422761218048, '2020-11-26 15:25:17', 0, 16508640061130108, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092422962544640, '2020-11-26 15:25:17', 0, 16508640061130109, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092423163871232, '2020-11-26 15:25:17', 0, 16508640061130078, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092423365197824, '2020-11-26 15:25:17', 0, 16508640061130110, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092423566524416, '2020-11-26 15:25:17', 0, 16508640061130111, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092423772045312, '2020-11-26 15:25:17', 0, 16508640061130112, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092423977566208, '2020-11-26 15:25:18', 0, 16508640061130113, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092424183087104, '2020-11-26 15:25:18', 0, 16508640061130079, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092424388608000, '2020-11-26 15:25:18', 0, 16508640061130118, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092424606711808, '2020-11-26 15:25:18', 0, 16508640061130122, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092424829009920, '2020-11-26 15:25:18', 0, 16508640061130123, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092425038725120, '2020-11-26 15:25:18', 0, 16508640061130124, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092425252634624, '2020-11-26 15:25:18', 0, 16508640061130125, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092425458155520, '2020-11-26 15:25:18', 0, 16508640061130126, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092425655287808, '2020-11-26 15:25:18', 0, 16508640061130127, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092425860808704, '2020-11-26 15:25:18', 0, 16508640061130128, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092426062135296, '2020-11-26 15:25:18', 0, 16508640061130134, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092426276044800, '2020-11-26 15:25:18', 0, 16508640061130071, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092426485760000, '2020-11-26 15:25:18', 0, 16508640061130080, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092426695475200, '2020-11-26 15:25:18', 0, 16508640061130119, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092426900996096, '2020-11-26 15:25:18', 0, 16508640061130120, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092427106516992, '2020-11-26 15:25:18', 0, 16508640061130121, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092427307843584, '2020-11-26 15:25:18', 0, 16508640061131999, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092427513364480, '2020-11-26 15:25:18', 0, 16508640061132000, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (252092427727273984, '2020-11-26 15:25:18', 0, 16508640061132001, 16508640061130146, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (258565056382373888, '2020-12-14 12:05:13', 16508640061130151, 16508640061130069, 258201886530736128, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (258565056466259968, '2020-12-14 12:05:13', 16508640061130151, 16508640061130072, 258201886530736128, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (258565056483037184, '2020-12-14 12:05:13', 16508640061130151, 16508640061130087, 258201886530736128, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (258565056491425792, '2020-12-14 12:05:13', 16508640061130151, 16508640061130088, 258201886530736128, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (286975114459746304, '2021-03-02 21:36:39', 16508640061130151, 16508640061130069, 286619174082449408, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (286975114522660864, '2021-03-02 21:36:39', 16508640061130151, 16508640061130072, 286619174082449408, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (286975114535243776, '2021-03-02 21:36:39', 16508640061130151, 16508640061130084, 286619174082449408, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (286975114552020992, '2021-03-02 21:36:39', 16508640061130151, 16508640061130085, 286619174082449408, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (286975114568798208, '2021-03-02 21:36:39', 16508640061130151, 16508640061130086, 286619174082449408, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (286975114581381120, '2021-03-02 21:36:39', 16508640061130151, 16508640061130087, 286619174082449408, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (286975114598158336, '2021-03-02 21:36:39', 16508640061130151, 16508640061130088, 286619174082449408, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (286975114610741248, '2021-03-02 21:36:39', 16508640061130151, 16508640061130089, 286619174082449408, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (286975114627518464, '2021-03-02 21:36:39', 16508640061130151, 16508640061130073, 286619174082449408, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (286975114640101376, '2021-03-02 21:36:39', 16508640061130151, 16508640061130090, 286619174082449408, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (286975114652684288, '2021-03-02 21:36:39', 16508640061130151, 16508640061130091, 286619174082449408, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (286975114669461504, '2021-03-02 21:36:39', 16508640061130151, 16508640061130092, 286619174082449408, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (286975114686238720, '2021-03-02 21:36:39', 16508640061130151, 16508640061130093, 286619174082449408, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (286975114703015936, '2021-03-02 21:36:39', 16508640061130151, 16508640061130083, 286619174082449408, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (286975114715598848, '2021-03-02 21:36:39', 16508640061130151, 16508640061130094, 286619174082449408, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (286975114732376064, '2021-03-02 21:36:39', 16508640061130151, 16508640061130095, 286619174082449408, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (286975114744958976, '2021-03-02 21:36:39', 16508640061130151, 16508640061130096, 286619174082449408, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (286975114761736192, '2021-03-02 21:36:39', 16508640061130151, 16508640061130097, 286619174082449408, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (286975114778513408, '2021-03-02 21:36:39', 16508640061130151, 286447559788990464, 286619174082449408, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872531423232, '2021-03-10 08:56:19', 16508640061130151, 16508640061130069, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872548200448, '2021-03-10 08:56:19', 16508640061130151, 16508640061130072, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872560783360, '2021-03-10 08:56:19', 16508640061130151, 16508640061130084, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872573366272, '2021-03-10 08:56:19', 16508640061130151, 16508640061130085, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872585949184, '2021-03-10 08:56:19', 16508640061130151, 16508640061130086, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872598532096, '2021-03-10 08:56:19', 16508640061130151, 16508640061130088, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872611115008, '2021-03-10 08:56:19', 16508640061130151, 16508640061130089, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872623697920, '2021-03-10 08:56:19', 16508640061130151, 16508640061130073, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872636280832, '2021-03-10 08:56:19', 16508640061130151, 16508640061130090, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872648863744, '2021-03-10 08:56:19', 16508640061130151, 16508640061130091, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872661446656, '2021-03-10 08:56:19', 16508640061130151, 16508640061130092, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872674029568, '2021-03-10 08:56:19', 16508640061130151, 16508640061130093, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872686612480, '2021-03-10 08:56:19', 16508640061130151, 16508640061130083, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872699195392, '2021-03-10 08:56:19', 16508640061130151, 16508640061130094, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872711778304, '2021-03-10 08:56:19', 16508640061130151, 16508640061130095, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872724361216, '2021-03-10 08:56:19', 16508640061130151, 16508640061130096, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872736944128, '2021-03-10 08:56:19', 16508640061130151, 16508640061130097, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872749527040, '2021-03-10 08:56:19', 16508640061130151, 16508640061130070, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872762109952, '2021-03-10 08:56:19', 16508640061130151, 16508640061130074, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872778887168, '2021-03-10 08:56:19', 16508640061130151, 16508640061130098, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872791470080, '2021-03-10 08:56:19', 16508640061130151, 16508640061130099, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872804052992, '2021-03-10 08:56:19', 16508640061130151, 16508640061130100, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872816635904, '2021-03-10 08:56:19', 16508640061130151, 16508640061130101, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872829218816, '2021-03-10 08:56:19', 16508640061130151, 16508640061130075, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872845996032, '2021-03-10 08:56:19', 16508640061130151, 16508640061130102, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872858578944, '2021-03-10 08:56:19', 16508640061130151, 16508640061130103, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872871161856, '2021-03-10 08:56:19', 16508640061130151, 16508640061130104, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872887939072, '2021-03-10 08:56:19', 16508640061130151, 16508640061130105, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872900521984, '2021-03-10 08:56:19', 16508640061130151, 16508640061130076, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872913104896, '2021-03-10 08:56:19', 16508640061130151, 16508640061130082, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872934076416, '2021-03-10 08:56:19', 16508640061130151, 16508640061130114, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872946659328, '2021-03-10 08:56:19', 16508640061130151, 16508640061130115, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872959242240, '2021-03-10 08:56:19', 16508640061130151, 16508640061130135, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872976019456, '2021-03-10 08:56:19', 16508640061130151, 16508640061130136, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682872988602368, '2021-03-10 08:56:19', 16508640061130151, 16508640061130137, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682873005379584, '2021-03-10 08:56:19', 16508640061130151, 16508640061130077, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682873017962496, '2021-03-10 08:56:19', 16508640061130151, 16508640061130106, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682873034739712, '2021-03-10 08:56:19', 16508640061130151, 16508640061130107, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682873047322624, '2021-03-10 08:56:19', 16508640061130151, 16508640061130108, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682873064099840, '2021-03-10 08:56:19', 16508640061130151, 16508640061130109, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682873080877056, '2021-03-10 08:56:19', 16508640061130151, 16508640061130078, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682873093459968, '2021-03-10 08:56:19', 16508640061130151, 16508640061130110, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682873110237184, '2021-03-10 08:56:19', 16508640061130151, 16508640061130111, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682873122820096, '2021-03-10 08:56:19', 16508640061130151, 16508640061130112, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682873139597312, '2021-03-10 08:56:19', 16508640061130151, 16508640061130113, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682873156374528, '2021-03-10 08:56:19', 16508640061130151, 16508640061130079, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682873168957440, '2021-03-10 08:56:19', 16508640061130151, 16508640061130118, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682873185734656, '2021-03-10 08:56:19', 16508640061130151, 16508640061130122, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682873890377728, '2021-03-10 08:56:19', 16508640061130151, 16508640061130123, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682874037178368, '2021-03-10 08:56:19', 16508640061130151, 16508640061130124, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682874192367616, '2021-03-10 08:56:19', 16508640061130151, 16508640061130125, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682874326585344, '2021-03-10 08:56:19', 16508640061130151, 16508640061130126, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682874410471424, '2021-03-10 08:56:19', 16508640061130151, 16508640061130127, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682874464997376, '2021-03-10 08:56:19', 16508640061130151, 16508640061130128, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682874553077760, '2021-03-10 08:56:19', 16508640061130151, 16508640061130134, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682875299663872, '2021-03-10 08:56:20', 16508640061130151, 260867164880244736, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682875467436032, '2021-03-10 08:56:20', 16508640061130151, 261771075572994048, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682875551322112, '2021-03-10 08:56:20', 16508640061130151, 261771076357328896, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682875622625280, '2021-03-10 08:56:20', 16508640061130151, 261771077133275136, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682876423737344, '2021-03-10 08:56:20', 16508640061130151, 261771077850501120, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682876549566464, '2021-03-10 08:56:20', 16508640061130151, 261771078534172672, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682876616675328, '2021-03-10 08:56:20', 16508640061130151, 16508640061130071, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682876637646848, '2021-03-10 08:56:20', 16508640061130151, 16508640061130080, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682876658618368, '2021-03-10 08:56:20', 16508640061130151, 16508640061130119, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682876679589888, '2021-03-10 08:56:20', 16508640061130151, 16508640061130120, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682876700561408, '2021-03-10 08:56:20', 16508640061130151, 16508640061130121, 277766285150916608, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682888981483520, '2021-03-10 08:56:23', 16508640061130151, 16508640061130069, 287185473351192576, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682888998260736, '2021-03-10 08:56:23', 16508640061130151, 16508640061130072, 287185473351192576, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682889010843648, '2021-03-10 08:56:23', 16508640061130151, 16508640061130084, 287185473351192576, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682889027620864, '2021-03-10 08:56:23', 16508640061130151, 16508640061130085, 287185473351192576, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682889040203776, '2021-03-10 08:56:23', 16508640061130151, 16508640061130086, 287185473351192576, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682889056980992, '2021-03-10 08:56:23', 16508640061130151, 16508640061130088, 287185473351192576, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682889069563904, '2021-03-10 08:56:23', 16508640061130151, 16508640061130089, 287185473351192576, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682889086341120, '2021-03-10 08:56:23', 16508640061130151, 16508640061130073, 287185473351192576, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682889098924032, '2021-03-10 08:56:23', 16508640061130151, 16508640061130090, 287185473351192576, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682889115701248, '2021-03-10 08:56:23', 16508640061130151, 16508640061130091, 287185473351192576, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682889128284160, '2021-03-10 08:56:23', 16508640061130151, 16508640061130092, 287185473351192576, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682889145061376, '2021-03-10 08:56:23', 16508640061130151, 16508640061130093, 287185473351192576, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682889157644288, '2021-03-10 08:56:23', 16508640061130151, 16508640061130083, 287185473351192576, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682889174421504, '2021-03-10 08:56:23', 16508640061130151, 16508640061130094, 287185473351192576, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682889191198720, '2021-03-10 08:56:23', 16508640061130151, 16508640061130095, 287185473351192576, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682889207975936, '2021-03-10 08:56:23', 16508640061130151, 16508640061130096, 287185473351192576, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682889220558848, '2021-03-10 08:56:23', 16508640061130151, 16508640061130097, 287185473351192576, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682889237336064, '2021-03-10 08:56:23', 16508640061130151, 16508640061130070, 287185473351192576, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682889249918976, '2021-03-10 08:56:23', 16508640061130151, 16508640061130076, 287185473351192576, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682889266696192, '2021-03-10 08:56:23', 16508640061130151, 16508640061130082, 287185473351192576, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682889283473408, '2021-03-10 08:56:23', 16508640061130151, 16508640061130114, 287185473351192576, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682889296056320, '2021-03-10 08:56:23', 16508640061130151, 16508640061130115, 287185473351192576, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682889312833536, '2021-03-10 08:56:23', 16508640061130151, 16508640061130135, 287185473351192576, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682889325416448, '2021-03-10 08:56:23', 16508640061130151, 16508640061130136, 287185473351192576, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (289682889342193664, '2021-03-10 08:56:23', 16508640061130151, 16508640061130137, 287185473351192576, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (290558951165005824, '2021-03-12 18:57:32', 16508640061130151, 16508640061130069, 289429554030710784, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (290558951248891904, '2021-03-12 18:57:32', 16508640061130151, 16508640061130072, 289429554030710784, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (290558951265669120, '2021-03-12 18:57:32', 16508640061130151, 16508640061130086, 289429554030710784, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (290558951282446336, '2021-03-12 18:57:32', 16508640061130151, 16508640061130070, 289429554030710784, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (290558951295029248, '2021-03-12 18:57:32', 16508640061130151, 16508640061130074, 289429554030710784, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (290558951307612160, '2021-03-12 18:57:32', 16508640061130151, 16508640061130100, 289429554030710784, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (293899490996260864, '2021-03-22 00:11:39', 16508640061130151, 16508640061130069, 292826047173365760, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (293899491013038080, '2021-03-22 00:11:39', 16508640061130151, 16508640061130072, 292826047173365760, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (293899491029815296, '2021-03-22 00:11:39', 16508640061130151, 16508640061130084, 292826047173365760, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (293899491042398208, '2021-03-22 00:11:39', 16508640061130151, 16508640061130085, 292826047173365760, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (293899491054981120, '2021-03-22 00:11:39', 16508640061130151, 16508640061130086, 292826047173365760, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (293899491067564032, '2021-03-22 00:11:39', 16508640061130151, 16508640061130087, 292826047173365760, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (293899491080146944, '2021-03-22 00:11:39', 16508640061130151, 16508640061130088, 292826047173365760, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (293899491096924160, '2021-03-22 00:11:39', 16508640061130151, 16508640061130089, 292826047173365760, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (293899491109507072, '2021-03-22 00:11:39', 16508640061130151, 16508640061130073, 292826047173365760, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (293899491122089984, '2021-03-22 00:11:39', 16508640061130151, 16508640061130090, 292826047173365760, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (293899491151450112, '2021-03-22 00:11:39', 16508640061130151, 16508640061130091, 292826047173365760, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (293899491164033024, '2021-03-22 00:11:39', 16508640061130151, 16508640061130092, 292826047173365760, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (293899491176615936, '2021-03-22 00:11:39', 16508640061130151, 16508640061130093, 292826047173365760, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (293899491193393152, '2021-03-22 00:11:39', 16508640061130151, 16508640061130083, 292826047173365760, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (293899491205976064, '2021-03-22 00:11:39', 16508640061130151, 16508640061130094, 292826047173365760, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (293899491277279232, '2021-03-22 00:11:39', 16508640061130151, 16508640061130095, 292826047173365760, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (293899491298250752, '2021-03-22 00:11:39', 16508640061130151, 16508640061130096, 292826047173365760, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (293899491310833664, '2021-03-22 00:11:39', 16508640061130151, 16508640061130097, 292826047173365760, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (295136574889267200, '2021-03-25 10:07:23', 16508640061130151, 16508640061130069, 289712787762974720, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (295136575036067840, '2021-03-25 10:07:23', 16508640061130151, 16508640061130072, 289712787762974720, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (295136575065427968, '2021-03-25 10:07:23', 16508640061130151, 16508640061130084, 289712787762974720, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (295136575090593792, '2021-03-25 10:07:23', 16508640061130151, 16508640061130086, 289712787762974720, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (295136575119953920, '2021-03-25 10:07:23', 16508640061130151, 16508640061130088, 289712787762974720, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296695508938788864, '2021-03-29 17:22:02', 16508640061130151, 16508640061130069, 296691626556788736, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296695508963954688, '2021-03-29 17:22:02', 16508640061130151, 16508640061130072, 296691626556788736, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296695508993314816, '2021-03-29 17:22:02', 16508640061130151, 16508640061130084, 296691626556788736, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296695509018480640, '2021-03-29 17:22:02', 16508640061130151, 16508640061130070, 296691626556788736, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296695509047840768, '2021-03-29 17:22:02', 16508640061130151, 16508640061130075, 296691626556788736, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296695509073006592, '2021-03-29 17:22:02', 16508640061130151, 16508640061130103, 296691626556788736, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296695509102366720, '2021-03-29 17:22:02', 16508640061130151, 16508640061130104, 296691626556788736, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993867108978688, '2021-03-30 13:07:36', 16508640061130151, 16508640061130069, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993867255779328, '2021-03-30 13:07:36', 16508640061130151, 16508640061130072, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993867402579968, '2021-03-30 13:07:36', 16508640061130151, 16508640061130084, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993867553574912, '2021-03-30 13:07:36', 16508640061130151, 16508640061130085, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993867704569856, '2021-03-30 13:07:36', 16508640061130151, 16508640061130086, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993867855564800, '2021-03-30 13:07:36', 16508640061130151, 16508640061130088, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993868010754048, '2021-03-30 13:07:36', 16508640061130151, 16508640061130089, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993868161748992, '2021-03-30 13:07:36', 16508640061130151, 16508640061130073, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993868316938240, '2021-03-30 13:07:36', 16508640061130151, 16508640061130090, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993868467933184, '2021-03-30 13:07:36', 16508640061130151, 16508640061130091, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993868618928128, '2021-03-30 13:07:36', 16508640061130151, 16508640061130092, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993868774117376, '2021-03-30 13:07:36', 16508640061130151, 16508640061130093, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993868920918016, '2021-03-30 13:07:36', 16508640061130151, 16508640061130083, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993869071912960, '2021-03-30 13:07:36', 16508640061130151, 16508640061130094, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993869227102208, '2021-03-30 13:07:36', 16508640061130151, 16508640061130095, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993869378097152, '2021-03-30 13:07:36', 16508640061130151, 16508640061130096, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993869533286400, '2021-03-30 13:07:36', 16508640061130151, 16508640061130097, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993869684281344, '2021-03-30 13:07:36', 16508640061130151, 16508640061130070, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993869839470592, '2021-03-30 13:07:36', 16508640061130151, 16508640061130074, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993869986271232, '2021-03-30 13:07:36', 16508640061130151, 16508640061130098, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993870133071872, '2021-03-30 13:07:37', 16508640061130151, 16508640061130099, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993870279872512, '2021-03-30 13:07:37', 16508640061130151, 16508640061130100, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993870430867456, '2021-03-30 13:07:37', 16508640061130151, 16508640061130101, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993870581862400, '2021-03-30 13:07:37', 16508640061130151, 16508640061130075, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993870737051648, '2021-03-30 13:07:37', 16508640061130151, 16508640061130102, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993870888046592, '2021-03-30 13:07:37', 16508640061130151, 16508640061130103, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993871043235840, '2021-03-30 13:07:37', 16508640061130151, 16508640061130104, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993871198425088, '2021-03-30 13:07:37', 16508640061130151, 16508640061130105, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993871349420032, '2021-03-30 13:07:37', 16508640061130151, 16508640061130076, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993871500414976, '2021-03-30 13:07:37', 16508640061130151, 16508640061130082, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993871655604224, '2021-03-30 13:07:37', 16508640061130151, 16508640061130114, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993871806599168, '2021-03-30 13:07:37', 16508640061130151, 16508640061130115, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993871961788416, '2021-03-30 13:07:37', 16508640061130151, 16508640061130135, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993872116977664, '2021-03-30 13:07:37', 16508640061130151, 16508640061130136, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993872272166912, '2021-03-30 13:07:37', 16508640061130151, 16508640061130137, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993872427356160, '2021-03-30 13:07:37', 16508640061130151, 16508640061130077, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993872582545408, '2021-03-30 13:07:37', 16508640061130151, 16508640061130106, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993872733540352, '2021-03-30 13:07:37', 16508640061130151, 16508640061130107, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993872888729600, '2021-03-30 13:07:37', 16508640061130151, 16508640061130108, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993873035530240, '2021-03-30 13:07:37', 16508640061130151, 16508640061130109, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993873190719488, '2021-03-30 13:07:37', 16508640061130151, 16508640061130079, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993873345908736, '2021-03-30 13:07:37', 16508640061130151, 16508640061130118, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993873501097984, '2021-03-30 13:07:37', 16508640061130151, 16508640061130122, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993873652092928, '2021-03-30 13:07:37', 16508640061130151, 16508640061130123, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993873807282176, '2021-03-30 13:07:37', 16508640061130151, 16508640061130124, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993873962471424, '2021-03-30 13:07:37', 16508640061130151, 16508640061130125, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993874113466368, '2021-03-30 13:07:37', 16508640061130151, 16508640061130126, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993874264461312, '2021-03-30 13:07:38', 16508640061130151, 16508640061130127, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993874415456256, '2021-03-30 13:07:38', 16508640061130151, 16508640061130128, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993874566451200, '2021-03-30 13:07:38', 16508640061130151, 16508640061130134, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993874721640448, '2021-03-30 13:07:38', 16508640061130151, 260867164880244736, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993874872635392, '2021-03-30 13:07:38', 16508640061130151, 261771075572994048, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993875023630336, '2021-03-30 13:07:38', 16508640061130151, 261771076357328896, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993875178819584, '2021-03-30 13:07:38', 16508640061130151, 261771077133275136, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993875329814528, '2021-03-30 13:07:38', 16508640061130151, 261771077850501120, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993875485003776, '2021-03-30 13:07:38', 16508640061130151, 261771078534172672, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993875640193024, '2021-03-30 13:07:38', 16508640061130151, 16508640061130071, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993875791187968, '2021-03-30 13:07:38', 16508640061130151, 16508640061130080, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993875946377216, '2021-03-30 13:07:38', 16508640061130151, 16508640061130119, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993876101566464, '2021-03-30 13:07:38', 16508640061130151, 16508640061130120, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmenuauthorize` VALUES (296993876252561408, '2021-03-30 13:07:38', 16508640061130151, 16508640061130121, 258606017569361920, 1, NULL, NULL, NULL, NULL, NULL, NULL);



-- ----------------------------

-- Table structure for sysmqttmsg

-- ----------------------------

DROP TABLE IF EXISTS `sysmqttmsg`;

CREATE TABLE `sysmqttmsg`  (

  `Id` bigint(0) NOT NULL,

  `ThemeName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,

  `Msg` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,

  `Time` datetime(0) NULL DEFAULT NULL,

  PRIMARY KEY (`Id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'MQTT订阅消息' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of sysmqttmsg

-- ----------------------------



-- ----------------------------

-- Table structure for sysmqtttheme

-- ----------------------------

DROP TABLE IF EXISTS `sysmqtttheme`;

CREATE TABLE `sysmqtttheme`  (

  `Id` bigint(0) NOT NULL,

  `ThemeName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '订阅主题名称',

  `IsSubscribe` tinyint(0) NULL DEFAULT NULL COMMENT '是否订阅',

  `CreateUserId` bigint(0) NULL DEFAULT NULL COMMENT '创建人ID编号',

  `DeleteTime` datetime(0) NULL DEFAULT NULL COMMENT '删除时间',

  `DeleteUserId` bigint(0) NULL DEFAULT NULL COMMENT '删除人ID编号',

  `LastModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '最后修改时间',

  `LastModifyUserId` bigint(0) NULL DEFAULT NULL COMMENT '最后修改人ID编号',

  `IsDelete` tinyint(0) NULL DEFAULT NULL,

  `CreateTime` datetime(0) NULL DEFAULT NULL,

  PRIMARY KEY (`Id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'MQTT订阅主题' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of sysmqtttheme

-- ----------------------------

INSERT INTO `sysmqtttheme` VALUES (261778569259126784, 'AA', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmqtttheme` VALUES (264362008562896896, 'b', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmqtttheme` VALUES (278670485468745728, '999', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmqtttheme` VALUES (279577831288082432, '__UNI__B88F94B_0209192540.apk', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmqtttheme` VALUES (283037528062169088, 'ffdrgdfg', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmqtttheme` VALUES (283261997045256192, '121212', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmqtttheme` VALUES (284650467370209280, '[[[[', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmqtttheme` VALUES (286509895866388480, 'fh', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmqtttheme` VALUES (286860315184861184, 'asdfgh', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmqtttheme` VALUES (286897414600658944, '4555', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmqtttheme` VALUES (287962593971146752, '11111', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmqtttheme` VALUES (294072833942753280, '544', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysmqtttheme` VALUES (294487255156789248, '3', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);



-- ----------------------------

-- Table structure for sysposition

-- ----------------------------

DROP TABLE IF EXISTS `sysposition`;

CREATE TABLE `sysposition`  (

  `Id` bigint(0) NOT NULL,

  `PositionName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '职位名称',

  `PositionSort` int(0) NOT NULL COMMENT '职位排序',

  `Remark` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',

  `CreateUserId` bigint(0) NULL DEFAULT NULL COMMENT '创建人ID编号',

  `DeleteTime` datetime(0) NULL DEFAULT NULL COMMENT '删除时间',

  `DeleteUserId` bigint(0) NULL DEFAULT NULL COMMENT '删除人ID编号',

  `LastModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '最后修改时间',

  `LastModifyUserId` bigint(0) NULL DEFAULT NULL COMMENT '最后修改人ID编号',

  `IsDelete` tinyint(0) NULL DEFAULT NULL,

  `CreateTime` datetime(0) NULL DEFAULT NULL,

  PRIMARY KEY (`Id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of sysposition

-- ----------------------------

INSERT INTO `sysposition` VALUES (16508640061130141, '项目经理', 3, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysposition` VALUES (16508640061130142, '测试经理', 4, '111', NULL, NULL, NULL, NULL, NULL, NULL, NULL);



-- ----------------------------

-- Table structure for sysrole

-- ----------------------------

DROP TABLE IF EXISTS `sysrole`;

CREATE TABLE `sysrole`  (

  `Id` bigint(0) NOT NULL,

  `RoleName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色名称',

  `RoleSort` int(0) NOT NULL COMMENT '角色排序',

  `RoleStatus` int(0) NOT NULL COMMENT '角色状态(0禁用 1启用)',

  `Remark` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',

  `CreateUserId` bigint(0) NULL DEFAULT NULL COMMENT '创建人ID编号',

  `DeleteTime` datetime(0) NULL DEFAULT NULL COMMENT '删除时间',

  `DeleteUserId` bigint(0) NULL DEFAULT NULL COMMENT '删除人ID编号',

  `LastModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '最后修改时间',

  `LastModifyUserId` bigint(0) NULL DEFAULT NULL COMMENT '最后修改人ID编号',

  `IsDelete` tinyint(0) NULL DEFAULT NULL,

  `CreateTime` datetime(0) NULL DEFAULT NULL,

  PRIMARY KEY (`Id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of sysrole

-- ----------------------------

INSERT INTO `sysrole` VALUES (258606017569361920, '管理', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);



-- ----------------------------

-- Table structure for sysuser

-- ----------------------------

DROP TABLE IF EXISTS `sysuser`;

CREATE TABLE `sysuser`  (

  `Id` bigint(0) NOT NULL,

  `IsDelete` tinyint(0) NOT NULL,

  `UserName` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户名',

  `Password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码',

  `Salt` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码盐值',

  `RealName` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '姓名',

  `DepartmentId` bigint(0) NOT NULL COMMENT '所属部门Id',

  `Gender` int(0) NOT NULL COMMENT '性别(0未知 1男 2女)',

  `Birthday` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '出生日期',

  `Portrait` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像',

  `Email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'Email',

  `Mobile` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机',

  `QQ` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'QQ',

  `WeChat` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信',

  `LoginCount` int(0) NULL DEFAULT NULL COMMENT '登录次数',

  `UserStatus` int(0) NOT NULL COMMENT '用户状态(0禁用 1启用)',

  `IsSystem` int(0) NULL DEFAULT NULL COMMENT '系统用户(0/null不是 1是[系统用户拥有所有的权限])',

  `IsOnline` int(0) NULL DEFAULT NULL COMMENT '在线(0不是 1是)',

  `FirstVisit` datetime(0) NULL DEFAULT NULL COMMENT '首次登录时间',

  `PreviousVisit` datetime(0) NULL DEFAULT NULL COMMENT '上一次登录时间',

  `LastVisit` datetime(0) NULL DEFAULT NULL COMMENT '最后一次登录时间',

  `Remark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',

  `Picture` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '相片',

  `ApiToken` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,

  `CreateUserId` bigint(0) NULL DEFAULT NULL COMMENT '创建人ID编号',

  `DeleteTime` datetime(0) NULL DEFAULT NULL COMMENT '删除时间',

  `DeleteUserId` bigint(0) NULL DEFAULT NULL COMMENT '删除人ID编号',

  `LastModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '最后修改时间',

  `LastModifyUserId` bigint(0) NULL DEFAULT NULL COMMENT '最后修改人ID编号',

  `CreateTime` datetime(0) NULL DEFAULT NULL,

  `Tags` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '个人标签',

  `LoginUserType` int(0) NULL DEFAULT NULL COMMENT '登录用户类型',

  `LoginUserId` bigint(0) NULL DEFAULT NULL COMMENT '登录用户对应表Id',

  PRIMARY KEY (`Id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of sysuser

-- ----------------------------

INSERT INTO `sysuser` VALUES (16508640061130150, 0, 'wangxue', 'ae51fabc8d8217a7242a58bb76ca62c1', '10184', '王雪', 16508640061124408, 1, '1993-10-06', '', '', '15612345678', '', '', 1, 1, 0, 1, '2019-09-21 10:48:03', '2019-09-21 10:48:03', '2019-09-21 10:48:03', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysuser` VALUES (16508640061130151, 0, 'admin', 'b4e24a62fb8b61b0af033b0a30b20df1', '98648', '管理员', 16508640061124402, 0, '2019-01-01', '/Resource/Portrait/2021/05/19/1621388220355.jpg', 'admin@163.com', '15766666666', '810938177', 's810938177', 3824, 1, 1, 1, '2018-12-12 16:00:10', '2021-05-31 15:55:20', '2021-05-31 15:55:20', '123123', NULL, 'cde273d82919485d97f3010ca1e74f61', NULL, NULL, NULL, '2021-05-31 15:55:20', 0, NULL, '超管', NULL, NULL);

INSERT INTO `sysuser` VALUES (296397676344250368, 0, 'zhangxiao', 'e30b1a81152bab39a7b22ae5454bdfe3', '42261', '张小小', 16508640061124408, 1, '2021-03-30', NULL, NULL, '13632015890', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021-03-30 14:51:13', 16508640061130151, NULL, NULL, NULL, NULL);

INSERT INTO `sysuser` VALUES (297033728075501568, 0, 'sj', '7a0bb7e7e69b093892e46682b26b510f', '57970', '史单纯', 16508640061124404, 1, '2021-03-30', NULL, NULL, '12345678901', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, 16508640061130151, NULL, NULL, '2021-04-01 13:42:08', 16508640061130151, '2021-03-30 15:45:59', NULL, NULL, NULL);

INSERT INTO `sysuser` VALUES (297308940515938304, 1, 'test11', '378e7e49aa5f8a06cb1fdbb7404f4a87', '68364', '测试1', 16508640061124406, 1, '2021-03-31', NULL, NULL, '18118394555', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '1111', NULL, NULL, 16508640061130151, '2021-03-31 10:01:28', 16508640061130151, '2021-03-31 14:29:43', 16508640061130151, '2021-03-31 09:59:35', NULL, NULL, NULL);

INSERT INTO `sysuser` VALUES (297377008554348544, 1, '111', 'de81b92652225066604d5e05d3538292', '84699', '11', 16508640061124403, 1, '2021-03-31', NULL, NULL, '11', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '11', NULL, NULL, 16508640061130151, '2021-03-31 14:30:10', 16508640061130151, '2021-03-31 14:30:10', 16508640061130151, '2021-03-31 14:30:04', NULL, NULL, NULL);

INSERT INTO `sysuser` VALUES (313344284575141888, 0, 'aqy', '936e9dc71b62474b1fa9f50f67e38b88', '80128', 'SDC', 313344111564296192, 1, '2021-05-14', NULL, NULL, '', NULL, NULL, 13, 1, NULL, 1, NULL, '2021-05-14 16:20:50', '2021-05-14 16:20:50', '', NULL, '3b1aaf9c700642fa9293b880fae4a26a', 16508640061130151, NULL, NULL, '2021-05-19 09:47:42', 16508640061130151, '2021-05-14 15:58:19', NULL, 1, 302100576374624256);

INSERT INTO `sysuser` VALUES (314809015781560320, 0, 'cs', '3c26eafa06a3e45daa1e2835de5f904a', '35957', '1', 313344111564296192, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16508640061130151, NULL, NULL, '2021-05-18 16:58:38', 16508640061130151, '2021-05-18 16:58:38', NULL, 1, 314809015106277376);



-- ----------------------------

-- Table structure for sysuserbelong

-- ----------------------------

DROP TABLE IF EXISTS `sysuserbelong`;

CREATE TABLE `sysuserbelong`  (

  `Id` bigint(0) NOT NULL,

  `CreateTime` datetime(0) NOT NULL,

  `UserId` bigint(0) NOT NULL COMMENT '用户Id',

  `BelongId` bigint(0) NOT NULL COMMENT '职位Id或者角色Id',

  `BelongType` int(0) NOT NULL COMMENT '所属类型(1职位 2角色)',

  `CreateUserId` bigint(0) NULL DEFAULT NULL COMMENT '创建人ID编号',

  `DeleteTime` datetime(0) NULL DEFAULT NULL COMMENT '删除时间',

  `DeleteUserId` bigint(0) NULL DEFAULT NULL COMMENT '删除人ID编号',

  `LastModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '最后修改时间',

  `LastModifyUserId` bigint(0) NULL DEFAULT NULL COMMENT '最后修改人ID编号',

  `IsDelete` tinyint(0) NULL DEFAULT NULL,

  PRIMARY KEY (`Id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of sysuserbelong

-- ----------------------------

INSERT INTO `sysuserbelong` VALUES (259363197956395008, '2020-12-16 16:56:45', 259345304376053760, 258606017569361920, 2, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysuserbelong` VALUES (259363198329688064, '2020-12-16 16:56:45', 259345304376053760, 16508640061130140, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysuserbelong` VALUES (259363198677815296, '2020-12-16 16:56:45', 259345304376053760, 16508640061130141, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysuserbelong` VALUES (259426846125330432, '2020-12-16 21:09:40', 16508640061130151, 258606017569361920, 2, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysuserbelong` VALUES (259426846565732352, '2020-12-16 21:09:40', 16508640061130151, 16508640061130140, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysuserbelong` VALUES (259432564475826176, '2020-12-16 21:32:23', 16508640061130152, 258606017569361920, 2, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysuserbelong` VALUES (259432564895256576, '2020-12-16 21:32:23', 16508640061130152, 16508640061130141, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysuserbelong` VALUES (259432565268549632, '2020-12-16 21:32:24', 16508640061130152, 16508640061130140, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysuserbelong` VALUES (283461040950218752, '2021-02-21 04:52:59', 16508640061130150, 258606017569361920, 2, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysuserbelong` VALUES (283461041021521920, '2021-02-21 04:52:59', 16508640061130150, 277766285150916608, 2, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysuserbelong` VALUES (283461041080242176, '2021-02-21 04:52:59', 16508640061130150, 16508640061130140, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysuserbelong` VALUES (286770553761566720, '2021-03-02 08:03:48', 286770553635737600, 277766285150916608, 2, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysuserbelong` VALUES (286770553816092672, '2021-03-02 08:03:48', 286770553635737600, 286619174082449408, 2, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysuserbelong` VALUES (286770553853841408, '2021-03-02 08:03:48', 286770553635737600, 16508640061130139, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysuserbelong` VALUES (286770553883201536, '2021-03-02 08:03:48', 286770553635737600, 16508640061130140, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysuserbelong` VALUES (286770553912561664, '2021-03-02 08:03:48', 286770553635737600, 16508640061130141, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysuserbelong` VALUES (286770553941921792, '2021-03-02 08:03:48', 286770553635737600, 16508640061130143, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysuserbelong` VALUES (286770553971281920, '2021-03-02 08:03:48', 286770553635737600, 16508640061130142, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysuserbelong` VALUES (286770554000642048, '2021-03-02 08:03:48', 286770553635737600, 16508640061130144, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysuserbelong` VALUES (286770554025807872, '2021-03-02 08:03:48', 286770553635737600, 16508640061130145, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysuserbelong` VALUES (287262428117340160, '2021-03-03 16:38:20', 287262427932790784, 258606017569361920, 2, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysuserbelong` VALUES (287262428171866112, '2021-03-03 16:38:20', 287262427932790784, 277766285150916608, 2, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysuserbelong` VALUES (287262428205420544, '2021-03-03 16:38:20', 287262427932790784, 16508640061130139, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysuserbelong` VALUES (297014870753153024, '2021-03-30 14:31:03', 297014869461307392, 258606017569361920, 2, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysuserbelong` VALUES (297014871122251776, '2021-03-30 14:31:04', 297014869461307392, 16508640061130142, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysuserbelong` VALUES (297016001441042432, '2021-03-30 14:35:33', 297016000946114560, 258606017569361920, 2, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysuserbelong` VALUES (297016001784975360, '2021-03-30 14:35:33', 297016000946114560, 16508640061130141, 1, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sysuserbelong` VALUES (297376920335552512, '2021-03-31 14:29:43', 297308940515938304, 258606017569361920, 2, 16508640061130151, NULL, NULL, '2021-03-31 14:29:43', 16508640061130151, 0);

INSERT INTO `sysuserbelong` VALUES (297376920574627840, '2021-03-31 14:29:43', 297308940515938304, 16508640061130142, 1, 16508640061130151, NULL, NULL, '2021-03-31 14:29:43', 16508640061130151, 0);

INSERT INTO `sysuserbelong` VALUES (297377008873115648, '2021-03-31 14:30:04', 297377008554348544, 258606017569361920, 2, 16508640061130151, NULL, NULL, '2021-03-31 14:30:04', 16508640061130151, 0);

INSERT INTO `sysuserbelong` VALUES (297377009095413760, '2021-03-31 14:30:04', 297377008554348544, 16508640061130141, 1, 16508640061130151, NULL, NULL, '2021-03-31 14:30:04', 16508640061130151, 0);

INSERT INTO `sysuserbelong` VALUES (313344285162344448, '2021-05-14 15:58:19', 313344284575141888, 258606017569361920, 2, 16508640061130151, NULL, NULL, '2021-05-14 15:58:19', 16508640061130151, 0);

INSERT INTO `sysuserbelong` VALUES (313344285439168512, '2021-05-14 15:58:19', 313344284575141888, 16508640061130142, 1, 16508640061130151, NULL, NULL, '2021-05-14 15:58:19', 16508640061130151, 0);



SET FOREIGN_KEY_CHECKS = 1;
Loading...
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
C#
1
https://gitee.com/zyqcome/queer.git
git@gitee.com:zyqcome/queer.git
zyqcome
queer
queer
master
点此查找更多帮助

搜索帮助

Git 命令在线学习 如何在 Gitee 导入 GitHub 仓库
Git 仓库基础操作
企业版和社区版功能对比
SSH 公钥设置
如何处理代码冲突
仓库体积过大，如何减小？
如何找回被删除的仓库数据
Gitee 产品配额说明
GitHub仓库快速导入Gitee及同步更新
什么是 Release（发行版）
将 PHP 项目自动发布到 packagist.org
评论
仓库举报
回到顶部