Jump to >

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.