/**Begin D:\PDM_UPGRADE\PDM1\HRCS_constraint.sql **/
 EXEC P_ALTERPK 'PK_HRCS_CHECKUSERROLESYN', 'T_HRCS_CHECKUSERROLESYN', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HRCS_CHECKUSERROLESYN_FCREATETIME') CREATE INDEX IDX_HRCS_CHECKUSERROLESYN_FCREATETIME ON T_HRCS_CHECKUSERROLESYN ( FCREATETIME );


 EXEC P_ALTERPK 'PK_HRCS_CHECKONLYINSYS', 'T_HRCS_CHECKONLYINSYS', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_HRCS_CHECKONLYINHMP', 'T_HRCS_CHECKONLYINHMP', 'FENTRYID', '1';

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



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