Changeset 505 for trunk/admin/Updates.php

Timestamp:

Apr 1, 2013, 12:29:37 AM (12 years ago)

Author:

chronos

Message:

• Upraveno: Procházení sdílení přetvořeno na aplikační modul.
• Ukládání a udržování souborů na disku bude nyní samostatný modul. Na tomto modulu zavisí moduly Finance a News.

File:

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

trunk/admin/Updates.php

@@ -56 +56 @@
   $Manager->Execute("INSERT INTO `ISMenuItem` (`Id` ,`Name` ,`Parent` ,`Table` ,`IconName`) ".
     "VALUES (NULL , 'Sítové služby', '1', 'NetworkConfiguration', '');");
-  $Manager->Execute("INSERT INTO `centrala`.`ISMenuItem` (`Id` ,`Name` ,`Parent` ,`Table` ,`IconName`) ".
+  $Manager->Execute("INSERT INTO `ISMenuItem` (`Id` ,`Name` ,`Parent` ,`Table` ,`IconName`) ".
     "VALUES (NULL , 'Fronta e-mailů', '23', 'EmailQueue', '');");
   $Manager->Execute("CREATE TABLE IF NOT EXISTS `FinanceVAT` (
@@ -154 +154 @@
     "VALUES (NULL , 'Banka', '2', '', '');");
   $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;");
+  $Manager->Execute("UPDATE `ISMenuItem` SET `Parent` = '".$Id."' WHERE `ISMenuItem`.`Id` =''Bankovní účty'; ".
+    "UPDATE `ISMenuItem` SET `Parent` = '".$Id."' WHERE `ISMenuItem`.`Id` ='Import z účtu';".
+    "UPDATE `ISMenuItem` SET `Parent` = '".$Id."' WHERE `ISMenuItem`.`Name` ='Banky';");
+}
+
+function UpdateTo505($Manager)
+{
+  $Manager->Execute("UPDATE `ISMenuItem` SET `Name` = 'Služby', `Table` = 'Service' WHERE `ISMenuItem`.`Name` ='Tarify';");
+  $Manager->Execute("INSERT INTO `ISMenuItem` (`Id` ,`Name` ,`Parent` ,`Table` ,`IconName`) ".
+      "VALUES (NULL , 'Kategorie služeb', '2', 'ServiceCategory', '');");
+  $Manager->Execute("CREATE TABLE IF NOT EXISTS `NetworkShareItem` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Name` varchar(255) NOT NULL DEFAULT '',
+  `Parent` int(11) NOT NULL DEFAULT '0',
+  `Host` int(11) NOT NULL DEFAULT '0',
+  `Size` bigint(20) NOT NULL DEFAULT '0',
+  `Ext` varchar(64) NOT NULL DEFAULT '',
+  `Date` date NOT NULL DEFAULT '0000-00-00',
+  `Type` int(11) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`Id`),
+  KEY `Parent` (`Parent`),
+  KEY `Search` (`Name`,`Size`),
+  KEY `Name` (`Name`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");
+  $Manager->Execute("CREATE TABLE IF NOT EXISTS `NetworkShareError` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Host` varchar(16) NOT NULL DEFAULT '',
+  `Message` varchar(255) NOT NULL DEFAULT '',
+  PRIMARY KEY (`Id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");
+  
 }
 
@@ -168 +196 @@
   499 => array('Revision' => 500, 'Function' => 'UpdateTo500'),
   500 => array('Revision' => 502, 'Function' => 'UpdateTo502'),
+  502 => array('Revision' => 505, 'Function' => 'UpdateTo505'),
 );