process_sheet/fastadmin/application/sql/ps_biz_import.sql

-- 工厂 Open API Key；工序增加工艺编号
ALTER TABLE `fa_ps_factory`
  ADD COLUMN `api_key_hash` varchar(64) NOT NULL DEFAULT '' COMMENT 'Open API Key SHA256' AFTER `owner_user_id`,
  ADD COLUMN `api_key_prefix` varchar(16) NOT NULL DEFAULT '' COMMENT 'Key 前缀展示' AFTER `api_key_hash`,
  ADD COLUMN `api_key_time` bigint(16) DEFAULT NULL COMMENT 'Key 生成时间' AFTER `api_key_prefix`;

ALTER TABLE `fa_ps_product_process`
  ADD COLUMN `code` varchar(64) NOT NULL DEFAULT '' COMMENT '工艺编号' AFTER `seq`;

ALTER TABLE `fa_ps_workorder_process`
  ADD COLUMN `code` varchar(64) NOT NULL DEFAULT '' COMMENT '工艺编号' AFTER `seq`;