Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By josvlaar on
Hello,
I want to setup multiple sites sharing some database tables configuring it this way (I understand the concept): http://drupal.org/node/221779#comment-735762
I basically want to know what all the database tables Drupal makes are meant for, so what data is stored in them so if it can/is worth to be shared across the sites. I can imagine people (including me) want to share a lot of things across the sites (users/profiles, excluded hosts/ip's/email adresses/usernames, feeds, blocks are some I can think of now), but I didn't find an overview anywhere on the internet of what database tables exactly correspond to them or what data eacht table holds (anyone did?).
If there is no nice list, let's make one over here with the tables worth sharing and why (what they exactly contain), or if anyone can document a list of all the tables and what they contain (so anyone can think for himself if they are worth sharing) that would also be nice.
Here are the tables needed to share users across all of the sites (or is there one missing/not needed?). I don't know what each one of them exactly stores (profile_fields and profile-values are easily guessed I think), anyone?
authmap
profile_fields
profile_values
role
sequences
sessions
users
users_roles
users_uid_seq (for pgsql only)
Thanks!
Josh
Comments
schema docs
The DB schema is now documented in core in Drupal 6 (and much of it is the same from 5.) You can look at the .install files in the core module folders in 6 or you can use the handy schema module.
Lullabot loves you | Be a Ninja, join the Drupal Dojo
Drupalize.Me, The best Drupal training, available all the time, anywhere!