about summary refs log tree commit diff stats
path: root/sql/sqlite/schema.sql
blob: f14bcf992e4302b2b41381d12ee19253700f9bf7 (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
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);