On Delete Cascade.....!!!!!

[ingo]

hi guys,
i have an ON DELETE CASCADE that is self-referential. I am trying to cascade a delete through a table with PK and FK constraint.

CREATE TABLE `folder` (
`folder_num` bigint(16) unsigned NOT NULL auto_increment,
`folder_num_par` bigint(16) unsigned default '0',
`user_num` int(11) unsigned NOT NULL default '0',
`folder_name` longtext NOT NULL,
`used_count` bigint(16) unsigned NOT NULL default '0',
`used_bytes` bigint(16) unsigned NOT NULL default '0',
`modified` datetime default '0000-00-00 00:00:00',
PRIMARY KEY (`folder_num`),
KEY `folder_Index2` (`folder_num_par`),
KEY `user_num` (`user_num`),
CONSTRAINT `folder_ibfk_1` FOREIGN KEY (`folder_num_par`) REFERENCES `folder` (`folder_num`) ON DELETE CASCADE,
CONSTRAINT `folder_ibfk_2` FOREIGN KEY (`user_num`) REFERENCES `user` (`user_num`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1

For rela -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Silasa]

try to compile MySQL yourself and then you can raise the limit.
good luck -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[waqar]

Originally Posted by Silasa

try to compile MySQL yourself and then you can raise the limit.
good luck

i will suggest the same , good luck from my side as well -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --