Changeset 800 for trunk/Application

Timestamp:

Feb 22, 2016, 11:17:22 PM (8 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.

Location:

trunk/Application

Files:

• UpdateTrace.php (modified) (2 diffs)
• Version.php (modified) (1 diff)

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'),
     ));
   }

trunk/Application/Version.php

@@ -1 +1 @@
 <?php
 
-$Revision = 799; // Subversion revision
-$DatabaseRevision = 792; // SQL structure revision
-$ReleaseTime = strtotime('2016-02-10');
+$Revision = 800; // Subversion revision
+$DatabaseRevision = 800; // SQL structure revision
+$ReleaseTime = strtotime('2016-02-22');