Foreign key script? The create_tables.sql is correct, you did something wrong when created the tables!!
> -----Original Message----- > From: [email protected] [mailto:[email protected]] On > Behalf Of Joan Moreau > Sent: domingo, 15 de Fevereiro de 2009 19:42 > To: DBMail mailinglist > Subject: Re: [Dbmail] Segfault in the git > > thanks, I will try that. > > Is it possible to fix the "fix foreign key' script ? I may not be the > only one with the issue... > > Jorge Bastos wrote: > > > > When you created the tables something went wrong or you created them > > in MyISAM and convert to InnoDB. > > > > The foreign keys are on the create_tables.sql > > > > > > > > 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_subsctiption add FOREIGN KEY mailbox_id_fk > > (mailbox_id) REFERENCES dbmail_mailboxes (mailbox_idnr) ON DELETE > > CASCADE ON UPDATE CASCADE; > > > > > > > > > > > > > > > > *From:* [email protected] [mailto:[email protected]] > > *On Behalf Of *Joan Moreau > > *Sent:* domingo, 15 de Fevereiro de 2009 19:29 > > *To:* DBMail mailinglist > > *Subject:* Re: [Dbmail] Segfault in the git > > > > > > > > CREATE TABLE `dbmail_subscription` ( > > `user_id` bigint(21) NOT NULL DEFAULT '0', > > `mailbox_id` bigint(21) NOT NULL, > > PRIMARY KEY (`user_id`,`mailbox_id`), > > KEY `user_id_index` (`user_id`), > > KEY `mailbox_id_index` (`mailbox_id`) > > ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED > > > > > > Jorge Bastos wrote: > > > > Maybe can you update the "fix foreign keys" script in sql/mysql/ > , so I > > > > can see if this is the case ? > > > > > > > > > > Show us the output of: > > > > > > show create table dbmail_subscription; > > > > _______________________________________________ > > DBmail mailing list > > [email protected] <mailto:[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 _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
