Ignore:
Timestamp:
Apr 9, 2017, 3:40:35 PM (8 years ago)
Author:
chronos
Message:
File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/Application/UpdateTrace.php

    r867 r872  
    29452945}
    29462946
     2947function UpdateTo872($Manager)
     2948{       
     2949  // Allow to store IPv6 addresses
     2950  $Manager->Execute('ALTER TABLE `UserOnline` CHANGE `IpAddress` `IpAddress` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT "";');
     2951  $Manager->Execute('ALTER TABLE `UserTrace` CHANGE `LastLogin` `LastLogin` DATETIME NULL;');
     2952  $Manager->Execute('ALTER TABLE `UserTrace` CHANGE `LastLogout` `LastLogout` DATETIME NULL;');
     2953  $Manager->Execute('UPDATE `UserTrace` SET LastLogin=NULL WHERE CAST(LastLogin AS CHAR(20))="0000-00-00 00:00:00"');
     2954  $Manager->Execute('UPDATE `UserTrace` SET LastLogout=NULL WHERE CAST(LastLogout AS CHAR(20))="0000-00-00 00:00:00"');
     2955  $Manager->Execute('ALTER TABLE `UserTrace` CHANGE `LastIP` `LastIP` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;');
     2956}
     2957
    29472958class Updates
    29482959{
     
    29822993  849 => array('Revision' => 857, 'Function' => 'UpdateTo857'),
    29832994  857 => array('Revision' => 867, 'Function' => 'UpdateTo867'),
     2995  867 => array('Revision' => 872, 'Function' => 'UpdateTo872'),
    29842996    ));
    29852997  }
Note: See TracChangeset for help on using the changeset viewer.