diff options
Diffstat (limited to 'sql/pgsql/schema.sql')
-rw-r--r-- | sql/pgsql/schema.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/pgsql/schema.sql b/sql/pgsql/schema.sql index 3616f06..2d02190 100644 --- a/sql/pgsql/schema.sql +++ b/sql/pgsql/schema.sql @@ -21,3 +21,9 @@ create table if not exists epube_favorites( id serial not null primary key, bookid bigint not null, owner varchar(200) not null references epube_users(username) on delete cascade); + +create table if not exists epube_sessions (id varchar(250) not null primary key, + data text, + expire integer not null); + +create index epube_sessions_expire_index on epube_sessions(expire); |