ts/SQL/CreateTable_DM.sqlbook

-- SQLBook: Code
#创建 tExecPlan 表格

#创建表格，全新UI
CREATE TABLE IF NOT EXISTS "tExecPlan" (
    "IncKey" INT PRIMARY KEY AUTO_INCREMENT,
    "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)
);

-- SQLBook: Code
# 创建 tExecPlanConfig 表格

#创建表格
CREATE TABLE IF NOT EXISTS "tExecPlanConfig" (
    "KeyWord" INT PRIMARY KEY,
    "Value1" INT,
    "UpdateTime" VARCHAR(64),
    "Notes" VARCHAR(255)
);
-- SQLBook: Code
#创建 tExecPlanTemplate 表格

#创建执行计划模版，新的UI
CREATE TABLE IF NOT EXISTS "EQM_CESHI"."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
);