From 60e4fdba8795ac832cc7fc41a644af4c1f56e71d Mon Sep 17 00:00:00 2001 From: linuxpoet Date: Sat, 21 Oct 2006 17:21:14 +0000 Subject: fixed length check for upgrades git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@256 4979c152-3d1c-0410-bac9-87ea11338e46 --- sql/Pg-upgrade-2.6.18-2.6.19.sql | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'sql') diff --git a/sql/Pg-upgrade-2.6.18-2.6.19.sql b/sql/Pg-upgrade-2.6.18-2.6.19.sql index b60aadac..dd8583eb 100644 --- a/sql/Pg-upgrade-2.6.18-2.6.19.sql +++ b/sql/Pg-upgrade-2.6.18-2.6.19.sql @@ -138,3 +138,7 @@ ALTER TABLE tax ALTER COLUMN pass SET NOT NULL; ALTER TABLE tax ADD COLUMN taxmodule_id int REFERENCES taxmodule DEFAULT 1; UPDATE tax SET taxmodule_id = 1; ALTER TABLE tax ALTER COLUMN taxmodule_id SET NOT NULL; + +-- Fixed session table -- +ALTER TABLE session ADD CONSTRAINT session_token_check check (length(token::text) = 32); + -- cgit v1.2.3