mysql设置on set null_MySQL：错误150使用ON UPDATE SET NULL和ON DELETE SET NULL,为什么？

我有这个：

DROP TABLE IF EXISTS `sf_guard_user`;

CREATE TABLE `sf_guard_user`

(

`id` INTEGER(11) NOT NULL AUTO_INCREMENT,

`username` VARCHAR(128) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `sf_guard_user_U_1` (`username`)

)Type=InnoDB;

DROP TABLE IF EXISTS `shop_orders`;

CREATE TABLE `shop_orders`

(

`orders_id` INTEGER(11) NOT NULL AUTO_INCREMENT,

`sfgu_id` INTEGER(11) NOT NULL,

PRIMARY KEY (`orders_id`),

INDEX `shop_orders_FI_1` (`sfgu_id`),

CONSTRAINT `shop_orders_FK_1`

FOREIGN KEY (`sfgu_id`)

REFERENCES `sf_guard_user` (`id`)

ON UPDATE SET NULL

ON DELETE SET NULL,

)Type=InnoDB;

我收到这个错误：

1005 – Can’t create table

‘prueba1.shop_orders’ (errno: 150)

如果我不删除ON UPDATE SET NULL和ON DELETE SET NULL行.

知道为什么吗？

问候

哈维