schema.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

drop table if exists epube_settings;
drop table if exists epube_pagination;
drop table if exists epube_books;

--create table epube_settings(
--	id serial not null primary key,
--	owner varchar(200) not null unique,
--	font_size integer not null,
--	font_family varchar(200) not null,
--	line_height integer not null);

create table epube_pagination(
	id serial not null primary key,
	bookid integer not null,
	total_pages integer not null,
	pagination text not null);

create table epube_books(
	id serial not null primary key,
	bookid integer not null,
	owner varchar(200) not null,
	lastread integer not null);