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

From vWiki
Jump to navigation Jump to search
ALTER TABLE script_run MODIFY COLUMN version VARCHAR(16);

CREATE TABLE script_run_error (errid INT UNSIGNED AUTO_INCREMENT, runid INT UNSIGNED, vcid TINYINT UNSIGNED, sev TINYINT UNSIGNED, text VARCHAR(256), stamp TIMESTAMP DEFAULT current_timestamp ON UPDATE current_timestamp, PRIMARY KEY (errid));

ALTER TABLE nw ADD COLUMN is_dv BOOL AFTER vlan, ADD COLUMN is_ft BOOL AFTER vlan, ADD COLUMN is_vmk BOOL AFTER vlan, ADD COLUMN is_mgmt BOOL AFTER vlan;

ALTER TABLE vm_ext ADD COLUMN vapp VARCHAR(64) AFTER mem;