/**Begin D:\PDM_UPGRADE\PDM1\FPM_constraint.sql **/
EXEC p_DropIdx 'IDX_EXECPLAN_BODYSYS', 'T_FPM_EXECUTEPLAN';
EXEC p_DropIdx 'IDX_EXECPLAN_REPORTORG', 'T_FPM_EXECUTEPLAN';
EXEC p_DropIdx 'IDX_EXECPLAN_CURRENCYMEM', 'T_FPM_EXECUTEPLAN';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_EXECPLAN_BODYSYS') CREATE INDEX IDX_EXECPLAN_BODYSYS ON T_FPM_EXECUTEPLAN ( FBODYSYS ,FCURRENCYMEM ,FREPORTORG );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_EXECPLAN_BIZBILL') CREATE INDEX IDX_EXECPLAN_BIZBILL ON T_FPM_EXECUTEPLAN ( FBIZBILLID );


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