/**Begin D:\PDM_UPGRADE\PDM1\HRCS_constraint.sql **/
 EXEC P_ALTERPK 'PK_HRCS_PINITROLEDIMROW', 'T_HRCS_PINITROLEDIMROW', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_HRCS_PINITROLEFUNCCOL', 'T_HRCS_PINITROLEFUNCCOL', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_HRCS_PINITROLEFUNCCOL_L', 'T_HRCS_PINITROLEFUNCCOL_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_HRCS_PINITROLEFUNCROW', 'T_HRCS_PINITROLEFUNCROW', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_HRCS_PINITROLEDATAROW_L', 'T_HRCS_PINITROLEDATAROW_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_HRCS_PINITROLEDATAROW', 'T_HRCS_PINITROLEDATAROW', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_HRCS_PINITROLEFUNCROW_L', 'T_HRCS_PINITROLEFUNCROW_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_HRCS_PINITROLEDIMROW_L', 'T_HRCS_PINITROLEDIMROW_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HRCS_PINITROLEDIMROW_L') CREATE INDEX IDX_HRCS_PINITROLEDIMROW_L ON T_HRCS_PINITROLEDIMROW_L ( FENTRYID ,FLOCALEID );
/**End D:\PDM_UPGRADE\PDM1\HRCS_constraint.sql **/
