/**Begin C:\Users\rd_jin_gu\Documents\work\PDM_UPGRADE\PDM1\HRCS_constraint.sql **/
EXEC p_DropIdx 'IDX_HRCS_LBLPRM_FLBLOBJID', 'T_HRCS_LABELPARAM';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HRCS_LBLPRM_FLBLOBJID') CREATE INDEX IDX_HRCS_LBLPRM_FLBLOBJID ON T_HRCS_LABELPARAM ( FLABELOBJECTID ,FLABELID );

 EXEC P_ALTERPK 'PK_HRCS_LABELVALUENEW', 'T_HRCS_LABELVALUENEW', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_HRCS_LABELVALUENEW_L', 'T_HRCS_LABELVALUENEW_L', 'FPKID', '1';

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



/**End C:\Users\rd_jin_gu\Documents\work\PDM_UPGRADE\PDM1\HRCS_constraint.sql **/
