"""planning_monthly (Grafana-Panel Planung nach Kategorie)

Revision ID: d5e8b3c7a410
Revises: c4d7e2a91b53
Create Date: 2026-09-28

"""
from typing import Sequence, Union

from alembic import op
import sqlalchemy as sa


revision: str = 'd5e8b3c7a410'
down_revision: Union[str, Sequence[str], None] = 'c4d7e2a91b53'
branch_labels: Union[str, Sequence[str], None] = None
depends_on: Union[str, Sequence[str], None] = None


def upgrade() -> None:
    op.create_table(
        'planning_monthly',
        sa.Column('month', sa.Date(), primary_key=True),
        sa.Column('category', sa.String(length=100), primary_key=True),
        sa.Column('total', sa.Numeric(precision=12, scale=2), nullable=False),
    )


def downgrade() -> None:
    op.drop_table('planning_monthly')