"""remove_gras_project_external_id_uniqness

Revision ID: 8feffc7c180f
Revises: 22e3392754dc
Create Date: 2021-02-16 15:54:45.300989

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '8feffc7c180f'
down_revision = '22e3392754dc'
branch_labels = None
depends_on = None


def upgrade():
    op.drop_constraint('uq_GRASProject_external_id', 'GRASProject', type_='unique')
    op.create_unique_constraint('uq_GRASProject_external_id_prs_project_code', 'GRASProject', ['external_id', 'prs_project_code'])


def downgrade():
    op.create_unique_constraint('uq_GRASProject_external_id', 'GRASProject', ['external_id'])
    op.drop_constraint('uq_GRASProject_external_id_prs_project_code', 'GRASProject', type_='unique')