/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\MAL_constraint.sql **/


 EXEC P_ALTERPK 'PK_T_MAL_EAFSERVENTRY', 'T_MAL_EAFSERVENTRY', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'INX_MAL_EAFSERVENY') CREATE INDEX INX_MAL_EAFSERVENY ON T_MAL_EAFSERVENTRY ( FID );


 EXEC P_ALTERPK 'PK_T_MAL_EAFSERVICE', 'T_MAL_EAFSERVICE', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_T_MAL_EAFSERVICE_L', 'T_MAL_EAFSERVICE_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'INX_MAL_EAFSERVICE_L') CREATE INDEX INX_MAL_EAFSERVICE_L ON T_MAL_EAFSERVICE_L ( FID );



/**End E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\MAL_constraint.sql **/
