mysql中nullify_这个MySql语句怎么回事

DROPTABLEIFEXISTS`t_saleitem`;CREATETABLE`t_saleitem`(`id`INT(11)NOTNULLAUTO_INCREMENT,`number`INT(11)NOTNULL,`price`DOUBLENOTNULL,`productId`INT(11)NOTNULL,`productName`...

DROP TABLE IF EXISTS `t_saleitem`;

CREATE TABLE `t_saleitem` (

`id` INT(11) NOT NULL AUTO_INCREMENT,

`number` INT(11) NOT NULL,

`price` DOUBLE NOT NULL,

`productId` INT(11) NOT NULL,

`productName` VARCHAR(255) DEFAULT NULL,

`salesOrderId` INT(11) DEFAULT NULL,

PRIMARY KEY (`id`),

KEY `FK2A1C3345854B6B5` (`salesOrderId`),

CONSTRAINT `FK2A1C3345854B6B5` FOREIGN KEY (`salesOrderId`) REFERENCES `t_salesorder` (`id`)

) ENGINE=INNODB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `t_salesorder`;

CREATE TABLE `t_salesorder` (

`id` INT(11) NOT NULL AUTO_INCREMENT,

`QQ` VARCHAR(255) DEFAULT NULL,

`addr` VARCHAR(255) DEFAULT NULL,

`nullify` TINYINT(1) NOT NULL,

`odate` DATETIME DEFAULT NULL,

`orderCode` VARCHAR(255) DEFAULT NULL,

`phone` VARCHAR(255) DEFAULT NULL,

`remark` VARCHAR(255) DEFAULT NULL,

`status` TINYINT(1) NOT NULL,

`user` VARCHAR(255) DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=INNODB DEFAULT CHARSET=utf8;

展开