From 4380e21c81cb00190bb2b0591cf10fdf2ad8238e Mon Sep 17 00:00:00 2001 From: christopherm Date: Tue, 21 Nov 2006 05:38:28 +0000 Subject: Moving to 1.2: Adding transaction_id. This will require an update to the session table, please drop table session and recreate with the create statement in Pg-central.sql. This is an anti-hijacking tool and something that will prevent users from double posting data. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@675 4979c152-3d1c-0410-bac9-87ea11338e46 --- sql/Pg-central.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'sql') 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; -- cgit v1.2.3