Module deadbeafc0de_add_indexes2
|
|
1 """add indexes2
2
3 Revision ID: deadbeafc0de_add_indexes.py
4 Revises: 10029c92dd0d
5 Create Date: 2019-01-14 14:43:00.000000
6
7 """
8
9
10 revision = 'deadbeafc0de'
11 down_revision = 'deaddeadc0de'
12
13 from alembic import op
14 import sqlalchemy as sa
15
16
18 op.create_index('build_package_idx', 'build', ['package_id'], unique=False)
19 op.create_index('copr_user_id_idx', 'copr', ['user_id'], unique=False)
20 op.create_index('copr_name_group_id_idx', 'copr', ['name', 'group_id'], unique=False)
21 op.create_index('package_copr_id_idx', 'package', ['copr_id'], unique=False)
22 op.create_index('build_user_id_idx', 'build', ['user_id'], unique=False)
23
24
26 op.drop_index('build_user_id_idx', table_name='build')
27 op.drop_index('package_copr_id_idx', table_name='package')
28 op.drop_index('copr_name_group_id_idx', table_name='copr')
29 op.drop_index('copr_user_id_idx', table_name='copr')
30 op.drop_index('build_package_idx', table_name='build')
31