>데이터 베이스 >MySQL 튜토리얼 >A mysql problem. Help me!

A mysql problem. Help me!

WBOY
WBOY원래의
2016-06-06 09:33:301046검색

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;

성명:
본 글의 내용은 네티즌들의 자발적인 기여로 작성되었으며, 저작권은 원저작자에게 있습니다. 본 사이트는 이에 상응하는 법적 책임을 지지 않습니다. 표절이나 침해가 의심되는 콘텐츠를 발견한 경우 admin@php.cn으로 문의하세요.