summaryrefslogtreecommitdiff
path: root/sql/sqlite/schema.sql
blob: a0daf619c821e32224cb811d668f1f03944d78e6 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
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_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_users (
	id integer not null primary key autoincrement,
	user varchar(100) not null,
	pass varchar(200) 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);