create table if not exists epube_pagination ( id integer not null primary key autoincrement, bookid integer not null, total_pages integer not null, pagination text not null); create table if not exists epube_users ( id integer not null primary key autoincrement, username varchar(100) not null, pass varchar(200) not null, last_auth_attempt bigint default null); create table if not exists epube_books ( id integer not null primary key autoincrement, bookid integer not null, owner varchar(200) not null, lastts integer not null, lastcfi varchar(200) not null, lastread integer not null); create table if not exists epube_favorites( id integer not null primary key autoincrement, bookid integer not null, owner varchar(200) not null); create index if not exists epube_users_last_auth_attempt on epube_users(last_auth_attempt);