2.7

VMware, Inc. 55
Appendix: Database Schema and Audit Event Log Data
identityType INTEGER NOT NULL, /* AD User, Group, or Token Value */
identityName VARCHAR(128), /* UI visible user/group name in AD case */
accUseInstanceLimit VARCHAR(7)
DEFAULT 'FALSE' NOT NULL, /* Limit number of instances for this ID? */
accInstanceLimit INTEGER NOT NULL, /* Max no. of ACE instances allowed */
accTsCreated VARCHAR(21) DEFAULT 0 NOT NULL, /* Creation timestamp */
accTsLastModified VARCHAR(21) DEFAULT 0 NOT NULL, /* Last modified timestamp */
deleted VARCHAR(7) DEFAULT 'FALSE', /* Is this entry deleted (tombstone) */
PRIMARY KEY(accessPK),
FOREIGN KEY(aceUID) REFERENCES PolicyDb_Ace(aceUID));
/* ACE Instance object data */
CREATE TABLE PolicyDb_Instance (
instanceUID VARCHAR(128), /* VM instance ID (primary key) */
packageUID VARCHAR(128) NOT NULL, /* The package it belongs to. */
aceUID VARCHAR(128) DEFAULT '' NOT NULL, /* The ACE Master it belongs to */
creatorIdName VARCHAR(128) NOT NULL, /* Display name of the activator user */
creatorIdData VARCHAR(256), /* Fully qualified name of the activator */
creatorAuthType INTEGER NOT NULL, /* The type of access check at activation */
activationDate VARCHAR(21) NOT NULL, /* The date and time for the activation. */
lastPolicyCheck VARCHAR(21) NOT NULL, /* Last time when the player called server */
revocationDate VARCHAR(21) NOT NULL, /* When the instance was revoked */
replacementDate VARCHAR(21) NOT NULL, /* When replaced because of Copy Protect. */
/* policy */
inheritsExpiration
VARCHAR(7) DEFAULT 'FALSE' NOT NULL, /* Use expiration info from Policy Set */
insUseValidDates
VARCHAR(7) DEFAULT 'FALSE' NOT NULL, /* Use validity dates or always valid */
insValidDateStart VARCHAR(21) NOT NULL, /* The instance is valid from this date*/
insValidDateEnd VARCHAR(21) NOT NULL, /* The instance is valid till this date*/
insPassword VARCHAR(128), /* The login password for non-AD */
/* authentication for this instance */
hostName VARCHAR(128), /* The name of the host PC the VM runs on */
hostIp VARCHAR(128), /* The IP addr of the host the VM runs on */
insProtectionKey VARCHAR(1024), /* Instance VM disk encryption key */
copyProtectionId VARCHAR(1024), /* Stores location of the copy */
insPreview VARCHAR(7) DEFAULT 'FALSE' NOT NULL, /* Is preview instance */
guestIpAddress VARCHAR(128) DEFAULT '', /* Reported VM IP address */
guestMacAddress VARCHAR(128) DEFAULT '', /* Assigned VM MAC address */
guestMachineName VARCHAR(128) DEFAULT '', /* The guest (VM) OS host name */
guestConfigStatus INTEGER DEFAULT 0, /* The completion status of guest */
/* auto-configuration */
guestConfigMsg VARCHAR(512), /* Message for the guest auto-config */
insTsCreated VARCHAR(21) DEFAULT 0 NOT NULL, /* Creation timestamp */
insTsLastModified VARCHAR(21) DEFAULT 0 NOT NULL, /* Last modified timestamp */
deleted VARCHAR(7) DEFAULT 'FALSE', /* Is this entry deleted (tombstone) */
insCustom1 VARCHAR(255), /* User-defined field */
insCustom2 VARCHAR(255), /* User-defined field */
insCustom3 VARCHAR(255), /* User-defined field */
insCustom4 VARCHAR(255), /* User-defined field */
insCustom5 VARCHAR(255), /* User-defined field */
insCustom6 VARCHAR(255), /* User-defined field */
insCustom7 VARCHAR(255), /* User-defined field */
insCustom8 VARCHAR(255), /* User-defined field */
insCustom9 VARCHAR(255), /* User-defined field */
PRIMARY KEY(instanceUID),
FOREIGN KEY(packageUID) REFERENCES PolicyDb_Package(packageUID),
FOREIGN KEY(aceUID) REFERENCES PolicyDb_Ace(aceUID));
/* MAC Address Pool (reserved for future use) */
CREATE TABLE PolicyDb_MacPool (
macPoolUID VARCHAR(128), /* primary key */
aceUID VARCHAR(128) NOT NULL, /* ACE for which this MacPool is used */
macPoolName VARCHAR(128), /* User visible name */
description VARCHAR(128), /* name and description of the MAC pool*/
rangeStart VARCHAR(21) NOT NULL, /* Start address of the MAC pool */
rangeEnd VARCHAR(21) NOT NULL, /* End address of the MAC pool */
lastAssigned VARCHAR(21) NOT NULL, /* Last assigned address */