/**Begin D:\PDM_UPGRADE\PDM1\BEI_constraint.sql **/
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_T_BEI_BANKTRANSDOWNUNIQUE') CREATE UNIQUE INDEX IDX_T_BEI_BANKTRANSDOWNUNIQUE ON T_BEI_BANKTRANSDOWNBILL ( FSOURCEBILLID ,FPAYUNIQUE );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_T_BEI_BANKTRANSUPUNIQUE') CREATE UNIQUE INDEX IDX_T_BEI_BANKTRANSUPUNIQUE ON T_BEI_BANKTRANSUPBILL ( FSOURCEBILLID ,FPAYUNIQUE );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BEI_BANKPAYUNIQUE') CREATE UNIQUE INDEX IDX_BEI_BANKPAYUNIQUE ON T_BEI_BANKPAYINGBILL ( FSOURCEBILLID ,FPAYUNIQUE );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BEI_BANKAGENTUNIQUE') CREATE UNIQUE INDEX IDX_BEI_BANKAGENTUNIQUE ON T_BEI_BANKAGENTPAYBILL ( FSOURCEBILLID ,FPAYUNIQUE );


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