From 33a64ede9aa2a6b6c5ebbbbbfbf789bc4d41e3f2 Mon Sep 17 00:00:00 2001
From: Aurélien Bompard
Date: Sat, 12 Dec 2015 10:48:12 +0100
Subject: Add a couple indexes on Member

---
 .../alembic/versions/3e09bb4a5dc_member_indexes.py | 25 ++++++++++++++++++++++
 1 file changed, 25 insertions(+)
 create mode 100644 src/mailman/database/alembic/versions/3e09bb4a5dc_member_indexes.py

(limited to 'src/mailman/database')

diff --git a/src/mailman/database/alembic/versions/3e09bb4a5dc_member_indexes.py b/src/mailman/database/alembic/versions/3e09bb4a5dc_member_indexes.py
new file mode 100644
index 000000000..6c7778ec2
--- /dev/null
+++ b/src/mailman/database/alembic/versions/3e09bb4a5dc_member_indexes.py
@@ -0,0 +1,25 @@
+"""Add indexes on the Member table.
+
+Revision ID: 3e09bb4a5dc
+Revises: 33bc0099223
+Create Date: 2015-12-11 19:16:57.030395
+
+"""
+
+# revision identifiers, used by Alembic.
+revision = '3e09bb4a5dc'
+down_revision = '33bc0099223'
+
+from alembic import op
+
+
+def upgrade():
+    op.create_index(
+        op.f('ix_member_list_id'), 'member', ['list_id'], unique=False)
+    op.create_index(
+        op.f('ix_member_role'), 'member', ['role'], unique=False)
+
+
+def downgrade():
+    op.drop_index(op.f('ix_member_role'), table_name='member')
+    op.drop_index(op.f('ix_member_list_id'), table_name='member')
-- 
cgit v1.3.1