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

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

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


 EXEC P_ALTERPK 'PK_T_MAL_ORDERENTRY_XFS', 'T_MAL_ORDERENTRY_XFS', 'FENTRYID', '1';

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_MAL_ENTRY_XFS_FID_FSEQ') CREATE INDEX IDX_MAL_ENTRY_XFS_FID_FSEQ ON T_MAL_ORDERENTRY_XFS ( FSEQ );



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