Changeset 878 for trunk/Application/UpdateTrace.php

Timestamp:

Jun 25, 2020, 10:21:26 AM (4 years ago)

Author:

chronos

Message:

• Fixed: Import of news from zdechov.cz and obec-hovezi.cz.

File:

• trunk/Application/UpdateTrace.php (modified) (2 diffs)

trunk/Application/UpdateTrace.php

@@ -2109 +2109 @@
   $Manager->Execute('UPDATE `NetworkSubnet` SET `MaskIPv6`=64 WHERE `AddressRangeIPv6` != ""');
   $Manager->Execute('UPDATE `NetworkSubnet` SET `AddressRangeIPv6` = REPLACE(`AddressRangeIPv6`, "/64", "")');
+}
+
+function UpdateTo878($Manager)
+{
+  $Manager->Execute('ALTER TABLE `NewsImport` ADD `Method` VARCHAR(255) NOT NULL AFTER `Category`;');
+  $Manager->Execute('ALTER TABLE `NewsImport` ADD PRIMARY KEY (`Id`);');
+  $Manager->Execute('ALTER TABLE `NewsImport` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;');
 }
 
@@ -2211 +2218 @@
       867 => array('Revision' => 869, 'Function' => 'UpdateTo869'),
       869 => array('Revision' => 870, 'Function' => 'UpdateTo870'),
+      870 => array('Revision' => 878, 'Function' => 'UpdateTo878'),
     );
   }