"""Store the user who closed an issue in the db

Revision ID: 1f24c9c8efa5
Revises: 6a3ed02ee160
Create Date: 2018-12-04 13:02:57.101095

"""

from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = "1f24c9c8efa5"
down_revision = "6a3ed02ee160"


def upgrade():

    op.add_column(
        "issues",
        sa.Column(
            "closed_by_id",
            sa.Integer,
            sa.ForeignKey("users.id", onupdate="CASCADE"),
        ),
    )


def downgrade():
    op.drop_column("issues", "closed_by_id")