| 12345678910111213141516171819202122232425262728293031323334353637383940 |
- """系统管理审批相关设置（契约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")
|
