summaryrefslogtreecommitdiff
path: root/src/mailman/database
diff options
context:
space:
mode:
authorBarry Warsaw2010-12-29 23:54:08 -0500
committerBarry Warsaw2010-12-29 23:54:08 -0500
commit534e90fea33c52585c74fa9127cca8b70178d5e0 (patch)
tree3a5d4088b5af1a4b310dffba711389ac67792dd2 /src/mailman/database
parenta31184862fc52a3c38059f832d533b137135c1f9 (diff)
downloadmailman-534e90fea33c52585c74fa9127cca8b70178d5e0.tar.gz
mailman-534e90fea33c52585c74fa9127cca8b70178d5e0.tar.zst
mailman-534e90fea33c52585c74fa9127cca8b70178d5e0.zip
Fairly significant change to the way member and nonmember moderation occurs.
Now, nonmembers are represented by a separate roster of IMembers, the latter which has grown a `moderation_action` enum. When that action is `defer`, then the normal processing rules apply. Anything else and the `moderation` chain is jumped to for a shortcut to moderation (which may include immediate acceptance). TODO: handle unregistered nonmembers. Details: * The member-moderation rule is renamed to just moderation, and handles both members and nonmembers (though the latter must currently be registered). * The moderation rule is moved up in the builtin chain. It is now checked after `approved`, `emergency`, and `loop`, but before the normal moderation checks. This means that nonmember postings will be (by default) held much earlier. * IMember.is_moderated is removed. * IMember.moderation_action is added. * IMailingList.default_member_moderation is removed. * IMailingList.default_member_action and IMailingList.default_nonmember_action are added. * MemberRole.nonmember is added.
Diffstat (limited to 'src/mailman/database')
-rw-r--r--src/mailman/database/mailman.sql6
1 files changed, 3 insertions, 3 deletions
diff --git a/src/mailman/database/mailman.sql b/src/mailman/database/mailman.sql
index 4ba71f8f0..cfe44c8e1 100644
--- a/src/mailman/database/mailman.sql
+++ b/src/mailman/database/mailman.sql
@@ -131,7 +131,8 @@ CREATE TABLE mailinglist (
filter_content BOOLEAN,
collapse_alternatives BOOLEAN,
convert_html_to_plaintext BOOLEAN,
- default_member_moderation BOOLEAN,
+ default_member_action INTEGER,
+ default_nonmember_action INTEGER,
description TEXT,
digest_footer TEXT,
digest_header TEXT,
@@ -156,7 +157,6 @@ CREATE TABLE mailinglist (
max_days_to_hold INTEGER,
max_message_size INTEGER,
max_num_recipients INTEGER,
- member_moderation_action INTEGER,
member_moderation_notice TEXT,
mime_is_default_digest BOOLEAN,
moderator_password TEXT,
@@ -199,7 +199,7 @@ CREATE TABLE member (
id INTEGER NOT NULL,
role TEXT,
mailing_list TEXT,
- is_moderated BOOLEAN,
+ moderation_action INTEGER,
address_id INTEGER,
preferences_id INTEGER,
PRIMARY KEY (id),