diff options
author | Andrew Dolgov <[email protected]> | 2021-03-05 21:14:35 +0300 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2021-03-05 21:14:35 +0300 |
commit | 2b8b845abe7c13ecbb266613910484310cffe8e1 (patch) | |
tree | 90bd2e93737c2aad17cfb09496cc57cf3f9968cd /schema.sql | |
parent | b2341679d53b227fc90fba34c3a7e6453e3cad6e (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.sql | 39 |
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); |