"""Seed staff internal plan (hidden from public catalog, auto-assigned to staff emails).

Revision ID: 029
Revises: 028
"""
from alembic import op

revision = "029"
down_revision = "028"
branch_labels = None
depends_on = None


def upgrade() -> None:
    op.execute("""
        INSERT INTO subscription_plans (
            id, name, slug, description, is_active,
            price_monthly, price_yearly, currency,
            limits, features, sort_order, trial_days
        )
        SELECT
            gen_random_uuid(),
            'Staff',
            'staff',
            'Internal team plan - not shown in public catalog',
            true,
            0,
            0,
            'usd',
            '{"max_projects": 999, "max_members": 50, "included_ai_units": 99999}'::jsonb,
            '{"custom_domain": true, "extra_staff": true}'::jsonb,
            -1,
            0
        WHERE NOT EXISTS (SELECT 1 FROM subscription_plans WHERE slug = 'staff')
    """)


def downgrade() -> None:
    op.execute("DELETE FROM subscription_plans WHERE slug = 'staff'")