WordPress.org

Making WordPress.org

Changeset 159


Ignore:
Timestamp:
12/20/2013 06:40:21 AM (7 years ago)
Author:
nacin
Message:

Trac MySQL migration: Bump session ID fields to 80 characters.

We found some anonymous session identifiers that were mangled with other cookie parameters, totalling 64 or 65 characters in length. (Trac bug?)

see #253.

File:
1 edited

Legend:

Unmodified
Added
Removed
  • sites/trunk/trac.wordpress.org/db/mysql-schema.sql

    r157 r159  
    214214/*!40101 SET character_set_client = utf8 */;
    215215CREATE TABLE IF NOT EXISTS `session` (
    216   `sid` varchar(60) COLLATE utf8_bin NOT NULL,
     216  `sid` varchar(80) COLLATE utf8_bin NOT NULL,
    217217  `authenticated` int(11) NOT NULL DEFAULT '0',
    218218  `last_visit` int(11) DEFAULT NULL,
     
    230230/*!40101 SET character_set_client = utf8 */;
    231231CREATE TABLE IF NOT EXISTS `session_attribute` (
    232   `sid` varchar(60) COLLATE utf8_bin NOT NULL,
     232  `sid` varchar(80) COLLATE utf8_bin NOT NULL,
    233233  `authenticated` int(11) NOT NULL DEFAULT '0',
    234234  `name` varchar(100) COLLATE utf8_bin NOT NULL,
Note: See TracChangeset for help on using the changeset viewer.