r4262 update: new indexes speeding up scanIPv[46]Space functions.
[racktables] / wwwroot / upgrade.php
index ffd8d0bc7bb8a3751016dcbed2dc16402f8d1830..4e89480d522490a1edf27c20194a14603b3978cb 100644 (file)
@@ -1000,6 +1000,14 @@ CREATE TABLE `EntityLink` (
                        }
                        $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;