From 68c5cce0839d1cfff7a8c269c037fd8f4d12c7a1 Mon Sep 17 00:00:00 2001
From: tbrehm <t.brehm@ispconfig.org>
Date: Mon, 26 Sep 2011 03:16:28 -0400
Subject: [PATCH] Changed max. length for session hash keys from 32 chars to 64 chars in the mysql database.

---
 install/sql/ispconfig3.sql           |    2 +-
 install/sql/incremental/upd_0023.sql |    1 +
 2 files changed, 2 insertions(+), 1 deletions(-)

diff --git a/install/sql/incremental/upd_0023.sql b/install/sql/incremental/upd_0023.sql
new file mode 100644
index 0000000..2bbf3f3
--- /dev/null
+++ b/install/sql/incremental/upd_0023.sql
@@ -0,0 +1 @@
+ALTER TABLE  `sys_session` CHANGE  `session_id`  `session_id` VARCHAR( 64 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;
\ No newline at end of file
diff --git a/install/sql/ispconfig3.sql b/install/sql/ispconfig3.sql
index 4657a21..866a4ce 100644
--- a/install/sql/ispconfig3.sql
+++ b/install/sql/ispconfig3.sql
@@ -1375,7 +1375,7 @@
 --
 
 CREATE TABLE `sys_session` (
-  `session_id` varchar(32) NOT NULL DEFAULT '',
+  `session_id` varchar(64) NOT NULL DEFAULT '',
   `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   `last_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   `session_data` longtext,

--
Gitblit v1.9.1