Changeset 527 for trunk/admin/Updates.php

Timestamp:

Apr 21, 2013, 11:24:56 PM (11 years ago)

Author:

chronos

Message:

• Upraveno: Tabulka ISMenuItem přepracována na obecnější MenuItem odkazující se na Menu. Nově položky nabídky jsou vázány přímo na akce tabulku Action.

File:

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

trunk/admin/Updates.php

@@ -275 +275 @@
 }
 
+function UpdateTo527($Manager)
+{
+  $Manager->Execute("RENAME TABLE `ISMenuItem` TO `MenuItem` ;");
+  $Manager->Execute("CREATE TABLE IF NOT EXISTS `Menu` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Name` varchar(255) NOT NULL,
+  PRIMARY KEY (`Id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");
+  $Manager->Execute("INSERT INTO `Menu` (`Id` ,`Name`)VALUES (NULL , 'IS');");
+  $Manager->Execute("ALTER TABLE `MenuItem` ADD `Menu` INT NOT NULL , ADD INDEX ( `Menu` )");
+  $Manager->Execute("UPDATE `MenuItem` SET `Menu` = 1");
+  $Manager->Execute("ALTER TABLE `MenuItem` ADD FOREIGN KEY ( `Menu` ) REFERENCES `Menu` (".
+    "`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;");
+  $Manager->Execute("ALTER TABLE `Action` CHANGE `Group` `Group` INT( 11 ) NULL ");
+  $Manager->Execute("INSERT INTO `Action` (SELECT NULL AS `Id`, '' AS `Name`, `Name` AS `Title`, 1 AS `Type`, CONCAT('/is/?t=', `Table`, '&a=list') AS `URL`, NULL AS `Group`, NULL AS `Icon`, NULL AS `PermisionModule`,  NULL AS `PermissionOperation`, 1 AS `Enable` FROM `MenuItem` WHERE `Parent` IS NOT NULL)");
+  $Manager->Execute("ALTER TABLE `MenuItem` DROP `IconName`");
+  $Manager->Execute("UPDATE `MenuItem` SET `Table` = (SELECT `Id` FROM `Action` WHERE `Action`.`URL` = CONCAT('/is/?t=', `MenuItem`.`Table`, '&a=list')) WHERE `MenuItem`.`Table` != ''");
+  $Manager->Execute("ALTER TABLE `MenuItem` CHANGE `Table` `Action` INT NULL");
+  $Manager->Execute("UPDATE `MenuItem` SET `Action` = NULL WHERE `Action` = 0");
+  $Manager->Execute("ALTER TABLE `MenuItem` ADD INDEX ( `Action` ) ");
+  $Manager->Execute("ALTER TABLE `MenuItem` ADD FOREIGN KEY ( `Action` ) REFERENCES `Action` (`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;");
+  $Manager->Execute("INSERT INTO `Action` (`Id` ,`Name` ,`Title` ,`Type` ,`URL` ,`Group` ,`Icon` ,`PermissionModule` ,`PermissionOperation` ,`Enable`)".
+    "VALUES (NULL , '', 'Nabídky', '1', '/is/?t=Menu&a=list', NULL , NULL , '', '', '1');");
+  $ActionId = $Manager->Database->insert_id;
+  $Manager->Execute("INSERT INTO `MenuItem` (`Id` ,`Name` ,`Parent` ,`Action` ,`Menu`) ".
+    "VALUES (NULL , 'Nabídky', '23', '".$ActionId."', '1');");  
+  
+}
+
 $Updates = array(
   491 => array('Revision' => 493, 'Function' => 'UpdateTo493'),
@@ -289 +318 @@
   515 => array('Revision' => 517, 'Function' => 'UpdateTo517'),
   517 => array('Revision' => 526, 'Function' => 'UpdateTo526'),
+  526 => array('Revision' => 527, 'Function' => 'UpdateTo527'),
 );