VI-DB vi-db-update-v2.7

From vwiki
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
ALTER TABLE vm2ip DROP PRIMARY KEY;
DELETE FROM vm2ip WHERE ISNULL(ip);
ALTER TABLE vm2ip ADD PRIMARY KEY (vmid, vnicid, ip);