
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FMM_PAYSTATEGY' AND KSQL_COL_NAME ='FEARCHIVEOBJ') 
 ALTER TABLE T_FMM_PAYSTATEGY ADD (FEARCHIVEOBJ  NVARCHAR(5)    DEFAULT ' '  NOT NULL);
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FMM_PAYSTATEGY' AND KSQL_COL_NAME ='FEDIRECTORY') 
 ALTER TABLE T_FMM_PAYSTATEGY ADD (FEDIRECTORY  NVARCHAR(50)   DEFAULT ' '  NOT NULL);
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FMM_WKGROUPROLEMSG' AND KSQL_COL_NAME ='FARRANGETYPE') 
 ALTER TABLE T_FMM_WKGROUPROLEMSG ADD (FARRANGETYPE  NVARCHAR(5)    DEFAULT ' '   NOT NULL);
 
 