= The BOINC database =

BOINC stores information in a MySQL database. The main tables are:

 platform ::
	Compilation targets of the core client and/or applications.
 app::
	Applications. The core client is treated as an application; its name is 'core_client'.
 app_version::
	Versions of applications. Each record includes a URL for downloading the executable, and the MD5 checksum of the executable.
 user::
	Describes users, including their email address, name, web password, and authenticator.
 host::
	Describes hosts.
 workunit::
	Describes workunits. The input file descriptions are stored in an XML document in a blob field. Includes counts of the number of results linked to this workunit, and the numbers that have been sent, that have succeeded, and that have failed.
 result::
	Describes results. Includes a 'state' (whether the result has been dispatched). Stores a number of items relevant only after the result has been returned: CPU time, exit status, and validation status.

The database is created by the [MakeProject make_project] script. Normally you don't have to directly examine or manipulate the database. If you need to, you can use the MySQL command-line interpreter or BOINC's [HtmlOps administrative web interface].