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

Sstrutt: Updated category

2014-03-16T22:13:29Z

Updated category

← Older revision		Revision as of 22:13, 16 March 2014
Line 9:		Line 9:
	</source>		</source>

	[[Category:MySQL]]		[[Category:MySQL Examples]]

Sstrutt: Missed vm_ext change

2011-06-22T09:15:09Z

Missed vm_ext change

← Older revision		Revision as of 09:15, 22 June 2011
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]]

Sstrutt: Initial creation

2011-06-22T09:06:42Z

Initial creation

New page

<source lang="mysql">
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;
</source>

[[Category:MySQL]]