From ce1ea9ac3806578719070a463ef7381a0d3c5148 Mon Sep 17 00:00:00 2001
From: huminmin <mac@MacBook-Pro.local>
Date: 星期二, 12 五月 2026 17:45:00 +0800
Subject: [PATCH] 分派生产单到班组长，班组长：排产工单到班组成员
---
doc/20260511_create_table_production_team.sql | 6 ++++++
1 files changed, 6 insertions(+), 0 deletions(-)
diff --git a/doc/20260511_create_table_production_team.sql b/doc/20260511_create_table_production_team.sql
index 9668d8e..7c705ee 100644
--- a/doc/20260511_create_table_production_team.sql
+++ b/doc/20260511_create_table_production_team.sql
@@ -26,3 +26,9 @@
index idx_sys_user_id (sys_user_id),
unique idx_production_team_user (production_team_id, sys_user_id)
);
+
+alter table production_order add column team_leader_user_id bigint not null default 0 comment '鐝粍闀縄D';
+alter table production_order add index idx_team_leader_user_id (team_leader_user_id);
+
+alter table production_operation_task
+ add team_user_id bigint default 0 not null comment '鐝粍鍥㈠憳鐢ㄦ埛id';
--
Gitblit v1.9.3