leocrm/alembic/versions/0034_automation_config.py

"""Add automation_config JSONB column to system_settings.

Revision ID: 0034
Revises: 0033_bank_accounts
Create Date: 2026-07-25
"""

from __future__ import annotations

from typing import Sequence, Union

from alembic import op
import sqlalchemy as sa
from sqlalchemy.dialects.postgresql import JSONB

revision: str = "0034_automation_config"
down_revision: Union[str, None] = "0033_bank_accounts"
branch_labels: Union[str, Sequence[str], None] = None
depends_on: Union[str, Sequence[str], None] = None


def upgrade() -> None:
    op.execute("ALTER TABLE system_settings ADD COLUMN IF NOT EXISTS automation_config JSONB")


def downgrade() -> None:
    op.drop_column("system_settings", "automation_config")