/**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_RSREGISTER' AND KSQL_COL_NAME ='FOUTPUTTYPE') 
 ALTER TABLE T_MRP_RSREGISTER ADD (FOUTPUTTYPE NVARCHAR(36) DEFAULT ' ' NOT NULL );
 
 -- 资源注册配置新增输出结果映射字段
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_RSREGISTER' AND KSQL_COL_NAME ='FOUTPUTMAPPING') 
 ALTER TABLE T_MRP_RSREGISTER ADD (FOUTPUTMAPPING BIGINT DEFAULT 0 NOT NULL );


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