/** 设置所有API默认出厂预置 **/
IF  EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MAL_EXTSYS_API' AND KSQL_COL_NAME IN ('FISPRESET')) 
update  T_MAL_EXTSYS_API  set FISPRESET = '1';
/** 设置指定API出厂记录日志 **/
IF  EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MAL_EXTSYS_API' AND KSQL_COL_NAME IN ('FRECORD_LOG')) 
update  T_MAL_EXTSYS_API  set FRECORD_LOG = '0';
IF  EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MAL_EXTSYS_API' AND KSQL_COL_NAME IN ('FRECORD_LOG')) 
update  T_MAL_EXTSYS_API  set FRECORD_LOG = '1' where FID in(985448464995372032,985451913912829952,985454867080333312,985463384596021248,985471972760616960,985474277253841920,985476183741169664,985477317293768704,1002276030980834304,1006511274676250624);

/** 设置所有API组默认都不开启 **/
/** 研发内部环境脚本会重复执行,回迁基线需要放开
IF  EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MAL_EXT_APISETENTRY' AND KSQL_COL_NAME IN ('FVALID')) 
update  T_MAL_EXT_APISETENTRY  set FVALID = '0';**/




