/**Begin D:\PDM_UPGRADE\PDM1\HOM_constraint.sql **/
 EXEC P_ALTERPK 'PK_HOM_WELCOMELETTER', 'T_HOM_WELCOMELETTER', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_HOM_WELCOMELETTER_L', 'T_HOM_WELCOMELETTER_L', 'FPKID', '1';

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


 EXEC p_AlterPK 'PK_HOM_ONBRDINVITE', 'T_HOM_ONBRDINVITE', 'FID', '1';
EXEC p_DropIdx 'IDX_T_HOM_ONBRDINVITE_FONBRDID', 'T_HOM_ONBRDINVITE';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HOM_ONBRDINVITE_FONBRDID') CREATE INDEX IDX_HOM_ONBRDINVITE_FONBRDID ON T_HOM_ONBRDINVITE ( FONBRDID );

 EXEC p_AlterPK 'PK_HOM_REMINDINFO', 'T_HOM_REMINDINFO', 'FID', '1';
EXEC p_DropIdx 'IDX_T_HOM_REMINDINFO_FINVITEID', 'T_HOM_REMINDINFO';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HOM_REMINDINFO_FINVITEID') CREATE INDEX IDX_HOM_REMINDINFO_FINVITEID ON T_HOM_REMINDINFO ( FINDUCTIONINVITEID );


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