/**Begin D:\04tools\PDM_UPGRADE\PDM1\HRCS_constraint.sql **/

 EXEC P_ALTERPK 'PK_HRCS_LBLOBJDISPENTRY', 'T_HRCS_LBLOBJDISPENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_HRCS_LBLOBJCONFIG', 'T_HRCS_LBLOBJCONFIG', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_HRCS_LBLOBJCONDENTRY', 'T_HRCS_LBLOBJCONDENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_HRCS_LBLOBJCONDENTRY_L', 'T_HRCS_LBLOBJCONDENTRY_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_HRCS_LBLOBJDISPENTRY_L', 'T_HRCS_LBLOBJDISPENTRY_L', 'FPKID', '1';

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



/**End D:\04tools\PDM_UPGRADE\PDM1\HRCS_constraint.sql **/
