Difference between revisions of "VI-DB vi-db-update-v2.0"
Jump to navigation
Jump to search
(Initial creation) |
(Updated category) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 5: | Line 5: | ||
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 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; | |||
</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;