VI-DB vi-db-update-v2.0
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 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;