From 3c77c83ec4070e7183482445ff0b9a30398b72f4 Mon Sep 17 00:00:00 2001
From: Barry Warsaw
Date: Tue, 4 Sep 2012 21:31:50 -0400
Subject: * The link between members and the mailing lists they are subscribed
 to, is   now via the RFC 2369 `list_id` instead of the fqdn listname (i.e.
 posting   address).  This is because while the posting address can change if
 the   mailing list is moved to a new server, the list id is fixed.   (LP:
 #1024509)   + IListManager.get_by_list_id() added.   + IListManager.list_ids
 added.   + IMailingList.list_id added.   + Several internal APIs that
 accepted fqdn list names now require list ids,     e.g.
 ISubscriptionService.join() and .find_members().   + IMember.list_id
 attribute added; .mailing_list is now an alias that     retrieves and returns
 the IMailingList.   - list_id added (LP: #1024509)

---
 src/mailman/database/schema/sqlite_20120407000000_01.sql | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'src/mailman/database/schema/sqlite_20120407000000_01.sql')

diff --git a/src/mailman/database/schema/sqlite_20120407000000_01.sql b/src/mailman/database/schema/sqlite_20120407000000_01.sql
index a4eb0adce..c0e752d68 100644
--- a/src/mailman/database/schema/sqlite_20120407000000_01.sql
+++ b/src/mailman/database/schema/sqlite_20120407000000_01.sql
@@ -18,6 +18,7 @@
 -- THESE COLUMNS ARE ADDED BY THE PYTHON MIGRATION LAYER:
 -- ADD allow_list_posts
 -- ADD archive_policy
+-- ADD list_id
 -- ADD newsgroup_moderation
 -- ADD nntp_prefix_subject_too
 
@@ -242,5 +243,6 @@ INSERT INTO ml_backup SELECT
 
 -- Add the new columns.  They'll get inserted at the Python layer.
 ALTER TABLE ml_backup ADD COLUMN archive_policy INTEGER;
+ALTER TABLE ml_backup ADD COLUMN list_id TEXT;
 ALTER TABLE ml_backup ADD COLUMN nntp_prefix_subject_too INTEGER;
 ALTER TABLE ml_backup ADD COLUMN newsgroup_moderation INTEGER;
-- 
cgit v1.3.1

