ts/SQL/CreateTable_MySQL.sqlbook

-- SQLBook: Code
-- Active: 1756343447531@@192.1.2.49@32124@eqm_ceshi
# 创建 tExecPlan 表 (MySQL)
CREATE TABLE IF NOT EXISTS `tExecPlan` (
  `IncKey` INT AUTO_INCREMENT PRIMARY KEY,
  `ChannelID` INT NOT NULL,
  `ChannelName` VARCHAR(64),
  `OnWeekDay` INT NOT NULL,
  `OnDate` VARCHAR(64) NOT NULL,
  `OnTime` VARCHAR(64) NOT NULL,
  `OffWeekDay` INT NOT NULL,
  `OffDate` VARCHAR(64) NOT NULL,
  `OffTime` VARCHAR(64) NOT NULL,
  `DID` INT,
  `MPID` INT,
  `DeviceName` VARCHAR(64),
  `PTTypeCode` INT,
  `ActionID` INT,
  `ActionName` VARCHAR(64)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- SQLBook: Code
# 创建 tExecPlanConfig 表 (MySQL)
CREATE TABLE IF NOT EXISTS `tExecPlanConfig` (
  `KeyWord` INT PRIMARY KEY,
  `Value1` INT,
  `UpdateTime` VARCHAR(64),
  `Notes` VARCHAR(255)
);
-- SQLBook: Code
# 创建 tExecPlanTemplate 表 (MySQL)
# 包含数据库 EQM_CESHI，若不存在可先创建
CREATE DATABASE IF NOT EXISTS `EQM_CESHI` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
USE `EQM_CESHI`;
CREATE TABLE IF NOT EXISTS `tExecPlanTemplate` (
  `TemplateName` VARCHAR(255) NOT NULL,
  `ChannelID` INT NOT NULL,
  `ChannelName` VARCHAR(255),
  `OnWeekDay` INT NOT NULL,
  `OnDate` VARCHAR(255) NOT NULL,
  `OnTime` VARCHAR(255) NOT NULL,
  `OffWeekDay` INT NOT NULL,
  `OffDate` VARCHAR(255) NOT NULL,
  `OffTime` VARCHAR(255) NOT NULL,
  `DeviceName` VARCHAR(255),
  `ActionName` VARCHAR(255),
  `ActionID` INT
);
-- SQLBook: Code