-- 新增默认字段
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDS_DPSVRDSSET' AND KSQL_COL_NAME ='fisfault')
 ALTER TABLE T_MDS_DPSVRDSSET ADD (fisfault char(1) DEFAULT '0' NOT NULL );
 
 
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDS_DPSVRDSSET' AND KSQL_COL_NAME ='fresult')
 ALTER TABLE T_MDS_DPSVRDSSET ADD (fresult  NVARCHAR(50) DEFAULT ' ' NOT NULL );
 
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDS_DPSVRDSSET' AND KSQL_COL_NAME ='fdetailmsg')
 ALTER TABLE T_MDS_DPSVRDSSET ADD (fdetailmsg NVARCHAR(2000) DEFAULT ' ' NOT NULL );
 