You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
136 lines
12 KiB
136 lines
12 KiB
2 years ago
|
/*
|
||
|
|
Navicat Premium Data Transfer
|
||
|
|
|
||
|
|
Source Server : localhost_3306
|
||
|
|
Source Server Type : MySQL
|
||
|
|
Source Server Version : 80032 (8.0.32)
|
||
|
|
Source Host : localhost:3306
|
||
|
|
Source Schema : hxwcs
|
||
|
|
|
||
|
|
Target Server Type : MySQL
|
||
|
|
Target Server Version : 80032 (8.0.32)
|
||
|
|
File Encoding : 65001
|
||
|
|
|
||
|
|
Date: 06/05/2023 18:01:14
|
||
|
|
*/
|
||
|
|
|
||
|
|
SET NAMES utf8mb4;
|
||
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
||
|
|
|
||
|
|
-- ----------------------------
|
||
|
|
-- Table structure for controller
|
||
|
|
-- ----------------------------
|
||
|
|
DROP TABLE IF EXISTS `controller`;
|
||
|
|
CREATE TABLE `controller` (
|
||
|
|
`CONTROLLER_ID` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
||
|
|
`TYPE` decimal(1, 0) NULL DEFAULT NULL,
|
||
|
|
`CLASS` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
|
||
|
|
`VENDOR` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
||
|
|
`HOST_ADDRESS` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
||
|
|
`PORT_NUMBER` decimal(5, 0) NULL DEFAULT NULL,
|
||
|
|
`MCP_CONNECT` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '可通信标志\r\n※从画面变更了通信的有效·无效时切换 \r\n现在的情况是调用 HOST-IF 的 connect 就是可用连接\r\n调用 disconnect 就不可以连接',
|
||
|
|
`GEM_STATE` decimal(1, 0) NULL DEFAULT NULL COMMENT 'GEM状态，设备状态 \r\n0=NONE\r\n1=INIT\r\n2=PAUSED\r\n3=AUTO\r\n4=PAUSING',
|
||
|
|
`HSMS_STATE` decimal(1, 0) NULL DEFAULT NULL COMMENT 'HSMS状态\r\n0=DISABLED\r\n1=NOT_COMMUNIACTING\r\n2=NOT_SELECTED\r\n3=SELECTED',
|
||
|
|
`CTRL_STATE` decimal(1, 0) NULL DEFAULT NULL COMMENT '控制状态，上线状态 \r\n0=NONE\r\n1=EQUIP_OFFLINE\r\n2=ATTEMPT_ONLINE\r\n3=HOST_OFFLINE\r\n4=LOCAL\r\n5=REMOTE',
|
||
|
|
`T3_TIMEOUT` decimal(10, 0) NULL DEFAULT NULL,
|
||
|
|
`T5_TIMEOUT` decimal(10, 0) NULL DEFAULT NULL,
|
||
|
|
`T6_TIMEOUT` decimal(10, 0) NULL DEFAULT NULL,
|
||
|
|
`T7_TIMEOUT` decimal(10, 0) NULL DEFAULT NULL,
|
||
|
|
`T8_TIMEOUT` decimal(10, 0) NULL DEFAULT NULL,
|
||
|
|
`SYNC_FLAG` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '同步标记',
|
||
|
|
`ENABLED` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '有效或无效标志',
|
||
|
|
`SESSION_ID` decimal(5, 0) NULL DEFAULT NULL COMMENT '会话ID',
|
||
|
|
`RESTRICT_EACH_SHELVES` decimal(1, 0) NULL DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`CONTROLLER_ID`) USING BTREE
|
||
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
|
||
|
|
|
||
|
|
-- ----------------------------
|
||
|
|
-- Records of controller
|
||
|
|
-- ----------------------------
|
||
|
|
INSERT INTO `controller` VALUES ('MQBSK001', 1, 'com.huaxing.wcs.host.equipment.Stocker', 'HXWCS', 'DESKTOP-AT2H2DU', 11022, '0', 2, 3, 5, 45000, 10000, 5000, 10000, 5000, '0', '1', 11022, 0);
|
||
|
|
|
||
|
|
-- ----------------------------
|
||
|
|
-- Table structure for event
|
||
|
|
-- ----------------------------
|
||
|
|
DROP TABLE IF EXISTS `event`;
|
||
|
|
CREATE TABLE `event` (
|
||
|
|
`CONTROLLER_ID` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
||
|
|
`CEID` decimal(5, 0) NOT NULL,
|
||
|
|
`CE_NAME` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
||
|
|
`CLASS` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
||
|
|
`REPORT_ID` decimal(5, 0) NULL DEFAULT NULL,
|
||
|
|
`INTERVAL` decimal(10, 0) NULL DEFAULT NULL,
|
||
|
|
`ENABLED` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`CONTROLLER_ID`, `CEID`) USING BTREE
|
||
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
|
||
|
|
|
||
|
|
-- ----------------------------
|
||
|
|
-- Records of event
|
||
|
|
-- ----------------------------
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 1, 'EquipmentOffline', 'com.hsemi.stkc.host.events.daifuku.stockersem.EquipmentOffline', 1, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 2, 'ControlStatusLocal', 'com.hsemi.stkc.host.events.daifuku.stockersem.ControlStatusLocal', 1, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 3, 'ControlStatusRemote', 'com.hsemi.stkc.host.events.daifuku.stockersem.ControlStatusRemote', 1, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 10, 'MessageRecognition', 'com.hsemi.stkc.host.events.daifuku.stockersem.MessageRecognition', 1, 0, '0');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 11, 'EstablishIntervalTimeChange', 'com.hsemi.stkc.host.events.daifuku.stockersem.EstablishIntervalTimeChange', 1, 0, '0');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 51, 'AlarmCleared', 'com.hsemi.stkc.host.events.daifuku.stockersem.AlarmCleared', 15, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 52, 'AlarmSet', 'com.hsemi.stkc.host.events.daifuku.stockersem.AlarmSet', 15, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 53, 'SCAutoCompleted', 'com.hsemi.stkc.host.events.daifuku.stockersem.SCAutoCompleted', 1, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 54, 'SCAutoInitiated', 'com.hsemi.stkc.host.events.daifuku.stockersem.SCAutoInitiated', 1, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 55, 'SCPauseCompleted', 'com.hsemi.stkc.host.events.daifuku.stockersem.SCPauseCompleted', 1, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 56, 'SCPaused', 'com.hsemi.stkc.host.events.daifuku.stockersem.SCPaused', 1, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 57, 'SCPauseInitiated', 'com.hsemi.stkc.host.events.daifuku.stockersem.custom.SCPauseInitiated', 23, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 101, 'TransferAbortCompleted', 'com.hsemi.stkc.host.events.daifuku.stockersem.TransferAbortCompleted', 3, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 102, 'TransferAbortFailed', 'com.hsemi.stkc.host.events.daifuku.stockersem.TransferAbortFailed', 4, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 103, 'TransferAbortInitiated', 'com.hsemi.stkc.host.events.daifuku.stockersem.TransferAbortInitiated', 4, 1000, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 104, 'TransferCancelCompleted', 'com.hsemi.stkc.host.events.daifuku.stockersem.TransferCancelCompleted', 3, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 105, 'TransferCancelFailed', 'com.hsemi.stkc.host.events.daifuku.stockersem.TransferCancelFailed', 4, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 106, 'TransferCancelInitiated', 'com.hsemi.stkc.host.events.daifuku.stockersem.TransferCancelInitiated', 4, 1000, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 107, 'TransferCompleted', 'com.hsemi.stkc.host.events.daifuku.stockersem.TransferCompleted', 2, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 108, 'TransferInitiated', 'com.hsemi.stkc.host.events.daifuku.stockersem.TransferInitiated', 4, 1000, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 109, 'TransferPaused', 'com.hsemi.stkc.host.events.daifuku.stockersem.TransferPaused', 2, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 110, 'TransferResumed', 'com.hsemi.stkc.host.events.daifuku.stockersem.TransferResumed', 4, 10000, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 151, 'CarrierInstallCompleted', 'com.hsemi.stkc.host.events.daifuku.stockersem.CarrierInstallCompleted', 5, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 152, 'CarrierRemoveCompleted', 'com.hsemi.stkc.host.events.daifuku.stockersem.CarrierRemoveCompleted', 5, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 153, 'CarrierRemoved', 'com.hsemi.stkc.host.events.daifuku.stockersem.CarrierRemoved', 6, 500, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 154, 'CarrierResumed', 'com.hsemi.stkc.host.events.daifuku.stockersem.CarrierResumed', 7, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 155, 'CarrierStored', 'com.hsemi.stkc.host.events.daifuku.stockersem.CarrierStored', 5, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 156, 'CarrierStoredAlt', 'com.hsemi.stkc.host.events.daifuku.stockersem.CarrierStoredAlt', 7, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 157, 'CarrierTransferring', 'com.hsemi.stkc.host.events.daifuku.stockersem.CarrierTransferring', 8, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 158, 'CarrierWaitIn', 'com.hsemi.stkc.host.events.daifuku.stockersem.CarrierWaitIn', 5, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 159, 'CarrierWaitOut', 'com.hsemi.stkc.host.events.daifuku.stockersem.CarrierWaitOut', 9, 1000, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 160, 'ZoneCapacityChange', 'com.hsemi.stkc.host.events.daifuku.stockersem.ZoneCapacityChange', 10, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 201, 'CraneActive', 'com.hsemi.stkc.host.events.daifuku.stockersem.CraneActive', 11, 10000, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 202, 'CraneIdle', 'com.hsemi.stkc.host.events.daifuku.stockersem.CraneIdle', 11, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 251, 'CarrierIDRead', 'com.hsemi.stkc.host.events.daifuku.stockersem.CarrierIDRead', 12, 1000, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 252, 'CarrierLocateCompleted', 'com.hsemi.stkc.host.events.daifuku.stockersem.CarrierLocateCompleted', 13, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 253, 'IDReaderError', 'com.hsemi.stkc.host.events.daifuku.stockersem.IDReaderError', 12, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 254, 'OperatorInitiatedAction', 'com.hsemi.stkc.host.events.daifuku.stockersem.OperatorInitiatedAction', 14, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 260, 'PortOutOfService', 'com.hsemi.stkc.host.events.daifuku.stockersem.PortOutOfService', 19, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 261, 'PortInService', 'com.hsemi.stkc.host.events.daifuku.stockersem.PortInService', 19, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 503, 'UnitAlarmCleared', 'com.hsemi.stkc.host.events.daifuku.stockersem.UnitAlarmCleared', 21, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 504, 'UnitAlarmSet', 'com.hsemi.stkc.host.events.daifuku.stockersem.UnitAlarmSet', 21, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 520, 'ZoneInService', 'com.hsemi.stkc.host.events.daifuku.stockersem.ShelfZoneInService', 22, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 521, 'ZoneOutOfService', 'com.hsemi.stkc.host.events.daifuku.stockersem.ShelfZoneOutOfService', 22, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 530, 'CraneOutOfService', 'com.hsemi.stkc.host.events.daifuku.stockersem.CraneOutOfService', 24, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 531, 'CraneInService', 'com.hsemi.stkc.host.events.daifuku.stockersem.CraneInService', 24, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 603, 'PortTypeInput', 'com.hsemi.stkc.host.events.daifuku.stockersem.PortTypeInput', 19, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 604, 'PortTypeOutput', 'com.hsemi.stkc.host.events.daifuku.stockersem.PortTypeOutput', 19, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 605, 'PortTypeChanging', 'com.hsemi.stkc.host.events.daifuku.stockersem.PortTypeChanging', 19, 2000, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 606, 'EqNoRequest', 'com.hsemi.stkc.host.events.daifuku.stockersem.EqNoRequest', 19, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 607, 'EqLoadRequest', 'com.hsemi.stkc.host.events.daifuku.stockersem.EqLoadRequest', 19, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 608, 'EqUnloadRequest', 'com.hsemi.stkc.host.events.daifuku.stockersem.EqUnloadRequest', 19, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 609, 'EqPresence', 'com.hsemi.stkc.host.events.daifuku.stockersem.EqPresence', 19, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 610, 'EqNoPresence', 'com.hsemi.stkc.host.events.daifuku.stockersem.EqNoPresence', 19, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 611, 'OperatorZoneDataChange', 'com.hsemi.stkc.host.events.daifuku.stockersem.OperatorZoneDataChange', 1, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 614, 'PortAutoMode', 'com.hsemi.stkc.host.events.daifuku.stockersem.PortAutoMode', 21, 0, '0');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 615, 'PortManualMode', 'com.hsemi.stkc.host.events.daifuku.stockersem.PortManualMode', 21, 0, '0');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 616, 'PortModeChanging', 'com.hsemi.stkc.host.events.daifuku.stockersem.PortModeChanging', 21, 5000, '0');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 627, 'ZoneShelfStateChanged', 'com.huaxing.wcs.host.events.ZoneShelfStateChanged', 25, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 681, 'ScanInitiated', 'com.hsemi.stkc.host.events.daifuku.stockersem.ScanInitiated', 5, 1000, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 682, 'ScanCompleted', 'com.hsemi.stkc.host.events.daifuku.stockersem.ScanCompleted', 12, 0, '1');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 811, 'ForkingStarted', 'com.hsemi.stkc.host.events.daifuku.stockersem.csott6.ForkingStarted', 31, 5000, '0');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 812, 'ForkingCompleted', 'com.hsemi.stkc.host.events.daifuku.stockersem.csott6.ForkingCompleted', 31, 0, '0');
|
||
|
|
INSERT INTO `event` VALUES ('MQBSK001', 813, 'ForkRised', 'com.hsemi.stkc.host.events.daifuku.stockersem.csott6.ForkRised', 31, 0, '0');
|
||
|
|
|
||
|
|
SET FOREIGN_KEY_CHECKS = 1;
|