VI-DB vi-db-update-v2.9
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 vmdk ADD COLUMN used INT UNSIGNED AFTER size, ADD COLUMN rdm BOOL AFTER thin;
CREATE TABLE vm_res (vmid INT UNSIGNED, cpu_resrv MEDIUMINT, cpu_limit MEDIUMINT, cpu_level VARCHAR(16), cpu_shares SMALLINT UNSIGNED, mem_resrv MEDIUMINT, mem_limit MEDIUMINT,
mem_level VARCHAR(16), mem_shares SMALLINT UNSIGNED, stamp TIMESTAMP DEFAULT current_timestamp ON UPDATE current_timestamp, PRIMARY KEY (vmid));
ALTER TABLE nw DROP KEY vcid;
ALTER TABLE nw ADD UNIQUE KEY (name, vcid, is_dv);
ALTER TABLE nw ADD COLUMN vkey VARCHAR(64) AFTER name;
ALTER TABLE nw ADD UNIQUE KEY (vkey, vcid);