/**BEGIN E:\NEXTERP_PDM\PDM_UPGRADE\PDMS\BRANCH_LASTEST\PDM\POM_TABLE.SQL **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IM_MDC_MFTREQBILLS' AND KSQL_COL_NAME ='FHEADPROJECT') 
 ALTER TABLE T_IM_MDC_MFTREQBILLS ADD (FHEADPROJECT BIGINT DEFAULT 0 NOT NULL);

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IM_MDC_MFTREQENTRY' AND KSQL_COL_NAME ='FWAREHOUSECHANGE') 
 ALTER TABLE T_IM_MDC_MFTREQENTRY ADD (FWAREHOUSECHANGE CHAR(1) DEFAULT '0' NOT NULL);

/**END E:\NEXTERP_PDM\PDM_UPGRADE\PDMS\BRANCH_LASTEST\PDM\POM_TABLE.SQL **/
