Changeset 727

Timestamp:

May 26, 2020 8:12:25 PM (4 years ago)

Author:

anonymous

Message:

Update session_tbl.session_id to support 256 chars and CHARACTER SET ascii COLLATE ascii_bin

File:

• trunk/lib/DBSessionHandler.inc.php (modified) (1 diff)

trunk/lib/DBSessionHandler.inc.php

@@ -107 +107 @@
             }
             $this->db->query("CREATE TABLE IF NOT EXISTS " . $this->db->escapeString($this->_params['db_table']) . " (
-                session_id VARCHAR(191) NOT NULL DEFAULT '',
-                session_data mediumtext NOT NULL,
-                last_access timestamp NOT NULL,
-                PRIMARY KEY (session_id),
-                KEY last_access (last_access)
-            )");
+                `session_id` VARCHAR(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT '',
+                `session_data` MEDIUMTEXT NOT NULL,
+                `last_access` TIMESTAMP(14) NOT NULL,
+                PRIMARY KEY `session_id` (`session_id`),
+                KEY `last_access` (`last_access`)
+            ) ENGINE=InnoDB DEFAULT CHARSET=utf8");
 
             if (!$this->db->columnExists($this->_params['db_table'], array(