Changeset 649

Timestamp:

Mar 26, 2014, 9:44:15 PM (11 years ago)

Author:

chronos

Message:

• Opraveno: Chyba v aktualizaci databáze.

File:

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

trunk/Common/Setup/Updates.php

@@ -569 +569 @@
   PRIMARY KEY (`Id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;');
-  $Manager->Execute('INSERT INTO `FinanceVATType` FROM (SELECT Id, Name FROM `FinanceVAT`)');
+  $Manager->Execute('INSERT INTO `FinanceVATType` (SELECT Id, Name FROM `FinanceVAT`)');
   $Manager->Execute('ALTER TABLE `FinanceVAT` ADD `ValidTo` DATE NULL ,
 ADD `Type` INT NOT NULL ;');
@@ -617 +617 @@
 `Id`
 ) ON DELETE RESTRICT ON UPDATE RESTRICT ;');
-  $Manager->Execute('ALTER TABLE `EmployeeSalary` ADD `Contract` INT NOT NULL ,
+  $Manager->Execute('ALTER TABLE `EmployeeSalary` ADD `Contract` INT NULL ,
 ADD INDEX ( `Contract` ) ;');
  $Manager->Execute('ALTER TABLE `EmployeeSalary` ADD FOREIGN KEY ( `Contract` ) REFERENCES `Contract` (