On Samstag 19 September 2009 Paul J Stevens wrote: > Jorge, > > You're mixing up tables here. > > there is *no* direct connection between messages and partlists. There > *is* a 1-1 connection between physmessages and partlists, and that is > maintained by a database constraint. > > But mimeparts have a 1-N connection to partlists, so no database > constraint there.
Any chance to get an ER diagram for the 2.3 series? http://www.dbmail.org/dokuwiki/doku.php/er-model Would be really nice to have a quick overview, and an idea of how things work. I also used it a lot for the 2.2 series to optimize some queries. mfg zmi -- // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 _______________________________________________ Dbmail-dev mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
