"""Add order source and creator fields

Revision ID: b71c4e92a630
Revises: 8a85dc09c313
"""

from alembic import op
import sqlalchemy as sa


revision = "b71c4e92a630"
down_revision = "8a85dc09c313"
branch_labels = None
depends_on = None


def upgrade():

    op.add_column(
        "orders",
        sa.Column(
            "order_source",
            sa.String(length=20),
            nullable=False,
            server_default="website"
        )
    )

    op.add_column(
        "orders",
        sa.Column(
            "created_by",
            sa.String(length=80),
            nullable=True
        )
    )

    op.alter_column(
        "orders",
        "order_source",
        server_default=None
    )


def downgrade():

    op.drop_column(
        "orders",
        "created_by"
    )

    op.drop_column(
        "orders",
        "order_source"
    )
