Difference between revisions of "VI-DB vi-db-update-v2.9"
Jump to navigation
Jump to search
(Initial creation) |
(No difference)
|
Revision as of 09:13, 19 December 2011
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);