Summary of the "listmessagesmapping_" fields in ListManager
Below 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 does not have gaps between the messages for that list, unless messages are deleted.
Primary key: none
Field Name | Description | Version Added |
|---|---|---|
| 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) |