/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\BOS_constraint.sql **/
 EXEC P_ALTERPK 'PK_INT_CURRENCYEXRULE', 'T_INT_CURRENCYEXRULE', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_INT_CUREXRULE_CREATETIME') CREATE INDEX IDX_INT_CUREXRULE_CREATETIME ON T_INT_CURRENCYEXRULE ( FCREATETIME );
 
  EXEC P_ALTERPK 'PK_INT_ENABLEDEXRULE', 'T_INT_ENABLEDEXRULE', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_INT_ENABLEDEX_CREATETIME') CREATE INDEX IDX_INT_ENABLEDEX_CREATETIME ON T_INT_ENABLEDEXRULE ( FCREATETIME );


 EXEC P_ALTERPK 'PK_INT_EXRULEENTRY', 'T_INT_EXRULEENTRY', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_INT_EXRULEENTRY_CUR_DATE') CREATE INDEX IDX_INT_EXRULEENTRY_CUR_DATE ON T_INT_EXRULEENTRY ( FSOURCECUR ,FTARGETCUR ,FEFFECTIVEDATE );


 EXEC P_ALTERPK 'PK_INT_EXRULELOG', 'T_INT_EXRULELOG', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_INT_EXRULELOG_OPTIME') CREATE INDEX IDX_INT_EXRULELOG_OPTIME ON T_INT_EXRULELOG ( FOPTIME );



/**End E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\BOS_constraint.sql **/
