/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\MRP_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_ORGMERGE' AND KSQL_COL_NAME ='FALLOCPLAN') 
 ALTER TABLE T_MRP_ORGMERGE ADD (FALLOCPLAN CHAR(1) DEFAULT '0' NOT NULL );

 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_ORGMERGE' AND KSQL_COL_NAME ='FGLOBALPLAN') 
 ALTER TABLE T_MRP_ORGMERGE ADD (FGLOBALPLAN CHAR(1) DEFAULT '0' NOT NULL );	
 
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_ORGMERGE' AND KSQL_COL_NAME ='FMFTCMPL') 
 ALTER TABLE T_MRP_ORGMERGE ADD (FMFTCMPL CHAR(1) DEFAULT '0' NOT NULL );	
 
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_ORGMERGE' AND KSQL_COL_NAME ='FPLANCMPL') 
 ALTER TABLE T_MRP_ORGMERGE ADD (FPLANCMPL CHAR(1) DEFAULT '0' NOT NULL );	
 
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_ORGMERGE' AND KSQL_COL_NAME ='FISSUPLAN') 
 ALTER TABLE T_MRP_ORGMERGE ADD (FISSUPLAN CHAR(1) DEFAULT '0' NOT NULL );	

/**End E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\MRP_table.sql **/
