summaryrefslogtreecommitdiff
path: root/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'schema.sql')
-rw-r--r--schema.sql13
1 files changed, 3 insertions, 10 deletions
diff --git a/schema.sql b/schema.sql
index cd9cf95..457b499 100644
--- a/schema.sql
+++ b/schema.sql
@@ -1,22 +1,15 @@
-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,
+ id integer not null primary key autoincrement,
bookid integer not null,
total_pages integer not null,
pagination text not null);
create table epube_books(
- id serial not null primary key,
+ id integer not null primary key autoincrement,
bookid integer not null,
owner varchar(200) not null,
+ lastcfi varchar(200) not null,
lastread integer not null);