【泛微E9】从数据库修改表单字段类型。例：将[附件上传-上传文件]修改为[附件上传-上传图片]

示例1：将[附件上传-上传文件]修改为[附件上传-上传图片]

根据字段名查到该字段所在的所有表：

-- MYSQL
SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS 
WHERE COLUMN_NAME = 'bhgxtpsc';

需要用到 workflow_billfield 这张表。

对比可知，附件上传 type = 1，图片上传 type = 2

-- MYSQL
SELECT * FROM workflow_billfield WHERE ID = 12749

UPDATE workflow_billfield SET TYPE = 2 where id = 12749

执行完 UPDATE 语句，清空缓存即可。

---

示例2：将自定义浏览框从单选改为多选

TYPE = 161，自定义单选
TYPE = 162，自定义多选

SELECT * FROM workflow_billfield WHERE ID = 13150

UPDATE workflow_billfield SET TYPE = 162 where id = 13150

---

示例3：修改签字意见

-- 表单：workflow_requestlog
-- 签字意见字段：REMARK
UPDATE workflow_requestlog SET REMARK = '同意' WHERE requestid =252811 and LOGID = 165628