|
From: SourceForge.net <no...@so...> - 2013-01-23 12:38:37
|
Bugs item #3601866, was opened at 2013-01-23 04:30 Message generated for change (Comment added) made by gingerdog You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=3601866&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Database Group: v2.3.5 Status: Open Resolution: None Priority: 5 Private: No Submitted By: Ondřej Kunc () Assigned to: Nobody/Anonymous (nobody) Summary: MySQL schema of postfixadmin lacks of foreign keys Initial Comment: Hi all, I have recently discovered when migrating some mailboxes to postfixadmin, that schema created by 2.3.5 installer doesn't have any foreign keys (except of on_vacation). This at least causes some caveeats when doing some manual modifications/imports into database. You can end up with mailboxes without domain and similar problems. I recommend adding foreign keys there. I you want, I can create patch for this. Please write me if you want it. Ondrej Kunc ---------------------------------------------------------------------- >Comment By: GingerDog (gingerdog) Date: 2013-01-23 04:38 Message: I've not looked at the mysql schema lately, but it used to use MyISAM tables, which don't support foreign keys (or never used to). I don't think there would be a problem migrating the tables to InnoDB, as there aren't any fulltext indexes (afaik). ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=3601866&group_id=191583 |
