【泛微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

---

示例4：更改自定义浏览框类型

SELECT * FROM workflow_billfield WHERE ID = 10333

UPDATE workflow_billfield SET FIELDDBTYPE = 'browser.XSLXSXM' where id = 10333

---

示例5：将单行文本框（文本）改为单行文本框（浮点数，小数位数2）

SELECT * FROM workflow_billfield WHERE ID = 13437

UPDATE workflow_billfield SET FIELDDBTYPE = 'decimal(38,2)', TYPE = 3 where id = 13437

---

示例6：将单行文本框（文本）改为单行文本框（整数）

SELECT * FROM workflow_billfield WHERE ID = 13504

UPDATE workflow_billfield SET FIELDDBTYPE = 'int', TYPE = 2 where id = 13504

---

示例7：将浏览框（日期）改为浏览框（日期时间）

SELECT * FROM workflow_billfield WHERE ID = 13508;

UPDATE workflow_billfield SET TYPE = 290, FIELDDBTYPE = 'varchar(100)' where id = 13508;
ALTER TABLE formtable_main_85 MODIFY COLUMN jhwgrq VARCHAR(100) DEFAULT NULL;

当FIELDHTMLTYPET = 3时，表workflow_billfield中TYPE的值为表workflow_browserurl的id值，即 workflow_billfield.TYPE = workflow_browserurl.ID
注意FIELDDBTYPE要改，实体表的数据类型也要改，不然提交流程时，会报错 “流程保存失败” 。