
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_LOCALAPPROVEOPINION' AND KSQL_COL_NAME IN ('FMAINJOB'))
ALTER TABLE T_EB_LOCALAPPROVEOPINION ADD (FMAINJOB NVARCHAR(100) NOT NULL DEFAULT ' ');
