connect-session-knex
Advanced tools
Comparing version 1.3.1 to 1.3.2
@@ -138,5 +138,5 @@ 'use strict'; | ||
if (['mysql', 'mariasql'].indexOf(self.knex.client.dialect) > -1) { | ||
table.dateTime('expired').notNullable(); | ||
table.dateTime('expired').notNullable().index(); | ||
} else { | ||
table.timestamp('expired').notNullable(); | ||
table.timestamp('expired').notNullable().index(); | ||
} | ||
@@ -143,0 +143,0 @@ }); |
{ | ||
"name": "connect-session-knex", | ||
"description": "A knex.js session store for Express and Connect", | ||
"version": "1.3.1", | ||
"version": "1.3.2", | ||
"main": "index.js", | ||
@@ -6,0 +6,0 @@ "engines": { |
@@ -41,4 +41,19 @@ # Connect Session Knex | ||
This module does not create any indexes. You should create an index on the 'expired' column to make the session clearing efficient. | ||
## Schema | ||
### PostgreSQL or SQLite | ||
#### Table Name "sessions" | ||
| Column | Type | Modifiers | Storage | | ||
|---------|:------------------------:|:---------:|:--------:| | ||
| sid | character varying(255) | not null | extended | | ||
| sess | json | not null | extended | | ||
| expired | timestamp with time zone | not null | plain | | ||
### Indexes: | ||
``` | ||
"sessions_pkey" PRIMARY KEY, btree (sid) | ||
"sessions_expired_index" btree (expired) | ||
``` | ||
## Benchmarks | ||
@@ -45,0 +60,0 @@ |
License Policy Violation
LicenseThis package is not allowed per your license policy. Review the package's license to ensure compliance.
Found 1 instance in 1 package
License Policy Violation
LicenseThis package is not allowed per your license policy. Review the package's license to ensure compliance.
Found 1 instance in 1 package
14243
78