/**  合同台台账增加多甲方  多乙方字段 **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_CONTRACTBILL' AND KSQL_COL_NAME ='FPARTANEWS')
ALTER TABLE T_ER_CONTRACTBILL ADD (FPARTANEWS NVARCHAR(255) DEFAULT ' ' NOT NULL);


IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_CONTRACTBILL' AND KSQL_COL_NAME ='FPARTBNEWS')
ALTER TABLE T_ER_CONTRACTBILL  ADD (FPARTBNEWS NVARCHAR(255) DEFAULT ' ' NOT NULL);

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_CONTRACTBILL_L' AND KSQL_COL_NAME ='FPARTANEWS')
ALTER TABLE T_ER_CONTRACTBILL_L ADD (FPARTANEWS NVARCHAR(255) DEFAULT ' ' NOT NULL);

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_CONTRACTBILL_L' AND KSQL_COL_NAME ='FPARTBNEWS')
ALTER TABLE T_ER_CONTRACTBILL_L ADD (FPARTBNEWS NVARCHAR(255) DEFAULT ' ' NOT NULL);