diff options
| -rwxr-xr-x | sql/Pg-tables.sql | 6 |
1 files changed, 2 insertions, 4 deletions
diff --git a/sql/Pg-tables.sql b/sql/Pg-tables.sql index 59e60248..78b7835f 100755 --- a/sql/Pg-tables.sql +++ b/sql/Pg-tables.sql @@ -564,12 +564,10 @@ CREATE TABLE jcitems ( -- Session tracking table -CREATE SEQUENCE session_session_id_seq; - CREATE TABLE session( -session_id INTEGER PRIMARY KEY DEFAULT nextval('session_session_id_seq'), +session_id serial PRIMARY KEY, sl_login VARCHAR(50), -token CHAR(32), +token VARCHAR(32) CHECK(length(token) = 32), last_used TIMESTAMP default now() ); |