VI-DB vi-db-update-v1.2
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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));