Summary of the "listmessagesmapping_" fields in ListManager

This table provides NNTP with per-list unique incrementing message IDs. The messages_ table has an auto-numbering field which is incremented for every new archive, regardless of which list it came from. Having large gaps in message IDs causes problems for many NNTP viewers, so this table provides a mechanism to make per-list IDs that will not have gaps between the messages for that list, unless messages are deleted.

 

Primary key: none

 

ListID_

Reference to the ListID_ in table lists_ (int, NOT NULL)

ListMessageID_

A unique key for use by NNTP. (int, NOT NULL)

MessageID_

Reference to the MessageID_ in table messages_. (int. NULL)

 

 


members_ messages_