/**Begin C:\PDM_UPGRADE\PDM1\MAL_constraint.sql **/
 EXEC P_ALTERPK 'PK_T_MAL_ORDER_DL', 'T_MAL_ORDER_DL', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_MAL_ORDER_DL_FORDERID') CREATE INDEX IDX_MAL_ORDER_DL_FORDERID ON T_MAL_ORDER_DL ( FORDERID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_MAL_ORDER_DL_FPORDERID') CREATE INDEX IDX_MAL_ORDER_DL_FPORDERID ON T_MAL_ORDER_DL ( FPORDERID );


 EXEC P_ALTERPK 'PK_T_MAL_ORDERENTRY_DL', 'T_MAL_ORDERENTRY_DL', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_MAL_ENTRY_DL_FGOODSID') CREATE INDEX IDX_MAL_ENTRY_DL_FGOODSID ON T_MAL_ORDERENTRY_DL ( FGOODSID );

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



/**End C:\PDM_UPGRADE\PDM1\MAL_constraint.sql **/
