-- -------------------------------------------------------- -- 主机: 127.0.0.1 -- 服务器版本: 8.0.40 - MySQL Community Server - GPL -- 服务器操作系统: Win64 -- HeidiSQL 版本: 12.8.0.6908 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET NAMES utf8 */; /*!50503 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- 导出 hbg_cupdataturnover 的数据库结构 CREATE DATABASE IF NOT EXISTS `hbg_cupdataturnover` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */; USE `hbg_cupdataturnover`; -- 导出 表 hbg_cupdataturnover.dataturnover 结构 CREATE TABLE IF NOT EXISTS `dataturnover` ( `equipNum` varchar(100) DEFAULT NULL, `containerCode` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `identification` varchar(100) DEFAULT NULL, `message` varchar(100) DEFAULT NULL, `Time` datetime DEFAULT NULL, KEY `索引 1` (`identification`), KEY `索引 2` (`containerCode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- 正在导出表 hbg_cupdataturnover.dataturnover 的数据：~2,874 rows (大约) INSERT INTO `dataturnover` (`equipNum`, `containerCode`, `identification`, `message`, `Time`) VALUES ('431RLM02', '431130509', 'ERROR', 'OK', '2026-04-30 02:35:05'), ('431RLM02', '431131147', 'ERROR', 'OK', '2026-04-30 02:35:10'), ('431MSD01', '43113208', '0ZZCE54431B00SG790006808', '不良品复投', '2026-07-13 11:27:43'), ('431MSD01', '43113082', '0ZZCE54431A00SG790008511', '不良品复投', '2026-07-13 12:41:35'), ('431RLM01', '431130344', '-1563477178196', 'OK', '2026-07-16 19:46:48'), ('431RLM01', '431131717', '0ZZCE11431A00SG800060108', 'OK', '2026-09-01 15:04:14'), ('431RLM01', '491001030', '0ZZCE11431A00SG800060137', 'OK', '2026-09-01 15:04:14'), ('431RLM01', '491004552', '0ZZCE11431A00SG800060159', 'OK', '2026-09-01 15:04:14'), ('431RLM01', '431132274', '0ZZCE11431A00SG800060158', 'OK', '2026-09-01 15:04:14'), ('431RLM01', '431250067', '0ZZCE11431A00SG800034230', 'OK', '2026-09-01 15:04:14'), ('431RLM01', '431130633', '0ZZCE11431A00SG800034169', 'OK', '2026-09-01 15:04:14'), ('431RLM01', '431131917', '0ZZCE11431A00SG800034168', 'OK', '2026-09-01 15:04:14'), ('431RLM01', '431130466', '0ZZCE11431A00SG800034167', 'OK', '2026-09-01 15:04:14'), ('431RLM01', '', 'Z0CZ5E44130AS04G0P002391', 'OK', '2026-09-03 17:30:47'), ('431RLM01', '', 'Z0CZ5E44130AS04G0P001358', 'OK', '2026-09-03 17:30:47'), ('431RLM01', '', 'Z0CZ5E44130AS04G0P008318', 'OK', '2026-09-03 17:30:47'), ('431RLM01', '', 'Z0CZ1E41130BS01G0Y003052', 'OK', '2026-09-03 17:30:47'), ('431RLM01', '', '', 'OK', '2026-09-05 16:30:07'); -- 导出 表 hbg_cupdataturnover.dataturnoverlog 结构 CREATE TABLE IF NOT EXISTS `dataturnoverlog` ( `LogID` bigint NOT NULL AUTO_INCREMENT, `equipNum` varchar(100) DEFAULT NULL, `containerCode` varchar(100) NOT NULL, `identification` varchar(100) DEFAULT NULL, `message` varchar(100) DEFAULT NULL, `Time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, `Operation` varchar(50) DEFAULT NULL, PRIMARY KEY (`LogID`) ) ENGINE=InnoDB AUTO_INCREMENT=38289091 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- 正在导出表 hbg_cupdataturnover.dataturnoverlog 的数据：~654,675 rows (大约) INSERT INTO `dataturnoverlog` (`LogID`, `equipNum`, `containerCode`, `identification`, `message`, `Time`, `Operation`) VALUES (37630787, '43FTDM01', '431901421', '0ZZCE11431A00SG8Y0007996', 'OK', '2026-08-31 08:46:15', 'INSERT'), (37630788, '43FTDM01', '431902538', '0ZZCE11431A00SG8Y0007995', 'OK', '2026-08-31 08:46:15', 'INSERT'), (37630789, '43FTDM01', '431902334', '0ZZCE11431A00SG8Y0008041', 'OK', '2026-08-31 08:46:15', 'INSERT'), (37630790, '43FTDM01', '431902189', '0ZZCE11431A00SG8Y0007998', 'OK', '2026-08-31 08:46:15', 'INSERT'), (37630791, '43FTDM01', '431910177', '0ZZCE11431A00SG8Y0007966', 'OK', '2026-08-31 08:46:15', 'INSERT'), (37630792, '43FTDM01', '431908859', '0ZZCE11431A00SG8Y0007899', 'OK', '2026-08-31 08:46:15', 'INSERT'), (37630793, '43FTDM01', '431903323', '0ZZCE11431A00SG8Y0007470', 'OK', '2026-08-31 08:46:15', 'INSERT'), (37631120, '43FTDM01', '431902353', '0ZZCE11431B00SG8Y0000361', 'OK', '2026-08-31 09:05:47', 'DELETE'), (37631121, '43FTDM01', '431902431', '0ZZCE11431B00SG8Y0000360', 'OK', '2026-08-31 09:05:47', 'DELETE'), (37631122, '43FTDM01', '431903689', '0ZZCE11431B00SG8Y0000359', 'OK', '2026-08-31 09:05:47', 'DELETE'), (37631123, '43FTDM01', '431907037', '0ZZCE11431B00SG8Y0000321', 'OK', '2026-08-31 09:05:47', 'DELETE'), (37631124, '43FTDM01', '431902049', '0ZZCE11431B00SG8Y0000320', 'OK', '2026-08-31 09:05:47', 'DELETE'), (37631125, '43FTDM01', '431901221', '0ZZCE11431B00SG8Y0000319', 'OK', '2026-08-31 09:05:47', 'DELETE'), (37631126, '43FTDM01', '431901765', '0ZZCE11431B00SG8Y0000327', 'OK', '2026-08-31 09:05:47', 'DELETE'), (37631127, '43FTDM01', '431901222', '0ZZCE11431B00SG8Y0000357', 'OK', '2026-08-31 09:06:01', 'DELETE'), (37631128, '43FTDM01', '431901439', '0ZZCE11431B00SG8Y0000363', 'OK', '2026-08-31 09:06:01', 'DELETE'), (37631129, '43FTDM01', '431901493', '0ZZCE11431B00SG8Y0000355', 'OK', '2026-08-31 09:06:01', 'DELETE'), (37631130, '43FTDM01', '431902338', '0ZZCE11431B00SG8Y0000343', 'OK', '2026-08-31 09:06:01', 'DELETE'), (37631131, '43FTDM01', '431902044', '0ZZCE11431B00SG8Y0000342', 'OK', '2026-08-31 09:06:01', 'DELETE'), (37631132, '43FTDM01', '431901873', '0ZZCE11431B00SG8Y0000341', 'OK', '2026-08-31 09:06:01', 'DELETE'), (37631133, '43FTDM01', '431910209', '0ZZCE11431B00SG8Y0000324', 'OK', '2026-08-31 09:06:01', 'DELETE'), (37631134, '43FTDM01', '431902418', '0ZZCE11431B00SG8Y0000323', 'OK', '2026-08-31 09:06:01', 'DELETE'), (37631135, '43FTDM01', '431907123', '0ZZCE11431B00SG8Y0000350', 'OK', '2026-08-31 09:06:01', 'DELETE'), (37631136, '43FTDM01', '431902278', '0ZZCE11431B00SG8Y0000349', 'OK', '2026-08-31 09:06:01', 'DELETE'), (37631137, '43FTDM01', '431909682', '0ZZCE11431B00SG8Y0000325', 'OK', '2026-08-31 09:06:02', 'DELETE'), (37631138, '43FTDM01', '431902429', '0ZZCE11431B00SG8Y0000314', 'OK', '2026-08-31 09:06:02', 'DELETE'), (37631139, '43FTDM01', '431902048', '0ZZCE11431B00SG8Y0000317', 'OK', '2026-08-31 09:06:02', 'DELETE'), (37631140, '43FTDM01', '431901794', '0ZZCE11431B00SG8Y0000318', 'OK', '2026-08-31 09:06:02', 'DELETE'), (37631141, '43FTDM01', '431901229', '0ZZCE11431B00SG8Y0000282', 'OK', '2026-08-31 09:06:02', 'DELETE'); -- 导出 表 hbg_cupdataturnover.dataturnover_af 结构 CREATE TABLE IF NOT EXISTS `dataturnover_af` ( `equipNum` varchar(100) DEFAULT NULL, `containerCode` varchar(100) NOT NULL, `identification` varchar(100) DEFAULT NULL, `message` varchar(100) DEFAULT NULL, `Time` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- 正在导出表 hbg_cupdataturnover.dataturnover_af 的数据：~0 rows (大约) -- 导出 事件 hbg_cupdataturnover.deleteFtngresult 结构 DELIMITER // CREATE EVENT `deleteFtngresult` ON SCHEDULE EVERY 1 DAY STARTS '2025-07-24 08:00:00' ON COMPLETION PRESERVE ENABLE DO BEGIN delete FROM ftngresult f WHERE NOW() - INTERVAL 7 DAY >=f.TestTime; delete FROM dataturnoverlog t WHERE NOW() - INTERVAL 6 DAY >=t.Time; END// DELIMITER ; -- 导出 表 hbg_cupdataturnover.ftngresult 结构 CREATE TABLE IF NOT EXISTS `ftngresult` ( `ID` int NOT NULL AUTO_INCREMENT, `ChannelNo` int DEFAULT NULL COMMENT '通道', `TestTime` datetime DEFAULT NULL COMMENT '时间', `BarCode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '条码', `ScanBarRest` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '扫码结果', `MesRest` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'Mes结果', `JiXinRest` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '极性结果', `JiuPianRest` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '纠偏结果', `YanPingPressureRest` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '压平压力结果', `HanQianHipotIRRest` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '焊前Hipot阻值结果', `HanQianVDRest` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '焊前Hipot跌落电压结果', `ZhengJiWaiLouRest` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '正极外漏结果', `FuJiWaiLouRest` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '负极外漏结果', `ZhengJiDuanMianRest` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '正极端面结果', `FuJiDuanMianRest` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '负极端面结果', `CellLengthRest` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '电芯长度结果', `CenterHoleRest` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '中心口检测结果', `JiErWaiFangRest` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '极耳外翻结果', `HanJiePressureRest` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '焊接压力结果', `HanJieSizeRest` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '焊接尺寸结果', `HanHouHipotIRRest` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '焊后hipot阻值结果', `HanHouVDRest` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '焊后Hipot跌落电压结果', PRIMARY KEY (`ID`) ) ENGINE=InnoDB AUTO_INCREMENT=11651 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- 正在导出表 hbg_cupdataturnover.ftngresult 的数据：~0 rows (大约) -- 导出 表 hbg_cupdataturnover.temprfidtable 结构 CREATE TABLE IF NOT EXISTS `temprfidtable` ( `equipNum` varchar(50) DEFAULT NULL, `RFID` varchar(50) NOT NULL, `BarCode` varchar(50) DEFAULT NULL, `message` int DEFAULT NULL, `TestTime` date DEFAULT NULL, PRIMARY KEY (`RFID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- 正在导出表 hbg_cupdataturnover.temprfidtable 的数据：~0 rows (大约) -- 导出 触发器 hbg_cupdataturnover.trg_DataTurnover_AfterDelete 结构 SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'; DELIMITER // CREATE TRIGGER `trg_DataTurnover_AfterDelete` AFTER DELETE ON `dataturnover` FOR EACH ROW BEGIN INSERT INTO DataTurnoverLog ( equipNum, containerCode, identification, message, Time, Operation ) VALUES ( OLD.equipNum, OLD.containerCode, OLD.identification, OLD.message, NOW(), 'DELETE' ); END// DELIMITER ; SET SQL_MODE=@OLDTMP_SQL_MODE; -- 导出 触发器 hbg_cupdataturnover.trg_DataTurnover_AfterInsert 结构 SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'; DELIMITER // CREATE TRIGGER `trg_DataTurnover_AfterInsert` AFTER INSERT ON `dataturnover` FOR EACH ROW BEGIN INSERT INTO DataTurnoverLog ( equipNum, containerCode, identification, message, Time, Operation ) VALUES ( NEW.equipNum, NEW.containerCode, NEW.identification, NEW.message, NOW(), -- 使用 MySQL 时间函数 'INSERT' ); END// DELIMITER ; SET SQL_MODE=@OLDTMP_SQL_MODE; /*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */; /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */; /*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;