Changeset 800 for trunk/Application/UpdateTrace.php

Timestamp:

Feb 22, 2016, 11:17:22 PM (9 years ago)

Author:

chronos

Message:

• Modified: StockSerialNumber info transformed to separate table so multiple history items with different time can be added to track serial number history.

File:

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

trunk/Application/UpdateTrace.php

@@ -1820 +1820 @@
     $Manager->Execute('UPDATE `Contract` SET `BillCode`='.$CodeId.' WHERE `Id`='.$DbRow['Id']);
   }
-  //$Manager->Execute('ALTER TABLE `Contract` DROP `BillCodeText`;');
+  $Manager->Execute('ALTER TABLE `Contract` DROP `BillCodeText`;');
+  $Manager->Execute('ALTER TABLE `StockSerialNumber` DROP `Info`;');
+}
+
+function UpdateTo800($Manager)
+{
+  $Manager->Execute('CREATE TABLE IF NOT EXISTS `StockItemHistory` (
+    `Id` int(11) NOT NULL,
+    `StockSerialNumber` int(11) NOT NULL,
+    `Time` datetime NOT NULL,
+    `Text` varchar(255) NOT NULL,
+    PRIMARY KEY (`Id`),
+    KEY `StockSerialNumber` (`StockSerialNumber`)
+   ) ENGINE=InnoDB DEFAULT CHARSET=utf8;');
+  $Manager->Execute('ALTER TABLE `StockItemHistory` ADD FOREIGN KEY (`StockSerialNumber`) '.
+    'REFERENCES `StockSerialNumber`(`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT;');
+  $Manager->Execute('INSERT INTO `StockItemHistory` (SELECT NULL AS `Id`, `Id` AS `StockSerialNumber`, '.
+    '"" AS `Time`, `Info` AS `Text` FROM `StockSerialNumber`)');
 }
 
@@ -1906 +1923 @@
       785 => array('Revision' => 786, 'Function' => 'UpdateTo786'),
       786 => array('Revision' => 792, 'Function' => 'UpdateTo792'),
+      792 => array('Revision' => 800, 'Function' => 'UpdateTo800'),
     ));
   }