/**Begin D:\PDM_UPGRADE\PDM1\HAOS_constraint.sql **/
 EXEC P_ALTERPK 'PK_HAOS_STAFFPERSON', 'T_HAOS_STAFFPERSON', 'FID', '1';

IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HAOS_STAFFPERSON_FPERSONID') CREATE INDEX IDX_HAOS_STAFFPERSON_FPERSONID ON T_HAOS_STAFFPERSON ( FPERSONID );


 EXEC P_ALTERPK 'PK_HAOS_PERCHANGEEVENT', 'T_HAOS_PERCHANGEEVENT', 'FEID', '1';

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


 EXEC P_ALTERPK 'PK_HAOS_ORGUSESTAFF', 'T_HAOS_ORGUSESTAFF', 'FUID', '1';

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


 EXEC P_ALTERPK 'PK_HAOS_MULDIMUSESTAFF', 'T_HAOS_MULDIMUSESTAFF', 'FMUID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HAOS_MULDIMUSESTAFF_FUID') CREATE INDEX IDX_HAOS_MULDIMUSESTAFF_FUID ON T_HAOS_MULDIMUSESTAFF ( FUID );


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