/**Begin D:\PDM_UPGRADE\PDM1\FA_constraint.sql **/
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_FA_CARD_VS2_BEFREALCARDID') CREATE INDEX IDX_FA_CARD_VS2_BEFREALCARDID ON T_FA_CARD_VERSION2 ( FBEFREALCARDID ,FCARDMASTERID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_FA_DEPREADJENTRY_REALID') CREATE INDEX IDX_FA_DEPREADJENTRY_REALID ON T_FA_DEPREADJUSTENTRY ( FREALCARDID );

EXEC p_DropIdx 'IDX_FA_CARREA_ORG', 'T_FA_CARD_REAL';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_FA_CARREA_ORGDATE') CREATE INDEX IDX_FA_CARREA_ORGDATE ON T_FA_CARD_REAL ( FORGID ,FISBAK ,FREALACCOUNTDATE ,FNUMBER );



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