---紧急补丁修复共库的问题，修复系统库中T_MDR_ITEMCLASS，T_MDR_ITEMBRAND缺字段
---T_MDR_ITEMBRAND
IF  EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDR_ITEMBRAND' AND KSQL_COL_NAME ='FCREATEORGID') 
 UPDATE T_MDR_ITEMBRAND SET FCREATEORGID = 100000 where FCREATEORGID = 0;
 
 IF EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDR_ITEMBRAND' AND KSQL_COL_NAME ='FCTRLSTRATEGY') 
 UPDATE T_MDR_ITEMBRAND SET FCTRLSTRATEGY = '5' where FCTRLSTRATEGY = ' ';
  
IF EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDR_ITEMBRAND' AND KSQL_COL_NAME ='FORGID') 
 UPDATE T_MDR_ITEMBRAND SET FORGID = 100000 where FORGID = 0;
 
 
