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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HRCS_WARNMSGPERSIST') CREATE INDEX IDX_HRCS_WARNMSGPERSIST ON T_HRCS_WARNMSGPERSIST ( FLOGID ,FWARNSCHEMEID );


EXEC P_ALTERPK 'PK_HRCS_WARNMSGPERSIST_L', 'T_HRCS_WARNMSGPERSIST_L', 'FPKID', '1';

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


EXEC P_ALTERPK 'PK_HRCS_WARNMSGPSRECIVER', 'T_HRCS_WARNMSGPSRECIVER', 'FENTRYID', '1';

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


EXEC P_ALTERPK 'PK_HRCS_WARNMSGROWDATA', 'T_HRCS_WARNMSGROWDATA', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HRCS_WARNMSGROWDATA') CREATE INDEX IDX_HRCS_WARNMSGROWDATA ON T_HRCS_WARNMSGROWDATA ( FMSGPERSISTID );


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