mysql外键级联删除

CREATE TABLE `user` ( 
`id` int(4) NOT NULL, 
`sex` enum('f','m') DEFAULT NULL, 
PRIMARY KEY (`id`) 
) ENGINE=InnoDB DEFAULT CHARSET=latin1; 
CREATE TABLE `userinfo` ( 
`sn` int(4) NOT NULL AUTO_INCREMENT, 
`userid` int(4) NOT NULL, 
`info` varchar(20) DEFAULT NULL, 
PRIMARY KEY (`sn`), 
KEY `userid` (`userid`), 
CONSTRAINT `userinfo_ibfk_1` FOREIGN KEY (`userid`) REFERENCES `user` (`id`)ON DELETE CASCADE ON UPDATE CASCADE 
) ENGINE=InnoDB DEFAULT CHARSET=latin1;