server1/SQL/ACAServer.sql

-- Active: 1752718919967@@192.1.2.61@5236


#对比项
SELECT *
FROM tACACompareItems;


#对比项通道信息
SELECT *
FROM tACACompareItemRoad;


#ACA系统设置信息
SELECT *
FROM tACASystemConfig;


#对比项一致性对比时段信息
SELECT *
FROM tACADetectPeriod;



#记录文件
SELECT *
FROM tACARecordFile;



#通道信息
SELECT *
FROM tACARoad;




#记录日志
SELECT *
FROM tACARecordLog;

#报警信息
SELECT *
FROM tACAAlarmLog;

#报警文件
SELECT *
FROM tACAAlarmFile;

SELECT *
FROM TEQMSETUP;

SELECT *
FROM tCheckSystemInfo;


#报警信息
SELECT *
FROM tACAAlarmLog

#报警文件信息
SELECT *
FROM tACAAlarmFile;

#插入报警信息
INSERT INTO tACAAlarmInfo (
    ItemID, ItemName, AlarmType, SoundCardNum, SoundCardName, SoundCardRoadNum, CompareRoadNum, CompareRoadName, CompareRoadType, 
    AlarmStartTime, AlarmEndTime, AlarmDuration, AlarmFilePath, FileAlarmStartPos )
VALUES (
    @itemID, @itemName, @alarmType, @soundCardNum, @soundCardName, @soundCardRoadNum, @compareRoadNum, @compareRoadName, @compareRoadType, 
    @alarmStartTime, @alarmEndTime, @alarmDuration, @alarmFilePath, @fileAlarmStartPos );