jh6pnQ2u

1MySQL: error 150 using ON UPDATE SET NULL and ON DELETE SET NULL, why?
2DROP TABLE IF EXISTS `sf_guard_user`;
3
4
5CREATE TABLE `sf_guard_user`
6(
7    `id` INTEGER(11)  NOT NULL AUTO_INCREMENT,
8    `username` VARCHAR(128)  NOT NULL,
9    PRIMARY KEY (`id`),
10    UNIQUE KEY `sf_guard_user_U_1` (`username`)
11)Type=InnoDB;
12
13
14DROP TABLE IF EXISTS `shop_orders`;
15
16CREATE TABLE `shop_orders`
17(
18    `orders_id` INTEGER(11)  NOT NULL AUTO_INCREMENT,
19    `sfgu_id` INTEGER(11)  NOT NULL,
20
21    PRIMARY KEY (`orders_id`),
22    INDEX `shop_orders_FI_1` (`sfgu_id`),
23    CONSTRAINT `shop_orders_FK_1`
24        FOREIGN KEY (`sfgu_id`)
25        REFERENCES `sf_guard_user` (`id`)
26        ON UPDATE SET NULL
27        ON DELETE SET NULL,
28
29)Type=InnoDB;