/* Navicat MySQL Data Transfer Source Server : 本地连接 Source Server Type : MySQL Source Server Version : 80029 Source Host : localhost:3306 Source Schema : hmplatform Target Server Type : MySQL Target Server Version : 80029 File Encoding : 65001 Date: 23/07/2024 13:56:06 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for frame_dept -- ---------------------------- DROP TABLE IF EXISTS `frame_dept`; CREATE TABLE `frame_dept` ( `DEPT_ID` int(0) NOT NULL AUTO_INCREMENT COMMENT '部门编号', `DEPT_NAME` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门名称', `DEPT_DESC` varchar(254) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注信息', `DEPT_PID` int(0) NULL DEFAULT NULL COMMENT '部门上级部门', `DEPT_MANAGER` varchar(254) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门经理', `DEPT_ADDR` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门地址', `DEPT_TEL` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门联系电话', `DEPT_FAX` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门传真', `DEPT_CODE` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门编号', `DEPT_LEVEL` int(0) NULL DEFAULT NULL COMMENT '部门级别', PRIMARY KEY (`DEPT_ID`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统表-部门信息' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of frame_dept -- ---------------------------- -- ---------------------------- -- Table structure for frame_dict -- ---------------------------- DROP TABLE IF EXISTS `frame_dict`; CREATE TABLE `frame_dict` ( `DICT_NAME` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典名称', `DICT_VALUE` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典值', `DICT_TEXT` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典中文名称', `DICT_ORDER` int(0) NULL DEFAULT 0 COMMENT '字典排序', PRIMARY KEY (`DICT_NAME`, `DICT_VALUE`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统表-字典定义' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of frame_dict -- ---------------------------- INSERT INTO `frame_dict` VALUES ('FrameResType', 'Fun', '功能点', 3); INSERT INTO `frame_dict` VALUES ('FrameResType', 'Menu', '大类', 1); INSERT INTO `frame_dict` VALUES ('FrameResType', 'Page', '页面', 2); INSERT INTO `frame_dict` VALUES ('FrameSex', '保密', '保密', 3); INSERT INTO `frame_dict` VALUES ('FrameSex', '女', '女', 2); INSERT INTO `frame_dict` VALUES ('FrameSex', '男', '男', 1); INSERT INTO `frame_dict` VALUES ('FrameStatus', 'Active', '启用', 1); INSERT INTO `frame_dict` VALUES ('FrameStatus', 'InActive', '禁用', 2); INSERT INTO `frame_dict` VALUES ('FrameValueType', 'Boolean', '布尔值', 5); INSERT INTO `frame_dict` VALUES ('FrameValueType', 'Date', '日期', 2); INSERT INTO `frame_dict` VALUES ('FrameValueType', 'Integer', '整数', 4); INSERT INTO `frame_dict` VALUES ('FrameValueType', 'String', '字符串', 1); INSERT INTO `frame_dict` VALUES ('FrameValueType', 'Time', '时间', 3); INSERT INTO `frame_dict` VALUES ('GobalBusinessType', 'AdoptAspect', '通过考试', 11); INSERT INTO `frame_dict` VALUES ('GobalBusinessType', 'Appointment', '分组预约', 14); INSERT INTO `frame_dict` VALUES ('GobalBusinessType', 'AspectBatchPay', '复试缴费成功', 12); INSERT INTO `frame_dict` VALUES ('GobalBusinessType', 'AspectCancel', '取消报考', 10); INSERT INTO `frame_dict` VALUES ('GobalBusinessType', 'AspectEnrol', '专业报考', 4); INSERT INTO `frame_dict` VALUES ('GobalBusinessType', 'AspectExamArrange', '复试已编排', 13); INSERT INTO `frame_dict` VALUES ('GobalBusinessType', 'AspectPay', '专业缴费', 5); INSERT INTO `frame_dict` VALUES ('GobalBusinessType', 'DownloadTicket', '下载准考证', 8); INSERT INTO `frame_dict` VALUES ('GobalBusinessType', 'EnrolPay', '批量缴费', 6); INSERT INTO `frame_dict` VALUES ('GobalBusinessType', 'IdCard', '上传证件照', 1); INSERT INTO `frame_dict` VALUES ('GobalBusinessType', 'NoCrownUpload', '上传免冠照', 2); INSERT INTO `frame_dict` VALUES ('GobalBusinessType', 'NoCrownValid', '免冠证件已验证', 9); INSERT INTO `frame_dict` VALUES ('GobalBusinessType', 'RefuseMaterial', '材料审核失败', 12); INSERT INTO `frame_dict` VALUES ('GobalBusinessType', 'StdReg', '考生完成注册', 3); INSERT INTO `frame_dict` VALUES ('GobalBusinessType', 'SubscribeExam', '考试预约', 7); INSERT INTO `frame_dict` VALUES ('ProjectStatus', 'Complete', '已结束', 2); INSERT INTO `frame_dict` VALUES ('ProjectStatus', 'Running', '运行中', 1); INSERT INTO `frame_dict` VALUES ('StdResType', 'FaceMatch', '人脸比对', 3); INSERT INTO `frame_dict` VALUES ('StdResType', 'Identify', '身份认证', 2); INSERT INTO `frame_dict` VALUES ('StdResType', 'OcrIdCard', 'Ocr身份识别', 1); INSERT INTO `frame_dict` VALUES ('WeixinMenuType', 'click', '点击推事件', 1); INSERT INTO `frame_dict` VALUES ('WeixinMenuType', 'location_select', '弹出地理位置选择', 8); INSERT INTO `frame_dict` VALUES ('WeixinMenuType', 'media_id', '下发消息（除文本消息）', 9); INSERT INTO `frame_dict` VALUES ('WeixinMenuType', 'pic_photo_or_album', '弹出拍照或者相册发图', 6); INSERT INTO `frame_dict` VALUES ('WeixinMenuType', 'pic_sysphoto', '弹出系统拍照发图', 5); INSERT INTO `frame_dict` VALUES ('WeixinMenuType', 'pic_weixin', '弹出微信相册发图', 7); INSERT INTO `frame_dict` VALUES ('WeixinMenuType', 'scancode_push', '扫码推事件', 3); INSERT INTO `frame_dict` VALUES ('WeixinMenuType', 'scancode_waitmsg', '扫码推事件且弹框', 4); INSERT INTO `frame_dict` VALUES ('WeixinMenuType', 'view', '跳转URL', 2); INSERT INTO `frame_dict` VALUES ('WeixinMenuType', 'view_limited', '跳转图文消息URL用户', 10); INSERT INTO `frame_dict` VALUES ('WeixinMsgType', 'EventClick', '点击事件', 8); INSERT INTO `frame_dict` VALUES ('WeixinMsgType', 'EventLocation', '位置事件', 9); INSERT INTO `frame_dict` VALUES ('WeixinMsgType', 'EventSubscribe', '关注事件', 10); INSERT INTO `frame_dict` VALUES ('WeixinMsgType', 'EventUnsubscribe', '取消关注事件', 11); INSERT INTO `frame_dict` VALUES ('WeixinMsgType', 'EventView', '点击View事件', 12); INSERT INTO `frame_dict` VALUES ('WeixinMsgType', 'image', '图片消息', 2); INSERT INTO `frame_dict` VALUES ('WeixinMsgType', 'link', '链接消息', 7); INSERT INTO `frame_dict` VALUES ('WeixinMsgType', 'location', '地理位置消息', 6); INSERT INTO `frame_dict` VALUES ('WeixinMsgType', 'shortvideo', '小视频消息', 5); INSERT INTO `frame_dict` VALUES ('WeixinMsgType', 'text', '文本消息', 1); INSERT INTO `frame_dict` VALUES ('WeixinMsgType', 'video', '视频消息', 4); INSERT INTO `frame_dict` VALUES ('WeixinMsgType', 'voice', '语音消息', 3); INSERT INTO `frame_dict` VALUES ('WeixinType', 'WeChat', '公众号', 1); -- ---------------------------- -- Table structure for frame_dict_name -- ---------------------------- DROP TABLE IF EXISTS `frame_dict_name`; CREATE TABLE `frame_dict_name` ( `DICT_NAME` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典类型', `DICT_DESC` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字典描述信息', `MODIFY_FLAG` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'Active' COMMENT '是否可以修改', `FRAME_FLAG` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'InActive' COMMENT '是否是框架自带的字典', PRIMARY KEY (`DICT_NAME`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统表-字典类型定义' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of frame_dict_name -- ---------------------------- INSERT INTO `frame_dict_name` VALUES ('FrameFileType', '文件类型', 'Active', 'Active'); INSERT INTO `frame_dict_name` VALUES ('FrameResType', '菜单类型', 'InActive', 'Active'); INSERT INTO `frame_dict_name` VALUES ('FrameSex', '性别', 'InActive', 'Active'); INSERT INTO `frame_dict_name` VALUES ('FrameStatus', '系统默认状态', 'InActive', 'Active'); INSERT INTO `frame_dict_name` VALUES ('FrameValueType', '数值类型', 'InActive', 'Active'); INSERT INTO `frame_dict_name` VALUES ('GobalBusinessType', '业务类型', 'Active', 'InActive'); INSERT INTO `frame_dict_name` VALUES ('WeixinMenuType', '微信菜单类型', 'InActive', 'InActive'); INSERT INTO `frame_dict_name` VALUES ('WeixinMsgType', '微信消息类型', 'InActive', 'InActive'); INSERT INTO `frame_dict_name` VALUES ('WeixinType', '微信类型', 'InActive', 'InActive'); -- ---------------------------- -- Table structure for frame_module -- ---------------------------- DROP TABLE IF EXISTS `frame_module`; CREATE TABLE `frame_module` ( `MODULE_ID` int(0) NOT NULL COMMENT '内部编号', `MODULE_NAME` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '模块名称', `MODULE_ALIAS` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模块中文名称', `MODULE_CLASS` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '模块的启动路径', `MODULE_VERSION` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '模块当前版本', `MODULE_PARAM` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '启动模块的参数信息', `MODULE_STATUS` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'InActive' COMMENT '是否启用改模块', `PROJECT_NAME` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '哪个工程需要使用该模块', `LOAD_ORDER` int(0) NOT NULL DEFAULT 1 COMMENT '模块启动顺序', PRIMARY KEY (`MODULE_ID`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统表-系统模块表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of frame_module -- ---------------------------- INSERT INTO `frame_module` VALUES (1, 'WeiXin', '微信公众号', 'cn.hmsoft.weixin.util.WeiXinModuleConfig', '2.0.0', '', 'InActive', ',HmPlatform,', 1); INSERT INTO `frame_module` VALUES (2, 'HmsoftAI', '合木AI', 'cn.hmsoft.ai.util.AiModuleConfig', '1.0.0', 'BaiduOcrAppId:17066982\r\nBaiduOcrAppKey:p7SV9y0kapnTIj6bAE8Qjz6c\r\nBaiduOcrSecretKey:dALAVYkeGp7Hs3HLio0YagVDK9TXhb9Q\r\nBaiduIdPhotoAppId:17794270\r\nBaiduIdPhotoAppKey:ac6cN0620mzGxfmQNiq1IIh8\r\nBaiduIdPhotoSecretKey:kapVs9Bh8tYIGjOt2MDXZGvf1pnD9tAx\r\nBaiduIdPhotoToken:24.8b3131e6e639967911bf36cdbfcbf7cc.2592000.1704519855.282335-17794270\r\nBaiduIdPhotoTokenExpireTime:2024-01-06 13:44:17\r\nOther:false', 'Active', ',HmPlatform,', 2); INSERT INTO `frame_module` VALUES (3, 'Pay', '合木支付', 'cn.hmsoft.pay.util.PayModuleConfig', '5.0.0', 'BusinessClass:cn.hmsoft.art.enrol.service.EnrolStdPayService', 'InActive', ',HmPlatform,', 3); -- ---------------------------- -- Table structure for frame_nation -- ---------------------------- DROP TABLE IF EXISTS `frame_nation`; CREATE TABLE `frame_nation` ( `NATION_ID` int(0) NOT NULL COMMENT '内部编号', `NATION_NAME` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '民族名称', `ROME_CODE` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '民族编号（罗马编号）', `CHAR_CODE` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '民族编号（英文编号）', PRIMARY KEY (`NATION_ID`) USING BTREE, UNIQUE INDEX `UQ_FRAME_NATION_NAME`(`NATION_NAME`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统表-民族定义' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of frame_nation -- ---------------------------- -- ---------------------------- -- Table structure for frame_optr -- ---------------------------- DROP TABLE IF EXISTS `frame_optr`; CREATE TABLE `frame_optr` ( `OPTR_ID` int(0) NOT NULL AUTO_INCREMENT COMMENT '内部编号', `OPTR_NAME` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '操作员名称', `LOGIN_NAME` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '登录名称，唯一', `LOGIN_PASS` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '登录密码,MD5加密', `OPTR_ALIAS` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '别名', `OPTR_SEX` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作员性别，FrameSex', `OPTR_STATUS` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作员状态，对应FrameStatus', `OPTR_EMAIL` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '电子邮件地址', `OPTR_MOBILE` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系电话', `OPTR_TEL` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '办公电话', `OPTR_ADDR` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系地址', `OPTR_FAX` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '传真号码', `OPTR_DEPT` int(0) NULL DEFAULT NULL COMMENT '部分编号', `OPTR_POST` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮政编码', `OPTR_LEVEL` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作员级别', `OPTR_DESC` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作员备注信息', `CREATE_OPTR` int(0) NULL DEFAULT NULL COMMENT '创建人操作员', `CREATE_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间', `OPTR_IMAGE` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '操作员照片', `VALID_CODE` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'sms验证码', `VALID_EXPIRE_TIME` datetime(0) NULL DEFAULT NULL COMMENT '验证码失效时间', PRIMARY KEY (`OPTR_ID`) USING BTREE, UNIQUE INDEX `INX_FRAME_OPTR_LOGIN_NAME`(`LOGIN_NAME`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统表-操作员信息' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of frame_optr -- ---------------------------- INSERT INTO `frame_optr` VALUES (0, '禾木管理员', 'admin', '866138C256DEE23653FA654FCB7CCDA8', '', NULL, 'Active', 'revisit@126.com', '13588866675', '027-88899975', '湖北省武汉市武汉大学茶港', '027-888888785', 0, '超管', NULL, NULL, NULL, NULL, 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAHoAAACACAYAAADEUH2bAAAiA0lEQVR42u1dCZgcVbUOKouyuwIi\r\nICqIiIKAAj4UAYXAU3xAfCwmTNfS2QhJBDGgYFQUEXgii2IgbLJI2AkEwzYk03WreiYEE7IAARJI\r\nyDaZrlvVM5lMkkm//7/V6HR1dU/XpGcyM/b9vvq6p6e7lnvuOfc/+5AhtVEbtVEbtVEbtVEbtVEb\r\ntVEbtVEbtVEbtVEbtVEbtVEbtVEbtdG3Y3J97kNaKrdrck7b3mZj9tCRjdlvGZZ/hia8EYaTHWs6\r\n/iWGLS83bfcXPNR7gc+EN5bf0Wz/B0baPz7hZL+UnN28t5Zq3vUEnLM2s9t4DMvlPpisX/lxLe1+\r\nVbPdH5iOO950vBvw/lFduLMN23vZtP2FuvDeAlFXGLa/2nC8Zny+Ln80q89sfzm/o9veQvx/jiHk\r\nLByP4LMb8J2LsBj+OylaD8PfHx02bdoHazPfF1yby31glJX9pObI7xmWe7Eu5FTdchsMx38NRHlP\r\nt6WH140g2Ba85np4bMmfQ4Lb38PxmsGFY8nbdNudaNryZC6wIbncdjWKVHkk5+S2B0d9neJWt/zH\r\ndMdfAAKsAWFb8bp5K4ha6cFrZHGsxvUXJIR8FItrktEgj+Tiq1Foawn8XGZ33fa/j+MuzfIWY6Jb\r\nDOFvwCR39gFxIw+dHC+8DbwXvF9kOPIO3fJOP99p2a1GsZhjuLX6k0baOxd77lOY1LWY1HbdjiWO\r\nN5qWzBi2u0x3PO7TTVgcs3RHzsTr0zjXDEiHZ/F+Nt7PIcEgHZbhyCixHYfouDccq3Cfj+N+z0nM\r\nzX6iRsHuCDxv9c4gwP/qJLDjuZjATRVNuOVldeHPA7c/Au7/vS6yI5UkaPK+DiJ/nvt63SvuHsk5\r\nmd0pJdSB9/yM/xvpeF9I2N43iLzNdHYUfnsN3j8K4i3A/bRVurgA7JqB9B9POPLsYQtzu9QoGjFG\r\n2f43IQbvx4RJHJWIZmmkvGcByC4jOCNBA/Uqt/0J9fUf4t45efLkD1QEmvAdfpe/4W95jvOd3G4j\r\nGvyDzLR3Coj9c1zveQDALBB5N/flb4akaMZCvTuJxVOj7L+AFvRe26Ne+w4mp7M8GnbbwL1NSVte\r\najitXxk+c/XOfYV+h8/M7Wxa7uEEhLiXuZqdaTfKbSeO7MRW8Cakw6V1ja17/WdSF8QZtyS3o2Fn\r\nTwAnzoCIbC8nEiFGoTp5D9AAMqZ+24vEMQvX7qJZ8izo2A9pKezPtg91zI8kuinkehyPGSn/+Lr6\r\n3E7/MWrZsGm5D2qp5n1A4PGm7b9RRgSC+C4JfAsXRH9VYzQn+x1sH7eC6CvyaDz6eYRcBEk0egy4\r\ne9CrZNz7DCfzFYi0W/TAOlUK1Kw20v5tuuV+ayBMChevkZYnYgu6E/e/piRyt7y1WNzXj6SZdc6c\r\n7QclkeuW5nbSaX8W7qPY59YX72lKN84YlnwWqtFZtDUPtO1odIPcExrDOQq4CelGYQ4Qms/+oGb5\r\nx3L7GlREHlO/dhfajCHi6nEUAy6KPOEtBpf/ZpTdfsDkyQNXtJG7TaB1EPpqZZqlgSesDgq5RRPy\r\nOezz34OU+8hgQF3bjXNadoNeOwwP3hi9d3muSQOGJc/mgoiSBOQUItdE4/rPQER+NmnJz/HQmuSB\r\ndbZ7gFHfsi/1YerH0F932CrAQ1UL56CezXMaDs6Na/Ba71/XmCU/m2hs+Uxd/dq91L1FgCzq6MAh\r\n51FC5VXGKIOLbTjuGcPn5XYe0GSm+AUhz8UxN8qqhIkIwFaDPPJ9AvE35GqoJ0deIORJEIXDdapT\r\nQv6BoIf6KX5/H16pc9+LbeAOLJSb8HqVLtzxejo7zGzMfpseJ4K+QDyWITyuycU0Sqz7NPEDgR+N\r\nNthiJuD8V+H1Zj3Ye+/NX/M+PA/v4S8mjTNK1fN+jHs7CWDra8AV+6sFm9csqEvjO1NwjlUlrHtz\r\nADrPTM5ZOTA5e5jIfZhcSp0zyqig0ytkyZ+TqMpiNcf/Ij47FarUTyDWbsd36jFBSzA5a/Hq43cd\r\n1E0j0CyPzcoU6Xgu9Nb38Nv5+PtpEOmP+K1hiuy3SYC6+qU7vX9/E3F/akGRsI5M0sWpTKNCvorz\r\nrMxzYbtymkQZSXAvphLLrq8BgGm2fAPXelGzMlNMahSi9ZQ6se6Lyl4vvM/rjvsrPk/eQRKWai/T\r\nKkewOuDQNR5+KDitMYKTO/BgjaaVHaM1uF/VZ8uTtFRmEgEKJnQxOLg1ch/vwYHrb8Ik05SK+8Di\r\nETI5Mi2PynvCRlMagKhNCjjZsipeMHXvwsvSF46//65b8tKkUsHcI3CtCSD2XDUHxb9NY+GfOGD0\r\nbKpDZqN/nO7IWcUPI9drwrMwGZcwqiPv3LcxCX5Mp0UPD38VOHcm3nPfXN3rni5IAhBW4jmFnvav\r\nVyLelj/D5+nAThBWv+Qsiv+Bwc3C/yI9OXpYtRDgLtt7g/ub6fhT8dCvxHAYdEGrXgfO3abbbmte\r\nTdvIz3uRYOTQjdgG1vOaENF49Tu0mNdUvnNbvqw7/hT8/Te8f9sMO224RVje4wR8/ZrIulj+Udzw\r\nn7EyN0Tsox0gyHK1NzvRKLQLQTdzQnEsxaJowN/TFPix5DUg9BUJBYDciwOQ5l2hpeTVmLRbArem\r\nXJ7fs3tK2E10WeL1SZz7Zj0lf4cF+gs9f01eWxPZKyCSr4HUuhX3x3tLBb/BIuhu2wm2EqqS76kF\r\nVPz/Dmx7fxqR9j/WP0U2dF+sxotUcEAJboS42lTKM5XXLWkta4Qon6rZ7k9ULJhoOU5JCag5Y/Hw\r\ndPDTmUH9k6/8jHs9iDwc578Di2GpWaF7swyh3wQBp+hp7zy9Kftlxov965rzVu9MlZGEMJz1+xr2\r\nukMAyo6jmgS9GYvPvRMSpwnnwDyU5PpOPQB5W6LnAgBUeBf2S6sgIyhx42/Hj9iQm8EZb4DQ9xlW\r\nZrTm+P9FXZmOg3LAhOqI2dh6OCeEoAeTOhfcsDJvb+6xKNeDeLN2gKkVFLWGyN6ngBtUr7KWrLxq\r\nOBr6Nk23wX3Jv6vgROFvih23xnApzGn/snw1tu6Flfxs977aouN1HH8KrGb0JzfvmusGdar4MSvz\r\n5SB013sOr8sjgU21DsHoFvkuARyBVBIqEyNQuwOk5HoGNNDjpmz7lnwrbpQMRPgTWqptn360N3tX\r\nxgNW/moAmjsZazVKrP+0MpZUYLEam859DJw/Ejrni+C4NZWG/WiWu0Wj+iQkJs9Vh2G5m/hZDFDF\r\na60BsZ7Xha+Nc3IVxYiNm5HbkSKe25CuQJgKOa40VKkF+vqkfqFyGenM8aaQb1QkLh2f+qMNItXR\r\nbDluxpLyVquu9mOKadu7S8Vn0f9bjrABkFsBMSyURcuSv9UZ9225dYbInMt4NBC/Dv8fj4XzO3Dt\r\nfcF9yRXd+MZzed/zSurgFzS2HFqxKXhJQHAuVMN2X65skcpOLJB/1qUy21aEj1mY2wUP/beyfth/\r\ngy0X37uLXpvk9MrNfYELEIRRpsIIr9e/CdCRV9/uB4i6UEvjOnMy+yVmZz8Bcb877cnDxPIPc8J5\r\n8P0l+Kyu3t2D39Gt9v01J/Nf9JMrQ4fwGB3SUYYI6xMCBHOyZ8eZM4I6XYVNefdDwvgVcHYWi3YK\r\nw6S2GaFNO/sjcMaKCrgZXOhNTsxq+Ux3+1vBXlef+xD278twjXUqFivSxwtVzpJpAJ5Jdda6o4mG\r\nSUQukJ54nvjbsQpRe8foKsRJcV+phdyppdwWEOynccyXjEsbQweN8K8upaWEEgqWmE72rG1CZHp2\r\ngJYfK2HO68ppy5nfpEKAYuw1am+z/etwlJ5kIRebUMOI0odNW7hDNd2bBFTEDspODd0ZYPPNMjFt\r\nDBq8moskjpeMzg/MzYTuiK182JBUnPO+90zZ8keKiOVuENwOQtTFBROTp+V2UIaX0jq3i0U2ZRR0\r\n3D7RNSdP/gCDEcGBd9OOXeJ524yU98fYwQSYGxDShOTIlMc31FDcM/uUyBNeye1hOO5D5WOkvDUA\r\nN6PiEpnRltjDrjei9kfhbcbioZfIiMU9VRokoul4YzThL41ahFD3PMXZC9fGDmAEIcfm037KqHne\r\nnec1yD37zp6d9k4HIZaUWYEZ6rlx006HKmTqT8JkZaOiUICcZ48UrSdtc03Dkd/FYktHImdmllju\r\nxRPjLkQwhO5kr8xnfpTaBudhMQ3tk4dkNAXtzoYy0kfezHrD8v4c90EV8HK8c8wIcKcHKTkzaJ3q\r\nL7aDOpE5TBPu82FVj0YRqERvJNNy2OSYC12pYMoXX0r1kj62zOviaC09N440eV83lJst0tDQqaf8\r\nF4mu465mLSWPCtBzoWNep4XI8WfQ3t3fzL5m2j/IdPwX6ZkLLXYaY15SLseYW9eFqeZ9sC3OjtJk\r\nIEW2ABTW11ne0b0bNQL1I2m7E/MRGBHB6u4KhtTE3vugx0KNmhohJToTtmcDbX65v3rsyNlmSjrh\r\nPRsL1APH38yEwdgLqKn1ZEO475XwDbyr2dlRVNF6b2+e3by36bj3mNGGiw4sgF/HDYehdUxZixzv\r\n3WhbuHtCf/fBEzdgu3o9wta/BNyZCCyAcbbHpTsZlv/byAhSoPuEkLcyHq4XbdryJN2STZHGeXw+\r\nIpXZL/YkNbhfBSc/F7Ev0RChDxkAQyUm0MMVuFkL7OO64z2ux5VIaivzD9ZEVCiWZFDl7F7zbBFY\r\nGCIzNu/JCftP2w2RTfZggj6CyZmkB5azAhuv6chbaTQZMkAGfdaMHtGLKjDQu+ZdFDd+W3F1oHK1\r\nRcz3W0D2iV7J9kjO8T+OPfimKPssCJUynNZPxZ8c9wjc9DNF3Gy5CxiuO2QADWWTT3nHQNzOD0XX\r\n4NnkI4HGEAOYkauVb9triJhvjxEupEn1VyzEj8nMx5DNGYTqMAEOeqZKZMZiIt4JcUAbzZo0aQ4Z\r\nYEPlZ9s+47xbwxyoYRtSgf5xHSDCHY852lBs/vUfYnRLdZ+AyrzwTmVJpyKXoJDz6xzvC3HVCGY/\r\ngKj3RTgMUlRbBmJ6aRAB23o4mCEVUrc2YMtj0uD+cc8XhAnLVyIMM6Lq4cHkLsZEQ2QsLRIjaf/6\r\nuAlxjCKBmDstnMGh06TqyEmMyxoyQIfaq4V3JfOiQyDKUapnTMKwJgqjcIoQvQpR8kZUFLQRRyTR\r\neQ8OlEV5U448K65KpTIrhbwsnDoLlLmY7sGeuBj7DwKfsz0JymSE0CJex+DJuDZ6ZpSMdLwf43wt\r\nISeHpJm5qlmnLD8BUHBn2AJE+D9ydvZLcd2DSahh+bCazV2jQPnZYCgDoTXIAxlYoBemEHWaKnds\r\n/b5xQZ5peUdHJCluxjVupm2jajdu2NlDdMY5F8P8uxidEft8qczxOF9D4aJxW6FzjhnwmYVKNXL3\r\noGOjyDkj/BeYDhQfCLv7BwmFRQalvys8UzWbrvCP00Vhig32nE1Gumeiw7Sy50A6vBnaBt5hiM1A\r\nFttduTAhWk7BnC0LW8oY8Rpbotb7H6fVUXcKXbdYNDO1tDyqmgDjVBXjXCi2WzTbOz+uykDwoDn+\r\nxYErsyBwcDbDY4cMkqFsBCGpBfU0Q1Ab1yRKKQdpoBeVAxFeWku536keRzOaxPFeC13kbaajxtWf\r\niUqBrP8Q4Xe9S5vbj2KYtxbXMGGeSQldwonBzetB7Cs5B3EBHv3Q+F1Y61nEkOkqEtqvw0nfCVl8\r\n5puplkPjqgvcb6Ds366LLn5cVZPL/U3cCejPg5ZCgLFrscV1FpSutN2b4gKyIYE6eozK3S40Li2j\r\n1lM9FOlAhy52TVo9yfpTwM5yp3VNhDMtuSkJ1WPAFagpy4WZ3TFvkxSW6bKgDdv9W10PtqigmJ1v\r\nhcDdSnD0OdUjtPDGsvJAqFDazLiWHnXDjbxhd3rXwAVMxsaE5SaoMw4WQivzZdq7UC+y/PmPsMp/\r\n/HnLHhqkIBVw9FrTzpxfPTFkZUeDqCsTttsBNagDqkMnVtITLB4TX6S1HWnQkdHV0iP89qRoPa9r\r\n6YkBj7zF8g8bIpM0hNsaCiB8Qu9BIAUloSrXoRjE3QywtxnnXlNVQusq8lGu0gJCM2+pkzc8pqeE\r\ntuQ/CghteRvMFBH8YCO0LCK0TkI39ZDQTgGhO3H+6hKaAfhG1UR36+HYCqZ3rVJA0Y1FVLctQnh7\r\nb4+mrx3zVpTL1XPRbYREN/OotapytEoMCwcHeCnmAsc9Fx9Ss9yHujrosWg2QUKMG3RgTGQKwBgR\r\nOJ793pE9BWPCs0L27pWsVFjFPdpN0HIVQnzz1MrsgXtSZw2TgmADVvJxfz241Ks1nwJhr+mqXoEo\r\nbMpycw+2vO0S9rpvYJ7mhVTcZawyXEU9OvujfNJ6173mbcYtxY1GZAIbJMS1eleRpsS4vKNXA976\r\neDA6hKpUyL3IZ54ctz6JinlXBeK9UEUJfxGQfTUNJt5Q3HCh79j215lO9py4AGrojCU7qmZjQSuF\r\nrqrCS0xoGyyEVqI2XILLkS7TlOLOGVU1SlXdks0hjm5MOlU0gepN/jcNRh4WAAF/IwP7erKvJtPe\r\neSy/FAJ3S5nTPBiaiKn4MUd+t4gDhXzLtP0fxIodw6AE0GzvlwzbCuGkZ81qBvMrZV14T0Wkc97e\r\nkwA12shpWQtNQpagT7VPGOCD9UsY+QnChAIpZb3htBwTmzFSmf3y9UfDbsoHWVOlevtNqm0fgKW7\r\ni+p3WdKmfhc38EDFiwnVKKUrUOlk+ahtkgNc5aHPbd9fd9x79K51P9XzyduSMWPfGTfGAriqEnA4\r\n/cn2bmFQSHVXqONfrdJCC9oQyRYo7j+MG0rE0lF48CsMUeiqBEJ9lf7VgeyTVvHvDe4JEQ6ITNL2\r\nJsat4qsML2nvXMxNODnAZ9OZqjZWow85KJJaqGKpUsyW/H1sccuoUtv/PkT/P0N6YZveg8mIu3/G\r\nKa8RdwR1uv3LQOi20NbUxELsuZjqKIMOQNDrw0mNOqsq2n5dVYMDlZvMYdRmRNipBTSelp+Nq08r\r\nfy0r+hal4vj1VE16I9zXbGw5VLfdC3RVZTB7SNW5GWI2KTKHUYMIVzICUe5U8xTnfKzGqGqIs1BP\r\nURC/ozXIk3PVnideUBPeP4oy/RlcDugfl0smKlswi5/LUHkM2ZpslKOrXbuavnND+Ix7Yw3wNzTH\r\nnUaQWc1rqJYSjje+OJFfLksCaMb1zqnqiFDH8n04CsttCvnoyB6YUrsHUPOyn9RZVySihodmuS/G\r\nLrnA2h2N3tFQq54zQ9Gl4LhXqh1WhPv+tdk1O5HhssAJ1eTmwExZaG8wg/qn0/WmtiPiSilVa1T4\r\nL0TUcMlqtnvd8N4ArnnrzDiAsuURVfDXs+hqfHtwAMp0UegwMYKC6jdUsyN7UC+0qzTy2zVb3lFN\r\n2zbOe2PRVsTic45/cdwqBYwrYxoPMFA2QmzT5qD3Wksl9oDUWHM6Km1WeILAIe45E7b8mpH2Xwq3\r\nIMCKbTaraLDHYnwwTGjGqlcNaQtvBMDW2nBxHfre6bGLCYq2U3XIbDelhzI0VOkM4VpsEdGLhvr1\r\n+wLtPVCiyGoHFsHlccUTUaPpuOMN1Qsj9ECO95ouIPKqwtGyiKOpt1cH5HlHG3ZmsV5ce2Up5mRU\r\nXGSsFo6TvSKqkB19BDjn7ezS07umPeH/tFSbAs3yV7LGSez931L7/wNGCHSorEHs/6Pq3QP6K6FV\r\ncL1FiRQuyC7bSJCepBMzLSmoNxpZsGZFIu1d2JsqYvBgduabEKuR4lvp1Y739LlxzaKQAgnRchyQ\r\n8MKI83ZgMh/eWgtQbxBa9cUC0MoDroJ5SNhuIwkWO0pWhUMr7SZyfrHwG0am/WN732APtQjocqoh\r\nShRgFd4GIOlr41b0UzojwAdUtbVRDUkTQj4UO0y2FwlNlyqJXKK64TLu2bFLVgaGpP8r2T+bRpiU\r\nd2Of+QMABM4Me5/CFfRYYS+ul0aVc0jJq6NqmLHmKPX4ANjENxJUj9DMFXePABe/VIIgLZifycN6\r\nUFAumc5eWLaHNjvUW+4ZfWbPHZFe8TEGuRmlCr4CKWpW5j0jnTk3diWEGS275YuqtUf1sTIc9xXD\r\nkWdT/YhjFdpaQvNarKnCOGqoPYtKlYhMOt7N42LanzlHTG/Cs7lliLwBc3pvr5SzKIs0LW84CLKi\r\nTPV4qgFvQT0YFrcQKvcp087eG1UkPV+ZDwhd/nZ0k38wpUAlBO8poXlu5pexoJ3p+Nfmt5Yt0VJM\r\nTo1LCN4/1UiNXXOcsuWwl7D9Y597aZKz2/aGDvx0uUryLJUE7nud9mVVWDwGB3LC6NYz7BLFy7nC\r\nhZti8lnS2vA5VXi9jNcrLqGV86N+7S7MqoCqk9Qc3ylZslolz3l/ieVixVzQ82QKV1N7erma56oS\r\nhP/QCLHu00O2xdAt1YKo7EpU3dwsuQwA7RL2z4gTY6asTY4qXr5aL91aKIN7mG462TFJu+1rnGza\r\nlMNcblgRhLYKCU3wpMJ0oRIxcoORqSDuM7i2V0pqUQ3CPPwmjgmYc6DMmyxwa6kKgVvKFmZnNwAa\r\nj7ZVXRelCgQeqI4KWgaw2cmNQKtHxam5RdMhXaSmLedH6NldpYen+jsK92a2BiShGIPGCgqKcxzV\r\nJK3QBCq8u9kklFUD+N1EAzvD+hfgen+BJGoqKU3eb79oua/i+0acGDBKHmVgEfKvRanD0ddpY4uK\r\nPt+bi5V7+V1M7tsVNU8RqlL9P3SROY/cXamHijZdIy1PVOJXqGS/zeUaj+LI4FgIYj5Jmzm2jomQ\r\nLE2he2TGiaWn5CUg2I1KVRLeIjYtLS4KFzJrYj/VHHm/bmW/Vbl0ym1Paxa3MXDyC1GF4kq0S1yg\r\n2fLkIdt60EKjO/7v9G67y3TtESHfhii6gQ9AbqoEmVOscqLyEaSz80nh3XalZbsjJghEtRJUn1lM\r\nb6moJRJ/32wK/yUVHMHaIRWIUtV5N9W2jy5aTmVMNysvVtz/im2ShfurYQv7Sc01xkiBaC/Gaxwm\r\nN5DLQIirNTszVPXFqMAmzP2XJTB01RhchdOu2soWhd22Jg7s8H49Y7JV1aQK7pOaxuimDQeqIvaC\r\nif+q096Gyq/N/HGA3ZjBCr2vbomWU4qS5SvqIOsx+nMuu6Zrtl9H8x6tTt25KLnvqrZCQv4U+/fD\r\nZtAcPLOVDUhz+YD7TYHhw58HVP+Qyeblln9sd4V0yL3cknhfWkrqLCKX76rbGrtloe0vYujRkP42\r\n+JAma4eJaISaF9mdZfbyDTTYq1AiijjHG8PCLixuXsc0HgA/gjgCH3ILEwHIWQEyZ2MTqbNyj2nJ\r\nd7aK2MFv3wax7mJMFkODuKh4PR68Nu+B98J74r2x+bjJTnUie2EQnOFD0vgrSnGw8gmwJ2fpuchQ\r\nS6luPFgVR1392r2gSk2NnGghN7KNAhbCW92tcD3QzZtZPiNv4L/PsN0bTeH9CoT8WQCu3PF6yp2o\r\nvGkWRSrQtmA6rmrXuzVcvZnhTbjPGYmUd5Nmeb9U1xDuhDpcE4twAu9B3YutiuDeHzQfl6+yaBzw\r\nysZuFhIl2BI9MJAUf1eV+ZBTxvT3emvkAEzEzMi9DvogJugeTMg9KpdLVb6tlAByUz4Wa12gV3ur\r\nmB8MzmnB+9bAPFq9rvLK4R80N2/N96VS19QDF+063kssbMBnFXIxo1o0SJ58j+qiBQk1cKbW5B88\r\npL8PptTkMzHSUb2hMDkNACgTGVCoKunRUB8LpAysI6hl7s9nI3NIhRHEFEYQjF9sy3c8R7k2B8oI\r\n2ie4P4S+OC+yKxvTcdK+zr01XzX4lxTReL9SZ0UFW1ZlklUnWUtN6GIsptUhju/UKBUs73Ud39Er\r\n7zrbbf9pcGuH6kxv+0+z7SFBlYqiteUohulGRugIOQ/3M7RfNgfvxl+7KybxxyDa4qgWvZiQBez6\r\nrgwnDFJPZQ9lCqjqB6lqUct5qhKS5fqsWlSBqGUyQQeLtpmqCrHPeKupbNidZPNx1v/o6gJkHy0h\r\nHzGF++2E5V7EtF18V+iBLzmjCa+jEn1XZxK/cD2CL3x/Ls7zIAvasnpxYnbLl5ggF5TcUknxi0r0\r\nylqkN8hhcYvz9Y+Ry21H+69Oo72Qr0W2TgLowWq/zmzwD6ITgYYTZVaF7qgC1x3vNNPyxhiWvEq1\r\nMLSAqh35WFDLw3uGiX+m4z/MYnTKAmZ5v1BIOeV+R5WCYN9mZnsyASHC1s3OPOQg7bXcrspqxQbk\r\n6eyJhuUnQOgrVPlk1cqYC8JnkuEzvDYI+ZhC+E6WDcCvMu3MKHJjnWg9bJTdfsBoPDefhc/E2Gue\r\nR1ddb2SUgYfS5tyBXe0BE8yHDlya/oISBnu2G36cptTwig6sSs27BuE1rZ+ihYmVkMghbAPMV/bY\r\nYpgR61rXvZLbg2pPVDxVpd4r6u+M4OB9s5WROveslsJr4h5Y5VBVNcC9MXA/bM5V5acsdvzzpgcl\r\nl6Ncm3J+Mp0dFuRPDbxC9EXEVmLczp4JkdpYyg1HsQZOuSSoBlD9h+7NKNCiSBHlJJGXacJfXKYl\r\nsQ0JcnpghBnoRC4AaLkd2RoAyPK5EmpJp9IxGbmS9o+vdkZlXxA638PrJKDr6cAW2UhbvCU34zmf\r\n0YAb4hZ/HTAjKDLuHk5dOrLR6L86ytKlib07Vb3cqN4k9Pu9NIgTNNtfXcpgA6nlJwAQuW8POHTd\r\nM3Np295BgHrpUCTuaQF69q6qq0Jfyt4iNBuRqepDjtedq3YZG45zXx/ynzSYTakL/4fYxyzVmq+0\r\nVYu68Fu6yN6QtL1vsB+HEutxE9aqQWhck9emyKVhgxUHcG/LykeHUKd2X9LTbacPpoJ58b1eaf8g\r\nw3b/FCTv+RvLBxv667AoHmcIE39HZMy9X6HsbgjfI0KTsDi3cjk25PYcrbjXv4BqnVZUVSnswIG+\r\nLLAIHP8PyTnxqyAPyjFUcYh7BibmSejBa4zubcgb6RiADn2nsjZZ2W8p/XW+3HPMwtwu9C5Rj+0a\r\nNxYdM/bvbEp+l7+hisdzUG3K1wo7gTHqtM/rjopl39SdH5k2caXfO95pg6m+adUGoxzNtBwFotPJ\r\nv6YSpwEIsFFVNRTyBXD7Xxlwh8/OY7ZhYACh8WX9vlhAj4YtYzjuV0aVBnkgWyQmoBUwvlqVprD9\r\n27CY6sHBy3Xb31hJoAC+twq/f55xZIOpm0CvDWMWiCO8sWbKfZGAjWG2FYffBF4yBiAsw964IKif\r\n6U/HsbwQLKnWi8vAeU/hu0K3Vd7XMj0I3d1UYajPlnzr33eVq9KSo3nvNQrGNjy07Q3u0sAhD+uO\r\nuyDvLty4zT1SQdRrCyTPAs3yp3HfZlRM7Fyr2iig+Hb6QpVheBpt3uCcp/L24bV97N5sz4csL0rY\r\n3pNaUKT2VIYL12hUbYPLwoU7GLPWHUJzKh0YuiUfwAIQ2Jdfw366Nt+VtRruxi35dKA1ICYdMpau\r\nolzk5SDw/4B7Dx4M/bkGxCA6ZryW2egfpwe1RX8O8DVFt9wnQPhZqlSWkG+CUO+pYmx0LKhCO6z/\r\npYLiaZljwZpmhQOEt8RQbkb/JeVksRhgLy9XniXLPzY5p32/gdS4fNCaVuktYvtEVjMiYSjqAwQt\r\nR+L9BOyjl2op/3Ij5V7BQ0vJy5WlSrgT+B2F1NkB1/GO4TkSs1d9gsV0BkMR2tqojdqojdqojdqo\r\njdqojdqojdqojdqojdqojdqojUE8/h83bQ22GzqTdQAAAABJRU5ErkJggg==', NULL, NULL); INSERT INTO `frame_optr` VALUES (2, 'test', 'test', '110205366D6384D1D4165E380BE8EE3B', '', NULL, 'Active', 'revisit@126.com', '13588866675', '027-88899975', '湖北省武汉市武汉大学茶港', '027-888888785', 0, '超管', NULL, NULL, NULL, NULL, 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAHoAAACACAYAAADEUH2bAAAiA0lEQVR42u1dCZgcVbUOKouyuwIi\r\nICqIiIKAAj4UAYXAU3xAfCwmTNfS2QhJBDGgYFQUEXgii2IgbLJI2AkEwzYk03WreiYEE7IAARJI\r\nyDaZrlvVM5lMkkm//7/V6HR1dU/XpGcyM/b9vvq6p6e7lnvuOfc/+5AhtVEbtVEbtVEbtVEbtVEb\r\ntVEbtVEbtVEbtVEbtVEbtVEbtVEbtdG3Y3J97kNaKrdrck7b3mZj9tCRjdlvGZZ/hia8EYaTHWs6\r\n/iWGLS83bfcXPNR7gc+EN5bf0Wz/B0baPz7hZL+UnN28t5Zq3vUEnLM2s9t4DMvlPpisX/lxLe1+\r\nVbPdH5iOO950vBvw/lFduLMN23vZtP2FuvDeAlFXGLa/2nC8Zny+Ln80q89sfzm/o9veQvx/jiHk\r\nLByP4LMb8J2LsBj+OylaD8PfHx02bdoHazPfF1yby31glJX9pObI7xmWe7Eu5FTdchsMx38NRHlP\r\nt6WH140g2Ba85np4bMmfQ4Lb38PxmsGFY8nbdNudaNryZC6wIbncdjWKVHkk5+S2B0d9neJWt/zH\r\ndMdfAAKsAWFb8bp5K4ha6cFrZHGsxvUXJIR8FItrktEgj+Tiq1Foawn8XGZ33fa/j+MuzfIWY6Jb\r\nDOFvwCR39gFxIw+dHC+8DbwXvF9kOPIO3fJOP99p2a1GsZhjuLX6k0baOxd77lOY1LWY1HbdjiWO\r\nN5qWzBi2u0x3PO7TTVgcs3RHzsTr0zjXDEiHZ/F+Nt7PIcEgHZbhyCixHYfouDccq3Cfj+N+z0nM\r\nzX6iRsHuCDxv9c4gwP/qJLDjuZjATRVNuOVldeHPA7c/Au7/vS6yI5UkaPK+DiJ/nvt63SvuHsk5\r\nmd0pJdSB9/yM/xvpeF9I2N43iLzNdHYUfnsN3j8K4i3A/bRVurgA7JqB9B9POPLsYQtzu9QoGjFG\r\n2f43IQbvx4RJHJWIZmmkvGcByC4jOCNBA/Uqt/0J9fUf4t45efLkD1QEmvAdfpe/4W95jvOd3G4j\r\nGvyDzLR3Coj9c1zveQDALBB5N/flb4akaMZCvTuJxVOj7L+AFvRe26Ne+w4mp7M8GnbbwL1NSVte\r\najitXxk+c/XOfYV+h8/M7Wxa7uEEhLiXuZqdaTfKbSeO7MRW8Cakw6V1ja17/WdSF8QZtyS3o2Fn\r\nTwAnzoCIbC8nEiFGoTp5D9AAMqZ+24vEMQvX7qJZ8izo2A9pKezPtg91zI8kuinkehyPGSn/+Lr6\r\n3E7/MWrZsGm5D2qp5n1A4PGm7b9RRgSC+C4JfAsXRH9VYzQn+x1sH7eC6CvyaDz6eYRcBEk0egy4\r\ne9CrZNz7DCfzFYi0W/TAOlUK1Kw20v5tuuV+ayBMChevkZYnYgu6E/e/piRyt7y1WNzXj6SZdc6c\r\n7QclkeuW5nbSaX8W7qPY59YX72lKN84YlnwWqtFZtDUPtO1odIPcExrDOQq4CelGYQ4Qms/+oGb5\r\nx3L7GlREHlO/dhfajCHi6nEUAy6KPOEtBpf/ZpTdfsDkyQNXtJG7TaB1EPpqZZqlgSesDgq5RRPy\r\nOezz34OU+8hgQF3bjXNadoNeOwwP3hi9d3muSQOGJc/mgoiSBOQUItdE4/rPQER+NmnJz/HQmuSB\r\ndbZ7gFHfsi/1YerH0F932CrAQ1UL56CezXMaDs6Na/Ba71/XmCU/m2hs+Uxd/dq91L1FgCzq6MAh\r\n51FC5VXGKIOLbTjuGcPn5XYe0GSm+AUhz8UxN8qqhIkIwFaDPPJ9AvE35GqoJ0deIORJEIXDdapT\r\nQv6BoIf6KX5/H16pc9+LbeAOLJSb8HqVLtzxejo7zGzMfpseJ4K+QDyWITyuycU0Sqz7NPEDgR+N\r\nNthiJuD8V+H1Zj3Ye+/NX/M+PA/v4S8mjTNK1fN+jHs7CWDra8AV+6sFm9csqEvjO1NwjlUlrHtz\r\nADrPTM5ZOTA5e5jIfZhcSp0zyqig0ytkyZ+TqMpiNcf/Ij47FarUTyDWbsd36jFBSzA5a/Hq43cd\r\n1E0j0CyPzcoU6Xgu9Nb38Nv5+PtpEOmP+K1hiuy3SYC6+qU7vX9/E3F/akGRsI5M0sWpTKNCvorz\r\nrMxzYbtymkQZSXAvphLLrq8BgGm2fAPXelGzMlNMahSi9ZQ6se6Lyl4vvM/rjvsrPk/eQRKWai/T\r\nKkewOuDQNR5+KDitMYKTO/BgjaaVHaM1uF/VZ8uTtFRmEgEKJnQxOLg1ch/vwYHrb8Ik05SK+8Di\r\nETI5Mi2PynvCRlMagKhNCjjZsipeMHXvwsvSF46//65b8tKkUsHcI3CtCSD2XDUHxb9NY+GfOGD0\r\nbKpDZqN/nO7IWcUPI9drwrMwGZcwqiPv3LcxCX5Mp0UPD38VOHcm3nPfXN3rni5IAhBW4jmFnvav\r\nVyLelj/D5+nAThBWv+Qsiv+Bwc3C/yI9OXpYtRDgLtt7g/ub6fhT8dCvxHAYdEGrXgfO3abbbmte\r\nTdvIz3uRYOTQjdgG1vOaENF49Tu0mNdUvnNbvqw7/hT8/Te8f9sMO224RVje4wR8/ZrIulj+Udzw\r\nn7EyN0Tsox0gyHK1NzvRKLQLQTdzQnEsxaJowN/TFPix5DUg9BUJBYDciwOQ5l2hpeTVmLRbArem\r\nXJ7fs3tK2E10WeL1SZz7Zj0lf4cF+gs9f01eWxPZKyCSr4HUuhX3x3tLBb/BIuhu2wm2EqqS76kF\r\nVPz/Dmx7fxqR9j/WP0U2dF+sxotUcEAJboS42lTKM5XXLWkta4Qon6rZ7k9ULJhoOU5JCag5Y/Hw\r\ndPDTmUH9k6/8jHs9iDwc578Di2GpWaF7swyh3wQBp+hp7zy9Kftlxov965rzVu9MlZGEMJz1+xr2\r\nukMAyo6jmgS9GYvPvRMSpwnnwDyU5PpOPQB5W6LnAgBUeBf2S6sgIyhx42/Hj9iQm8EZb4DQ9xlW\r\nZrTm+P9FXZmOg3LAhOqI2dh6OCeEoAeTOhfcsDJvb+6xKNeDeLN2gKkVFLWGyN6ngBtUr7KWrLxq\r\nOBr6Nk23wX3Jv6vgROFvih23xnApzGn/snw1tu6Flfxs977aouN1HH8KrGb0JzfvmusGdar4MSvz\r\n5SB013sOr8sjgU21DsHoFvkuARyBVBIqEyNQuwOk5HoGNNDjpmz7lnwrbpQMRPgTWqptn360N3tX\r\nxgNW/moAmjsZazVKrP+0MpZUYLEam859DJw/Ejrni+C4NZWG/WiWu0Wj+iQkJs9Vh2G5m/hZDFDF\r\na60BsZ7Xha+Nc3IVxYiNm5HbkSKe25CuQJgKOa40VKkF+vqkfqFyGenM8aaQb1QkLh2f+qMNItXR\r\nbDluxpLyVquu9mOKadu7S8Vn0f9bjrABkFsBMSyURcuSv9UZ9225dYbInMt4NBC/Dv8fj4XzO3Dt\r\nfcF9yRXd+MZzed/zSurgFzS2HFqxKXhJQHAuVMN2X65skcpOLJB/1qUy21aEj1mY2wUP/beyfth/\r\ngy0X37uLXpvk9MrNfYELEIRRpsIIr9e/CdCRV9/uB4i6UEvjOnMy+yVmZz8Bcb877cnDxPIPc8J5\r\n8P0l+Kyu3t2D39Gt9v01J/Nf9JMrQ4fwGB3SUYYI6xMCBHOyZ8eZM4I6XYVNefdDwvgVcHYWi3YK\r\nw6S2GaFNO/sjcMaKCrgZXOhNTsxq+Ux3+1vBXlef+xD278twjXUqFivSxwtVzpJpAJ5Jdda6o4mG\r\nSUQukJ54nvjbsQpRe8foKsRJcV+phdyppdwWEOynccyXjEsbQweN8K8upaWEEgqWmE72rG1CZHp2\r\ngJYfK2HO68ppy5nfpEKAYuw1am+z/etwlJ5kIRebUMOI0odNW7hDNd2bBFTEDspODd0ZYPPNMjFt\r\nDBq8moskjpeMzg/MzYTuiK182JBUnPO+90zZ8keKiOVuENwOQtTFBROTp+V2UIaX0jq3i0U2ZRR0\r\n3D7RNSdP/gCDEcGBd9OOXeJ524yU98fYwQSYGxDShOTIlMc31FDcM/uUyBNeye1hOO5D5WOkvDUA\r\nN6PiEpnRltjDrjei9kfhbcbioZfIiMU9VRokoul4YzThL41ahFD3PMXZC9fGDmAEIcfm037KqHne\r\nnec1yD37zp6d9k4HIZaUWYEZ6rlx006HKmTqT8JkZaOiUICcZ48UrSdtc03Dkd/FYktHImdmllju\r\nxRPjLkQwhO5kr8xnfpTaBudhMQ3tk4dkNAXtzoYy0kfezHrD8v4c90EV8HK8c8wIcKcHKTkzaJ3q\r\nL7aDOpE5TBPu82FVj0YRqERvJNNy2OSYC12pYMoXX0r1kj62zOviaC09N440eV83lJst0tDQqaf8\r\nF4mu465mLSWPCtBzoWNep4XI8WfQ3t3fzL5m2j/IdPwX6ZkLLXYaY15SLseYW9eFqeZ9sC3OjtJk\r\nIEW2ABTW11ne0b0bNQL1I2m7E/MRGBHB6u4KhtTE3vugx0KNmhohJToTtmcDbX65v3rsyNlmSjrh\r\nPRsL1APH38yEwdgLqKn1ZEO475XwDbyr2dlRVNF6b2+e3by36bj3mNGGiw4sgF/HDYehdUxZixzv\r\n3WhbuHtCf/fBEzdgu3o9wta/BNyZCCyAcbbHpTsZlv/byAhSoPuEkLcyHq4XbdryJN2STZHGeXw+\r\nIpXZL/YkNbhfBSc/F7Ev0RChDxkAQyUm0MMVuFkL7OO64z2ux5VIaivzD9ZEVCiWZFDl7F7zbBFY\r\nGCIzNu/JCftP2w2RTfZggj6CyZmkB5azAhuv6chbaTQZMkAGfdaMHtGLKjDQu+ZdFDd+W3F1oHK1\r\nRcz3W0D2iV7J9kjO8T+OPfimKPssCJUynNZPxZ8c9wjc9DNF3Gy5CxiuO2QADWWTT3nHQNzOD0XX\r\n4NnkI4HGEAOYkauVb9triJhvjxEupEn1VyzEj8nMx5DNGYTqMAEOeqZKZMZiIt4JcUAbzZo0aQ4Z\r\nYEPlZ9s+47xbwxyoYRtSgf5xHSDCHY852lBs/vUfYnRLdZ+AyrzwTmVJpyKXoJDz6xzvC3HVCGY/\r\ngKj3RTgMUlRbBmJ6aRAB23o4mCEVUrc2YMtj0uD+cc8XhAnLVyIMM6Lq4cHkLsZEQ2QsLRIjaf/6\r\nuAlxjCKBmDstnMGh06TqyEmMyxoyQIfaq4V3JfOiQyDKUapnTMKwJgqjcIoQvQpR8kZUFLQRRyTR\r\neQ8OlEV5U448K65KpTIrhbwsnDoLlLmY7sGeuBj7DwKfsz0JymSE0CJex+DJuDZ6ZpSMdLwf43wt\r\nISeHpJm5qlmnLD8BUHBn2AJE+D9ydvZLcd2DSahh+bCazV2jQPnZYCgDoTXIAxlYoBemEHWaKnds\r\n/b5xQZ5peUdHJCluxjVupm2jajdu2NlDdMY5F8P8uxidEft8qczxOF9D4aJxW6FzjhnwmYVKNXL3\r\noGOjyDkj/BeYDhQfCLv7BwmFRQalvys8UzWbrvCP00Vhig32nE1Gumeiw7Sy50A6vBnaBt5hiM1A\r\nFttduTAhWk7BnC0LW8oY8Rpbotb7H6fVUXcKXbdYNDO1tDyqmgDjVBXjXCi2WzTbOz+uykDwoDn+\r\nxYErsyBwcDbDY4cMkqFsBCGpBfU0Q1Ab1yRKKQdpoBeVAxFeWku536keRzOaxPFeC13kbaajxtWf\r\niUqBrP8Q4Xe9S5vbj2KYtxbXMGGeSQldwonBzetB7Cs5B3EBHv3Q+F1Y61nEkOkqEtqvw0nfCVl8\r\n5puplkPjqgvcb6Ds366LLn5cVZPL/U3cCejPg5ZCgLFrscV1FpSutN2b4gKyIYE6eozK3S40Li2j\r\n1lM9FOlAhy52TVo9yfpTwM5yp3VNhDMtuSkJ1WPAFagpy4WZ3TFvkxSW6bKgDdv9W10PtqigmJ1v\r\nhcDdSnD0OdUjtPDGsvJAqFDazLiWHnXDjbxhd3rXwAVMxsaE5SaoMw4WQivzZdq7UC+y/PmPsMp/\r\n/HnLHhqkIBVw9FrTzpxfPTFkZUeDqCsTttsBNagDqkMnVtITLB4TX6S1HWnQkdHV0iP89qRoPa9r\r\n6YkBj7zF8g8bIpM0hNsaCiB8Qu9BIAUloSrXoRjE3QywtxnnXlNVQusq8lGu0gJCM2+pkzc8pqeE\r\ntuQ/CghteRvMFBH8YCO0LCK0TkI39ZDQTgGhO3H+6hKaAfhG1UR36+HYCqZ3rVJA0Y1FVLctQnh7\r\nb4+mrx3zVpTL1XPRbYREN/OotapytEoMCwcHeCnmAsc9Fx9Ss9yHujrosWg2QUKMG3RgTGQKwBgR\r\nOJ793pE9BWPCs0L27pWsVFjFPdpN0HIVQnzz1MrsgXtSZw2TgmADVvJxfz241Ks1nwJhr+mqXoEo\r\nbMpycw+2vO0S9rpvYJ7mhVTcZawyXEU9OvujfNJ6173mbcYtxY1GZAIbJMS1eleRpsS4vKNXA976\r\neDA6hKpUyL3IZ54ctz6JinlXBeK9UEUJfxGQfTUNJt5Q3HCh79j215lO9py4AGrojCU7qmZjQSuF\r\nrqrCS0xoGyyEVqI2XILLkS7TlOLOGVU1SlXdks0hjm5MOlU0gepN/jcNRh4WAAF/IwP7erKvJtPe\r\neSy/FAJ3S5nTPBiaiKn4MUd+t4gDhXzLtP0fxIodw6AE0GzvlwzbCuGkZ81qBvMrZV14T0Wkc97e\r\nkwA12shpWQtNQpagT7VPGOCD9UsY+QnChAIpZb3htBwTmzFSmf3y9UfDbsoHWVOlevtNqm0fgKW7\r\ni+p3WdKmfhc38EDFiwnVKKUrUOlk+ahtkgNc5aHPbd9fd9x79K51P9XzyduSMWPfGTfGAriqEnA4\r\n/cn2bmFQSHVXqONfrdJCC9oQyRYo7j+MG0rE0lF48CsMUeiqBEJ9lf7VgeyTVvHvDe4JEQ6ITNL2\r\nJsat4qsML2nvXMxNODnAZ9OZqjZWow85KJJaqGKpUsyW/H1sccuoUtv/PkT/P0N6YZveg8mIu3/G\r\nKa8RdwR1uv3LQOi20NbUxELsuZjqKIMOQNDrw0mNOqsq2n5dVYMDlZvMYdRmRNipBTSelp+Nq08r\r\nfy0r+hal4vj1VE16I9zXbGw5VLfdC3RVZTB7SNW5GWI2KTKHUYMIVzICUe5U8xTnfKzGqGqIs1BP\r\nURC/ozXIk3PVnideUBPeP4oy/RlcDugfl0smKlswi5/LUHkM2ZpslKOrXbuavnND+Ix7Yw3wNzTH\r\nnUaQWc1rqJYSjje+OJFfLksCaMb1zqnqiFDH8n04CsttCvnoyB6YUrsHUPOyn9RZVySihodmuS/G\r\nLrnA2h2N3tFQq54zQ9Gl4LhXqh1WhPv+tdk1O5HhssAJ1eTmwExZaG8wg/qn0/WmtiPiSilVa1T4\r\nL0TUcMlqtnvd8N4ArnnrzDiAsuURVfDXs+hqfHtwAMp0UegwMYKC6jdUsyN7UC+0qzTy2zVb3lFN\r\n2zbOe2PRVsTic45/cdwqBYwrYxoPMFA2QmzT5qD3Wksl9oDUWHM6Km1WeILAIe45E7b8mpH2Xwq3\r\nIMCKbTaraLDHYnwwTGjGqlcNaQtvBMDW2nBxHfre6bGLCYq2U3XIbDelhzI0VOkM4VpsEdGLhvr1\r\n+wLtPVCiyGoHFsHlccUTUaPpuOMN1Qsj9ECO95ouIPKqwtGyiKOpt1cH5HlHG3ZmsV5ce2Up5mRU\r\nXGSsFo6TvSKqkB19BDjn7ezS07umPeH/tFSbAs3yV7LGSez931L7/wNGCHSorEHs/6Pq3QP6K6FV\r\ncL1FiRQuyC7bSJCepBMzLSmoNxpZsGZFIu1d2JsqYvBgduabEKuR4lvp1Y739LlxzaKQAgnRchyQ\r\n8MKI83ZgMh/eWgtQbxBa9cUC0MoDroJ5SNhuIwkWO0pWhUMr7SZyfrHwG0am/WN732APtQjocqoh\r\nShRgFd4GIOlr41b0UzojwAdUtbVRDUkTQj4UO0y2FwlNlyqJXKK64TLu2bFLVgaGpP8r2T+bRpiU\r\nd2Of+QMABM4Me5/CFfRYYS+ul0aVc0jJq6NqmLHmKPX4ANjENxJUj9DMFXePABe/VIIgLZifycN6\r\nUFAumc5eWLaHNjvUW+4ZfWbPHZFe8TEGuRmlCr4CKWpW5j0jnTk3diWEGS275YuqtUf1sTIc9xXD\r\nkWdT/YhjFdpaQvNarKnCOGqoPYtKlYhMOt7N42LanzlHTG/Cs7lliLwBc3pvr5SzKIs0LW84CLKi\r\nTPV4qgFvQT0YFrcQKvcp087eG1UkPV+ZDwhd/nZ0k38wpUAlBO8poXlu5pexoJ3p+Nfmt5Yt0VJM\r\nTo1LCN4/1UiNXXOcsuWwl7D9Y597aZKz2/aGDvx0uUryLJUE7nud9mVVWDwGB3LC6NYz7BLFy7nC\r\nhZti8lnS2vA5VXi9jNcrLqGV86N+7S7MqoCqk9Qc3ylZslolz3l/ieVixVzQ82QKV1N7erma56oS\r\nhP/QCLHu00O2xdAt1YKo7EpU3dwsuQwA7RL2z4gTY6asTY4qXr5aL91aKIN7mG462TFJu+1rnGza\r\nlMNcblgRhLYKCU3wpMJ0oRIxcoORqSDuM7i2V0pqUQ3CPPwmjgmYc6DMmyxwa6kKgVvKFmZnNwAa\r\nj7ZVXRelCgQeqI4KWgaw2cmNQKtHxam5RdMhXaSmLedH6NldpYen+jsK92a2BiShGIPGCgqKcxzV\r\nJK3QBCq8u9kklFUD+N1EAzvD+hfgen+BJGoqKU3eb79oua/i+0acGDBKHmVgEfKvRanD0ddpY4uK\r\nPt+bi5V7+V1M7tsVNU8RqlL9P3SROY/cXamHijZdIy1PVOJXqGS/zeUaj+LI4FgIYj5Jmzm2jomQ\r\nLE2he2TGiaWn5CUg2I1KVRLeIjYtLS4KFzJrYj/VHHm/bmW/Vbl0ym1Paxa3MXDyC1GF4kq0S1yg\r\n2fLkIdt60EKjO/7v9G67y3TtESHfhii6gQ9AbqoEmVOscqLyEaSz80nh3XalZbsjJghEtRJUn1lM\r\nb6moJRJ/32wK/yUVHMHaIRWIUtV5N9W2jy5aTmVMNysvVtz/im2ShfurYQv7Sc01xkiBaC/Gaxwm\r\nN5DLQIirNTszVPXFqMAmzP2XJTB01RhchdOu2soWhd22Jg7s8H49Y7JV1aQK7pOaxuimDQeqIvaC\r\nif+q096Gyq/N/HGA3ZjBCr2vbomWU4qS5SvqIOsx+nMuu6Zrtl9H8x6tTt25KLnvqrZCQv4U+/fD\r\nZtAcPLOVDUhz+YD7TYHhw58HVP+Qyeblln9sd4V0yL3cknhfWkrqLCKX76rbGrtloe0vYujRkP42\r\n+JAma4eJaISaF9mdZfbyDTTYq1AiijjHG8PCLixuXsc0HgA/gjgCH3ILEwHIWQEyZ2MTqbNyj2nJ\r\nd7aK2MFv3wax7mJMFkODuKh4PR68Nu+B98J74r2x+bjJTnUie2EQnOFD0vgrSnGw8gmwJ2fpuchQ\r\nS6luPFgVR1392r2gSk2NnGghN7KNAhbCW92tcD3QzZtZPiNv4L/PsN0bTeH9CoT8WQCu3PF6yp2o\r\nvGkWRSrQtmA6rmrXuzVcvZnhTbjPGYmUd5Nmeb9U1xDuhDpcE4twAu9B3YutiuDeHzQfl6+yaBzw\r\nysZuFhIl2BI9MJAUf1eV+ZBTxvT3emvkAEzEzMi9DvogJugeTMg9KpdLVb6tlAByUz4Wa12gV3ur\r\nmB8MzmnB+9bAPFq9rvLK4R80N2/N96VS19QDF+063kssbMBnFXIxo1o0SJ58j+qiBQk1cKbW5B88\r\npL8PptTkMzHSUb2hMDkNACgTGVCoKunRUB8LpAysI6hl7s9nI3NIhRHEFEYQjF9sy3c8R7k2B8oI\r\n2ie4P4S+OC+yKxvTcdK+zr01XzX4lxTReL9SZ0UFW1ZlklUnWUtN6GIsptUhju/UKBUs73Ud39Er\r\n7zrbbf9pcGuH6kxv+0+z7SFBlYqiteUohulGRugIOQ/3M7RfNgfvxl+7KybxxyDa4qgWvZiQBez6\r\nrgwnDFJPZQ9lCqjqB6lqUct5qhKS5fqsWlSBqGUyQQeLtpmqCrHPeKupbNidZPNx1v/o6gJkHy0h\r\nHzGF++2E5V7EtF18V+iBLzmjCa+jEn1XZxK/cD2CL3x/Ls7zIAvasnpxYnbLl5ggF5TcUknxi0r0\r\nylqkN8hhcYvz9Y+Ry21H+69Oo72Qr0W2TgLowWq/zmzwD6ITgYYTZVaF7qgC1x3vNNPyxhiWvEq1\r\nMLSAqh35WFDLw3uGiX+m4z/MYnTKAmZ5v1BIOeV+R5WCYN9mZnsyASHC1s3OPOQg7bXcrspqxQbk\r\n6eyJhuUnQOgrVPlk1cqYC8JnkuEzvDYI+ZhC+E6WDcCvMu3MKHJjnWg9bJTdfsBoPDefhc/E2Gue\r\nR1ddb2SUgYfS5tyBXe0BE8yHDlya/oISBnu2G36cptTwig6sSs27BuE1rZ+ihYmVkMghbAPMV/bY\r\nYpgR61rXvZLbg2pPVDxVpd4r6u+M4OB9s5WROveslsJr4h5Y5VBVNcC9MXA/bM5V5acsdvzzpgcl\r\nl6Ncm3J+Mp0dFuRPDbxC9EXEVmLczp4JkdpYyg1HsQZOuSSoBlD9h+7NKNCiSBHlJJGXacJfXKYl\r\nsQ0JcnpghBnoRC4AaLkd2RoAyPK5EmpJp9IxGbmS9o+vdkZlXxA638PrJKDr6cAW2UhbvCU34zmf\r\n0YAb4hZ/HTAjKDLuHk5dOrLR6L86ytKlib07Vb3cqN4k9Pu9NIgTNNtfXcpgA6nlJwAQuW8POHTd\r\nM3Np295BgHrpUCTuaQF69q6qq0Jfyt4iNBuRqepDjtedq3YZG45zXx/ynzSYTakL/4fYxyzVmq+0\r\nVYu68Fu6yN6QtL1vsB+HEutxE9aqQWhck9emyKVhgxUHcG/LykeHUKd2X9LTbacPpoJ58b1eaf8g\r\nw3b/FCTv+RvLBxv667AoHmcIE39HZMy9X6HsbgjfI0KTsDi3cjk25PYcrbjXv4BqnVZUVSnswIG+\r\nLLAIHP8PyTnxqyAPyjFUcYh7BibmSejBa4zubcgb6RiADn2nsjZZ2W8p/XW+3HPMwtwu9C5Rj+0a\r\nNxYdM/bvbEp+l7+hisdzUG3K1wo7gTHqtM/rjopl39SdH5k2caXfO95pg6m+adUGoxzNtBwFotPJ\r\nv6YSpwEIsFFVNRTyBXD7Xxlwh8/OY7ZhYACh8WX9vlhAj4YtYzjuV0aVBnkgWyQmoBUwvlqVprD9\r\n27CY6sHBy3Xb31hJoAC+twq/f55xZIOpm0CvDWMWiCO8sWbKfZGAjWG2FYffBF4yBiAsw964IKif\r\n6U/HsbwQLKnWi8vAeU/hu0K3Vd7XMj0I3d1UYajPlnzr33eVq9KSo3nvNQrGNjy07Q3u0sAhD+uO\r\nuyDvLty4zT1SQdRrCyTPAs3yp3HfZlRM7Fyr2iig+Hb6QpVheBpt3uCcp/L24bV97N5sz4csL0rY\r\n3pNaUKT2VIYL12hUbYPLwoU7GLPWHUJzKh0YuiUfwAIQ2Jdfw366Nt+VtRruxi35dKA1ICYdMpau\r\nolzk5SDw/4B7Dx4M/bkGxCA6ZryW2egfpwe1RX8O8DVFt9wnQPhZqlSWkG+CUO+pYmx0LKhCO6z/\r\npYLiaZljwZpmhQOEt8RQbkb/JeVksRhgLy9XniXLPzY5p32/gdS4fNCaVuktYvtEVjMiYSjqAwQt\r\nR+L9BOyjl2op/3Ij5V7BQ0vJy5WlSrgT+B2F1NkB1/GO4TkSs1d9gsV0BkMR2tqojdqojdqojdqo\r\njdqojdqojdqojdqojdqojdqojUE8/h83bQ22GzqTdQAAAABJRU5ErkJggg==', NULL, NULL); -- ---------------------------- -- Table structure for frame_optr_log -- ---------------------------- DROP TABLE IF EXISTS `frame_optr_log`; CREATE TABLE `frame_optr_log` ( `LOG_ID` int(0) NOT NULL AUTO_INCREMENT COMMENT '内部编号', `OPTR_ID` int(0) NULL DEFAULT NULL COMMENT '操作员编号', `LOG_TYPE` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '日志类型', `LOG_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '记录日志时间', `LOG_PARAM` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '日志参数', PRIMARY KEY (`LOG_ID`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统表-操作员日志表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of frame_optr_log -- ---------------------------- -- ---------------------------- -- Table structure for frame_optr_login -- ---------------------------- DROP TABLE IF EXISTS `frame_optr_login`; CREATE TABLE `frame_optr_login` ( `LOGIN_ID` int(0) NOT NULL AUTO_INCREMENT COMMENT '登录编号 ', `OPTR_ID` int(0) NULL DEFAULT NULL COMMENT '操作员编号', `LOGIN_NAME` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作员名称', `LOGIN_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '登录时间', `BROWSER_TYPE` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '浏览器类型', `BROWSER_VERSION` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '浏览器版本', `PLATFORM_TYPE` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作系统平台', `PLATFORM_SERIES` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作系统类型', `PLATFORM_VERSION` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作系统版本', `LOGIN_ADDR` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '登录地址', PRIMARY KEY (`LOGIN_ID`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 33 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统表-操作员登录日志' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of frame_optr_login -- ---------------------------- -- ---------------------------- -- Table structure for frame_optr_res -- ---------------------------- DROP TABLE IF EXISTS `frame_optr_res`; CREATE TABLE `frame_optr_res` ( `OPTR_ID` int(0) NOT NULL COMMENT '操作员编号', `RES_ID` int(0) NOT NULL COMMENT '资源编号', `TYPE` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型，Active增加权限，InActive，移除权限', PRIMARY KEY (`OPTR_ID`, `RES_ID`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '操作员权限扩展表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of frame_optr_res -- ---------------------------- -- ---------------------------- -- Table structure for frame_optr_role -- ---------------------------- DROP TABLE IF EXISTS `frame_optr_role`; CREATE TABLE `frame_optr_role` ( `OPTR_ID` int(0) NOT NULL COMMENT '操作员ID', `ROLE_ID` int(0) NOT NULL COMMENT '角色ID', PRIMARY KEY (`OPTR_ID`, `ROLE_ID`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of frame_optr_role -- ---------------------------- -- ---------------------------- -- Table structure for frame_param -- ---------------------------- DROP TABLE IF EXISTS `frame_param`; CREATE TABLE `frame_param` ( `PARAM_NAME` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '参数名称', `PARAM_VALUE` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '参数值', `PARAM_VALUE_TYPE` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'String' COMMENT '参数值类型', `PROTECT_STATUS` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'InActive' COMMENT '是否为系统保护状态', `PROJECT_OWNER` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '哪个工程可以使用该参数', `PARAM_DESC` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注信息', PRIMARY KEY (`PARAM_NAME`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统表-系统参数定义' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of frame_param -- ---------------------------- INSERT INTO `frame_param` VALUES ('FrameDeptName', '启明禾木', 'String', 'InActive', NULL, '顶级部门名称'); INSERT INTO `frame_param` VALUES ('FrameName', '禾木框架V2', 'String', 'InActive', NULL, '框架名称'); INSERT INTO `frame_param` VALUES ('MaterialLocalPath', '/data/p2021/uploadfile/image/', 'String', 'InActive', NULL, '平台文件存储目录'); INSERT INTO `frame_param` VALUES ('MaterialWebPath', 'http://p.hmsoft.cn/image/', 'String', 'InActive', NULL, '平台图片访问路径'); -- ---------------------------- -- Table structure for frame_region_area -- ---------------------------- DROP TABLE IF EXISTS `frame_region_area`; CREATE TABLE `frame_region_area` ( `PROVINCE_ID` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '省编号', `AREA_ID` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '地区编号', `AREA_NAME` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地区名称', PRIMARY KEY (`AREA_ID`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统表-地区定义-地级市' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of frame_region_area -- ---------------------------- INSERT INTO `frame_region_area` VALUES ('11', '1101', '北京市'); INSERT INTO `frame_region_area` VALUES ('12', '1201', '天津市'); INSERT INTO `frame_region_area` VALUES ('13', '1301', '河北省'); INSERT INTO `frame_region_area` VALUES ('14', '1401', '山西省'); INSERT INTO `frame_region_area` VALUES ('15', '1501', '内蒙古'); INSERT INTO `frame_region_area` VALUES ('21', '2101', '辽宁省'); INSERT INTO `frame_region_area` VALUES ('22', '2201', '吉林省'); INSERT INTO `frame_region_area` VALUES ('23', '2301', '黑龙江省'); INSERT INTO `frame_region_area` VALUES ('31', '3101', '上海市'); INSERT INTO `frame_region_area` VALUES ('32', '3201', '江苏省'); INSERT INTO `frame_region_area` VALUES ('33', '3301', '浙江省'); INSERT INTO `frame_region_area` VALUES ('34', '3401', '安徽省'); INSERT INTO `frame_region_area` VALUES ('35', '3501', '福建省'); INSERT INTO `frame_region_area` VALUES ('36', '3601', '江西省'); INSERT INTO `frame_region_area` VALUES ('37', '3701', '山东省'); INSERT INTO `frame_region_area` VALUES ('41', '4101', '河南省'); INSERT INTO `frame_region_area` VALUES ('42', '4201', '湖北省'); INSERT INTO `frame_region_area` VALUES ('43', '4301', '湖南省'); INSERT INTO `frame_region_area` VALUES ('44', '4401', '广东省'); INSERT INTO `frame_region_area` VALUES ('45', '4501', '广西区'); INSERT INTO `frame_region_area` VALUES ('46', '4601', '海南省'); INSERT INTO `frame_region_area` VALUES ('50', '5001', '重庆市'); INSERT INTO `frame_region_area` VALUES ('51', '5101', '成都市'); INSERT INTO `frame_region_area` VALUES ('51', '5103', '自贡市'); INSERT INTO `frame_region_area` VALUES ('51', '5104', '攀枝花市'); INSERT INTO `frame_region_area` VALUES ('51', '5105', '泸州市'); INSERT INTO `frame_region_area` VALUES ('51', '5106', '德阳市'); INSERT INTO `frame_region_area` VALUES ('51', '5107', '绵阳市'); INSERT INTO `frame_region_area` VALUES ('51', '5108', '广元市'); INSERT INTO `frame_region_area` VALUES ('51', '5109', '遂宁市'); INSERT INTO `frame_region_area` VALUES ('51', '5110', '内江市'); INSERT INTO `frame_region_area` VALUES ('51', '5111', '乐山市'); INSERT INTO `frame_region_area` VALUES ('51', '5113', '南充市'); INSERT INTO `frame_region_area` VALUES ('51', '5114', '眉山市'); INSERT INTO `frame_region_area` VALUES ('51', '5115', '宜宾市'); INSERT INTO `frame_region_area` VALUES ('51', '5116', '广安市'); INSERT INTO `frame_region_area` VALUES ('51', '5117', '达州市'); INSERT INTO `frame_region_area` VALUES ('51', '5118', '雅安市'); INSERT INTO `frame_region_area` VALUES ('51', '5119', '巴中市'); INSERT INTO `frame_region_area` VALUES ('51', '5120', '资阳市'); INSERT INTO `frame_region_area` VALUES ('51', '5132', '阿坝藏族羌族自治州'); INSERT INTO `frame_region_area` VALUES ('51', '5133', '甘孜藏族自治州'); INSERT INTO `frame_region_area` VALUES ('51', '5134', '凉山彝族自治州'); INSERT INTO `frame_region_area` VALUES ('52', '5201', '贵州省'); INSERT INTO `frame_region_area` VALUES ('53', '5301', '云南省'); INSERT INTO `frame_region_area` VALUES ('54', '5401', '西藏区'); INSERT INTO `frame_region_area` VALUES ('61', '6101', '陕西省'); INSERT INTO `frame_region_area` VALUES ('62', '6201', '甘肃省'); INSERT INTO `frame_region_area` VALUES ('63', '6301', '青海省'); INSERT INTO `frame_region_area` VALUES ('64', '6401', '宁夏区'); INSERT INTO `frame_region_area` VALUES ('65', '6501', '新疆区'); INSERT INTO `frame_region_area` VALUES ('71', '7101', '台湾省'); INSERT INTO `frame_region_area` VALUES ('81', '8101', '香港特区'); INSERT INTO `frame_region_area` VALUES ('82', '8201', '澳门特区'); INSERT INTO `frame_region_area` VALUES ('99', '9901', '外国'); -- ---------------------------- -- Table structure for frame_region_city -- ---------------------------- DROP TABLE IF EXISTS `frame_region_city`; CREATE TABLE `frame_region_city` ( `PROVINCE_ID` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '省编号', `AREA_ID` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '市编号', `CITY_ID` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '县编号', `CITY_NAME` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '县名称', PRIMARY KEY (`CITY_ID`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统表-区域定义-县市表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of frame_region_city -- ---------------------------- INSERT INTO `frame_region_city` VALUES ('11', '1101', '110100', '北京市'); INSERT INTO `frame_region_city` VALUES ('12', '1201', '120100', '天津市'); INSERT INTO `frame_region_city` VALUES ('13', '1301', '130100', '河北省'); INSERT INTO `frame_region_city` VALUES ('14', '1401', '140100', '山西省'); INSERT INTO `frame_region_city` VALUES ('15', '1501', '150100', '内蒙古'); INSERT INTO `frame_region_city` VALUES ('21', '2101', '210100', '辽宁省'); INSERT INTO `frame_region_city` VALUES ('22', '2201', '220100', '吉林省'); INSERT INTO `frame_region_city` VALUES ('23', '2301', '230100', '黑龙江省'); INSERT INTO `frame_region_city` VALUES ('31', '3101', '310100', '上海市'); INSERT INTO `frame_region_city` VALUES ('32', '3201', '320100', '江苏省'); INSERT INTO `frame_region_city` VALUES ('33', '3301', '330100', '浙江省'); INSERT INTO `frame_region_city` VALUES ('34', '3401', '340100', '安徽省'); INSERT INTO `frame_region_city` VALUES ('35', '3501', '350100', '福建省'); INSERT INTO `frame_region_city` VALUES ('36', '3601', '360100', '江西省'); INSERT INTO `frame_region_city` VALUES ('37', '3701', '370100', '山东省'); INSERT INTO `frame_region_city` VALUES ('41', '4101', '410100', '河南省'); INSERT INTO `frame_region_city` VALUES ('42', '4201', '420100', '湖北省'); INSERT INTO `frame_region_city` VALUES ('43', '4301', '430100', '湖南省'); INSERT INTO `frame_region_city` VALUES ('44', '4401', '440100', '广东省'); INSERT INTO `frame_region_city` VALUES ('45', '4501', '450100', '广西区'); INSERT INTO `frame_region_city` VALUES ('46', '4601', '460100', '海南省'); INSERT INTO `frame_region_city` VALUES ('50', '5001', '500100', '重庆市'); INSERT INTO `frame_region_city` VALUES ('51', '5101', '510104', '锦江区'); INSERT INTO `frame_region_city` VALUES ('51', '5101', '510105', '青羊区'); INSERT INTO `frame_region_city` VALUES ('51', '5101', '510106', '金牛区'); INSERT INTO `frame_region_city` VALUES ('51', '5101', '510107', '武侯区'); INSERT INTO `frame_region_city` VALUES ('51', '5101', '510108', '成华区'); INSERT INTO `frame_region_city` VALUES ('51', '5101', '510109', '高新区'); INSERT INTO `frame_region_city` VALUES ('51', '5101', '510110', '天府新区'); INSERT INTO `frame_region_city` VALUES ('51', '5101', '510112', '龙泉驿区'); INSERT INTO `frame_region_city` VALUES ('51', '5101', '510113', '青白江区'); INSERT INTO `frame_region_city` VALUES ('51', '5101', '510114', '新都区'); INSERT INTO `frame_region_city` VALUES ('51', '5101', '510115', '温江区'); INSERT INTO `frame_region_city` VALUES ('51', '5101', '510121', '金堂县'); INSERT INTO `frame_region_city` VALUES ('51', '5101', '510122', '双流区'); INSERT INTO `frame_region_city` VALUES ('51', '5101', '510124', '郫都区'); INSERT INTO `frame_region_city` VALUES ('51', '5101', '510129', '大邑县'); INSERT INTO `frame_region_city` VALUES ('51', '5101', '510131', '蒲江县'); INSERT INTO `frame_region_city` VALUES ('51', '5101', '510132', '新津县'); INSERT INTO `frame_region_city` VALUES ('51', '5101', '510181', '都江堰市'); INSERT INTO `frame_region_city` VALUES ('51', '5101', '510182', '彭州市'); INSERT INTO `frame_region_city` VALUES ('51', '5101', '510183', '邛崃市'); INSERT INTO `frame_region_city` VALUES ('51', '5101', '510184', '崇州市'); INSERT INTO `frame_region_city` VALUES ('51', '5101', '510185', '简阳市'); INSERT INTO `frame_region_city` VALUES ('51', '5103', '510302', '自流井区'); INSERT INTO `frame_region_city` VALUES ('51', '5103', '510303', '贡井区'); INSERT INTO `frame_region_city` VALUES ('51', '5103', '510304', '大安区'); INSERT INTO `frame_region_city` VALUES ('51', '5103', '510311', '沿滩区'); INSERT INTO `frame_region_city` VALUES ('51', '5103', '510321', '荣县'); INSERT INTO `frame_region_city` VALUES ('51', '5103', '510322', '富顺县'); INSERT INTO `frame_region_city` VALUES ('51', '5104', '510402', '东区'); INSERT INTO `frame_region_city` VALUES ('51', '5104', '510403', '西区'); INSERT INTO `frame_region_city` VALUES ('51', '5104', '510411', '仁和区'); INSERT INTO `frame_region_city` VALUES ('51', '5104', '510421', '米易县'); INSERT INTO `frame_region_city` VALUES ('51', '5104', '510422', '盐边县'); INSERT INTO `frame_region_city` VALUES ('51', '5105', '510502', '江阳区'); INSERT INTO `frame_region_city` VALUES ('51', '5105', '510503', '纳溪区'); INSERT INTO `frame_region_city` VALUES ('51', '5105', '510504', '龙马潭区'); INSERT INTO `frame_region_city` VALUES ('51', '5105', '510521', '泸县'); INSERT INTO `frame_region_city` VALUES ('51', '5105', '510522', '合江县'); INSERT INTO `frame_region_city` VALUES ('51', '5105', '510524', '叙永县'); INSERT INTO `frame_region_city` VALUES ('51', '5105', '510525', '古蔺县'); INSERT INTO `frame_region_city` VALUES ('51', '5106', '510603', '旌阳区'); INSERT INTO `frame_region_city` VALUES ('51', '5106', '510623', '中江县'); INSERT INTO `frame_region_city` VALUES ('51', '5106', '510626', '罗江县'); INSERT INTO `frame_region_city` VALUES ('51', '5106', '510681', '广汉市'); INSERT INTO `frame_region_city` VALUES ('51', '5106', '510682', '什邡市'); INSERT INTO `frame_region_city` VALUES ('51', '5106', '510683', '绵竹市'); INSERT INTO `frame_region_city` VALUES ('51', '5107', '510703', '涪城区'); INSERT INTO `frame_region_city` VALUES ('51', '5107', '510704', '游仙区'); INSERT INTO `frame_region_city` VALUES ('51', '5107', '510722', '三台县'); INSERT INTO `frame_region_city` VALUES ('51', '5107', '510723', '盐亭县'); INSERT INTO `frame_region_city` VALUES ('51', '5107', '510724', '安州区\r\n'); INSERT INTO `frame_region_city` VALUES ('51', '5107', '510725', '梓潼县'); INSERT INTO `frame_region_city` VALUES ('51', '5107', '510726', '北川县'); INSERT INTO `frame_region_city` VALUES ('51', '5107', '510727', '平武县'); INSERT INTO `frame_region_city` VALUES ('51', '5107', '510781', '江油市'); INSERT INTO `frame_region_city` VALUES ('51', '5108', '510802', '利州区'); INSERT INTO `frame_region_city` VALUES ('51', '5108', '510811', '昭化区'); INSERT INTO `frame_region_city` VALUES ('51', '5108', '510812', '朝天区'); INSERT INTO `frame_region_city` VALUES ('51', '5108', '510821', '旺苍县'); INSERT INTO `frame_region_city` VALUES ('51', '5108', '510822', '青川县'); INSERT INTO `frame_region_city` VALUES ('51', '5108', '510823', '剑阁县'); INSERT INTO `frame_region_city` VALUES ('51', '5108', '510824', '苍溪县'); INSERT INTO `frame_region_city` VALUES ('51', '5109', '510903', '船山区'); INSERT INTO `frame_region_city` VALUES ('51', '5109', '510904', '安居区'); INSERT INTO `frame_region_city` VALUES ('51', '5109', '510921', '蓬溪县'); INSERT INTO `frame_region_city` VALUES ('51', '5109', '510922', '射洪县'); INSERT INTO `frame_region_city` VALUES ('51', '5109', '510923', '大英县'); INSERT INTO `frame_region_city` VALUES ('51', '5110', '511002', '市中区'); INSERT INTO `frame_region_city` VALUES ('51', '5110', '511011', '东兴区'); INSERT INTO `frame_region_city` VALUES ('51', '5110', '511024', '威远县'); INSERT INTO `frame_region_city` VALUES ('51', '5110', '511025', '资中县'); INSERT INTO `frame_region_city` VALUES ('51', '5110', '511028', '隆昌县'); INSERT INTO `frame_region_city` VALUES ('51', '5111', '511102', '市中区'); INSERT INTO `frame_region_city` VALUES ('51', '5111', '511111', '沙湾区'); INSERT INTO `frame_region_city` VALUES ('51', '5111', '511112', '五通桥区'); INSERT INTO `frame_region_city` VALUES ('51', '5111', '511113', '金口河区'); INSERT INTO `frame_region_city` VALUES ('51', '5111', '511123', '犍为县'); INSERT INTO `frame_region_city` VALUES ('51', '5111', '511124', '井研县'); INSERT INTO `frame_region_city` VALUES ('51', '5111', '511126', '夹江县'); INSERT INTO `frame_region_city` VALUES ('51', '5111', '511129', '沐川县'); INSERT INTO `frame_region_city` VALUES ('51', '5111', '511132', '峨边县'); INSERT INTO `frame_region_city` VALUES ('51', '5111', '511133', '马边县'); INSERT INTO `frame_region_city` VALUES ('51', '5111', '511181', '峨眉山市'); INSERT INTO `frame_region_city` VALUES ('51', '5113', '511302', '顺庆区'); INSERT INTO `frame_region_city` VALUES ('51', '5113', '511303', '高坪区'); INSERT INTO `frame_region_city` VALUES ('51', '5113', '511304', '嘉陵区'); INSERT INTO `frame_region_city` VALUES ('51', '5113', '511321', '南部县'); INSERT INTO `frame_region_city` VALUES ('51', '5113', '511322', '营山县'); INSERT INTO `frame_region_city` VALUES ('51', '5113', '511323', '蓬安县'); INSERT INTO `frame_region_city` VALUES ('51', '5113', '511324', '仪陇县'); INSERT INTO `frame_region_city` VALUES ('51', '5113', '511325', '西充县'); INSERT INTO `frame_region_city` VALUES ('51', '5113', '511381', '阆中市'); INSERT INTO `frame_region_city` VALUES ('51', '5114', '511402', '东坡区'); INSERT INTO `frame_region_city` VALUES ('51', '5114', '511421', '仁寿县'); INSERT INTO `frame_region_city` VALUES ('51', '5114', '511422', '彭山区'); INSERT INTO `frame_region_city` VALUES ('51', '5114', '511423', '洪雅县'); INSERT INTO `frame_region_city` VALUES ('51', '5114', '511424', '丹棱县'); INSERT INTO `frame_region_city` VALUES ('51', '5114', '511425', '青神县'); INSERT INTO `frame_region_city` VALUES ('51', '5115', '511502', '翠屏区'); INSERT INTO `frame_region_city` VALUES ('51', '5115', '511521', '宜宾县'); INSERT INTO `frame_region_city` VALUES ('51', '5115', '511522', '南溪县'); INSERT INTO `frame_region_city` VALUES ('51', '5115', '511523', '江安县'); INSERT INTO `frame_region_city` VALUES ('51', '5115', '511524', '长宁县'); INSERT INTO `frame_region_city` VALUES ('51', '5115', '511525', '高县'); INSERT INTO `frame_region_city` VALUES ('51', '5115', '511526', '珙县'); INSERT INTO `frame_region_city` VALUES ('51', '5115', '511527', '筠连县'); INSERT INTO `frame_region_city` VALUES ('51', '5115', '511528', '兴文县'); INSERT INTO `frame_region_city` VALUES ('51', '5115', '511529', '屏山县'); INSERT INTO `frame_region_city` VALUES ('51', '5116', '511602', '广安区'); INSERT INTO `frame_region_city` VALUES ('51', '5116', '511603', '前锋区'); INSERT INTO `frame_region_city` VALUES ('51', '5116', '511621', '岳池县'); INSERT INTO `frame_region_city` VALUES ('51', '5116', '511622', '武胜县'); INSERT INTO `frame_region_city` VALUES ('51', '5116', '511623', '邻水县'); INSERT INTO `frame_region_city` VALUES ('51', '5116', '511681', '华莹市'); INSERT INTO `frame_region_city` VALUES ('51', '5117', '511702', '通川区'); INSERT INTO `frame_region_city` VALUES ('51', '5117', '511721', '达川区'); INSERT INTO `frame_region_city` VALUES ('51', '5117', '511722', '宣汉县'); INSERT INTO `frame_region_city` VALUES ('51', '5117', '511723', '开江县'); INSERT INTO `frame_region_city` VALUES ('51', '5117', '511724', '大竹县'); INSERT INTO `frame_region_city` VALUES ('51', '5117', '511725', '渠县'); INSERT INTO `frame_region_city` VALUES ('51', '5117', '511781', '万源市'); INSERT INTO `frame_region_city` VALUES ('51', '5118', '511802', '雨城区'); INSERT INTO `frame_region_city` VALUES ('51', '5118', '511821', '名山县'); INSERT INTO `frame_region_city` VALUES ('51', '5118', '511822', '荥经县'); INSERT INTO `frame_region_city` VALUES ('51', '5118', '511823', '汉源县'); INSERT INTO `frame_region_city` VALUES ('51', '5118', '511824', '石棉县'); INSERT INTO `frame_region_city` VALUES ('51', '5118', '511825', '天全县'); INSERT INTO `frame_region_city` VALUES ('51', '5118', '511826', '芦山县'); INSERT INTO `frame_region_city` VALUES ('51', '5118', '511827', '宝兴县'); INSERT INTO `frame_region_city` VALUES ('51', '5119', '511902', '巴州区'); INSERT INTO `frame_region_city` VALUES ('51', '5119', '511921', '通江县'); INSERT INTO `frame_region_city` VALUES ('51', '5119', '511922', '南江县'); INSERT INTO `frame_region_city` VALUES ('51', '5119', '511923', '平昌县'); INSERT INTO `frame_region_city` VALUES ('51', '5119', '511924', '恩阳区'); INSERT INTO `frame_region_city` VALUES ('51', '5120', '512002', '雁江区'); INSERT INTO `frame_region_city` VALUES ('51', '5120', '512021', '安岳县'); INSERT INTO `frame_region_city` VALUES ('51', '5120', '512022', '乐至县'); INSERT INTO `frame_region_city` VALUES ('51', '5132', '513221', '汶川县'); INSERT INTO `frame_region_city` VALUES ('51', '5132', '513222', '理县'); INSERT INTO `frame_region_city` VALUES ('51', '5132', '513223', '茂县'); INSERT INTO `frame_region_city` VALUES ('51', '5132', '513224', '松潘县'); INSERT INTO `frame_region_city` VALUES ('51', '5132', '513225', '九寨沟县'); INSERT INTO `frame_region_city` VALUES ('51', '5132', '513226', '金川县'); INSERT INTO `frame_region_city` VALUES ('51', '5132', '513227', '小金县'); INSERT INTO `frame_region_city` VALUES ('51', '5132', '513228', '黑水县'); INSERT INTO `frame_region_city` VALUES ('51', '5132', '513229', '马尔康县'); INSERT INTO `frame_region_city` VALUES ('51', '5132', '513230', '壤塘县'); INSERT INTO `frame_region_city` VALUES ('51', '5132', '513231', '阿坝县'); INSERT INTO `frame_region_city` VALUES ('51', '5132', '513232', '若尔盖县'); INSERT INTO `frame_region_city` VALUES ('51', '5132', '513233', '红原县'); INSERT INTO `frame_region_city` VALUES ('51', '5133', '513321', '康定市'); INSERT INTO `frame_region_city` VALUES ('51', '5133', '513322', '泸定县'); INSERT INTO `frame_region_city` VALUES ('51', '5133', '513323', '丹巴县'); INSERT INTO `frame_region_city` VALUES ('51', '5133', '513324', '九龙县'); INSERT INTO `frame_region_city` VALUES ('51', '5133', '513325', '雅江县'); INSERT INTO `frame_region_city` VALUES ('51', '5133', '513326', '道孚县'); INSERT INTO `frame_region_city` VALUES ('51', '5133', '513327', '炉霍县'); INSERT INTO `frame_region_city` VALUES ('51', '5133', '513328', '甘孜县'); INSERT INTO `frame_region_city` VALUES ('51', '5133', '513329', '新龙县'); INSERT INTO `frame_region_city` VALUES ('51', '5133', '513330', '德格县'); INSERT INTO `frame_region_city` VALUES ('51', '5133', '513331', '白玉县'); INSERT INTO `frame_region_city` VALUES ('51', '5133', '513332', '石渠县'); INSERT INTO `frame_region_city` VALUES ('51', '5133', '513333', '色达县'); INSERT INTO `frame_region_city` VALUES ('51', '5133', '513334', '理塘县'); INSERT INTO `frame_region_city` VALUES ('51', '5133', '513335', '巴塘县'); INSERT INTO `frame_region_city` VALUES ('51', '5133', '513336', '乡城县'); INSERT INTO `frame_region_city` VALUES ('51', '5133', '513337', '稻城县'); INSERT INTO `frame_region_city` VALUES ('51', '5133', '513338', '得荣县'); INSERT INTO `frame_region_city` VALUES ('51', '5134', '513401', '西昌市'); INSERT INTO `frame_region_city` VALUES ('51', '5134', '513422', '木里县'); INSERT INTO `frame_region_city` VALUES ('51', '5134', '513423', '盐源县'); INSERT INTO `frame_region_city` VALUES ('51', '5134', '513424', '德昌县'); INSERT INTO `frame_region_city` VALUES ('51', '5134', '513425', '会理县'); INSERT INTO `frame_region_city` VALUES ('51', '5134', '513426', '会东县'); INSERT INTO `frame_region_city` VALUES ('51', '5134', '513427', '宁南县'); INSERT INTO `frame_region_city` VALUES ('51', '5134', '513428', '普格县'); INSERT INTO `frame_region_city` VALUES ('51', '5134', '513429', '布拖县'); INSERT INTO `frame_region_city` VALUES ('51', '5134', '513430', '金阳县'); INSERT INTO `frame_region_city` VALUES ('51', '5134', '513431', '昭觉县'); INSERT INTO `frame_region_city` VALUES ('51', '5134', '513432', '喜德县'); INSERT INTO `frame_region_city` VALUES ('51', '5134', '513433', '冕宁县'); INSERT INTO `frame_region_city` VALUES ('51', '5134', '513434', '越西县'); INSERT INTO `frame_region_city` VALUES ('51', '5134', '513435', '甘洛县'); INSERT INTO `frame_region_city` VALUES ('51', '5134', '513436', '美姑县'); INSERT INTO `frame_region_city` VALUES ('51', '5134', '513437', '雷波县'); INSERT INTO `frame_region_city` VALUES ('52', '5201', '520100', '贵州省'); INSERT INTO `frame_region_city` VALUES ('53', '5301', '530100', '云南省'); INSERT INTO `frame_region_city` VALUES ('54', '5401', '540100', '西藏区'); INSERT INTO `frame_region_city` VALUES ('61', '6101', '610100', '陕西省'); INSERT INTO `frame_region_city` VALUES ('62', '6201', '620100', '甘肃省'); INSERT INTO `frame_region_city` VALUES ('63', '6301', '630100', '青海省'); INSERT INTO `frame_region_city` VALUES ('64', '6401', '640100', '宁夏区'); INSERT INTO `frame_region_city` VALUES ('65', '6501', '650100', '新疆区'); INSERT INTO `frame_region_city` VALUES ('71', '7101', '710100', '台湾省'); INSERT INTO `frame_region_city` VALUES ('81', '8101', '810100', '香港特区'); INSERT INTO `frame_region_city` VALUES ('82', '8201', '820100', '澳门特区'); INSERT INTO `frame_region_city` VALUES ('99', '9901', '990100', '外国'); -- ---------------------------- -- Table structure for frame_region_province -- ---------------------------- DROP TABLE IF EXISTS `frame_region_province`; CREATE TABLE `frame_region_province` ( `PROVINCE_ID` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '省编号', `PROVINCE_NAME` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '省名称', `PROVINCE_ABBR` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '省简称', `PROVINCE_CAPITAL` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '省会城市', `PROVINCE_SHORT_NAME` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '省名称简写', PRIMARY KEY (`PROVINCE_ID`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统表-区域定义-省份定义' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of frame_region_province -- ---------------------------- INSERT INTO `frame_region_province` VALUES ('11', '北京市', '北京', '北京', NULL); INSERT INTO `frame_region_province` VALUES ('12', '天津市', '天津', '天津', NULL); INSERT INTO `frame_region_province` VALUES ('13', '河北省', '河北', '石家庄市', NULL); INSERT INTO `frame_region_province` VALUES ('14', '山西省', '山西', '太原市', NULL); INSERT INTO `frame_region_province` VALUES ('15', '内蒙古自治区', '内蒙古', '呼和浩特市', NULL); INSERT INTO `frame_region_province` VALUES ('21', '辽宁省', '辽宁', '沈阳市', NULL); INSERT INTO `frame_region_province` VALUES ('22', '吉林省', '吉林', '长春市', NULL); INSERT INTO `frame_region_province` VALUES ('23', '黑龙江省', '黑龙江', '哈尔滨市', NULL); INSERT INTO `frame_region_province` VALUES ('31', '上海市', '上海', '上海', NULL); INSERT INTO `frame_region_province` VALUES ('32', '江苏省', '江苏', '南京市', NULL); INSERT INTO `frame_region_province` VALUES ('33', '浙江省', '浙江', '杭州市', NULL); INSERT INTO `frame_region_province` VALUES ('34', '安徽省', '安徽', '合肥市', NULL); INSERT INTO `frame_region_province` VALUES ('35', '福建省', '福建', '福州市', NULL); INSERT INTO `frame_region_province` VALUES ('36', '江西省', '江西', '南昌市', NULL); INSERT INTO `frame_region_province` VALUES ('37', '山东省', '山东', '济南市', NULL); INSERT INTO `frame_region_province` VALUES ('41', '河南省', '河南', '郑州市', NULL); INSERT INTO `frame_region_province` VALUES ('42', '湖北省', '湖北', '武汉市', NULL); INSERT INTO `frame_region_province` VALUES ('43', '湖南省', '湖南', '长沙市', NULL); INSERT INTO `frame_region_province` VALUES ('44', '广东省', '广东', '广州市', NULL); INSERT INTO `frame_region_province` VALUES ('45', '广西壮族自治区', '广西', '南宁市', NULL); INSERT INTO `frame_region_province` VALUES ('46', '海南省', '海南', '海口市', NULL); INSERT INTO `frame_region_province` VALUES ('50', '重庆市', '重庆', '重庆', NULL); INSERT INTO `frame_region_province` VALUES ('51', '四川省', '四川', '成都市', NULL); INSERT INTO `frame_region_province` VALUES ('52', '贵州省', '贵州', '贵阳市', NULL); INSERT INTO `frame_region_province` VALUES ('53', '云南省', '云南', '昆明市', NULL); INSERT INTO `frame_region_province` VALUES ('54', '西藏自治区', '西藏', '拉萨市', NULL); INSERT INTO `frame_region_province` VALUES ('61', '陕西省', '陕西', '西安市', NULL); INSERT INTO `frame_region_province` VALUES ('62', '甘肃省', '甘肃', '兰州市', NULL); INSERT INTO `frame_region_province` VALUES ('63', '青海省', '青海', '西宁市', NULL); INSERT INTO `frame_region_province` VALUES ('64', '宁夏回族自治区', '宁夏', '银川市', NULL); INSERT INTO `frame_region_province` VALUES ('65', '新疆维吾尔自治区', '新疆', '乌鲁木齐市', NULL); INSERT INTO `frame_region_province` VALUES ('71', '台湾', '台湾', '台湾', NULL); INSERT INTO `frame_region_province` VALUES ('81', '香港', '香港', '香港', NULL); INSERT INTO `frame_region_province` VALUES ('82', '澳门', '澳门', '澳门', NULL); INSERT INTO `frame_region_province` VALUES ('90', '华侨', '华侨', '华侨', NULL); -- ---------------------------- -- Table structure for frame_report -- ---------------------------- DROP TABLE IF EXISTS `frame_report`; CREATE TABLE `frame_report` ( `REPORT_NAME` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '报表名称', `REPORT_ALIAS` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '报表中文名称', `RES_ID` int(0) NULL DEFAULT NULL COMMENT '对应的资源ID，如果有值，判断是否有权限', `REPORT_SQL` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'sql语句', `REPORT_PARAM` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '参数配置信息', `REPORT_PARAM_FLAG` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '不同客户应用是否需要修改参数', `REPORT_SUFFIX` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '报表后缀名', `INDEX_FLAG` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'Active' COMMENT '是否显示', `UPDATE_TIME` datetime(0) NULL DEFAULT NULL COMMENT '更新日期', `MAX_SIZE` int(0) NULL DEFAULT NULL COMMENT '最大的字段数量', `CURRENT_SIZE` int(0) NULL DEFAULT NULL COMMENT '当期配置数量', PRIMARY KEY (`REPORT_NAME`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统表-报表定义' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of frame_report -- ---------------------------- -- ---------------------------- -- Table structure for frame_report_detail -- ---------------------------- DROP TABLE IF EXISTS `frame_report_detail`; CREATE TABLE `frame_report_detail` ( `REPORT_NAME` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '报表名称', `FIELD_ORDER` int(0) NOT NULL COMMENT '字段排序', `FIELD_NAME` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字段名称', `FIELD_LENGTH` int(0) NOT NULL COMMENT '字段长度', `FIELD_TEXT` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '描述文字', `FIELD_DATE_TYPE` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'java.lang.String' COMMENT '字段数据类型', `FIELD_STATUS` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'Active' COMMENT '字段状态', `DICT_NAME` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '对应的字典名称，如果是字典的话', PRIMARY KEY (`REPORT_NAME`, `FIELD_NAME`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统表-报表配置明细' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of frame_report_detail -- ---------------------------- -- ---------------------------- -- Table structure for frame_res -- ---------------------------- DROP TABLE IF EXISTS `frame_res`; CREATE TABLE `frame_res` ( `RES_ID` int(0) NOT NULL COMMENT '内部编号', `RES_NAME` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '资源名称', `RES_ALIAS` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '别名，用于前端权限控制', `RES_URL` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '资源的地址', `RES_PID` int(0) NULL DEFAULT NULL COMMENT '资源上级ID', `RES_LEVEL` int(0) NULL DEFAULT NULL COMMENT '资源级别', `RES_TYPE` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '资源类型,Menu,Fun', `RES_CSS` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '资源的样式信息', `RES_STATUS` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'Active' COMMENT '资源状态', `RES_ORDER` int(0) NULL DEFAULT 0 COMMENT '排序', `RES_DESC` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注信息', PRIMARY KEY (`RES_ID`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统表-资源定义' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of frame_res -- ---------------------------- INSERT INTO `frame_res` VALUES (1000, '系统配置', NULL, '', 0, 1, 'Menu', '', 'Active', 1000, NULL); INSERT INTO `frame_res` VALUES (1010, '资源管理', 'res_manage', '/frame/res/page', 1100, 3, 'Page', 'icon-docs', 'Active', 1010, NULL); INSERT INTO `frame_res` VALUES (1011, '资源列表', NULL, NULL, 1010, 4, 'Fun', NULL, 'Active', 1011, NULL); INSERT INTO `frame_res` VALUES (1012, '资源权限', NULL, NULL, 1010, 4, 'Fun', '', 'Active', 1012, NULL); INSERT INTO `frame_res` VALUES (1020, '系统参数', NULL, '/frame/param/page', 1100, 3, 'Page', 'icon-eye', 'Active', 1020, NULL); INSERT INTO `frame_res` VALUES (1021, '参数列表', NULL, NULL, 1020, 4, 'Fun', NULL, 'Active', 1021, NULL); INSERT INTO `frame_res` VALUES (1022, '参数维护', NULL, NULL, 1020, 4, 'Fun', NULL, 'Active', 1022, NULL); INSERT INTO `frame_res` VALUES (1023, '重载参数', NULL, NULL, 1023, 4, 'Fun', '', 'Active', 1023, NULL); INSERT INTO `frame_res` VALUES (1030, '系统字典', NULL, '/frame/dict/page', 1100, 3, 'Page', 'icon-directions', 'Active', 1030, NULL); INSERT INTO `frame_res` VALUES (1031, '字典列表', NULL, '', 1030, 4, 'Fun', NULL, 'Active', 1031, NULL); INSERT INTO `frame_res` VALUES (1032, '字典管理', NULL, '', 1030, 4, 'Fun', '', 'Active', 1032, NULL); INSERT INTO `frame_res` VALUES (1033, '重载字典', NULL, '', 1030, 4, 'Fun', '', 'Active', 1033, NULL); INSERT INTO `frame_res` VALUES (1040, '部门管理', NULL, '/frame/dept/page', 1100, 3, 'Page', 'icon-people', 'Active', 1040, NULL); INSERT INTO `frame_res` VALUES (1041, '部门列表', NULL, '', 1040, 4, 'Fun', '', 'Active', 1041, NULL); INSERT INTO `frame_res` VALUES (1042, '部门管理', NULL, '', 1040, 4, 'Fun', '', 'Active', 1042, NULL); INSERT INTO `frame_res` VALUES (1080, '角色管理', NULL, '/frame/role/page', 1100, 3, 'Page', 'icon-people', 'Active', 1080, NULL); INSERT INTO `frame_res` VALUES (1081, '角色列表', NULL, '', 1080, 4, 'Fun', NULL, 'Active', 1081, NULL); INSERT INTO `frame_res` VALUES (1082, '角色管理', NULL, '', 1080, 4, 'Fun', '', 'Active', 1082, NULL); INSERT INTO `frame_res` VALUES (1083, '分配角色权限', NULL, '', 1080, 4, 'Fun', NULL, 'Active', 1083, NULL); INSERT INTO `frame_res` VALUES (1090, '操作员管理', NULL, '/frame/optr/page', 1100, 3, 'Page', 'icon-user', 'Active', 1090, NULL); INSERT INTO `frame_res` VALUES (1091, '操作员列表', NULL, '', 1090, 4, 'Fun', NULL, 'Active', 1091, NULL); INSERT INTO `frame_res` VALUES (1092, '操作员管理', NULL, '', 1090, 4, 'Fun', '', 'Active', 1092, NULL); INSERT INTO `frame_res` VALUES (1100, '运行配置', NULL, '', 1000, 2, 'Menu', 'icon-settings', 'Active', 1100, NULL); INSERT INTO `frame_res` VALUES (10100, '企业微信', NULL, '', 1000, 2, 'Menu', 'fab fa-weixin', 'Active', 10100, NULL); INSERT INTO `frame_res` VALUES (10110, '微信公众号', NULL, '/weixin/define/page', 10100, 3, 'Page', 'fab fa-weixin text-success', 'Active', 10110, NULL); INSERT INTO `frame_res` VALUES (10111, '微信公众号管理', NULL, '', 10110, 4, 'Fun', '', 'Active', 10111, NULL); INSERT INTO `frame_res` VALUES (10120, '微信参数', NULL, '/weixin/param/page', 10100, 3, 'Page', 'icon-settings text-darkred', 'Active', 10120, NULL); INSERT INTO `frame_res` VALUES (10121, '微信参数管理', NULL, '', 10120, 4, 'Fun', '', 'Active', 10121, NULL); INSERT INTO `frame_res` VALUES (10130, '微信菜单', NULL, '/weixin/menu/page', 10100, 3, 'Page', 'icon-menu text-darkcyan', 'Active', 10130, NULL); INSERT INTO `frame_res` VALUES (10131, '微信菜单管理', NULL, '', 10130, 4, 'Fun', '', 'Active', 10131, NULL); INSERT INTO `frame_res` VALUES (10140, '自动回复', NULL, '/weixin/reply/page', 10100, 4, 'Page', 'icon-bubbles text-cornflowerblue', 'Active', 10140, NULL); INSERT INTO `frame_res` VALUES (10141, '微信消息管理', NULL, '', 10140, 5, 'Fun', '', 'Active', 10141, NULL); INSERT INTO `frame_res` VALUES (10150, '标签管理', NULL, '/weixin/tag/page', 10100, 4, 'Page', 'icon-tag text-darkorange', 'Active', 10150, NULL); INSERT INTO `frame_res` VALUES (10151, '用户标签管理', NULL, '', 10160, 5, 'Fun', '', 'Active', 10151, NULL); INSERT INTO `frame_res` VALUES (10160, '微信用户', NULL, '/weixin/user/page', 10100, 4, 'Page', 'icon-people text-info', 'Active', 10160, NULL); INSERT INTO `frame_res` VALUES (10161, '微信用户管理', NULL, '', 10160, 4, 'Fun', '', 'Active', 10161, NULL); INSERT INTO `frame_res` VALUES (10170, '模板消息', NULL, '/weixin/template/page', 10100, 3, 'Page', 'icon-docs text-dodgerblue', 'Active', 10170, NULL); INSERT INTO `frame_res` VALUES (10171, '模板消息管理', NULL, '', 10170, 4, 'Fun', '', 'Active', 10171, NULL); INSERT INTO `frame_res` VALUES (10180, '消息处理器', NULL, '/weixin/processor/page', 10100, 3, 'Page', 'icon-docs text-dodgerblue', 'Active', 10180, NULL); INSERT INTO `frame_res` VALUES (10181, '消息处理器管理', NULL, '', 10810, 4, 'Fun', '', 'Active', 10181, NULL); INSERT INTO `frame_res` VALUES (100000, '基础配置', NULL, '', 0, 1, 'Menu', '', 'Active', 100000, NULL); INSERT INTO `frame_res` VALUES (101000, '专业配置', NULL, NULL, 100000, 2, 'Page', 'icon-directions', 'Active', 101000, NULL); INSERT INTO `frame_res` VALUES (101100, '报考大类', NULL, '/art/conf/category/page', 101000, 3, 'Page', 'fas fa-book text-primary', 'Active', 101100, NULL); INSERT INTO `frame_res` VALUES (101200, '二级学院', NULL, '/art/conf/major/page', 101000, 3, 'Page', 'fas fa-bookmark text-info', 'Active', 101200, NULL); INSERT INTO `frame_res` VALUES (101300, '专业方向', NULL, '/art/conf/aspect/page', 101000, 3, 'Page', 'fas fa-clone text-succss', 'Active', 101300, NULL); INSERT INTO `frame_res` VALUES (105000, '微信Token', NULL, '', 0, 1, 'Menu', '', 'Active', 105000, NULL); INSERT INTO `frame_res` VALUES (106000, '公众号列表', NULL, '/hmplatform/wxtoken/page', 105000, 2, 'Page', 'icon-directions', 'Active', 106000, NULL); INSERT INTO `frame_res` VALUES (200000, '项目实施', NULL, NULL, 0, 1, 'Menu', NULL, 'Active', 200000, NULL); INSERT INTO `frame_res` VALUES (201000, '学校管理', NULL, '/hmplatform/conf/school/page', 200000, 2, 'Page', 'icon-docs text-dodgerblue', 'Active', 201000, NULL); INSERT INTO `frame_res` VALUES (202000, '项目管理', NULL, '/hmplatform/conf/project/page', 200000, 2, 'Page', 'icon-eye', 'Active', 202000, NULL); INSERT INTO `frame_res` VALUES (300000, '监控统计', NULL, '', 0, 1, 'Menu', NULL, 'Active', 200000, NULL); INSERT INTO `frame_res` VALUES (301000, '学生列表', NULL, '/hmplatform/monitor/std/page', 300000, 2, 'Page', 'icon-docs text-dodgerblue', 'Active', 201000, NULL); -- ---------------------------- -- Table structure for frame_role -- ---------------------------- DROP TABLE IF EXISTS `frame_role`; CREATE TABLE `frame_role` ( `ROLE_ID` int(0) NOT NULL AUTO_INCREMENT COMMENT '角色内部编号', `ROLE_NAME` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '角色名称', `ROLE_STATUS` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'InActive' COMMENT '角色状态', `ROLE_TYPE` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '角色类型', `ROLE_DESC` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注信息', `HOME_PAGE` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `THREAD_MAX` int(0) NULL DEFAULT NULL COMMENT '当前角色允许的后台线程数', `CREATE_OPTR` int(0) NULL DEFAULT NULL COMMENT '创建人', `CREATE_TIME` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`ROLE_ID`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统表-角色定义' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of frame_role -- ---------------------------- -- ---------------------------- -- Table structure for frame_role_res -- ---------------------------- DROP TABLE IF EXISTS `frame_role_res`; CREATE TABLE `frame_role_res` ( `ROLE_ID` int(0) NOT NULL COMMENT '角色内部编号', `RES_ID` int(0) NOT NULL COMMENT '资源内部编号', PRIMARY KEY (`ROLE_ID`, `RES_ID`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统表-角色拥有的资源定义' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of frame_role_res -- ---------------------------- -- ---------------------------- -- Table structure for frame_thread -- ---------------------------- DROP TABLE IF EXISTS `frame_thread`; CREATE TABLE `frame_thread` ( `THREAD_ID` int(0) NOT NULL AUTO_INCREMENT COMMENT '线程ID', `THREAD_NAME` varchar(254) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '线程名称', `THREAD_STATUS` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '线程状态', `THREAD_STATUS_TIME` datetime(0) NULL DEFAULT NULL COMMENT '状态变更时间', `THREAD_TYPE` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '线程类型', `THREAD_START_TIME` datetime(0) NULL DEFAULT NULL COMMENT '线程开始时间', `THREAD_END_TIME` datetime(0) NULL DEFAULT NULL COMMENT '线程结束时间', `THREAD_NOTICE` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '线程描述信息', `THREAD_PERCENT` int(0) NULL DEFAULT NULL COMMENT '线程已运行百分比', `CALLBACK_TYPE` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '线程完成后回调类型', `CALLBACK_PARAM` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '线程完成后回调参数', `CREATE_OPTR_ID` int(0) NULL DEFAULT NULL COMMENT '创建人内部编号', `CREATE_LOGIN_NAME` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人登录名', `CREATE_OPTR_NAME` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人姓名', PRIMARY KEY (`THREAD_ID`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统表-线程表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of frame_thread -- ---------------------------- -- ---------------------------- -- Table structure for frame_timer -- ---------------------------- DROP TABLE IF EXISTS `frame_timer`; CREATE TABLE `frame_timer` ( `TIMER_ID` int(0) NOT NULL COMMENT '内部编号', `TIMER_NAME` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '定时器名称', `TIMER_CRON` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '定时器CRON表达式', `TIMER_CLASS` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '定时器使用类', `TIMER_PARAM` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '定时器的参数信息', `PROJECT_NAME` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '哪个系统需要使用这个定时器', `TIMER_ORDER` int(0) NULL DEFAULT NULL COMMENT '定时器启动顺序', `TIMER_START_TIME` datetime(0) NULL DEFAULT NULL COMMENT '定时器启动时间', `TIMER_END_TIME` datetime(0) NULL DEFAULT NULL COMMENT '定时器结束时间', `TIMER_NEXT_TIME` datetime(0) NULL DEFAULT NULL COMMENT '下次运行时间', `TIMER_LAST_TIME` datetime(0) NULL DEFAULT NULL COMMENT '最后一次运行时间', `AUTO_RUN_FLAG` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'InActive' COMMENT '系统启动时是否自动运行', `TIMER_STATUS` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'InActive' COMMENT '定时器状态，是否启用该定时器', `SINGLE_RUN_FLAG` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'Active' COMMENT '唯一运行标记', `RELOAD_PARAM_FLAG` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'InActive' COMMENT '每次运行时是否重启加载参数', `RUNNING_STATUS` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'InActive' COMMENT '是否正在运行', `LOG_FLAG` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'Active' COMMENT '是否记录日志', `TIMER_DESC` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '定时器备注信息', PRIMARY KEY (`TIMER_ID`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统表-系统定时器' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of frame_timer -- ---------------------------- -- ---------------------------- -- Table structure for frame_timer_log -- ---------------------------- DROP TABLE IF EXISTS `frame_timer_log`; CREATE TABLE `frame_timer_log` ( `LOG_ID` int(0) NOT NULL AUTO_INCREMENT COMMENT '日志编号', `TIMER_ID` int(0) NULL DEFAULT NULL COMMENT '定时器编号', `RUN_START_TIME` datetime(0) NULL DEFAULT NULL COMMENT '开始运行时间', `RUN_END_TIME` datetime(0) NULL DEFAULT NULL COMMENT '结束运行时间', `LOG_PARAM` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '日志参数信息', `LOG_NOTE` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '本次运行日志信息', PRIMARY KEY (`LOG_ID`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统表-定时器运行日志' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of frame_timer_log -- ---------------------------- -- ---------------------------- -- Table structure for p_project -- ---------------------------- DROP TABLE IF EXISTS `p_project`; CREATE TABLE `p_project` ( `PROJECT_ID` int(0) NOT NULL AUTO_INCREMENT, `PROJECT_NAME` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目描述', `SCHOOL_ID` int(0) NULL DEFAULT NULL COMMENT '学校ID', `YEAR` int(0) NULL DEFAULT NULL COMMENT '项目实施年度', `START_DATE` datetime(0) NULL DEFAULT NULL COMMENT '项目开始日期', `END_DATE` datetime(0) NULL DEFAULT NULL COMMENT '项目结束日期', `MANAGER` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '负责人', `PROJECT_DESC` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目描述', `PROJECT_STATUS` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目状态', PRIMARY KEY (`PROJECT_ID`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of p_project -- ---------------------------- INSERT INTO `p_project` VALUES (2, '南艺校考', 2, 2021, '2020-11-04 00:00:00', '2020-11-08 00:00:00', '梁宇迪', NULL, 'Running'); -- ---------------------------- -- Table structure for p_project_remark -- ---------------------------- DROP TABLE IF EXISTS `p_project_remark`; CREATE TABLE `p_project_remark` ( `REMARK_ID` int(0) NOT NULL AUTO_INCREMENT, `PROJECT_ID` int(0) NULL DEFAULT NULL COMMENT '项目ID', `REMARK_TIME` datetime(0) NULL DEFAULT NULL, `REMARK` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (`REMARK_ID`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of p_project_remark -- ---------------------------- -- ---------------------------- -- Table structure for p_school -- ---------------------------- DROP TABLE IF EXISTS `p_school`; CREATE TABLE `p_school` ( `SCHOOL_ID` int(0) NOT NULL AUTO_INCREMENT, `SCHOOL_NAME` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `SCHOOL_CODE` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `SCHOOL_ADDR` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (`SCHOOL_ID`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of p_school -- ---------------------------- INSERT INTO `p_school` VALUES (2, '南京艺术学院', '10331', '南京'); -- ---------------------------- -- Table structure for p_std_reg -- ---------------------------- DROP TABLE IF EXISTS `p_std_reg`; CREATE TABLE `p_std_reg` ( `STD_ID` int(0) NOT NULL AUTO_INCREMENT, `CERT_ID` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '证件号码', `STD_NAME` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '考生姓名', `STD_SEX` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '考生性别', `STD_NATION` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '考生民族', `CERT_ADDR` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '证件地址', `STD_BIRTHDAY` date NULL DEFAULT NULL COMMENT '出生日期', `FROM_PROJECT` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '来自于哪个工程', `STD_IMAGE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '免冠证件照地址', `VERIFY_STATUS` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '验证状态', `VERIFY_TIME` datetime(0) NULL DEFAULT NULL COMMENT '验证时间', PRIMARY KEY (`STD_ID`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 84695 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '考生列表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of p_std_reg -- ---------------------------- INSERT INTO `p_std_reg` VALUES (84695, '412726198702033722', '测试', NULL, NULL, NULL, NULL, '10048', NULL, 'InActive', '2022-12-31 12:15:03'); -- ---------------------------- -- Table structure for p_std_res -- ---------------------------- DROP TABLE IF EXISTS `p_std_res`; CREATE TABLE `p_std_res` ( `RES_TYPE` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '资源类型', `CERT_ID` varchar(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '身份证号', `STD_ID` int(0) NOT NULL COMMENT '考生编号', `RES_DATE` date NOT NULL COMMENT '身份证验证日期', `RES_NUMBER` int(0) NULL DEFAULT 0 COMMENT '验证次数', `RES_PLUS` int(0) NULL DEFAULT NULL COMMENT '手工调整', PRIMARY KEY (`RES_TYPE`, `CERT_ID`, `RES_DATE`) USING BTREE, INDEX `idx_cert_id`(`CERT_ID`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '考生使用资源记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of p_std_res -- ---------------------------- INSERT INTO `p_std_res` VALUES ('Identify', '412726198702033722', 84695, '2022-12-31', 3, 0); INSERT INTO `p_std_res` VALUES ('Identify', '412726198702033722', 84695, '2023-12-07', 3, 0); -- ---------------------------- -- Table structure for p_std_res_log -- ---------------------------- DROP TABLE IF EXISTS `p_std_res_log`; CREATE TABLE `p_std_res_log` ( `LOG_ID` int(0) NOT NULL AUTO_INCREMENT COMMENT '日志内部编号', `RES_TIME` datetime(0) NULL DEFAULT NULL COMMENT '使用资源的时间', `RES_TYPE` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '使用的资源类型', `RES_RESULT` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '使用资源后的反馈', `RES_DESC` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注信息', `RES_PARAM` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '资源参数信息', `STD_ID` int(0) NULL DEFAULT NULL COMMENT '考生内部编号', PRIMARY KEY (`LOG_ID`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 85500 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '微信用户使用资源记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of p_std_res_log -- ---------------------------- INSERT INTO `p_std_res_log` VALUES (85497, '2022-12-31 12:15:03', 'Identify', '18.67', '出现未知错误！请稍后再试', '412726198702093712,郝光辉', 84695); INSERT INTO `p_std_res_log` VALUES (85498, '2022-12-31 12:16:13', 'Identify', '18.67', '出现未知错误！请稍后再试', '412726198702093712,郝光辉', 84695); INSERT INTO `p_std_res_log` VALUES (85499, '2023-12-07 13:41:18', 'Identify', '0.0', '出现未知错误！请稍后再试', '412726198702093712,郝光辉', 84695); INSERT INTO `p_std_res_log` VALUES (85500, '2023-12-07 13:44:54', 'Identify', '0.0', '出现未知错误！请稍后再试', '412726198702093712,郝光辉', 84695); -- ---------------------------- -- Table structure for p_wx_define -- ---------------------------- DROP TABLE IF EXISTS `p_wx_define`; CREATE TABLE `p_wx_define` ( `TOKEN_ID` int(0) NOT NULL AUTO_INCREMENT COMMENT '微信内部编号', `APP_ID` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '微信公众号', `APP_SECRECT` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信公众号密钥', `APP_AESKEY` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信公众号密钥，消息加密', `APP_QRCODE` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信图标文件', `APP_ACCESSTOKENKEY` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'App默认Token', `APP_ACCESSTOKEN` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'app实时的access_token', `APP_TOKEN_EXPIRED` datetime(0) NULL DEFAULT NULL COMMENT 'token超时时间', `APP_JSAPI` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'JSAPI需要使用的Ticket', `APP_STATUS` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否启用', `RECORD_USER_LOG` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否记录用户日志', `WX_CODE` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '原始微信号', `APP_NAME` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '哪个系统使用，空为所有系哦他能够', `WX_NAME` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信公众号主体', `WX_TYPE` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信类型', `APP_CREATE_TIME` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `APP_UPDATE_TIME` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `APP_TOKEN_TIME` datetime(0) NULL DEFAULT NULL COMMENT '请求token时间', PRIMARY KEY (`TOKEN_ID`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 40 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '微信公众号（小程序）定义表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of p_wx_define -- ---------------------------- INSERT INTO `p_wx_define` VALUES (3, 'wx0f32f46a0904b160', 'a84c2ecaf31c6cb23920f4e2eb77cff3', 'wwwhmsoftcn', 'assets/image/school/51065.jpg', '', '61_T1sf1mNE8IoguK4fFBy8ZHsB92x7Paz_Ba22fU5B2CsmFm1pLAOKnfMZIC03c--yAfku2K06bfa697J2YM-6ekOe3vUPPnF16DZ24GyDP-WacCxfkGxnEv57oQDHcPD0KEgxy20rLSB_CGX4WPGhAAACVM', '2022-10-11 13:02:57', 'kgt8ON7yVITDhtdwci0qeZwM0Y2txgrk88Be7LVGsm4eukfO1XvFk78NQa-nPeCeJCLjk6WYsUq6lKlEOO63hg', 'Active', 'InActive', NULL, 'cafa2021yjs', 'cafa2021yjs', 'WeChat', '2020-06-05 16:11:23', '2021-03-31 16:35:12', '2022-10-11 11:02:57'); INSERT INTO `p_wx_define` VALUES (4, 'wxb501ca68bdeb52df', 'aca244f836a76bdfa498a26be93e30a1', 'wwwhmsoftcn', 'assets/image/school/51065.jpg', '', '61_xIQ-odAfANIyWYYPb7h9kZXxM9kgWCywBlqviBuqYwZdRO01YSzCd3jCjfOnNOSBzYpJR7zpd4pfIeJJFyTTUu0uSc89lsyDppS6SSWXhLnQBtBEYSvGmKAS3skipcLzBXs7I2GHLtWwiObqMQDiAAAEIV', '2022-10-11 20:23:22', 'kgt8ON7yVITDhtdwci0qeTdkYwqvRvcoBaAFO2cmMjonoX4ngVF9SzljqQRDi2m7lQwbrt32gvz-_kRhDxYGcQ', 'Active', 'InActive', NULL, '南艺', '南艺', 'WeChat', '2020-06-10 09:29:36', '2022-10-11 18:23:21', '2022-10-11 18:23:22'); -- ---------------------------- -- Table structure for p_wx_deploy -- ---------------------------- DROP TABLE IF EXISTS `p_wx_deploy`; CREATE TABLE `p_wx_deploy` ( `DEPLOY_ID` int(0) NOT NULL AUTO_INCREMENT, `TOKEN_ID` int(0) NOT NULL, `INTERNET_ADDR` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '互联网访问地址', `DEPLOY_ADDR` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部署地址，唯一', `REQUEST_TIME` datetime(0) NULL DEFAULT NULL COMMENT '最后请求时间', `NOTICE_TIME` datetime(0) NULL DEFAULT NULL COMMENT '最后成功通知时间', PRIMARY KEY (`DEPLOY_ID`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 363 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '微信公众号部署地址' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of p_wx_deploy -- ---------------------------- INSERT INTO `p_wx_deploy` VALUES (363, 4, 'https://nbljq.oicp.vip/a', 'http://192.168.11.131:8080', '2022-10-11 18:23:21', '2022-10-11 18:23:23'); -- ---------------------------- -- Table structure for p_wx_deploy_log -- ---------------------------- DROP TABLE IF EXISTS `p_wx_deploy_log`; CREATE TABLE `p_wx_deploy_log` ( `LOG_ID` int(0) NOT NULL AUTO_INCREMENT, `TOKEN_ID` int(0) NULL DEFAULT NULL, `REQUEST_TIME` datetime(0) NULL DEFAULT NULL COMMENT '请求时间', `REQUEST_ADDR` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求地址', `INTERNET_ADDR` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '互联网访问地址', `DEPLOY_ADDR` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部署地址，唯一', `APP_ACCESSTOKENKEY` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'App默认Token', `APP_ACCESSTOKEN` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'app实时的access_token', `APP_TOKEN_EXPIRED` datetime(0) NULL DEFAULT NULL COMMENT 'token超时时间', PRIMARY KEY (`LOG_ID`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 40024 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '请求记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of p_wx_deploy_log -- ---------------------------- INSERT INTO `p_wx_deploy_log` VALUES (40023, 4, '2022-10-11 14:42:12', '127.0.0.1', 'https://nbljq.oicp.vip/a', 'http://192.168.11.131:8080', '', '61_GKiJh1WFeYhMrbGZcET7-2TopXUCYSy6WGu-PGQyi2M0IlGfc-_KpWO07mJuXM3nOPSDjFKTF3w6zkFf7KPUFZsGS-yyHosPeGIlhX0_XK_a-j6H5aMJ5kss_iQijEWIlsUw_tvjsoSnck_vNQAdAEAVYI', '2022-10-11 16:01:55'); INSERT INTO `p_wx_deploy_log` VALUES (40024, 4, '2022-10-11 18:23:21', '127.0.0.1', 'https://nbljq.oicp.vip/a', 'http://192.168.11.131:8080', '', '61_GKiJh1WFeYhMrbGZcET7-2TopXUCYSy6WGu-PGQyi2M0IlGfc-_KpWO07mJuXM3nOPSDjFKTF3w6zkFf7KPUFZsGS-yyHosPeGIlhX0_XK_a-j6H5aMJ5kss_iQijEWIlsUw_tvjsoSnck_vNQAdAEAVYI', '2022-10-11 16:01:55'); -- ---------------------------- -- Table structure for p_wx_token_notice -- ---------------------------- DROP TABLE IF EXISTS `p_wx_token_notice`; CREATE TABLE `p_wx_token_notice` ( `LOG_ID` int(0) NOT NULL AUTO_INCREMENT, `TOKEN_ID` int(0) NOT NULL, `NOTICE_TIME` datetime(0) NULL DEFAULT NULL COMMENT '通知token时间', `NOTICE_ADDR` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '通知token地址', `NOTICE_STATUS` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否成功', `APP_ACCESSTOKENKEY` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'App默认Token', `APP_ACCESSTOKEN` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'app实时的access_token', `APP_TOKEN_EXPIRED` datetime(0) NULL DEFAULT NULL COMMENT 'token超时时间', PRIMARY KEY (`LOG_ID`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 325408 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '回传token信息' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of p_wx_token_notice -- ---------------------------- INSERT INTO `p_wx_token_notice` VALUES (325408, 4, '2022-10-11 18:23:23', 'https://nbljq.oicp.vip/a', 'Active', '', '61_xIQ-odAfANIyWYYPb7h9kZXxM9kgWCywBlqviBuqYwZdRO01YSzCd3jCjfOnNOSBzYpJR7zpd4pfIeJJFyTTUu0uSc89lsyDppS6SSWXhLnQBtBEYSvGmKAS3skipcLzBXs7I2GHLtWwiObqMQDiAAAEIV', '2022-10-11 20:23:22'); -- ---------------------------- -- Table structure for p_wx_token_request -- ---------------------------- DROP TABLE IF EXISTS `p_wx_token_request`; CREATE TABLE `p_wx_token_request` ( `LOG_ID` int(0) NOT NULL AUTO_INCREMENT, `TOKEN_ID` int(0) NOT NULL COMMENT '微信内部编号', `APP_ACCESSTOKENKEY` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'App默认Token', `APP_ACCESSTOKEN` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'app实时的access_token', `APP_TOKEN_EXPIRED` datetime(0) NULL DEFAULT NULL COMMENT 'token超时时间', `APP_JSAPI` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'JSAPI需要使用的Ticket', `REQUEST_TIME` datetime(0) NULL DEFAULT NULL COMMENT '请求时间', `RESPONSE_TIME` datetime(0) NULL DEFAULT NULL COMMENT '返回时间', `ERROR_CODE` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '返回代码', `ERROR_MSG` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '错误提示', PRIMARY KEY (`LOG_ID`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4188166 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'TOKEN获取日志' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of p_wx_token_request -- ---------------------------- INSERT INTO `p_wx_token_request` VALUES (4188138, 13, '', '61_9bpp9oOrhS4ZnaM5yao5QI-yk1OOGrGgy7ChYMNQsc5zvuMM62VgZw_d3GzHkI_EflQFmhxNhvZ5gYKw0U0f_wHAx2G3NON4znRRp2e7NcM1C8n9oLCC6h7Z-a2daSFsu0t6y8fVSAA0fTg0UJJfABAETT', '2022-10-11 13:02:57', 'LIKLckvwlJT9cWIhEQTwfHGsKl5ygaq-FyG8D88Ha3RnnbbCyT-f7lLer0wKN792dhalu6CQ0QHwKzpcqMek1A', '2022-10-11 14:51:14', '2022-10-11 14:51:14', '40164', 'invalid ip 221.234.131.130 ipv6 ::ffff:221.234.131.130, not in whitelist rid: 63451261-32fdd842-1a802e86'); INSERT INTO `p_wx_token_request` VALUES (4188139, 3, '', '61_T1sf1mNE8IoguK4fFBy8ZHsB92x7Paz_Ba22fU5B2CsmFm1pLAOKnfMZIC03c--yAfku2K06bfa697J2YM-6ekOe3vUPPnF16DZ24GyDP-WacCxfkGxnEv57oQDHcPD0KEgxy20rLSB_CGX4WPGhAAACVM', '2022-10-11 13:02:57', 'kgt8ON7yVITDhtdwci0qeZwM0Y2txgrk88Be7LVGsm4eukfO1XvFk78NQa-nPeCeJCLjk6WYsUq6lKlEOO63hg', '2022-10-11 14:51:14', '2022-10-11 14:51:14', '40164', 'invalid ip 221.234.131.130 ipv6 ::ffff:221.234.131.130, not in whitelist rid: 63451261-7955a0f1-088f3352'); INSERT INTO `p_wx_token_request` VALUES (4188140, 39, '', NULL, NULL, NULL, '2022-10-11 14:51:14', '2022-10-11 14:51:14', '40164', 'invalid ip 221.234.131.130 ipv6 ::ffff:221.234.131.130, not in whitelist rid: 63451261-25845cdd-2cf6618a'); INSERT INTO `p_wx_token_request` VALUES (4188141, 19, '', '61_QfUdzkgig_Q6GVOrVaeXO0Jem9lM0IfKOydSmkRm6Bb1qU9kqmPoz1PwMkCZoRPa6cN3DzhDUl6dsIIjYVkOmdvDZfUV0AnxPO3sgyM4Rw95EcdjBUo64rZiYFfvh8wGDlVV8V3dRKixaofKWWYcABARRT', '2022-10-11 13:02:57', 'kgt8ON7yVITDhtdwci0qeak_1Rui-NSstAfYKLhowDiQ1kd0MZirPy4rD0ifEoi62NqrpI2B_EqIdXCfAzNY2w', '2022-10-11 14:51:14', '2022-10-11 14:51:14', '40164', 'invalid ip 221.234.131.130 ipv6 ::ffff:221.234.131.130, not in whitelist rid: 63451261-16cdf0c1-3b92097c'); INSERT INTO `p_wx_token_request` VALUES (4188142, 12, '', '61_NKqtwwAMKWEAY_LiTQbhuWIJ5WJ3h_0GCHWkzFYXVRGsZoM3DspEKlu9CrDhrzJaqZTnHExWkFW8WNiuPDbdQ5hXPUJFdODGBTo6UQ1yvcVwh0mY1t3ci_PziX-fHBXEWhj_HY5Yn5uXBrC4PKDgAGAEZS', '2022-10-11 13:02:57', 'HoagFKDcsGMVCIY2vOjf9runXy2DPjFpUHfzw49fg6DCBvysof-Vh8YpJqA_GO-N3FeJQBe35w5H9UlIMVmdJw', '2022-10-11 14:51:14', '2022-10-11 14:51:14', '40164', 'invalid ip 221.234.131.130 ipv6 ::ffff:221.234.131.130, not in whitelist rid: 63451261-42eb3402-7c77ed9c'); INSERT INTO `p_wx_token_request` VALUES (4188143, 36, 'qXuUWopl1ZfLa9Evng8R6ydX33MzEvoc8Fye6pcjXMP', '61_SNaEPn0n97VbiS5gQNbv-Ll10_xAnn7LMV2PzjKlHuS3Hyb1KiIczjFloqU794IjbNLvzMtO7hbJww1VDVhLhNCUSmFKcaibvyJtaDjdsscstUkGOh8PL-Bj3W2nfHj_EKXKif5Wn3lpdQwcTTHgAAALLZ', '2022-10-11 11:24:35', 'O3SMpm8bG7kJnF36aXbe83KQVKmMmndPbY-Fpc1I0BDpU9nKczHNsnsK5ItqnmLrzTTk4P7g2pAQMpfhFKDa5g', '2022-10-11 14:51:14', '2022-10-11 14:51:14', '40164', 'invalid ip 221.234.131.130 ipv6 ::ffff:221.234.131.130, not in whitelist rid: 63451261-70afe093-3833eaad'); INSERT INTO `p_wx_token_request` VALUES (4188144, 24, '', '61_hTKVfnpIyr-J4KJ4xMsAMi6liRxn7gfw9mZGq6XoDW6WWhUgv6FHb4CPymM91l7_QEbpE43rdiZpzsyNtIdS2JD1YRtDWHzjO3SOyAxbO1SikACgvSJH-kK6oxUHCD3fbBwpkWwsXTO4i9xAPSFhAAAZCP', '2022-10-11 13:02:57', 'LIKLckvwlJT9cWIhEQTwfGNJd6rCuAtdRToCRKRskI0iuNbYoJ2Da2a4Nd61ahWlhVpk4CO9WwMJT_SF1PyYsQ', '2022-10-11 14:51:14', '2022-10-11 14:51:14', '40164', 'invalid ip 221.234.131.130 ipv6 ::ffff:221.234.131.130, not in whitelist rid: 63451261-326f5961-6b314dfd'); INSERT INTO `p_wx_token_request` VALUES (4188145, 28, '', '61_wL-xVQXOWRz0EMhQ4QEbhkea1FYAR0lHqkfGIc0jXyGk16pxdIkU7thRuJ9hclsco16-QE7t3uvVWkUZIIQbPgmNjfUH1wRttFptSI3o63-ztoop3wMQ4C3HwXOeHp1ZVM2svYddxm9z2UNJTCHhAHAPYD', '2022-10-11 13:02:57', 'kgt8ON7yVITDhtdwci0qeYXyFpjYdXgTyRIw5gWnnh6h3BH6GTWI-Oib_uxpzZcPRnFw1AZlnshxszxNdlL-IQ', '2022-10-11 14:51:14', '2022-10-11 14:51:14', '40164', 'invalid ip 221.234.131.130 ipv6 ::ffff:221.234.131.130, not in whitelist rid: 63451261-5ab2e634-771063ae'); INSERT INTO `p_wx_token_request` VALUES (4188146, 40, '', '54_oE2fhoM7HTZbv2IfaRKWujG_8ALZh63xF3lL6n9fG4XaD9S7UNwR_RDZW0V6CUPcP-h9i2is4qpEaTxl3-Jzke6TukKTMBw8OrwgqNGTsltc8sSt1RBxN0plewi1kg5u5zmkQVis--yCnf6CDIYgAHAKPF', '2022-03-10 19:26:36', 'O3SMpm8bG7kJnF36aXbe89ftT9qPymuti-x_tKowZCEbdM6-43xIfCrbQhrzvr7bQAshc4-Cdu2EUiDT_-VMRw', '2022-10-11 14:51:14', '2022-10-11 14:51:14', '40164', 'invalid ip 221.234.131.130 ipv6 ::ffff:221.234.131.130, not in whitelist rid: 63451261-44365e2d-6088c4b9'); INSERT INTO `p_wx_token_request` VALUES (4188147, 10, '', '61_pjJTPw-ISOY8RBbGbki_uAnbE3rFPhw05hphBj2v8IXEyro_GQ_RmMKP3rP7aLVxjKijj23enXMba01mcqZhafwVSQF_1lCHpdJmYVm_yW6_AEpXeWUuewCodgj-m3dueG66sbUKTXGqL3hNBBJcAAAXXF', '2022-10-11 13:02:57', 'kgt8ON7yVITDhtdwci0qeXBT5xKbMqSLqZXEiSCYtzT9rxZpDHlMFOxJS0emekqdAUlGQlxoB5bWLyOwFmY9XQ', '2022-10-11 14:51:14', '2022-10-11 14:51:14', '40164', 'invalid ip 221.234.131.130 ipv6 ::ffff:221.234.131.130, not in whitelist rid: 63451261-11c240c1-4b22ecbe'); INSERT INTO `p_wx_token_request` VALUES (4188148, 3, '', '61_T1sf1mNE8IoguK4fFBy8ZHsB92x7Paz_Ba22fU5B2CsmFm1pLAOKnfMZIC03c--yAfku2K06bfa697J2YM-6ekOe3vUPPnF16DZ24GyDP-WacCxfkGxnEv57oQDHcPD0KEgxy20rLSB_CGX4WPGhAAACVM', '2022-10-11 13:02:57', 'kgt8ON7yVITDhtdwci0qeZwM0Y2txgrk88Be7LVGsm4eukfO1XvFk78NQa-nPeCeJCLjk6WYsUq6lKlEOO63hg', '2022-10-11 18:23:21', '2022-10-11 18:23:22', '40164', 'invalid ip 221.234.131.130 ipv6 ::ffff:221.234.131.130, not in whitelist rid: 63454419-48c49f6b-6653fcf6'); INSERT INTO `p_wx_token_request` VALUES (4188149, 4, '', '61_GKiJh1WFeYhMrbGZcET7-2TopXUCYSy6WGu-PGQyi2M0IlGfc-_KpWO07mJuXM3nOPSDjFKTF3w6zkFf7KPUFZsGS-yyHosPeGIlhX0_XK_a-j6H5aMJ5kss_iQijEWIlsUw_tvjsoSnck_vNQAdAEAVYI', '2022-10-11 16:01:55', 'kgt8ON7yVITDhtdwci0qeTdkYwqvRvcoBaAFO2cmMjqpLKvAg5Oc9IAIg9azd6leeuTTKLuzDk_XMZlirzgUhA', '2022-10-11 18:23:21', '2022-10-11 18:23:22', '0', NULL); INSERT INTO `p_wx_token_request` VALUES (4188150, 3, '', '61_T1sf1mNE8IoguK4fFBy8ZHsB92x7Paz_Ba22fU5B2CsmFm1pLAOKnfMZIC03c--yAfku2K06bfa697J2YM-6ekOe3vUPPnF16DZ24GyDP-WacCxfkGxnEv57oQDHcPD0KEgxy20rLSB_CGX4WPGhAAACVM', '2022-10-11 13:02:57', 'kgt8ON7yVITDhtdwci0qeZwM0Y2txgrk88Be7LVGsm4eukfO1XvFk78NQa-nPeCeJCLjk6WYsUq6lKlEOO63hg', '2022-10-11 18:24:52', '2022-10-11 18:24:52', '40164', 'invalid ip 221.234.131.130 ipv6 ::ffff:221.234.131.130, not in whitelist rid: 63454473-7f582292-260ade23'); INSERT INTO `p_wx_token_request` VALUES (4188151, 3, '', '61_T1sf1mNE8IoguK4fFBy8ZHsB92x7Paz_Ba22fU5B2CsmFm1pLAOKnfMZIC03c--yAfku2K06bfa697J2YM-6ekOe3vUPPnF16DZ24GyDP-WacCxfkGxnEv57oQDHcPD0KEgxy20rLSB_CGX4WPGhAAACVM', '2022-10-11 13:02:57', 'kgt8ON7yVITDhtdwci0qeZwM0Y2txgrk88Be7LVGsm4eukfO1XvFk78NQa-nPeCeJCLjk6WYsUq6lKlEOO63hg', '2022-10-11 18:26:22', '2022-10-11 18:26:23', '40164', 'invalid ip 221.234.131.130 ipv6 ::ffff:221.234.131.130, not in whitelist rid: 634544cd-4b60f77d-66e59686'); INSERT INTO `p_wx_token_request` VALUES (4188152, 3, '', '61_T1sf1mNE8IoguK4fFBy8ZHsB92x7Paz_Ba22fU5B2CsmFm1pLAOKnfMZIC03c--yAfku2K06bfa697J2YM-6ekOe3vUPPnF16DZ24GyDP-WacCxfkGxnEv57oQDHcPD0KEgxy20rLSB_CGX4WPGhAAACVM', '2022-10-11 13:02:57', 'kgt8ON7yVITDhtdwci0qeZwM0Y2txgrk88Be7LVGsm4eukfO1XvFk78NQa-nPeCeJCLjk6WYsUq6lKlEOO63hg', '2022-10-11 18:27:53', '2022-10-11 18:27:53', '40164', 'invalid ip 221.234.131.130 ipv6 ::ffff:221.234.131.130, not in whitelist rid: 63454528-2d021788-003fc8a0'); INSERT INTO `p_wx_token_request` VALUES (4188153, 3, '', '61_T1sf1mNE8IoguK4fFBy8ZHsB92x7Paz_Ba22fU5B2CsmFm1pLAOKnfMZIC03c--yAfku2K06bfa697J2YM-6ekOe3vUPPnF16DZ24GyDP-WacCxfkGxnEv57oQDHcPD0KEgxy20rLSB_CGX4WPGhAAACVM', '2022-10-11 13:02:57', 'kgt8ON7yVITDhtdwci0qeZwM0Y2txgrk88Be7LVGsm4eukfO1XvFk78NQa-nPeCeJCLjk6WYsUq6lKlEOO63hg', '2022-10-11 18:29:23', '2022-10-11 18:29:23', '40164', 'invalid ip 221.234.131.130 ipv6 ::ffff:221.234.131.130, not in whitelist rid: 63454582-6defa7da-7ea3f529'); INSERT INTO `p_wx_token_request` VALUES (4188154, 3, '', '61_T1sf1mNE8IoguK4fFBy8ZHsB92x7Paz_Ba22fU5B2CsmFm1pLAOKnfMZIC03c--yAfku2K06bfa697J2YM-6ekOe3vUPPnF16DZ24GyDP-WacCxfkGxnEv57oQDHcPD0KEgxy20rLSB_CGX4WPGhAAACVM', '2022-10-11 13:02:57', 'kgt8ON7yVITDhtdwci0qeZwM0Y2txgrk88Be7LVGsm4eukfO1XvFk78NQa-nPeCeJCLjk6WYsUq6lKlEOO63hg', '2022-10-11 18:30:53', '2022-10-11 18:30:53', '40164', 'invalid ip 221.234.131.130 ipv6 ::ffff:221.234.131.130, not in whitelist rid: 634545dc-215eafd2-43ce852e'); INSERT INTO `p_wx_token_request` VALUES (4188155, 3, '', '61_T1sf1mNE8IoguK4fFBy8ZHsB92x7Paz_Ba22fU5B2CsmFm1pLAOKnfMZIC03c--yAfku2K06bfa697J2YM-6ekOe3vUPPnF16DZ24GyDP-WacCxfkGxnEv57oQDHcPD0KEgxy20rLSB_CGX4WPGhAAACVM', '2022-10-11 13:02:57', 'kgt8ON7yVITDhtdwci0qeZwM0Y2txgrk88Be7LVGsm4eukfO1XvFk78NQa-nPeCeJCLjk6WYsUq6lKlEOO63hg', '2022-10-11 18:32:23', '2022-10-11 18:32:24', '40164', 'invalid ip 221.234.131.130 ipv6 ::ffff:221.234.131.130, not in whitelist rid: 63454637-47f97b97-24b202c7'); INSERT INTO `p_wx_token_request` VALUES (4188156, 3, '', '61_T1sf1mNE8IoguK4fFBy8ZHsB92x7Paz_Ba22fU5B2CsmFm1pLAOKnfMZIC03c--yAfku2K06bfa697J2YM-6ekOe3vUPPnF16DZ24GyDP-WacCxfkGxnEv57oQDHcPD0KEgxy20rLSB_CGX4WPGhAAACVM', '2022-10-11 13:02:57', 'kgt8ON7yVITDhtdwci0qeZwM0Y2txgrk88Be7LVGsm4eukfO1XvFk78NQa-nPeCeJCLjk6WYsUq6lKlEOO63hg', '2022-10-11 18:33:54', '2022-10-11 18:33:54', '40164', 'invalid ip 221.234.131.130 ipv6 ::ffff:221.234.131.130, not in whitelist rid: 63454691-08b4c165-45ef0efa'); INSERT INTO `p_wx_token_request` VALUES (4188157, 3, '', '61_T1sf1mNE8IoguK4fFBy8ZHsB92x7Paz_Ba22fU5B2CsmFm1pLAOKnfMZIC03c--yAfku2K06bfa697J2YM-6ekOe3vUPPnF16DZ24GyDP-WacCxfkGxnEv57oQDHcPD0KEgxy20rLSB_CGX4WPGhAAACVM', '2022-10-11 13:02:57', 'kgt8ON7yVITDhtdwci0qeZwM0Y2txgrk88Be7LVGsm4eukfO1XvFk78NQa-nPeCeJCLjk6WYsUq6lKlEOO63hg', '2022-10-11 18:35:24', '2022-10-11 18:35:24', '40164', 'invalid ip 221.234.131.130 ipv6 ::ffff:221.234.131.130, not in whitelist rid: 634546eb-6af47b49-703709c3'); INSERT INTO `p_wx_token_request` VALUES (4188158, 3, '', '61_T1sf1mNE8IoguK4fFBy8ZHsB92x7Paz_Ba22fU5B2CsmFm1pLAOKnfMZIC03c--yAfku2K06bfa697J2YM-6ekOe3vUPPnF16DZ24GyDP-WacCxfkGxnEv57oQDHcPD0KEgxy20rLSB_CGX4WPGhAAACVM', '2022-10-11 13:02:57', 'kgt8ON7yVITDhtdwci0qeZwM0Y2txgrk88Be7LVGsm4eukfO1XvFk78NQa-nPeCeJCLjk6WYsUq6lKlEOO63hg', '2022-10-11 18:36:54', '2022-10-11 18:36:54', '40164', 'invalid ip 221.234.131.130 ipv6 ::ffff:221.234.131.130, not in whitelist rid: 63454745-4f659c2d-06d11c90'); INSERT INTO `p_wx_token_request` VALUES (4188159, 3, '', '61_T1sf1mNE8IoguK4fFBy8ZHsB92x7Paz_Ba22fU5B2CsmFm1pLAOKnfMZIC03c--yAfku2K06bfa697J2YM-6ekOe3vUPPnF16DZ24GyDP-WacCxfkGxnEv57oQDHcPD0KEgxy20rLSB_CGX4WPGhAAACVM', '2022-10-11 13:02:57', 'kgt8ON7yVITDhtdwci0qeZwM0Y2txgrk88Be7LVGsm4eukfO1XvFk78NQa-nPeCeJCLjk6WYsUq6lKlEOO63hg', '2022-10-11 18:38:24', '2022-10-11 18:38:25', '40164', 'invalid ip 221.234.131.130 ipv6 ::ffff:221.234.131.130, not in whitelist rid: 634547a0-6d5d8ec5-2f3c1b05'); INSERT INTO `p_wx_token_request` VALUES (4188160, 3, '', '61_T1sf1mNE8IoguK4fFBy8ZHsB92x7Paz_Ba22fU5B2CsmFm1pLAOKnfMZIC03c--yAfku2K06bfa697J2YM-6ekOe3vUPPnF16DZ24GyDP-WacCxfkGxnEv57oQDHcPD0KEgxy20rLSB_CGX4WPGhAAACVM', '2022-10-11 13:02:57', 'kgt8ON7yVITDhtdwci0qeZwM0Y2txgrk88Be7LVGsm4eukfO1XvFk78NQa-nPeCeJCLjk6WYsUq6lKlEOO63hg', '2022-10-11 18:39:55', '2022-10-11 18:39:55', '40164', 'invalid ip 221.234.131.130 ipv6 ::ffff:221.234.131.130, not in whitelist rid: 634547fa-393d0fa5-2470dc02'); INSERT INTO `p_wx_token_request` VALUES (4188161, 3, '', '61_T1sf1mNE8IoguK4fFBy8ZHsB92x7Paz_Ba22fU5B2CsmFm1pLAOKnfMZIC03c--yAfku2K06bfa697J2YM-6ekOe3vUPPnF16DZ24GyDP-WacCxfkGxnEv57oQDHcPD0KEgxy20rLSB_CGX4WPGhAAACVM', '2022-10-11 13:02:57', 'kgt8ON7yVITDhtdwci0qeZwM0Y2txgrk88Be7LVGsm4eukfO1XvFk78NQa-nPeCeJCLjk6WYsUq6lKlEOO63hg', '2022-10-11 18:41:25', '2022-10-11 18:41:25', '40164', 'invalid ip 221.234.131.130 ipv6 ::ffff:221.234.131.130, not in whitelist rid: 63454854-4a4b901f-4f66c6f1'); INSERT INTO `p_wx_token_request` VALUES (4188162, 3, '', '61_T1sf1mNE8IoguK4fFBy8ZHsB92x7Paz_Ba22fU5B2CsmFm1pLAOKnfMZIC03c--yAfku2K06bfa697J2YM-6ekOe3vUPPnF16DZ24GyDP-WacCxfkGxnEv57oQDHcPD0KEgxy20rLSB_CGX4WPGhAAACVM', '2022-10-11 13:02:57', 'kgt8ON7yVITDhtdwci0qeZwM0Y2txgrk88Be7LVGsm4eukfO1XvFk78NQa-nPeCeJCLjk6WYsUq6lKlEOO63hg', '2022-10-11 18:42:55', '2022-10-11 18:42:55', '40164', 'invalid ip 221.234.131.130 ipv6 ::ffff:221.234.131.130, not in whitelist rid: 634548ae-47bdf3b1-196b019b'); INSERT INTO `p_wx_token_request` VALUES (4188163, 3, '', '61_T1sf1mNE8IoguK4fFBy8ZHsB92x7Paz_Ba22fU5B2CsmFm1pLAOKnfMZIC03c--yAfku2K06bfa697J2YM-6ekOe3vUPPnF16DZ24GyDP-WacCxfkGxnEv57oQDHcPD0KEgxy20rLSB_CGX4WPGhAAACVM', '2022-10-11 13:02:57', 'kgt8ON7yVITDhtdwci0qeZwM0Y2txgrk88Be7LVGsm4eukfO1XvFk78NQa-nPeCeJCLjk6WYsUq6lKlEOO63hg', '2022-10-11 18:44:26', '2022-10-11 18:44:26', '40164', 'invalid ip 221.234.131.130 ipv6 ::ffff:221.234.131.130, not in whitelist rid: 63454909-43d4f323-7ca2163d'); INSERT INTO `p_wx_token_request` VALUES (4188164, 3, '', '61_T1sf1mNE8IoguK4fFBy8ZHsB92x7Paz_Ba22fU5B2CsmFm1pLAOKnfMZIC03c--yAfku2K06bfa697J2YM-6ekOe3vUPPnF16DZ24GyDP-WacCxfkGxnEv57oQDHcPD0KEgxy20rLSB_CGX4WPGhAAACVM', '2022-10-11 13:02:57', 'kgt8ON7yVITDhtdwci0qeZwM0Y2txgrk88Be7LVGsm4eukfO1XvFk78NQa-nPeCeJCLjk6WYsUq6lKlEOO63hg', '2022-10-11 18:45:56', '2022-10-11 18:45:56', '40164', 'invalid ip 221.234.131.130 ipv6 ::ffff:221.234.131.130, not in whitelist rid: 63454963-188031c6-1f7b7881'); INSERT INTO `p_wx_token_request` VALUES (4188165, 3, '', '61_T1sf1mNE8IoguK4fFBy8ZHsB92x7Paz_Ba22fU5B2CsmFm1pLAOKnfMZIC03c--yAfku2K06bfa697J2YM-6ekOe3vUPPnF16DZ24GyDP-WacCxfkGxnEv57oQDHcPD0KEgxy20rLSB_CGX4WPGhAAACVM', '2022-10-11 13:02:57', 'kgt8ON7yVITDhtdwci0qeZwM0Y2txgrk88Be7LVGsm4eukfO1XvFk78NQa-nPeCeJCLjk6WYsUq6lKlEOO63hg', '2022-10-11 18:47:26', '2022-10-11 18:47:26', '40164', 'invalid ip 221.234.131.130 ipv6 ::ffff:221.234.131.130, not in whitelist rid: 634549bd-0e607d27-36ca488f'); INSERT INTO `p_wx_token_request` VALUES (4188166, 3, '', '61_T1sf1mNE8IoguK4fFBy8ZHsB92x7Paz_Ba22fU5B2CsmFm1pLAOKnfMZIC03c--yAfku2K06bfa697J2YM-6ekOe3vUPPnF16DZ24GyDP-WacCxfkGxnEv57oQDHcPD0KEgxy20rLSB_CGX4WPGhAAACVM', '2022-10-11 13:02:57', 'kgt8ON7yVITDhtdwci0qeZwM0Y2txgrk88Be7LVGsm4eukfO1XvFk78NQa-nPeCeJCLjk6WYsUq6lKlEOO63hg', '2022-10-11 18:48:56', '2022-10-11 18:48:57', '40164', 'invalid ip 221.234.131.130 ipv6 ::ffff:221.234.131.130, not in whitelist rid: 63454a17-28fafcad-345903a4'); -- ---------------------------- -- Table structure for pay_bill -- ---------------------------- DROP TABLE IF EXISTS `pay_bill`; CREATE TABLE `pay_bill` ( `BILL_ID` int(0) NOT NULL AUTO_INCREMENT COMMENT '订单编号', `MERCHANT_ID` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商户编号', `CHANNEL_ID` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '渠道编号', `BILL_TIME` datetime(0) NULL DEFAULT NULL COMMENT '订单生成日期', `BILL_AMOUNT` int(0) NULL DEFAULT NULL COMMENT '订单金额，分为单位', `BILL_STATUS` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '订单状态', `BUSINESS_TYPE` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '支付的业务类型', `BUSINESS_ID` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '支付的业务的编号', `REFUND_TIME` datetime(0) NULL DEFAULT NULL COMMENT '退款时间', `BILL_NO` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '订单外部编号', `REPLY_TIME` datetime(0) NULL DEFAULT NULL COMMENT '银行返回时间', `PAY_TIME` datetime(0) NULL DEFAULT NULL COMMENT '实际成交时间', `CUSTOMER_ID` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '订单属于哪个用户', `CHANNEL_NO` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '渠道对应的流水号', `BILL_PARAM` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '订单其他参数', PRIMARY KEY (`BILL_ID`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '支付表-支付订单' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of pay_bill -- ---------------------------- -- ---------------------------- -- Table structure for pay_bill_alipay -- ---------------------------- DROP TABLE IF EXISTS `pay_bill_alipay`; CREATE TABLE `pay_bill_alipay` ( `BILL_ID` int(0) NULL DEFAULT NULL, `TRADE_NO` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `APP_ID` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `OUT_TRADE_NO` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `OUT_BIZ_NO` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `BUYER_ID` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `SELLER_ID` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `TRADE_STATUS` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `TOTAL_AMOUNT` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `RECEIPT_AMOUNT` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `INVOICE_AMOUNT` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `BUYER_PAY_AMOUNT` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `POINT_AMOUNT` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `REFUND_FEE` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `SUBJECT` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `BODY` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `GMT_CREATE` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `GMT_PAYMENT` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `GMT_REFUND` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `GMT_CLOSE` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `FUND_BILL_LIST` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `VOUCHER_DETAIL_LIST` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `PASSBACK_PARAMS` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '支付表-支付宝订单' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of pay_bill_alipay -- ---------------------------- -- ---------------------------- -- Table structure for pay_bill_weixin -- ---------------------------- DROP TABLE IF EXISTS `pay_bill_weixin`; CREATE TABLE `pay_bill_weixin` ( `BILL_ID` int(0) NOT NULL, `OPENID` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户标识', `IS_SUBSCRIBE` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否关注公众账号 用户是否关注公众账号，Y-关注，N-未关注，仅在公众账号类型支付有效', `TRADE_TYPE` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '交易类型 JSAPI、NATIVE、APP', `BANK_TYPE` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '付款银行', `TOTAL_FEE` int(0) NULL DEFAULT NULL COMMENT '订单金额 订单总金额，单位为分', `SETTLEMENT_TOTAL_FEE` int(0) NULL DEFAULT NULL COMMENT '应结订单金额 应结订单金额=订单金额-非充值代金券金额，应结订单金额<=订单金额', `FEE_TYPE` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '货币种类', `CASH_FEE` int(0) NULL DEFAULT NULL COMMENT '现金支付金额', `CASH_FEE_TYPE` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '现金支付货币类型', `TRANSACTION_ID` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信支付订单号', `OUT_TRADE_NO` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商户系统的订单号，与请求一致', `ATTACH` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商家数据包，原样返回', `TIME_END` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '支付完成时间' ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '支付表-微信支付成功订单' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of pay_bill_weixin -- ---------------------------- -- ---------------------------- -- Table structure for pay_channel_define -- ---------------------------- DROP TABLE IF EXISTS `pay_channel_define`; CREATE TABLE `pay_channel_define` ( `CHANNEL_ID` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '渠道编号', `CHANNEL_NAME` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '渠道名称', `CHANNEL_ALIAS` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '渠道别名', `PUBLIC_VERSION` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '银行版本号', `PRIVATE_VERSION` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '内部版本号', `CHANNEL_PARAM` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '渠道其他参数', `PAY_URL` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '支付路径', `REFUND_URL` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '订单退订接口', `CHANNEL_STATUS` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否启用该渠道', PRIMARY KEY (`CHANNEL_ID`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '支付表-支付渠道定义表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of pay_channel_define -- ---------------------------- INSERT INTO `pay_channel_define` VALUES ('AliPay', '支付宝支付', '支付宝支付', '1.0', '2.0', 'alipay_public_key:MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAn79ZMVwI/6/wEq7PvruJF8WYUtAZwAiOu2vyz/LzUhric4ALVzotWe6kWksPqtqkTl3b7yNDu8T6HG9HZtc2+tmfQ0oVkPOVQ9MuB8O1okr6Jwj5qB71S3ypmYrnT8rPjhwdX/kqfeMGFKvEaviEEGsLBG5Tz6r4r9P3c3t22zqXz/MRpWp2WHRBzCTQEdUjUNKxSSZWK+SrPYFwjUIQMs8b1vrnUWR+AOWoHQcYQE6vBJUW1CY0gnSRFJOs+sYqewHegZ4UWP8E3SR3LWQPAXWYO1NDkazC/MBgWvIh/une2oo24GJlUOPNhd0BgpteiiKqOeYb2eJT6qjelzFa6QIDAQAB\r\nOwnerSubmit:true', 'https://openapi.alipay.com/gateway.do', NULL, 'Active'); INSERT INTO `pay_channel_define` VALUES ('AnxinPay', '安心付', '安心付', '1.0', '4.3', '', 'http://axf.hbctc.edu.cn:8081/paycenter/gateway_web', '..........', 'Active'); INSERT INTO `pay_channel_define` VALUES ('AnxinUnPay', '安心付银联支付', '安心付银联支付', '1.0', '2.0', NULL, 'http://axf.hbctc.edu.cn:8081/paycenter/gateway_web', NULL, 'Active'); INSERT INTO `pay_channel_define` VALUES ('WeiXin', '微信支付', '微信支付', '1.0', '4.0', '', 'https://api.mch.weixin.qq.com/pay/unifiedorder', 'https://api.mch.weixin.qq.com/secapi/pay/refund', 'Active'); -- ---------------------------- -- Table structure for pay_merchant_channel -- ---------------------------- DROP TABLE IF EXISTS `pay_merchant_channel`; CREATE TABLE `pay_merchant_channel` ( `MC_ID` int(0) NOT NULL AUTO_INCREMENT, `MERCHANT_ID` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商户编号', `CHANNEL_ID` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '渠道编号', `BANK_MERCHANT_ID` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '对应银行商户号', `BANK_MERCHANT_NAME` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '对应银行的商户名称', `BANK_MERCHANT_PASS` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '对应银行的商户密码', `PUBLIC_KEY_PATH` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '公钥文件位置', `PRIVATE_KEY_PATH` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '私钥文件位置', `BANK_MERCHANT_KEY` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '对应银行的商户证书地址', `CHANNEL_GOODS_NAME` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '默认商品名称', `SMALL_IMAGE` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '小图标', `NORMAL_IMAGE` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '中等图标', `LARGE_IMAGE` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '大图标', `MC_STATUS` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否正在运行', `MC_PARAMS` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '参数信息', `NOTICE_URL` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '支付结果回传路径', `PAGE_URL` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '支付成功后页面', `QUERY_URL` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '查询商品地址', PRIMARY KEY (`MC_ID`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '支付表-商户使用了哪些渠道' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of pay_merchant_channel -- ---------------------------- INSERT INTO `pay_merchant_channel` VALUES (1, '7157', 'WeiXin', 'wx0a96016fd80b34af', '1494879522', '995434B6669C2E6CAFA9A8654346D561', '', '', '39.105.161.241', '专业报考费', '../enrol/std/enrol/weixin/qrcode/image.htm', '', 'std/image/pay/weixin.png', 'Active', '', 'http://7157.hmsoft.cn/sk/pay/reply/weixin.htm', '123', ''); INSERT INTO `pay_merchant_channel` VALUES (2, '8092', 'AliPay', '2019011663050290', '', '', 'MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAiGEUuxsQOPsFt0YlW6S+Uviwm2h5HvgcI27+EoJTij9k7Z/jVM+8D/yZACqBhQGF7Swom0YwLJgCXeAEp1jrtDab2qMHlhvk80P+4HZgmKz3OSNPeYTaYvMms/++AKJtj5dovtCiCKc6plqD78KY2YZpv8MRce85kDXRq2HZtgStkEpsDg0JgwFfiatRR7wu2ifWLi47UcLqTeOcSHIRn1MP0LCFZI7xniPPt7jVlwkHpang8oHWs2fbwNb0qyKvw4uiMD3oqJxQuHkdgp6lIxLEjuC85OZcKafOqTvXiGPaSa0yYKqXj/YKk02i0fOXlarGSPpjbVnfZOrFdM6sIwIDAQAB', 'MIIEvgIBADANBgkqhkiG9w0BAQEFAASCBKgwggSkAgEAAoIBAQC3LvhuV5Pqx9fdbkWFE/dlKF0VHLW56euEUIo23H0u0vFey7XwqDP/HPaALr9fgzssiG9MuxzLINQ7TvZtXiXqAEVd5mbHKBZSINkthAyF7Ng92nPpVIJMxvNCsMFZOOGOKKkDZtqTriyEaC6LvSu/MMpj6lVsDqCBEnU2ix6ztYdyXWCmQsFD0RQA2z0/uAaCPhz8XX1T+t2HrVuK0eUf3MtICwmjLe8vMIlWU1DCXeSMKNfnHuGtszQ49914phM6o1eDPDpt1/8YH/fuwoIlxNfukmnFrLs1B2DCod3kdRbJiN9zpUG3Grdl0iUVnRTgwZO3UbksE57VKhLw6aSTAgMBAAECggEAbUZozrIRvBHA9QfOEufpQgAFHw4EXkZrx3+gI7/+MUuGz0zoWQqOEhZ9+dNpOBn518P/2R8Zuxb3Y/XjzTRHm8LTnoNONmn0fsO3qo5GRjIWgTdqw/s0y4Y3IUZ94LKs4vfgcvYNV+GkDsxzT8rmaOQ7J8VnddF37+dJ4uK0yvBwWy4Usqfsav5EViJ66yMzjl92+IdlDgcF4mcOqT6ExrgezBVdf5ll9RnZuNlb51VpWkIe+52OVuaNSlwS+vZL0aw0ANwCQWbqe3sgn2mWf0rc9iRLSyDJj5Y2ZKpc5rMMWUzKpN2b7prVA1ICiAlaSPZbsCn+Nr0DNBFS+Ahy4QKBgQDxZjGR/PlW1j3YT1jL3wk2bPsZHuH6jIAnXULtOj0evCTrXCrAi9Lm5kvB8+RK5HLmP6GGAMuu5VFYZNd7P9BokXbP/m/tq0jYr+/t+lStlmBtvp992WIN+RSxNgU9PUPI8sx0lD91hFZ9kOyhblMyvxzcG5U6CK1pEYsJ0RGnEQKBgQDCQ16CqkctABeTYjTBWKC60UQAahGi8pDP6rIxExEPCiqZ+q/dWs8MgvbEjRZ6/TdOvRTotkBhGEbnvzCOLfTS/bk5nxvCy1bRKRlIi4hlkdocD687AJV6cA2ZSU4SfFrbunrU4Fod+GDQejezexo5SQa+ztIOpjrXjH7U4y95YwKBgQCHJdKsy/eAYVOgjdPF1+mdeegeiUa08gIxh6oXjFp5oZX92szonZ+Gu/o/7N6r+zhEpe01S669DQ+8sEBfdTulv4LIMcfSROn0vpNSJatQv/bemjFK0PBvqDqod/j47xrLHvvObM0Wau/NPtzsCAs2Rv7OT/b81azYPQUditoaMQKBgDF+7MOqEvx6O4eHzB0/MaSn0QWyANBdsVvoVoJ+cyg71OLqpohlrL9pVup5cDLh9YeQUZWBaiHTB63gXsS7HNftYZY23eHh4Trll9WOB7CpWsMvk9wap/tMNYrKzKOVH6lAeC9pAk0EjdZQbYTDZskVvCw9kfO9ktx8pYwkXmI1AoGBAOHIh8pye1zWseV/NiG1NzB+nM8wNaCUBYBinAMZ4YnQxN0k9rqMo820hYUfGSyQfZ7fLl74mx8LxqnwS5kDpa2YxUcaVol37+fIMB/2RIY1XkZg0aaM3Wvt5+u9wTcVzNwfqGZ9jq9Cfo5Y2K3VnXHCmjSpqoB8fXey54BHT0E5', '', '专业报考费', '', 'alipay.trade.wap.pay', '', 'Active', '5m', 'http://8092.hmsoft.cn/sk/pay/reply/alipay/notice.htm', 'http://8092.hmsoft.cn/sk/pay/reply/alipay/return.htm', ''); INSERT INTO `pay_merchant_channel` VALUES (3, '8190', 'AnxinUnPay', '', 'jngkbmsyt', '6136da74a2181bb7ba679949b62f0134', 'UnionPay', '', '', '技能高考报考费', '', '', '', 'Active', '', 'http://8190.hmsoft.cn/sk/pay/reply/anxinpay.htm', 'http://axf.hbctc.edu.cn:8081/paycenter/gateway_web', ''); INSERT INTO `pay_merchant_channel` VALUES (4, '8310', 'WeiXin', 'wx94864eb55a1772b4', '1600219674', '1a3b8c0d1970efg1986hijk111zzz98A', NULL, NULL, '39.105.161.241', '技能高考报考费', '../enrol/std/enrol/weixin/qrcode/image.htm', NULL, 'std/image/pay/weixin.png', 'Active', '', 'http://8310.hmsoft.cn/sk/pay/reply/weixin.htm', '', ''); INSERT INTO `pay_merchant_channel` VALUES (5, '831000', 'WeiXin', 'wx2e75b37b812f0be3', '1436455602', '56f9c85303a46l8e169a2f9s3c8d428a', NULL, NULL, '39.105.161.241', '技能高考报考费', '../enrol/std/enrol/weixin/qrcode/image.htm', NULL, 'std/image/pay/weixin.png', 'InActive', '', 'http://8310.hmsoft.cn/sk/pay/reply/weixin.htm', '', ''); INSERT INTO `pay_merchant_channel` VALUES (6, '8640', 'WeiXin', 'wx9c3b6a72de2a0617', '1520474551', 'SLEC2018FFFFFFFFFFFFFFFFFFFFFFFF', '', '', '39.105.161.241', '专业报考费', '../enrol/std/enrol/weixin/qrcode/image.htm', '', 'std/image/pay/weixin.png', 'Active', '', 'http://8640.hmsoft.cn/sk/pay/reply/weixin.htm', '', ''); INSERT INTO `pay_merchant_channel` VALUES (7, '8910', 'AnxinPay', '', 'bmsyt', 'fafe11d3451f60c3235135ce68c28612', 'WxPay', '', '', '技能高考报考费', '../enrol/std/enrol/anxinpay/qrcode/image.htm', '', '', 'Active', '', 'http://8910.hmsoft.cn/sk/pay/reply/anxinpay.htm', 'http://pay.wru.edu.cn:8081/paycenter/gateway_back', ''); -- ---------------------------- -- Table structure for pay_merchant_define -- ---------------------------- DROP TABLE IF EXISTS `pay_merchant_define`; CREATE TABLE `pay_merchant_define` ( `MERCHANT_ID` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商户编号', `MERCHANT_NAME` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商户名称', `MERCHANT_STATUS` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商户状态', `MERCHANT_DSEC` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商户描述信息', PRIMARY KEY (`MERCHANT_ID`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '支付表-支付商户定义' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of pay_merchant_define -- ---------------------------- INSERT INTO `pay_merchant_define` VALUES ('7157', '科技职院', 'Active', '科技职院'); INSERT INTO `pay_merchant_define` VALUES ('8092', '城市职院', 'Active', '城市职院'); INSERT INTO `pay_merchant_define` VALUES ('8190', '湖北交职', 'Active', '湖北交职'); INSERT INTO `pay_merchant_define` VALUES ('8310', '襄阳职院', 'Active', '襄阳职院'); INSERT INTO `pay_merchant_define` VALUES ('8640', '武汉信息', 'Active', '武汉信息'); INSERT INTO `pay_merchant_define` VALUES ('8910', '武铁职院', 'Active', '武铁职院'); -- ---------------------------- -- Table structure for pay_reply_log -- ---------------------------- DROP TABLE IF EXISTS `pay_reply_log`; CREATE TABLE `pay_reply_log` ( `LOG_ID` int(0) NOT NULL AUTO_INCREMENT COMMENT '日志编号', `REPLY_TIME` datetime(0) NULL DEFAULT NULL COMMENT '银行返回时间', `BILL_ID` int(0) NULL DEFAULT NULL COMMENT '订单编号', `PROCE_RESULT` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '处理结果', `REPLAY_ADDR` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '银行地址', `BILL_CODE` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '订单号码', `REPLY_MSG` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '银行返回的字符串', PRIMARY KEY (`LOG_ID`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '支付表-银行回传记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of pay_reply_log -- ---------------------------- SET FOREIGN_KEY_CHECKS = 1;