Repository :
http://git.fedorahosted.org/cgit/copr.git
On branch : master
---------------------------------------------------------------
commit 3c03f2fa7a40e2d0341492d2f96a681d68803156
Author: Miroslav Suchý <msuchy(a)redhat.com>
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')
+
+