"""Drop questions.is_shared.

Per-question sharing is gone. The column defaulted to 1 and was only ever set
by a route nothing called, so in practice it divided the bank into "everything"
and "everything, plus your own private ones" — a distinction that cost every
recommendation denominator a join and never changed an answer. Who may see the
bank is decided by the site's own access rules, and who may *manage* a question
by the category grant tree.

Revision ID: b4c5d6e7f809
Revises: a3b4c5d6e7f8
"""
import sqlalchemy as sa
from alembic import op

revision = "b4c5d6e7f809"
down_revision = "a3b4c5d6e7f8"
branch_labels = None
depends_on = None


def upgrade():
    op.drop_column("questions", "is_shared")


def downgrade():
    # Back as it was: visible by default, which is what every row held.
    op.add_column("questions",
                  sa.Column("is_shared", sa.Integer(), nullable=True, server_default="1"))