Maison >base de données >tutoriel mysql >A mysql problem. Help me!
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;