A mysql problem. Help me!
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;
推荐阅读
-
深入理解mysql帮助命令(help)
-
Mysqladmin -help 命令_MySQL
-
make me cry make me smile php入门学习知识点一 PHP与MYSql连接与查询
-
Mysql help命令(帮助信息)中文注解_MySQL
-
Mysqladmin -help 命令_MySQL
-
深入理解mysql帮助命令(help)
-
A mysql problem. Help me!
-
Mysql help命令(帮助信息)中文注解_MySQL
-
take me home country roads 图解MYSQL的安装和数据升级第1/2页
-
take me home country roads 基于mysql的论坛(7)