2.5

VMware, Inc. 79
Appendix: Database Schema and Audit Event Log Data
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 */
mplTsCreated VARCHAR(21) DEFAULT 0 NOT NULL, /* Creation timestamp */
mplTsLastModified VARCHAR(21) DEFAULT 0 NOT NULL, /* Last modified timestamp */
deleted VARCHAR(7) DEFAULT 'FALSE', /* Is this entry deleted (tombstone) */
PRIMARY KEY(macPoolUID),
FOREIGN KEY(aceUID) REFERENCES PolicyDb_Ace(aceUID));
/* Instance customization data */
CREATE TABLE PolicyDb_UserData (
userDataPK VARCHAR(516), /* Primary key */
aceUID VARCHAR(128), /* ACE for which this UserData is defined */
packageUID VARCHAR(128), /* Package for which this UserData is used */
activator VARCHAR(128), /* The user */
udataName VARCHAR(128), /* User data entry name */
udataType INTEGER NOT NULL, /* Attribute of the date */
udataValue VARCHAR(2048), /* User data entry value */
udtTsCreated VARCHAR(21) DEFAULT 0 NOT NULL, /* Creation timestamp */
udtTsLastModified VARCHAR(21) DEFAULT 0 NOT NULL, /* Last modified timestamp */
deleted VARCHAR(7) DEFAULT 'FALSE', /* Is this entry deleted (tombstone) */
FOREIGN KEY(aceUID) REFERENCES PolicyDb_Ace(aceUID),
FOREIGN KEY(packageUID) REFERENCES PolicyDb_Package(packageUID),
PRIMARY KEY(userDataPK));
/* ACE Master policy set */
CREATE TABLE PolicyDb_RuntimePolicy (
aceUID VARCHAR(128), /* The ACE it belongs to. */
policyVersion INTEGER, /* Version of the RT Policy for this ACE */
clientPolicyData VARCHAR(2000), /* Runtime policy for the guest OS */
clientPolicyDataExtKey VARCHAR(128), /* If too long store in LongField table */
hostPolicyData VARCHAR(2000), /* Runtime policy for the host OS (NQ) */
hostPolicyDataExtKey VARCHAR(128), /* If too long store in LongField table */
expirationType INTEGER NOT NULL, /* Expiration Type (enum) */
expValue_1 VARCHAR(21) NOT NULL, /* Expiration value (depends on type) */
expValue_2 VARCHAR(21) NOT NULL, /* Expiration value (depends on type) */
cacheLifetime VARCHAR(21) NOT NULL, /* How long could work without server */
rtpInstType INTEGER NOT NULL, /* Instantiation authentication check type */
rtpAuthType INTEGER NOT NULL, /* Runtime authentication check type */
rtpUseInstanceLimit VARCHAR(7)
DEFAULT 'FALSE' NOT NULL, /* Limit number of instances for this ACE? */
rtpInstanceLimit INTEGER NOT NULL, /* Max no. of ACE instances allowed */
rtpUsePerUserInstanceLimit VARCHAR(7)
DEFAULT 'FALSE' NOT NULL, /* Limit number of instances per user? */
rtpPerUserInstanceLimit INTEGER NOT NULL, /* Max no. of ACE instances per user */
copyPolicy INTEGER DEFAULT 0 NOT NULL, /* Behavior if VM instance is copied */
published VARCHAR(7) DEFAULT 'FALSE' NOT NULL,/* Policy published (update locked)*/
rtpTsCreated VARCHAR(21) DEFAULT 0 NOT NULL, /* Creation timestamp */
rtpTsLastModified VARCHAR(21) DEFAULT 0 NOT NULL, /* Last modified timestamp */