/**Begin D:\PDM_UPGRADE\PDM1\TSRBD_constraint.sql **/
 EXEC P_ALTERPK 'PK_TSRBD_APPPRGS', 'T_TSRBD_APPPRGS', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TSRBD_APPPRGS_RECRUTYP') CREATE INDEX IDX_TSRBD_APPPRGS_RECRUTYP ON T_TSRBD_APPPRGS ( FRECRUTYPID );


 EXEC P_ALTERPK 'PK_TSRBD_APPPRGS_L', 'T_TSRBD_APPPRGS_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_TSRBD_RECRUSTG', 'T_TSRBD_RECRUSTG', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_TSRBD_RECRUSTG_L', 'T_TSRBD_RECRUSTG_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TSRBD_RECRUSTG_L') CREATE INDEX IDX_TSRBD_RECRUSTG_L ON T_TSRBD_RECRUSTG_L ( FENTRYID ,FLOCALEID );


 EXEC P_ALTERPK 'PK_TSRBD_RECRUSTAT', 'T_TSRBD_RECRUSTAT', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_TSRBD_RECRUSTAT_L', 'T_TSRBD_RECRUSTAT_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TSRBD_RECRUSTAT_L') CREATE INDEX IDX_TSRBD_RECRUSTAT_L ON T_TSRBD_RECRUSTAT_L ( FENTRYID ,FLOCALEID );


 EXEC P_ALTERPK 'PK_TSRBD_FILESTATUS', 'T_TSRBD_FILESTATUS', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_TSRBD_FILESTATUS_L', 'T_TSRBD_FILESTATUS_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TSRBD_FILESTATUS_L') CREATE INDEX IDX_TSRBD_FILESTATUS_L ON T_TSRBD_FILESTATUS_L ( FENTRYID ,FLOCALEID );



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