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

From vwiki
Revision as of 22:13, 16 March 2014 by Sstrutt (talk | contribs) (Updated category)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
ALTER TABLE vm2ip DROP PRIMARY KEY;
DELETE FROM vm2ip WHERE ISNULL(ip);
ALTER TABLE vm2ip ADD PRIMARY KEY (vmid, vnicid, ip);