"""add_external_key_to_project_budget

Revision ID: 4bff89c6c395
Revises: 71e07a7662dd
Create Date: 2021-02-19 11:34:30.325378

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '4bff89c6c395'
down_revision = '71e07a7662dd'
branch_labels = None
depends_on = None


def upgrade():
    op.add_column('PRSProjectBudget', sa.Column('external_key', sa.String(), nullable=True))
    op.create_unique_constraint('uq_PRSProjectBudget_external_key', 'ArtistMoment', ['external_key'])

def downgrade():
    op.drop_column('PRSProjectBudget', 'external_key')