Changeset 495 for trunk/admin/Updates.php

Timestamp:

Mar 1, 2013, 11:02:44 PM (12 years ago)

Author:

chronos

Message:

• Upraveno: Pozice subjektu na mapě se nyní zadává jako odkaz do tabulky MapPosition.

File:

• trunk/admin/Updates.php (modified) (1 diff)

trunk/admin/Updates.php

@@ -13 +13 @@
 }
 
-
+function UpdateTo495($Manager)
+{
+  $Manager->Execute("INSERT INTO `MapPosition` (SELECT NULL AS `Id`, `Name`, `MapPositionX` AS `Latitude`, `MapPositionY` AS `Longitude` FROM `Subject`)");
+  $Manager->Execute("ALTER TABLE `Subject` ADD `MapPosition` INT NULL AFTER `PayVAT`");
+  $Manager->Execute("UPDATE `Subject` SET `MapPosition` = (SELECT `MapPosition`.`Id` FROM `MapPosition` WHERE `MapPosition`.`Name` = `Subject`.`Name` LIMIT 1)");
+  $Manager->Execute("ALTER TABLE `Subject`  DROP `MapPositionX`,  DROP `MapPositionY`;");
+  $Manager->Execute("ALTER TABLE `Subject` ADD INDEX ( `MapPosition` ) ");
+  $Manager->Execute("ALTER TABLE `Subject` ADD FOREIGN KEY ( `MapPosition` ) REFERENCES `MapPosition` (".
+    "`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;");
+}
 
 $Updates = array(
         491 => array('Revision' => 493, 'Function' => 'UpdateTo493'),
   493 => array('Revision' => 494, 'Function' => 'UpdateTo494'),
+  494 => array('Revision' => 495, 'Function' => 'UpdateTo495'),
 );