diff options
Diffstat (limited to 'src/mailman/database')
| -rw-r--r-- | src/mailman/database/alembic/versions/781a38e146bf_mailinglist_indexes.py | 31 |
1 files changed, 31 insertions, 0 deletions
diff --git a/src/mailman/database/alembic/versions/781a38e146bf_mailinglist_indexes.py b/src/mailman/database/alembic/versions/781a38e146bf_mailinglist_indexes.py new file mode 100644 index 000000000..c375fea1c --- /dev/null +++ b/src/mailman/database/alembic/versions/781a38e146bf_mailinglist_indexes.py @@ -0,0 +1,31 @@ +"""MailingList indexes + +Revision ID: 781a38e146bf +Revises: 70af5a4e5790 +Create Date: 2016-01-14 15:34:29.734429 + +""" + +# revision identifiers, used by Alembic. +revision = '781a38e146bf' +down_revision = '70af5a4e5790' + +from alembic import op + + +def upgrade(): + op.create_index( + op.f('ix_mailinglist_list_id'), 'mailinglist', ['list_id'], + unique=True) + op.create_index( + op.f('ix_mailinglist_list_name'), 'mailinglist', ['list_name'], + unique=False) + op.create_index( + op.f('ix_mailinglist_mail_host'), 'mailinglist', ['mail_host'], + unique=False) + + +def downgrade(): + op.drop_index(op.f('ix_mailinglist_mail_host'), table_name='mailinglist') + op.drop_index(op.f('ix_mailinglist_list_name'), table_name='mailinglist') + op.drop_index(op.f('ix_mailinglist_list_id'), table_name='mailinglist') |