From 2b8b845abe7c13ecbb266613910484310cffe8e1 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <noreply@fakecake.org>
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/sqlite/schema.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

