2.5

VMware, Inc. 77
Appendix: Database Schema and Audit Event Log Data
/* ACE Master data */
CREATE TABLE PolicyDb_Ace (
aceUID VARCHAR(128), /* Unique ID (primary key) */
aceName VARCHAR(128), /* Name of this ace */
activePolicySetVersion INTEGER NOT NULL, /* Soft foreign key to active RT policy*/
aceTsCreated VARCHAR(21) DEFAULT 0 NOT NULL, /* Creation timestamp */
aceTsLastModified VARCHAR(21) DEFAULT 0 NOT NULL, /* Last modified timestamp */
deleted VARCHAR(7) DEFAULT 'FALSE', /* Is this entry deleted (tombstone) */
PRIMARY KEY(aceUID));
/* Package data */
CREATE TABLE PolicyDb_Package (
packageUID VARCHAR(128), /* Unique ID (primary key) */
aceUID VARCHAR(128) NOT NULL, /* The ACE it belongs to. */
pkgName VARCHAR(128), /* UI visible name. */
pkgUseValidDates VARCHAR(7)
DEFAULT 'FALSE' NOT NULL, /* Use validity dates or always valid */
pkgValidDateStart VARCHAR(21) NOT NULL, /* The package is valid from this date.*/
pkgValidDateEnd VARCHAR(21) NOT NULL, /* The package is valid till this date.*/
pkgDisabled VARCHAR(7) DEFAULT 'FALSE' NOT NULL, /* Is the package disabled */
pkgProtectionKey VARCHAR(1024), /* The key used for package distribution */
pkgPreview VARCHAR(7) DEFAULT 'FALSE' NOT NULL, /* Is preview package */
pkgTsCreated VARCHAR(21) DEFAULT 0 NOT NULL, /* Creation timestamp */
pkgTsLastModified VARCHAR(21) DEFAULT 0 NOT NULL, /* Last modified timestamp */
deleted VARCHAR(7) DEFAULT 'FALSE', /* Is this entry deleted (tombstone) */
PRIMARY KEY(packageUID),
FOREIGN KEY(aceUID) REFERENCES PolicyDb_Ace(aceUID));
/* Access Control object data (single item of the list, associated with ACE Master)*/
CREATE TABLE PolicyDb_Access (
accessPK VARCHAR(128), /* Unique ID (primary key) */
aceUID VARCHAR(128), /* Ace for which this access policy is (FK)*/
identityData VARCHAR(128), /* Internal representation, SID in AD */
/* case, token value goes here. */
accVersion INTEGER NOT NULL, /* Access object version number */
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) */