项目数据库索引

# book.xml CREATE        INDEX idx_nav_id ON book_info(nav_id);CREATE UNIQUE INDEX uniq_id     ON book_info(id);CREATE UNIQUE INDEX uniq_nav_id ON navigation(id);CREATE        INDEX idx_lib_id ON book(lib_id);CREATE        INDEX idx_lib_id ON book(book_info_id);#borrowReturn.xmlCREATE UNIQUE INDEX uniq_user_rtx_borrow_num ON user(user_rtx(8),borrow_num);CREATE        INDEX idx_lib_id               ON user(lib_id);CREATE        INDEX idx_is_return            ON borrowed(is_return);#reserve.xmlCREATE        INDEX idx_book_info_id         ON reserve(book_info_id);CREATE        INDEX idx_lib_id               ON reserve(lib_id);CREATE        INDEX idx_user_rtx             ON reserve(user_rtx(8));