Changeset 948 for trunk/Application
- Timestamp:
- Apr 10, 2023, 7:44:01 PM (19 months ago)
- Location:
- trunk/Application
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/Application/UpdateTrace.php
r947 r948 2184 2184 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;'); 2185 2185 $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;'); 2187 2187 2188 2188 // Convert NetworkSignal MAC from string into reference … … 2220 2220 2221 2221 function UpdateTo939(UpdateManager $Manager): void 2222 { 2222 { 2223 2223 $Manager->Execute('ALTER TABLE `Member` ADD `PaymentEmailTime` DATETIME NULL DEFAULT NULL AFTER `Contract`;'); 2224 2224 $Manager->Execute('UPDATE `Member` SET `PaymentEmailTime`=DATE_SUB(`BillingPeriodLastDate`, INTERVAL 1 MONTH) WHERE BillingPeriod=2 AND BillingPeriodLastDate<>"0000-00-00"'); … … 2227 2227 $Manager->Execute('UPDATE `Member` SET `PaymentEmailTime`=DATE_SUB(`BillingPeriodLastDate`, INTERVAL 12 MONTH) WHERE BillingPeriod=5 AND BillingPeriodLastDate<>"0000-00-00"'); 2228 2228 $Manager->Execute('ALTER TABLE `UserOnline` ENGINE = InnoDB;'); 2229 } 2230 2231 function 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;'); 2229 2234 } 2230 2235 … … 2339 2344 921 => array('Revision' => 933, 'Function' => 'UpdateTo933'), 2340 2345 933 => array('Revision' => 939, 'Function' => 'UpdateTo939'), 2346 939 => array('Revision' => 948, 'Function' => 'UpdateTo948'), 2341 2347 ); 2342 2348 } -
trunk/Application/Version.php
r945 r948 1 1 <?php 2 2 3 $Revision = 94 5; // Subversion revision4 $DatabaseRevision = 9 39; // SQL structure revision3 $Revision = 948; // Subversion revision 4 $DatabaseRevision = 948; // SQL structure revision 5 5 $ReleaseTime = strtotime('2022-12-06');
Note:
See TracChangeset
for help on using the changeset viewer.