/**Begin D:\PDM_UPGRADE\PDM1\TSRBD_constraint.sql **/
 EXEC P_ALTERPK 'PK_TSRBD_MSGTEMPFLDSCM_L', 'T_TSRBD_MSGTEMPFLDSCM_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_TSRBD_MSGTEMPFLDSCM', 'T_TSRBD_MSGTEMPFLDSCM', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TSRBD_MSGTEMPFLDSCM_TYPE') CREATE INDEX IDX_TSRBD_MSGTEMPFLDSCM_TYPE ON T_TSRBD_MSGTEMPFLDSCM ( FTEMPTYPE );


 EXEC P_ALTERPK 'PK_TSRBD_FLDSCMENTRY', 'T_TSRBD_FLDSCMENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_TSRBD_MSGTEMPTYPE_L', 'T_TSRBD_MSGTEMPTYPE_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_TSRBD_MSGTEMPTYPE', 'T_TSRBD_MSGTEMPTYPE', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_TSRBD_TEMPTYPEENTRY', 'T_TSRBD_TEMPTYPEENTRY', 'FENTRYID', '1';

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



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