"""Move losses thresholds from master_spbu to master_produk.

Revision ID: m9c0d1e2f3a4
Revises: k6f7a8b9c0d1
Create Date: 2026-04-03
"""
from alembic import op
import sqlalchemy as sa

revision = 'm9c0d1e2f3a4'
down_revision = 'k6f7a8b9c0d1'
branch_labels = None
depends_on = None


def upgrade() -> None:
    # Add threshold columns to master_produk
    op.add_column('master_produk', sa.Column(
        'losses_threshold_penerimaan_pct',
        sa.Numeric(6, 3), nullable=False, server_default='0.150'
    ))
    op.add_column('master_produk', sa.Column(
        'losses_threshold_penjualan_pct',
        sa.Numeric(6, 3), nullable=False, server_default='0.500'
    ))
    # Remove from master_spbu
    op.drop_column('master_spbu', 'losses_threshold_penerimaan_pct')
    op.drop_column('master_spbu', 'losses_threshold_penjualan_pct')


def downgrade() -> None:
    op.add_column('master_spbu', sa.Column(
        'losses_threshold_penerimaan_pct',
        sa.Numeric(6, 3), nullable=False, server_default='0.150'
    ))
    op.add_column('master_spbu', sa.Column(
        'losses_threshold_penjualan_pct',
        sa.Numeric(6, 3), nullable=False, server_default='0.500'
    ))
    op.drop_column('master_produk', 'losses_threshold_penerimaan_pct')
    op.drop_column('master_produk', 'losses_threshold_penjualan_pct')