"""change_prs_code_to_string

Revision ID: 11468bd7913d
Revises: 8f7bd3021fa2
Create Date: 2021-03-03 10:48:49.474465

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '11468bd7913d'
down_revision = '8f7bd3021fa2'
branch_labels = None
depends_on = None


def upgrade():
    op.drop_constraint('fk_PRSProjectBudget_prs_project_code_GRASProject', 'PRSProjectBudget', type_='foreignkey')

    op.alter_column('GRASProject', 'prs_project_code',
               existing_type=sa.BIGINT(),
               type_=sa.String(),
               existing_nullable=True)
    op.alter_column('PRSProjectBudget', 'prs_project_code',
               existing_type=sa.BIGINT(),
               type_=sa.String(),
               existing_nullable=True)


def downgrade():
    op.drop_constraint('fk_PRSProjectBudget_prs_project_code_GRASProject', 'PRSProjectBudget', type_='foreignkey')

    op.alter_column('PRSProjectBudget', 'prs_project_code',
               existing_type=sa.String(),
               type_=sa.BIGINT(),
               existing_nullable=True)
    op.alter_column('GRASProject', 'prs_project_code',
               existing_type=sa.String(),
               type_=sa.BIGINT(),
               existing_nullable=True)

    op.create_foreign_key(
        op.f('fk_PRSProjectBudget_prs_project_code_GRASProject'),
        'PRSProjectBudget',
        'GRASProject',
        ['prs_project_code'], ['prs_project_code'])