/**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_PLANORDER' AND KSQL_COL_NAME ='FCOMMENT') 
 ALTER TABLE T_MRP_PLANORDER ADD (FCOMMENT NVARCHAR(512) DEFAULT ' ' NOT NULL );
  IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_XPLANORDER' AND KSQL_COL_NAME ='FCOMMENT') 
 ALTER TABLE T_MRP_XPLANORDER ADD (FCOMMENT NVARCHAR(512) DEFAULT ' ' NOT NULL);
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_SIMULATEORDER' AND KSQL_COL_NAME ='FCOMMENT') 
 ALTER TABLE T_MRP_SIMULATEORDER ADD (FCOMMENT NVARCHAR(512) DEFAULT ' ' NOT NULL);
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_CPS_PLANPRO' AND KSQL_COL_NAME ='FNAME') 
 ALTER TABLE T_MRP_CPS_PLANPRO ADD (FNAME NVARCHAR(255) DEFAULT ' ' NOT NULL);
/**End E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\MRP_table.sql **/
