[Systers-dev] Moving from Pickle Membership to Store in the Postgresql Database

[Anna Granudd]

Hi,
Jen: I'll send you and Robin a copy of what was said.
I attach a text file with all the tables and their content in Mailman 3.0 in
case anyone else but me might find it useful (not sure Mailman allows
attachments but it's worth a try...). I have no idea if Barry plan to update
the core db but it contains quite a lot so it's a good start for us as well
when migrating. I believe they'll use a sqlite3 db.

Thanks,
Anna

On Wed, Jun 9, 2010 at 5:58 PM, Jennifer Redman <jenred at gmail.com> wrote:

>
>
> On Tue, Jun 8, 2010 at 9:12 AM, Jennifer Redman <jenred at gmail.com> wrote:
>
>>
>>
>> On Tue, Jun 8, 2010 at 8:59 AM, Robin Jeffries <robin at jeffries.org>wrote:
>>
>>> And for me also.  Tomorrow == Wed, June 9
>>>
>>>
>> And I can actually make this meeting as well!  Hopefully the time works
>> for Malveeka and Pinar?
>>
>
> And I'm not going to make it after all.  If someone can post the irc logs
> that would be great and I'll take a look this afternoon.
>
> Thanks,
> Jen
>
-------------- next part --------------
Mailman Core has the following tables, PK indicates the primary key.

_request:
    id INTEGER NOT NULL, PK
    "key" TEXT,
    request_type TEXT,
    data_hash TEXT,
    mailing_list_id INTEGER,

acceptablealias
    id INTEGER NOT NULL, PK
    "alias" TEXT NOT NULL,
    mailing_list_id INTEGER NOT NULL,

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

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

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

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

language
    id INTEGER NOT NULL, PK
    code TEXT,

mailinglist
    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,

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

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

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

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

pendedkeyvalue
    id INTEGER NOT NULL, PK
    "key" TEXT,
    value TEXT,
    pended_id INTEGER,

preferences
    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,

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

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