use sqlite as a scratch db

store lastread pointer as a CFI

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