SF.net SVN: ledger-smb: [256] trunk/sql/Pg-upgrade-2.6.18-2.6.19.sql

[..hidden..]

Revision: 256
          http://svn.sourceforge.net/ledger-smb/?rev=256&view=rev
Author:   linuxpoet
Date:     2006-10-21 10:21:14 -0700 (Sat, 21 Oct 2006)

Log Message:
-----------
fixed length check for upgrades

Modified Paths:
--------------
    trunk/sql/Pg-upgrade-2.6.18-2.6.19.sql

Modified: trunk/sql/Pg-upgrade-2.6.18-2.6.19.sql
===================================================================
--- trunk/sql/Pg-upgrade-2.6.18-2.6.19.sql	2006-10-21 17:09:24 UTC (rev 255)
+++ trunk/sql/Pg-upgrade-2.6.18-2.6.19.sql	2006-10-21 17:21:14 UTC (rev 256)
@@ -138,3 +138,7 @@
 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);
+


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.