-- 旧协作任务中心修改执行信息
 EXEC p_AlterColumn 'T_HPDI_TASKCENTER', 'FEXECUTEFAILMSG', 'NCLOB', 'NULL', '1111', 'NULL';
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HPDI_TASKCENTERENT' AND KSQL_COL_NAME IN ('FRESULT')) 
 ALTER TABLE T_HPDI_TASKCENTERENT ADD (FRESULT NCLOB );

-- 新协作任务中心修改执行结果信息，分录增加执行结果字段
 EXEC p_AlterColumn 'T_HPDI_COLLATASK', 'FEXECUTEFAILMSG', 'NCLOB', 'NULL', '1111', 'NULL';
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HPDI_COLLATASKENT' AND KSQL_COL_NAME IN ('FRESULT')) 
 ALTER TABLE T_HPDI_COLLATASKENT ADD (FRESULT NCLOB );