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

Timestamp:

May 23, 2015, 12:07:08 AM (10 years ago)

Author:

chronos

Message:

• Added: NetworkDomainServer table to configure DNS servers for domains.

File:

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

trunk/Common/Setup/Updates.php

@@ -1343 +1343 @@
   $Manager->Execute('ALTER TABLE `NetworkLinkType`
 MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;');
+}
+
+function UpdateTo739($Manager)
+{
+  $Manager->Execute('ALTER TABLE `NetworkDomain` ADD KEY (`Parent`);');
+  $Manager->Execute('ALTER TABLE `NetworkDomain` ADD FOREIGN KEY (`Parent`) REFERENCES `NetworkDomain`(`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT;');
+
+  $Manager->Execute('CREATE TABLE IF NOT EXISTS `NetworkDomainServer` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Address` varchar(255) NOT NULL,
+  `Domain` int(11) NOT NULL,
+  `Sequence` int(11) NOT NULL
+) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;');
+
+  $Manager->Execute('ALTER TABLE `NetworkDomainServer`
+ ADD PRIMARY KEY (`Id`), ADD KEY `Domain` (`Domain`);');
+
+  $Manager->Execute('ALTER TABLE `NetworkDomainServer`
+ADD CONSTRAINT `NetworkDomainServer_ibfk_1` FOREIGN KEY (`Domain`) REFERENCES `NetworkDomain` (`Id`);');
+
 }
 
@@ -1411 +1431 @@
       731 => array('Revision' => 735, 'Function' => 'UpdateTo735'),
       735 => array('Revision' => 736, 'Function' => 'UpdateTo736'),
+      736 => array('Revision' => 739, 'Function' => 'UpdateTo739'),
     ));
   }