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

Timestamp:

Nov 24, 2015, 9:56:00 PM (9 years ago)

Author:

chronos

Message:

• Added: More DNS related tables to replace fixed DNS configuration.
• Modified: All icons should now have transparency. This is useful if user have set dark backround in its browser.

File:

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

trunk/Common/Setup/Updates.php

@@ -1633 +1633 @@
         "VALUES (NULL , 'Zákazická podpora', ".$DbRow['Id'].", '".$ActionId."', '1');");
   }
+}
+
+function UpdateTo768($Manager)
+{
+  $Manager->Execute('ALTER TABLE `NetworkDomainAlias` ADD `Domain` INT NOT NULL AFTER `Comment`;');
+  $Manager->Execute('ALTER TABLE `NetworkDomainAlias` ADD KEY `Domain` (`Domain`);');
+  $Manager->Execute('UPDATE `NetworkDomainAlias` SET `Domain`=1');
+  $Manager->Execute('ALTER TABLE `NetworkDomainAlias` ADD FOREIGN KEY (`Domain`) REFERENCES `NetworkDomain`(`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT;');
+  $Manager->Execute('CREATE TABLE IF NOT EXISTS `NetworkAddressCategory` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Name` varchar(255) NOT NULL,
+  PRIMARY KEY (`Id`)
+) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;');
+  $Manager->Execute('CREATE TABLE IF NOT EXISTS `NetworkDomainItemFilter` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Name` varchar(255) NOT NULL,
+  `Domain` int(11) NOT NULL,
+  `AddressCategory` int(11) NOT NULL,
+  `Suffix` varchar(255) NOT NULL,
+  `View` int(11) NOT NULL,
+  `AddressRange` varchar(255) NOT NULL
+  PRIMARY KEY (`Id`),
+  KEY `Domain` (`Domain`),
+  KEY `View` (`View`)
+) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;');
+  $Manager->Execute('CREATE TABLE IF NOT EXISTS `NetworkDomainView` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Domain` int(11) NOT NULL,
+  `AddressRange` varchar(255) NOT NULL,
+  `Name` varchar(255) NOT NULL,
+  `SysName` varchar(255) NOT NULL
+  PRIMARY KEY (`Id`),
+  KEY `Domain` (`Domain`)
+) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;');
+  $Manager->Execute('ALTER TABLE `NetworkDomainItemFilter`
+  ADD CONSTRAINT `NetworkDomainItemFilter_ibfk_1` FOREIGN KEY (`Domain`) REFERENCES `NetworkDomain` (`Id`);');
+  $Manager->Execute('ALTER TABLE `NetworkDomainItemFilter`
+  ADD FOREIGN KEY (`Domain`) REFERENCES `NetworkDomainView`(`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT;');
+  $Manager->Execute('ALTER TABLE `NetworkDomainView`
+  ADD FOREIGN KEY (`Domain`) REFERENCES `NetworkDomainView`(`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT;');
 }
 
@@ -1713 +1753 @@
       762 => array('Revision' => 763, 'Function' => 'UpdateTo763'),
       763 => array('Revision' => 765, 'Function' => 'UpdateTo765'),
+      765 => array('Revision' => 768, 'Function' => 'UpdateTo768'),
     ));
   }