summaryrefslogtreecommitdiff
path: root/schema.sql
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2021-03-05 21:14:35 +0300
committerAndrew Dolgov <[email protected]>2021-03-05 21:14:35 +0300
commit2b8b845abe7c13ecbb266613910484310cffe8e1 (patch)
tree90bd2e93737c2aad17cfb09496cc57cf3f9968cd /schema.sql
parentb2341679d53b227fc90fba34c3a7e6453e3cad6e (diff)
* use ORM for trivial queries
* environment-based configuration * useradm.php -> update.php with new options * support for schema migrations * various fixes
Diffstat (limited to 'schema.sql')
-rw-r--r--schema.sql39
1 files changed, 0 insertions, 39 deletions
diff --git a/schema.sql b/schema.sql
deleted file mode 100644
index e67e980..0000000
--- a/schema.sql
+++ /dev/null
@@ -1,39 +0,0 @@
-drop table if exists epube_pagination;
-drop table if exists epube_books;
-drop table if exists epube_users;
-drop table if exists epube_sessions;
-drop table if exists epube_favorites;
-
-drop index if exists epube_sessions_expire;
-
-create table epube_pagination(
- id integer not null primary key autoincrement,
- bookid integer not null,
- total_pages integer not null,
- pagination text not null);
-
-create table 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 epube_users(
- id integer not null primary key autoincrement,
- user varchar(100) not null,
- pass varchar(200) not null);
-
-create table epube_sessions (
- id varchar(250) not null primary key,
- data text,
- expire integer not null);
-
-create table epube_favorites(
- id integer not null primary key autoincrement,
- bookid integer not null,
- owner varchar(200) not null);
-
-
-create index epube_sessions_expire on epube_sessions(expire);