金蝶s-HR-人事单据撤销挂起正常-加索引.txt

Ifexists(select*fromKSQL_INDEXESwhereKSQL_INDNAME='index_HR_BizHisEntryID')dropindexT_HR_AffairBizHistory.index_HR_BizHisEntryID;Ifnotexists(select*fromKSQL_INDEXESwhereKSQL_INDNAME='index_HR_BizHisEntryID')createindexindex_HR_BizHisEntryIDonT_HR_AffairBizHistory(FEntryID);Ifexists(select*fromKSQL_INDEXESwhereKSQL_INDNAME='index_HR_ExpPersonID')dropindexT_HR_EmpPostExperienceHis.index_HR_ExpPersonID;Ifnotexists(select*fromKSQL_INDEXESwhereKSQL_INDNAME='index_HR_ExpPersonID')createindexindex_HR_ExpPersonIDonT_HR_EmpPostExperienceHis(FPersonID);Ifexists(select*fromKSQL_INDEXESwhereKSQL_INDNAME='index_HR_POhistoryrelateid')dropindexT_HR_PersonOtherInfoHis.index_HR_POhistoryrelateid;Ifnotexists(select*fromKSQL_INDEXESwhereKSQL_INDNAME='index_HR_POhistoryrelateid')createindexindex_HR_POhistoryrelateidonT_HR_PersonOtherInfoHis(fhistoryrelateid);Ifexists(select*fromKSQL_INDEXESwhereKSQL_INDNAME='index_HR_POPersonID')dropindexT_HR_PersonOtherInfoHis.index_HR_POPersonID;Ifnotexists(select*fromKSQL_INDEXESwhereKSQL_INDNAME='index_HR_POPersonID')createindexindex_HR_POPersonIDonT_HR_PersonOtherInfoHis(FPersonID);Ifexists(select*fromKSQL_INDEXESwhereKSQL_INDNAME='index_HRO_BuRelationID')dropindexT_HR_EmpHRORelationHis.index_HRO_BuRelationID;Ifnotexists(select*fromKSQL_INDEXESwhereKSQL_INDNAME='index_HRO_BuRelationID')createindexindex_HRO_BuRelationIDonT_HR_EmpHRORelationHis(FBuRelationID);