项目数据库索引

# 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.xml

CREATE 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.xml

CREATE        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));