当前位置:Gxlcms > mysql > Amysqlproblem.Helpme!

Amysqlproblem.Helpme!

时间:2021-07-01 10:21:17 帮助过:23人阅读

mysqlsqlschema

why these statements are wrong ?
these statements are auto generated by mysql workbench

-- MySQL Workbench Forward Engineering

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';


-- Schema SysBaseData



-- Schema SysBaseData


CREATE SCHEMA IF NOT EXISTS SysBaseData DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
SHOW WARNINGS;
USE SysBaseData ;


-- Table SysBaseData.Instruments


CREATE TABLE IF NOT EXISTS SysBaseData.Instruments (
InstrumentID CHAR(32) NOT NULL,
ExchangeID CHAR(12) NOT NULL,
InstrumentName CHAR(24) NULL,
PRIMARY KEY (InstrumentID, ExchangeID))
ENGINE = InnoDB;

SHOW WARNINGS;


-- Table SysBaseData.OrdersGroups


CREATE TABLE IF NOT EXISTS SysBaseData.OrdersGroups (
OrderGroup INT NOT NULL,
OrderRef CHAR(16) NOT NULL,
TradingDay DATE NOT NULL,
PRIMARY KEY (OrderRef, TradingDay, OrderGroup))
ENGINE = InnoDB;

SHOW WARNINGS;


-- Table SysBaseData.ErrorOrderRecords


CREATE TABLE IF NOT EXISTS SysBaseData.ErrorOrderRecords (
InstrumentID CHAR(32) NULL,
ExchangeID CHAR(12) NULL,
OrderPriceType CHAR NULL,
Direction CHAR NULL,
LimitPrice CHAR(16) NULL,
VolumeTotalOriginal INT NULL,
ErrorMsg CHAR(255) NULL,
OrderGroup INT NOT NULL,
OrderRef CHAR(16) NOT NULL,
TradingDay DATE NOT NULL,
PRIMARY KEY (TradingDay, OrderRef, OrderGroup),
CONSTRAINT fk_ErrorOrderRecords_1
FOREIGN KEY (TradingDay , OrderRef , OrderGroup)
REFERENCES SysBaseData.OrdersGroups (TradingDay , OrderRef , OrderGroup)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;

SHOW WARNINGS;

SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;

人气教程排行