/**Begin D:\utils\PDM_UPGRADE\PDM_UPGRADE\PDM1\HRCS_constraint.sql **/
EXEC P_ALTERPK 'PK_HRCS_SYSCAPABILITY', 'T_HRCS_SYSCAPABILITY', 'FID', '1';

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


EXEC P_ALTERPK 'PK_HRCS_SYSCAPABILITY_L', 'T_HRCS_SYSCAPABILITY_L', 'FPKID', '1';

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


EXEC P_ALTERPK 'PK_HRCS_SYSCAPINPARAM', 'T_HRCS_SYSCAPINPARAM', 'FENTRYID', '1';

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


EXEC P_ALTERPK 'PK_HRCS_SYSCAPINPARAM_L', 'T_HRCS_SYSCAPINPARAM_L', 'FPKID', '1';

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


EXEC P_ALTERPK 'PK_HRCS_SYSCAPOUTPARAM', 'T_HRCS_SYSCAPOUTPARAM', 'FENTRYID', '1';

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


EXEC P_ALTERPK 'PK_HRCS_SYSCAPOUTPARAM_L', 'T_HRCS_SYSCAPOUTPARAM_L', 'FPKID', '1';

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



/**End D:\utils\PDM_UPGRADE\PDM_UPGRADE\PDM1\HRCS_constraint.sql **/
