2.5

ACE Management Server Administrator’s Manual
80 VMware, Inc.
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));
/* Audit Event Log data */
CREATE TABLE PolicyDb_Event (
eventUID INTEGER, /* Primary key of the table (sequential) */
eventTs VARCHAR(21), /* Timestamp of the event creation in uSec */
loginName VARCHAR(128), /* Login user name of the actor */
aceUID VARCHAR(128), /* UID of the ACE affected by event */
packageUID VARCHAR(128), /* UID of the package affected by event */
instanceUID VARCHAR(128), /* UID of the instance affected by event */
policyVersion INTEGER, /* Version of ACE policy affected by event */
eventCategory INTEGER, /* Event Category as defined in EventType */
eventType INTEGER, /* Event Type as defined in EventType */
sessionID VARCHAR(128), /* Ace Server Session ID */
clientIP VARCHAR(128), /* IP Address of the client machine (resvd) */
serverIP VARCHAR(128), /* IP Address of the Ace Server (reserved) */
turnaroundTime VARCHAR(21), /* Server-side execution time in ms */
handlerName VARCHAR(128), /* Name of the ClientLib handler (debug) */
returnCodeText VARCHAR(128), /* Text error code returned to the client */
messageParams VARCHAR(1024), /* Tab separated list of event data */
prevEventUID INTEGER UNIQUE, /* UID of the previous recorded event */
eventSignature VARCHAR(128), /* Event signature, signed with server key */
FOREIGN KEY(eventType) REFERENCES PolicyDb_EventType(eventType),
FOREIGN KEY(prevEventUID) REFERENCES PolicyDb_Event(eventUID),
PRIMARY KEY (eventUID));