about summary refs log tree commit diff stats
path: root/sql/sqlite/schema.sql
blob: dacb1f2825c2ab3b9f086f6eff2ebf782a743dfe (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
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);