Michael Kummer wrote:
alter table mailboxes add foreign key (owner_idnr) references
users(user_idnr) on delete cascade;
alter table messages add foreign key (mailbox_idnr) references
mailboxes(mailbox_idnr) on delete cascade;
alter table messageblks add foreign key (message_idnr) references
messages(message_idnr) on delete cascade;
this only works with innodb doesnt it?
what happens when issueing the commands with a default installation of
dbmail?
Nothing basically.
I've tested it on a dbmail/innodb installation with mysql-3.23.48. No
problem there. The innodb docs state that 'on delete' isn't really
supported before 3.23.50. But monty has always been very clear about
external references: Any such statement is accepted but silently ignored
by the parser for all table types that don't support them.
--
________________________________________________________________
Paul Stevens mailto:[EMAIL PROTECTED]
NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED]
The Netherlands________________________________http://www.nfg.nl
