diff options
Diffstat (limited to 'schema.sql')
-rw-r--r-- | schema.sql | 16 |
1 files changed, 16 insertions, 0 deletions
@@ -1,5 +1,9 @@ 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 index if exists epube_sessions_expire; create table epube_pagination( id integer not null primary key autoincrement, @@ -13,3 +17,15 @@ create table epube_books( owner varchar(200) 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 index epube_sessions_expire on epube_sessions(expire); |