README.txt
Версия 1.3 (checked in on 2006/12/23 at 15:35:51 by dries)
$Id
: README.txt,v 1.3 2006/06/20 17:38:14 hlslaughter Exp $
This folder contains some preliminary documentation for the Drupal database.
Please note that these files are NOT complete! This spot is for us to have a working place to centralize database documentation efforts. If you spot errors, or would like to help with the documentation effort, please contact hlslaughter or webchick.
- annotated_database.mysql: A copy of database.mysql from Drupal HEAD which contains comments describing where the PK and FK relationships are. The plan is to eventually extend this to also contain comments on what each table/field is for, and (possibly) have this file replace the existing database.mysql file in Drupal core so the schema is documented out of the box.
- annotated_database.4.1.mysql Similar to above, but based on 4.7 schema version and with a different style of documentation.
- data_dictionary.html: A complete data dictionary for Drupal core's database. At the moment, this contains only relationship info, but will eventually be expanded to show comments on what each field is for as well.
- database.xml (coming soon) An E-R diagram of the Drupal database in XML format (generated from DBDesigner).
- drupal_pma_relation.sql:
A dump of the pma_relation table from PHPMyAdmin, which establishes
the relations between the tables without the use for foreign keys.
Only required if you intend to make changes to the documentation of
relationships between tables (source database is called
'drupal_head'
).