diff options
Diffstat (limited to 'sql/sqlite')
-rw-r--r-- | sql/sqlite/schema.sql | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/sql/sqlite/schema.sql b/sql/sqlite/schema.sql new file mode 100644 index 0000000..a0daf61 --- /dev/null +++ b/sql/sqlite/schema.sql @@ -0,0 +1,23 @@ +create table if not exists epube_pagination ( + id integer not null primary key autoincrement, + bookid integer not null, + total_pages integer not null, + pagination text not null); + +create table if not exists epube_books ( + id integer not null primary key autoincrement, + bookid integer not null, + owner varchar(200) not null, + lastts integer not null, + lastcfi varchar(200) not null, + lastread integer not null); + +create table if not exists epube_users ( + id integer not null primary key autoincrement, + user varchar(100) not null, + pass varchar(200) not null); + +create table if not exists epube_favorites( + id integer not null primary key autoincrement, + bookid integer not null, + owner varchar(200) not null); |