Changeset 591 for trunk/Modules

Timestamp:

Nov 2, 2013, 3:54:49 PM (12 years ago)

Author:

chronos

Message:

• Přidáno: Skladová položka nyní může mít nyní jako sestava podpoložky.

Location:

trunk/Modules

Files:

• Setup/Updates.php (modified) (2 diffs)
• Stock/Stock.php (modified) (1 diff)

trunk/Modules/Setup/Updates.php

@@ -441 +441 @@
 }
 
+function UpdateTo591($Manager)
+{
+  $Manager->Execute('ALTER TABLE `StockItem` ADD `Esemble` INT NULL ,
+ADD INDEX ( `Esemble` ) ;');
+  $Manager->Execute('ALTER TABLE `StockItem` ADD FOREIGN KEY ( `Esemble` ) REFERENCES StockItem` (
+`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;');
+}
+
 class Updates
 {
@@ -468 +476 @@
   571 => array('Revision' => 574, 'Function' => 'UpdateTo574'),
   574 => array('Revision' => 584, 'Function' => 'UpdateTo584'),
+  584 => array('Revision' => 591, 'Function' => 'UpdateTo591'),
 ));
     }

trunk/Modules/Stock/Stock.php

@@ -50 +50 @@
         'Segment' => array('Type' => 'TNetworkSegment', 'Caption' => 'Úsek sítě', 'Default' => '', 'Null' => true),
         'Info' => array('Type' => 'Text', 'Caption' => 'Informace', 'Default' => ''),
+        'Esemble' => array('Type' => 'TStockItem', 'Caption' => 'Celek', 'Default' => ''),
+        'Parts' => array('Type' => 'TStockItemListStockItem', 'Caption' => 'Části', 'Default' => ''),          
       ),
     ));