From 08d8cae4f79bdf0a0773efdd2f795411f280cd1e Mon Sep 17 00:00:00 2001
From: Aurélien Bompard
Date: Thu, 14 Jan 2016 16:16:32 +0100
Subject: Delete bans when their associated list is deleted

Also add indexes on the Ban fields that are filtered on.
---
 .../alembic/versions/bfda02ab3a9b_ban_indexes.py   | 23 ++++++++++++++++++++++
 1 file changed, 23 insertions(+)
 create mode 100644 src/mailman/database/alembic/versions/bfda02ab3a9b_ban_indexes.py

(limited to 'src/mailman/database/alembic')

diff --git a/src/mailman/database/alembic/versions/bfda02ab3a9b_ban_indexes.py b/src/mailman/database/alembic/versions/bfda02ab3a9b_ban_indexes.py
new file mode 100644
index 000000000..952b9eeaf
--- /dev/null
+++ b/src/mailman/database/alembic/versions/bfda02ab3a9b_ban_indexes.py
@@ -0,0 +1,23 @@
+"""Ban indexes
+
+Revision ID: bfda02ab3a9b
+Revises: 70af5a4e5790
+Create Date: 2016-01-14 16:15:44.059688
+
+"""
+
+# revision identifiers, used by Alembic.
+revision = 'bfda02ab3a9b'
+down_revision = '781a38e146bf'
+
+from alembic import op
+
+
+def upgrade():
+    op.create_index(op.f('ix_ban_email'), 'ban', ['email'], unique=False)
+    op.create_index(op.f('ix_ban_list_id'), 'ban', ['list_id'], unique=False)
+
+
+def downgrade():
+    op.drop_index(op.f('ix_ban_list_id'), table_name='ban')
+    op.drop_index(op.f('ix_ban_email'), table_name='ban')
-- 
cgit v1.2.3-70-g09d2