From f38314707ab771f185e427a259f415627f788b14 Mon Sep 17 00:00:00 2001
From: CodeBuddy <codebuddy@local>
Date: Mon, 28 Sep 2026 15:09:07 +0800
Subject: [PATCH] =?utf8?q?POST=20/api/domain-templates=EF=BC=9A=E6=94=AF?=
 =?utf8?q?=E6=8C=81=20abbr=20=E5=AD=97=E6=AE=B5=E4=B8=8E=20editing=20?=
 =?utf8?q?=E7=8A=B6=E6=80=81=EF=BC=88=E4=B8=8E=20PUT=20=E5=AF=B9=E9=BD=90?=
 =?utf8?q?=EF=BC=89?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

- 解析 body.abbr 入库
- status 允许 available/editing/unavailable（原先仅 available/unavailable）
- INSERT 语句增加 abbr 列
---
 db-sidecar.mjs | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

diff --git a/db-sidecar.mjs b/db-sidecar.mjs
index 049d168..02e4d31 100644
--- a/db-sidecar.mjs
+++ b/db-sidecar.mjs
@@ -1912,8 +1912,9 @@ async function handleDomainTemplateCreate(req, res) {
   if (!domain_id) return respondError(res, 400, "请选择所属领域");
   if (!name) return respondError(res, 400, "模板名称不能为空");
   if (!db.prepare("SELECT 1 FROM domains WHERE id=?").get(domain_id)) return respondError(res, 404, "领域不存在");
-  const status = body.status === "unavailable" ? "unavailable" : "available";
-  const info = db.prepare("INSERT INTO domain_templates (domain_id,name,description,status,version,creator) VALUES (?,?,?,?,?,?)").run(domain_id, name, body.description || "", status, (body.version || "V1.0").toString(), (body.creator || "").toString());
+  const abbr = body.abbr != null ? body.abbr.toString().trim() : "";
+  const status = ["available", "editing", "unavailable"].includes(body.status) ? body.status : "available";
+  const info = db.prepare("INSERT INTO domain_templates (domain_id,name,abbr,description,status,version,creator) VALUES (?,?,?,?,?,?,?)").run(domain_id, name, abbr, body.description || "", status, (body.version || "V1.0").toString(), (body.creator || "").toString());
   respondJson(res, 200, { ok: true, id: info.lastInsertRowid });
 }
 
-- 
2.43.0