11
CREATE TABLE mailinglist_backup (
16
allow_list_posts BOOLEAN,
17
include_rfc2369_headers BOOLEAN,
18
-- Attributes not directly modifiable via the web u/i
20
admin_member_chunksize INTEGER,
21
next_request_id INTEGER,
22
next_digest_number INTEGER,
23
digest_last_sent_at TIMESTAMP,
25
last_post_at TIMESTAMP,
26
accept_these_nonmembers BLOB,
27
acceptable_aliases_id INTEGER,
28
admin_immed_notify BOOLEAN,
29
admin_notify_mchanges BOOLEAN,
30
administrivia BOOLEAN,
32
anonymous_list BOOLEAN,
33
-- Automatic responses.
34
autorespond_owner INTEGER,
35
autoresponse_owner_text TEXT,
36
autorespond_postings INTEGER,
37
autoresponse_postings_text TEXT,
38
autorespond_requests INTEGER,
39
autoresponse_request_text TEXT,
40
autoresponse_grace_period TEXT,
42
forward_unrecognized_bounces_to INTEGER,
43
process_bounces BOOLEAN,
44
bounce_info_stale_after TEXT,
45
bounce_matching_headers TEXT,
46
bounce_notify_owner_on_disable BOOLEAN,
47
bounce_notify_owner_on_removal BOOLEAN,
48
bounce_score_threshold INTEGER,
49
bounce_you_are_disabled_warnings INTEGER,
50
bounce_you_are_disabled_warnings_interval TEXT,
52
filter_action INTEGER,
53
filter_content BOOLEAN,
54
collapse_alternatives BOOLEAN,
55
convert_html_to_plaintext BOOLEAN,
56
default_member_action INTEGER,
57
default_nonmember_action INTEGER,
59
digest_footer_uri TEXT,
60
digest_header_uri TEXT,
61
digest_is_default BOOLEAN,
62
digest_send_periodic BOOLEAN,
63
digest_size_threshold FLOAT,
64
digest_volume_frequency INTEGER,
66
discard_these_nonmembers BLOB,
68
encode_ascii_prefixes BOOLEAN,
69
first_strip_reply_to BOOLEAN,
71
forward_auto_discards BOOLEAN,
72
gateway_to_mail BOOLEAN,
73
gateway_to_news BOOLEAN,
74
goodbye_message_uri TEXT,
77
hold_these_nonmembers BLOB,
79
linked_newsgroup TEXT,
80
max_days_to_hold INTEGER,
81
max_message_size INTEGER,
82
max_num_recipients INTEGER,
83
member_moderation_notice TEXT,
84
mime_is_default_digest BOOLEAN,
85
moderator_password TEXT,
86
new_member_options INTEGER,
87
nondigestable BOOLEAN,
88
nonmember_rejection_notice TEXT,
89
obscure_addresses BOOLEAN,
95
posting_pipeline TEXT,
96
preferred_language TEXT,
97
private_roster BOOLEAN,
99
reject_these_nonmembers BLOB,
100
reply_goes_to_list INTEGER,
101
reply_to_address TEXT,
102
require_explicit_destination BOOLEAN,
103
respond_to_post_requests BOOLEAN,
104
scrub_nondigest BOOLEAN,
105
send_goodbye_message BOOLEAN,
106
send_reminders BOOLEAN,
107
send_welcome_message BOOLEAN,
109
subscribe_auto_approval BLOB,
110
subscribe_policy INTEGER,
112
topics_bodylines_limit INTEGER,
113
topics_enabled BOOLEAN,
114
unsubscribe_policy INTEGER,
115
welcome_message_uri TEXT,
119
INSERT INTO mailinglist_backup SELECT
124
include_list_post_header,
125
include_rfc2369_headers,
126
-- Attributes not directly modifiable via the web u/i
128
admin_member_chunksize,
134
accept_these_nonmembers,
135
acceptable_aliases_id,
137
admin_notify_mchanges,
141
-- Automatic responses.
143
autoresponse_owner_text,
144
autorespond_postings,
145
autoresponse_postings_text,
146
autorespond_requests,
147
autoresponse_request_text,
148
autoresponse_grace_period,
150
forward_unrecognized_bounces_to,
152
bounce_info_stale_after,
153
bounce_matching_headers,
154
bounce_notify_owner_on_disable,
155
bounce_notify_owner_on_removal,
156
bounce_score_threshold,
157
bounce_you_are_disabled_warnings,
158
bounce_you_are_disabled_warnings_interval,
159
-- Content filtering.
162
collapse_alternatives,
163
convert_html_to_plaintext,
164
default_member_action,
165
default_nonmember_action,
170
digest_send_periodic,
171
digest_size_threshold,
172
digest_volume_frequency,
174
discard_these_nonmembers,
176
encode_ascii_prefixes,
177
first_strip_reply_to,
179
forward_auto_discards,
185
hold_these_nonmembers,
191
member_moderation_notice,
192
mime_is_default_digest,
196
nonmember_rejection_notice,
207
reject_these_nonmembers,
210
require_explicit_destination,
211
respond_to_post_requests,
213
send_goodbye_message,
215
send_welcome_message,
217
subscribe_auto_approval,
220
topics_bodylines_limit,
226
CREATE TABLE member_backup(
230
moderation_action INTEGER,
232
preferences_id INTEGER,
237
INSERT INTO member_backup SELECT
248
ALTER TABLE mailinglist_backup ADD COLUMN archive_policy INTEGER;
249
ALTER TABLE mailinglist_backup ADD COLUMN list_id TEXT;
250
ALTER TABLE mailinglist_backup ADD COLUMN nntp_prefix_subject_too INTEGER;
251
ALTER TABLE mailinglist_backup ADD COLUMN newsgroup_moderation INTEGER;
253
ALTER TABLE member_backup ADD COLUMN list_id TEXT;