Changeset 551 for trunk/admin/Updates.php

Timestamp:

Jul 7, 2013, 9:26:44 PM (11 years ago)

Author:

chronos

Message:

• Přidáno: Automatické generování kódu dokladu při vytváření nové položky v IS a při importu z Fio banky.
• Odstraněno: Staré akce na stránce "Správa financí".

File:

• trunk/admin/Updates.php (modified) (2 diffs)

trunk/admin/Updates.php

@@ -329 +329 @@
 }
 
+function UpdateTo551($Manager)
+{  
+  $Manager->Execute('ALTER TABLE `FinanceOperation` ADD `DocumentLine` INT NULL AFTER `Value` ,
+ADD INDEX ( `DocumentLine` ) ;');
+  $Manager->Execute('ALTER TABLE `FinanceOperation` ADD FOREIGN KEY ( `DocumentLine` ) REFERENCES `DocumentLine` (
+`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;');
+  $Manager->Execute('ALTER TABLE `FinanceInvoice` ADD `DocumentLine` INT NULL AFTER `Id` ,
+ADD INDEX ( `DocumentLine` ) ;');
+  $Manager->Execute('ALTER TABLE `FinanceInvoice` ADD FOREIGN KEY ( `DocumentLine` ) REFERENCES `DocumentLine` (
+`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;');
+  $Manager->Execute('DROP TABLE `FinanceBillsOld`');
+  $Manager->Execute('DROP TABLE `FinanceBillsItemsOld`');
+}
+
+
 $Updates = array(
   491 => array('Revision' => 493, 'Function' => 'UpdateTo493'),
@@ -347 +362 @@
   535 => array('Revision' => 549, 'Function' => 'UpdateTo549'),
   549 => array('Revision' => 550, 'Function' => 'UpdateTo550'),
+  550 => array('Revision' => 551, 'Function' => 'UpdateTo551'),
 );