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

Timestamp:

Jan 2, 2016, 11:18:17 AM (9 years ago)

Author:

chronos

Message:

• Fixed: Wrong SQL query concatenation in IS module.
• Fixed: Update code was wrongly commented out.

File:

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

trunk/Common/Setup/Updates.php

@@ -1637 +1637 @@
 function UpdateTo768($Manager)
 {
-/*  $Manager->Execute('ALTER TABLE `NetworkDomainAlias` ADD `Domain` INT NOT NULL AFTER `Comment`;');
+  $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');
@@ -1667 +1667 @@
   KEY `Domain` (`Domain`)
 ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;');
-*/
-        $Manager->Execute('ALTER TABLE `NetworkDomainItemFilter`
+  $Manager->Execute('ALTER TABLE `NetworkDomainItemFilter`
   ADD FOREIGN KEY (`Domain`) REFERENCES `NetworkDomain` (`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT;');
   $Manager->Execute('ALTER TABLE `NetworkDomainItemFilter`