2.7

ACE Management Server Administrator’s Manual
56 VMware, Inc.
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 */
deleted VARCHAR(7) DEFAULT 'FALSE', /* Is this entry deleted (tombstone) */
PRIMARY KEY (aceUID, policyVersion),
FOREIGN KEY(aceUID) REFERENCES PolicyDb_Ace(aceUID));
/* ACE Management Server info - reserved for future use */
CREATE TABLE PolicyDb_AcescServer (
serverHostname VARCHAR(128), /* Host name of the server computer */
serverPort INTEGER, /* TCP port number server is listening on */
secure VARCHAR(7) DEFAULT 'FALSE' NOT NULL, /* Whether HTTPS is enabled */
sslCertificateExtKey VARCHAR(128), /* SSL Certificate data, key to stored */
/* in LongField table */
sslCertificateChainExtKey VARCHAR(128), /* SSL Certificate Chain data, key to */
/* stored in LongField table */
PRIMARY KEY (serverHostname, serverPort));
/* Audit Event Log Event Types lookup table */
CREATE TABLE PolicyDb_EventType (
eventType INTEGER, /* Event Type code (PK) */
eventMessage VARCHAR(1024), /* Printable message for this event type */
eventCategory INTEGER, /* Event Category code */
eventCategoryName VARCHAR(128), /* Event Category printable name */
eventLogLevel INTEGER, /* Event Log Level */
PRIMARY KEY (eventType));