summaryrefslogtreecommitdiff
path: root/sql/sqlite/schema.sql
blob: eeab2f9f8ac9b39bc0902753e6dae1d0bc971b9c (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_users (
	id integer not null primary key autoincrement,
	username varchar(100) not null,
	pass varchar(200) 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_favorites(
	id integer not null primary key autoincrement,
	bookid integer not null,
	owner varchar(200) not null);