zkxw/docs/sql/migrate-protocol-void-type.sql

-- 协议作废类型（采集协议单 / 捐赠协议单）
-- 2026-07-01

ALTER TABLE `biz_collection_protocol`
  ADD COLUMN `void_type` varchar(32) DEFAULT NULL COMMENT '协议作废类型（字典 xyzflx）' AFTER `void_desc`;

ALTER TABLE `biz_research_donation`
  ADD COLUMN `void_type` varchar(32) DEFAULT NULL COMMENT '作废类型（字典 xyzflx）' AFTER `void_desc`;

INSERT INTO `sys_dict_type` (
  `id`, `dict_name`, `dict_type`, `tenant_no`, `order_num`, `remark`,
  `create_by`, `create_dept_id`, `create_time`, `update_by`, `update_time`, `del_flag`
) VALUES (
  'TDP000000000000000000000000000096', '协议作废类型', 'xyzflx', 'zkxw', 0, NULL,
  NULL, '', NOW(), NULL, NOW(), 0
);

INSERT INTO `sys_dict_data` (
  `id`, `dict_label`, `dict_value`, `dict_type`, `tenant_no`, `order_num`, `remark`,
  `create_by`, `create_dept_id`, `create_time`, `update_by`, `update_time`, `del_flag`
) VALUES
(
  'DDP000000000000000000000000000201', '客户毁存', 'khhc', 'xyzflx', 'zkxw', 1, NULL,
  NULL, '', NOW(), NULL, NOW(), 0
),
(
  'DDP000000000000000000000000000202', '检测不合格', 'jcbhg', 'xyzflx', 'zkxw', 2, NULL,
  NULL, '', NOW(), NULL, NOW(), 0
);