"""系统管理审批相关设置（契约1.54）。

Revision ID: 0045_borrow_settings
Revises: 0044_role_password
Create Date: 2026-09-23

变更要点（Python 版已废弃不做功能实现，仅保持迁移链同步）：
新建 sys_setting 通用键值设置表：调阅说明（borrow.notice 行）与
调阅审批单模板元数据（borrow.template 行，模板文件落盘固定路径），
行不存在即未设置。
"""

from __future__ import annotations

from collections.abc import Sequence

import sqlalchemy as sa
from alembic import op

revision: str = "0045_borrow_settings"
down_revision: str | None = "0044_role_password"
branch_labels: str | Sequence[str] | None = None
depends_on: str | Sequence[str] | None = None


def upgrade() -> None:
    op.create_table(
        "sys_setting",
        sa.Column("setting_key", sa.String(length=64), nullable=False),
        sa.Column("setting_value", sa.Text(), nullable=True),
        sa.Column("file_name", sa.String(length=255), nullable=True),
        sa.Column("file_size", sa.BigInteger(), nullable=True),
        sa.Column("updated_at", sa.DateTime(), nullable=True),
        sa.Column("updated_by", sa.BigInteger(), nullable=True),
        sa.PrimaryKeyConstraint("setting_key"),
    )


def downgrade() -> None:
    op.drop_table("sys_setting")