/**Begin D:\PDM_UPGRADE\PDM_UPGRADE_1.1\PDM_UPGRADE\PDM1\BCM_constraint.sql **/
 EXEC P_ALTERPK 'PK_T_BCM_UDCFEFFECTIVE', 'T_BCM_UDCFEFFECTIVE', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BCM_UDCFEFFECTIVE_FID') CREATE INDEX IDX_BCM_UDCFEFFECTIVE_FID ON T_BCM_UDCFEFFECTIVE ( FID );


 EXEC P_ALTERPK 'PK_T_BCM_RATEEFFECTIVE', 'T_BCM_RATEEFFECTIVE', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BCM_RATEEFFECTIVE_FID') CREATE INDEX IDX_BCM_RATEEFFECTIVE_FID ON T_BCM_RATEEFFECTIVE ( FID );


 EXEC P_ALTERPK 'PK_T_BCM_STRUCTOFACCOUNT_DM', 'T_BCM_STRUCTOFACCOUNT_DM', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BCM_STRUCTOFACCOUNT_DM') CREATE INDEX IDX_BCM_STRUCTOFACCOUNT_DM ON T_BCM_STRUCTOFACCOUNT_DM ( FID );


 EXEC P_ALTERPK 'PK_T_BCM_RATEMEMBENTRY', 'T_BCM_RATEMEMBENTRY', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BCM_RATEMEMBENTRY_FID') CREATE INDEX IDX_BCM_RATEMEMBENTRY_FID ON T_BCM_RATEMEMBENTRY ( FID );


 EXEC P_ALTERPK 'PK_T_BCM_SPECIALRATE', 'T_BCM_SPECIALRATE', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BCM_SPECIALRATE_MS') CREATE INDEX IDX_BCM_SPECIALRATE_MS ON T_BCM_SPECIALRATE ( FMODELID ,FSCENARIOID );



/**End D:\PDM_UPGRADE\PDM_UPGRADE_1.1\PDM_UPGRADE\PDM1\BCM_constraint.sql **/
