Changeset 803 for trunk/Application/UpdateTrace.php

Timestamp:

Feb 23, 2016, 7:18:38 PM (9 years ago)

Author:

chronos

Message:

• Added: Relation between StockMoveItem and StockSerialNumber so serial numbers can be associated with stock move items now.

File:

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

trunk/Application/UpdateTrace.php

@@ -1887 +1887 @@
   $Manager->Execute('ALTER TABLE `StockMove` DROP `BillCodeText`;');
   $Manager->Execute('ALTER TABLE `StockMoveItem` DROP `Text`;');
+}
+
+function UpdateTo803($Manager)
+{
+  $Manager->Execute('CREATE TABLE IF NOT EXISTS `StockMoveItemSerialRel` (
+  `Id` int(11) NOT NULL,
+  `StockMoveItem` int(11) NOT NULL,
+  `StockSerialNumber` int(11) NOT NULL,
+  PRIMARY KEY (`Id`),
+  KEY `StockSerialNumber` (`StockSerialNumber`),
+  KEY `StockMoveItem` (`StockMoveItem`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;');
+  $Manager->Execute('ALTER TABLE `StockMoveItemSerialRel` ADD FOREIGN KEY (`StockMoveItem`) '.
+    'REFERENCES `StockMoveItem`(`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT;');
+  $Manager->Execute('ALTER TABLE `StockMoveItemSerialRel` ADD FOREIGN KEY (`StockSerialNumber`) '.
+    'REFERENCES `StockSerialNumber`(`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT;');
 }
 
@@ -1974 +1990 @@
       792 => array('Revision' => 800, 'Function' => 'UpdateTo800'),
       800 => array('Revision' => 802, 'Function' => 'UpdateTo802'),
+      802 => array('Revision' => 803, 'Function' => 'UpdateTo803'),
     ));
   }