ts/SQL/CreateTable_SQLServer.sqlbook

-- SQLBook: Code
-- 创建 tExecPlan 表 (SQL Server)
IF OBJECT_ID(N'dbo.tExecPlan', N'U') IS NULL
BEGIN
  CREATE TABLE dbo.tExecPlan (
    IncKey INT IDENTITY(1,1) 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)
  );
END;
-- SQLBook: Code
-- 创建 tExecPlanConfig 表 (SQL Server)
IF OBJECT_ID(N'dbo.tExecPlanConfig', N'U') IS NULL
BEGIN
  CREATE TABLE dbo.tExecPlanConfig (
    KeyWord INT PRIMARY KEY,
    Value1 INT,
    UpdateTime VARCHAR(64),
    Notes VARCHAR(255)
  );
END;
-- SQLBook: Code
-- 创建 tExecPlanTemplate 表 (SQL Server)
IF DB_ID(N'EQM_CESHI') IS NULL CREATE DATABASE EQM_CESHI;
GO
USE EQM_CESHI;
IF OBJECT_ID(N'dbo.tExecPlanTemplate', N'U') IS NULL
BEGIN
  CREATE TABLE dbo.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
  );
END;
-- SQLBook: Code