blob: 24fc6b9cb855322795e30b613dad62d0163bdb03 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
|
"""Add indexes on the Member table.
Revision ID: 3e09bb4a5dc
Revises: 33bc0099223
Create Date: 2015-12-11 19:16:57.030395
"""
from alembic import op
# Revision identifiers, used by Alembic.
revision = '3e09bb4a5dc'
down_revision = '33bc0099223'
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')
|
