From 6f0b236ea33ffe2899e813dc9bcbc58da0cbefee Mon Sep 17 00:00:00 2001
From: Aurélien Bompard
Date: Thu, 14 Jan 2016 15:36:24 +0100
Subject: Add indexes on the MailingList table

Ensure that list_id is unique, and add indexes on two commonly
filtered-on fields: list_name and mail_host.
---
 src/mailman/model/mailinglist.py | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

(limited to 'src/mailman/model')

diff --git a/src/mailman/model/mailinglist.py b/src/mailman/model/mailinglist.py
index f8d1481a2..abc2c57f6 100644
--- a/src/mailman/model/mailinglist.py
+++ b/src/mailman/model/mailinglist.py
@@ -82,9 +82,9 @@ class MailingList(Model):
     # are currently missing.
 
     # List identity
-    list_name = Column(Unicode)
-    mail_host = Column(Unicode)
-    _list_id = Column('list_id', Unicode)
+    list_name = Column(Unicode, index=True)
+    mail_host = Column(Unicode, index=True)
+    _list_id = Column('list_id', Unicode, index=True, unique=True)
     allow_list_posts = Column(Boolean)
     include_rfc2369_headers = Column(Boolean)
     advertised = Column(Boolean)
-- 
cgit v1.3.1