ts/SQL/CreateTable_SQLServer.sqlbook

-- SQLBook: Code
-- Active: 1749101395601@@192.1.3.105@1433@EQM_BJ
-- 创建 tExecPlan 表 (SQL Server)
IF NOT EXISTS (SELECT 1 FROM sys.tables t WHERE t.name = N'tExecPlan' AND t.schema_id = SCHEMA_ID(N'dbo'))
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)
IF NOT EXISTS (SELECT 1 FROM sys.tables t WHERE t.name = N'tExecPlanConfig' AND t.schema_id = SCHEMA_ID(N'dbo'))
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)
IF DB_ID(N'EQM_CESHI') IS NULL CREATE DATABASE EQM_CESHI;
GO
USE EQM_CESHI;
GO
IF NOT EXISTS (SELECT 1 FROM sys.tables t WHERE t.name = N'tExecPlanTemplate' AND t.schema_id = SCHEMA_ID(N'dbo'))
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
GO
-- SQLBook: Code