"""mat_view_concurrent_unique_ids


Revision ID: e5873c5fd326
Revises: 6b246f7d3a50
Create Date: 2018-12-21 12:19:48.517529

"""

# revision identifiers, used by Alembic.
revision = 'e5873c5fd326'
down_revision = '6b246f7d3a50'
branch_labels = None
depends_on = None

from alembic import op
import sqlalchemy as sa


def upgrade():
    op.execute('''
      create unique index entity_names_refcur_idx on entity_names (name, source, id, col)
    ''')

    op.execute('''
      create unique index in_artists_refcur_idx on in_artists (inid)
    ''')
    op.execute('''
      create unique index twitter_artist_activity_refcur_idx on twitter_artist_activity (eid)
    ''')

    op.execute('''
      create unique index search_table_refcur_idx on search_table (term, matches)
    ''')

    op.execute('''
      create unique index spy_artist_countries_refcur_idx on spy_artist_countries (artist_spyid)
    ''')

    op.execute('''
     create unique index spy_track_olap_refcur_idx on spy_track_olap (spyid)
    ''')



def downgrade():
    pass