XdCxRhDW/DbMigrate/dwpt.sql

/*
 Navicat Premium Data Transfer

 Source Server         : mysql-local2
 Source Server Type    : MySQL
 Source Server Version : 90300
 Source Host           : 192.168.101.3:3306
 Source Schema         : dwpt

 Target Server Type    : MySQL
 Target Server Version : 90300
 File Encoding         : 65001

 Date: 07/05/2025 22:33:18
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for cgres
-- ----------------------------
DROP TABLE IF EXISTS `cgres`;
CREATE TABLE `cgres`  (
  `ID` bigint NOT NULL AUTO_INCREMENT,
  `SigTime` datetime(3) NOT NULL,
  `StationResID` bigint NOT NULL,
  `TaskID` int NOT NULL,
  `FixedStationID` int NULL DEFAULT NULL,
  `Dto1` double NULL DEFAULT NULL,
  `Dfo1` double NULL DEFAULT NULL,
  `Snr1` double NULL DEFAULT NULL,
  `Dto2` double NULL DEFAULT NULL,
  `Dfo2` double NULL DEFAULT NULL,
  `Snr2` double NULL DEFAULT NULL,
  `DtoCdb` double NULL DEFAULT NULL,
  `DfoCdb` double NULL DEFAULT NULL,
  `SnrCdb` double NULL DEFAULT NULL,
  `YbMainDto` double NULL DEFAULT NULL,
  `YbMainDfo` double NULL DEFAULT NULL,
  `YbMainSnr` double NULL DEFAULT NULL,
  `YbAdja1Dto` double NULL DEFAULT NULL,
  `YbAdja1Dfo` double NULL DEFAULT NULL,
  `YbAdja1Snr` double NULL DEFAULT NULL,
  `YbAdja2Dto` double NULL DEFAULT NULL,
  `YbAdja2Dfo` double NULL DEFAULT NULL,
  `YbAdja2Snr` double NULL DEFAULT NULL,
  `TarFreqUp` double NULL DEFAULT NULL,
  `TarFreqDown` double NULL DEFAULT NULL,
  `RefFreqUp` double NULL DEFAULT NULL,
  `RefFreqDown` double NULL DEFAULT NULL,
  `MainCode` int NULL DEFAULT NULL,
  `Adja1Code` int NULL DEFAULT NULL,
  `Adja2Code` int NULL DEFAULT NULL,
  `MainXlTime` datetime(3) NULL DEFAULT NULL,
  `Adja1XlTime` datetime(3) NULL DEFAULT NULL,
  `Adja2XlTime` datetime(3) NULL DEFAULT NULL,
  `MainX` double NULL DEFAULT NULL,
  `MainY` double NULL DEFAULT NULL,
  `MainZ` double NULL DEFAULT NULL,
  `MainVx` double NULL DEFAULT NULL,
  `MainVy` double NULL DEFAULT NULL,
  `MainVz` double NULL DEFAULT NULL,
  `Adja1X` double NULL DEFAULT NULL,
  `Adja1Y` double NULL DEFAULT NULL,
  `Adja1Z` double NULL DEFAULT NULL,
  `Adja1Vx` double NULL DEFAULT NULL,
  `Adja1Vy` double NULL DEFAULT NULL,
  `Adja1Vz` double NULL DEFAULT NULL,
  `Adja2X` double NULL DEFAULT NULL,
  `Adja2Y` double NULL DEFAULT NULL,
  `Adja2Z` double NULL DEFAULT NULL,
  `Adja2Vx` double NULL DEFAULT NULL,
  `Adja2Vy` double NULL DEFAULT NULL,
  `Adja2Vz` double NULL DEFAULT NULL,
  `CreateTime` datetime(3) NOT NULL,
  `UpdateTime` datetime(3) NOT NULL,
  `Deleted` int NOT NULL,
  PRIMARY KEY (`ID`, `SigTime`) USING BTREE,
  UNIQUE INDEX `ID`(`SigTime` DESC, `ID` ASC) USING BTREE,
  INDEX `FixedStationID`(`FixedStationID` ASC) USING BTREE,
  INDEX `StationResID`(`StationResID` ASC) USING BTREE,
  INDEX `Deleted`(`Deleted` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1641 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC PARTITION BY RANGE (to_days(`SigTime`))
PARTITIONS 1
(PARTITION `p_future` VALUES LESS THAN (MAXVALUE) ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 )
;

-- ----------------------------
-- Table structure for cgxgfres
-- ----------------------------
DROP TABLE IF EXISTS `cgxgfres`;
CREATE TABLE `cgxgfres`  (
  `ID` bigint NOT NULL AUTO_INCREMENT,
  `CgResID` bigint NOT NULL,
  `CgType` int NOT NULL,
  `SigTime` datetime(3) NOT NULL,
  `Dto` double NULL DEFAULT NULL,
  `Dfo` double NULL DEFAULT NULL,
  `Snr` double NULL DEFAULT NULL,
  `CreateTime` datetime(3) NOT NULL,
  `UpdateTime` datetime(3) NOT NULL,
  `Deleted` int NOT NULL,
  PRIMARY KEY (`ID`, `SigTime`) USING BTREE,
  UNIQUE INDEX `ID`(`SigTime` DESC, `ID` ASC) USING BTREE,
  INDEX `CgResID`(`CgResID` ASC) USING BTREE,
  INDEX `Deleted`(`Deleted` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC PARTITION BY RANGE (to_days(`SigTime`))
PARTITIONS 1
(PARTITION `p_future` VALUES LESS THAN (MAXVALUE) ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 )
;

-- ----------------------------
-- Table structure for checkres
-- ----------------------------
DROP TABLE IF EXISTS `checkres`;
CREATE TABLE `checkres`  (
  `ID` bigint NOT NULL AUTO_INCREMENT,
  `FileName` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `PosCheckType` int NULL DEFAULT NULL,
  `SmpStart` bigint NULL DEFAULT NULL,
  `SmpCount` bigint NULL DEFAULT NULL,
  `SigTime` datetime(3) NOT NULL,
  `UserName` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `ModType` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `ModRate` double NULL DEFAULT NULL,
  `FfcHz` double NULL DEFAULT NULL,
  `Snr` double NULL DEFAULT NULL,
  `CreateTime` datetime(3) NOT NULL,
  `UpdateTime` datetime(3) NOT NULL,
  `Deleted` int NOT NULL,
  PRIMARY KEY (`ID`, `SigTime`) USING BTREE,
  UNIQUE INDEX `ID`(`SigTime` DESC, `ID` ASC) USING BTREE,
  INDEX `Deleted`(`Deleted` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1641 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for cxres
-- ----------------------------
DROP TABLE IF EXISTS `cxres`;
CREATE TABLE `cxres`  (
  `ID` bigint NOT NULL AUTO_INCREMENT,
  `SigTime` datetime(3) NOT NULL,
  `Fx` double NOT NULL,
  `CreateTime` datetime(3) NOT NULL,
  `UpdateTime` datetime(3) NOT NULL,
  `Deleted` int NOT NULL,
  PRIMARY KEY (`ID`, `SigTime`) USING BTREE,
  UNIQUE INDEX `ID`(`SigTime` DESC, `ID` ASC) USING BTREE,
  INDEX `Deleted`(`Deleted` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC PARTITION BY RANGE (to_days(`SigTime`))
PARTITIONS 1
(PARTITION `p_future` VALUES LESS THAN (MAXVALUE) ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 )
;

-- ----------------------------
-- Table structure for fixedstation
-- ----------------------------
DROP TABLE IF EXISTS `fixedstation`;
CREATE TABLE `fixedstation`  (
  `ID` int NOT NULL AUTO_INCREMENT,
  `StationName` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `Lon` double NOT NULL,
  `Lat` double NOT NULL,
  `FreqUpHz` bigint NOT NULL,
  `Value` double NOT NULL,
  `SpareField` double NOT NULL,
  `Enable` tinyint(1) NOT NULL,
  `CreateTime` datetime(3) NOT NULL,
  `UpdateTime` datetime(3) NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE,
  UNIQUE INDEX `ID`(`ID` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for logres
-- ----------------------------
DROP TABLE IF EXISTS `logres`;
CREATE TABLE `logres`  (
  `ID` bigint NOT NULL AUTO_INCREMENT,
  `Module` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `LogTime` datetime(3) NOT NULL,
  `LogType` int NOT NULL,
  `Msg` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `CreateTime` datetime(3) NOT NULL,
  `UpdateTime` datetime(3) NOT NULL,
  `Deleted` int NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE,
  UNIQUE INDEX `ID`(`ID` ASC) USING BTREE,
  INDEX `Module`(`Module`(10) ASC) USING BTREE,
  INDEX `LogTime`(`LogTime` ASC) USING BTREE,
  INDEX `LogType`(`LogType` ASC) USING BTREE,
  INDEX `Deleted`(`Deleted` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for posres
-- ----------------------------
DROP TABLE IF EXISTS `posres`;
CREATE TABLE `posres`  (
  `ID` bigint NOT NULL AUTO_INCREMENT,
  `TaskInfoID` int NOT NULL,
  `FreqUpHz` bigint NOT NULL,
  `StationResID` bigint NOT NULL,
  `CxResID` bigint NULL DEFAULT NULL,
  `CgResID` bigint NOT NULL,
  `TargetInfoID` int NULL DEFAULT NULL,
  `CheckResID` bigint NULL DEFAULT NULL,
  `PosResType` int NOT NULL,
  `TargetState` int NOT NULL,
  `SigTime` datetime(3) NOT NULL,
  `PosLon` double NOT NULL,
  `PosLat` double NOT NULL,
  `MirrLon` double NOT NULL,
  `MirrLat` double NOT NULL,
  `Confidence` int NOT NULL,
  `CreateTime` datetime(3) NOT NULL,
  `UpdateTime` datetime(3) NOT NULL,
  `Deleted` int NOT NULL,
  PRIMARY KEY (`ID`, `SigTime`) USING BTREE,
  UNIQUE INDEX `ID`(`SigTime` DESC, `ID` ASC) USING BTREE,
  INDEX `CgResID`(`CgResID` ASC) USING BTREE,
  INDEX `CheckResID`(`CheckResID` ASC) USING BTREE,
  INDEX `CxResID`(`CxResID` ASC) USING BTREE,
  INDEX `StationResID`(`StationResID` ASC) USING BTREE,
  INDEX `Deleted`(`Deleted` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 54901 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC PARTITION BY RANGE (to_days(`SigTime`))
PARTITIONS 1
(PARTITION `p_future` VALUES LESS THAN (MAXVALUE) ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 )
;

-- ----------------------------
-- Table structure for satinfo
-- ----------------------------
DROP TABLE IF EXISTS `satinfo`;
CREATE TABLE `satinfo`  (
  `ID` int NOT NULL AUTO_INCREMENT,
  `SatCode` int NOT NULL,
  `SatName` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `SatLon` double NULL DEFAULT NULL,
  `SatTrans` double NULL DEFAULT NULL,
  `CreateTime` datetime(3) NOT NULL,
  `UpdateTime` datetime(3) NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE,
  UNIQUE INDEX `ID`(`ID` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for sigdelay
-- ----------------------------
DROP TABLE IF EXISTS `sigdelay`;
CREATE TABLE `sigdelay`  (
  `ID` int NOT NULL AUTO_INCREMENT,
  `SigInfoId` int NOT NULL,
  `SatInfoSatCode` int NOT NULL,
  `Sat` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `Delay` double NOT NULL,
  `CreateTime` datetime(3) NOT NULL,
  `UpdateTime` datetime(3) NOT NULL,
  `SatInfo_ID` int NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE,
  UNIQUE INDEX `ID`(`ID` ASC) USING BTREE,
  INDEX `SatInfo_ID`(`SatInfo_ID` ASC) USING BTREE,
  INDEX `SigInfoId`(`SigInfoId` ASC) USING BTREE,
  CONSTRAINT `SigDelay_SatInfo` FOREIGN KEY (`SatInfo_ID`) REFERENCES `satinfo` (`ID`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `SigDelay_SigInfo` FOREIGN KEY (`SigInfoId`) REFERENCES `siginfo` (`ID`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for siginfo
-- ----------------------------
DROP TABLE IF EXISTS `siginfo`;
CREATE TABLE `siginfo`  (
  `ID` int NOT NULL AUTO_INCREMENT,
  `FreqUp` bigint NOT NULL,
  `FreqDown` bigint NOT NULL,
  `SigType` int NOT NULL,
  `Snr` double NOT NULL,
  `Band` double NULL DEFAULT NULL,
  `CreateTime` datetime(3) NOT NULL,
  `UpdateTime` datetime(3) NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE,
  UNIQUE INDEX `ID`(`ID` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for stationres
-- ----------------------------
DROP TABLE IF EXISTS `stationres`;
CREATE TABLE `stationres`  (
  `ID` bigint NOT NULL AUTO_INCREMENT,
  `SigTime` datetime(3) NOT NULL,
  `SatTxLon` double NOT NULL,
  `SatTxLat` double NOT NULL,
  `CdbTxLon` double NULL DEFAULT NULL,
  `CdbTxLat` double NULL DEFAULT NULL,
  `CxLon` double NULL DEFAULT NULL,
  `CxLat` double NULL DEFAULT NULL,
  `RefLon` double NULL DEFAULT NULL,
  `RefLat` double NULL DEFAULT NULL,
  `CreateTime` datetime(3) NOT NULL,
  `UpdateTime` datetime(3) NOT NULL,
  `Deleted` int NOT NULL,
  PRIMARY KEY (`ID`, `SigTime`) USING BTREE,
  UNIQUE INDEX `ID`(`SigTime` DESC, `ID` ASC) USING BTREE,
  INDEX `Deleted`(`Deleted` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1641 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for syssetings
-- ----------------------------
DROP TABLE IF EXISTS `syssetings`;
CREATE TABLE `syssetings`  (
  `ID` int NOT NULL AUTO_INCREMENT,
  `TimeZoneID` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `TimeZoneUTC` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `TimeZoneName` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `ZoneHours` double NOT NULL,
  `HttpPort` int NOT NULL,
  `XLDirectory` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `YDPZThreshold` int NOT NULL,
  `MapType` int NOT NULL,
  `WmtsSource` int NOT NULL,
  `MapLayerType` int NOT NULL,
  `CreateTime` datetime(3) NOT NULL,
  `UpdateTime` datetime(3) NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE,
  UNIQUE INDEX `ID`(`ID` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for targetinfo
-- ----------------------------
DROP TABLE IF EXISTS `targetinfo`;
CREATE TABLE `targetinfo`  (
  `ID` int NOT NULL AUTO_INCREMENT,
  `TargetName` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `TargeColor` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `CreateTime` datetime(3) NOT NULL,
  `UpdateTime` datetime(3) NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE,
  UNIQUE INDEX `ID`(`ID` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for taskinfo
-- ----------------------------
DROP TABLE IF EXISTS `taskinfo`;
CREATE TABLE `taskinfo`  (
  `ID` int NOT NULL AUTO_INCREMENT,
  `TaskState` int NOT NULL,
  `TaskName` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `TaskType` int NOT NULL,
  `PosType` int NOT NULL,
  `MainSat` int NOT NULL,
  `Adja1Sat` int NULL DEFAULT NULL,
  `Adja2Sat` int NULL DEFAULT NULL,
  `CapDir` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `CapDirFormat` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `CreateTime` datetime(3) NOT NULL,
  `UpdateTime` datetime(3) NOT NULL,
  `MaxSigTime` datetime(3) NULL,
  `MinSigTime` datetime(3) NULL,
  PRIMARY KEY (`ID`) USING BTREE,
  UNIQUE INDEX `ID`(`ID` ASC) USING BTREE,
  INDEX `UpdateTime`(`UpdateTime` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for taskrunnninginfo
-- ----------------------------
DROP TABLE IF EXISTS `taskrunnninginfo`;
CREATE TABLE `taskrunnninginfo`  (
  `ID` int NOT NULL AUTO_INCREMENT,
  `TaskID` int NOT NULL,
  `FreqUp` bigint NOT NULL,
  `LastDoneAdFileTime` datetime(3) NOT NULL,
  `CreateTime` datetime(3) NOT NULL,
  `UpdateTime` datetime(3) NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE,
  UNIQUE INDEX `ID`(`ID` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for tasksig
-- ----------------------------
DROP TABLE IF EXISTS `tasksig`;
CREATE TABLE `tasksig`  (
  `ID` int NOT NULL AUTO_INCREMENT,
  `TaskInfoID` int NOT NULL,
  `SigInfoID` int NOT NULL,
  `FreqUp` bigint NOT NULL,
  `FreqDown` bigint NOT NULL,
  `CreateTime` datetime(3) NOT NULL,
  `UpdateTime` datetime(3) NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE,
  UNIQUE INDEX `ID`(`ID` ASC) USING BTREE,
  INDEX `SigInfoID`(`SigInfoID` ASC) USING BTREE,
  INDEX `TaskInfoID`(`TaskInfoID` ASC) USING BTREE,
  CONSTRAINT `TaskSig_SigInfo` FOREIGN KEY (`SigInfoID`) REFERENCES `siginfo` (`ID`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `TaskSig_TaskInfo` FOREIGN KEY (`TaskInfoID`) REFERENCES `taskinfo` (`ID`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for txinfo
-- ----------------------------
DROP TABLE IF EXISTS `txinfo`;
CREATE TABLE `txinfo`  (
  `ID` int NOT NULL AUTO_INCREMENT,
  `Name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `TxType` int NOT NULL,
  `Lon` double NOT NULL,
  `Lat` double NOT NULL,
  `SatInfoID` int NULL DEFAULT NULL,
  `CreateTime` datetime(3) NOT NULL,
  `UpdateTime` datetime(3) NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE,
  UNIQUE INDEX `ID`(`ID` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for xlinfo
-- ----------------------------
DROP TABLE IF EXISTS `xlinfo`;
CREATE TABLE `xlinfo`  (
  `ID` int NOT NULL AUTO_INCREMENT,
  `SatCode` int NOT NULL,
  `SatName` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `TimeUTC` datetime(3) NOT NULL,
  `Lon` double NULL DEFAULT NULL,
  `Line1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `Line2` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `CreateTime` datetime(3) NOT NULL,
  `UpdateTime` datetime(3) NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE,
  UNIQUE INDEX `ID`(`ID` ASC) USING BTREE,
  INDEX `IX_XlInfo_SatCode_TimeUTC`(`SatCode` ASC, `TimeUTC` ASC) USING BTREE,
  INDEX `IX_XlInfo_SatCode`(`SatCode` ASC) USING BTREE,
  INDEX `IX_XlInfo_TimeUTC`(`TimeUTC` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

SET FOREIGN_KEY_CHECKS = 1;