
EXEC P_ALTERPK 'PK_T_MRP_DROPPLANORDERLOG', 'T_MRP_DROPPLANORDERLOG', 'FID', '1';

IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_MRP_DROPPLANORDERLOG') CREATE INDEX IDX_MRP_DROPPLANORDERLOG ON T_MRP_DROPPLANORDERLOG ( FTARGETORDERID );

EXEC P_ALTERPK 'PK_T_MSPLAN_DROPCONFENTRY', 'T_MSPLAN_DROPCONFENTRY', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_MSPLAN_DROPCONFENTRY') CREATE INDEX IDX_MSPLAN_DROPCONFENTRY ON T_MSPLAN_DROPCONFENTRY ( FID ,FSEQ );


 EXEC P_ALTERPK 'PK_T_MSPLAN_DROPCONFIGURE', 'T_MSPLAN_DROPCONFIGURE', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_MSPLAN_DROPCONFIGURE') CREATE INDEX IDX_MSPLAN_DROPCONFIGURE ON T_MSPLAN_DROPCONFIGURE ( FNUMBER );


 EXEC P_ALTERPK 'PK_T_MSPLAN_DROPCONFIGURE_L', 'T_MSPLAN_DROPCONFIGURE_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_MSPLAN_DROPCONFIGURE_L') CREATE INDEX IDX_MSPLAN_DROPCONFIGURE_L ON T_MSPLAN_DROPCONFIGURE_L ( FID ,FLOCALEID );
