summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorlinuxpoet <linuxpoet@4979c152-3d1c-0410-bac9-87ea11338e46>2006-10-21 17:21:14 +0000
committerlinuxpoet <linuxpoet@4979c152-3d1c-0410-bac9-87ea11338e46>2006-10-21 17:21:14 +0000
commit60e4fdba8795ac832cc7fc41a644af4c1f56e71d (patch)
treee1955cc684f4d7fb34bfeafad9ac5c5a00dd6433
parentaf108df9ba2f8a7b7ffa9788a7e0f96844133a51 (diff)
fixed length check for upgrades
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@256 4979c152-3d1c-0410-bac9-87ea11338e46
-rw-r--r--sql/Pg-upgrade-2.6.18-2.6.19.sql4
1 files changed, 4 insertions, 0 deletions
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);
+