-- Issue #50: 项目组版本历史（append-only JSON 快照）。MySQL 5.7.
-- DDL 隐式提交；该脚本不作为自动应用启动步骤。上线前仍须备份并在目标副本验证。

CREATE TABLE IF NOT EXISTS biz_project_team_history (
  id VARCHAR(64) NOT NULL,
  team_id VARCHAR(64) NOT NULL,
  version_no INT NOT NULL,
  action VARCHAR(16) NOT NULL,
  snapshot_json TEXT NOT NULL,
  operator_user_id VARCHAR(64) NULL,
  operator_user_name VARCHAR(100) NULL,
  operate_time DATETIME NOT NULL,
  tenant_no VARCHAR(64) NOT NULL,
  order_num INT NULL,
  remark VARCHAR(512) NULL,
  create_by VARCHAR(64) NULL,
  create_dept_id VARCHAR(64) NOT NULL DEFAULT '',
  create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  update_by VARCHAR(64) NULL,
  update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  del_flag SMALLINT NOT NULL DEFAULT 0,
  PRIMARY KEY (id),
  UNIQUE KEY uk_team_version (tenant_no, team_id, version_no),
  KEY ix_team_history (tenant_no, team_id, version_no)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;