/**Begin D:\PDM_UPGRADE\PDM1\HRPTMC_constraint.sql **/
 EXEC P_ALTERPK 'PK_HRPTMC_PREINDEX', 'T_HRPTMC_PREINDEX', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_HRPTMC_PREINDEX_L', 'T_HRPTMC_PREINDEX_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_HRPTMC_PREINDEXPARAM', 'T_HRPTMC_PREINDEXPARAM', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HRPTMC_PREINDEXPARAM') CREATE INDEX IDX_HRPTMC_PREINDEXPARAM ON T_HRPTMC_PREINDEXPARAM ( FID ,FBUSISRVPARAMID );


 EXEC P_ALTERPK 'PK_HRPTMC_PREINDEXPARAM_L', 'T_HRPTMC_PREINDEXPARAM_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HRPTMC_PREINDEXPARAM_L') CREATE INDEX IDX_HRPTMC_PREINDEXPARAM_L ON T_HRPTMC_PREINDEXPARAM_L ( FENTRYID ,FLOCALEID );



 EXEC P_ALTERPK 'PK_HRPTMC_BUSISERVICE', 'T_HRPTMC_BUSISERVICE', 'FID', '1';

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

 EXEC P_ALTERPK 'PK_HRPTMC_BUSISERVICE_L', 'T_HRPTMC_BUSISERVICE_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_HRPTMC_BUSISRVPARAM', 'T_HRPTMC_BUSISRVPARAM', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_HRPTMC_BUSISRVPARAM_L', 'T_HRPTMC_BUSISRVPARAM_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HRPTMC_BUSISRVPARAM_L') CREATE INDEX IDX_HRPTMC_BUSISRVPARAM_L ON T_HRPTMC_BUSISRVPARAM_L ( FENTRYID ,FLOCALEID );



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