/**Begin D:\DBA\PDM_UPGRADE\PDM1\BCM_constraint.sql **/
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BCM_PERMISSIONCLASS_FIDM') CREATE INDEX IDX_BCM_PERMISSIONCLASS_FIDM ON T_BCM_PERMISSIONCLASS ( FFIDMMODELID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BCM_AUTH_DATA_FIDM') CREATE INDEX IDX_BCM_AUTH_DATA_FIDM ON T_BCM_AUTH_DATA ( FFIDMMODELID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BCM_PERMCLASS_ENTITY_FIDM') CREATE INDEX IDX_BCM_PERMCLASS_ENTITY_FIDM ON T_BCM_PERMCLASS_ENTITY ( FFIDMMODELID );


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