Files
Random-image-api/backend/alembic/versions/20260210_0010_create_runtime_settings.py
2026-02-22 18:58:55 +08:00

31 lines
747 B
Python

from __future__ import annotations
from alembic import op
import sqlalchemy as sa
revision = "20260210_0010"
down_revision = "20260210_0009"
branch_labels = None
depends_on = None
def upgrade() -> None:
op.create_table(
"runtime_settings",
sa.Column("key", sa.Text(), primary_key=True),
sa.Column("value_json", sa.Text(), nullable=False),
sa.Column("description", sa.Text(), nullable=True),
sa.Column(
"updated_at",
sa.Text(),
nullable=False,
server_default=sa.text("(strftime('%Y-%m-%dT%H:%M:%fZ','now'))"),
),
sa.Column("updated_by", sa.Text(), nullable=True),
)
def downgrade() -> None:
op.drop_table("runtime_settings")