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);
|