2.0

Table Of Contents
VMware ACE Administrator’s Manual
260 VMware, Inc.
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 */
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) */