IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PMPD_PROJECT_MCC' AND KSQL_COL_NAME ='fprjstate') 
  ALTER TABLE T_PMPD_PROJECT_MCC ADD (fprjstate BIGINT DEFAULT 0 NOT NULL);
  
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_fmm_project_change' AND KSQL_COL_NAME ='fprjstate') 
  ALTER TABLE t_fmm_project_change ADD (fprjstate BIGINT DEFAULT 0 NOT NULL);
 
  



