Trac Database Schema: Version Control

Trac's version control system stores some mainly caching information in the database. (For the version control backends that support this.)

Table repository

Table	Key
repository	id, name

Columns	Type	Notes
id	int	ID of a version control repository (e.g. 1 or 2)
name		Name of a per-repository property
value		Value of that property

Stores (some cached and some configured) per-repository properties.

Trac itself uses a few such properties:

• name Admin-given name (configured in Admin panel)
• dir Just the repository directory (configured in Admin panel)
• alias Admin-given alias (configured in Admin panel)
• description Admin-given description (configured in Admin panel)
• repository_dir The repository directory (usually with a repository type prefix) of a cached repository
• youngest_rev The youngest revision number that is cached of a cached repository

See VcCache, trac.versioncontrol.cache​

Table revision

Table	Key
revision	repos, rev (40)

Columns	Type	Notes
repos	int	Repository id that this revision belongs to
rev		Revision number
time	int64	Commit time
author		Commit author
message		Commit message

Index

repos, time

Part of the version control cache. Stores cached revisions (i.e. changesets, commits).

See VcCache, trac.versioncontrol.cache​

Table node_change

Table	Key
node_change	id

Columns	Type	Notes
id	auto_increment	Added in Trac 1.1.4 (see #3676)
repos	int	Repository id that this revision belongs to
rev	key_size=40	Revision number that this change belongs to
path	key_size=255	Path of the affected file or directory
node_type	size=1	'F' for files, 'D' for directories
change_type	size=1	'A' for added, 'D' for deleted', 'M' for moved, 'C' for copied', 'E' for edited
base_path		The source path (or null)
base_rev		The previous revision affecting this path (or null)

Index

repos, rev, path

repos, path, rev

Part of the version control cache. Stores cached node changes of a revisions. A node change is a added, deleted, moved, copied or edited directory or file.

See VcCache, trac.versioncontrol.cache​