/**Begin D:\pdm\PDM_UPGRADE\PDM1\HRPTMC_constraint.sql **/

 EXEC P_ALTERPK 'PK_HRPTMC_CUSTOMSORTDET', 'T_HRPTMC_CUSTOMSORTDET', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HRPTMC_CUSTOMSORTDET') CREATE INDEX IDX_HRPTMC_CUSTOMSORTDET ON T_HRPTMC_CUSTOMSORTDET ( FENTITYSORTFIELDID ,FINDEX );


 EXEC P_ALTERPK 'PK_HRPTMC_COMMONSORTDET', 'T_HRPTMC_COMMONSORTDET', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HRPTMC_COMMONSORTDET') CREATE INDEX IDX_HRPTMC_COMMONSORTDET ON T_HRPTMC_COMMONSORTDET ( FENTITYSORTFIELDID ,FINDEX );

/**End D:\pdm\PDM_UPGRADE\PDM1\HRPTMC_constraint.sql **/
