ts/SQL/CreateTable_GBase.sqlbook

-- SQLBook: Code
# 创建 tExecPlan 表 (GBase 8s / 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 表 (GBase)
CREATE TABLE IF NOT EXISTS `tExecPlanConfig` (
  `KeyWord` INT PRIMARY KEY,
  `Value1` INT,
  `UpdateTime` VARCHAR(64),
  `Notes` VARCHAR(255)
);
-- SQLBook: Code
# 创建 tExecPlanTemplate 表 (GBase)
CREATE DATABASE IF NOT EXISTS `EQM_CESHI`;
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