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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_ANOBJSIDEBAR') CREATE INDEX IDX_ANOBJSIDEBAR ON T_HRPTMC_ANOBJSIDEBAR ( FANOBJID );


 EXEC P_ALTERPK 'PK_HRPTMC_ANGROUPFIELD', 'T_HRPTMC_ANGROUPFIELD', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_HRPTMC_GROUPITEM', 'T_HRPTMC_GROUPITEM', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_HRPTMC_ANGROUPFIELD_L', 'T_HRPTMC_ANGROUPFIELD_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_HRPTMC_GROUPITEM_L', 'T_HRPTMC_GROUPITEM_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_GROUPITEM_L') CREATE INDEX IDX_GROUPITEM_L ON T_HRPTMC_GROUPITEM_L ( FENTRYID );



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