Mailman 3.0 Database

This is a simple list of all the tables and their content in the upcoming Mailman 3.0 core database. This hasn't been made pretty with a picture illustrating the tables but it gives us an idea what we have to work with at least. PK indicates the primary key.

The database is taken from the create table script which is distributed with the source code. These are the tables, their content is listed below each table.

• id INTEGER NOT NULL, PK
• “key” TEXT,
• request_type TEXT,
• data_hash TEXT,
• mailing_list_id INTEGER,

• id INTEGER NOT NULL, PK
• “alias” TEXT NOT NULL,
• mailing_list_id INTEGER NOT NULL,

• id INTEGER NOT NULL, PK
• address TEXT,
• _original TEXT,
• real_name TEXT,
• verified_on TIMESTAMP,
• registered_on TIMESTAMP,
• user_id INTEGER,
• preferences_id INTEGER,

• id INTEGER NOT NULL, PK
• address_id INTEGER,
• mailing_list_id INTEGER,
• response_type INTEGER,
• date_sent TIMESTAMP,

• id INTEGER NOT NULL, PK
• mailing_list_id INTEGER,
• filter_pattern TEXT,
• filter_type INTEGER,

• id INTEGER NOT NULL, PK
• email_host TEXT,
• base_url TEXT,
• description TEXT,
• contact_address TEXT,

• id INTEGER NOT NULL, PK
• code TEXT,

• id INTEGER NOT NULL, PK
• – List identity
• list_name TEXT,
• host_name TEXT,
• list_id TEXT,
• include_list_post_header BOOLEAN,
• include_rfc2369_headers BOOLEAN,
• – Attributes not directly modifiable via the web u/i
• created_at TIMESTAMP,
• admin_member_chunksize INTEGER,
• next_request_id INTEGER,
• next_digest_number INTEGER,
• digest_last_sent_at TIMESTAMP,
• volume INTEGER,
• last_post_time TIMESTAMP,
• accept_these_nonmembers BLOB,
• acceptable_aliases_id INTEGER,
• admin_immed_notify BOOLEAN,
• admin_notify_mchanges BOOLEAN,
• administrivia BOOLEAN,
• advertised BOOLEAN,
• anonymous_list BOOLEAN,
• archive BOOLEAN,
• archive_private BOOLEAN,
• archive_volume_frequency INTEGER,
• – Automatic responses.
• autorespond_owner INTEGER,
• autoresponse_owner_text TEXT,
• autorespond_postings INTEGER,
• autoresponse_postings_text TEXT,
• autorespond_requests INTEGER,
• autoresponse_request_text TEXT,
• autoresponse_grace_period TEXT,
• – Bounce and ban.
• ban_list BLOB,
• bounce_info_stale_after TEXT,
• bounce_matching_headers TEXT,
• bounce_notify_owner_on_disable BOOLEAN,
• bounce_notify_owner_on_removal BOOLEAN,
• bounce_processing BOOLEAN,
• bounce_score_threshold INTEGER,
• bounce_unrecognized_goes_to_list_owner BOOLEAN,
• bounce_you_are_disabled_warnings INTEGER,
• bounce_you_are_disabled_warnings_interval TEXT,
• – Content filtering.
• filter_content BOOLEAN,
• collapse_alternatives BOOLEAN,
• convert_html_to_plaintext BOOLEAN,
• default_member_moderation BOOLEAN,
• description TEXT,
• digest_footer TEXT,
• digest_header TEXT,
• digest_is_default BOOLEAN,
• digest_send_periodic BOOLEAN,
• digest_size_threshold INTEGER,
• digest_volume_frequency TEXT,
• digestable BOOLEAN,
• discard_these_nonmembers BLOB,
• emergency BOOLEAN,
• encode_ascii_prefixes BOOLEAN,
• first_strip_reply_to BOOLEAN,
• forward_auto_discards BOOLEAN,
• gateway_to_mail BOOLEAN,
• gateway_to_news BOOLEAN,
• generic_nonmember_action INTEGER,
• goodbye_msg TEXT,
• header_matches BLOB,
• hold_these_nonmembers BLOB,
• info TEXT,
• linked_newsgroup TEXT,
• max_days_to_hold INTEGER,
• max_message_size INTEGER,
• max_num_recipients INTEGER,
• member_moderation_action BOOLEAN,
• member_moderation_notice TEXT,
• mime_is_default_digest BOOLEAN,
• moderator_password TEXT,
• msg_footer TEXT,
• msg_header TEXT,
• new_member_options INTEGER,
• news_moderation TEXT,
• news_prefix_subject_too BOOLEAN,
• nntp_host TEXT,
• nondigestable BOOLEAN,
• nonmember_rejection_notice TEXT,
• obscure_addresses BOOLEAN,
• personalize TEXT,
• pipeline TEXT,
• post_id INTEGER,
• preferred_language TEXT,
• private_roster BOOLEAN,
• real_name TEXT,
• reject_these_nonmembers BLOB,
• reply_goes_to_list TEXT,
• reply_to_address TEXT,
• require_explicit_destination BOOLEAN,
• respond_to_post_requests BOOLEAN,
• scrub_nondigest BOOLEAN,
• send_goodbye_msg BOOLEAN,
• send_reminders BOOLEAN,
• send_welcome_msg BOOLEAN,
• start_chain TEXT,
• subject_prefix TEXT,
• subscribe_auto_approval BLOB,
• subscribe_policy INTEGER,
• topics BLOB,
• topics_bodylines_limit INTEGER,
• topics_enabled BOOLEAN,
• unsubscribe_policy INTEGER,
• welcome_msg TEXT,

• id INTEGER NOT NULL, PK
• role TEXT,
• mailing_list TEXT,
• is_moderated BOOLEAN,
• address_id INTEGER,
• preferences_id INTEGER,

• id INTEGER NOT NULL, PK
• message_id_hash TEXT,
• path TEXT,
• message_id TEXT,

• id INTEGER NOT NULL, PK
• mailing_list_id INTEGER,
• address_id INTEGER,
• delivery_mode TEXT,

• id INTEGER NOT NULL, PK
• token TEXT,
• expiration_date TIMESTAMP,

• id INTEGER NOT NULL, PK
• “key” TEXT,
• value TEXT,
• pended_id INTEGER,

• id INTEGER NOT NULL, PK
• acknowledge_posts BOOLEAN,
• hide_address BOOLEAN,
• preferred_language TEXT,
• receive_list_copy BOOLEAN,
• receive_own_postings BOOLEAN,
• delivery_mode TEXT,
• delivery_status TEXT,

• id INTEGER NOT NULL, PK
• real_name TEXT,
• password TEXT,
• preferences_id INTEGER,

• id INTEGER NOT NULL, PK
• component TEXT,
• version INTEGER,