/**Begin D:\PDM_UPGRADE\PDM1\HRSS_constraint.sql **/
 EXEC P_ALTERPK 'PK_HRSS_SEARCHWEIGHTCONF', 'T_HRSS_SEARCHWEIGHTCONF', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_HRSS_SEARCHWEIGHTCONF_L', 'T_HRSS_SEARCHWEIGHTCONF_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_HRSS_SEARCHWEIGHTENTRY', 'T_HRSS_SEARCHWEIGHTENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_HRSS_SEARCHWESUBENTRY', 'T_HRSS_SEARCHWESUBENTRY', 'FDETAILID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HRSS_SEARCHWESUBENTRY') CREATE INDEX IDX_HRSS_SEARCHWESUBENTRY ON T_HRSS_SEARCHWESUBENTRY ( FENTRYID );



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