On Thu, 2005-10-20 at 17:28 +0200, Kertész Viktor wrote: > Hi! > > I am currently developing a small web based managing tool for dbmail. I > use dbmail with MySQL. I realized that messages from physmessage table > and so messageblks table are not deleted after deleting a user from > users table. I cannot found any constraint that would do the job. I have > had an old dbmail installation and i thought i am wrong somewhere. But I > have made a new database structure from 2.0.7 and imported all datas > from my old database. (I think the only differences was that the 'on > update' constraint was missing and some properties were at different > columns) With the new database everything works like it should but the > user deletion problem stays. If I delete a user, his messages stay in > the mentioned tables. dbmail-util does not solve the problem. What do > you think? Is this a bug or a feature?
It is a design feature. If dbmail-util fails to clean those messages up when run with the proper flags, then that is a bug. You should be able to get mailboxes and messageblks to automatically go away when a user is deleted by database constraints if you wanted, but not physmessageblks, because multiple messages can reference the same entries there. > In svn trunk database structure is the same. > > Viktor Kertesz > _______________________________________________ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail -- Jesse Norell - [EMAIL PROTECTED] Kentec Communications, Inc.
