Changeset 731 for trunk/Common/Setup/Updates.php

Timestamp:

Jan 17, 2015, 9:24:47 PM (10 years ago)

Author:

chronos

Message:

• Added: NetworkDomain table for managing multiple network domains. It is not completed and linked to real functionality yet.
• Added: ModuleLinks and Model tables as preparation for better modules and models in-database representation.

File:

• trunk/Common/Setup/Updates.php (modified) (2 diffs)

trunk/Common/Setup/Updates.php

@@ -1222 +1222 @@
   $Manager->Execute('ALTER TABLE `Scheduler` ADD CONSTRAINT `Schedule_ibfk_2` FOREIGN KEY (`Action`) REFERENCES `SchedulerAction` (`Id`);');
   $Manager->Execute('INSERT INTO `SchedulerAction` (`Id`, `Name`, `Class`) VALUES (NULL, "Import bankovních účtů", "ScheduleBankImport");');  
+}
+
+function UpdateTo731($Manager)
+{
+        // NetworkDomain
+        $Manager->Execute('CREATE TABLE IF NOT EXISTS `NetworkDomain` (
+`Id` int(11) NOT NULL,
+`Name` varchar(255) NOT NULL,
+`Parent` int(11) DEFAULT NULL,
+`Serial` int(11) NOT NULL,
+`Refresh` int(11) NOT NULL,
+`Expire` int(11) NOT NULL,
+`Retry` int(11) NOT NULL,
+`Minimum` int(11) NOT NULL,
+`TTL` int(11) NOT NULL,
+`Description` varchar(255) NOT NULL
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;');
+
+  $Manager->Execute('ALTER TABLE `NetworkDomain` ADD PRIMARY KEY (`Id`);');
+
+  $Manager->Execute('ALTER TABLE `NetworkDomain`
+  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;');
+
+  $Manager->Execute('INSERT INTO `Action` (`Id` ,`Name` ,`Title` ,`Type` ,`URL` ,
+`Group` ,`Icon` ,`PermissionOperation` ,`Enable`) VALUES (
+NULL , "", "Síťová doména", "1", "/is/?t=NetworkDomain&a=list", NULL , NULL , NULL , "1");');
+  $ActionId = $Manager->Database->insert_id;
+  $DbResult = $Manager->Execute('SELECT `Id` FROM `MenuItem` WHERE `Name`="Síť"');
+  if($DbResult->num_rows > 0)
+  {
+        $DbRow = $DbResult->fetch_assoc();
+        $Manager->Execute("INSERT INTO `MenuItem` (`Id` ,`Name` ,`Parent` ,`Action` ,`Menu`) ".
+                "VALUES (NULL , 'Síťová doména', ".$DbRow['Id'].", '".$ActionId."', '1');");
+  }  
+        
+        // Model additions
+        $Manager->Execute('ALTER TABLE `Model` ADD `Title` VARCHAR(255) NOT NULL , '.
+                'ADD `Query` VARCHAR(255) NOT NULL , '.
+                'ADD `DefaultSortColumn` VARCHAR(255) NOT NULL , '.
+                'ADD `DefaultSortOrder` INT NOT NULL ;');
+        
+        // ModelField
+        $Manager->Execute('CREATE TABLE IF NOT EXISTS `ModelField` (
+        `Id` int(11) NOT NULL,
+        `Name` varchar(255) NOT NULL,
+        `Model` int(11) NOT NULL,
+        `Query` varchar(255) NOT NULL,
+        `Type` varchar(255) NOT NULL,
+        `Title` varchar(255) NOT NULL,
+        `DefaultValue` varchar(255) NOT NULL,
+        `IsNull` int(11) NOT NULL,
+        `Suffix` varchar(255) NOT NULL
+        ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;');
+        
+        $Manager->Execute('ALTER TABLE `ModelField`
+        ADD PRIMARY KEY (`Id`), ADD KEY `Model` (`Model`);');
+        
+        $Manager->Execute('ALTER TABLE `ModelField`
+        MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;');
+        
+        $Manager->Execute('ALTER TABLE `ModelField`
+        ADD CONSTRAINT `ModelField_ibfk_1` FOREIGN KEY (`Model`) REFERENCES `Model` (`Id`);');
+        
+        // Module additions
+        $Manager->Execute('ALTER TABLE `Module` ADD `Version` VARCHAR(255) NOT NULL , '.
+                'ADD `Creator` VARCHAR(255) NOT NULL , '.
+                'ADD `License` VARCHAR(255) NOT NULL , '.
+                'ADD `Installed` INT NOT NULL , '.
+                'ADD `HomePage` VARCHAR(255) NOT NULL , '.
+                'ADD `Description` TEXT NOT NULL ;');
+        
+        // ModuleLink
+        $Manager->Execute('CREATE TABLE IF NOT EXISTS `ModuleLink` (
+`Id` int(11) NOT NULL,
+  `Module` int(11) NOT NULL,
+  `LinkedModule` int(11) NOT NULL,
+  `Type` int(11) NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;');
+
+  $Manager->Execute('ALTER TABLE `ModuleLink`
+ ADD PRIMARY KEY (`Id`), ADD KEY `Module` (`Module`), ADD KEY `LinkedModule` (`LinkedModule`);');
+
+  $Manager->Execute('ALTER TABLE `ModuleLink`
+        MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;');
 }
 
@@ -1287 +1371 @@
         726 => array('Revision' => 729, 'Function' => 'UpdateTo729'),
         729 => array('Revision' => 730, 'Function' => 'UpdateTo730'),
+        730 => array('Revision' => 731, 'Function' => 'UpdateTo731'),
     ));
   }