/**Begin D:\DBA\1.4\PDM_UPGRADE\PDM1\BCM_constraint.sql **/
 EXEC P_ALTERPK 'PK_T_BCM_ISSCHEME_A', 'T_BCM_ISSCHEME_A', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_BCM_ISSCHEME_A' AND KSQL_INDNAME = 'IDX_BCM_ISSCHEMEA') CREATE INDEX IDX_BCM_ISSCHEMEA ON T_BCM_ISSCHEME_A ( FTARGETOBJID );


 EXEC P_ALTERPK 'PK_T_DI_SCHEMEPARAM', 'T_DI_SCHEMEPARAM', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_DI_SCHEMEPARAM' AND KSQL_INDNAME = 'IDX_DI_SCHEMEPARAM') CREATE INDEX IDX_DI_SCHEMEPARAM ON T_DI_SCHEMEPARAM ( FPARAMNAME );


 EXEC P_ALTERPK 'PK_T_DI_SCHEMEPARAM_L', 'T_DI_SCHEMEPARAM_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_DI_SCHEMEPARAM_L' AND KSQL_INDNAME = 'IDX_DI_SCHEMEPARAML') CREATE INDEX IDX_DI_SCHEMEPARAML ON T_DI_SCHEMEPARAM_L ( FENTRYID ,FLOCALEID );



/**End D:\DBA\1.4\PDM_UPGRADE\PDM1\BCM_constraint.sql **/
