Ifexists(select*fromKSQL_INDEXESwhereKSQL_INDNAME='index_HR_EnrollEntryBillId')dropindexT_HR_EmpEnrollBizBillEntry.index_HR_EnrollEntryBillId;Ifnotexists(select*fromKSQL_INDEXESwhereKSQL_INDNAME='index_HR_EnrollEntryBillId')createindexindex_HR_EnrollEntryBillIdonT_HR_EmpEnrollBizBillEntry(FBillID);Ifexists(select*fromKSQL_INDEXESwhereKSQL_INDNAME='index_HR_HireEntryBillId')dropindexT_HR_EmpHireBizBillEntry.index_HR_HireEntryBillId;Ifnotexists(select*fromKSQL_INDEXESwhereKSQL_INDNAME='index_HR_HireEntryBillId')createindexindex_HR_HireEntryBillIdonT_HR_EmpHireBizBillEntry(FBillID);Ifexists(select*fromKSQL_INDEXESwhereKSQL_INDNAME='index_HR_FluEntryBillId')dropindexT_HR_FluctuationBizBillEntry.index_HR_FluEntryBillId;Ifnotexists(select*fromKSQL_INDEXESwhereKSQL_INDNAME='index_HR_FluEntryBillId')createindexindex_HR_FluEntryBillIdonT_HR_FluctuationBizBillEntry(FBillID);Ifexists(select*fromKSQL_INDEXESwhereKSQL_INDNAME='index_HR_ResignEntryBillId')dropindexT_HR_ResignBizBillEntry.index_HR_ResignEntryBillId;Ifnotexists(select*fromKSQL_INDEXESwhereKSQL_INDNAME='index_HR_ResignEntryBillId')createindexindex_HR_ResignEntryBillIdonT_HR_ResignBizBillEntry(FBillID);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);
