/**Begin D:\utils\PDM_UPGRADE\PDM_UPGRADE\PDM1\HRCS_constraint.sql **/
EXEC P_ALTERPK 'PK_HRCS_WARNPLAN', 'T_HRCS_WARNPLAN', 'FID', '1';

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


EXEC P_ALTERPK 'PK_HRCS_WARNPLAN_L', 'T_HRCS_WARNPLAN_L', 'FPKID', '1';

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


EXEC P_ALTERPK 'PK_HRCS_RCFIX', 'T_HRCS_RCFIX', 'FENTRYID', '1';

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



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