э-книги

sqlite> .schema
CREATE TABLE archives(
      id integer primary key,
      file_name varchar(255),
      file_path varchar(255),
      file_size integer,
      file_count integer);
CREATE TABLE authors(
	id integer primary key,
	letter char(1),
	search_name varchar(255),
	full_name varchar(255),
	first_name varchar(128),
	middle_name varchar(128),
	last_name varchar(128),
	number integer,
	newid integer,
	description text);
CREATE TABLE books(
      id integer not null,
      id_author integer,
      title varchar(255) not null,
      annotation text,
      genres text,
      id_sequence integer,
      deleted boolean,
      id_archive integer,
      file_name text,
      file_size integer,
      file_type varchar(20),
      md5sum char(32),
      created integer,
      lang char(2),
      year integer,
      description text,
      PRIMARY KEY(id,id_author)
      );
CREATE TABLE bookseq(id_book integer, id_seq integer, number integer, level integer, id_author integer, PRIMARY KEY(id_book,id_seq));
CREATE TABLE dates(id integer primary key, lib_min integer, lib_max integer, lib_num, usr_min integer, usr_max, usr_num integer);
CREATE TABLE files(id_book integer, id_archive integer, file_name TEXT, file_path TEXT);
CREATE TABLE genres(id_book integer, id_genre CHAR(2), PRIMARY KEY(id_book, id_genre));
CREATE TABLE params(id integer primary key, value integer, text text);
CREATE TABLE sequences(id integer primary key, number integer, value varchar(255) not null);
CREATE INDEX author_letter ON authors(letter);
CREATE INDEX author_name ON authors(search_name);
CREATE INDEX book_archive ON books(id_archive);
CREATE INDEX book_author ON books(id_author);
CREATE INDEX book_created ON books(created);
CREATE INDEX book_md5sum ON books(md5sum);
CREATE INDEX bookseq_seq ON bookseq(id_seq);
CREATE INDEX files_book ON files(id_book);
CREATE INDEX genres_genre ON genres(id_genre);
CREATE INDEX sequences_name ON sequences(value);
sqlite>