Eliminate Utils.get_pattern() and in the process, completely revamp

subscription bans so as not to have to rely on BLOBS or pickles in the
database.

Also, be sure to include .rst files in both doctests and in the packaged
tarballs.  With the now awesome reST mode for Emacs, I plan to rename all .txt
doctest files to .rst.

1 files changed, 8 insertions, 2 deletions

diff --git a/src/mailman/database/mailman.sql b/src/mailman/database/mailman.sql
index bb7f9dc57..9d2b015b7 100644
--- a/src/mailman/database/mailman.sql
+++ b/src/mailman/database/mailman.sql
@@ -116,8 +116,7 @@ CREATE TABLE mailinglist (
         autorespond_requests INTEGER,
         autoresponse_request_text TEXT,
         autoresponse_grace_period TEXT,
-        -- Bounce and ban.
-        ban_list BLOB,
+        -- Bounces.
         bounce_info_stale_after TEXT,
         bounce_matching_headers TEXT,
         bounce_notify_owner_on_disable BOOLEAN,
@@ -270,3 +269,10 @@ CREATE INDEX ix_member_address_id ON member (address_id);
 CREATE INDEX ix_member_preferences_id ON member (preferences_id);
 CREATE INDEX ix_pendedkeyvalue_pended_id ON pendedkeyvalue (pended_id);
 CREATE INDEX ix_user_preferences_id ON user (preferences_id);
+
+CREATE TABLE ban (
+    id INTEGER NOT NULL,
+    email TEXT,
+    mailing_list TEXT,
+    PRIMARY KEY (id)
+);