From 2b8b845abe7c13ecbb266613910484310cffe8e1 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Fri, 5 Mar 2021 21:14:35 +0300 Subject: * use ORM for trivial queries * environment-based configuration * useradm.php -> update.php with new options * support for schema migrations * various fixes --- sql/sqlite/schema.sql | 23 +++++++++++++++++++++++ 1 file changed, 23 insertions(+) create mode 100644 sql/sqlite/schema.sql (limited to 'sql') 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); -- cgit v1.2.3