Changeset 649


Ignore:
Timestamp:
Mar 26, 2014, 9:44:15 PM (11 years ago)
Author:
chronos
Message:
  • Opraveno: Chyba v aktualizaci databáze.
File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/Common/Setup/Updates.php

    r647 r649  
    569569  PRIMARY KEY (`Id`)
    570570) ENGINE=InnoDB DEFAULT CHARSET=utf8;');
    571   $Manager->Execute('INSERT INTO `FinanceVATType` FROM (SELECT Id, Name FROM `FinanceVAT`)');
     571  $Manager->Execute('INSERT INTO `FinanceVATType` (SELECT Id, Name FROM `FinanceVAT`)');
    572572  $Manager->Execute('ALTER TABLE `FinanceVAT` ADD `ValidTo` DATE NULL ,
    573573ADD `Type` INT NOT NULL ;');
     
    617617`Id`
    618618) ON DELETE RESTRICT ON UPDATE RESTRICT ;');
    619   $Manager->Execute('ALTER TABLE `EmployeeSalary` ADD `Contract` INT NOT NULL ,
     619  $Manager->Execute('ALTER TABLE `EmployeeSalary` ADD `Contract` INT NULL ,
    620620ADD INDEX ( `Contract` ) ;');
    621621 $Manager->Execute('ALTER TABLE `EmployeeSalary` ADD FOREIGN KEY ( `Contract` ) REFERENCES `Contract` (
Note: See TracChangeset for help on using the changeset viewer.