about summary refs log tree commit diff stats
path: root/schema.sql
diff options
context:
space:
mode:
authorAndrew Dolgov <noreply@fakecake.org>2017-02-25 15:37:22 +0300
committerAndrew Dolgov <noreply@fakecake.org>2017-02-25 15:37:32 +0300
commitbc6e20d282e0cc6152fb3b7a99ef79aef08388d3 (patch)
treefec469e63bb6b6e03475e8faf1c019b9e8467626 /schema.sql
parentf37c9975eeec34562c93f9a0b25ace14294d089f (diff)
downloadthe-epube-bc6e20d282e0cc6152fb3b7a99ef79aef08388d3.tar.gz
the-epube-bc6e20d282e0cc6152fb3b7a99ef79aef08388d3.tar.xz
use sqlite as a scratch db
store lastread pointer as a CFI
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);