/**Begin D:\zhaohui_zeng\PDM_UPGRADE\PDM1\MRP_constraint.sql **/

 EXEC P_ALTERPK 'PK_T_MRP_ADJUSTSUGGEST', 'T_MRP_ADJUSTSUGGEST', 'FID', '1';
 
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_MRP_ADJUSTSUGGEST') CREATE INDEX IDX_MRP_ADJUSTSUGGEST ON T_MRP_ADJUSTSUGGEST ( FPLANNUM );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_MRP_MATERIAL') CREATE INDEX IDX_MRP_MATERIAL ON T_MRP_ADJUSTSUGGEST ( FMATERIEL );
 
 EXEC P_ALTERPK 'PK_T_MRP_ADJUSTSUGGEST_L', 'T_MRP_ADJUSTSUGGEST_L', 'FPKID', '1';
 
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_MRP_ADJUSTSUGGEST_L') CREATE INDEX IDX_MRP_ADJUSTSUGGEST_L ON T_MRP_ADJUSTSUGGEST_L ( FID ,FLOCALEID );

/**End D:\zhaohui_zeng\PDM_UPGRADE\PDM1\MRP_constraint.sql **/
