VI-DB vi-db-update-v2.0: Difference between revisions

From vwiki
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;