/**Begin D:\PDM_UPGRADE_1.3\PDM_UPGRADE\pdm1\RIM_constraint.sql **/
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_RIM_DOWN_LOG_CREATE') CREATE INDEX IDX_RIM_DOWN_LOG_CREATE ON T_RIM_DOWN_LOG ( FCREATETIME );

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_RIM_SELECT_BATCHNO') CREATE INDEX IDX_RIM_SELECT_BATCHNO ON T_RIM_SELECT_ACCOUNT ( FBATCH_NO );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_RIM_SELECT_CREATETIME') CREATE INDEX IDX_RIM_SELECT_CREATETIME ON T_RIM_SELECT_ACCOUNT ( FCREATE_TIME );


/**End D:\PDM_UPGRADE_1.3\PDM_UPGRADE\pdm1\RIM_constraint.sql **/
