VI-DB vi-db-update-v2.0: Difference between revisions
Jump to navigation
Jump to search
(Missed vm_ext change) |
(Updated category) |
||
| Line 9: | Line 9: | ||
</source> | </source> | ||
[[Category:MySQL]] | [[Category:MySQL Examples]] | ||
Latest revision as of 22:13, 16 March 2014
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;