Script 20140423001_add_indexes_py
|
|
1 """add indexes
2
3 Revision ID: 20140423001
4 Revises: 5845661bb37d
5 Create Date: 2014-04-24 11:25:36.216132
6
7 """
8
9
10 revision = '20140423001'
11 down_revision = '5845661bb37d'
12
13 from alembic import op
14
15
17 op.create_index('build_ended_on_canceled_started_on', 'build', ['ended_on', 'canceled', 'started_on'])
18 op.create_index('copr_owner_id', 'copr', ['owner_id'])
19 op.create_index('copr_deleted_name', 'copr', ['deleted', 'name'])
20 op.create_index('copr_chroot_copr_id', 'copr_chroot', ['copr_id'])
21 op.create_index('action_result_action_type', 'action', ['result', 'action_type'])
22 op.create_index('user_openid_name', 'user', ['openid_name'])
23 op.create_index('copr_permission_copr_id', 'copr_permission', ['copr_id'])
24 op.create_index('build_chroot_build_id', 'build_chroot', ['build_id'])
25 op.create_index('user_api_login', 'user', ['api_login'])
26 op.create_index('legal_flag_resolved_on', 'legal_flag', ['resolved_on'])
27
29 op.drop_index('build_ended_on_canceled_started_on')
30 op.drop_index('copr_owner_id')
31 op.drop_index('copr_deleted_name')
32 op.drop_index('copr_chroot_copr_id')
33 op.drop_index('action_result_action_type')
34 op.drop_index('user_openid_name')
35 op.drop_index('copr_permission_copr_id')
36 op.drop_index('build_chroot_build_id')
37 op.drop_index('user_api_login')
38 op.drop_index('legal_flag_resolved_on')
39