IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PMPD_PROJECT_MCC' AND KSQL_COL_NAME ='FMODELONE') 
 ALTER TABLE T_PMPD_PROJECT_MCC ADD (FMODELONE NVARCHAR(255) DEFAULT ' ' NOT NULL );
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PMPD_PROJECT_MCC' AND KSQL_COL_NAME ='FMODELMPDONE') 
 ALTER TABLE T_PMPD_PROJECT_MCC ADD (FMODELMPDONE NVARCHAR(255) DEFAULT ' ' NOT NULL );
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PMPD_PROJECT_MCC' AND KSQL_COL_NAME ='FMODELTWO') 
 ALTER TABLE T_PMPD_PROJECT_MCC ADD (FMODELTWO NVARCHAR(255) DEFAULT ' ' NOT NULL );
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PMPD_PROJECT_MCC' AND KSQL_COL_NAME ='FMODELTRD') 
 ALTER TABLE T_PMPD_PROJECT_MCC ADD (FMODELTRD NVARCHAR(255) DEFAULT ' ' NOT NULL );
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PMPD_PROJECT_MCC' AND KSQL_COL_NAME ='FPLANROOM') 
 ALTER TABLE T_PMPD_PROJECT_MCC ADD (FPLANROOM BIGINT DEFAULT 0 NOT NULL );

 
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FMM_PROJECT_MCC_CUST' AND KSQL_COL_NAME ='FSALECONSTRACTNO') 
 ALTER TABLE T_FMM_PROJECT_MCC_CUST ADD (FSALECONSTRACTNO NVARCHAR(255) DEFAULT ' ' NOT NULL );
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FMM_PROJECT_MCC_CUST' AND KSQL_COL_NAME ='FSALECONSTRACTNAME') 
 ALTER TABLE T_FMM_PROJECT_MCC_CUST ADD (FSALECONSTRACTNAME NVARCHAR(255) DEFAULT ' ' NOT NULL );
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FMM_PROJECT_MCC_CUST' AND KSQL_COL_NAME ='FSALEORDERNO') 
 ALTER TABLE T_FMM_PROJECT_MCC_CUST ADD (FSALEORDERNO NVARCHAR(255) DEFAULT ' ' NOT NULL );

 

 