-- EXEC p_DropIdx 'IDX_TSRBD_TYJOBCLENTRY_FEID', 'T_TSRBD_TYJOBCLENTRY';
-- 切环境时发现oracle库报错
-- IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TSRBD_TYJO_FENTRYID') CREATE UNIQUE INDEX IDX_TSRBD_TYJO_FENTRYID ON T_TSRBD_TYJOBCLENTRY ( FENTRYID );
--EXEC p_DropIdx 'IDX_TSRBD_TYJO_FENTRYID', 'T_TSRBD_TYJOBCLENTRY';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TSRBD_TYJO_FID') CREATE INDEX IDX_TSRBD_TYJO_FID ON T_TSRBD_TYJOBCLENTRY ( FID );

EXEC p_AlterPK 'PK_TSRBD_TYJOBCLENTRY', 'T_TSRBD_TYJOBCLENTRY', 'FENTRYID', '1';


 EXEC P_ALTERPK 'PK_TSRBD_MSGRECRUSCENE', 'T_TSRBD_MSGRECRUSCENE', 'FPKID', '1';

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