Sergey Spiridonov wrote: > Hi > >> No way those are valid messages. I would simply delete them. > > <Looking at entity-relationship-model>: is it enough to > > > DELETE FROM dbmail_messages where physmessage_id=335; > DELETE FROM dbmail_physmessage where id=3335; > DELETE FROM dbmail_messageblks where physmessage_id=3335; > DELETE FROM dbmail_envelope where physmessage_id=3335; > DELETE FROM dbmail_headervalue where physmessage_id=3335; > DELETE FROM dbmail_ccfield WHERE physmessage_id='3335'; > DELETE FROM dbmail_datefield WHERE physmessage_id='3335'; > DELETE FROM dbmail_envelope WHERE physmessage_id='3335'; > DELETE FROM dbmail_fromfield WHERE physmessage_id='3335'; > DELETE FROM dbmail_headervalue WHERE physmessage_id='3335'; > DELETE FROM dbmail_referencesfield WHERE physmessage_id='3335'; > DELETE FROM dbmail_replytofield WHERE physmessage_id='3335'; > DELETE FROM dbmail_subjectfield WHERE physmessage_id='3335'; > DELETE FROM dbmail_tofield WHERE physmessage_id='3335'; > > ? >
just do: DELETE FROM dbmail_physmessage where id=3335; the key-restraints will take care of the rest. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
