VI-DB vi-db-update-v2.7
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);
ALTER TABLE vm2ip DROP PRIMARY KEY;
DELETE FROM vm2ip WHERE ISNULL(ip);
ALTER TABLE vm2ip ADD PRIMARY KEY (vmid, vnicid, ip);