[copr] master: add indexes (3c03f2f)

Repository : http://git.fedorahosted.org/cgit/copr.git On branch : master commit 3c03f2fa7a40e2d0341492d2f96a681d68803156 Author: Miroslav Suchý <msuchy(a)redhat.com&gt; Date: Wed Apr 23 16:57:57 2014 +0200 add indexes .../alembic/versions/20140423001_add_indexes.py | 41 ++++++++++++++++++++ 1 files changed, 41 insertions(+), 0 deletions(-) diff --git a/frontend/coprs_frontend/alembic/versions/20140423001_add_indexes.py b/frontend/coprs_frontend/alembic/versions/20140423001_add_indexes.py new file mode 100644 index 0000000..a6c698d --- /dev/null +++ b/frontend/coprs_frontend/alembic/versions/20140423001_add_indexes.py @@ -0,0 +1,41 @@ +"""add indexes + +Revision ID: 20140423001 +Revises: 5845661bb37d +Create Date: 2014-04-24 11:25:36.216132 + +""" + +# revision identifiers, used by Alembic. +revision = '20140423001' +down_revision = '5845661bb37d' + +from alembic import op +import sqlalchemy as sa + + +def upgrade(): + op.create_index('build_ended_on_canceled_started_on', 'build', ['ended_on', 'canceled', 'started_on']) + op.create_index('copr_owner_id', 'copr', ['owner_id']) + op.create_index('copr_deleted_name', 'copr', ['deleted', 'name']) + op.create_index('copr_chroot_copr_id', 'copr_chroot', ['copr_id']) + op.create_index('action_result_action_type', 'action', ['result', 'action_type']) + op.create_index('user_openid_name', 'user', ['openid_name']) + op.create_index('copr_permission_copr_id', 'copr_permission', ['copr_id']) + op.create_index('build_chroot_build_id', 'build_chroot', ['build_id']) + op.create_index('user_api_login', 'user', ['api_login']) + op.create_index('legal_flag_resolved_on', 'legal_flag', ['resolved_on']) + +def downgrade(): + op.drop_index('build_ended_on_canceled_started_on') + op.drop_index('copr_owner_id') + op.drop_index('copr_deleted_name') + op.drop_index('copr_chroot_copr_id') + op.drop_index('action_result_action_type') + op.drop_index('user_openid_name') + op.drop_index('copr_permission_copr_id') + op.drop_index('build_chroot_build_id') + op.drop_index('user_api_login') + op.drop_index('legal_flag_resolved_on') + +