--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/migrations/versions/37eaf74e46b_use_index_shortcuts.py	Tue Oct 28 18:11:16 2014 +0100
@@ -0,0 +1,52 @@
+"""use index shortcuts
+
+Revision ID: 37eaf74e46b
+Revises: 3c78152eb874
+Create Date: 2014-10-28 16:41:05.519404
+
+"""
+
+# revision identifiers, used by Alembic.
+revision = '37eaf74e46b'
+down_revision = '3c78152eb874'
+
+from alembic import op
+import sqlalchemy as sa
+
+
+def upgrade():
+    op.create_index(op.f('ix_annotation_channel'), 'annotation', ['channel'], unique=False)
+    op.create_index(op.f('ix_annotation_event_code'), 'annotation', ['event_code'], unique=False)
+    op.create_index(op.f('ix_annotation_ts'), 'annotation', ['ts'], unique=False)
+    op.drop_index('idx_annotation_channel', table_name='annotation')
+    op.drop_index('idx_annotation_event', table_name='annotation')
+    op.drop_index('idx_annotation_ts', table_name='annotation')
+    op.create_index(op.f('ix_event_active'), 'event', ['active'], unique=False)
+    op.create_index(op.f('ix_event_code'), 'event', ['code'], unique=True)
+    op.create_index(op.f('ix_event_start_date'), 'event', ['start_date'], unique=False)
+    op.drop_index('idx_event_active', table_name='event')
+    op.drop_index('idx_event_code', table_name='event')
+    op.drop_index('idx_event_start_date', table_name='event')
+    op.create_index(op.f('ix_event_session_order'), 'event_session', ['order'], unique=False)
+    op.create_index(op.f('ix_event_session_start_ts'), 'event_session', ['start_ts'], unique=False)
+    op.drop_index('idx_event_session_order', table_name='event_session')
+    op.drop_index('idx_event_session_start_ts', table_name='event_session')
+
+
+def downgrade():
+    op.create_index('idx_event_session_start_ts', 'event_session', ['start_ts'], unique=False)
+    op.create_index('idx_event_session_order', 'event_session', ['order'], unique=False)
+    op.drop_index(op.f('ix_event_session_start_ts'), table_name='event_session')
+    op.drop_index(op.f('ix_event_session_order'), table_name='event_session')
+    op.create_index('idx_event_start_date', 'event', ['start_date'], unique=False)
+    op.create_index('idx_event_code', 'event', ['code'], unique=False)
+    op.create_index('idx_event_active', 'event', ['active'], unique=False)
+    op.drop_index(op.f('ix_event_start_date'), table_name='event')
+    op.drop_index(op.f('ix_event_code'), table_name='event')
+    op.drop_index(op.f('ix_event_active'), table_name='event')
+    op.create_index('idx_annotation_ts', 'annotation', ['ts'], unique=False)
+    op.create_index('idx_annotation_event', 'annotation', ['event_code'], unique=False)
+    op.create_index('idx_annotation_channel', 'annotation', ['channel'], unique=False)
+    op.drop_index(op.f('ix_annotation_ts'), table_name='annotation')
+    op.drop_index(op.f('ix_annotation_event_code'), table_name='annotation')
+    op.drop_index(op.f('ix_annotation_channel'), table_name='annotation')