2.0

VMware ACE Administrator’s Manual
258 VMware, Inc.
ThefollowingistheDatabaseSchemascript.
/* Name – value pairs of service information, e.g. DB schema version number */
CREATE TABLE PolicyDb_MetaInfo (
name VARCHAR(128), /* Name of the name-value pair */
value VARCHAR(1024), /* Value of the name-value pair */
PRIMARY KEY(name));
/* This table holds data for guest and host policy sets, split in 2K chunks */
/* Select all fields for the key in the order of index and append strings together */
/* to reconstruct the policy set */
CREATE TABLE PolicyDb_LongField (
longFieldKey VARCHAR(128), /* Unique ID of the long field series */
longFieldIndex INTEGER, /* Index in the series */
longFieldValue VARCHAR(2000), /* Up to 2000 chars of field value chunk */
sessionExpires VARCHAR(21), /* Optional field for storing session blob */
PRIMARY KEY (longFieldKey, longFieldIndex));
/* 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)*/