Changeset 1043

Show
Ignore:
Timestamp:
04/23/2008 10:21:03 PM (2 years ago)
Author:
BrianKoontz
Message:

Changed sessionid field size to 40 bytes to support smallest
hash_bits_per_character value of 4 bits for SHA-1. Refs #739.

Files:
1 modified

Legend:

Unmodified
Added
Removed

  • trunk/setup/install.php

    r1041 r1043  
    130130                @mysql_query( 
    131131                        "CREATE TABLE ".$config["table_prefix"]."sessions (". 
    132                          "sessionid char(32) NOT NULL,". 
     132                         "sessionid char(40) NOT NULL,". 
    133133                         "userid varchar(75) NOT NULL,". 
    134134                         "PRIMARY KEY (sessionid, userid),". 
    … …  
    356356        @mysql_query('alter table '.$config['table_prefix'].'links drop index `idx_from`', $dblink), __('Already done?  OK!'), 0); 
    357357        test("Adding sessions tracking table...", 
    358         mysql_query("create table ".$config['table_prefix']."sessions (sessionid char(32) NOT NULL, userid varchar(75) NOT NULL, PRIMARY KEY (sessionid, userid), session_start datetime NOT NULL)"), "Already done? OK!", 0); 
     358        mysql_query("create table ".$config['table_prefix']."sessions (sessionid char(40) NOT NULL, userid varchar(75) NOT NULL, PRIMARY KEY (sessionid, userid), session_start datetime NOT NULL)"), "Already done? OK!", 0); 
    359359        test("Adding AdminUsers page...",  
    360360        mysql_query("insert into ".$config['table_prefix']."pages set tag = 'AdminUsers', body = '{{adminusers}}\n\n----\nCategoryAdmin', owner = '(Public)', note='".$upgrade_note."', user = 'WikkaInstaller', time = now(), latest = 'Y'", $dblink), "Already done? OK!", 0);