"""add_phases_order_constraint

Revision ID: 6f1944095fce
Revises: 6086c70437d8
Create Date: 2022-06-29 13:40:03.558830

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '6f1944095fce'
down_revision = '6086c70437d8'
branch_labels = None
depends_on = None


def upgrade():
    op.create_unique_constraint(
        'uq_ProjectPhase_project_id_order',
        'ProjectPhase',
        ['project_id', 'order'],
        deferrable=True,
        initially="DEFERRED"
    )


def downgrade():
    op.drop_constraint('uq_ProjectPhase_project_id_order', 'ProjectPhase')