VI-DB vi-db-update-v1.2: Difference between revisions
Jump to navigation
Jump to search
(Initial creation) |
(Updated category) |
||
| Line 12: | Line 12: | ||
</source> | </source> | ||
[[Category:MySQL]] | [[Category:MySQL Examples]] | ||
Latest revision as of 22:13, 16 March 2014
ALTER TABLE snap ADD COLUMN vrange BOOL AFTER vm_on;
CREATE TABLE esx_ext (esxid SMALLINT UNSIGNED, ip INT UNSIGNED, domain VARCHAR(32), dns_svr1 INT UNSIGNED, dns_svr2 INT UNSIGNED, syslog VARCHAR(32), bios_ver VARCHAR(32), stamp TIMESTAMP DEFAULT current_timestamp ON UPDATE current_timestamp, PRIMARY KEY (esxid));
CREATE TABLE esx_ntp (esxid SMALLINT UNSIGNED, idx TINYINT UNSIGNED, svr VARCHAR(32), stamp TIMESTAMP DEFAULT current_timestamp ON UPDATE current_timestamp, PRIMARY KEY (esxid, idx));
CREATE TABLE esx_hba (esxid SMALLINT UNSIGNED, device VARCHAR(7), model VARCHAR(128), driver VARCHAR(32), drv_ver VARCHAR(32), stamp TIMESTAMP DEFAULT current_timestamp ON UPDATE current_timestamp, PRIMARY KEY (esxid, device));
CREATE TABLE esx_nic (esxid SMALLINT UNSIGNED, device VARCHAR(7), speed SMALLINT UNSIGNED, model VARCHAR(128), driver VARCHAR(32), drv_ver VARCHAR(32), stamp TIMESTAMP DEFAULT current_timestamp ON UPDATE current_timestamp, PRIMARY KEY (esxid, device));