VI-DB vi-db-update-v1.2

From vWiki
Jump to navigation Jump to search
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));