Changeset 880 for trunk/Application/UpdateTrace.php
- Timestamp:
- Apr 7, 2020, 10:15:48 PM (5 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/Application/UpdateTrace.php
r879 r880 2483 2483 2484 2484 $DbResult = $System->Database->query('SELECT `TablePrefix` FROM `Group`'); 2485 while ($Group = $DbResult->fetch_assoc())2485 while ($Group = $DbResult->fetch_assoc()) 2486 2486 { 2487 2487 $Manager->Execute('ALTER TABLE `'.$Group['TablePrefix'].'` ADD FOREIGN KEY ( `Language` ) REFERENCES `Language` ('. … … 2532 2532 // Set all string collation to utf8 general 2533 2533 $DbResult = $Manager->Execute("SHOW TABLES"); 2534 while ($DbRow = $DbResult->fetch_row())2534 while ($DbRow = $DbResult->fetch_row()) 2535 2535 { 2536 2536 $Manager->Execute("ALTER TABLE `".$DbRow[0]."` CONVERT TO CHARACTER SET utf8"); … … 2946 2946 2947 2947 function UpdateTo872($Manager) 2948 { 2948 { 2949 2949 // Allow to store IPv6 addresses 2950 2950 $Manager->Execute('ALTER TABLE `UserOnline` CHANGE `IpAddress` `IpAddress` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT "";'); … … 2957 2957 2958 2958 function UpdateTo873($Manager) 2959 { 2959 { 2960 2960 $Manager->Execute('ALTER TABLE `User` CHANGE `XP` `XP` INT(11) NOT NULL DEFAULT "0";'); 2961 2961 $Manager->Execute('ALTER TABLE `User` CHANGE `TranslatedCount` `TranslatedCount` INT(11) NOT NULL DEFAULT "0";'); … … 2971 2971 function Get() 2972 2972 { 2973 return (array(2973 return array( 2974 2974 498 => array('Revision' => 506, 'Function' => 'UpdateTo506'), 2975 2975 506 => array('Revision' => 510, 'Function' => 'UpdateTo510'), … … 3006 3006 867 => array('Revision' => 872, 'Function' => 'UpdateTo872'), 3007 3007 872 => array('Revision' => 873, 'Function' => 'UpdateTo873'), 3008 ) );3008 ); 3009 3009 } 3010 3010 }
Note:
See TracChangeset
for help on using the changeset viewer.