VI-DB vi-db-update-v2.4
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.
CREATE TABLE vm_attrib (vmid INT UNSIGNED, name VARCHAR(256), data VARCHAR(1024), stamp TIMESTAMP DEFAULT current_timestamp ON UPDATE current_timestamp,
PRIMARY KEY (vmid, name));
CREATE TABLE vapp (vappid TINYINT UNSIGNED AUTO_INCREMENT, vcid TINYINT UNSIGNED, vappvcid SMALLINT UNSIGNED, name VARCHAR(32), vc_path VARCHAR(512), status VARCHAR(16), exist BOOL, clid TINYINT UNSIGNED, prod_name VARCHAR(256), prod_ver VARCHAR(16), prod_fver VARCHAR(128), prod_vend VARCHAR(128), stamp TIMESTAMP DEFAULT current_timestamp ON UPDATE current_timestamp, PRIMARY KEY (vappid), UNIQUE KEY (vcid, name));
CREATE TABLE vapp_vm (vappid TINYINT UNSIGNED, vmid INT UNSIGNED, vmvcid SMALLINT UNSIGNED, ord TINYINT UNSIGNED, start_dly TINYINT UNSIGNED, start_wait BOOL, stop_dly TINYINT UNSIGNED, stop_act VARCHAR(16), stamp TIMESTAMP DEFAULT current_timestamp ON UPDATE current_timestamp, PRIMARY KEY (vappid, vmid));
ALTER TABLE vm ADD COLUMN vappid TINYINT UNSIGNED AFTER esxid;