1 CREATE TABLE _request (
6 mailing_list_id INTEGER,
8 CONSTRAINT _request_mailing_list_id_fk FOREIGN KEY(mailing_list_id) REFERENCES mailinglist (id)
10 CREATE TABLE address (
15 verified_on TIMESTAMP,
16 registered_on TIMESTAMP,
18 preferences_id INTEGER,
20 CONSTRAINT address_user_id_fk FOREIGN KEY(user_id) REFERENCES user (id),
21 CONSTRAINT address_preferences_id_fk FOREIGN KEY(preferences_id) REFERENCES preferences (id)
23 CREATE TABLE language (
28 CREATE TABLE mailinglist (
34 admin_member_chunksize INTEGER,
35 hold_and_cmd_autoresponses BLOB,
36 next_request_id INTEGER,
37 next_digest_number INTEGER,
39 postings_responses BLOB,
40 request_responses BLOB,
41 digest_last_sent_at NUMERIC(10, 2),
44 last_post_time TIMESTAMP,
45 accept_these_nonmembers BLOB,
46 acceptable_aliases BLOB,
47 admin_immed_notify BOOLEAN,
48 admin_notify_mchanges BOOLEAN,
49 administrivia BOOLEAN,
51 anonymous_list BOOLEAN,
53 archive_private BOOLEAN,
54 archive_volume_frequency INTEGER,
55 autorespond_admin BOOLEAN,
56 autorespond_postings BOOLEAN,
57 autorespond_requests INTEGER,
58 autoresponse_admin_text TEXT,
59 autoresponse_graceperiod TEXT,
60 autoresponse_postings_text TEXT,
61 autoresponse_request_text TEXT,
63 bounce_info_stale_after TEXT,
64 bounce_matching_headers TEXT,
65 bounce_notify_owner_on_disable BOOLEAN,
66 bounce_notify_owner_on_removal BOOLEAN,
67 bounce_processing BOOLEAN,
68 bounce_score_threshold INTEGER,
69 bounce_unrecognized_goes_to_list_owner BOOLEAN,
70 bounce_you_are_disabled_warnings INTEGER,
71 bounce_you_are_disabled_warnings_interval TEXT,
72 collapse_alternatives BOOLEAN,
73 convert_html_to_plaintext BOOLEAN,
74 default_member_moderation BOOLEAN,
78 digest_is_default BOOLEAN,
79 digest_send_periodic BOOLEAN,
80 digest_size_threshold INTEGER,
81 digest_volume_frequency INTEGER,
83 discard_these_nonmembers BLOB,
85 encode_ascii_prefixes BOOLEAN,
86 filter_action INTEGER,
87 filter_content BOOLEAN,
88 filter_filename_extensions BLOB,
89 filter_mime_types BLOB,
90 first_strip_reply_to BOOLEAN,
91 forward_auto_discards BOOLEAN,
92 gateway_to_mail BOOLEAN,
93 gateway_to_news BOOLEAN,
94 generic_nonmember_action INTEGER,
96 header_filter_rules BLOB,
97 hold_these_nonmembers BLOB,
98 include_list_post_header BOOLEAN,
99 include_rfc2369_headers BOOLEAN,
101 linked_newsgroup TEXT,
102 max_days_to_hold INTEGER,
103 max_message_size INTEGER,
104 max_num_recipients INTEGER,
105 member_moderation_action BOOLEAN,
106 member_moderation_notice TEXT,
107 mime_is_default_digest BOOLEAN,
108 moderator_password TEXT,
111 new_member_options INTEGER,
112 news_moderation TEXT,
113 news_prefix_subject_too BOOLEAN,
115 nondigestable BOOLEAN,
116 nonmember_rejection_notice TEXT,
117 obscure_addresses BOOLEAN,
118 pass_filename_extensions BLOB,
119 pass_mime_types BLOB,
122 preferred_language TEXT,
123 private_roster BOOLEAN,
125 reject_these_nonmembers BLOB,
126 reply_goes_to_list TEXT,
127 reply_to_address TEXT,
128 require_explicit_destination BOOLEAN,
129 respond_to_post_requests BOOLEAN,
130 scrub_nondigest BOOLEAN,
131 send_goodbye_msg BOOLEAN,
132 send_reminders BOOLEAN,
133 send_welcome_msg BOOLEAN,
135 subscribe_auto_approval BLOB,
136 subscribe_policy INTEGER,
138 topics_bodylines_limit INTEGER,
139 topics_enabled BOOLEAN,
140 unsubscribe_policy INTEGER,
144 CREATE TABLE member (
148 is_moderated BOOLEAN,
150 preferences_id INTEGER,
152 CONSTRAINT member_address_id_fk FOREIGN KEY(address_id) REFERENCES address (id),
153 CONSTRAINT member_preferences_id_fk FOREIGN KEY(preferences_id) REFERENCES preferences (id)
155 CREATE TABLE message (
157 message_id_hash TEXT,
162 CREATE TABLE pended (
165 expiration_date TIMESTAMP,
168 CREATE TABLE pendedkeyvalue (
174 CONSTRAINT pendedkeyvalue_pended_id_fk FOREIGN KEY(pended_id) REFERENCES pended (id)
176 CREATE TABLE preferences (
178 acknowledge_posts BOOLEAN,
179 hide_address BOOLEAN,
180 preferred_language TEXT,
181 receive_list_copy BOOLEAN,
182 receive_own_postings BOOLEAN,
184 delivery_status TEXT,
191 preferences_id INTEGER,
193 CONSTRAINT user_preferences_id_fk FOREIGN KEY(preferences_id) REFERENCES preferences (id)
195 CREATE TABLE version (
201 CREATE INDEX ix__request_mailing_list_id ON _request (mailing_list_id);
202 CREATE INDEX ix_address_preferences_id ON address (preferences_id);
203 CREATE INDEX ix_address_user_id ON address (user_id);
204 CREATE INDEX ix_member_address_id ON member (address_id);
205 CREATE INDEX ix_member_preferences_id ON member (preferences_id);
206 CREATE INDEX ix_pendedkeyvalue_pended_id ON pendedkeyvalue (pended_id);
207 CREATE INDEX ix_user_preferences_id ON user (preferences_id);