but does not work :-(
mysql> SET FOREIGN_KEY_CHECKS=0;
Query OK, 0 rows affected (0.00 sec)
mysql> alter table dbmail_subscription drop foreign key user_id_fk;
ERROR 1025 (HY000): Error on rename of
'./services_dbmail/dbmail_subscription' to
'./services_dbmail/#sql2-f3e-8d22' (errno: 152)
Jorge Bastos wrote:
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
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
