drop table if exists eb_bookmark_bk;
drop table if exists eb_bookshelves_bk;
drop table if exists eb_lastAccessPage_bk;
drop table if exists eb_licMgnt_bk;
drop table if exists eb_licMgntLog_bk;
drop table if exists opl_ILL_in_bk;
drop table if exists opl_ILL_out_bk;
drop table if exists opl_ILL_user_bk;
drop table if exists opl_arl_bk;
drop table if exists opl_authCtrl_bk;
drop table if exists opl_bcmBc_bk;
drop table if exists opl_bcmRange_bk;
drop table if exists opl_bcmVendor_bk;
drop table if exists opl_bookingFor_bk;
drop table if exists opl_bookingHold_bk;
drop table if exists opl_bookingItem_bk;
drop table if exists opl_bookingRequest_bk;
drop table if exists opl_category_bk;
drop table if exists opl_cmntRating_bk;
drop table if exists opl_collectionStats_bk;
drop table if exists opl_damage_bk;
drop table if exists opl_dateClosed_bk;
drop table if exists opl_delUser_bk;
drop table if exists opl_deweyDesc_bk;
drop table if exists opl_ebLoan_bk;
drop table if exists opl_ebReserve_bk;
drop table if exists opl_emailDetails_bk;
drop table if exists opl_emailRequest_bk;
drop table if exists opl_extDatabase_bk;
drop table if exists opl_featureItem_bk;
drop table if exists opl_file_bk;
drop table if exists opl_fineMaterials_bk;
drop table if exists opl_fineRate_bk;
drop table if exists opl_found_bk;
drop table if exists opl_fullMarcRecord_bk;
drop table if exists opl_ge852record_bk;
drop table if exists opl_ge852request_bk;
drop table if exists opl_guardian_bk;
drop table if exists opl_historyItem_bk;
drop table if exists opl_historyUser_bk;
drop table if exists opl_hold_bk;
drop table if exists opl_idGen_bk;
drop table if exists opl_index_map_bk;
drop table if exists opl_inventory_bk;
drop table if exists opl_inventoryFile_bk;
drop table if exists opl_inventoryInfo_bk;
drop table if exists opl_inventoryResult_bk;
drop table if exists opl_item_bk;
drop table if exists opl_itemCategory_bk;
drop table if exists opl_itemInfo_bk;
drop table if exists opl_itemStats_bk;
drop table if exists opl_itemType_bk;
drop table if exists opl_itemTypeChange_bk;
drop table if exists opl_itemTypeParam_bk;
drop table if exists opl_itemstatus_bk;
drop table if exists opl_libSystem_bk;
drop table if exists opl_library_bk;
drop table if exists opl_loan_bk;
drop table if exists opl_lost_bk;
drop table if exists opl_marcDelete_bk;
drop table if exists opl_marcDuplicate_bk;
drop table if exists opl_marcExport_bk;
drop table if exists opl_marcImport_bk;
drop table if exists opl_marcRecord_bk;
drop table if exists opl_menuItem_bk;
drop table if exists opl_newsEvents_bk;
drop table if exists opl_nystd_bk;
drop table if exists opl_odl_bk;
drop table if exists opl_offlineLoan_bk;
drop table if exists opl_openHours_bk;
drop table if exists opl_overdue_bk;
drop table if exists opl_payRefundInfo_bk;
drop table if exists opl_payment_bk;
drop table if exists opl_permGroup_bk;
drop table if exists opl_permission_bk;
drop table if exists opl_portalLayout_bk;
drop table if exists opl_portalTheme_bk;
drop table if exists opl_portlet_bk;
drop table if exists opl_portletProp_bk;
drop table if exists opl_prefFormParam_bk;
drop table if exists opl_prefGroup_bk;
drop table if exists opl_preference_bk;
drop table if exists opl_recordArchive_bk;
drop table if exists opl_recordIdentifier_bk;
drop table if exists opl_recordStats_bk;
drop table if exists opl_recordindex_bk;
drop table if exists opl_reserve_bk;
drop table if exists opl_reserveShelf_bk;
drop table if exists opl_reserveShelfGroup_bk;
drop table if exists opl_reserveShelfItems_bk;
drop table if exists opl_reserveShelfSubject_bk;
drop table if exists opl_reserveShelfUsers_bk;
drop table if exists opl_ridBcdHitlistExport_bk;
drop table if exists opl_ridBid_bk;
drop table if exists opl_schoolYear_bk;
drop table if exists opl_session_bk;
drop table if exists opl_sessionVar_bk;
drop table if exists opl_srchLog_bk;
drop table if exists opl_studentILL_bk;
drop table if exists opl_subSystem_bk;
drop table if exists opl_subjects_bk;
drop table if exists opl_taxcalcdetail_bk;
drop table if exists opl_taxes_bk;
drop table if exists opl_teacherSchedule_bk;
drop table if exists opl_template_bk;
drop table if exists opl_transCode_bk;
drop table if exists opl_transactiondetail_bk;
drop table if exists opl_transactions_bk;
drop table if exists opl_unionRequest_bk;
drop table if exists opl_unionRequestDetail_bk;
drop table if exists opl_user_bk;
drop table if exists opl_userImg_bk;
drop table if exists opl_userimport_bk;
drop table if exists opl_webLinks_bk;
drop table if exists opl_zDatabase_bk;
drop table if exists opl_zResult_bk;
drop table if exists pf_bookRs_bk;
drop table if exists pf_record_bk;
drop table if exists pf_ridMap_bk;
drop table if exists pf_sbjAreaList_bk;
drop table if exists pf_subject_bk;
drop table if exists pf_webRs_bk;
drop table if exists eb_bookmark_tmp;
drop table if exists eb_bookshelves_tmp;
drop table if exists eb_lastAccessPage_tmp;
drop table if exists eb_licMgnt_tmp;
drop table if exists eb_licMgntLog_tmp;
drop table if exists opl_ILL_in_tmp;
drop table if exists opl_ILL_out_tmp;
drop table if exists opl_ILL_user_tmp;
drop table if exists opl_arl_tmp;
drop table if exists opl_authCtrl_tmp;
drop table if exists opl_bcmBc_tmp;
drop table if exists opl_bcmRange_tmp;
drop table if exists opl_bcmVendor_tmp;
drop table if exists opl_bookingFor_tmp;
drop table if exists opl_bookingHold_tmp;
drop table if exists opl_bookingItem_tmp;
drop table if exists opl_bookingRequest_tmp;
drop table if exists opl_category_tmp;
drop table if exists opl_cmntRating_tmp;
drop table if exists opl_collectionStats_tmp;
drop table if exists opl_damage_tmp;
drop table if exists opl_dateClosed_tmp;
drop table if exists opl_delUser_tmp;
drop table if exists opl_deweyDesc_tmp;
drop table if exists opl_ebLoan_tmp;
drop table if exists opl_ebReserve_tmp;
drop table if exists opl_emailDetails_tmp;
drop table if exists opl_emailRequest_tmp;
drop table if exists opl_extDatabase_tmp;
drop table if exists opl_featureItem_tmp;
drop table if exists opl_file_tmp;
drop table if exists opl_fineMaterials_tmp;
drop table if exists opl_fineRate_tmp;
drop table if exists opl_found_tmp;
drop table if exists opl_fullMarcRecord_tmp;
drop table if exists opl_ge852record_tmp;
drop table if exists opl_ge852request_tmp;
drop table if exists opl_guardian_tmp;
drop table if exists opl_historyItem_tmp;
drop table if exists opl_historyUser_tmp;
drop table if exists opl_hold_tmp;
drop table if exists opl_idGen_tmp;
drop table if exists opl_index_map_tmp;
drop table if exists opl_inventory_tmp;
drop table if exists opl_inventoryFile_tmp;
drop table if exists opl_inventoryInfo_tmp;
drop table if exists opl_inventoryResult_tmp;
drop table if exists opl_item_tmp;
drop table if exists opl_itemCategory_tmp;
drop table if exists opl_itemInfo_tmp;
drop table if exists opl_itemStats_tmp;
drop table if exists opl_itemType_tmp;
drop table if exists opl_itemTypeChange_tmp;
drop table if exists opl_itemTypeParam_tmp;
drop table if exists opl_itemstatus_tmp;
drop table if exists opl_libSystem_tmp;
drop table if exists opl_library_tmp;
drop table if exists opl_loan_tmp;
drop table if exists opl_lost_tmp;
drop table if exists opl_marcDelete_tmp;
drop table if exists opl_marcDuplicate_tmp;
drop table if exists opl_marcExport_tmp;
drop table if exists opl_marcImport_tmp;
drop table if exists opl_marcRecord_tmp;
drop table if exists opl_menuItem_tmp;
drop table if exists opl_newsEvents_tmp;
drop table if exists opl_nystd_tmp;
drop table if exists opl_odl_tmp;
drop table if exists opl_offlineLoan_tmp;
drop table if exists opl_openHours_tmp;
drop table if exists opl_overdue_tmp;
drop table if exists opl_payRefundInfo_tmp;
drop table if exists opl_payment_tmp;
drop table if exists opl_permGroup_tmp;
drop table if exists opl_permission_tmp;
drop table if exists opl_portalLayout_tmp;
drop table if exists opl_portalTheme_tmp;
drop table if exists opl_portlet_tmp;
drop table if exists opl_portletProp_tmp;
drop table if exists opl_prefFormParam_tmp;
drop table if exists opl_prefGroup_tmp;
drop table if exists opl_preference_tmp;
drop table if exists opl_recordArchive_tmp;
drop table if exists opl_recordIdentifier_tmp;
drop table if exists opl_recordStats_tmp;
drop table if exists opl_recordindex_tmp;
drop table if exists opl_reserve_tmp;
drop table if exists opl_reserveShelf_tmp;
drop table if exists opl_reserveShelfGroup_tmp;
drop table if exists opl_reserveShelfItems_tmp;
drop table if exists opl_reserveShelfSubject_tmp;
drop table if exists opl_reserveShelfUsers_tmp;
drop table if exists opl_ridBcdHitlistExport_tmp;
drop table if exists opl_ridBid_tmp;
drop table if exists opl_schoolYear_tmp;
drop table if exists opl_session_tmp;
drop table if exists opl_sessionVar_tmp;
drop table if exists opl_srchLog_tmp;
drop table if exists opl_studentILL_tmp;
drop table if exists opl_subSystem_tmp;
drop table if exists opl_subjects_tmp;
drop table if exists opl_taxcalcdetail_tmp;
drop table if exists opl_taxes_tmp;
drop table if exists opl_teacherSchedule_tmp;
drop table if exists opl_template_tmp;
drop table if exists opl_transCode_tmp;
drop table if exists opl_transactiondetail_tmp;
drop table if exists opl_transactions_tmp;
drop table if exists opl_unionRequest_tmp;
drop table if exists opl_unionRequestDetail_tmp;
drop table if exists opl_user_tmp;
drop table if exists opl_userImg_tmp;
drop table if exists opl_userimport_tmp;
drop table if exists opl_webLinks_tmp;
drop table if exists opl_zDatabase_tmp;
drop table if exists opl_zResult_tmp;
drop table if exists pf_bookRs_tmp;
drop table if exists pf_record_tmp;
drop table if exists pf_ridMap_tmp;
drop table if exists pf_sbjAreaList_tmp;
drop table if exists pf_subject_tmp;
drop table if exists pf_webRs_tmp;
