/**Begin D:\PDM_UPGRADE\PDM1\FCS_constraint.sql **/
EXEC p_DropIdx 'IDX_T_FCS_PAYACCESS_RECORD', 'T_FCS_PAYACCESS_RECORD';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_RECORD_DESTID') CREATE INDEX IDX_RECORD_DESTID ON T_FCS_PAYACCESS_RECORD ( FISREPEATRESULT ,FISEXCESSRESULT ,FDESTBILLID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_RECORD_SRCPKID') CREATE INDEX IDX_RECORD_SRCPKID ON T_FCS_PAYACCESS_RECORD ( FSRCBILLPKID );

EXEC p_DropIdx 'IDX_T_FCS_PAYACCESS_DEST', 'T_FCS_PAYACCESS';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_T_FCS_PAYACCESS_DEST') CREATE INDEX IDX_T_FCS_PAYACCESS_DEST ON T_FCS_PAYACCESS ( FISBOTPADD ,FENABLE ,FDESTENTITYID );


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