Database Management¶

The Database section of the Administration UI allows you to view and modify the actual contents of the Review Board database in a simple, human-readable fashion.

With the exception of the management tables, most tables are used for data storage only and should not be modified unless you know what you’re doing.

Warning

If not handled carefully, modifying entries in the database can lead to data loss or corruption.

Management Tables¶

The management tables are the areas of the database you’re most likely to modify in your installation.

Table	Description
Default reviewers	Default reviewers applied to review requests
Groups	User permission/authentication groups
Repositories	Source code repository configuration
Review groups	Target reviewer groups
Sites	Basic site information
Users	User account information

Data Storage Tables¶

As the name suggests, data storage tables contain data for such things as review requests, raw site settings, diffs, and so on. These should usually be left untouched, but there may be occasions when you’ll need to fix something for another user by modifying one of these tables.

The table below is grouped by the sections listed in the Database page in the Administration UI.

Table	Description
Accounts
Local site profiles	User profile and configuration specific to partitioned local sites.
Profiles	General site-wide user profile and configuration
Review request visits	Tracking of review request visits for user accounts.
Attachments
File attachments	File attachments associated with review requests.
Auth
Groups	User permission/authentication groups.
Users	User account information.
Changedescs
Change descriptions	Review request change description logging.
Diffviewer
Diff set histories	Groupings of revisioned diff sets, each owned by a review request.
Diff sets	A revisioned set of file diffs owned by a diff set history.
File diffs	Per-file diffs, along with the path and revision of the referenced files in the repository.
Django_Evolution
Evolutions	A history of database migrations applied. Do not modify this!
Versions	A history of database schemas. Do not modify this!
Reviews
Comments	Comments made on diffs.
Default reviewers	Default reviewers applied to review requests.
File attachment comments	Comments made on file attachments.
Review groups	Target reviewer groups.
Review request drafts	Drafts of review requests.
Review requests	All review requests, public and private.
Reviews	All reviews, public and private.
Screenshot comments	Comments made on screenshots.
Screenshots	All uploaded screenshots.
Scmtools
Tools	All registered SCMTools for talking to repositories.
Site
Local sites	Partitioned local sites.
Siteconfig
Site configurations	Stored configuration for the site. Do not modify this!
Sites
Sites	Basic site information.