CREATE TABLE "bible_access_history" ( "id" INTEGER PRIMARY KEY, "path" TEXT DEFAULT '', "access_time" INT DEFAULT 0 );

CREATE TABLE "bible_versions" (
	"id" INTEGER PRIMARY KEY,
	"abbreviation" TEXT DEFAULT '',
	"full_name" TEXT DEFAULT '',
	"copyright" TEXT DEFAULT '',
	"sync_version" TEXT DEFAULT '',
	"language" TEXT DEFAULT '',
	"api_provider" TEXT DEFAULT '',
	"api_key" TEXT DEFAULT '',
	"path" TEXT DEFAULT '',
	"is_downloaded" INT DEFAULT 0,
	"access_time" INT DEFAULT 0 );

CREATE TABLE "bible_books" (
	"id" INTEGER PRIMARY KEY,
	"abbreviation" TEXT DEFAULT '',
	"full_name" TEXT DEFAULT '' );

CREATE TABLE "bible_version_to_book" (
	"version_id" INT DEFAULT 0,
	"book_id" INT DEFAULT 0,
	"last_chapter" INT DEFAULT 0,
	"book_order" INT DEFAULT 0,
	CONSTRAINT bv2b_pk PRIMARY KEY ("version_id","book_id"));