These were created while delving much deeper into learning the MySQL schema created during a default Drupal installation, and as part of current site and module troubleshooting and error reporting. These diagrams are based on a standard UML database schema icon, but currently do not include table-to-table UML relationship connectors, yet. I may add those at some unknown future date.

Located here . Very large full size poster size images can be downloaded and printed as part of development or as an introduction of the Drupal MySQL Schema to new users.

So far I have the following uploaded there for a Default 6.14 Installation:

All 45 tables created for the Core Drupal modules, no Core Optional modules selected, other than what is selected by default; i.e. Color.
All 46 tables created for the Core Drupal modules, with Update also selected.

To be uploaded soon...
A 21 tables view when all 25 Core Optional modules are selected.
A 'Total tables view' which combines all Core & Core Optional module tables created for a default install.

Cheers,

Varenne

Comments

Varenne’s picture

Varenne commented
Priority: Normal » Minor
Status: Active » Needs review

I'm changing priority to minor based on what seems to be a 'no interest' from the community, and status to needs review.

I'll leave it open for another month and then close it.

arianek’s picture

arianek commented

this looks really interesting actually. i'm not sure at all where the right place is for it - please leave the ticket open, we are focusing on D7 docs at the moment, so it may take a while before someone has time to properly review this and/or find a place for it.

Varenne’s picture

Varenne commented

Will do, but I am in the process of un-publishing what is my content on the www.charlotteregional.com web site as my term as their web master is nearing it's end. The links will work still for now, I am just no longer a member of STC. (They increased membership costs beyond what I felt was reasonable for what little value they provided to members.)

I will be needing a need a new home for this content after 2010 July when the hosted site payment runs out. I may simply move it to a new Drupal based site, not entirely sure yet so I will continue updating here as I work through those decisions.

Cheers,

Varenne

PS: Maybe MySQL Schemas for Drupal 7 are more inline with what will be needed for the community? If so I can work on those next.

leehunter’s picture

leehunter commented

They might fit nicely here: http://drupal.org/node/22754

It's a reference section on database tables

Varenne’s picture

Varenne commented

I agree and will add them asap.

figaro’s picture

figaro commented
Status: Needs review » Reviewed & tested by the community

Will need to set status to fixed as soon as this is done.

Varenne’s picture

Varenne commented
Assigned: Unassigned » Varenne
Status: Reviewed & tested by the community » Closed (fixed)

I'm marking status as closed even though I have not moved these to the suggested location. Seems maintaining status is more important than getting the actual work done. I don't have time at the moment, so if I get around to it fine, if not, oh well, users will just have to do what ever they did before.