Changeset 872 for trunk/Application/UpdateTrace.php
- Timestamp:
- Apr 9, 2017, 3:40:35 PM (8 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/Application/UpdateTrace.php
r867 r872 2945 2945 } 2946 2946 2947 function 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 2947 2958 class Updates 2948 2959 { … … 2982 2993 849 => array('Revision' => 857, 'Function' => 'UpdateTo857'), 2983 2994 857 => array('Revision' => 867, 'Function' => 'UpdateTo867'), 2995 867 => array('Revision' => 872, 'Function' => 'UpdateTo872'), 2984 2996 )); 2985 2997 }
Note:
See TracChangeset
for help on using the changeset viewer.