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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HRCS_EVENTREG_NUMBER') CREATE INDEX IDX_HRCS_EVENTREG_NUMBER ON T_HRCS_EVENTREG ( FNUMBER ,FBIZCLOUD );


 EXEC P_ALTERPK 'PK_HRCS_EVENTREG_L', 'T_HRCS_EVENTREG_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_HRCS_ENTITYCONFIG', 'T_HRCS_ENTITYCONFIG', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HRCS_ENTITYCONFIG_ENTITY') CREATE INDEX IDX_HRCS_ENTITYCONFIG_ENTITY ON T_HRCS_ENTITYCONFIG ( FENTITYID );


 EXEC P_ALTERPK 'PK_HRCS_APPDEFAULTCONFIG', 'T_HRCS_APPDEFAULTCONFIG', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HRCS_APPCONFIG_ACTIONAPP') CREATE INDEX IDX_HRCS_APPCONFIG_ACTIONAPP ON T_HRCS_APPDEFAULTCONFIG ( FACTIONAPP );



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