Changeset 503 for trunk/admin/Updates.php

Timestamp:

Mar 17, 2013, 10:49:19 AM (12 years ago)

Author:

chronos

Message:

• Opraveno: Aktualizace databáze z 499 na 502.

File:

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

trunk/admin/Updates.php

@@ -136 +136 @@
   $Manager->Execute("ALTER TABLE `FinanceBankAccount` ADD `Bank` INT NOT NULL AFTER `Number` ,".
      " ADD INDEX ( `Bank` )");
+  $Manager->Execute("INSERT INTO `FinanceBank` (`Id`, `Name`, `Code`, `BIC`, `Country`) VALUES
+  (1, 'Neznámá banka', '', '', 1);");
+  $Manager->Execute("UPDATE `FinanceBankAccount` SET `Bank` = 1 WHERE `Bank` = 0");
   $Manager->Execute("ALTER TABLE `FinanceBankAccount` ADD FOREIGN KEY ( `Bank` ) REFERENCES `FinanceBank` (".
     "`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;");
@@ -150 +153 @@
   $Manager->Execute("INSERT INTO `ISMenuItem` (`Id` ,`Name` ,`Parent` ,`Table` ,`IconName`) ".
     "VALUES (NULL , 'Banka', '2', '', '');");
-  $Manager->Execute("UPDATE `ISMenuItem` SET `Parent` = '51' WHERE `ISMenuItem`.`Id` =10; ".
-    "UPDATE `ISMenuItem` SET `Parent` = '51' WHERE `ISMenuItem`.`Id` =48;".
-    "UPDATE `ISMenuItem` SET `Parent` = '51' WHERE `ISMenuItem`.`Id` =50;");
+  $Id = $Manager->Database->insert_id;
+  $Manager->Execute("UPDATE `ISMenuItem` SET `Parent` = '".$Id."' WHERE `ISMenuItem`.`Id` =10; ".
+    "UPDATE `ISMenuItem` SET `Parent` = '".$Id."' WHERE `ISMenuItem`.`Id` =48;".
+    "UPDATE `ISMenuItem` SET `Parent` = '".$Id."' WHERE `ISMenuItem`.`Id` =50;");
 }