← Back to branch summary

~raj-abhilash1/mailman/sqlalchemy

« back to all changes in this revision

Viewing changes to src/mailman/database/schema/sqlite_20121015000000_01.sql

  • Committer: Barry Warsaw
  • Date: 2014-09-22 23:32:58 UTC
  • mto: This revision was merged to the branch mainline in revision 7267.
  • Revision ID: barry@list.org-20140922233258-fvg9e3j3equ2y915
Migrations will be replaced with Alchemy.

We don't need the raw SQL schema stuff any more.

We don't need the Version table any more.

Show diffs side-by-side

added added

removed removed

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