0.19.2
bugfix: port linking was broken for some users due to open PDO cursor
bugfix: Permissions code editor was broken with Google Chrome
+ update: new DB table indexes speeding up IP tree operations
0.19.1 2011-02-22
update: UI: rack lists are now reduced by common tags with object on Rackspace tab (FILTER_RACKLIST_BY_TAGS config var)
update: 802.1q: If switch has IP interface in some VLAN linked to IP subnet, this VLAN is not pruned from switch's uplink
`name` char(255) NOT NULL default '',
`type` enum('regular','shared','virtual','router') default NULL,
PRIMARY KEY (`object_id`,`ip`),
+ KEY `ip` (`ip`),
CONSTRAINT `IPv4Allocation-FK-object_id` FOREIGN KEY (`object_id`) REFERENCES `RackObject` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB;
`rspool_id` int(10) unsigned default NULL,
`rsconfig` text,
PRIMARY KEY (`id`),
+ KEY `rsip` (`rsip`),
UNIQUE KEY `pool-endpoint` (`rspool_id`,`rsip`,`rsport`),
CONSTRAINT `IPv4RS-FK` FOREIGN KEY (`rspool_id`) REFERENCES `IPv4RSPool` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB;
`name` char(255) default NULL,
`vsconfig` text,
`rsconfig` text,
- PRIMARY KEY (`id`)
+ PRIMARY KEY (`id`),
+ KEY `vip` (`vip`)
) ENGINE=InnoDB;
CREATE TABLE `IPv6Address` (
`name` char(255) NOT NULL default '',
`type` enum('regular','shared','virtual','router') default NULL,
PRIMARY KEY (`object_id`,`ip`),
+ KEY `ip` (`ip`),
CONSTRAINT `IPv6Allocation-FK-object_id` FOREIGN KEY (`object_id`) REFERENCES `RackObject` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB;
}
$query[] = "UPDATE Config SET varvalue = '0.19.1' WHERE varname = 'DB_VERSION'";
break;
+ case '0.19.2':
+ $query = array_merge ($query, reloadDictionary ($batchid));
+ $query[] = "ALTER TABLE IPv4Allocation ADD KEY `ip` (`ip`)";
+ $query[] = "ALTER TABLE IPv6Allocation ADD KEY `ip` (`ip`)";
+ $query[] = "ALTER TABLE IPv4VS ADD KEY `vip` (`vip`)";
+ $query[] = "ALTER TABLE IPv4RS ADD KEY `rsip` (`rsip`)";
+ $query[] = "UPDATE Config SET varvalue = '0.19.1' WHERE varname = 'DB_VERSION'";
+ break;
default:
showError ("executeUpgradeBatch () failed, because batch '${batchid}' isn't defined");
die;