Hum didn't saw that,
But what's inside is correct:
---
SET FOREIGN_KEY_CHECKS=0;
alter table dbmail_subscription drop foreign key user_id_fk;
alter table dbmail_subscription drop foreign key mailbox_id_fk;
alter table dbmail_subscription drop foreign key dbmail_subscription_ibfk_1;
alter table dbmail_subscription drop foreign key dbmail_subscription_ibfk_2;
alter table dbmail_subscription drop foreign key dbmail_subscription_ibfk_3;
alter table dbmail_subscription add FOREIGN KEY user_id_fk (user_id)
REFERENCES dbmail_users (user_idnr) ON DELETE CASCADE ON UPDATE
CASCADE;
alter table dbmail_subscription add FOREIGN KEY mailbox_id_fk (mailbox_id)
REFERENCES dbmail_mailboxes (mailbox_idnr) ON DELETE CASCADE ON
UPDATE CASCADE;
SET FOREIGN_KEY_CHECKS=1;
---
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On
> Behalf Of Joan Moreau
> Sent: domingo, 15 de Fevereiro de 2009 19:47
> To: DBMail mailinglist
> Subject: Re: [Dbmail] Segfault in the git
>
>
> > Foreign key script?
> >
> >
> yes, : dbmail/sql/mysql/fix_foreign_keys.mysql
>
> _______________________________________________
> DBmail mailing list
> [email protected]
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
