/**Begin D:\PDM_UPGRADE\PDM1\ER_constraint.sql **/
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_ER_PREPAYENTRY_FSRCBILLID') CREATE INDEX IDX_ER_PREPAYENTRY_FSRCBILLID ON T_ER_PREPAYBILLENTRY ( FSOURCEBILLID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_ER_PERPAYBILL_FBPAYER_CP') CREATE INDEX IDX_ER_PERPAYBILL_FBPAYER_CP ON T_ER_PREPAYBILL ( FBILLPAYERID ,FCOSTCOMPANYID );


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