/**Begin D:\PDM_UPGRADE\PDM1\BCM_constraint.sql **/
EXEC p_DropIdx 'IDX_BCM_FuncPermLog', 'T_BCM_FUNCTIONPERMLOG';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BCM_FUNCPLOG_M') CREATE INDEX IDX_BCM_FUNCPLOG_M ON T_BCM_FUNCTIONPERMLOG ( FMODELID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BCM_FUNCPLOG_MT') CREATE INDEX IDX_BCM_FUNCPLOG_MT ON T_BCM_FUNCTIONPERMLOG ( FMODIFYTIME );

EXEC p_DropIdx 'IDX_BCM_DataPermLog', 'T_BCM_DATAPERMLOG';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BCM_DATAPLOG_M') CREATE INDEX IDX_BCM_DATAPLOG_M ON T_BCM_DATAPERMLOG ( FMODELID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BCM_DATAPLOG_MT') CREATE INDEX IDX_BCM_DATAPLOG_MT ON T_BCM_DATAPERMLOG ( FMODIFYTIME );


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