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. |