"""pins.w_percent / h_percent — a note may mark an AREA, not just a point

Revision ID: c4e6a8b0d2f4
Revises: b8d4f2a6c1e3
Create Date: 2026-09-02

"This whole block" is a different remark from "this spot". NULL = a point;
a width and height = the area the note is about, highlighted like a
walkthrough beat while the note is open.
"""
from typing import Sequence, Union

import sqlalchemy as sa
from alembic import op

revision: str = 'c4e6a8b0d2f4'
down_revision: Union[str, Sequence[str], None] = 'b8d4f2a6c1e3'
branch_labels: Union[str, Sequence[str], None] = None
depends_on: Union[str, Sequence[str], None] = None


def upgrade() -> None:
    op.add_column('pins', sa.Column('w_percent', sa.Float(), nullable=True))
    op.add_column('pins', sa.Column('h_percent', sa.Float(), nullable=True))


def downgrade() -> None:
    op.drop_column('pins', 'h_percent')
    op.drop_column('pins', 'w_percent')