"""Геймификация: редкость растения и признак «из 3 вариантов» в xp_events

Revision ID: b7e4d5c6a8f9
Revises: a1f2c3d4e5f6
Create Date: 2026-09-20

"""

from collections.abc import Sequence

import sqlalchemy as sa

from alembic import op

revision: str = "b7e4d5c6a8f9"
down_revision: str | Sequence[str] | None = "a1f2c3d4e5f6"
branch_labels: Sequence[str] | None = None
depends_on: Sequence[str] | None = None


def upgrade() -> None:
    op.add_column(
        "xp_events",
        sa.Column("rarity", sa.String(length=16), nullable=False, server_default="common"),
    )
    op.add_column(
        "xp_events",
        sa.Column("via_options", sa.Boolean(), nullable=False, server_default=sa.false()),
    )


def downgrade() -> None:
    op.drop_column("xp_events", "via_options")
    op.drop_column("xp_events", "rarity")