Helix Server Schema Documentation

Release: 2019.2

Contents

Alphabetical List of Tables

FilenameLock OrderVers.Description
db.bodresolve870 Resolve data for stream specifications
db.bodtext881 Job data for job attributes
db.bodtextcx890 Versioned openable spec fields
db.bodtexthx900 Head revision of spec fields
db.bodtextsx910 Shelved openable spec fields
db.bodtextwx920 Open openable spec fields
db.change706 Changelists
db.changeidx721 Secondary index of db.change/db.changex
db.changex716 Subset of db.change - records for pending changelists only
db.config11 Server configurations table
db.configh20 Server configuration history
db.counters31 Counters table
db.depot201Depot specifications
db.desc730 Change descriptions
db.domain227 Domains: depots, clients, labels, branches, streams, and typemap
db.excl651Exclusively locked (+l) files - enables coordinated file locking in commit/edge server environments
db.exclg660Graph depot LFS locks
db.exclgx670Graph depot LFS locks indexed by lockId
db.fix851 Fix records - indexed by job
db.fixrev861 Fix records - indexed by change
db.graphindex781 Graph depot repository index data
db.graphperm790 Graph depot permissions
db.group189Group specifications
db.groupx191Per-group data to support group membership controlled by AD/LDAP group membership
db.have343 Contains the 'have-list' for all clients
db.have.pt333 Placeholder for read-only clients
db.have.rp323 Contains the 'have-list' for clients of build-server replicas
db.haveg640 Contains the 'have-list' for graph depot files that are not at the same revision as defined by the client's have reference.
db.haveview291 Stores mapping changes for clients mapping graph depot content
db.integed360 Permanent integration records
db.integtx370 Temporary integration records used by task streams
db.ixtext940 Indexing data for generic and job attributes
db.ixtexthx950 Indexing data for head revision of all spec fields
db.jnlack1021 Tracks journal positions of all replicas
db.job820 Job records
db.label310 Revisions of files in labels
db.ldap80 LDAP specifications
db.locks592Locked/Unlocked files
db.locksg602Lock records for clients of type graph
db.logger70 Support for 'p4 logger' command. Logs any changes to changelists and jobs
db.message990 System messages
db.monitor1032 Helix Server process information
db.nameval41 A table to store key/value pairs
db.object770 Object storage for graph depots
db.property980 Properties
db.protect975 The protections table
db.pubkey810 SSH Public keys
db.ref760Reference content for graph depots
db.refhist750 Reference history for graph depots
db.remote111 Remote specifications
db.repo743 Repository specifications
db.resolve381 Pending integration records
db.resolveg400 Resolve records for clients of type graph
db.resolvex391 Pending integration records for shelved files
db.rev569 Revision records
db.revbx539 Revision records for archived files
db.revcx550 Secondary index of db.rev
db.revdx489 Revision records for revisions deleted at the head revision
db.revhx499 Revision records for revisions NOT deleted at the head revision
db.review301 User's review mappings
db.revpx509 Pending revision records
db.revsh529 Revision records for shelved files
db.revstg589 Temporary revision records for storage upgrade process
db.revsx519 Revision records for spec depot files
db.revtx579 Task stream revision records
db.revux549 Revision records for unload depot files
db.rmtview121 View data for remote specifications
db.scanctl440 ScanCtl
db.scandir430 Scandir
db.sendq1004 Parallel file transmission work queue
db.sendq.pt1014 Per Client transmission work queue
db.server93 Server specifications
db.stash130 Stash data
db.storage461 Track references to archive files
db.storageg470 Track references to Graph Depot archive files (for future use)
db.storagesh451 Track references to shelved archive files
db.stream211 Stream specifications
db.submodule800 Submodule configuration data
db.svrview100 View data for servers specifications
db.template232 Streams templates
db.templatesx241 Shelved stream templates
db.templatewx251 Pending stream templates
db.ticket170Second factor authentication state on a per user/host basis
db.ticket.rp160Second factor authentication state on a per user/host basis (replica)
db.traits680 Attributes associated with file revisions
db.trigger693 Trigger specifications
db.upgrades60 Store server upgrade info
db.upgrades.rp50 Store replica upgrade info
db.user157User specifications
db.user.rp147 Used by replica server's to store login information
db.uxtext960 Indexing data for Swarm
db.view271 View data for domain records
db.view.rp261 View data for clients of build-server replicas
db.working6110 Records for work in progress
db.workingg630 Working records for clients of type graph
db.workingx6210 Records for shelved open files
pdb.lbr3 Proxy server pending archive transfer table
rdb.lbr3 Replica server pending archive transfer table
tiny.db0 Records content data for tiny files using the +T file type modifier

Locking Order

To avoid the possibility of deadlock, the Helix Server always locks its tables in a defined order. The section below lists the tables in the order in which they are locked. When a checkpoint is taken, the order of the database file content written to the checkpoint follows the table locking order.

Lock OrderFilenameVers.Description
1db.config1 Server configurations table
2db.configh0 Server configuration history
3db.counters1 Counters table
4db.nameval1 A table to store key/value pairs
5db.upgrades.rp0 Store replica upgrade info
6db.upgrades0 Store server upgrade info
7db.logger0 Support for 'p4 logger' command. Logs any changes to changelists and jobs
8db.ldap0 LDAP specifications
9db.server3 Server specifications
10db.svrview0 View data for servers specifications
11db.remote1 Remote specifications
12db.rmtview1 View data for remote specifications
13db.stash0 Stash data
14db.user.rp7 Used by replica server's to store login information
15db.user7User specifications
16db.ticket.rp0Second factor authentication state on a per user/host basis (replica)
17db.ticket0Second factor authentication state on a per user/host basis
18db.group9Group specifications
19db.groupx1Per-group data to support group membership controlled by AD/LDAP group membership
20db.depot1Depot specifications
21db.stream1 Stream specifications
22db.domain7 Domains: depots, clients, labels, branches, streams, and typemap
23db.template2 Streams templates
24db.templatesx1 Shelved stream templates
25db.templatewx1 Pending stream templates
26db.view.rp1 View data for clients of build-server replicas
27db.view1 View data for domain records
29db.haveview1 Stores mapping changes for clients mapping graph depot content
30db.review1 User's review mappings
31db.label0 Revisions of files in labels
32db.have.rp3 Contains the 'have-list' for clients of build-server replicas
33db.have.pt3 Placeholder for read-only clients
34db.have3 Contains the 'have-list' for all clients
36db.integed0 Permanent integration records
37db.integtx0 Temporary integration records used by task streams
38db.resolve1 Pending integration records
39db.resolvex1 Pending integration records for shelved files
40db.resolveg0 Resolve records for clients of type graph
43db.scandir0 Scandir
44db.scanctl0 ScanCtl
45db.storagesh1 Track references to shelved archive files
46db.storage1 Track references to archive files
47db.storageg0 Track references to Graph Depot archive files (for future use)
48db.revdx9 Revision records for revisions deleted at the head revision
49db.revhx9 Revision records for revisions NOT deleted at the head revision
50db.revpx9 Pending revision records
51db.revsx9 Revision records for spec depot files
52db.revsh9 Revision records for shelved files
53db.revbx9 Revision records for archived files
54db.revux9 Revision records for unload depot files
55db.revcx0 Secondary index of db.rev
56db.rev9 Revision records
57db.revtx9 Task stream revision records
58db.revstg9 Temporary revision records for storage upgrade process
59db.locks2Locked/Unlocked files
60db.locksg2Lock records for clients of type graph
61db.working10 Records for work in progress
62db.workingx10 Records for shelved open files
63db.workingg0 Working records for clients of type graph
64db.haveg0 Contains the 'have-list' for graph depot files that are not at the same revision as defined by the client's have reference.
65db.excl1Exclusively locked (+l) files - enables coordinated file locking in commit/edge server environments
66db.exclg0Graph depot LFS locks
67db.exclgx0Graph depot LFS locks indexed by lockId
68db.traits0 Attributes associated with file revisions
69db.trigger3 Trigger specifications
70db.change6 Changelists
71db.changex6 Subset of db.change - records for pending changelists only
72db.changeidx1 Secondary index of db.change/db.changex
73db.desc0 Change descriptions
74db.repo3 Repository specifications
75db.refhist0 Reference history for graph depots
76db.ref0Reference content for graph depots
77db.object0 Object storage for graph depots
78db.graphindex1 Graph depot repository index data
79db.graphperm0 Graph depot permissions
80db.submodule0 Submodule configuration data
81db.pubkey0 SSH Public keys
82db.job0 Job records
85db.fix1 Fix records - indexed by job
86db.fixrev1 Fix records - indexed by change
87db.bodresolve0 Resolve data for stream specifications
88db.bodtext1 Job data for job attributes
89db.bodtextcx0 Versioned openable spec fields
90db.bodtexthx0 Head revision of spec fields
91db.bodtextsx0 Shelved openable spec fields
92db.bodtextwx0 Open openable spec fields
94db.ixtext0 Indexing data for generic and job attributes
95db.ixtexthx0 Indexing data for head revision of all spec fields
96db.uxtext0 Indexing data for Swarm
97db.protect5 The protections table
98db.property0 Properties
99db.message0 System messages
100db.sendq4 Parallel file transmission work queue
101db.sendq.pt4 Per Client transmission work queue
102db.jnlack1 Tracks journal positions of all replicas
103db.monitor2 Helix Server process information

Upgrades

The following table lists the upgrade operations performed by p4d -xu and shows the release in which each upgrade was introduced.

The 2019.2 release has 35 upgrades.
UpgradeReleaseDescriptionNotes
12001.1Split db.integ into db.integed and db.resolve
22001.1Split db.have into db.have and db.label
32002.1Split db.change into db.change and db.changex
42002.2Upgrade tempobj filetype in db.rev
52002.2Upgrade tempobj filetype in db.working
62003.1Initialize default depot
72003.2Upgrade db.user
82005.1Build db.revhx (headrev) table
92005.1Rebuild db.locks from db.working
102005.1Build lazy-copy index (db.archive)Removed in 2006.2
112005.2Build db.revdx (delrev) table
122005.2Build haveMap from db.have/db.workingMoved to 16 in 2007.3
132005.2Move spec depot entries into db.revsx
142006.2Build db.archmap (lazy-copy map) tableMoved to 17 in 2007.3
152006.2Remove (obsolete) db.archive tableMoved to 18 in 2007.3
162007.3Build/Rebuild haveMap from db.have/db.workingRewritten in 2007.3
172007.3Build/Rebuild db.archmap (lazy-copy map) tableRemoved in 2019.1
182007.3Remove (obsolete) db.archive tableMoved from 15 in 2007.3
192008.1Build db.change common path
202009.2Move db.boddate/db.ixdate into db.bodtext/db.ixtext
212009.2Remove db.boddate/db.ixdate
222010.2Move system counters into db.config
232011.1Upgrade tiny.db
242015.2Move LDAP specs into db.ldap
252016.1Create db.templatesx and db.templatewx
262016.2Initialize graph depot
272017.1Rename repo specifications, build owner graph permissions, remove db.repoview
282017.2No upgrades - upgrade counter value increment only
292018.1Remove existing db.graphindexremove db.graphindex
302018.2Initialize Extensions depot and server.extensions.dir
312018.2Normalize a field in the triggers table
322019.1Build db.storage from db.rev, db.revsh and db.revtx, remove db.archmap
332019.1 Add default namespace to Extension configurations
342019.2Upgrade git-connector server specs
352019.2Correct configurationVersion server names

The following table lists the upgrade operations performed by a server when first configured as a commit server and shows the release in which each upgrade was introduced.

These upgrades run when the first server specification with 'Services: commit-server' is saved.

UpgradeReleaseDescriptionNotes
commit-server2013.2Generate exclusive locksGenerate exclusive lock records in db.excl based on db.working data.
commit-server2014.1Promote ShelvesPromote existing shelves by updating changeStatus in db.change and db.changex.

Table Details

db.bodresolve - Resolve data for stream specifications

Indexed on: type, client, toKey, attr, fromKey, fromChange
NameTypeDescription
typeSpecType The spec type
clientDomain The client name
toKeyKey To Key
attrInt The attribute value
fromKeyKey From key
fromChangeChange From change
baseKeyKey Base Key
baseChangeChange Base change

db.bodtext - Job data for job attributes

Indexed on: key, attr
NameTypeDescription
keyKey The job to which this attribute belongs
attrInt The attribute number (from the jobspec) of this attribute
isBulkInt Indicates whether (1), or not (0) the field is a bulk text field that should not be indexed.
textText The attribute value

db.bodtextcx - Versioned openable spec fields

Indexed on: type, key, change, attr
NameTypeDescription
typeInt The type of spec
keyKey The spec to which this attribute belongs
changeChange The change to which this attribute belongs
attrInt The attribute number of this attribute
textText The attribute value

db.bodtexthx - Head revision of spec fields

Indexed on: type, key, attr
NameTypeDescription
typeInt The type of spec
keyKey The spec to which this attribute belongs
attrInt The attribute number of this attribute
bulkInt Indicates whether (1), or not (0) the field is a bulk text field that should not be indexed.
textText The attribute value

db.bodtextsx - Shelved openable spec fields

Indexed on: type, shelf, key, attr
NameTypeDescription
typeInt The type of spec
shelfChange The shelf to which this attribute belongs
keyKey The spec to which this attribute belongs
attrInt The attribute number of this attribute
textText The attribute value
workChangeChange The working change

db.bodtextwx - Open openable spec fields

Indexed on: type, client, key, attr
NameTypeDescription
typeInt The type of spec
clientDomain The client the spec is opened on
keyKey The spec to which this attribute belongs
attrInt The attribute number of this attribute
textText The attribute value
workChangeChange The working change

db.change - Changelists

Indexed on: change
NameTypeDescription
changeChange The change number
descKeyChange The description key. Normally the same as 'change', but may differ if a changelist was renumbered on submission.
clientDomain The client from which the change originates
userUser The user who owns the change
dateDate Date and time the changelist was submitted
statusChangeStatus Status of the change
descriptionDescShort Short description of the change.
rootMapping Common path for all files in the changelist
importerUser The user who fetched or pushed this change to this server
identityKey Identifier for this change
accessDate Shelve last access
updateDate Shelve last update
streamDomain Stream spec name in changelist

db.changeidx - Secondary index of db.change/db.changex

Indexed on: identity
NameTypeDescription
identityKey Identifier for this change
changeChange Changelist

db.changex - Subset of db.change - records for pending changelists only

Indexed on: change
NameTypeDescription
changeChange The change number
descKeyChange The description key. Normally the same as 'change', but may differ if a changelist was renumbered on submission.
clientDomain The client from which the change originates
userUser The user who owns the change
dateDate Date and time the changelist was submitted
statusChangeStatus Status of the change
descriptionDescShort Short description of the change.
rootMapping Common path for all files in the changelist
importerUser The user who fetched or pushed this change to this server
identityKey Identifier for this change
accessDate Shelve last access
updateDate Shelve last update
streamDomain Stream spec name in changelist
Note: contains records for pending changelists only.

db.config - Server configurations table

Indexed on: serverName, name
NameTypeDescription
serverNameKey Server name
nameKey Configuration variable name
valueValue Configuration variable value

db.configh - Server configuration history

Indexed on: sName, name, version, date, server
NameTypeDescription
sNameKey Server name where configurable applies
nameKey variable name
versionInt configuration version
dateDate date
serverKey server ID where the configurable was set
userUser user
ovalueValue old value
nvalueValue new value

db.counters - Counters table

Indexed on: name
NameTypeDescription
nameCounter Counter name
valueValue Counter value

db.depot - Depot specifications

Indexed on: name
NameTypeDescription
nameDomain Depot name
typeDepotType Type of depot
extraText For remote depots, the P4PORT address of the remote server. For spec depots, a suffix to append to the filename. For stream depots, stream depth
mapText The depot's map (path translation information). For local depots, this will be a path relative to the root directory. For remote depots, this will be specified in terms of the remote server's namespace.

db.desc - Change descriptions

Indexed on: descKey
NameTypeDescription
descKeyChange Original number of the change to which this description applies. This may differ from the final change number if the change is renumbered on submission.
descriptionText The change description itself

db.domain - Domains: depots, clients, labels, branches, streams, and typemap

Indexed on: name
NameTypeDescription
nameDomain Domain name
typeDomainType Type of domain
extraText Formerly "host". Associated host or, for labels, revision number.
mountText The client root
mount2Text Alternate client root
mount3Text Alternate client root
ownerUser Name of user who owns the domain.
updateDateDate Date of last update to domain specification.
accessDateDate Date of last access to domain specification.
optionsDomainOpts Options for client, label, and branch domains.
descriptionText Description of domain.
streamDomain Associated stream for client records
serverIdKey Associated server ID for client records
contentsInt Client domain contents. 1: Maps only classic depot files, 2: Maps only graph depot files, 3: Maps both classic and graph depot files

db.excl - Exclusively locked (+l) files - enables coordinated file locking in commit/edge server environments

Indexed on: depotFile
NameTypeDescription
depotFileFile The file locked
clientDomain The client for which the file is locked
userUser The user for which the file is locked

db.exclg - Graph depot LFS locks

Indexed on: repo, ref, file
NameTypeDescription
repoKey The name of the repository on which the lock is applied
refText The reference on which the lock is applied
fileFile The git file path
lockIdString The git LFS lock identifier
userUser The user for which the file is locked
createdString The lock creation date stored in git data format

db.exclgx - Graph depot LFS locks indexed by lockId

Indexed on: lockId
NameTypeDescription
lockIdString The git LFS lock identifier
repoKey The name of the repository on which the lock is applied
refText The reference on which the lock is applied
fileFile The git file path
userUser The user for which the file is locked
createdString The lock creation date stored in git data format

db.fix - Fix records - indexed by job

Indexed on: job, change
NameTypeDescription
jobKey Job name
changeChange Changelist number
dateDate Date fix was recorded (may differ from date change was submitted).
statusFixStatus Status of the job
clientDomain The client where the fix originated
userUser The user who fixed the job
See also:db.fixrev

db.fixrev - Fix records - indexed by change

Indexed on: change, job
NameTypeDescription
jobKey Job name
changeChange Changelist number
dateDate Date fix was recorded (may differ from date change was submitted).
statusFixStatus Status of the job
clientDomain The client where the fix originated
userUser The user who fixed the job
See also:db.fix

db.graphindex - Graph depot repository index data

Indexed on: id, name, date, blobSha, commitSha
NameTypeDescription
idIntID of repo index belongs to
nameFileFile name (minus the repo name)
dateDateDescending historical commit sequence
blobShaSHA1SHA of blob
commitShaSHA1SHA of commit that added/edited this file
flagsIntMiscellaneous flags
sizeFileSizeThe size of the file (or target LFS file)
typeFileTypeThe filetype of the graph file
lfsoidTextLFS Object ID

db.graphperm - Graph depot permissions

Indexed on: name, repo, ref, type, user, perm
NameTypeDescription
nameDomainGraph depot name
repoMappingRepository name
refMappingReference
typeUserTypeType of user
userUserWildUser or Group for permission
permGraphPermTypePermission

db.group - Group specifications

Indexed on: user, group
NameTypeDescription
userUser User name
groupUser Group name
typeUserType Type of user in this group.
maxResultsMaxResults MaxResults setting for the group.
maxScanRowsMaxScanRows MaxScanRows setting for the group.
maxLockTimeMaxLockTime MaxLockTime setting for the group.
maxOpenFilesMaxOpenFiles MaxOpenFiles setting for the group.
timeoutInt Length of time (in seconds) a login ticket remains valid.
passwordTimeoutInt Length of time (in seconds) a password remains valid for users in the group.

db.groupx - Per-group data to support group membership controlled by AD/LDAP group membership

Indexed on: group
NameTypeDescription
groupUser Group name
ldapConfString The LDAP configuration to use when populating the group's user list from an LDAP query
ldapSearchQueryString The LDAP query used to identify the members of the group
ldapUserAttributeString The LDAP attribute that represents the user's username
ldapDNAttributeString The LDAP attribute that represents the user's DN

db.have - Contains the 'have-list' for all clients

Indexed on: clientFile
NameTypeDescription
clientFileFile The file in its location on the client
depotFileFile The file in the depot
haveRevRev The revision synced to the client
typeFileType The filetype of the synced file
timeDate The sync time of the synced revision

db.have.pt - Placeholder for read-only clients

Indexed on: clientFile
NameTypeDescription
clientFileFile The file in its location on the client
depotFileFile The file in the depot
haveRevRev The revision synced to the client
typeFileType The filetype of the synced file
timeDate The sync time of the synced revision

db.have.rp - Contains the 'have-list' for clients of build-server replicas

Indexed on: clientFile
NameTypeDescription
clientFileFile The file in its location on the client
depotFileFile The file in the depot
haveRevRev The revision synced to the client
typeFileType The filetype of the synced file
timeDate The sync time of the synced revision

db.haveg - Contains the 'have-list' for graph depot files that are not at the same revision as defined by the client's have reference.

Indexed on: repo, clientFile
NameTypeDescription
repoKey Repository name
clientFileFile The file in its location on the client
depotFileFile The git file path
clientDomain Domain (client) in which file is synced
typeFileType The filetype of the synced revision
actionAction Action file is open for: add, edit, delete, branch, integrate, or import
blobShaSHA1 SHA of blob
commitShaSHA1 SHA of commit that added/edited this file
flagsInt Miscellaneous flags

db.haveview - Stores mapping changes for clients mapping graph depot content

Indexed on: name, seq
NameTypeDescription
nameDomain Domain name to which this view applies
seqInt Sequence number: for ordering multi-line views
mapFlagMapFlag Type of mapping
viewFileMapping The right-hand-side of the view. For clients, this is the client-side, for labels it's the generated label view. For branches, it's the target side of the branch view.
depotFileMapping The left-hand-side of the view - a mapping to file(s) in the depot.

db.integed - Permanent integration records

Indexed on: toFile, fromFile, startFromRev, endFromRev, startToRev, endToRev
NameTypeDescription
toFileFile File to which integration is being performed (target).
fromFileFile File from which integration is being performed (source).
startFromRevRevStarting revision of fromFile
endFromRevRev Ending revision of fromFile
startToRevRev Start revision of toFile into which integration was performed.
endToRevRev End revision of toFile into which integration was performed. Only varies from startToRev for reverse integration records.
howIntegHow Integration method: variations on merge/branch/copy/ignore/delete.
changeChangeChangelist associated with the integration.
See also:db.resolve

db.integtx - Temporary integration records used by task streams

Indexed on: toFile, fromFile, startFromRev, endFromRev, startToRev, endToRev
NameTypeDescription
toFileFile File to which integration is being performed (target).
fromFileFile File from which integration is being performed (source).
startFromRevRevStarting revision of fromFile
endFromRevRev Ending revision of fromFile
startToRevRev Start revision of toFile into which integration was performed.
endToRevRev End revision of toFile into which integration was performed. Only varies from startToRev for reverse integration records.
howIntegHow Integration method: variations on merge/branch/copy/ignore/delete.
changeChangeChangelist associated with the integration.
See also:db.resolve

db.ixtext - Indexing data for generic and job attributes

Indexed on: word, attr, value
NameTypeDescription
wordKey The word being indexed
attrInt The attribute number to which this word belongs. For job data, the attribute number from the jobspec.
valueKey For job data, a job name. For generic data, the value of the index keyed by the word.

db.ixtexthx - Indexing data for head revision of all spec fields

Indexed on: type, word, attr, value
NameTypeDescription
typeSpecType The type
wordKey The word being indexed
attrInt The attribute number to which this word belongs.
valueKey The value of the index keyed by the word.

db.jnlack - Tracks journal positions of all replicas

Indexed on: serverId
NameTypeDescription
serverIdKey The serverId of the replica for whom this record applies
lastUpdateDate The date and time of last update
serverTypeServerServiceType The server services offered by this replica
persistedJnlInt The last journal number persisted by this replica
appliedJnlInt The last journal number applied by this replica
persistedPosInt64 The last journal position persisted by this replica
appliedPosInt64 The last journal position applied by this replica
jcflagsJournalCopyFlags Journalcopy Flags
isAliveInt 1 = alive
serverOptionsServerOptionsType Server Options
failoverSeenText Failover was seen

db.job - Job records

Indexed on: job
NameTypeDescription
jobKey The job name
xuserUser User name: defunct
xdateDate The date: defunct
xstatusJobStat Job status: defunct
descriptionDescShort Short description
See also:db.bodtext

db.label - Revisions of files in labels

Indexed on: name, depotFile
NameTypeDescription
nameDomainName of the label
depotFileFileFile name
haveRevRevThe revision of the file in the label

db.ldap - LDAP specifications

Indexed on: name
NameTypeDescription
nameKey The LDAP configuration name
hostString The FQDN of the directory server
portInt The port number on which to connect to the directory server
sslInt The encryption method to use when connecting to the The FQDN of the directory server. Options are: 0='none', 1='ssl' and 2='tls'
typeInt The bind method to use with this directory. Options are: 0='simple', 1='search' and 2='sasl'.
patternText The DN used to bind against to validate the user's credentials.
baseDNText The DN from which to start the search for the user object
filterText The LDAP query filter to use to identify the user object which will be used to bind against
scopeInt The scope to use when searching for the user records. Options are: 0 = baseonly - Just the BaseDN object 1 = children - The BaseDN and its direct children 2 = subtree - The BaseDN and all objects below it
bindDNText The DN to bind against in order to search the directory
bindpassText The password for the BindDN record
realmText The optional realm to use when authenticating the user via SASL
groupBaseDNText The search base for performing the group search. If unset this will default to the SearchBaseDN
groupFilterText The filter to use for the group search
groupScopeInt The scope to use when performing the group search.Options are: 0 = baseonly - Just the BaseDN object 1 = children - The BaseDN and its direct children 2 = subtree - The BaseDN and all objects below it
optionsInt LDAP options bitmask: 1=[no]downcase, 2=[no]getattrs and 4=[no]realminusername
attrUidText The name of the attribute in the directory's user records that contain the users' UIDs
attrEmailText The name of the attribute in the directory's user records that contain the users' email addresses.
attrNameText The name(s) of the attribute(s) in the directory's user records that contain the users' full names.

db.locks - Locked/Unlocked files

Indexed on: depotFile, client
NameTypeDescription
depotFileFileFile in depot
clientDomainDomain (client) in which file is open
userUserUser who presently has the file open
actionAction Action file is open for: add, edit, delete, branch, integrate, or import
isLockedIntFlag: 0 for unlocked, 1 for locked
changeChange Changelist in which the revision is open: 0 for the default changelist

db.locksg - Lock records for clients of type graph

Indexed on: depotFile, client
NameTypeDescription
depotFileFileFile in depot
clientDomainDomain (client) in which file is open
userUserUser who presently has the file open
actionAction Action file is open for: add, edit, delete, branch, integrate, or import
isLockedIntFlag: 0 for unlocked, 1 for locked
changeChange Changelist in which the revision is open: 0 for the default changelist

db.logger - Support for 'p4 logger' command. Logs any changes to changelists and jobs

Indexed on: seq
NameTypeDescription
seqInt Sequence number of event
keyKey Either the word 'change' or the word 'job'
attrKey The number of the change, or name of the job that was altered.

db.message - System messages

Indexed on: language, id
NameTypeDescription
languageKey The language for which this message applies
idInt The message number
messageString The message text

db.monitor - Helix Server process information

Indexed on: id
NameTypeDescription
idInt Thread/process id
userUser Username of the user running the command
functionString The command being executed.
argsString Arguments passed to the command
startDateDate The date and time the command started
runstateInt Flag: 0 for running, 1 for terminated, 2 for paused
clientDomain The client workspace
hostText The IP address of the client
progText The name (and version) of the client program
lockInfoText Table locking information for command

db.nameval - A table to store key/value pairs

Indexed on: name
NameTypeDescription
nameKey Key name
valueValue Key value

db.object - Object storage for graph depots

Indexed on: sha
NameTypeDescription
shaSHA1The SHA1 of the object
typeObjectTypeThe object type
dataOctet StringThe object content

db.property - Properties

Indexed on: name, seq, type, scope
NameTypeDescription
nameKey The property name
seqInt Sequence number of property
typeUserType Only uses 1=user or 2=group and only applies when scope is set
scopeUser The user or group the property applies to (may be empty)
valueValue The property value
dateDate The date/time the property was last updated
userUser The user that last modified the property

db.protect - The protections table

Indexed on: seq
NameTypeDescription
seqInt Sequence number: for ordering the protections table
isGroupInt Flag: 0 for a per-user setting, 1 for a per-group setting.
userUserWild User(s), or Group(s) for whom this record applies.
hostDomainWild Domain(s) (IP addresses) for which this record applies.
permPerm Permissions to be granted/revoked
mapFlagMapFlag Flag: Map the files in or out?
depotFileMapping Files to be mapped in or out.
subPathMapping Root path of the sub-protections table
updateDate Date this specification was last modified

db.pubkey - SSH Public keys

Indexed on: user, scope
NameTypeDescription
userUserUser
scopeKeyScope
keyTextKey
digestDigestDigest
updateDateUpdate date

db.ref - Reference content for graph depots

Indexed on: repo, type, name
NameTypeDescription
repoKeyRepository name
nameKeyReference name
typeRefTypeReference type
refSHA1Target of the reference
symrefTextTarget of symbolic reference

db.refhist - Reference history for graph depots

Indexed on: repo, type, name, date, action, user, ref
NameTypeDescription
repoKeyRepository name
nameKeyReference name
typeRefTypeReference type
actionRefActionReference action
dateDateThe date the reference was updated
userUserThe user who made the reference update
refSHA1Encoded reference value
symrefTextSymbolic reference

db.remote - Remote specifications

Indexed on: id
NameTypeDescription
idRemoteID The remote identifier
ownerUser The user who created this remote
optionsInt Remote options bitmask: 0: unlocked/nocompress, 1: locked/nocompress, 2: unlocked/compress, 4: locked/compress
addressText The P4PORT used by the remote server
descText Description of the remote server
updateDate The date this specification was last modified
accessDate The date of the last push/fetch on this remote
fetchChange The last changelist that was fetched
pushChange The last changelist that was pushed
rmtuserUser The user to use when connecting to the remote server

db.repo - Repository specifications

Indexed on: repo
NameTypeDescription
repoKeyName of the repo
ownerUserOwner of the repo
createdDateDate the repo specification was created
pushedDateDate of the last push to the repo
forkedKeyName of the repo from which this repo was forked
descTextRepo Description
branchTextDefault branch to clone from the repo
mirrorTextUpstream URL that this repo is mirrored (readonly) from
optionsIntRepo options: 0 = nolfs, 1 = lfs
idIntRepo index ID
gcmrrserverTextgconn Mirror Server ID

db.resolve - Pending integration records

Indexed on: toFile, fromFile, startFromRev
NameTypeDescription
toFileFile File to which integration is being performed (target).
fromFileFile File from which integration is being performed (source).
startFromRevRevStarting revision of fromFile
endFromRevRev Ending revision of fromFile
startToRevRev Start revision of toFile into which integration was performed.
endToRevRev End revision of toFile into which integration was performed. Only varies from startToRev for reverse integration records.
howIntegHow Integration method: variations on merge/branch/copy/ignore/delete.
stateResolveStateHow the user performed the resolve.
baseFileFileFile used as the base for merging.
baseRevRevRevision of baseFile used as the merge base.
See also:db.integed

db.resolveg - Resolve records for clients of type graph

Indexed on: toFile, fromFile, baseSha
NameTypeDescription
toFileFileToFile
fromFileFileFromFile
baseSHASHA1Base SHA
wantsSHASHA1Wants SHA
howIntegHowHow
stateResolvedStatusState

db.resolvex - Pending integration records for shelved files

Indexed on: toFile, fromFile, startFromRev
NameTypeDescription
toFileFile File to which integration is being performed (target).
fromFileFile File from which integration is being performed (source).
startFromRevRevStarting revision of fromFile
endFromRevRev Ending revision of fromFile
startToRevRev Start revision of toFile into which integration was performed.
endToRevRev End revision of toFile into which integration was performed. Only varies from startToRev for reverse integration records.
howIntegHow Integration method: variations on merge/branch/copy/ignore/delete.
stateResolveStateHow the user performed the resolve.
baseFileFileFile used as the base for merging.
baseRevRevRevision of baseFile used as the merge base.
See also:db.integed

db.rev - Revision records

Indexed on: depotFile, depotRev
NameTypeDescription
depotFileFile The file name
depotRevRev The revision number
typeFileType The file type of the revision
actionAction The action that created the revision
changeChange The changelist that created the revision
dateDate The date/time the changelist that created the revision was submitted
modTimeDate The timestamp on the file in the user's workspace when the revision was submitted.
digestDigest The MD5 digest of the revision.
sizeFileSize The size of the file in bytes
traitLotTraitLot Group of traits (attributes) associated with the revision.
lbrIsLazyRevStatus Specifies whether or not the revision gets its content from another file (lazy copy), data about promotion of revision content from task streams, and data about revision charset information.
lbrFileFile Filename for librarian's purposes. Specifies location in the archives where the file containing the revision may be found. Usually the same as depotFile, but differs in the case of branched/copied revisions.
lbrRevString The revision of lbrFile that contains the revision content.
lbrTypeFileType The file type of the librarian revision. Usually the same as type, but differs in the case of branched/copied revisions.

db.revbx - Revision records for archived files

Indexed on: depotFile, depotRev
NameTypeDescription
depotFileFile The file name
depotRevRev The revision number
typeFileType The file type of the revision
actionAction The action that created the revision
changeChange The changelist that created the revision
dateDate The date/time the changelist that created the revision was submitted
modTimeDate The timestamp on the file in the user's workspace when the revision was submitted.
digestDigest The MD5 digest of the revision.
sizeFileSize The size of the file in bytes
traitLotTraitLot Group of traits (attributes) associated with the revision.
lbrIsLazyRevStatus Specifies whether or not the revision gets its content from another file (lazy copy), data about promotion of revision content from task streams, and data about revision charset information.
lbrFileFile Filename for librarian's purposes. Specifies location in the archives where the file containing the revision may be found. Usually the same as depotFile, but differs in the case of branched/copied revisions.
lbrRevString The revision of lbrFile that contains the revision content.
lbrTypeFileType The file type of the librarian revision. Usually the same as type, but differs in the case of branched/copied revisions.

db.revcx - Secondary index of db.rev

Indexed on: change, depotFile
NameTypeDescription
changeChange The changelist that created the revision
depotFileFile The file name
depotRevRev The revision number
actionAction The action that created the revision

db.revdx - Revision records for revisions deleted at the head revision

Indexed on: depotFile
NameTypeDescription
depotFileFile The file name
depotRevRev The revision number
typeFileType The file type of the revision
actionAction The action that created the revision
changeChange The changelist that created the revision
dateDate The date/time the changelist that created the revision was submitted
modTimeDate The timestamp on the file in the user's workspace when the revision was submitted.
digestDigest The MD5 digest of the revision.
sizeFileSize The size of the file in bytes
traitLotTraitLot Group of traits (attributes) associated with the revision.
lbrIsLazyRevStatus Specifies whether or not the revision gets its content from another file (lazy copy), data about promotion of revision content from task streams, and data about revision charset information.
lbrFileFile Filename for librarian's purposes. Specifies location in the archives where the file containing the revision may be found. Usually the same as depotFile, but differs in the case of branched/copied revisions.
lbrRevString The revision of lbrFile that contains the revision content.
lbrTypeFileType The file type of the librarian revision. Usually the same as type, but differs in the case of branched/copied revisions.

db.revhx - Revision records for revisions NOT deleted at the head revision

Indexed on: depotFile
NameTypeDescription
depotFileFile The file name
depotRevRev The revision number
typeFileType The file type of the revision
actionAction The action that created the revision
changeChange The changelist that created the revision
dateDate The date/time the changelist that created the revision was submitted
modTimeDate The timestamp on the file in the user's workspace when the revision was submitted.
digestDigest The MD5 digest of the revision.
sizeFileSize The size of the file in bytes
traitLotTraitLot Group of traits (attributes) associated with the revision.
lbrIsLazyRevStatus Specifies whether or not the revision gets its content from another file (lazy copy), data about promotion of revision content from task streams, and data about revision charset information.
lbrFileFile Filename for librarian's purposes. Specifies location in the archives where the file containing the revision may be found. Usually the same as depotFile, but differs in the case of branched/copied revisions.
lbrRevString The revision of lbrFile that contains the revision content.
lbrTypeFileType The file type of the librarian revision. Usually the same as type, but differs in the case of branched/copied revisions.

db.review - User's review mappings

Indexed on: user, seq
NameTypeDescription
userUser A user name
seqInt Sequence number: used for ordering multi-line views
mapFlagMapFlag Type of mapping
depotFileMapping The files to be reviewed
typeReviewer Type of reviewer

db.revpx - Pending revision records

Indexed on: depotFile, depotRev
NameTypeDescription
depotFileFile The file name
depotRevRev The revision number
typeFileType The file type of the revision
actionAction The action that created the revision
changeChange The changelist that created the revision
dateDate The date/time the changelist that created the revision was submitted
modTimeDate The timestamp on the file in the user's workspace when the revision was submitted.
digestDigest The MD5 digest of the revision.
sizeFileSize The size of the file in bytes
traitLotTraitLot Group of traits (attributes) associated with the revision.
lbrIsLazyRevStatus Specifies whether or not the revision gets its content from another file (lazy copy), data about promotion of revision content from task streams, and data about revision charset information.
lbrFileFile Filename for librarian's purposes. Specifies location in the archives where the file containing the revision may be found. Usually the same as depotFile, but differs in the case of branched/copied revisions.
lbrRevString The revision of lbrFile that contains the revision content.
lbrTypeFileType The file type of the librarian revision. Usually the same as type, but differs in the case of branched/copied revisions.
Note: Only populated during content trigger execution to allow triggers access to the revisions being submitted.

db.revsh - Revision records for shelved files

Indexed on: depotFile, depotRev, type, action, change
NameTypeDescription
depotFileFile The file name
depotRevRev The revision number
typeFileType The file type of the revision
actionAction The action that created the revision
changeChange The changelist that created the revision
dateDate The date/time the changelist that created the revision was submitted
modTimeDate The timestamp on the file in the user's workspace when the revision was submitted.
digestDigest The MD5 digest of the revision.
sizeFileSize The size of the file in bytes
traitLotTraitLot Group of traits (attributes) associated with the revision.
lbrIsLazyRevStatus Specifies whether or not the revision gets its content from another file (lazy copy), data about promotion of revision content from task streams, and data about revision charset information.
lbrFileFile Filename for librarian's purposes. Specifies location in the archives where the file containing the revision may be found. Usually the same as depotFile, but differs in the case of branched/copied revisions.
lbrRevString The revision of lbrFile that contains the revision content.
lbrTypeFileType The file type of the librarian revision. Usually the same as type, but differs in the case of branched/copied revisions.

db.revstg - Temporary revision records for storage upgrade process

Indexed on: depotFile, depotRev
NameTypeDescription
depotFileFile The file name
depotRevRev The revision number
typeFileType The file type of the revision
actionAction The action that created the revision
changeChange The changelist that created the revision
dateDate The date/time the changelist that created the revision was submitted
modTimeDate The timestamp on the file in the user's workspace when the revision was submitted.
digestDigest The MD5 digest of the revision.
sizeFileSize The size of the file in bytes
traitLotTraitLot Group of traits (attributes) associated with the revision.
lbrIsLazyRevStatus Specifies whether or not the revision gets its content from another file (lazy copy), data about promotion of revision content from task streams, and data about revision charset information.
lbrFileFile Filename for librarian's purposes. Specifies location in the archives where the file containing the revision may be found. Usually the same as depotFile, but differs in the case of branched/copied revisions.
lbrRevString The revision of lbrFile that contains the revision content.
lbrTypeFileType The file type of the librarian revision. Usually the same as type, but differs in the case of branched/copied revisions.

db.revsx - Revision records for spec depot files

Indexed on: depotFile, depotRev
NameTypeDescription
depotFileFile The file name
depotRevRev The revision number
typeFileType The file type of the revision
actionAction The action that created the revision
changeChange The changelist that created the revision
dateDate The date/time the changelist that created the revision was submitted
modTimeDate The timestamp on the file in the user's workspace when the revision was submitted.
digestDigest The MD5 digest of the revision.
sizeFileSize The size of the file in bytes
traitLotTraitLot Group of traits (attributes) associated with the revision.
lbrIsLazyRevStatus Specifies whether or not the revision gets its content from another file (lazy copy), data about promotion of revision content from task streams, and data about revision charset information.
lbrFileFile Filename for librarian's purposes. Specifies location in the archives where the file containing the revision may be found. Usually the same as depotFile, but differs in the case of branched/copied revisions.
lbrRevString The revision of lbrFile that contains the revision content.
lbrTypeFileType The file type of the librarian revision. Usually the same as type, but differs in the case of branched/copied revisions.

db.revtx - Task stream revision records

Indexed on: depotFile, depotRev
NameTypeDescription
depotFileFile The file name
depotRevRev The revision number
typeFileType The file type of the revision
actionAction The action that created the revision
changeChange The changelist that created the revision
dateDate The date/time the changelist that created the revision was submitted
modTimeDate The timestamp on the file in the user's workspace when the revision was submitted.
digestDigest The MD5 digest of the revision.
sizeFileSize The size of the file in bytes
traitLotTraitLot Group of traits (attributes) associated with the revision.
lbrIsLazyRevStatus Specifies whether or not the revision gets its content from another file (lazy copy), data about promotion of revision content from task streams, and data about revision charset information.
lbrFileFile Filename for librarian's purposes. Specifies location in the archives where the file containing the revision may be found. Usually the same as depotFile, but differs in the case of branched/copied revisions.
lbrRevString The revision of lbrFile that contains the revision content.
lbrTypeFileType The file type of the librarian revision. Usually the same as type, but differs in the case of branched/copied revisions.

db.revux - Revision records for unload depot files

Indexed on: depotFile, depotRev
NameTypeDescription
depotFileFile The file name
depotRevRev The revision number
typeFileType The file type of the revision
actionAction The action that created the revision
changeChange The changelist that created the revision
dateDate The date/time the changelist that created the revision was submitted
modTimeDate The timestamp on the file in the user's workspace when the revision was submitted.
digestDigest The MD5 digest of the revision.
sizeFileSize The size of the file in bytes
traitLotTraitLot Group of traits (attributes) associated with the revision.
lbrIsLazyRevStatus Specifies whether or not the revision gets its content from another file (lazy copy), data about promotion of revision content from task streams, and data about revision charset information.
lbrFileFile Filename for librarian's purposes. Specifies location in the archives where the file containing the revision may be found. Usually the same as depotFile, but differs in the case of branched/copied revisions.
lbrRevString The revision of lbrFile that contains the revision content.
lbrTypeFileType The file type of the librarian revision. Usually the same as type, but differs in the case of branched/copied revisions.

db.rmtview - View data for remote specifications

Indexed on: id, seq
NameTypeDescription
idRemoteID Remote name
seqInt Sequence number: for ordering multi-line views
mapFlagMapFlag Type of mapping
localFileMapping Local file
remoteFileMapping Remote file
retainInt ArchiveLimits

db.scanctl - ScanCtl

Indexed on: file
NameTypeDescription
depotPathFilename of scanner task
stateScanStatescan state
seqIntNext internal sequence number of working directories
dirsIntdirectories processed
filesIntfiles processed
zerosIntorphaned revisions
dirserrIntdirectories skipped due to errors
priIntPriority (unused)
reqpauseIntrequest paused
errTextbackground process error

db.scandir - Scandir

Indexed on: lskey, seq
NameTypeDescription
lskeyFilelibrary scan key
seqIntThe sequence of the work directory
fileFileThe path of the pending work directory

db.sendq - Parallel file transmission work queue

Indexed on: taskid, seq
NameTypeDescription
taskidInt The process id (PID) of the sync
seqInt Sequence number
handleText Handle
depotFileFile The file in the depot
clientFileFile The file in its location on the client
haveRevRev Have revision
typeFileType File type
modtimeDate Modification time
digestDigest The MD5 digest of the revision
sizeFileSize The size of the file in bytes
lbrFileFile Librarian filename
lbrRevString The librarian revision number
lbrTypeFileType The file type of the librarian revision
flagsInt Miscellaneous flags
clientTypeFileType The client file type of the revision
depotRevRev The revision number of depotFile
changeChange The changelist that created the depotRev of depotFile
dateDate The date/time when the changelist that created depotRev of depotFile was submitted
blobShaSHA1 The Blob SHA
repoSlotInt The repo slot (internal repo ordering)
shelveDigestDigest Digest of previous shelved revision

db.sendq.pt - Per Client transmission work queue

Indexed on: taskid, seq
NameTypeDescription
taskidInt The process id (PID) of the sync
seqInt Sequence number
handleText Handle
depotFileFile The file in the depot
clientFileFile The file in its location on the client
haveRevRev Have revision
typeFileType File type
modtimeDate Modification time
digestDigest The MD5 digest of the revision
sizeFileSize The size of the file in bytes
lbrFileFile Librarian filename
lbrRevString The librarian revision number
lbrTypeFileType The file type of the librarian revision
flagsInt Miscellaneous flags
clientTypeFileType The client file type of the revision
depotRevRev The revision number of depotFile
changeChange The changelist that created the depotRev of depotFile
dateDate The date/time when the changelist that created depotRev of depotFile was submitted
blobShaSHA1 The Blob SHA
repoSlotInt The repo slot (internal repo ordering)
shelveDigestDigest Digest of previous shelved revision

db.server - Server specifications

Indexed on: id
NameTypeDescription
idKey The server identifier
typeServerType The server type: server/broker/proxy
nameText The P4NAME used by this server
addressText The P4PORT used by this server
externalAddressText For an edge server, this optional field contains its external address for connections from the commit server. This field is required for federated parallel submit.
servicesServerServiceType Service provided by this server
descText Server description
userUser The service user used by this server
optionsServerOptionsType Server options
rplFromKey Replication from Server ID
failoverSeenText Mark failover as seen

db.stash - Stash data

Indexed on: client, stream, type, seq
NameTypeDescription
clientDomain Client the stash refers to
streamDomain Stream the stash refers to
typeStashType Stash type
seqInt Sequence number
changeChange Stash change number

db.storage - Track references to archive files

Indexed on: file, rev, type
NameTypeDescription
fileFile Librarian file
revString Librarian revision
typeFileType The file type of the librarian revision
refCountInt Reference count
digestDigest MD5 of librarian file (ktext collapsed)
sizeFileSize Size of file
serverSizeFileSize Size of librarian file on server at time of submit / shelve operation
compCksumDigest Digest of compressed librarian file
dateDate Date of last update to the storage record
Note: Supersedes db.archmap in 2019.1

db.storageg - Track references to Graph Depot archive files (for future use)

Indexed on: repo, sha, type
NameTypeDescription
repoKey Repository name
shaKey Digest of the file in type appropriate format
typeObjectType Type of graph object
refCountInt Reference count
dateDate Date of last update to the storage record

db.storagesh - Track references to shelved archive files

Indexed on: file, rev, type
NameTypeDescription
fileFile Librarian file
revString Librarian revision
typeFileType The file type of the librarian revision
refCountInt Reference count
digestDigest MD5 of librarian file (ktext collapsed)
sizeFileSize Size of file
serverSizeFileSize Size of librarian file on server at time of submit / shelve operation
compCksumDigest Digest of compressed librarian file
dateDate Date of last update to the storage record

db.stream - Stream specifications

Indexed on: stream
NameTypeDescription
streamDomain Stream name
parentDomain Parent stream name
titleText Stream title (alias for the stream name)
typeStreamType The type of stream
previewDate Stream template modification time
changeChange Last submit to stream
copyChangeChange Parent change at last copy
mergeChangeChange Parent change at last merge
highChangeChange Highest change at last merge
hashInt Hash value of dynamic branch
statusStreamStatus Flow status

db.submodule - Submodule configuration data

Indexed on: repo, path
NameTypeDescription
repoKey Repository name
pathKey Path at which the submodule is linked
subrepoKey Submodule repository name

db.svrview - View data for servers specifications

Indexed on: id, type, seq
NameTypeDescription
idKey Server name
typeSvrViewType View type
seqInt Sequence (line) number
mapFlagMapFlag Type of mapping
viewFileMapping View file

db.template - Streams templates

Indexed on: name, change, seq
NameTypeDescription
nameDomain Stream name
changeChange Versioned at change
seqInt Sequence (line) number
parentDomain Parent stream name
typeStreamType Type of stream
pathStreamPathType Stream path type
viewFileMapping View file (left hand side of path)
depotFileMapping Depot file (right hand side of path)
changeMapValue Stream 'import' path changelist specifier. The changelist limits in effect for a given client are displayed in a read-only client spec field called 'ChangeView'

db.templatesx - Shelved stream templates

Indexed on: shelf, name, seq
NameTypeDescription
shelfChange Shelf changelist number
nameDomain Stream name
seqInt Sequence (line) number
changeChange Versioned at change
parentDomain Parent stream name
typeStreamType Type of stream
pathStreamPathType Stream path type
viewFileMapping View file (left hand side of path)
depotFileMapping Depot file (right hand side of path)
changeMapValue Stream 'import' path changelist specifier. The changelist limits in effect for a given client are displayed in a read-only client spec field called 'ChangeView'
changeAtOpenChange Base change at time of opening

db.templatewx - Pending stream templates

Indexed on: client, name, seq
NameTypeDescription
clientDomain Stream client
nameDomain Stream name
seqInt Sequence (line) number
changeChange Versioned at change
parentDomain Parent stream name
typeStreamType Type of stream
pathStreamPathType Stream path type
viewFileMapping View file (left hand side of path)
depotFileMapping Depot file (right hand side of path)
changeMapValue Stream 'import' path changelist specifier. The changelist limits in effect for a given client are displayed in a read-only client spec field called 'ChangeView'
changeAtOpenChange Base change at time of opening

db.ticket - Second factor authentication state on a per user/host basis

Indexed on: user, host
NameTypeDescription
userUser User the ticket was issued for
hostKey Host the ticket was issued for
ticketPassword The 'p4 login' ticket for this user
state2FAState The state of 2 Factor Authentication
tokenString The 2 Factor Authentication token
updateDateDate The date of the last ticket update

db.ticket.rp - Second factor authentication state on a per user/host basis (replica)

Indexed on: user, host
NameTypeDescription
userUser User the ticket was issued for
hostKey Host the ticket was issued for
ticketPassword The 'p4 login' ticket for this user
state2FAState The state of 2 Factor Authentication
tokenString The 2 Factor Authentication token
updateDateDate The date of the last ticket update

db.traits - Attributes associated with file revisions

Indexed on: traitLot, name
NameTypeDescription
traitLotInt Indicates a specific collection of traits (referred to externally as "attributes".)
nameKey Trait (attribute) name
typeTraitType Type of trait
valueOctet String The value

db.trigger - Trigger specifications

Indexed on: seq
NameTypeDescription
seqInt Sequence number: for ordering the trigger list
nameKey Name of the trigger
mapFlagMapFlag Type of mapping: specifies whether the trigger applies to the files or not.
depotFileMapping The files to apply the trigger to
triggerDepotFileFile Depot path to the trigger
triggerTrigger Type of trigger
actionText Command to execute when trigger runs

db.upgrades - Store server upgrade info

Indexed on: seq
NameTypeDescription
seqIntSequence
nameTextname of upgrade
stateUpgradeStatecurrent state
startdateDateupgrade started
enddateDateupgrade ended
infoTextoptional information specific to the upgrade step

db.upgrades.rp - Store replica upgrade info

Indexed on: seq
NameTypeDescription
seqIntSequence
nameTextname of upgrade
stateUpgradeStatecurrent state
startdateDateupgrade started
enddateDateupgrade ended
infoTextoptional information specific to the upgrade step

db.user - User specifications

Indexed on: user
NameTypeDescription
userUser The username
emailText The user's email address
jobViewText The user's job view
updateDateDate The date/time the user record was last updated
accessDateDate The date/time the user record was last used
fullNameText The user's full name
passwordPassword The MD5 hash of the users (encrypted) password
strengthStrength Measure of the strength of the user's password
ticketPassword 'p4 login' ticket for this user
endDateDate Date/time the user's ticket expires
typeUserLevel Type of user
passDateDate Date password was last changed
passExpireDate Date of password expiration
attemptsDate Failed login attempts
authUserAuthType Authentication method (AuthMethod) for the user

db.user.rp - Used by replica server's to store login information

Indexed on: user
NameTypeDescription
userUser The username
emailText The user's email address
jobViewText The user's job view
updateDateDate The date/time the user record was last updated
accessDateDate The date/time the user record was last used
fullNameText The user's full name
passwordPassword The MD5 hash of the users (encrypted) password
strengthStrength Measure of the strength of the user's password
ticketPassword 'p4 login' ticket for this user
endDateDate Date/time the user's ticket expires
typeUserLevel Type of user
passDateDate Date password was last changed
passExpireDate Date of password expiration
attemptsDate Failed login attempts
authUserAuthType Authentication method (AuthMethod) for the user

db.uxtext - Indexing data for Swarm

Indexed on: word, attr, value
NameTypeDescription
wordKey The word being indexed
attrInt The attribute number to which this word belongs. For job data, the attribute number from the jobspec.
valueKey For job data, a job name. For generic data, the value of the index keyed by the word.

db.view - View data for domain records

Indexed on: name, seq
NameTypeDescription
nameDomain Domain name to which this view applies
seqInt Sequence number: for ordering multi-line views
mapFlagMapFlag Type of mapping
viewFileMapping The right-hand-side of the view. For clients, this is the client-side, for labels it's the generated label view. For branches, it's the target side of the branch view.
depotFileMapping The left-hand-side of the view - a mapping to file(s) in the depot.

db.view.rp - View data for clients of build-server replicas

Indexed on: name, seq
NameTypeDescription
nameDomain Domain name to which this view applies
seqInt Sequence number: for ordering multi-line views
mapFlagMapFlag Type of mapping
viewFileMapping The right-hand-side of the view. For clients, this is the client-side, for labels it's the generated label view. For branches, it's the target side of the branch view.
depotFileMapping The left-hand-side of the view - a mapping to file(s) in the depot.

db.working - Records for work in progress

Indexed on: clientFile
NameTypeDescription
clientFileFile File on the client
depotFileFile File in the depot
clientDomain The client the file is opened on
userUser The user who has the file opened
haveRevRev Revision presently in user's client workspace
workRevRev Working revision; normally identical to the haveRev
isVirtualInt Flag: if 1, file was opened with "p4 integ -v".
typeFileType File type
actionAction What the user's doing with the file
changeChange Associated changelist, or zero for the default changelist.
modTimeDate Modification timestamp on the file in the user's workspace.
isLockedInt Flag: 0 for unlocked, 1 for locked.
digestDigest MD5 digest of working file.
sizeFileSize File size
traitLotTraitLot Group of traits associated with file revision.
tamperedTamperCheck Flag indicating the tamper-state of the file in the workspace.
clientTypeFileType Type of the file in the client workspace.
movedFileFile Moved from filename
statusWorkStatus Working status

db.workingg - Working records for clients of type graph

Indexed on: clientFile
NameTypeDescription
clientFileFile File on the client
depotFileFile File in the depot
clientDomain The client on which the file is opened
userUser The user who has the file opened
haveRevRev Revision presently in user's client workspace
workRevRev Working revision; normally identical to the haveRev
isVirtualInt Flag: if 1, file was opened with "p4 integ -v".
typeFileType File type
actionAction What the user's doing with the file
changeChange Associated changelist, or zero for the default changelist.
modTimeDate Modification timestamp on the file in the user's workspace.
isLockedInt Flag: 0 for unlocked, 1 for locked.
digestDigest MD5 digest of working file.
sizeFileSize File size
traitLotTraitLot Group of traits associated with file revision.
tamperedTamperCheck Flag indicating the tamper-state of the file in the workspace.
clientTypeFileType Type of the file in the client workspace.
movedFileFile Moved from filename
statusWorkStatus Working status
blobShaSHA1Blob SHA
repoKeyRepository name

db.workingx - Records for shelved open files

Indexed on: clientFile
NameTypeDescription
clientFileFile File on the client
depotFileFile File in the depot
clientDomain The client the file is opened on
userUser The user who has the file opened
haveRevRev Revision presently in user's client workspace
workRevRev Working revision; normally identical to the haveRev
isVirtualInt Flag: if 1, file was opened with "p4 integ -v".
typeFileType File type
actionAction What the user's doing with the file
changeChange Associated changelist, or zero for the default changelist.
modTimeDate Modification timestamp on the file in the user's workspace.
isLockedInt Flag: 0 for unlocked, 1 for locked.
digestDigest MD5 digest of working file.
sizeFileSize File size
traitLotTraitLot Group of traits associated with file revision.
tamperedTamperCheck Flag indicating the tamper-state of the file in the workspace.
clientTypeFileType Type of the file in the client workspace.
movedFileFile Moved from filename
statusWorkStatus Working status

pdb.lbr - Proxy server pending archive transfer table

Indexed on: file, rev
NameTypeDescription
fileFile The file name
revString The librarian revision
typeFileType The file type of the revision
statusPullStatus The status of the archive transfer
whoInt The process / thread id ID of the pull process
whenInt The timestamp from when the transfer was scheduled
actionAction The action that created the revision
digestDigest The MD5 digest of the revision
sizeFileSize The size of the file in bytes
retriesInt Error retry count
errmsgOctet String Last Error Message
changeChange The changelist that created the revision
dateDate Librarian date
modTimeDate Librarian modtime
originInt The revision type that this transfer originates from: 1 = db.rev 2 = db.revsh 3 = db.revsx 4 = db.revux 5 = db.object
targetText Edge server to transfer from (reverse replication only)

rdb.lbr - Replica server pending archive transfer table

Indexed on: file, rev
NameTypeDescription
fileFile The file name
revString The librarian revision
typeFileType The file type of the revision
statusPullStatus The status of the archive transfer
whoInt The process / thread id ID of the pull process
whenInt The timestamp from when the transfer was scheduled
actionAction The action that created the revision
digestDigest The MD5 digest of the revision
sizeFileSize The size of the file in bytes
retriesInt Error retry count
errmsgOctet String Last Error Message
changeChange The changelist that created the revision
dateDate Librarian date
modTimeDate Librarian modtime
originInt The revision type that this transfer originates from: 1 = db.rev 2 = db.revsh 3 = db.revsx 4 = db.revux 5 = db.object
targetText Edge server to transfer from (reverse replication only)

tiny.db - Records content data for tiny files using the +T file type modifier

Indexed on: key
NameTypeDescription
keyKey The file name and revision
valueOctet String The (encoded) file content

Datatypes

2FAState - Second Factor Authentication State

Second factor authentication scheme and status

Bits used to store second factor authentication scheme (Mask: 0xFF)

ValueExplanation
0x0001otp-generated; one-time password generated
0x0002otp-requested; one-time password requested
0x0003challenge; challenge/response
0x0004external; 3rd-party prompting

Bits used to store second factor authentication status (Mask: None)

ValueExplanation
0x0100authenticated; host is authenticated
0x0200persisted; 2FA persists for this host
0x0400forced; superuser skipped the checks
0x0800skipped; 2FA was not required
0x1000waiting; waiting on 2FA service
0x2000token-requested; OTP requested from 2FA service
0x4000required; 2FA required
0x8000rejected; external 2FA was rejected

Action - Type of action

Revisions are produced by user actions. The Action type defines the available actions and their internal values.

ValueExplanation
0add; user adds a file
1edit; user edits a file
2delete; user deletes a file
3branch; add via integration
4integ; edit via integration
5import; add via remote depot
6purge; purged revision, no longer available
7movefrom; move from another filename
8moveto; move to another filename
9archive; stored in archive depot

Change - A changelist number

The number of a changelist. The number 0 represents the default pending changelist.

ChangeStatus - The status of a change

A bit mask representing the status of a change

ValueExplanation
0x0001committed
0x0002shelved
0x0004restricted
0x0008hidden
0x0010elsewhere
0x0012promoted - elsewhere, shelved
0x0020unsubmitted
0x0040hasgraph

Counter - A counter name

A string representing the counter name. Counter names must contain no spaces, contain no slashes, and be identifiers (cannot begin with a dash and cannot be all-numeric)

Date - A unix-style date and time

A date and time represented as the number of seconds since the Epoch: 01 January 1970 00:00:00 UTC. This is the same convention as that used on Unix platforms.

DepotType - Type of Depot

The type of a given depot

ValueExplanation
0local depot
1remote depot
2spec depot
3stream depot
4archive depot
5unload depot
6tangent depot
7graph depot
8extension

DescShort - A short string value

The first 31 characters of a Text string
See also:Text

Digest - An MD5 digest

A string containing an MD5 digest.

Domain - A domain name

A string representing the name of a depot, label, client, branch, typemap, or stream.

DomainOpts - Options for domains

A integer value representing the options for a domain

Bits used to store client, label, and branch options (Mask: 0x10EF)

ValueExplanation
0x0001modtime
0x0002clobber
0x0004allwrite
0x0008locked
0x0020compress
0x0040rmdir
0x1000indirect (obsolete since 2004.2)
0x8000autoreload

Bits used to store client type and backup status (Mask: 0x190000)

ValueExplanation
0x00000client is writeable
0x10000client is readonly
0x20000client is nobackup
0x110000client is partitioned

Bits used to store client line termination settings (Mask: 0x0710)

ValueExplanation
0x0000local
0x0010unix (LF)
0x0200mac (CR)
0x0300win (CRLF)
0x0400share (LF/CRLF)

Bits used to store client submit options (Mask: 0x7000)

ValueExplanation
0x1000Revert unchanged files
0x2000Leave unchanged files
0x4000Submit, and re-open unchanged files

Bits used to store stream options (Mask: 0x000C)

ValueExplanation
0x0001allsubmit or ownersubmit
0x0002locked or unlocked
0x0004change flows to parent
0x0008change flows from parent
0x0010mergeany or mergedown

DomainType - A domain type

A integer value representing the type of a domain

ValueExplanation
67 (ASCII 'C')unloaded client
76 (ASCII 'L')unloaded label
83 (ASCII 'S')unloaded task stream
98 (ASCII 'b')branch
99 (ASCII 'c')client
100 (ASCII 'd')depot
108 (ASCII 'l')label
115 (ASCII 's')stream
116 (ASCII 't')typemap

DomainWild - A string with optional wildcards

A string that may contain wildcards - usually an IP address in the protections table.

File - A file name

A string representing the filename
See also:FileType

FileSize - A file size

A 64-bit integer used to store file sizes. The value -1 is used to represent unknown file sizes.

FileType - Type of file

The FileType is a bitmask specifying the type and modifiers of a revision from both the client and server points of view. The first 16 bits are used to store the storage type and modifiers, the next 16 bits are used to store the client access method and modifiers.

Bits used to store the server's storage type (Mask: 0x000F)

ValueExplanation
0x0000RCS
0x0001Binary
0x0002Tiny
0x0003Compressed
0x0004tempobj (deprecated since 2002.1)
0x0005 Detect type. Used internally when no type is given by the user.
0x0006 Compressed tempobj (deprecated since 2002.1)
0x0007 Binary access to compressed data. Used internally.
0x0008 Stored externally via librarian trigger

Bits used to store the modifiers to the server's storage type (Mask: 0x00F0)

ValueExplanation
0x001099.2-style keyword expansion/contraction
0x00202000.1-style keyword expansion/contraction
0x0030Any type of keyword expansion
0x0040Exclusive open
0x0080New tempobj (+S modifier)

Bits used to store the number of revisions to be stored for +Sn files. (Mask: 0x0F00)

ValueExplanation
0x0000+S1
0x0100+S2
0x0200+S3
0x0300+S4
0x0400+S5
0x0500+S6
0x0600+S7
0x0700+S8
0x0800+S9
0x0900+S10
0x0A00+S16
0x0B00+S32
0x0C00+S64
0x0D00+S128
0x0E00+S256
0x0F00+S512

Bits used to store the file type from the client's point of view. (Mask: 0x10D0000)

ValueExplanation
0x0000000text
0x0010000binary
0x0020000executable bit set
0x0040000symlink
0x0050000resource fork
0x0080000unicode
0x0090000raw text (nocrlf - 99.1)
0x00C0000apple data + resource file (since 2000.2)
0x00D0000apple data + resource file (99.2)
0x1000000Used to support filetype detection

Bits used to store the modifiers applied to the file on the client. (Mask: 0x720000)

ValueExplanation
0x0100000writable
0x0200000modtime
0x0400000uncompress on client

FixStatus - Status of a fixed job

This type is a wrapper around the 'Text' type that handles the pre-2000.1 "closed" default value.

GraphPermType - Type of Graph Permission

The type of a graph depot permission

ValueExplanation
0none
1read
2write-ref
4write-all
8create-repo
16delete-repo
32create-ref
64delete-ref
128force-push
256admin
4096restricted-ref

Int - A 32-bit integer

A 32-bit integer

Int64 - A 64-bit integer

A 64-bit integer.

Int8 - An 8-bit integer

An 8-bit integer: an unsigned char

IntegHow - Integration methods

Specifies how an integration was performed. Integrations always come in pairs: the 'forward' and 'reverse' records. As a general rule, the forward records contain the word 'from'; and the reverse records contain the word 'into'.

ValueExplanation
0merge from: integration with other changes
1merge into: reverse merge
2branch from: integration was branch of file
3branch into: reverse branch
4copy from: integration took source file whole
5copy into: reverse take
6ignored: integration ignored source changes
7ignored by: reverse copy
8delete from: integration of delete
9delete into: reverse delete
10 edit into: reverse of integration downgraded to edit
11 add into: reverse of branch downgraded to add
12edit from: merge that the user edited
13add from: branch downgraded to add
14moved from: reverse of renamed file
15moved into: file was renamed
16'delete' target rev ignoring non-deleted source
17non-deleted source ignored by 'delete' target rev
18'integrate' target rev ignoring deleted source
19deleted source ignored by 'integrate' target rev
20deleted branch: branch from
21deleted branch: delete into
22undo: opposite of merge
23undo reverse
24move undo: move + undo as one record
25move undo reverse
Note: All integration records should have a corresponding reverse record. The 'branch from' (2) and 'merge from' (0) records have corresponding "dirty" reverse records for cases where the target file took more than one change or was (re)opened for 'edit' or 'add'.

JobStat - Job status - defunct

Old (pre-98.2) job status values.

ValueExplanation
0open
1closed
2suspended

JournalCopyFlags - "Journal Copy State"

Used to maintain Journal Copy State

ValueExplanation
1Durable Only
2Non Acknowledging
4 Journal Wait

Key - A key name

A string representing the key name. Key names must contain no spaces, contain no slashes, and be identifiers (cannot begin with a dash and cannot be all-numeric)
See also:String

MapFlag - Types of mapping

Specifies how the files specified by a mapping should be treated

ValueExplanation
0mapped-in (the default)
1mapped-out (mappings that start with '-')
2overlay (mappings that start with '+')
3 haveMap (mappings that start with '$'). Used internally only
4 changeMap (mappings that start with '@')

Mapping - A string representing a mapping

A Mapping is essentially a file name that may contain wildcards

MaxLockTime - Maximum number of milliseconds to hold locks

The number of milliseconds for which a command may hold locks. Commands that take longer than this time period will abort. The value 0 means 'unlimited'.

MaxResults - Maximum number of results permitted

The number of results that commands run by the restricted user are permitted to return. The value 0 means 'unlimited'.

MaxScanRows - Maximum number of records scanned

The maximum number of records that the server may read on behalf of the restricted user. The value 0 means 'unlimited'.

ObjectType - Object type

Object type

ValueExplanation
0commit
1tree
2tag
3null

Octet String - Encoded hex string

A variable length encoded hex string. The first octet stores the length of the string.

Password - The MD5 hash of a password

The MD5 hash of an encrypted password.

Perm - Bitmask of permissions

A bitmask of granted permissions

Bits used to store granted permissions (Mask: 0x00FF)

ValueExplanation
0x0000none
0x0001Grants list access
0x0002Grants read access
0x0004Grants ability to branch/integ from
0x0008Grants open access
0x0010Grants write access
0x0020Grants review access
0x0080Grants admin access
0x0040Grants super-user access
0x0100Grants owner access

PullStatus - Archive pull transfer status

The status of an archive pull transfer

ValueExplanation
newnew transfer
activeactive transfer
donecompleted transfer
errorerrored transfer
restartrestarted transfer
cancelledcancelled transfer

RefAction - Reference action

A reference action

ValueExplanation
0create
1update
2force
3delete

RefType - A reference type

The type of reference

ValueExplanation
0Branch reference
1Remote reference
2Tag reference
3Workspace branch reference. Pseudo-reference, used by workspaces that access git files
4Workspace have reference. Pseudo-reference, used by workspaces that access git files
5Other reference

RemoteID - A remote name

A string representing the name of a remote spec

ResolvedStatus - Resolve methods (obsolete in 2011.1, replaced by ResolveState)

Specifies how the user resolved merge operations.

ValueExplanation
0Not yet resolved
1Resolved manually
2Resolved automatically as part of a branch
3Resolved automatically as part of a delete
4Resolved automatically as part of a move

ResolveState - Resolve actions

Pending or completed resolve actions.

ValueExplanation
0Content resolve
1Filetype resolve
2Branch resolve
3Delete resolve
4Move resolve
5Attribute resolve
6Charset resolve

Rev - A revision number

The positive integer number of a specific revision of a file. The number 0 represents '#none'.

Reviewer - Type of reviewer

The type of reviewer. Currently there is only one type of reviewer and 0 is the only valid value.

RevStatus - A revision status

Lazy copy, task stream promotion, and charset status

Bits used to store revision status (Mask: 0x00FFFFFF)

ValueExplanation
0x0000single revision with content
0x0001single revision lazy copied
0x0002revision task sparse
0x0004revision task branch

Bits used to store revision charset (high 8 bits). Values below have been shifted right 24 bits (Mask: 0x7F000000)

ValueExplanation
0NONE
1UTF_8
2ISO8859_1
3UTF_16
4SHIFTJIS
5EUCJP
6WIN_US_ANSI
7WIN_US_OEM
8MACOS_ROMAN
9ISO8859_15
10ISO8859_5
11KOI8_R
12WIN_CP_1251
13UTF_16_LE
14UTF_16_BE
15UTF_16_LE_BOM
16UTF_16_BE_BOM
17UTF_16_BOM
18UTF_8_BOM
19UTF_32
20UTF_32_LE
21UTF_32_BE
22UTF_32_LE_BOM
23UTF_32_BE_BOM
24UTF_32_BOM
25UTF_8_UNCHECKED
26UTF_8_UNCHECKED_BOM
27CP949
28CP936
29CP950
30CP850
31CP858

ScanState - The state of the scan

The state of the scan

ValueExplanation
0unset
1run
2paused
3paused
4done
5error
6busy

ServerOptionsType - Options for server definitions

Option Flags for server definitions.

The server options service type setting is generated by OR'ing the generic ServerOptionFlags defined below (Mask: None)

ValueExplanation
0x0001mandatory

ServerServiceType - The type of server service

The services offered by a type of service.

The server service type setting is generated by OR'ing the generic ServerServiceProperties defined below (Mask: None)

ValueExplanation
0x0903standard ( db-read | db-write | rmt-depot | rmt-journal )
0x0945replica ( db-read | db-replication | file-replication | rmt-depot | rmt-journal )
0x0030broker ( brokering | forwarding )
0x00A0proxy ( forwarding | file-cacheing )
0x09E5forwarding-replica ( db-read | db-replication | forwarding | file-replication | file-cacheing | rmt-depot | rmt-journal )
0x094Dbuild-server ( db-read | db-replication | bound-clients | file-replication | rmt-depot | rmt-journal )
0x0203P4AUTH ( db-read | db-write | rmt-auth )
0x0403P4CHANGE ( db-read | db-write | rmt-change )
0x19EDedge-server ( db-read | db-replication | bound-clients | forwarding | file-replication | file-cacheing | rmt-depot | rmt-journal | local-opens )
0x2F03commit-server ( db-read | db-write | rmt-depot | rmt-journal | rmt-change | rmt-auth | commit-server )
0x6F03depot-master ( db-read | db-write | rmt-depot | rmt-journal | rmt-change | rmt-auth | commit-server | p4zk-managed )
0xC945depot-standby ( db-read | db-replication | file-replication | rmt-depot | rmt-journal | journal-copy | p4zk-managed )
0x59EDworkspace-server ( db-read | db-replication | bound-clients | forwarding | file-replication | file-cacheing | rmt-depot | rmt-journal | local-opens | p4zk-managed )
0x8945standby ( db-read | db-replication | file-replication | rmt-depot | rmt-journal | journal-copy )
0x89E5forwarding-standby ( db-read | db-replication | forwarding | file-replication | file-cacheing | rmt-depot | rmt-journal | journal-copy )
0x4030workspace-router ( brokering | forwarding | p4zk-managed )
0x10003local ( db-read | db-write | dvcs-local )
0x20000cluster ( cluster-id )
0x40000zookeeper-server ( zookeeper-server )
0x80000hxca-server ( hxca-server )
0x100000git-connector

ServerServiceProperties: Bits used to identify generic server properties (Mask: None)

ValueExplanation
0x0001db-read
0x0002db-write
0x0004db-replication
0x0008bound-clients
0x0010brokering
0x0020forwarding
0x0040file-replication
0x0080file-cacheing
0x0100rmt-depot
0x0200rmt-auth
0x0400rmt-change
0x0800rmt-journal
0x1000local-opens
0x2000commit-server
0x4000p4zk-managed
0x8000journal-copy
0x10000dvcs-local
0x20000cluster-id
0x40000zookeeper
0x80000hxca
0x80000Git-Connector

ServerType - The type of server

The type of server

ValueExplanation
0server
1proxy
2broker
3identifier
4admin
5connector

SHA1 - Encoded SHA1

20 byte SHA1 digest of a block of text

SpecType - A spec type

A integer value representing the type of a spec

ValueExplanation
98 (ASCII 'b')branch
67 (ASCII 'C')change
99 (ASCII 'c')client
100 (ASCII 'd')depot
101 (ASCII 'e')spec
69 (ASCII 'E')extension
103 (ASCII 'g')group
106 (ASCII 'j')job
108 (ASCII 'l')label
68 (ASCII 'D')ldap
76 (ASCII 'L')license
112 (ASCII 'p')protect
114 (ASCII 'r')remote
82 (ASCII 'R')repo
83 (ASCII 'S')server
115 (ASCII 's')stream
84 (ASCII 'T')trigger
116 (ASCII 't')typemap
117 (ASCII 'u')user

StashType - Stash type

Stash type

ValueExplanation
0switch: A shelf with work-in-progress for a particular stream/branch
1tangent: Work-in-progress relocated by 'p4 fetch -t'. Consumed and removed by 'p4 resubmit'

StreamPathType - Type of stream path

The path type for file paths in a stream view.

ValueExplanation
0share
1isolate
2import
3exclude
4remapped
5ignored
6inclusive
7import+

StreamStatus - Stream integration status

The stream integration status.

Bits used to store the stream integration status (Mask: Copy: 0x0003, Merge: 0x000C)

ValueExplanation
0x0000Clear cache
0x0001Needs copy
0x0002Copy up-to-date
0x0004Needs merge
0x0008Merge up-to-date

StreamType - Type of stream

The type of stream.

ValueExplanation
0mainline
1release
2development
3virtual
4task
5task - unloaded

Strength - Strength check of a password

Whether or not a user's password has been tested for strength.

ValueExplanation
0Strength unknown
1Password is strong
2Unset

String - A string up to 1024 characters long

A string up to 1024 characters in length. Depending on the context in which the string is used, restrictions may apply. Strings are often used as key fields in the schema.
  • Cannot be empty
  • Cannot consist solely of a dash (-)
  • Cannot be all-numeric
  • Cannot contain non-printable characters
  • Spaces are replaced with underscores ( _ )
  • Revision characters (# and @) are prohibited
  • Slashes (/) are prohibited
  • Wildcards (... and *) are prohibited

SvrViewType - Server specification view type

Server specification view type

ValueExplanation
0Client Data Filter
1Revision Data Filter
2Archive Data Filter
3Authorized Addresses
4Repos that should be polled to keep their caches up-to-date

TamperCheck - Tamper-state of workspace file

Indicates the tamper-state of a file in a workspace. This is used to decide whether or not to check the file, and if checked, to hold the result.

ValueExplanation
0Do not check for tampering
1Check for tampering
2Tamper-check failed

Text - A string value

A text string value - used to hold longer blocks of text.

TraitLot - The id of a group of traits

An integer identifying a group of traits which may be shared by several revisions.

TraitType - A type of trait

The type of trait.

ValueExplanation
0Special trait for reference counting
1Binary trait
2Binary trait that gets propagated

Trigger - A type of trigger

The type of a trigger.

ValueExplanation
0change-submit (formerly pre-submit triggers)
1change-content
2change-commit
3form-in
4form-out
5form-save
6form-delete
7form-commit
8auth-check
9auth-check-sso
10auth-set
11fix-add
12fix-delete
13archive
14shelve-submit
15shelve-commit
16shelve-delete
17service-check
18edge-submit
19edge-content
20change-failed
21command
22push-submit
23push-content
24push-commit
25journal-rotate
26journal-rotate-lock
27graph-push-start
28graph-push-complete
29graph-push-reference
30graph-push-reference-complete
31graph-lfs-push
32graph-fork-repo
33pull-archive
34auth-pre-2fa
35auth-init-2fa
36auth-check-2fa
37bgtask
38auth-invalidate
39extension config
40pre-SSO session info
41new master failover
42extension --run

UpgradeState - Upgrade State

upgrade state

ValueExplanation
0upgrade needed
1upgrade pending
2upgrade running
3upgrade completed
4isolated upgrade success
5upgrade failed

User - A user or group name

The name of a Helix Server user or group.
See also:String

UserAuthType - User Authentication Type

The AuthMethod setting for the user.

ValueExplanation
0perforce
1ldap
16perforce+2fa
17ldap+2fa

UserLevel - User functionality level

User functionality level

ValueExplanation
0standard
1service
2operator

UserType - The role of a user within a group

The role of a user (or group) within a group.

Bits used to store the role of a user in a group (Mask: 0x0007)

ValueExplanation
0x0001User is an ordinary user
0x0002Group is a sub-group
0x0004User is the owner of a group

UserWild - A user or group name with wildcards

A user/group name that may contain wildcards (*)
See also:User

Value - A number or a string

A number, stored in a string, or a string

WorkStatus - Working table charset and status

Working State Flags and Charset

Working table status flags, WorkStatus Flags defined below (Mask: 0x00FFFFFF)

ValueExplanation
0x0001resolved merged ktext

Bits used to store working charset (high 8 bits). Values below have been shifted right 24 bits (Mask: 0x7F000000)

ValueExplanation
0NONE
1UTF_8
2ISO8859_1
3UTF_16
4SHIFTJIS
5EUCJP
6WIN_US_ANSI
7WIN_US_OEM
8MACOS_ROMAN
9ISO8859_15
10ISO8859_5
11KOI8_R
12WIN_CP_1251
13UTF_16_LE
14UTF_16_BE
15UTF_16_LE_BOM
16UTF_16_BE_BOM
17UTF_16_BOM
18UTF_8_BOM
19UTF_32
20UTF_32_LE
21UTF_32_BE
22UTF_32_LE_BOM
23UTF_32_BE_BOM
24UTF_32_BOM
25UTF_8_UNCHECKED
26UTF_8_UNCHECKED_BOM
27CP949
28CP936
29CP950
30CP850
31CP858
Copyright 1999-2015, Perforce Software. All rights reserved.