/**Begin D:\PDM_UPGRADE\PDM1\BEI_constraint.sql **/
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BEI_BANKTRANSDOWN_CCB') CREATE INDEX IDX_BEI_BANKTRANSDOWN_CCB ON T_BEI_BANKTRANSDOWNBILL ( FCOMPANYID ,FCREATETIME ,FBILLSTATUS );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BEI_BANKTRANSUP_CCB') CREATE INDEX IDX_BEI_BANKTRANSUP_CCB ON T_BEI_BANKTRANSUPBILL ( FCOMPANYID ,FCREATETIME ,FBILLSTATUS );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BEI_BANKAGENTPAY_CCB') CREATE INDEX IDX_BEI_BANKAGENTPAY_CCB ON T_BEI_BANKAGENTPAYBILL ( FCOMPANYID ,FCREATETIME ,FBILLSTATUS );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BEI_BANKPAYBILL_CCB') CREATE INDEX IDX_BEI_BANKPAYBILL_CCB ON T_BEI_BANKPAYINGBILL ( FCOMPANYID ,FCREATETIME ,FBILLSTATUS );


/**End D:\PDM_UPGRADE\PDM1\BEI_constraint.sql **/
