diff options
Diffstat (limited to 'schema.sql')
-rw-r--r-- | schema.sql | 13 |
1 files changed, 3 insertions, 10 deletions
@@ -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); |