ts/SQL/CreateTable_SQLServer.sqlbook

-- SQLBook: Code
-- Active: 1749101395601@@192.1.3.105@1433@EQM_BJ
-- 创建 tExecPlan 表 (SQL Server)

BEGIN
    CREATE TABLE dbo.tExecPlan (
        IncKey INT IDENTITY(1,1) NOT NULL PRIMARY KEY,
        ChannelID INT NOT NULL,
        ChannelName VARCHAR(64) NULL,
        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 NULL,
        MPID INT NULL,
        DeviceName VARCHAR(64) NULL,
        PTTypeCode INT NULL,
        ActionID INT NULL,
        ActionName VARCHAR(64) NULL
    );
END
GO
-- SQLBook: Code
-- 创建 tExecPlanConfig 表 (SQL Server)
BEGIN
    CREATE TABLE dbo.tExecPlanConfig (
        KeyWord INT NOT NULL PRIMARY KEY,
        Value1 INT NULL,
        UpdateTime VARCHAR(64) NULL,
        Notes VARCHAR(255) NULL
    );
END
GO
-- SQLBook: Code
-- 创建 tExecPlanTemplate 表 (SQL Server)

BEGIN
    CREATE TABLE dbo.tExecPlanTemplate (
        TemplateName VARCHAR(255) NOT NULL,
        ChannelID INT NOT NULL,
        ChannelName VARCHAR(255) NULL,
        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) NULL,
        ActionName VARCHAR(255) NULL,
        ActionID INT NULL
    );
END

-- SQLBook: Code