IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FMM_MILESTONETPL' AND KSQL_COL_NAME ='FCUSTOMER') 
 ALTER TABLE T_FMM_MILESTONETPL ADD (FCUSTOMER BIGINT DEFAULT 0 NOT NULL );
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FMM_MILESTONETPL' AND KSQL_COL_NAME ='FMRTYPE') 
 ALTER TABLE T_FMM_MILESTONETPL ADD (FMRTYPE BIGINT DEFAULT 0 NOT NULL );
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FMM_MILESTONETPL' AND KSQL_COL_NAME ='FCHECKTYPE') 
 ALTER TABLE T_FMM_MILESTONETPL ADD (FCHECKTYPE BIGINT DEFAULT 0 NOT NULL );
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FMM_MILESTONETPL' AND KSQL_COL_NAME ='FFIXWEEK') 
 ALTER TABLE T_FMM_MILESTONETPL ADD (FFIXWEEK DECIMAL(23,10) DEFAULT 0 NOT NULL );
 