/**Begin C:\Users\rd_jin_gu\Documents\work\PDM_UPGRADE\PDM1\HRCS_constraint.sql **/
 EXEC P_ALTERPK 'PK_HRCS_LABELPOLICY', 'T_HRCS_LABELPOLICY', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HRCS_LABELPOLICY_FLBLOBJID') CREATE INDEX IDX_HRCS_LABELPOLICY_FLBLOBJID ON T_HRCS_LABELPOLICY ( FLABELOBJECTID );


 EXEC P_ALTERPK 'PK_HRCS_LABELPOLICYRULE', 'T_HRCS_LABELPOLICYRULE', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HRCS_LBLPLCYRULE_FLBLOBJID') CREATE INDEX IDX_HRCS_LBLPLCYRULE_FLBLOBJID ON T_HRCS_LABELPOLICYRULE ( FLABELPOLICYID );


 EXEC P_ALTERPK 'PK_HRCS_LABELPOLICY_L', 'T_HRCS_LABELPOLICY_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_HRCS_LABELPOLICYTASK', 'T_HRCS_LABELPOLICYTASK', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HRCS_LBLPLCYTASK_FPOLICYID') CREATE INDEX IDX_HRCS_LBLPLCYTASK_FPOLICYID ON T_HRCS_LABELPOLICYTASK ( FLABELPOLICYID );


 EXEC P_ALTERPK 'PK_HRCS_LBLSCENEREL', 'T_HRCS_LBLSCENEREL', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_HRCS_LBLSTRATEGYORG', 'T_HRCS_LBLSTRATEGYORG', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_HRCS_LBLPOLICYFILTER', 'T_HRCS_LBLPOLICYFILTER', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HRCS_LBLPOLICYFILTER') CREATE INDEX IDX_HRCS_LBLPOLICYFILTER ON T_HRCS_LBLPOLICYFILTER ( FLBLPOLICYID );



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