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

From vwiki
Revision as of 09:13, 19 December 2011 by Sstrutt (talk | contribs) (Initial creation)
(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);