about summary refs log tree commit diff stats
path: root/sql/sqlite/schema.sql
diff options
context:
space:
mode:
authorAndrew Dolgov <noreply@fakecake.org>2021-03-05 21:14:35 +0300
committerAndrew Dolgov <noreply@fakecake.org>2021-03-05 21:14:35 +0300
commit2b8b845abe7c13ecbb266613910484310cffe8e1 (patch)
tree90bd2e93737c2aad17cfb09496cc57cf3f9968cd /sql/sqlite/schema.sql
parentb2341679d53b227fc90fba34c3a7e6453e3cad6e (diff)
downloadthe-epube-2b8b845abe7c13ecbb266613910484310cffe8e1.tar.gz
the-epube-2b8b845abe7c13ecbb266613910484310cffe8e1.tar.xz
* use ORM for trivial queries
 * environment-based configuration
 * useradm.php -> update.php with new options
 * support for schema migrations
 * various fixes
Diffstat (limited to 'sql/sqlite/schema.sql')
-rw-r--r--sql/sqlite/schema.sql23
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);