1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
|
-- THIS FILE CONTAINS THE SQLITE3 SCHEMA MIGRATION FROM
-- 3.0b2 TO 3.0b3
--
-- AFTER 3.0b3 IS RELEASED YOU MAY NOT EDIT THIS FILE.
-- REMOVALS from the ban table.
-- REM mailing_list
-- ADDS to the ban table.
-- ADD list_id
CREATE TABLE ban_backup (
id INTEGER NOT NULL,
email TEXT,
PRIMARY KEY (id)
);
INSERT INTO ban_backup SELECT
id, email
FROM ban;
ALTER TABLE ban_backup ADD COLUMN list_id TEXT;
-- REMOVALS from the mailinglist table.
-- REM new_member_options
CREATE TABLE ml_backup (
id INTEGER NOT NULL,
list_name TEXT,
mail_host TEXT,
allow_list_posts BOOLEAN,
include_rfc2369_headers BOOLEAN,
created_at TIMESTAMP,
admin_member_chunksize INTEGER,
next_request_id INTEGER,
next_digest_number INTEGER,
digest_last_sent_at TIMESTAMP,
volume INTEGER,
last_post_at TIMESTAMP,
accept_these_nonmembers BLOB,
acceptable_aliases_id INTEGER,
admin_immed_notify BOOLEAN,
admin_notify_mchanges BOOLEAN,
administrivia BOOLEAN,
advertised BOOLEAN,
anonymous_list BOOLEAN,
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,
forward_unrecognized_bounces_to INTEGER,
process_bounces BOOLEAN,
bounce_info_stale_after TEXT,
bounce_matching_headers TEXT,
bounce_notify_owner_on_disable BOOLEAN,
bounce_notify_owner_on_removal BOOLEAN,
bounce_score_threshold INTEGER,
bounce_you_are_disabled_warnings INTEGER,
bounce_you_are_disabled_warnings_interval TEXT,
filter_action INTEGER,
filter_content BOOLEAN,
collapse_alternatives BOOLEAN,
convert_html_to_plaintext BOOLEAN,
default_member_action INTEGER,
default_nonmember_action INTEGER,
description TEXT,
digest_footer_uri TEXT,
digest_header_uri TEXT,
digest_is_default BOOLEAN,
digest_send_periodic BOOLEAN,
digest_size_threshold FLOAT,
digest_volume_frequency INTEGER,
digestable BOOLEAN,
discard_these_nonmembers BLOB,
emergency BOOLEAN,
encode_ascii_prefixes BOOLEAN,
first_strip_reply_to BOOLEAN,
footer_uri TEXT,
forward_auto_discards BOOLEAN,
gateway_to_mail BOOLEAN,
gateway_to_news BOOLEAN,
goodbye_message_uri TEXT,
header_matches BLOB,
header_uri TEXT,
hold_these_nonmembers BLOB,
info TEXT,
linked_newsgroup TEXT,
max_days_to_hold INTEGER,
max_message_size INTEGER,
max_num_recipients INTEGER,
member_moderation_notice TEXT,
mime_is_default_digest BOOLEAN,
moderator_password TEXT,
nondigestable BOOLEAN,
nonmember_rejection_notice TEXT,
obscure_addresses BOOLEAN,
owner_chain TEXT,
owner_pipeline TEXT,
personalize INTEGER,
post_id INTEGER,
posting_chain TEXT,
posting_pipeline TEXT,
preferred_language TEXT,
private_roster BOOLEAN,
display_name TEXT,
reject_these_nonmembers BLOB,
reply_goes_to_list INTEGER,
reply_to_address TEXT,
require_explicit_destination BOOLEAN,
respond_to_post_requests BOOLEAN,
scrub_nondigest BOOLEAN,
send_goodbye_message BOOLEAN,
send_reminders BOOLEAN,
send_welcome_message BOOLEAN,
subject_prefix TEXT,
subscribe_auto_approval BLOB,
subscribe_policy INTEGER,
topics BLOB,
topics_bodylines_limit INTEGER,
topics_enabled BOOLEAN,
unsubscribe_policy INTEGER,
welcome_message_uri TEXT,
archive_policy INTEGER,
list_id TEXT,
nntp_prefix_subject_too INTEGER,
newsgroup_moderation INTEGER,
PRIMARY KEY (id)
);
INSERT INTO ml_backup SELECT
id,
list_name,
mail_host,
allow_list_posts,
include_rfc2369_headers,
created_at,
admin_member_chunksize,
next_request_id,
next_digest_number,
digest_last_sent_at,
volume,
last_post_at,
accept_these_nonmembers,
acceptable_aliases_id,
admin_immed_notify,
admin_notify_mchanges,
administrivia,
advertised,
anonymous_list,
autorespond_owner,
autoresponse_owner_text,
autorespond_postings,
autoresponse_postings_text,
autorespond_requests,
autoresponse_request_text,
autoresponse_grace_period,
forward_unrecognized_bounces_to,
process_bounces,
bounce_info_stale_after,
bounce_matching_headers,
bounce_notify_owner_on_disable,
bounce_notify_owner_on_removal,
bounce_score_threshold,
bounce_you_are_disabled_warnings,
bounce_you_are_disabled_warnings_interval,
filter_action,
filter_content,
collapse_alternatives,
convert_html_to_plaintext,
default_member_action,
default_nonmember_action,
description,
digest_footer_uri,
digest_header_uri,
digest_is_default,
digest_send_periodic,
digest_size_threshold,
digest_volume_frequency,
digestable,
discard_these_nonmembers,
emergency,
encode_ascii_prefixes,
first_strip_reply_to,
footer_uri,
forward_auto_discards,
gateway_to_mail,
gateway_to_news,
goodbye_message_uri,
header_matches,
header_uri,
hold_these_nonmembers,
info,
linked_newsgroup,
max_days_to_hold,
max_message_size,
max_num_recipients,
member_moderation_notice,
mime_is_default_digest,
moderator_password,
nondigestable,
nonmember_rejection_notice,
obscure_addresses,
owner_chain,
owner_pipeline,
personalize,
post_id,
posting_chain,
posting_pipeline,
preferred_language,
private_roster,
display_name,
reject_these_nonmembers,
reply_goes_to_list,
reply_to_address,
require_explicit_destination,
respond_to_post_requests,
scrub_nondigest,
send_goodbye_message,
send_reminders,
send_welcome_message,
subject_prefix,
subscribe_auto_approval,
subscribe_policy,
topics,
topics_bodylines_limit,
topics_enabled,
unsubscribe_policy,
welcome_message_uri,
archive_policy,
list_id,
nntp_prefix_subject_too,
newsgroup_moderation
FROM mailinglist;
|
