diff options
Diffstat (limited to 'sql')
| -rwxr-xr-x | sql/Pg-central.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/Pg-central.sql b/sql/Pg-central.sql index 50904801..15c16ad7 100755 --- a/sql/Pg-central.sql +++ b/sql/Pg-central.sql @@ -69,10 +69,10 @@ COMMENT ON FUNCTION update_user(int4,text) IS $$ Takes int4 which is users.id an CREATE TABLE session( session_id serial PRIMARY KEY, -sl_login VARCHAR(50), token VARCHAR(32) CHECK(length(token) = 32), last_used TIMESTAMP default now(), -users_id INTEGER -- NOT NULL references users(id) +users_id INTEGER NOT NULL references users(id), +transaction_id INTEGER NOT NULL ); commit; |