51 lines
14 KiB
SQL
51 lines
14 KiB
SQL
/*
|
||
Navicat Premium Data Transfer
|
||
|
||
Source Server : localhost_mysql_8.0
|
||
Source Server Type : MySQL
|
||
Source Server Version : 80026
|
||
Source Host : localhost:3306
|
||
Source Schema : gyhlw
|
||
|
||
Target Server Type : MySQL
|
||
Target Server Version : 80026
|
||
File Encoding : 65001
|
||
|
||
Date: 16/04/2024 17:15:14
|
||
*/
|
||
|
||
SET NAMES utf8mb4;
|
||
SET FOREIGN_KEY_CHECKS = 0;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for exam_config_answer
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `exam_config_answer`;
|
||
CREATE TABLE `exam_config_answer` (
|
||
`id` varchar(50) CHARACTER SET gbk COLLATE gbk_bin NOT NULL,
|
||
`mark` varchar(255) CHARACTER SET gbk COLLATE gbk_bin NULL DEFAULT NULL COMMENT '题目标记',
|
||
`topic` varchar(255) CHARACTER SET gbk COLLATE gbk_bin NULL DEFAULT NULL COMMENT '题目',
|
||
`answer` text CHARACTER SET gbk COLLATE gbk_bin NULL COMMENT '答案',
|
||
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '最近更新时间',
|
||
`r1` text CHARACTER SET gbk COLLATE gbk_bin NULL,
|
||
`r2` text CHARACTER SET gbk COLLATE gbk_bin NULL,
|
||
`r3` text CHARACTER SET gbk COLLATE gbk_bin NULL,
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = gbk COLLATE = gbk_bin COMMENT = '配置答案' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of exam_config_answer
|
||
-- ----------------------------
|
||
INSERT INTO `exam_config_answer` VALUES ('10001', 'DB-IotLite_yx', 'DB-IotLite网关有线', '{\r\n \"ippz_wangkou\": \"ETH1\",\r\n \"ippz_ip\": \"192.168.64.3\",\r\n \"ippz_zwym\": \"255.255.255.192\",\r\n \"ippz_mrwg\": \"192.168.64.4\",\r\n \"ippz_dns_sx\": \"223.5.5.5\",\r\n \"ippz_dns_by\": \"114.114.114.114\",\r\n \"ippz_mac\": \"3C:2D:50:20:30:3D\",\r\n\r\n \"wgpz_wgmc\": \"有线区网关1\",\r\n \"wgpz_wgid\": \"LAN-BOX1\",\r\n \"wgpz_wglx\": \"MODBUS网关\",\r\n\r\n \"tdpz_tdmc\": \"有线区Channel1\",\r\n \"tdpz_td\": \"网口\",\r\n \"tdpz_qdmc\": \"ModbusTCPClient\",\r\n \"tdpz_ip\": \"192.168.64.2\",\r\n \"tdpz_port\": \"502\",\r\n \"tdpz_cssj\": \"500\",\r\n \"tdpz_jgsj\": \"500\",\r\n \"tdpz_lxsj\": \"0\",\r\n \"tdpz_cfcs\": \"3\",\r\n \"tdpz_watchtime\": \"1\",\r\n \"tdpz_cjsylxdz\": \"1\",\r\n \"tdpz_dxzkb\": \"1:1\",\r\n \"tdpz_050F\": \"auto\",\r\n \"tdpz_0610\": \"auto\",\r\n\r\n \"sbpz_sbid\": \"有线区加工设备1\",\r\n \"sbpz_sbmc\": \"有线区精雕1\",\r\n \"sbpz_mac\": \"3C:2D:50:20:30:3D\",\r\n \"sbpz_jysb\": \"0\",\r\n \"sbpz_jdzxz\": \"1\",\r\n\r\n \"cjdpz_tagid\": \"MachinePamHID910\",\r\n \"cjdpz_mc\": \"产量\",\r\n \"cjdpz_sjq\": \"4X (Holding Register)\",\r\n \"cjdpz_jcqdz\": \"8195\",\r\n \"cjdpz_cjsjlx\": \"uint16\",\r\n \"cjdpz_zjx\": \"Null\",\r\n \"cjdpz_dxsx\": \"只读\",\r\n \"cjdpz_beilv\": \"1\",\r\n\r\n \"mqtt_qiyong\": \"1\",\r\n \"mqtt_ip\": \"192.168.60.7\",\r\n \"mqtt_port\": \"1883\",\r\n \"mqtt_wgsn\": \"2000808010\",\r\n \"mqtt_sssjfbzt\": \"dbzn/gateway/iotlite/2000808010\",\r\n \"mqtt_qos\": \"qos1\",\r\n\r\n \"mqtt_scms\": \"周期上传\",\r\n \"mqtt_sczq\": \"5\",\r\n \"mqtt_sjgl\":[ \"采集成功\"],\r\n \"mqtt_cjd_sbmc\": \"有线区精雕1\",\r\n \"mqtt_cjd_tagid\": \"MachinePamHID910\"\r\n\r\n}', '2023-10-31 10:20:14', '4', NULL, NULL);
|
||
INSERT INTO `exam_config_answer` VALUES ('10002', 'DB-IotLite_wx', 'DB-IotLite网关无线', '{\r\n \"ippz_lwfs\": \"无线\",\r\n \"ippz_wangkou\": \"ETH0\",\r\n\r\n \"ippz_wifi_ssid\": \"无线区无线网\",\r\n \"ippz_wifi_mm\": \"admin1234!\",\r\n \"ippz_ip\": \"192.168.160.5\",\r\n \"ippz_zwym\": \"255.255.255.192\",\r\n \"ippz_mrwg\": \"192.168.131.8\",\r\n \"ippz_dns_sx\": \"223.5.5.5\",\r\n \"ippz_dns_by\": \"114.114.114.114\",\r\n \"ippz_mac\": \"3C:2D:50:20:30:3D\",\r\n\r\n \"wgpz_wgmc\": \"无线区网关1\",\r\n \"wgpz_wgid\": \"WLAN-BOX1\",\r\n \"wgpz_wglx\": \"MODBUS网关\",\r\n\r\n \"tdpz_tdmc\": \"无线区Channel1\",\r\n \"tdpz_td\": \"串口\",\r\n \"tdpz_qdmc\": \"ModbusRTU_over_TCP\",\r\n \"tdpz_chuankou\": \"com1\",\r\n \"tdpz_btl\": \"9600\",\r\n \"tdpz_sjw\": \"8\",\r\n \"tdpz_tzw\": \"1\",\r\n \"tdpz_jojy\": \"无校验（none）\",\r\n \"tdpz_cgsj\": \"1000\",\r\n \"tdpz_jgsj\": \"500\",\r\n \"tdpz_lxsj\": \"0\",\r\n \"tdpz_cfcs\": \"3\",\r\n \"tdpz_watchtime\": \"1\",\r\n \"tdpz_cjsylxdz\": \"1\",\r\n \"tdpz_dxzkb\": \"1:1\",\r\n \"tdpz_050F\": \"auto\",\r\n \"tdpz_0610\": \"auto\",\r\n\r\n \"sbpz_sbid\": \"无线区加工设备1\",\r\n \"sbpz_sbmc\": \"无线区精雕1\",\r\n \"sbpz_sbdz\": \"1\",\r\n \"sbpz_jysb\": \"0\",\r\n \"sbpz_jdzxz\": \"1\",\r\n\r\n \"cjdpz_tagid\": \"MachinePamHID909\",\r\n \"cjdpz_mc\": \"急停状态\",\r\n \"cjdpz_sjq\": \"4X (Holding Register)\",\r\n \"cjdpz_jcqdz\": \"8193\",\r\n \"cjdpz_cjsjlx\": \"uint16\",\r\n \"cjdpz_zjx\": \"Null\",\r\n \"cjdpz_dxsx\": \"只读\",\r\n \"cjdpz_beilv\": \"1\",\r\n\r\n \"mqtt_qiyong\": \"1\",\r\n \"mqtt_ip\": \"192.168.60.7\",\r\n \"mqtt_port\": \"1883\",\r\n \"mqtt_wgsn\": \"2000808012\",\r\n \"mqtt_sssjfbzt\": \"dbzn/gateway/iotlite/2000808012\",\r\n \"mqtt_qos\": \"qos1\",\r\n \r\n \"mqtt_scms\": \"周期上传\",\r\n \"mqtt_sczq\": \"5\",\r\n \"mqtt_sjgl\": [ \"采集成功\" ],\r\n \"mqtt_cjd_sbmc\": \"无线区精雕1\",\r\n \"mqtt_cjd_tagid\": \"MachinePamHID909\"\r\n\r\n}\r\n', '2023-10-31 16:38:34', '3', NULL, NULL);
|
||
INSERT INTO `exam_config_answer` VALUES ('10003', 'CHGYWG_yx', '斥候工业网关有线 ', '{\r\n \"ippz_wllx\": \"静态IP\",\r\n \"ippz_ip\": \"192.168.96.4\",\r\n \"ippz_zwym\": \"255.255.255.192\",\r\n \"ippz_wg\": \"192.168.96.5\",\r\n \"ippz_dns\": \"223.5.5.5\",\r\n \"ippz_dns_by\": \"114.114.114.114\",\r\n\r\n\r\n \"wgpz_wgmc\": \"有线区网关2\",\r\n \"wgpz_wgid\": \"LAN-BOX2\",\r\n\r\n \"sbpz_sbmc\": \"有线区精雕2\",\r\n \"sbpz_kzqxy\": \"Modbus TCP\",\r\n \"sbpz_ip\": \"192.168.96.3\",\r\n \"sbpz_port\": \"502\",\r\n \"sbpz_czdz\": \"2\",\r\n \"sbpz_lxzq\": \"10\",\r\n \"sbpz_qyhmcj\": \"0\",\r\n \"sbpz_qyplcj\": \"1\",\r\n \"sbpz_zdplcjs\": \"64\",\r\n \"sbpz_cjcgsj\": \"10000\",\r\n \"sbpz_zqsbonchange\": \"0\",\r\n \"sbpz_txsjjg\": \"3\",\r\n \"sbpz_xqjcqxr\": \"05\",\r\n \"sbpz_bcjcqxr\": \"06\",\r\n\r\n\r\n\r\n \"cjdpz_tagid\": \"MachinePamHID917\",\r\n \"cjdpz_mc\": \"主轴转速\",\r\n \"cjdpz_sjq\": \"4X (Holding Register)\",\r\n \"cjdpz_jcqdz\": \"8210\",\r\n \"cjdpz_cjsjlx\": \"INT（16位有符号整数）\",\r\n \"cjdpz_dxsx\": \"只读\",\r\n \"cjdpz_scms\": \"Periodic\",\r\n\r\n\r\n \"mqtt_ip\": \"192.168.60.7\",\r\n \"mqtt_wgsn\": \"2000808011\",\r\n \"mqtt_port\": \"1883\",\r\n \"mqtt_keepalive\": \"60\",\r\n \r\n \"mqtt_sssjfbzt\": \"dbzn/gateway/iotlite/2000808011\",\r\n \"mqtt_qos\": \"1\",\r\n\r\n \"mqtt_cjd_sbmc\": \"有线区精雕2\",\r\n \"mqtt_cjd_tagid\": \"MachinePamHID917\"\r\n\r\n}', '2023-11-01 15:33:00', '3', NULL, NULL);
|
||
INSERT INTO `exam_config_answer` VALUES ('10004', 'CHGYWG_wx', '斥候工业网关无线 ', '{\r\n \"ippz_ssid\": \"无线区无线网\",\r\n \"ippz_rzfs\": \"WPA2-PSK\",\r\n \"ippz_jmfs\": \"AES\",\r\n \"ippz_mm\": \"admin1234!\",\r\n\r\n\r\n\r\n \"wgpz_wgmc\": \"无线区网关2\",\r\n \"wgpz_wgid\": \"WLAN-BOX2\",\r\n\r\n \"sbpz_sbmc\": \"无线区精雕2\",\r\n \"sbpz_kzqxy\": \"Modbus TCP\",\r\n \"sbpz_ip\": \"192.168.129.5\",\r\n \"sbpz_port\": \"502\",\r\n \"sbpz_czdz\": \"2\",\r\n \"sbpz_lxzq\": \"10\",\r\n \"sbpz_qyhmcj\": \"0\",\r\n \"sbpz_qyplcj\": \"1\",\r\n \"sbpz_zdplcjs\": \"64\",\r\n \"sbpz_cjcgsj\": \"10000\",\r\n \"sbpz_zqsbonchange\": \"0\",\r\n \"sbpz_txsjjg\": \"3\",\r\n \"sbpz_xqjcqxr\": \"05\",\r\n \"sbpz_bcjcqxr\": \"06\",\r\n\r\n\r\n\r\n \"cjdpz_tagid\": \"MachinePamHID928\",\r\n \"cjdpz_mc\": \"切削速度\",\r\n \"cjdpz_sjq\": \"4X (Holding Register)\",\r\n \"cjdpz_jcqdz\": \"8227\",\r\n \"cjdpz_cjsjlx\": \"INT（16位有符号整数）\",\r\n \"cjdpz_dxsx\": \"只读\",\r\n \"cjdpz_scms\": \"Periodic\",\r\n\r\n\r\n \"mqtt_ip\": \"192.168.60.7\",\r\n \"mqtt_wgsn\": \"2000808013\",\r\n \"mqtt_port\": \"1883\",\r\n \"mqtt_keepalive\": \"60\",\r\n\r\n \"mqtt_sssjfbzt\": \"dbzn/gateway/iotlite/2000808013\",\r\n \"mqtt_qos\": \"1\",\r\n\r\n \"mqtt_cjd_sbmc\": \"无线区精雕2\",\r\n \"mqtt_cjd_tagid\": \"MachinePamHID928\"\r\n\r\n}', '2023-11-01 15:33:03', '3', NULL, NULL);
|
||
INSERT INTO `exam_config_answer` VALUES ('10005', 'CKFWQ_yx', '串口服务器有线', '{\r\n \"ippz_ip_hqfs\": \"Static IP\",\r\n \"ippz_dns_hqfs\": \"手动设定\",\r\n \"ippz_ip\": \"192.168.72.5\",\r\n \"ippz_zwym\": \"255.255.255.192\",\r\n \"ippz_mrwg\": \"192.168.72.6\",\r\n \"ippz_dns_zy\": \"223.5.5.5\",\r\n \"ippz_dns_by\": \"114.114.114.114\",\r\n\r\n\r\n \"dkpz_btl\": \"115200\",\r\n \"dkpz_sjw\": \"8\",\r\n \"dkpz_jyw\": \"无校验(None)\",\r\n \"dkpz_tzw\": \"1\",\r\n \"dkpz_lkms\": \"None\",\r\n \"dkpz_dbcd\": \"0\",\r\n \"dkpz_dbsj\": \"0\",\r\n \"dkpz_tbbtl\": \"启用\",\r\n \"dkpz_snckxtb\": \"0\"\r\n}', '2023-11-01 15:33:05', '2', NULL, NULL);
|
||
INSERT INTO `exam_config_answer` VALUES ('10006', 'CKFWQ_wx', '串口服务器无线', '{\r\n \"ckcssz_btl\": \"9600\",\r\n \"ckcssz_sjw\": \"8\",\r\n \"ckcssz_jyw\": \"无校验（none）\",\r\n \"ckcssz_tzw\": \"1\",\r\n \"ckcssz_lk\": \"关闭\",\r\n \"ckcssz_485\": \"开启\",\r\n \"ckcssz_zdybtl\": \"开启\",\r\n\r\n \"qtsz_ckzdcz\": \"关闭\",\r\n \"qtsz_zcblx\": \"关闭\",\r\n \"qtsz_zdyxtb\": \"关闭\",\r\n \"qtsz_tjzffgn\": \"关闭\",\r\n\r\n\r\n\r\n \"ytwgn_kqwk\": \"开启\",\r\n \"ytwgn_wkgzfs\": \"LAN口\",\r\n \"wkmssz_wkms\": \"n\",\r\n\r\n\r\n \"wxpz_gzms\": \"STA模式\",\r\n \"wxpz_wlmc\": \"无线区无线网\",\r\n \"wxpz_jmms\": \"WPA2PSK\",\r\n \"wxpz_jmsf\": \"AES\",\r\n \"wxpz_mm\": \"admin1234!\"\r\n}', '2023-11-03 13:30:00', '2', NULL, NULL);
|
||
INSERT INTO `exam_config_answer` VALUES ('10007', 'GYWZ_yx', '工业网闸有线', '{\r\n \"wlgl_nw_name\": \"有线区网闸（内网）\",\r\n \"wlgl_nw_ip\": \"192.168.80.5\",\r\n \"wlgl_nw_zwym\": \"255.255.255.192\",\r\n \"wlgl_ww_name\": \"有线区网闸（外网）\",\r\n \"wlgl_ww_ip\": \"192.168.49.5\",\r\n \"wlgl_ww_zwym\": \"255.255.255.0\",\r\n\r\n \"dxgl\": [\r\n {\r\n \"dx_name\": \"有线区交换机\",\r\n \"iplx\": \"IPV4\",\r\n \"ip\": \"192.168.66.4\"\r\n },\r\n {\r\n \"dx_name\": \"数采服务器\",\r\n \"iplx\": \"IPV4\",\r\n \"ip\": \"192.168.60.7\"\r\n }\r\n ],\r\n \"clgl_name\": \"有线区策略\",\r\n \"clgl_xy\": [ \"Modbus(TCP)\" ],\r\n \"clgl_gzms\": \"透明模式\",\r\n \"clgl_ydx\": \"有线区交换机\",\r\n \"clgl_ydk\": \"5200\",\r\n\r\n \"clgl_mddx\": \"数采服务器\",\r\n \"clgl_mddk\": \"1883\",\r\n \"clgl_rkwg\": \"192.168.80.6\",\r\n \"clgl_rkwk\": \"有线区网闸（内网）\",\r\n \"clgl_rkip\": \"192.168.36.4\",\r\n\r\n \"clgl_ckwg\": \"192.168.49.6\",\r\n \"clgl_ckwk\": \"有线区网闸（外网）\",\r\n \"clgl_ckip\": \"192.168.49.5\",\r\n \"clgl_wdyml\": \"拒绝\",\r\n\r\n \"cmdlist_ml\": \"读线圈状态\",\r\n \"cmdlist_sbid\": \"有线区交换机命令\",\r\n \"cmdlist_qsdz\": \"0\",\r\n \"cmdlist_dzcd\": \"65535\",\r\n \"cmdlist_ms\": \"有线区交换机命令，允许Modbus(TCP)协议通行\",\r\n \"cmdlist_dz\": \"允许\"\r\n\r\n}', '2023-11-01 15:33:09', '3', NULL, NULL);
|
||
INSERT INTO `exam_config_answer` VALUES ('10008', 'GYWZ_wx', '工业网闸无线', '{\r\n \"wlgl_nw_name\": \"无线区网闸（内网）\",\r\n \"wlgl_nw_ip\": \"192.168.132.6\",\r\n \"wlgl_nw_zwym\": \"255.255.255.192\",\r\n \"wlgl_ww_name\": \"无线区网闸（外网）\",\r\n \"wlgl_ww_ip\": \"192.168.56.5\",\r\n \"wlgl_ww_zwym\": \"255.255.255.0\",\r\n\r\n \"dxgl\": [\r\n {\r\n \"dx_name\": \"无线区路由器\",\r\n \"iplx\": \"IPV4\",\r\n \"ip\": \"192.168.131.8\"\r\n },\r\n {\r\n \"dx_name\": \"数采服务器\",\r\n \"iplx\": \"IPV4\",\r\n \"ip\": \"192.168.60.7\"\r\n }\r\n ],\r\n \"clgl_name\": \"无线区策略\",\r\n \"clgl_xy\": [ \"Modbus(TCP)\" ],\r\n \"clgl_gzms\": \"透明模式\",\r\n \"clgl_ydx\": \"无线区路由器\",\r\n \"clgl_ydk\": \"5200\",\r\n\r\n \"clgl_mddx\": \"数采服务器\",\r\n \"clgl_mddk\": \"1883\",\r\n \"clgl_rkwg\": \"192.168.131.8\",\r\n \"clgl_rkwk\": \"无线区网闸（内网）\",\r\n \"clgl_rkip\": \"192.168.132.6\",\r\n\r\n \"clgl_ckwg\": \"192.168.56.6\",\r\n \"clgl_ckwk\": \"无线区网闸（外网）\",\r\n \"clgl_ckip\": \"192.168.56.5\",\r\n \"clgl_wdyml\": \"拒绝\",\r\n\r\n \"cmdlist_ml\": \"读线圈状态\",\r\n \"cmdlist_sbid\": \"无线区路由器命令\",\r\n \"cmdlist_qsdz\": \"0\",\r\n \"cmdlist_dzcd\": \"65535\",\r\n \"cmdlist_ms\": \"无线区路由器命令1，允许Modbus(TCP)协议通行\",\r\n \"cmdlist_dz\": \"允许\"\r\n\r\n}', '2023-11-01 15:33:12', '3', NULL, NULL);
|
||
INSERT INTO `exam_config_answer` VALUES ('10009', 'YDPZYM_wgpz', '云端配置页面网关配置', ' [\r\n {\r\n \"wglx\": \"box\",\r\n \"wgid\": \"lan-box1\",\r\n \"wgbh\": \"2000808010\",\r\n \"wgmc\": \"有线区网关1\"\r\n },\r\n {\r\n \"wglx\": \"box\",\r\n \"wgid\": \"lan-box2\",\r\n \"wgbh\": \"2000808011\",\r\n \"wgmc\": \"有线区网关2\"\r\n },\r\n {\r\n \"wglx\": \"box\",\r\n \"wgid\": \"wlan-box1\",\r\n \"wgbh\": \"2000808012\",\r\n \"wgmc\": \"无线区网关1\"\r\n },\r\n {\r\n \"wglx\": \"box\",\r\n \"wgid\": \"wlan-box2\",\r\n \"wgbh\": \"2000808013\",\r\n \"wgmc\": \"无线区网关2\"\r\n }\r\n ]', '2023-11-01 15:33:14', '2', NULL, NULL);
|
||
INSERT INTO `exam_config_answer` VALUES ('10010', 'YDPZYM_wgwh', '云端配置页面网关维护', ' [\r\n {\r\n \"sswg\": \"lan-box1\",\r\n \"cskey\": \"MachinePamHID910\",\r\n \"csname\": \"产量\",\r\n \"xsws\": \"0\",\r\n\r\n \"sdz\": \"20\",\r\n \"pcz\": \"5\"\r\n },\r\n {\r\n \"sswg\": \"lan-box2\",\r\n \"cskey\": \"MachinePamHID917\",\r\n \"csname\": \"主轴转速\",\r\n \"xsws\": \"0\",\r\n\r\n \"sdz\": \"2000\",\r\n \"pcz\": \"100\"\r\n },\r\n {\r\n \"sswg\": \"wlan-box1\",\r\n \"cskey\": \"MachinePamHID909\",\r\n \"csname\": \"急停状态\",\r\n \"xsws\": \"0\",\r\n\r\n \"sdz\": \"1\",\r\n \"pcz\": \"0\"\r\n },\r\n {\r\n \"sswg\": \"wlan-box2\",\r\n \"cskey\": \"MachinePamHID928\",\r\n \"csname\": \"切削速度\",\r\n \"xsws\": \"0\",\r\n\r\n \"sdz\": \"500\",\r\n \"pcz\": \"50\"\r\n }\r\n ]', '2023-11-03 13:30:03', '2', NULL, NULL);
|
||
|
||
SET FOREIGN_KEY_CHECKS = 1;
|