Changeset 741 for trunk/Common/Setup/Updates.php

Timestamp:

Jul 5, 2015, 6:24:33 PM (9 years ago)

Author:

chronos

Message:

• Modified: Added Direction column to finance operations and invoices. This column will serve as real direction where ValueSign could be different for storno operations.

File:

• trunk/Common/Setup/Updates.php (modified) (3 diffs)

trunk/Common/Setup/Updates.php

@@ -1355 +1355 @@
   `Domain` int(11) NOT NULL,
   `Sequence` int(11) NOT NULL,
+  PRIMARY KEY (`Id`)
 ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;');
 
-  $Manager->Execute('ALTER TABLE `NetworkDomainServer`
- ADD PRIMARY KEY (`Id`), ADD KEY `Domain` (`Domain`);');
+  $Manager->Execute('ALTER TABLE `NetworkDomainServer` ADD KEY `Domain` (`Domain`);');
 
   $Manager->Execute('ALTER TABLE `NetworkDomainServer`
@@ -1421 +1421 @@
   $Manager->Execute('ALTER TABLE `FinanceInvoice` CHANGE `Direction` `ValueSign` INT(11) NOT NULL;');
   $Manager->Execute('ALTER TABLE `FinanceOperation` CHANGE `Direction` `ValueSign` INT(11) NOT NULL;');
+}
+
+function UpdateTo741($Manager)
+{
+        // Add Direction column
+  $Manager->Execute('ALTER TABLE `FinanceOperationGroup` ADD `Direction` INT NOT NULL ;');
+  $Manager->Execute('UPDATE `FinanceOperationGroup` SET `Direction` = 1 WHERE ValueSign=-1');
+  $Manager->Execute('ALTER TABLE `FinanceOperation` ADD `Direction` INT NOT NULL AFTER `Cash`;');
+  $Manager->Execute('UPDATE `FinanceOperation` SET `Direction` = 1 WHERE ValueSign=-1');
+  $Manager->Execute('ALTER TABLE `FinanceInvoiceGroup` ADD `Direction` INT NOT NULL ;');
+  $Manager->Execute('UPDATE `FinanceInvoiceGroup` SET `Direction` = 1 WHERE ValueSign=1');
+  $Manager->Execute('ALTER TABLE `FinanceInvoice` ADD `Direction` INT NOT NULL AFTER `TimePayment`;');  
+  $Manager->Execute('UPDATE `FinanceInvoice` SET `Direction` = 1 WHERE ValueSign=1');
 }
 
@@ -1490 +1503 @@
       735 => array('Revision' => 736, 'Function' => 'UpdateTo736'),
       736 => array('Revision' => 739, 'Function' => 'UpdateTo739'),
+        739 => array('Revision' => 740, 'Function' => 'UpdateTo740'),
+        740 => array('Revision' => 741, 'Function' => 'UpdateTo741'),
     ));
   }