Changeset 948 for trunk/Application


Ignore:
Timestamp:
Apr 10, 2023, 7:44:01 PM (19 months ago)
Author:
chronos
Message:
  • Fixed: IP address database field size in News table for IPv6.
Location:
trunk/Application
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • trunk/Application/UpdateTrace.php

    r947 r948  
    21842184  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;');
    21852185  $Manager->Execute('ALTER TABLE `NetworkMac` ADD PRIMARY KEY (`Id`), ADD KEY `MAC` (`MAC`);');
    2186   $Manager->Execute('ALTER TABLE `NetworkMac` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;'); 
     2186  $Manager->Execute('ALTER TABLE `NetworkMac` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;');
    21872187
    21882188  // Convert NetworkSignal MAC from string into reference
     
    22202220
    22212221function UpdateTo939(UpdateManager $Manager): void
    2222 { 
     2222{
    22232223  $Manager->Execute('ALTER TABLE `Member` ADD `PaymentEmailTime` DATETIME NULL DEFAULT NULL AFTER `Contract`;');
    22242224  $Manager->Execute('UPDATE `Member` SET `PaymentEmailTime`=DATE_SUB(`BillingPeriodLastDate`, INTERVAL 1 MONTH) WHERE BillingPeriod=2 AND BillingPeriodLastDate<>"0000-00-00"');
     
    22272227  $Manager->Execute('UPDATE `Member` SET `PaymentEmailTime`=DATE_SUB(`BillingPeriodLastDate`, INTERVAL 12 MONTH) WHERE BillingPeriod=5 AND BillingPeriodLastDate<>"0000-00-00"');
    22282228  $Manager->Execute('ALTER TABLE `UserOnline` ENGINE = InnoDB;');
     2229}
     2230
     2231function UpdateTo948(UpdateManager $Manager): void
     2232{
     2233  $Manager->Execute('ALTER TABLE `News` CHANGE `IP` `IP` VARCHAR(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL;');
    22292234}
    22302235
     
    23392344      921 => array('Revision' => 933, 'Function' => 'UpdateTo933'),
    23402345      933 => array('Revision' => 939, 'Function' => 'UpdateTo939'),
     2346      939 => array('Revision' => 948, 'Function' => 'UpdateTo948'),
    23412347    );
    23422348  }
  • trunk/Application/Version.php

    r945 r948  
    11<?php
    22
    3 $Revision = 945; // Subversion revision
    4 $DatabaseRevision = 939; // SQL structure revision
     3$Revision = 948; // Subversion revision
     4$DatabaseRevision = 948; // SQL structure revision
    55$ReleaseTime = strtotime('2022-12-06');
Note: See TracChangeset for help on using the changeset viewer.