使用MySQL官方的Workbench 5.2.3 CE 设计好E-R图之后使用正向工具生成SQL script然后连接数据库执行,结果总是提示错误。
下面是提示错误的部分SQL语句:
-- -----------------------------------------------------
-- Table `GoodsIntroduction`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `GoodsIntroduction` ;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `GoodsIntroduction` (
`id` VARCHAR(16) NOT NULL ,
`introTitle` VARCHAR(700) NOT NULL ,
`titlephoto` VARCHAR(16) NOT NULL ,
`titleExt` VARCHAR(200) NOT NULL ,
`detail` MEDIUMTEXT NOT NULL ,
`state` INT NOT NULL DEFAULT 0 ,
`currentPrice` DECIMAL(10,2) NOT NULL ,
`previousPrice` DECIMAL(10,2) NOT NULL ,
`startdate` TIMESTAMP NOT NULL ,
`minCustomer` INT NOT NULL DEFAULT 0 ,
`maxPerCustomer` INT NOT NULL DEFAULT 0 ,
`quantity` INT NOT NULL DEFAULT 0 ,
`goodsKind` VARCHAR(16) NOT NULL ,
`provider` VARCHAR(16) NOT NULL COMMENT '商品供货商' ,
`consumeAddress` VARCHAR(60) NULL COMMENT '消费地址' ,
`ExtA` VARCHAR(50) NULL ,
`ExtB` VARCHAR(50) NULL ,
`enddate` timestamp NOT NULL,
PRIMARY KEY (`id`) ,
CONSTRAINT `fk-goodsintroduction_goodskind`
FOREIGN KEY (`goodsKind` )
REFERENCES `GoodsKind` (`id` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk-goodsintroduction_photo`
FOREIGN KEY (`titlephoto` )
REFERENCES `Photo` (`id` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk-goodsintroduction_provider_provider`
FOREIGN KEY (`provider` )
REFERENCES `Provider` (`id` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB,
COMMENT = '商品介绍' ;
SHOW WARNINGS;
提示的错误
Error | 1067 | Invalid default value for 'enddate'
自己真的饿是搞不明白,大家谁能够帮忙,谢谢了!