summaryrefslogtreecommitdiff
path: root/schema.sql
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2017-02-25 08:51:08 +0300
committerAndrew Dolgov <[email protected]>2017-02-25 08:51:08 +0300
commitb4fb29e00346ec78065e875ab318885810524a22 (patch)
tree40950c1cce12b39e81488d5e09a63c82bc6a4e8b /schema.sql
parentabe6ca80782474e266961e49077ee566c22a0a91 (diff)
switch to integer book ids
Diffstat (limited to 'schema.sql')
-rw-r--r--schema.sql16
1 files changed, 8 insertions, 8 deletions
diff --git a/schema.sql b/schema.sql
index 36e6c93..8e425db 100644
--- a/schema.sql
+++ b/schema.sql
@@ -2,20 +2,20 @@ 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_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 varchar(200) not null,
+ bookid integer not null,
pagination text not null);
create table epube_books(
id serial not null primary key,
- bookid varchar(200) not null,
+ bookid integer not null,
owner varchar(200) not null,
lastread integer not null);