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

Timestamp:

Mar 25, 2014, 12:38:20 AM (11 years ago)

Author:

chronos

Message:

• Přidáno: Typ sazby DPH jako samostatná tabulka.

File:

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

trunk/Common/Setup/Updates.php

@@ -562 +562 @@
 }
 
+function UpdateTo645($Manager)
+{
+        $Manager->Execute('CREATE TABLE IF NOT EXISTS `FinanceVATType` (
+  `Id` int(11) NOT NULL,
+  `Name` varchar(255) NOT NULL,
+  PRIMARY KEY (`Id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;');
+  $Manager->Execute('INSERT INTO `FinanceVATType` FROM (SELECT Id, Name FROM `FinanceVAT`)');
+  $Manager->Execute('ALTER TABLE `FinanceVAT` ADD `ValidTo` DATE NULL ,
+ADD `Type` INT NOT NULL ;');
+  $Manager->Execute('UPDATE `FinanceVAT` SET `Type`=(SELECT `Id` FROM `FinanceVATType` WHERE `FinanceVATType`.`Name`=`FinanceVAT`.`Name`)');
+  $Manager->Execute('ALTER TABLE `FinanceVAT` DROP `Name`');
+}
+
+
 class Updates
 {
@@ -598 +613 @@
       627 => array('Revision' => 632, 'Function' => 'UpdateTo632'),
       632 => array('Revision' => 633, 'Function' => 'UpdateTo633'),
+      633 => array('Revision' => 645, 'Function' => 'UpdateTo645'),
     ));
   }