Ignore:
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:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/Common/Setup/Updates.php

    r765 r769  
    16331633        "VALUES (NULL , 'Zákazická podpora', ".$DbRow['Id'].", '".$ActionId."', '1');");
    16341634  }
     1635}
     1636
     1637function UpdateTo768($Manager)
     1638{
     1639  $Manager->Execute('ALTER TABLE `NetworkDomainAlias` ADD `Domain` INT NOT NULL AFTER `Comment`;');
     1640  $Manager->Execute('ALTER TABLE `NetworkDomainAlias` ADD KEY `Domain` (`Domain`);');
     1641  $Manager->Execute('UPDATE `NetworkDomainAlias` SET `Domain`=1');
     1642  $Manager->Execute('ALTER TABLE `NetworkDomainAlias` ADD FOREIGN KEY (`Domain`) REFERENCES `NetworkDomain`(`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT;');
     1643  $Manager->Execute('CREATE TABLE IF NOT EXISTS `NetworkAddressCategory` (
     1644  `Id` int(11) NOT NULL AUTO_INCREMENT,
     1645  `Name` varchar(255) NOT NULL,
     1646  PRIMARY KEY (`Id`)
     1647) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;');
     1648  $Manager->Execute('CREATE TABLE IF NOT EXISTS `NetworkDomainItemFilter` (
     1649  `Id` int(11) NOT NULL AUTO_INCREMENT,
     1650  `Name` varchar(255) NOT NULL,
     1651  `Domain` int(11) NOT NULL,
     1652  `AddressCategory` int(11) NOT NULL,
     1653  `Suffix` varchar(255) NOT NULL,
     1654  `View` int(11) NOT NULL,
     1655  `AddressRange` varchar(255) NOT NULL
     1656  PRIMARY KEY (`Id`),
     1657  KEY `Domain` (`Domain`),
     1658  KEY `View` (`View`)
     1659) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;');
     1660  $Manager->Execute('CREATE TABLE IF NOT EXISTS `NetworkDomainView` (
     1661  `Id` int(11) NOT NULL AUTO_INCREMENT,
     1662  `Domain` int(11) NOT NULL,
     1663  `AddressRange` varchar(255) NOT NULL,
     1664  `Name` varchar(255) NOT NULL,
     1665  `SysName` varchar(255) NOT NULL
     1666  PRIMARY KEY (`Id`),
     1667  KEY `Domain` (`Domain`)
     1668) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;');
     1669  $Manager->Execute('ALTER TABLE `NetworkDomainItemFilter`
     1670  ADD CONSTRAINT `NetworkDomainItemFilter_ibfk_1` FOREIGN KEY (`Domain`) REFERENCES `NetworkDomain` (`Id`);');
     1671  $Manager->Execute('ALTER TABLE `NetworkDomainItemFilter`
     1672  ADD FOREIGN KEY (`Domain`) REFERENCES `NetworkDomainView`(`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT;');
     1673  $Manager->Execute('ALTER TABLE `NetworkDomainView`
     1674  ADD FOREIGN KEY (`Domain`) REFERENCES `NetworkDomainView`(`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT;');
    16351675}
    16361676
     
    17131753      762 => array('Revision' => 763, 'Function' => 'UpdateTo763'),
    17141754      763 => array('Revision' => 765, 'Function' => 'UpdateTo765'),
     1755      765 => array('Revision' => 768, 'Function' => 'UpdateTo768'),
    17151756    ));
    17161757  }
Note: See TracChangeset for help on using the changeset viewer.